Cash flow is the single largest reason African SMEs fail in their first three years — even profitable ones. Sales were good, the books said the year was on track, then the supplier’s 60-day terms came due in the same week as VAT and the rent and the wage run, and the business was suddenly “short.”
Profitability and liquidity are not the same thing. A 13-week rolling cash-flow forecast keeps both visible.
This guide is for retail SME owners who don’t have a CFO, work mostly from a phone and a laptop, and want a practical way to never get blindsided by a cash-flow squeeze again.
Why 13 weeks?
13 weeks = one calendar quarter. It’s long enough to see the next big cash event coming (a tax payment, a quarter-end supplier reconciliation) and short enough to be plausibly accurate week-by-week.
Forecasting a year ahead is a strategic exercise; forecasting 13 weeks ahead is an operational one. They are different skills; this guide covers the operational one.
The four-row model
Every cash-flow forecast collapses to four rows times 13 columns:
| Row | What it captures | |---|---| | Opening cash | Bank + mobile money balances at the start of each week | | Cash in | Sales revenue actually received that week (not accrued) | | Cash out | Cash actually paid out that week (suppliers, wages, taxes, rent) | | Closing cash | Opening + In − Out (becomes next week’s Opening) |
Everything else is detail.
Step 1 — Map your cash inflow sources
Walk through your last 30 days and identify every channel money came in through:
- Mobile money — TNM Mpamba, Airtel Money, M-Pesa (whichever applies)
- Card terminal settlements (typically T+1 or T+2)
- Bank transfers (B2B customer payments)
- Cash deposits at the bank
- Letts Eat / Uber Eats / Glovo settlements (typically weekly)
For each source, note the lag: how many days between the customer paying and the money landing in your operating account. M-Pesa settles end-of-day; cards settle T+1; Glovo settles weekly on a Tuesday. Lags drive cash-flow surprises.
Step 2 — Map your cash outflow obligations
Same exercise for outflows. Common categories for African retail:
- Cost of goods (suppliers) — usually 30/60/90-day terms
- Wages (typically end-of-month or weekly for casuals)
- Rent (monthly or quarterly)
- Utilities (monthly)
- VAT / sales tax (monthly or quarterly)
- PAYE / income tax instalments
- Loan repayments
- Owner draws
Most owners under-estimate their outflows because they bundle too many small ones into “other.” Don’t. Granularity is the point.
Step 3 — Build the 13-week grid
In a spreadsheet (or in your accounting system if it has a cash-flow module):
- Columns 1–13: weeks
- Row 1: Opening cash (start of week)
- Rows 2–N: Inflows (one row per source)
- Row N+1: Total Inflows
- Rows N+2–M: Outflows (one row per category)
- Row M+1: Total Outflows
- Row M+2: Closing cash (Opening + Total Inflows − Total Outflows)
Closing cash for week 1 becomes Opening cash for week 2, and so on.
Step 4 — Forecast the inflows
For each inflow source, take the last 4 weeks of actuals and project a baseline. Adjust for known events:
- Quarter-end is the strongest week of most retail months
- December is 1.5–2× a normal month
- Easter and end-of-Ramadan drive specific verticals
- A planned promotion adds X
- A planned price rise adds Y
Forecast by source, not by total. You’ll get smarter forecasts because each source has its own seasonality.
Step 5 — Forecast the outflows
Most outflows are committed and known. List them by their actual due date:
- Wages — week the wage run hits
- Rent — week the rent hits
- VAT — week the return is due
- Loan — week the instalment is due
- Suppliers — week the supplier’s invoice is due (NOT when you booked the order)
Variable outflows (cost of goods on weekly orders, utilities) get a baseline plus a small contingency.
Step 6 — Look at the closing-cash line
This is the punchline. Read across the 13 weeks. You’re looking for:
- Negative closing balance in any week → action required NOW
- Closing balance below your minimum buffer (typically 4–6 weeks of operating cash) → tighten somewhere
- A consistent week-on-week downward trend → you have a structural problem, not a timing one
If any of these show up, you have time to act because you’re looking 13 weeks ahead. Your options are: accelerate inflows (chase debtors, run a promo), defer outflows (negotiate supplier terms, push a non-essential capex), or raise short-term finance (overdraft, invoice discount, supplier advance).
Step 7 — Update weekly
Every Monday morning (or Friday afternoon, whatever works) take 15 minutes to:
- Replace last week’s forecast row with actuals
- Roll the grid forward by one week — drop the oldest, add a new column 13
- Re-forecast inflows and outflows for the newest column
- Re-read the closing-cash line
That’s the operational rhythm. The forecast is always 13 weeks long; week 1 is always the live week.
When to graduate from a spreadsheet
A 13-week forecast in Excel works fine for a single-location SME with one bank account and one mobile-money wallet. It starts breaking when:
- You have multiple locations consolidating cash
- You have multiple bank accounts in multiple currencies
- You have multiple legal entities sharing some costs
- VAT and PAYE start consuming meaningful spreadsheet time
- Your supplier list is over ~20 active accounts
At that point a proper accounting and ERP platform earns its keep. LettsOS generates this 13-week forecast automatically from your posted transactions and recurring schedules — and updates it after every sale and every supplier payment.
What's next
- M-Pesa setup guide — clean inflow data is the foundation
- Multi-location retail playbook — when one location becomes three
- ROI calculator — quantify what better data gets you
Sign up free or book a 30-minute call with our retail team.