BusinessZA

Cash Flow & P&L

Cash Flow Forecaster

Three months of cash in and out, starting from today’s balance. See your tightest moment, the runway at your current burn, and whether you’ll close any month negative.

Month 1

Month 2

Month 3

Cash forecasts are only as accurate as the inputs. Be honest about timing — a R100k invoice expected in month 1 that actually lands in month 3 is the exact pattern that causes cash crunches. When in doubt, model two scenarios.

See it before it arrives

How to forecast cash for a South African small business

The single most common reason South African SMEs fail isn’t lack of profit. It’s lack of cash on the day cash is required. A business can be making money on paper, growing revenue every month, and still run out of money because the timing of inflows and outflows doesn’t line up. A cash forecast is the only tool that surfaces this gap before it kills you.

Profit ≠ cash

An example. You sell R500k of consulting work in month 1, on 60-day terms. You recognise revenue immediately — month 1 P&L shows the R500k. But the cash only arrives in month 3. Meanwhile salaries, rent, and supplier invoices need paying in months 1 and 2. You can be R500k profitable in month 1 and still default on rent in month 2. The income statement won’t show the problem until month 3 settles — too late to act.

This timing gap exists for every business that runs on credit terms. The forecast collapses the gap into one view: not what’s earned, but what’s in the bank, on the day the bank needs it.

The mechanics

Closing balance = Opening balance + Money in − Money out Next month opens with the previous month’s close

The maths is mechanical. The work is in being honest about timing. Cash in means cash in the bank — not invoices issued, not orders received, not promises. Cash out means cash out of the bank — not stock ordered, not bills received. The unit isn’t accruals; it’s bank transactions on the date they actually clear.

What goes in the inflow column

  • Cash sales — point of payment.
  • Credit sales — forecast by debtor age. If your average debtor pays in 45 days, an invoice issued today shows up in cash six weeks from now, not in the month invoiced.
  • Existing debtors — invoices already outstanding. Schedule by expected receipt date, not by age — old debtors get older.
  • VAT refunds— if you’re in a refund position, these can take 30–90 days from SARS.
  • Loan drawdowns or capital — only when actually approved and dated.

What goes in the outflow column

  • Salaries and wages — month-end (or whenever you actually pay).
  • PAYE, UIF, SDL — 7th of the following month per SARS rules.
  • VAT — by the last business day of the month following your tax period. Provisional taxpayers should also model provisional tax in months 2 and 8.
  • Stock and suppliers — when invoices actually fall due, not when stock arrives. Use your supplier terms.
  • Rent and utilities — fixed monthly.
  • Loan repayments — capital plus interest, on the contract date.
  • Owner drawings — easy to forget; matters as much as anything else.
  • Lumpy outflows — insurance renewals, annual licences, equipment replacements, leave payouts. The crunches that surprise people are almost always these.

The lowest cash point is the number that matters

Most forecasts focus on the closing balance at the end of the period. That number is less important than the lowest point across the period. If month 2 dips to −R45k mid-month even though month 3 recovers, you still need a way through month 2. The bank doesn’t care that you would have been fine if it had just waited.

The forecaster surfaces the lowest closing balance across the three months. For a sharper view, model week-by-week instead — most businesses run their biggest outflows in the first week (salaries, rent) and the lowest cash point is typically week 1 of each month, not month-end.

When the forecast shows a crunch

Five levers, in order of speed and cost:

  1. Accelerate inflows — chase debtors aggressively, offer settlement discounts (2% for early payment is usually cheap), require deposits on new orders, switch slow debtors to cash-on-delivery terms.
  2. Delay outflows — negotiate extended supplier terms, time non-urgent purchases past the crunch month, defer owner drawings if possible.
  3. Cut discretionary spend — pause anything not keeping the lights on. Marketing campaigns, software subscriptions, training, travel.
  4. Raise short-term finance — an overdraft facility set up before you need it is much cheaper than emergency borrowing. Invoice discounting works for businesses with strong debtor books.
  5. Inject equity — owner contribution or external investor. Slowest and most dilutive, but sometimes the only option.

