13-week cash forecast template for Singapore founders

A forecast can show enough cash at month-end while leaving payroll unfunded a week earlier. The 13-week cash forecast template is designed to expose that timing gap. Its starting point is cash that the company can use, followed by receipts and payments in the weeks they are expected to clear.

A short-term cash forecast is a management model of expected bank movements. It differs from an income statement because recognition of a sale and collection of the related invoice can occur in different periods. The IFRS Foundation's IAS 7 overview, reviewed in 2026, distinguishes operating, investing and financing cash flows. Keeping those sources separate prevents a new borrowing from concealing cash consumed by trading.

The companion workbook contains editable assumptions, calculated weekly balances and an illustrative collection-delay scenario. Amounts are in Singapore dollars. The model supports a weekly liquidity decision; statutory reporting, a complete treasury assessment and insolvency questions require their own analysis.

What belongs in a 13-week cash forecast template?

Begin with accessible bank cash at the forecast start date. Reconcile the opening figure to the bank records and identify balances that cannot be used for ordinary payments. A deposit held as security should not quietly increase the amount management believes it can spend. Record facilities separately, including conditions that must be met before drawing them.

Receipts need an evidence hierarchy. An accepted invoice with a confirmed payment date supports a stronger assumption than a milestone still awaiting sign-off. An unsigned sales opportunity needs a further qualification. Record the evidence beside the expected date so the reader can distinguish a collection judgment from a commercial hope.

Build the payment schedule from obligations and intended decisions. Include payroll, suppliers, rent, taxes, debt payments and committed purchases. A payment that management can postpone by agreement differs from a contractual obligation that is already due. The forecast should make that distinction visible before anyone assumes a timing change is available.

Maintain enough detail to investigate a variance. A single receipts total can conceal a large overdue account. A single supplier total can conceal a payment that protects an essential service. The summary sheet should stay readable, while its supporting schedule identifies the transactions responsible for material changes.

One delayed receipt changes the funding decision

Revenue recognition does not tell the team when the customer will pay. The IFRS Foundation's IFRS 15 overview, reviewed in 2026, connects revenue to the transfer of promised goods or services. A forecast therefore needs an additional collection assumption even when the accounting treatment is settled.

Consider an illustrative business opening the week with S$120,000. It expects S$70,000 of receipts and S$95,000 of payments. Closing cash is S$95,000, calculated as opening cash plus receipts less payments. If S$30,000 of those receipts moves to the following week, closing cash falls to S$65,000. The revenue recorded for the period may be unchanged.

Suppose management has chosen an illustrative minimum cash level of S$80,000. The delayed receipt creates a S$15,000 shortfall against that management threshold. It does not automatically mean the business is insolvent or in breach of a covenant. Those questions require their own legal, contractual and financial analysis. The threshold is an internal decision aid.

Show the delayed receipt in its revised week as well as removing it from the original week. A scenario that deducts cash without moving the receipt forward models nonpayment, not delay. Both risks may matter, but combining them accidentally prevents management from seeing which assumption caused the funding need.

Preserve the forecast that management relied on

Freeze the forecast before the week begins. The following review should compare actual bank movements with that version. Updating the expected date after a receipt fails to arrive may improve the next forecast, but it cannot explain why management relied on the earlier date. Retain both versions and classify the difference before revising the model.

Sales or account owners should explain changes in customer collection dates. Operations should explain supplier and delivery commitments. Finance should reconcile the totals and identify whether a difference is timing, amount, omission or classification. Assigning all explanations to the person maintaining the spreadsheet leaves the source of uncertainty untouched.

Keep accounting and management models connected without making them identical. Singapore entities use the reporting requirements applicable to their circumstances, as described in ACRA's guide to accounting standards, reviewed in 2026. A weekly cash tool should reconcile to the relevant records while retaining the timing detail needed for a management decision.

The project scoping questions help define a wider intervention when the forecast exposes a recurring process problem. The meeting should produce specific actions. “Monitor collections” is difficult to follow up. “The account owner will confirm acceptance of the milestone invoice before the next payroll run” identifies the dependency and the person. Record the expected cash effect, due date and whether the action is confirmed or still under discussion.

The lowest cash point governs the response

A downside case needs a named event. Move a major receipt to the week supported by the revised collection evidence, or bring forward an essential payment. A blanket reduction in receipts can be useful as a stress assumption, but it does not identify which customer or decision creates the exposure. Management needs that distinction to choose a response.

Compare the lowest projected cash point and the week it occurs. A comfortable closing balance at the end of the forecast can conceal an earlier shortage. The forecast should also show whether the business recovers through normal receipts or only through a funding assumption that has not been agreed.

Extend the forecast by one week at every update so the horizon remains useful. Retain prior versions and the reasons for material changes. Over time, repeated timing errors reveal a process problem, such as late invoicing or uncertain customer acceptance, that needs work outside the spreadsheet.

Adapt the workbook for restricted cash, currencies, facilities and tax payments where they affect the decision. Then identify the lowest usable balance, the week in which it occurs and the transactions that account for it. The cash conversion analysis helps separate a temporary timing requirement from a recurring commercial problem. The forecast earns its place in the weekly review when it gives management time to act on that distinction.