Business
Small business cash flow forecast: the version you will maintain
Most small business forecasts are built once for a bank and never opened again. A useful one is smaller, dated, and updated weekly — and it takes about an hour to build the first time.
- Date receivables honestly
Use each customer's actual average payment days, not your stated terms.
- Payroll and tax are non-negotiable
Put them in first; everything else flexes around them.
- Watch the trough, not the total
A quarter that nets positive can still fail in week six.
- Keep tax separate
Sales tax and VAT collected are not your money; show them leaving on their due date.
Rows to include
- Cash in: customer payments by invoice with realistic dates, deposits, grants, loan drawdowns, owner injections.
- Cash out: payroll and employer contributions, rent, utilities, software, insurance, supplier payments.
- Tax: VAT or sales tax remittance, corporation or income tax instalments, payroll taxes.
- Financing: loan repayments, interest, lease payments.
- Owner: draws or dividends, which people routinely leave out and then wonder where the cash went.
Building it in five steps
- Enter your true opening bank balance across operating accounts.
- Add every fixed outflow on its actual date as a recurring item.
- Add each open invoice on the date that customer usually pays, not the due date.
- Add tax remittances and payroll runs for the next two quarters.
- Read the lowest projected balance and decide what to move before it arrives.
The mistakes that kill small business forecasts
| Mistake | Fix |
|---|---|
| Using invoice due dates | Use each customer's historical average payment days |
| Forgetting VAT or sales tax | Show it as a dated outflow the moment it is collected |
| Omitting owner draws | Treat them as a fixed monthly outflow |
| Averaging seasonal revenue | Model each month at its real level |
| Building it once | Roll it weekly — a stale forecast is worse than none |
Frequently asked questions
How do I create a cash flow forecast for a small business?
Start from your real bank balance, add fixed outflows and payroll on their dates, add each invoice on the date the customer usually pays, include tax remittances, then read the lowest projected balance.
How far ahead should a small business forecast?
Thirteen weeks in detail, with a lighter twelve-month view for annual tax and insurance.
Should I use invoice due dates or expected payment dates?
Expected payment dates based on each customer's history. Using due dates is the single most common cause of an over-optimistic forecast.
Do I need accounting software?
Not for a forecast. Accounting software records the past; a dated calendar with a carried balance is enough to project forward.
A forecast small enough to keep current
Recurring items project forward automatically. Free forever.