Cash flow forecasting for small companies

A cash flow forecast estimates when money will enter and leave the business. It is different from a profit forecast because timing, loans, asset purchases and tax payments affect cash differently. Start with the actual opening bank position and a period suitable for the decisions being made.

Use realistic customer collection dates and committed payments, not only invoice dates. Separate confirmed amounts from assumptions. Test delays, lower sales or unexpected costs and identify the point at which the company may need action or professional advice.

Choose a horizon that supports the decision

Start with the actual available cash and the dates on which obligations must be met. A short weekly forecast can expose an immediate pressure that a monthly total hides, while a longer view helps plan seasonal needs and investment. The British Business Bank describes cash forecasting as predicting movements over a chosen period. ^[1] Select the detail needed for decisions rather than producing a complicated model without a clear user.

Separate bank balances from unused borrowing facilities and restricted funds. Record whether finance is committed, conditional or only being discussed. Do not include an expected loan as available cash before the relevant conditions are understood. Keep the opening position reconcilable to evidence so later differences are not blamed on trading when the model began from an inaccurate balance.

Forecast receipts by realistic collection timing

List amounts already invoiced, expected sales and other receipts separately. Use customer payment behaviour and agreed terms, not only invoice dates. A signed order may still require delivery, acceptance and credit before cash arrives. Identify disputed or overdue debts and avoid assuming they will all be collected next week merely to make the forecast balance positive.

Model sales assumptions explicitly. Distinguish confirmed orders from pipeline estimates and record the conversion or timing assumption. For subscription or retail businesses, consider refunds, chargebacks and platform settlement delays. The guide to Reconciling online payment platforms helps with payment-platform cash that differs from gross sales. Review concentration where one customer's delayed payment could materially change the company's ability to meet obligations.

Include outflows that profit reports do not show

Schedule payroll, suppliers, tax, debt repayments, asset purchases and owner payments using the expected cash dates. Avoid double counting purchases through both invoices and bank payments. Separate recurring commitments from discretionary spending and one-off projects. A capital purchase or loan principal repayment can consume cash without appearing as an ordinary expense in the profit and loss report.

Check Corporation Tax payment timing separately from return filing and use the relevant HMRC rules for the company's circumstances. ^[2] Include VAT and payroll obligations where applicable using the actual reporting cycles. Do not assume every tax payment follows the same annual date. Ask the accountant to identify uncertain amounts early enough for funds planning rather than adding them after the cash has been committed elsewhere.

Test scenarios and define actions

Create a base case and a small number of meaningful downside cases, such as delayed collections or lower sales. Change the underlying assumptions rather than manually editing the closing balance. Identify the earliest date action may be needed and the realistic options available. A forecast is useful when it provides time to improve collections, renegotiate commitments or assess funding before pressure becomes urgent.

Compare actual cash with forecast regularly and explain the difference. Separate timing changes from permanent changes in performance. Carry revised assumptions forward instead of simply replacing last week's number. Use Director responsibilities when a business struggles if the forecast raises concerns about meeting obligations, and obtain timely specialist advice rather than treating an optimistic scenario as proof that financial distress has been resolved.

For Management accounts support, provide bank evidence, debtor and creditor schedules and the business's main assumptions. Agree who updates the forecast and who decides actions when thresholds are reached. Keep a short commentary explaining uncertainty and the next decisions. The model should remain understandable to the people running the company, with formulas and sources clear enough that another authorised person can update it when the usual preparer is unavailable.

Compare last month's forecast with actual cash

Separate forecast errors caused by timing from those caused by a change in the underlying business. A customer who paid a week late may explain a temporary shortfall; a cancelled order changes the expected receipts altogether. Record which assumption failed and whether the next forecast needs a revised amount, date or probability.

Use the comparison to improve the model's most significant drivers instead of adding detail to every minor payment. If supplier timing repeatedly differs from the forecast, speak to the person scheduling payments. If sales receipts are consistently optimistic, review customer-specific collection evidence. A short explanation of the largest differences is more useful to directors than a highly detailed forecast that repeats the same unsupported assumptions each month.

Illustrative scenario

A profitable wholesaler buys stock before its busiest season and receives customer payments later. The forecast shows a temporary funding gap that the annual profit estimate hides. Directors review purchasing, collections and funding options early, then update the forecast as actual receipts and supplier commitments become known.

Preparation checklist

• Start from reconciled cash and known facilities.
• List receipts and payments by expected date.
• Include tax, payroll, borrowing and capital spending.
• Compare actual movements with forecast and revise assumptions.