Most South African small business owners know they should be forecasting their cash. Very few actually do it. The ones who don't usually explain this the same way: "I don't really know where to start" or "My income is too unpredictable to forecast."
Neither of those is a real obstacle. A 12-week cash flow forecast doesn't require accounting knowledge, it doesn't require perfect information, and it doesn't take more than 30 minutes to build the first time. What it does require is the willingness to confront the numbers.
Why 12 weeks?
Annual budgets are useful but they're too far out to act on. If your annual model shows a cash shortfall in month 10, you don't really feel it until month 8 or 9, and by then you have limited options.
A 12-week (roughly 3-month) window is close enough that your estimates are grounded in reality — you know what's in your sales pipeline, what invoices are outstanding, what major expenses are coming. It's also far enough out that if you identify a problem in week 8, you have eight weeks to do something about it: chase debtors, reduce discretionary spending, arrange a short-term facility, delay a capital purchase.
Finding out you're going to run out of cash eight weeks before it happens is a problem you can solve. Finding out the week it happens is a crisis.
What you need to get started
You don't need complex software. A spreadsheet works fine — Google Sheets or Excel, whichever you're more comfortable with. You need three things:
Your bank statement or Xero bank feed. This gives you your opening balance for week 1 and a realistic picture of your recurring payment patterns.
Your outstanding debtors. A list of invoices you've issued that haven't been paid yet, with the expected payment dates. This is the most important input to get right. If you're in Xero, the Aged Receivables report gives you this instantly.
A list of expected payments for the next 12 weeks. Rent, salaries, PAYE, supplier invoices, loan repayments, VAT, insurance — everything that's committed.
Setting up the forecast: the structure
Lay out 12 columns, one per week. For each week, you need four rows:
Opening balance — the bank balance at the start of that week (which is the previous week's closing balance, except for week 1 where it's your current actual balance).
Expected receipts — money you expect to receive that week. This includes payments from outstanding invoices (based on your debtors book and expected payment dates), any new sales you're reasonably confident of, and any other income.
Expected payments — money going out that week. Include everything: salaries and wages, PAYE (due by the 7th of each month), VAT (due by the 25th of the relevant month), rent, loan repayments, supplier payments, insurance premiums, subscriptions, and any large one-off payments.
Closing balance — opening balance plus receipts minus payments. This is your projected bank balance at the end of that week.
That's the whole structure. It takes about 20 minutes to populate the first time once you have your inputs.
The key insight: where the closing balance goes negative
As you complete the forecast, scan down the closing balance row. The moment it goes negative — even briefly — that's the week your business runs out of money, and it will happen in real life if nothing changes.
This is the entire value of the exercise. Not the accuracy of the forecast (it won't be perfectly accurate), but the visibility. You now know, eight or ten or twelve weeks in advance, that there is a problem. You have time to act.
Common responses to a projected cash gap:
- Accelerate collections: call debtors with invoices due in weeks 5–8 and ask them to pay earlier
- Delay discretionary spending: postpone a capital purchase or a non-essential service until after the tight period
- Negotiate extended supplier terms: ask a supplier to push a payment from week 6 to week 10
- Arrange a short-term facility with your bank before you need it (banks are far more willing to discuss facilities when you aren't already in crisis)
None of these options are available once the cash gap has already arrived. They're only available when you can see it coming.
South African-specific items to include
This is where many generic cash flow templates miss the mark. Make sure your forecast includes:
Provisional tax. If you're a provisional taxpayer, your first payment is due at the end of August and your second at the end of February. These can be substantial — often R30,000 to R200,000+ depending on the business — and they fall in fixed months. Put them in the forecast as soon as you know the relevant months fall within your 12-week window.
VAT. VAT returns are typically due on the 25th of the month following the end of your VAT period. For bi-monthly vendors, this means a VAT payment every two months. If you've been collecting 15% VAT from clients and spending freely, the VAT payment can catch you out. Put it in the forecast so you can see exactly how much it reduces your available balance on the day it's due.
CIPC annual return fee. This falls on your registration month anniversary and is easy to forget. It's a relatively small amount (R100–R175 for most private companies) but the point is to include everything.
Annual licence renewals and insurance premiums. Some insurers bill annually. Some licence authorities send annual renewals. These lumpy, infrequent payments are the ones people most often forget to include.
Salary increases and thirteenth cheques. If your team's salaries increase in a particular month, or if you pay a year-end bonus, model it in the forecast when those months approach your 12-week window.
How to maintain it
The forecast is only useful if you keep it current. The method that works for most businesses is straightforward: every Monday morning, spend 15 minutes updating it. Update the actual bank balance, mark the receipts and payments that happened last week as actual (replacing the estimates), add a new week 12 to the rolling window, and review whether any estimates in the remaining weeks need adjusting.
Over time you'll get better at estimating. Your debtors' payment patterns will become predictable. Your recurring expenses will be pre-loaded and just roll forward each week.
After two or three months of maintaining the forecast, you'll find that you stop being surprised by cash. The surprises — a slow-paying debtor, a bigger-than-expected VAT payment — become visible weeks in advance rather than arriving without warning.
The Xero shortcut
If your bookkeeping is current in Xero, the platform has a built-in short-term cash flow tool that does a version of this automatically. It pulls your bank balance from the connected feed, your outstanding receivables from the invoices module, and your outstanding payables from the bills module, and projects your balance forward 30 and 90 days.
It won't capture every payment — it doesn't know about PAYE, provisional tax, or salary costs unless those are in bills — but it gives you a useful starting point and takes the data entry out of the debtors and creditors portion of your forecast. You'd still want to add the tax and payroll items manually.