A cash forecast is neither a wish list nor a copy of the income statement. It is a timeline connecting opening cash with expected receipts and payments, showing when a shortfall may require action before it arrives.
One week can reveal what a month hides
Opening cash of SAR 40,000, probable receipts of SAR 30,000 and payments of SAR 85,000 create a SAR 15,000 gap before week end. The action may be a specific collection or an approved payment reschedule, not simply waiting for the balance.
What if the largest customer pays late?
Start a week with SAR 40,000, forecast receipts of SAR 25,000 and payments of SAR 50,000. Expected closing cash is SAR 15,000. If a SAR 20,000 receipt slips into the following week, the balance becomes negative SAR 5,000. This is a timing shortfall requiring action before payment day, not an accounting loss.
Put the basis beside each expected receipt: an overdue invoice, a customer's transfer confirmation or an estimate of cash sales. These do not carry equal confidence. Showing confirmed and probable receipts separately can be more informative than a single precise-looking total combining firm obligations with hoped-for sales.
For payments, separate contractual due dates from planned payment dates. Moving a cell into a later week does not mean the supplier agreed to an extension. Include payroll and recurring obligations at their expected dates, together with approved purchases and exceptional expenditure not yet invoiced. The schedule should anticipate events rather than merely reproduce accounts payable.
Each week, compare forecast and actual cash and explain material differences. Consistently low receipts may reveal optimistic assumptions or weak collection follow-up. Repeated unexpected payments suggest purchasing commitments are reaching finance too late. A forecast improves when it learns from these differences, not when more coloured weeks are added to the spreadsheet.
Three versions of the same week
Instead of forecasting to the last halala, test the timing of three large items. Use likely collection dates in the base case, delay the largest receipt a week in a cautious case, and add a possible urgent purchase in a stress test. Keep the scenarios distinct and show their effect on the lowest cash balance.
Connect a shortfall with an action and deadline: early customer follow-up, a documented supplier agreement or approved financing. Treating an unapproved facility as available cash hides the problem. Also inspect the balance within the week when major payments occur before forecast receipts.
Inputs for receipts and payments
- Confirm opening balances that are available to use.
- List collections by invoice, date and confidence.
- Schedule payroll, suppliers, taxes and other commitments.
- Calculate weekly closing cash and record an action at every critical threshold.
A forecast balance is not a promise
Forecast accuracy improves when confirmed and probable amounts are separated, realistic collection and payment dates are used, and uncertain sales or finance are not treated as cash already available. Base and downside scenarios show decision sensitivity.
Sources & further reading
Visit the original source to explore the concept and its wider context.
General educational content. Appropriate treatment depends on your business and accounting policies; consult your accounting professional when applying it to business records.
