A Simple Cash Flow Forecast Template You Will Actually Use

Every guide tells you to «forecast your cash flow». Almost none shows you the actual spreadsheet. This article does. In one hour you will have a working 13-week forecast; in twenty minutes a week you will keep it alive — and you will never again be surprised by a payroll date arriving before a client payment does.

Why 13 weeks

Thirteen weeks is one quarter. It is long enough to see trouble coming — a VAT payment, Ramadan seasonality, a client who always pays 20 days late — and short enough that the numbers stay real rather than hopeful. Monthly forecasts hide the danger: a month can look fine in total while week two of it leaves you unable to pay salaries.

The template structure

Open a blank spreadsheet. Columns are weeks (W1 to W13). Rows are:

Opening balance — cash actually in the bank at the start of the week.

Cash in:

• Confirmed client payments (invoices with agreed dates)
• Probable payments (issued invoices, estimated by client behavior)
• Other income (refunds, deposits)

Cash out:

• Salaries and wages
• Rent
• Suppliers
• VAT and government fees
• Subscriptions and utilities
• Owner drawings

Net movement = total in − total out. Closing balance = opening + net movement. This becomes next week's opening balance.

A worked example (SAR)

A small design studio in Riyadh, first four weeks:

Notice what the forecast reveals: W3 closes at 22,500 SAR — dangerously close to the 26,000 SAR payroll if the W2 client payment of 35,000 slips by two weeks. That is the entire value of the tool: you see the collision six weeks early, while you can still act — chase the invoice, delay a supplier payment, or shift a purchase.

Estimating the hardest row: client payments

Cash out is easy to predict; cash in is where forecasts lie. Two rules keep you honest:

1. Use behavior, not promises. If a client has paid your last four invoices 18–25 days after the due date, forecast the next one at +21 days regardless of what the contract says. The invoice aging calculator shows you each client's real payment pattern from your outstanding invoices. 2. Discount uncertain money. Enter confirmed payments at 100%, issued invoices at 80%, and promised-but-uninvoiced work at 0. If you cannot invoice it yet, it is not cash flow — and the faster you issue the invoice via the invoice generator, the sooner it becomes real.

The 20-minute weekly ritual

Pick a fixed slot — Sunday morning works well in Gulf business weeks. Then:

1. Replace last week's forecast numbers with actuals from your bank statement (5 min). 2. Update expected payment dates based on any client news (5 min). 3. Add week 14 at the end so the horizon always stays 13 weeks (5 min). 4. Look at the lowest closing balance in the sheet. That number — the trough — is your real financial position, not today's bank balance (5 min).

What to do with what you see

If the trough goes negative, you have weeks — not days — to respond: accelerate invoicing, request a deposit on new work, negotiate supplier terms, or trim a discretionary cost. If the trough stays comfortably positive for a full quarter, you can finally answer growth questions with data: whether the business can absorb a new hire or higher rent, and check how much more revenue that requires with the break-even calculator.

A forecast does not create cash. It creates time — and in small business, time is what turns a crisis into an errand. Build the sheet this week, before you need it; the worst moment to start forecasting is the week the trouble has already arrived.

More from Xuvilo

Try our free tools: invoice generator, quotation generator, receipt generator, and 14 business calculators. For more guides, head back to the Xuvilo Blog.