Cash Flow Forecast Template: What to Include and Why

A cash flow forecast template is not a complicated document. It is a structured list of money coming in, money going out, and the balance left after each period. That structure is what makes it useful — and what most founders get wrong when they build one from scratch.

This article covers what a cash flow forecast template needs to contain, why each section exists, and where the gaps typically appear that make a forecast unreliable.

What a cash flow forecast template actually is#

A forecast is not a record of what happened. It is a projection of what will happen to your cash, period by period, based on what you know today.

The template is the skeleton. It defines which rows you track, how they are grouped, and how the closing balance for one period becomes the opening balance for the next. Get the structure right and the numbers follow. Get it wrong and the model breaks the moment anything changes.

The key distinction: a cash flow forecast is not the same as a P&L. Revenue on a P&L is recognised when earned. Cash arrives when a customer pays. Those two dates are often different, and the gap between them is where businesses run into trouble.

The three sections every template must have#

Every cash flow forecast template — regardless of how simple or detailed — has the same three sections.

Opening balance#

This is the cash you start with at the beginning of the period. For the first period, it is your actual bank balance. For every subsequent period, it is the closing balance from the period before. This single figure anchors the entire model. If it is wrong, every period that follows is wrong.

Cash receipts#

This section captures every source of money coming into the business. For most early-stage companies that means: revenue from customers. Loan drawdowns. Investment proceeds. Any other cash inflow.

The critical discipline here is timing. You record receipts when the cash actually lands in your account, not when you invoice. If you sell on 30-day payment terms, a sale made in October shows as a receipt in November. That lag is not a rounding error. It is the difference between knowing you have a problem and finding out when the account is empty.

Cash payments#

This section captures every outgoing payment. Payroll. Rent. Software subscriptions. Supplier invoices. Tax. Loan repayments. VAT. Everything.

Most founders undercount this section on the first pass. They include the obvious costs and forget the irregular ones: the annual insurance renewal, the quarterly tax payment, the one-off legal fee. A good template forces you to think in categories so nothing slips through.

Closing balance#

This is not a separate section so much as the output of the other three. Opening balance, plus receipts, minus payments, equals closing balance. That single number, for each period, is the most important figure in the forecast. It tells you whether you have a problem.

How to structure the rows#

The rows within each section should reflect how your business actually works, not a generic accounting chart of accounts.

For receipts, group by revenue stream if you have more than one. A SaaS business might separate new subscription revenue, expansion revenue, and one-off professional services fees. A product business might separate direct sales and wholesale. Grouping matters because different streams have different timing and different risk profiles.

For payments, group by type. Fixed costs are payments that do not change month to month: rent, salaries, software licences. Variable costs move with activity: cost of goods sold, sales commissions, payment processing fees. Irregular costs sit outside both categories: the VAT bill, the annual filing fee, a planned equipment purchase. Keep them separate or your forecast will smooth over the months when cash is genuinely tight.

The horizon question#

Most templates are built for one of two horizons, and they serve different purposes.

A 13-week forecast is the operational tool. It is short enough to be accurate, detailed enough to manage week by week. It is what a founder uses to decide whether to delay a hire, chase a late invoice, or draw on a credit line. If you want to understand the mechanics of building one, how to build a 13-week cash flow forecast covers the construction in detail.

A 12-month forecast is the planning and fundraising tool. Investors want to see it. It shows runway, the point at which cash runs out if nothing changes, and the assumptions behind your growth. It is less precise than a 13-week model but far more useful for strategic decisions.

The template structure is the same for both. The difference is granularity: weekly periods for the short-term model, monthly periods for the annual one.

Direct vs indirect method#

A cash flow forecast template can be built two ways. The direct method lists actual cash receipts and payments. The indirect method starts from profit and adjusts for non-cash items and working capital movements to arrive at cash.

For a founder building a forward-looking forecast, the direct method is almost always the right choice. It is concrete. Every line is a real payment somebody could point at, which makes it easy to check, easy to explain, and easy to act on. The indirect method is better suited to reporting on what already happened, not projecting what will. If you want a fuller comparison, direct vs indirect cash flow forecasting sets out the trade-offs clearly.

