Free Cash Flow Forecast Template for Excel
A cash flow forecast template is an Excel sheet that estimates the money moving in and out of your bank each month and the balance left at the end. This one is free, covers twelve months and flags any month that falls below your cash buffer.
Download the free template Arrange a free call
Free · Excel (.xlsx) · Works in Google Sheets · Includes a filled-in example
What is a cash flow forecast?
A cash flow forecast is a month-by-month estimate of the cash coming into and going out of your bank account. Its last line is the balance left at each month-end.
It is the statement that tells you when you will run short. A business can be profitable on paper and still miss payroll, which is why lenders read this page closely.
What is the difference between a cash flow forecast and a cash flow statement?
A cash flow forecast estimates future cash, while a statement of cash flows reports past cash. The formal statement of cash flows is one of the three accounting statements. It groups cash into operating, investing and financing activities and is often built by adjusting net income, which is called the indirect method.
This template is a forecast, not that formal statement. It lists receipts and payments directly, the way your bank statement does. That makes it easier to build and easier to check. If a lender asks for a “cash flow statement” for a business with no history, a forecast like this is usually what they mean, but ask which they want.
What is in this cash flow forecast template?
The file has three sheets: How to use, Cash flow and Example. The Cash flow sheet runs twelve months plus a Year column.
| Section | Rows | What it does |
|---|---|---|
| Opening cash | Month 1 is typed in; later months link from the prior closing | Starts each month from the right balance |
| Cash coming in | Cash sales, customer invoices collected, loan money received, owner or investor money, other | Money landing in the bank |
| Cash going out | Supplier payments, wages, rent, utilities, marketing, insurance, software, accounting and legal, loan repayments, tax payments, equipment, owner draws, other | Money leaving the bank |
| Net cash flow | Cash in minus cash out | The month’s movement |
| Closing cash | Opening plus net cash flow | The balance at month-end |
| Buffer check | Minimum cash buffer cell, red flag, lowest closing cash | Shows the tightest month of the year |
The Example sheet is a made-up café. A loan funds its fit-out, and its cash dips below the $5,000 buffer in months 1 to 3 before recovering. The figures are invented for illustration.
How do you fill in a cash flow forecast template?
You enter cash in the month it moves, not the month you earn or owe it.
- Type your business name, the month your year starts and your minimum cash buffer.
- Enter the bank balance on day one as opening cash for month 1.
- Enter cash coming in when it lands. A sale invoiced in March and paid in May goes in May.
- Enter cash going out when it leaves. Include loan repayments, tax and equipment.
- Read closing cash. A red cell means that month ends below your buffer.
- Each month, swap in actual figures and roll the forecast forward.
Not sure what to include on day one? The startup costs worksheet lists the one-off spending that hits month 1.
What does a lender or investor check on a cash flow forecast?
They check whether you can pay your bills and your loan from the cash you expect to have. They also check whether your timing assumptions are realistic.
- How long do customers really take to pay?
- What happens to cash if sales come in lower than planned?
- Are loan repayments and tax included, since they are not in the P&L?
- Does the forecast show the funding gap honestly, or hide it?
A forecast that shows a tight month and a plan to cover it reads better than one that never dips. Our guide to what SBA lenders look for in a business plan explains how this fits with the rest of the package.
How does the cash flow forecast link to the P&L and balance sheet?
The forecast turns profit into cash, and its closing balance becomes the cash line on the balance sheet. Sales and costs start on the profit and loss statement. The forecast then moves them to the months money actually changes hands and adds what the P&L leaves out, such as loans, tax payments and equipment.
Closing cash each month should match cash and bank balances on the balance sheet. See the hub for how the three fit together.
What are the common mistakes on a cash flow forecast?
The mistakes are nearly all about timing and optimism.
- Using the invoice date. Cash moves when the customer pays, not when you bill.
- Forgetting repayments. Principal repayments are cash out but not a P&L expense.
- Leaving out tax. Sales tax and income tax come due in lumps.
- Setting no buffer. Zero is not a safety margin.
- Never updating it. A forecast that is not rolled forward each month stops being useful.
What do we think about the cash flow forecast?
We think it is the statement owners should build first and update most often. Profit is an opinion about the year. Cash is a fact about this Tuesday.
We would also rather see a forecast with a bad month in it. The honest dip, with a stated way to cover it, is what a careful reader trusts. A smooth line that never touches the buffer makes us suspect the timing assumptions.
For a five-year version with all three statements linked, use a financial model template. To place the numbers in a plan, see our business plan template and financial forecasts, or browse the resources hub.
Want to talk it through?
Arrange a free 30-minute call with BusinessPlanHub. Bring your plan, your forecast or the question you are stuck on.
Arrange a call →Cash flow forecast template: common questions
What is the difference between a cash flow forecast and a cash flow statement?
A forecast looks ahead and estimates future bank movements. A statement of cash flows reports what already happened, split into operating, investing and financing activity. This file is a forecast.
Why does the template use the direct method?
The direct method lists actual cash received and paid, so you can check each line against a bank statement. It is the easiest layout for owners to follow.
What should I set as my minimum cash buffer?
It is your call. Many owners choose a balance that covers a month or more of fixed costs. The template simply flags any month below the figure you set.
Can a profitable business run out of cash?
Yes. Customers pay late, stock is bought ahead and loans are repaid from cash, not profit. That is why the forecast exists.
Are the Example sheet figures benchmarks?
No. The Example sheet is a made-up café with invented figures, shown so you can see a filled-in forecast.