How to Create a 12-Month Rolling Cash Flow Forecast for a Small Business
A 12-month rolling cash flow forecast shows when money moves in and out of your business — updated monthly so you always see a full year ahead. To build one: list every expected inflow and outflow by month, track opening and closing balances, and roll it forward each time you close a month. This article shows you exactly how.
Lerato runs a small marketing consultancy in Johannesburg. She's billing consistently — R85,000 a month on average — and her clients are paying. On paper, she's profitable. But in March, she nearly missed payroll.
The problem wasn't revenue. It was timing. Three retainer invoices were 45 days late. Her landlord had moved the lease renewal to a new quarter. And she'd bought equipment in February without accounting for the VAT payment due the same month.
Nothing catastrophic. Just three ordinary business events landing at the same time — with no system to see them coming.
That's what a rolling cash flow forecast is for. Not accounting. Not optimism. Just a honest, month-by-month picture of when money arrives and when it leaves — updated regularly enough to actually be useful.
This guide walks you through building one from scratch, whether you're using Excel, Google Sheets, or a ready-made template.
What Is a Rolling Cash Flow Forecast — and Why Does the Rolling Part Matter?
A standard cash flow forecast shows you one fixed period — usually a financial year. You build it in June for July–June, and by December it's already half stale.
A rolling forecast is different. It always shows the next 12 months from today. When January closes, you add the following January. The window moves forward. You never lose sight of the year ahead.
For small businesses, that matters more than it sounds. Your business is not a spreadsheet that resets annually. Your lease doesn't care about your tax year. Seasonal dips, large supplier payments, and slow-paying clients don't arrange themselves neatly around a fixed budget cycle.
The rolling format forces you to keep the forecast alive — not as a once-a-year ritual, but as a working tool you update every month with actual figures. That's when forecasts become useful rather than impressive-looking and ignored.
A cash flow forecast is not a profit and loss statement. Your P&L shows whether your business is profitable. Your cash flow forecast shows whether your business can pay its bills this month. You can be profitable and cash-flow negative at the same time — which is exactly how solvent businesses go under.
What Goes Into a 12-Month Cash Flow Forecast?
Before you build anything, you need to know what you're tracking. A complete forecast has three categories of rows and one running total.
Cash Inflows
These are all the ways money enters your bank account — not when you raise the invoice, but when the cash lands. List every source separately:
| Inflow Category | South African Example | Notes |
|---|---|---|
| Client / customer receipts | Retainer fees, project payments, product sales | Use actual payment dates, not invoice dates |
| VAT refunds (SARS) | Refund from SARS on VAT201 submission | Only if VAT-registered and expecting a refund |
| Loan proceeds | IDC, NEF, or commercial bank drawdowns | List month loan proceeds hit your account |
| Investment / owner capital | Personal capital injection | Track separately from trading income |
| Other income | Commissions, rental sub-income, grants (SEDA, etc.) | List individually if material |
Cash Outflows
Every payment that leaves your account, in the month it actually leaves. Common categories for South African small businesses:
| Outflow Category | South African Example | Notes |
|---|---|---|
| Salaries and wages | Nett pay to employees | Separate from PAYE and UIF |
| PAYE & UIF (SARS) | EMP201 monthly submission | Due 7th of following month |
| VAT payments (SARS) | VAT201 — bi-monthly for most SMEs | Watch the lumpy months — this catches people off guard |
| Rent / premises | Office lease, storage, co-working | Include annual escalation months |
| Suppliers / cost of goods | Stock purchases, materials, subcontractors | Match to when you pay, not when you receive |
| Loan repayments | Business loan instalments | Principal + interest, fixed monthly |
| Insurance | Business insurance, professional indemnity | Note annual vs monthly billing |
| Software and subscriptions | Accounting software, tools, SaaS | Watch for USD-billed items — rand exposure |
| Marketing and advertising | Google Ads, Meta, print, events | Include campaign months separately |
| Provisional tax (SARS) | IRP6 — August and February | Two fixed-date outflows per year — plan for them |
Opening Balance, Net Position, Closing Balance
This is the mechanical core of the forecast. Three rows that link every month together:
Opening Balance = Previous month's Closing Balance
Total Inflows = SUM of all inflow rows
Total Outflows = SUM of all outflow rows
Net Cash Position = Total Inflows − Total Outflows
Closing Balance = Opening Balance + Net Cash Position
That closing balance is the only number that actually tells you how you're doing. If it goes negative in any month, that's not a projection — that's a problem you now have time to solve.
Building It: Step by Step
This is your current bank account balance — not your accounting balance, your actual available cash. Pull it from your business bank statement for the first day of your forecast period. If you have multiple accounts, decide upfront whether you're forecasting consolidated cash or per account.
Go through your existing client contracts, outstanding invoices, and recurring revenue. Enter each inflow in the month you expect the cash to arrive — not when you billed. If a client consistently pays 30 days late, build that into your forecast. Optimistic forecasts don't help you manage reality.
Pull your last 3 months of bank statements and categorise every outgoing payment. Fixed costs (rent, salaries, loan repayments) repeat — they're easy. Variable costs (stock, marketing, travel) need estimates based on your operating plan. Statutory payments have fixed due dates: put them in the exact month they're due.
For each column (month), subtract total outflows from total inflows. Add that net to the opening balance. The result is your closing balance — which becomes next month's opening balance. Months with a negative closing balance are the months you need to act on before they arrive.
This is the rolling mechanic. At the end of each month, replace your oldest forecast month with actual figures, then add a new 13th month at the far end. You always have 12 months of forward visibility. The forecast rolls — it never collapses to a single quarter as the year wears on.
Add a column next to each closed month showing Actual vs Forecast and the variance. If your forecasts are consistently wrong in the same direction — always underestimating inflows, always missing a category of outflow — the variance column shows you that pattern fast. It turns the forecast into a learning tool, not just a planning one.
The most common error in small business cash flow forecasts is using invoice dates instead of payment dates. A R45,000 invoice raised on 1 March that your client pays on 30 April is a March event on your P&L — but it's an April event on your cash flow. Forecasting on invoice dates makes your position look better than it is, in exactly the months where the gap will hurt you most.
Real Example: Thabo's Construction Firm, Cape Town
Thabo runs a small residential construction firm in Cape Town. His team of 8 generates around R320,000 in monthly billings — but his projects bill in milestone phases, which means three months of work followed by a large payment. His costs, however, are monthly: salaries, plant hire, materials, and fuel.
Without a cash flow forecast, Thabo was managing month to month based on bank balance. He knew large payments were coming — he just never knew exactly when.
The fix: He mapped his next three projects against his outstanding invoices, estimated payment timing conservatively (assuming 30 days after milestone submission), and plotted his fixed costs month by month. Within the first draft of his forecast, he could see that July and August were going to be extremely tight — both closing balances went below R25,000. With two months of warning, he negotiated extended terms with his main materials supplier, moved a non-critical equipment purchase to September, and approached his bank about a short-term overdraft facility he'd never needed before. He didn't need the overdraft. But having it arranged in May — not in a July emergency — meant he negotiated from a position of stability, not desperation.
That is what a cash flow forecast actually does. Not magic. Not accounting software. Just visibility — early enough to act.
South Africa-Specific Items to Never Miss
South African small businesses have several statutory payment obligations that create predictable, high-value outflows. These are the ones most commonly forgotten in informal forecasts — and the most dangerous to miss.
| Obligation | Typical Due Date | Forecast Action |
|---|---|---|
| PAYE / UIF (EMP201) | 7th of the following month | Fixed row, every month. Non-negotiable. |
| VAT (VAT201) | Last business day of the month after the tax period | Bi-monthly for most SMEs. Enter in the exact months it's due. |
| Provisional Tax — 1st payment (IRP6) | 31 August (or end of 6th month of tax year) | Single large outflow. Flag this month visually. |
| Provisional Tax — 2nd payment (IRP6) | 28 February (or end of tax year) | Single large outflow. Flag this month visually. |
| Annual lease escalation | Varies — check your lease | Usually 8–10% increase. Adjust that month's rent row. |
| CIDB / industry levies | Varies by industry | Construction, transport, and other regulated sectors — check your industry SETA. |
If you're VAT-registered and on a bi-monthly cycle, your VAT payment months will consistently show higher outflows. Colour-code those months in your spreadsheet so they're visually obvious at a glance. A red or amber cell is a faster warning than scanning columns of numbers.
What a Completed Forecast Looks Like
Here's a simplified 3-month extract from a service business forecast. The full 12-month version extends this structure across all columns.
| Line Item | July | August | September |
|---|---|---|---|
| INFLOWS | |||
| Client receipts | R 68,000 | R 52,000 | R 91,000 |
| SARS VAT refund | — | R 8,400 | — |
| Total Inflows | R 68,000 | R 60,400 | R 91,000 |
| OUTFLOWS | |||
| Salaries (nett) | R 34,000 | R 34,000 | R 34,000 |
| PAYE & UIF (SARS) | R 9,200 | R 9,200 | R 9,200 |
| VAT payment (SARS) | R 11,400 | — | R 13,100 |
| Rent | R 8,500 | R 8,500 | R 9,300 |
| Software & subscriptions | R 2,100 | R 2,100 | R 2,100 |
| Provisional tax (IRP6) | — | R 18,000 | — |
| Total Outflows | R 65,200 | R 71,800 | R 67,700 |
| Net Cash Position | + R 2,800 | − R 11,400 | + R 23,300 |
| Opening Balance | R 38,000 | R 40,800 | R 29,400 |
| Closing Balance | R 40,800 | R 29,400 | R 52,700 |
August closes at R29,400 — which is tight for this business. Seeing this in May gives the owner time to accelerate a client payment, delay a non-critical purchase, or simply hold the overdraft facility in reserve for that month. None of those options are available once August arrives and the balance hits the account.
Stop building this from scratch.
The DocxDrop 12-Month Rolling Cash Flow Forecast is built for South African small businesses — ZAR-denominated, with PAYE, VAT, and provisional tax rows already included. Available in Excel and Google Sheets.
Get the Template → Instant download · One-time purchase · No subscriptionHow Often Should You Update It?
Monthly — as a hard rule. Weekly for the next 8 weeks if you're in a tight period.
The monthly ritual is simple: close the oldest month by replacing forecasted figures with actual bank statement figures. Add a new 13th month at the end using your best current estimates. Update any forward months where your expectations have changed — a client who's indicated they'll pay late, a supplier who's raised prices, a new cost you didn't anticipate.
This takes 45 minutes to an hour once the template is set up. Businesses that do it consistently don't get surprised. Businesses that only open the forecast when something feels wrong are using it as a post-mortem tool rather than a planning one.
Every Monday, check the next 4 weeks of your forecast against your current bank balance. If they're diverging — you're running lower than expected, or a large payment hasn't arrived — you find out with 3 weeks to act, not 3 days.
Excel vs Google Sheets: Which Should You Use?
Both work well. The choice depends on how you run your business day to day.
Use Excel if you work offline frequently, have complex multi-sheet modelling needs, or your accountant prefers to receive .xlsx files. Excel handles large formula arrays faster and has more advanced data validation tools for complex forecasts.
Use Google Sheets if you want to share the forecast with your accountant, bookkeeper, or business partner in real time. The link-sharing model makes collaboration frictionless — no emailing versions, no file naming confusion. It also means you can update the forecast from your phone while you're on-site with a client.
DocxDrop's 12-Month Rolling Cash Flow Forecast is available in both formats — same structure, same formulas, same colour-coded input cells. Choose based on your workflow, not what sounds more professional.
- A rolling cash flow forecast always shows 12 months ahead — it moves forward each month rather than shrinking toward year-end.
- Forecast when cash lands in your account, not when you raise the invoice. The gap between those two dates is where businesses get caught.
- South African SMEs must include PAYE/UIF (monthly), VAT (bi-monthly), and provisional tax (August and February) as fixed forecast rows — these are the most commonly missed outflows.
- A negative closing balance in any future month is a warning with time attached. Act on it before the month arrives.
- The forecast only works if you update it monthly. A 45-minute month-end review is the entire maintenance cost.
- Variance tracking — comparing actual to forecast — turns the spreadsheet into a learning tool that gets more accurate over time.
Need your P&L and cash flow in the same system?
The DocxDrop Small Business Finance Bundle includes the Cash Flow Forecast, Annual Budget Workbook, and Profit & Loss Statement — built to work together.
One Response