A business can report a profit and still miss payroll if customer payments arrive after the bills are due. Cash-flow forecasting focuses on timing: what money is likely to reach the bank, what must leave it, and how much remains after each week. It is a planning tool, not a promise that every invoice will be paid on schedule.
Start with the bank balance available for operations. Keep restricted funds, sales tax or VAT collected for remittance, payroll deductions and other money owed to third parties clearly separated. A large account balance can give a misleading sense of safety when part of it already belongs to someone else.
The core formulas
Formula: Closing cash = opening cash + cash collected − cash paid
For a multiweek view, use each week's closing balance as the next week's opening balance. Add receipts on the expected collection date, not the invoice date. Add outflows when the cash is expected to leave, including payroll, supplier terms, rent, loan payments, insurance and tax due dates.
Expected collection estimate: invoice amount × estimated collection probability. This probability-weighted amount can help model a pipeline, but it should not replace a conservative timing schedule for essential bills. A 90% expectation is still not cash in the bank.
Worked example: four weeks
A business begins week one with $18,000 of unrestricted operating cash. Forecast receipts are $7,000, $3,000, $9,000 and $4,000 over the next four weeks. Expected cash outflows are $8,500, $6,500, $10,000 and $7,000. The closing balances are $16,500, $13,000, $12,000 and $9,000, respectively. The business remains above zero, but its lowest point is $9,000, so the owner can compare that trough with a chosen minimum reserve before committing to a new expense.
Do not treat that illustration as a universal cash buffer. A seasonal firm with large deposits, a shop with daily sales, and a contractor paid after project milestones face different timing risks. The useful output is the point in the calendar when available cash is lowest, plus the assumptions that could move that date or amount.
Decision table
| Situation | What it signals | Practical next step |
|---|---|---|
| Large invoice due before payroll | A single delayed payment may create a short-term gap even if the sale is profitable. | Confirm approval and payment date, then prepare a downside schedule without that receipt. |
| Supplier terms change | Cash leaves earlier than the previous forecast assumed. | Update the actual due dates and renegotiate terms before the gap becomes urgent. |
| Seasonal demand | Monthly averages can hide weeks with low collections and high fixed costs. | Forecast across the full slow season and name any planned draw on reserves. |
A weekly forecasting routine
Update the forecast on the same weekday. Match open invoices to an expected cash date based on payment history, mark confirmed receipts separately from uncertain ones, and record the next payroll, rent, supplier, financing and tax dates. Compare forecast with actual cash every week. A persistent forecast error is useful evidence that payment timing, collection assumptions or expense categories need adjustment.
- Start from reconciled, unrestricted cash rather than the accounting profit figure.
- Separate confirmed receipts from estimates and model a delayed-payment case.
- Enter unavoidable outflows on the dates they are due, including amounts set aside for tax or other restricted obligations.
- Set a minimum operating-cash threshold and agree in advance what action follows if the forecast falls below it.
- Review actual versus forecast weekly and document why material differences occurred.
Common mistakes to avoid
- Counting an invoice as cash on issue: the customer may pay later, dispute the amount or pay in instalments.
- Ignoring one-off outflows: annual insurance, equipment replacement and tax dates still affect the bank balance.
- Using one optimistic scenario: test a late receipt or an unexpected expense before assuming that a new commitment is affordable.
- Double-counting restricted money: funds reserved for payroll deductions or tax remittance are not free operating cash.
Related tools
- Invoice Maker for organising the amount and terms shown to a customer.
- Freelance Rate & Project Quote Calculator for checking whether quoted work accounts for costs and time.
- Percentage Calculator for testing collection rates, expense changes or reserve percentages.
Frequently asked questions
How far ahead should a small business forecast?
Use at least enough weeks to see the next important payroll, supplier and tax obligations, then extend the forecast through seasonal low points or large contractual commitments. Near-term weeks should use specific dates; farther-out estimates can use cautious ranges and should be refreshed as new information arrives.
Is cash flow the same as profit?
No. Profit is measured under accounting rules and can include sales not yet collected or expenses not yet paid. A cash forecast tracks expected money movement and is particularly sensitive to payment timing, loan principal, equipment purchases and funds held for future liabilities.
Editorial note: This guide is educational and uses illustrative figures. It is not personalised accounting, tax, lending or investment advice. Verify obligations and payment terms against current contracts and qualified local guidance.