ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Blog / Cash management · Procura team · Updated November 18, 2026 · 9 min read
Cash management

Cash flow forecast: a 7-step method and a 3-month worked example

Build a cash flow forecast that actually helps: receipts by customer terms, VAT, payroll, suppliers, investments, a cautious scenario and an alert threshold, with a month-by-month worked example.

Gross
The forecast uses amounts actually paid
12 months
Annual plan horizon
13 weeks
Operational tracking horizon
1 threshold
The minimum balance not to cross

01What a cash flow forecast is for

A cash flow forecast projects, month by month, the money that will come into and go out of the bank account, and the resulting balance. It answers one question: will we have enough cash at each month end to pay what we owe?

It is not the budget, nor the income statement. A January sale paid at 60 days is January revenue but March cash. A 30,000 investment is an immediate cash outflow, while it only affects profit through depreciation. A loan repayment leaves the bank without being an expense.

That is why a profitable company can run short of cash: growth, customer terms and investments consume money before they bring any in.

02The structure: four blocks

Line 1, the opening cash balance (the previous month's closing balance, and for the first month, the reconciled bank balance).

Block 2, receipts: sales collected (taxes included), other income collected, capital contributions, loans received, grants, tax refunds.

Block 3, payments: suppliers, net salaries and social charges, rent, taxes, net sales tax to remit (VAT, or GST and QST), investments, loan repayments, dividends.

Line 4, the closing balance: opening + receipts - payments. It is the only line that really matters, and it must be compared with an alert threshold set in advance.

03The 7-step method

1. Start from the reconciled bank balance, not the online balance: an issued cheque not yet cashed distorts the starting point (see our guide to bank reconciliation).

2. Project sales, then shift them by your customers' actual payment times, not the contractual ones. Think taxes included: that is what the customer pays you.

3. Place the net sales tax to remit in the month it is paid: tax collected on sales minus tax deductible on purchases, with the filing lag.

4. Add recurring, certain payments: salaries, social charges, rent, subscriptions, loan instalments.

5. Place suppliers on their actual due dates. Orders already placed are near-certain payments: a commitment approved today is a cash outflow in 30 or 60 days.

6. Add one-off operations: investments, annual taxes, bonuses, an expected tax refund.

7. Set an alert threshold (for instance one month of salaries and current suppliers), then build a cautious scenario. Update the plan every month with actuals.

04A three-month worked example

A trading SME, subject to 20% VAT, starts January with 40,000 in the bank. Sales before tax: December 75,000, January 80,000, February 90,000, March 70,000. Customers pay at 30 days: a month's receipts equal the previous month's sales, taxes included. Receipts: January 90,000, February 96,000, March 108,000.

Fixed monthly payments: salaries and charges 45,000, suppliers 24,000 taxes included (of which 4,000 deductible VAT), rent 6,000 taxes included (of which 1,000 VAT), loan instalment 2,500. In February, a machine is bought for 36,000 taxes included (of which 6,000 VAT). Each month's net VAT is paid the following month: 10,000 in January (15,000 collected in December minus 5,000 deductible), 11,000 in February, 7,000 in March (18,000 collected in February minus 11,000 deductible, machine included).

January: 40,000 + 90,000 - 87,500 = 42,500. February: 42,500 + 96,000 - 124,500 = 14,000. March: 14,000 + 108,000 - 84,500 = 37,500.

Reading: the company is profitable and ends March close to its January level, but it goes through a 14,000 trough at the end of February, below a reasonable 20,000 alert threshold. The plan shows the problem two months ahead, while there are still options: finance the machine with a loan or a lease, move the purchase to March, or negotiate staged payments.

05The cautious scenario: what happens if a customer pays late

Take the example again, assuming 20% of January sales are paid one month late. February receipts fall from 96,000 to 76,800, and the end-of-February balance goes from 14,000 to minus 5,200: an overdraft, while nothing changed in the business.

That is the point of the cautious scenario: it measures how sensitive the plan is to the two variables the company controls least, customer payment times and large one-off spending. If the cautious scenario goes below zero, the decision (financing, deferral, collection calls) is taken now, not in February.

On the spending side, the best protection is knowing what is already committed. An approved order not yet invoiced appears on no bank statement; it still belongs in the plan. It is one of the arguments for routing purchases through approved requests and orders rather than invoices discovered on arrival.

06The six mistakes that make a forecast useless

1. Copying the budget and shifting everything by one month. Actual payment times vary by customer and supplier; a customer who pays at 75 days is not a 30-day customer.

2. Mixing net and gross amounts. If sales are entered before tax and suppliers after tax, the net sales tax to remit is counted twice or not at all.

3. Forgetting annual items: income tax and its instalments, local taxes, insurance paid once a year, thirteenth-month pay or bonuses. They rarely fall in the month when cash is most comfortable.

4. Ignoring commitments already made. Signed orders, subscription contracts and approved investments are known; they belong in the plan before the invoice arrives.

5. Never comparing with actuals. A plan that is not checked every month against what happened does not improve. The gap between forecast and actual, line by line, shows where the assumptions were wrong.

6. Having only one scenario. The central scenario reassures; the cautious one protects. Both should be presented together to management and to the bank.

07Monthly over 12 months, weekly over 13 weeks

The 12-month monthly plan is for deciding: investments, financing, hiring. The 13-week weekly tracking is for steering: which invoices to pay this week, which customer to chase. They complement each other; our article on 13-week cash forecasting covers the second.

To get started, our 13-week cash flow Excel template projects receipts, payments and balance week by week, and flags negative weeks.

In Comptia, the cash forecast is computed from the general ledger, over a rolling 13 weeks by default (4 to 52 weeks depending on the setting), with an alert threshold, what-if scenarios on the page, and a snapshot of the forecast saved each week it is viewed, to compare with actuals later.

Frequently asked questions

Is a cash flow forecast built before or after tax?

After tax (gross). The forecast tracks money actually received and paid: customers pay the tax-included amount, and the net tax owed to the State appears on its own line, in the month it is paid.

What is the difference between a cash flow forecast and a cash budget?

The terms are often used interchangeably. When they are distinguished, the cash budget is the initial projection for the year, and the forecast is the living version, updated monthly with actuals.

How often should a cash flow forecast be updated?

Every month at least, after the bank reconciliation. When cash is tight, switch to weekly tracking over 13 weeks.

Which alert threshold should you use?

There is no standard. A common benchmark is one month of unavoidable payments (salaries, charges, rent, current suppliers). What matters is setting it in advance and comparing it with the cautious scenario, not only the central one.


Sources & references

Free guide

The P2P Playbook for Africa.

Seven concrete levers to digitise your procure-to-pay cycle, SYSCOHADA, MeCEF, FNE, Mobile Money. PDF, 12 pages, free.

No spam, ever. One-click unsubscribe.

See Procura on your real data.

From need to payment, your purchasing cycle in a 30-minute demo.