A small business rarely fails because it isn't profitable on paper. It fails because the cash ran out in a month nobody looked at.
A small business cash flow forecast lists expected cash in and cash out by month, usually for twelve months. Start with the bank balance, add customer receipts and other income, subtract supplier payments, wages, rent, tax, loan repayments and owner drawings, and carry the closing balance forward. Base receipts on when customers actually pay, not when you invoice, and update it monthly with actuals.
Put months across the columns and cash lines down the rows. Keep it to cash: no depreciation, no accruals, nothing that doesn't move money in the bank.
| Row | Line | Where the number comes from |
|---|---|---|
| 3 | Opening cash | Bank balance for month 1, then last month's closing cash |
| 5 | Customer receipts | Sales forecast shifted by how long customers take to pay |
| 6 | Cash sales | Card and cash takings, received in the month |
| 7 | Other receipts | Grants, loans received, asset sales, tax refunds |
| 8 | Total receipts | Sum of rows 5 to 7 |
| 10 | Supplier payments | Purchases shifted by your payment terms |
| 11 | Wages and payroll taxes | Payroll calendar |
| 12 | Rent and utilities | Contracts and standing orders |
| 13 | Software, insurance and other overheads | Subscriptions and renewal dates |
| 14 | VAT or sales tax and other taxes | Your tax calendar |
| 15 | Loan and lease repayments | Facility and lease agreements |
| 16 | Equipment and other one-off spending | Planned purchases |
| 17 | Owner drawings or dividends | Your plan |
| 18 | Total payments | Sum of rows 10 to 17 |
| 20 | Net cash flow | Total receipts less total payments |
| 21 | Closing cash | Opening cash plus net cash flow |
| 22 | Minimum cash buffer | Your own policy |
With month 1 in column B:
B8: =SUM(B5:B7)
B18: =SUM(B10:B17)
B20: =B8-B18
B21: =B3+B20
C3: =B21
Copy C3 across so each month opens with the previous month's closing cash. Add a warning row that flags any month where closing cash falls below the buffer:
=IF(B21<B22,"BELOW BUFFER","")
See how to set a minimum cash buffer if you haven't decided on one.
Invoicing in March doesn't mean cash in March. Look at the last few months and work out what share of each month's credit sales is collected in the same month, the next month and the month after. Put those shares in input cells, for example D30, D31 and D32, and keep the credit sales forecast on row 25. Customer receipts for a month are then:
=D25*$D$30+C25*$D$31+B25*$D$32
where D25 is this month's credit sales, C25 last month's and B25 the month before. The three shares should add up to 100% less whatever you expect never to collect. Check the shares against your aged debtors report every quarter.
The months that catch small businesses out are the ones with a payment that only happens once or twice a year: annual insurance, software renewals, tax bills, a quarterly rent payment, a bonus. Go through last year's bank statements and list every payment that wasn't monthly, then put each one in the month it will fall.
The comparison step is what makes the forecast better over time; the method is in cash flow forecast variance analysis. When cash is tight, move to weekly columns with a 13-week cash flow forecast.
UK small businesses usually show VAT payments to HMRC and PAYE as separate rows; US businesses show sales tax remittances and payroll taxes. Payment dates and frequencies depend on your registration and size, so take them from your own tax calendar and check current HMRC or IRS and state rules rather than assuming.
AI software that turns a bank statement into a cash flow dashboard on your own computer: balance day by day, money in and out, recurring payments and a 13-week forecast. $1,997 once-off; see it on the built-in example first.
The Cash Flow Forecasting & Liquidity Control System tests every week of a rolling cash forecast against your minimum cash buffer and lending covenants, and flags a breach before it lands. Excel, no macros, one-time price.
Twelve months by month is a good default. If cash is tight, add a weekly forecast for the next 13 weeks as well.
Yes. Receipts and payments are in cash including tax, and the tax you pay over is a cash outflow, so include all three to see the real bank position.
A budget plans income and costs for the year on an accounting basis. A cash flow forecast shows when money actually arrives and leaves the bank.
Last updated 08 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.