The earlier you spot the crunch, the more of these levers are available. Spotting it in the week is limited to option 1 (chase debtors) and option 4 (panic borrowing). Spotting it two months out opens up the whole list.

The discipline that makes forecasts useful

A forecast built once and forgotten is useless. The discipline:

  1. Update monthly— refresh with the actual closing balance from the month that just ended. Roll the forecast forward one month so you’re always looking three months out.
  2. Compare actual vs forecast — where did reality diverge from the projection? Usually it’s debtor timing. Adjusting next month’s assumptions based on what just happened is how the forecast gets better.
  3. Run a worst case — for any forecast showing thin headroom, model conservative assumptions: 20% lower inflows, 10% higher outflows, 30 extra days of debtor lag. If the worst case survives, you have margin. If not, act now.

Frequently asked questions

  • What is a cash flow forecast?

    A month-by-month projection of cash in and cash out, starting from today's bank balance. The point isn't accounting accuracy — it's seeing the future tight spots before they arrive. Profit and cash flow are different things; profitable businesses fail every month in SA because cash arrived too late to pay the salaries that already left.

  • Why three months?

    Long enough to catch the patterns that monthly P&L hides — VAT payments hitting on alternate months, PAYE filings, the gap between when you ship a sale and when the debtor actually pays. Short enough that the inputs stay grounded. Beyond three months, accuracy drops sharply because too many assumptions stack on top of each other. Refresh the forecast monthly with the actual closing balance from the previous month.

  • What counts as money in?

    Anything that hits the bank: sales (cash sales immediately, credit sales when the debtor pays, not when you invoice), debtor collections from prior months, loan drawdowns, capital injections, VAT refunds from SARS, asset sales. Don't include invoices you've issued but haven't been paid for — that's accounting revenue, not cash. Forecasting cash means forecasting the date the money actually arrives.

  • What counts as money out?

    Everything leaving the bank: stock purchases (when paid, not when received), supplier payments, salaries, UIF and PAYE to SARS, VAT payments on filing dates, rent, utilities, loan repayments, owner drawings, asset purchases. Be especially careful with quarterly or annual outflows — provisional tax, insurance renewals, leave payouts. Missing one of these is a common cause of unexpected crunches.

  • What's a healthy cash buffer?

    Most SME advisors recommend 1–3 months of operating expenses sitting in cash. The right number depends on revenue volatility, supplier credit terms, and how seasonal the business is. A retailer with strong supplier credit and steady monthly sales can run thinner; a construction or consulting business with lumpy payment cycles needs more. The forecaster tells you what the buffer needs to be: the lowest cash point across the projection is the buffer you need to survive that period.

  • What if the forecast shows a crunch?

    Five levers, in order of how quickly they work: (1) Accelerate inflows — chase debtors hard, offer settlement discounts, take deposits on new orders. (2) Delay outflows — negotiate extended supplier terms, time non-urgent purchases past the crunch. (3) Cut discretionary spend — pause anything that isn't keeping the lights on or serving customers. (4) Raise short-term finance — overdraft facility (cheaper than later panic borrowing) or invoice discounting. (5) Inject equity — owner contribution or external. The first two are usually fastest and cheapest. Acting two months out is much easier than acting in the crunch week.

  • How accurate are cash flow forecasts in practice?

    Less accurate than people expect. The two biggest drivers of error: (1) Debtor timing — clients reliably pay later than they promise. Discount your inflow assumptions if you're depending on prompt payment. (2) Surprises — equipment breaking, a client churning, a supplier raising prices mid-quarter. Build in a contingency line of 5–10% of monthly outflows for the unknown-unknowns. The point of the forecast isn't being right; it's being early enough to react when wrong.

  • Should I run a worst-case scenario too?

    Yes — for any forecast showing a tight cash position, run a second pass with conservative assumptions: 20% lower inflows, 10% higher outflows, debtor payments delayed by 30 days. If the worst case still survives, you have headroom. If the worst case crunches at month 2, that's the timing for action. Most businesses that fail were running a base-case forecast that worked; the worst case would have shown them the cliff months earlier.

  • Is the data I enter saved anywhere?

    No. Every calculation runs entirely in your browser. We never see the numbers you type, and nothing is stored on a server.