Profitable businesses run out of cash all the time. Customers pay late, a VAT payment and month-end salaries land in the same week, or a large order needs stock paid for before the customer pays. None of this shows up in the annual financial statements until it is far too late.
A 13-week cash flow forecast is the simplest tool for seeing it coming. It covers one quarter, week by week, which is far enough ahead to act and close enough to be accurate.
Why 13 weeks, and why weekly
Monthly forecasts hide the timing problems that hurt small businesses. A month can look fine overall while the week salaries go out is short by R60,000. Weekly columns show those dips. Thirteen weeks is one quarter, long enough to cover a full cycle of salaries, SARS payments and supplier runs.
Step 1: Start with your actual bank balance
Use the real balance across all business bank accounts today, not the balance in your accounting system unless the bank is fully reconciled. If you have an overdraft, note the facility limit separately.
Step 2: Forecast receipts customer by customer
Work from your debtors age analysis, not from sales targets. For each customer, enter the amount in the week you realistically expect to receive it, based on how they have actually paid before. A customer who always pays 45 days after invoice goes in at 45 days, whatever your terms say.
Then add new sales you expect to invoice, shifted by their usual payment delay, and any other receipts such as loan funding or asset sales. Be conservative: it is better to be pleasantly surprised than caught short.
Step 3: Forecast every payment, with its date
- Salaries and wages, in the week they are paid, including any bonuses.
- PAYE, UIF and SDL on the EMP201, due to SARS by the 7th of the following month.
- VAT, if you are registered. Most small vendors file every two months, with payment due by the 25th of the month after the period ends, or the last business day of that month if you file and pay on eFiling.
- Provisional tax. For a company with a February year end, the first payment is due at the end of August and the second at the end of February.
- Suppliers, on the dates you actually pay them.
- Rent, loan and vehicle repayments, insurance and debit orders.
- Annual and once-off items that are easy to forget: software licences, the CIPC annual return, equipment, the audit or review fee.
Step 4: Work out the closing balance for each week
Each week’s closing balance is the opening balance plus receipts minus payments. It becomes the next week’s opening balance. Here is a simplified example covering four of the thirteen weeks:
| Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
| Opening balance | R250,000 | R255,000 | R245,000 | R300,000 |
| Customer receipts | R120,000 | R60,000 | R90,000 | R140,000 |
| Salaries | – | – | – | (R180,000) |
| PAYE, UIF and SDL | (R45,000) | – | – | – |
| Suppliers | (R40,000) | (R70,000) | (R35,000) | (R50,000) |
| Rent | (R30,000) | – | – | – |
| VAT | – | – | – | (R55,000) |
| Closing balance | R255,000 | R245,000 | R300,000 | R155,000 |
The figures are illustrative. Week 3 looks comfortable, but salaries, suppliers and VAT all fall in week 4 and take R285,000 out of the bank in seven days.
Step 5: Set a minimum balance and flag the gaps
Decide on the lowest balance you are comfortable holding, for example one month of salaries, or enough to cover two weeks of payments. In the example, a business that wants at least R200,000 in the bank can see four weeks ahead that week 4 falls R45,000 short. That’s early enough to do something about it.
Step 6: Act early on a shortfall
- Chase the specific customers whose payments would close the gap. Our guide on getting clients to pay on time sets out a follow-up routine.
- Ask key suppliers for a short extension before the payment is due, not after.
- Move non-urgent spending, such as equipment or once-off projects, to a later week.
- Speak to your bank about an overdraft or a temporary increase well before you need it. Banks respond far better to a forecast than to a request made the day before payroll.
Step 7: Update it every week
Every week, replace the week just gone with actual figures, roll the forecast forward by one week, and compare what happened with what you expected. Where the forecast was wrong, find out why. Within a few weeks the forecast becomes reliable, and checking it takes about 30 minutes.
Forecast or budget? A budget sets targets for the year. A 13-week forecast predicts your bank balance week by week. You need both: the budget to measure performance, and the forecast to make sure you can pay everyone on the way.
How Monarch helps
We build and maintain cash flow forecasts and budgets for small businesses and independent schools in Johannesburg, and review them with you every month alongside your management accounts. Read about our budgeting and forecasting service, or book a free consultation.
This article is general information, not legal, tax or accounting advice for your specific situation.