Build a cash forecast that catches timing gaps

Decide what the forecast needs to reveal

A month can end with enough cash even though a payment due earlier in the month cannot be covered. That is why timing belongs at the centre of a cash forecast. Choose intervals that expose the decisions ahead: a weekly view for near-term commitments, with a monthly view further out if it helps the team plan.

Start from the reconciled bank position on a stated date. Identify any money unavailable for ordinary payments separately. Keep the calculation visible: opening cash, plus receipts, less payments, equals closing cash. Each period's closing position becomes the next period's opening position.

Give each expected receipt a defensible date

An invoice date is not a collection date. Review outstanding customer balances and use the latest evidence about when payment is expected. Check contractual terms, unresolved queries and what the collection owner has learned. Record uncertain sales opportunities separately from existing receivables so the forecast does not quietly depend on unsigned work.

When evidence is weak, make the uncertainty visible. Keep the current expectation and a plausible later receipt date available for review. The question is not whether a spreadsheet looks balanced; it is whether the team understands which receipts that balance depends on.

Check commitments outside the usual monthly expenses

Build payment estimates from obligations and operating plans. Alongside payroll, rent and suppliers, review annual renewals, equipment purchases, debt repayments and other infrequent commitments. A cost may appear gradually in an accounting report while the cash payment falls on a single date.

Use the expected payment date and identify the person who can confirm it. A supplier obligation should not be moved to a later week merely to improve the closing balance. If timing might change, show that as an option requiring agreement rather than an established fact.

Use a short exception list in the cash meeting

The following working template is illustrative. It helps a team focus its review without adding fictional financial results.

Receipt to confirm

source, supporting evidence, expected date and collection owner.

Commitment to verify

purpose, due date, approval status and payment owner.

Period needing attention

the dependency creating pressure and the latest date for a decision.

Agreed response

action, authorised owner, deadline and what will be checked at the next review.

Replace estimates with actuals, then investigate

As each period closes, record actual cash movements and compare them with the previous forecast. Separate a receipt that arrived late from revenue that will not arrive at all. Investigate significant differences before carrying the same assumption into the next version.

Refresh the remaining periods, extend the horizon and keep the previous version. Test whether the near-term position still works if an important receipt moves later. Finish the review with decisions and owners. A forecast becomes useful through this repeated exchange between records, operating knowledge and management action.