What most templates miss#

The rows are the easy part. The harder part is the assumptions that drive them.

A template with no documented assumptions is just a table of numbers. When something changes — a customer pays late, a hire is delayed, a cost comes in higher than expected — you need to know which input to update and what the downstream effect will be. Templates that do not separate inputs from outputs force you to edit cells manually and break the moment you change a figure.

The other common gap is the receipts timing adjustment. Most founders build a template where revenue and receipts are the same number in the same period. That works only if every customer pays on the day they buy. For anyone selling on invoice terms, or with a sales cycle, the timing mismatch is real and the template needs to account for it explicitly.

Building from scratch vs starting from a model#

If you have no accounting system and no historical data, a blank template is still a valid starting point. You are forecasting from assumptions, not from actuals, and that is fine. Pre-revenue founders do this all the time. The inputs are your pricing, your expected sales volume, your headcount plan, your cost structure. The template converts those inputs into a cash picture.

The limitation of a spreadsheet template is that it requires you to wire the logic yourself. When headcount changes, you update payroll manually. When a new revenue stream is added, you rebuild the receipts section. For a simple, stable business that is manageable. For anything with multiple products, payment terms, or financing lines, the maintenance burden becomes the problem.

Tools that build the financial model from your business inputs directly — rather than requiring you to import accounting data — are worth considering if the spreadsheet is breaking every time something changes. Forecasting cash flow without accounting data covers that approach in detail.

bluprnts works this way. You enter your products and pricing, headcount, costs, and financing lines, and the tool derives the full cash flow statement, P&L, and balance sheet automatically. No accounting integration required. If you are building a forecast for an investor meeting and do not have a bookkeeper or CFO, it is worth seeing what the model produces before you spend a weekend in a spreadsheet. You can start free at bluprnts.ai with no credit card required.

What a template cannot do#

A cash flow forecast template does not make your assumptions accurate. It makes them visible. If you forecast 50 new customers in month three and you get 12, the template will show you the cash impact of that miss. It will not prevent it.

The forecast is only as good as the thinking behind the inputs. The template is the structure that forces that thinking to happen in a disciplined way, period by period, rather than as a vague sense that things will probably work out.

That is why the rows matter. Not because a tidy spreadsheet impresses anyone, but because building one forces you to make specific claims about your business that you can then test against reality.

Frequently asked questions#

What should a cash flow forecast template include?

Every template needs an opening cash balance, a section for cash receipts grouped by source, a section for cash payments grouped by type, and a closing balance that carries forward to the next period. The closing balance is the output that matters most.

How many months should a cash flow forecast cover?

A 13-week (three-month) forecast is the standard operational tool for managing near-term cash. A 12-month forecast is what investors and lenders typically want to see. Most businesses benefit from maintaining both.

What is the difference between a cash flow forecast and a P&L?

A P&L records revenue when it is earned and costs when they are incurred. A cash flow forecast records money when it physically moves. A sale invoiced in September but paid in November appears in September on a P&L and in November on a cash flow forecast. That timing difference is the reason the two statements rarely show the same figures.

Do I need accounting software to build a cash flow forecast?

No. A forecast is built from assumptions about the future, not records of the past. You need to know your pricing, your expected sales volume, your headcount plan, and your cost structure. None of that requires a bookkeeping system. You can build a cash flow forecast from a blank template or a purpose-built tool.

What is the most common mistake in a cash flow forecast template?

Treating revenue and receipts as the same number in the same period. If you sell on payment terms, the cash arrives later than the sale. Ignoring that lag makes the forecast look healthier than it is and hides the months where you are actually tight.

What is the difference between the direct and indirect method in a cash flow forecast?

The direct method lists actual receipts and payments. The indirect method starts from net profit and adjusts for non-cash items to arrive at cash. For forward-looking forecasts, the direct method is more useful because every line represents a real transaction you can verify and update.

Can I use a cash flow forecast template to raise investment?

Yes, but investors typically want more than just the cash flow statement. They want to see the P&L and balance sheet alongside it, plus the assumptions behind the numbers. A template that only covers cash receipts and payments will not be enough on its own for a fundraising data room.