30 Jun Cash Flow Forecasting for South African SMEs: A Practical Template Approach

Cash Flow Forecasting for South African SMEs: A Practical Template Approach

Late payments are quietly becoming one of the biggest threats to small business survival in South Africa. By Q2 of the most recent reporting period, unpaid invoices older than 30 days had climbed to R12.4 billion — up from R11.7 billion just one quarter earlier, a 6% deterioration in a matter of months. The number of overdue invoices grew even faster: from roughly 81,700 to over 95,000, a 17% jump in a single quarter. For SMEs operating on already-thin margins, that’s not an inconvenience — it’s a direct threat to whether the business survives the next few months.

A cash flow forecast won’t make a slow-paying customer pay faster, but it will tell you, well in advance, exactly when you’re going to run short — so you can act before the crunch hits rather than scrambling once it has. Here’s a practical, no-frills approach to building one.

Why Profit and Cash Flow Are Not the Same Thing

A business can be profitable on paper and still run out of cash — this is one of the most common and most dangerous misunderstandings among growing SMEs. Profit is an accounting measure; cash flow is what’s actually sitting in your bank account. If your customers are paying you 60 or 90 days after invoice while your suppliers expect payment in 30, your income statement can look healthy while your bank balance quietly heads toward zero.

The Core Cash Flow Forecasting Formula

At its simplest, cash flow forecasting comes down to one equation, applied consistently period by period:

Ending cash balance = (Beginning cash balance + Cash inflows) − Cash outflows

Run this calculation monthly, and each month’s ending balance becomes the next month’s beginning balance — building a rolling picture of where your cash position is headed, not just where it stands today.

Building the Template: Four Steps

1. Project Your Cash Inflows

List every source of incoming cash: sales revenue (realistically timed to when customers actually pay, not when you invoice), plus any secondary inflows like loan proceeds, asset sales, or grant disbursements. Be conservative here — optimistic revenue assumptions are the most common reason cash flow forecasts turn out to be wrong.

2. Project Your Cash Outflows, Categorised

Break expenses into three categories, since each behaves differently and needs a different level of scrutiny:

• Fixed costs — rent, salaries, insurance, loan repayments. Predictable and largely non-negotiable in the short term.
• Variable costs — materials, commissions, shipping. These move with sales volume, so they should scale with your inflow projections.
• Irregular expenses — equipment purchases, legal fees, annual subscriptions. Easy to forget because they don’t happen every month, but they can blindside a forecast that only tracks recurring costs.

3. Calculate Net Cash Flow

Subtract total outflows from total inflows for each period. A negative net cash flow in a given month isn’t automatically a crisis — it depends on whether your beginning balance can absorb it — but it’s a signal worth flagging and investigating.

4. Roll Forward the Ending Balance

Add net cash flow to your beginning balance to get the ending balance for that period, then carry it forward as next period’s opening figure. Twelve months of this, laid out side by side, is your forecast.

Set the Right Time Horizon

A 12-month projection, broken down month by month, is the standard starting point for most small businesses — long enough to see seasonal patterns and major expenses coming, short enough that the numbers stay reasonably reliable. Businesses with tighter, more volatile cash positions often layer a rolling 13-week forecast on top, for a closer view of the near term.

Stress-Test It With Three Scenarios

A single-line forecast tells you what you expect to happen. A stronger forecast tells you what happens if things go differently — build three versions:

• Most-likely case — your realistic, best-estimate numbers.
• Best case — faster collections, stronger sales, useful for knowing what upside looks like.
• Worst case — slower-paying customers, a lost contract, a cost spike. This is the version that tells you how much runway you actually have if things go wrong, and whether you need to arrange finance, tighten credit terms, or build a cash buffer before that happens.

Where South African SMEs Should Pay Extra Attention

Given how sharply overdue invoices have been climbing, your inflow assumptions deserve particular scrutiny. If your average customer is paying later than your invoice terms say they should, your forecast should reflect the real, historical payment pattern — not the payment terms printed on the invoice. Tracking actual debtor days (how long customers really take to pay, on average) and feeding that number back into the forecast is one of the highest-value habits an SME can build.

Frequently Asked Questions

How often should a cash flow forecast be updated?

Monthly, at minimum, comparing actuals against the forecast and adjusting future projections accordingly. Businesses with tighter cash positions or high customer-payment volatility often review weekly.

What’s the single biggest mistake businesses make when forecasting cash flow?

Using invoice payment terms instead of actual historical payment behaviour to time inflows. If customers typically pay 15 days later than your stated terms, a forecast built on the stated terms will consistently overstate how much cash you’ll have on hand.

Do I need accounting software to do this properly?

No — a well-built spreadsheet is enough for most SMEs, provided it’s updated consistently and reconciled against actual bank activity each month. Software helps with automation and reduces manual error as the business grows, but the underlying method is the same either way.

If cash flow visibility or slow-paying customers are putting real pressure on the business, our guide to unlocking profit potential covers the broader financial picture, or you can book a free 30-minute business review to work through your specific numbers.