Cash flow forecasting Singapore SMEs actually rely on looks very different from the theoretical version, and it’s one of the most underused pieces of financial infrastructure in the local SME sector. Profitable businesses fail because they run out of cash, not because they’re unprofitable. They simply don’t see the crunch coming in time to do anything about it. This guide explains how to build a forecast that’s actually useful, not just a spreadsheet that gets ignored.
Why a P&L isn’t enough
A profit and loss statement tells you whether you made money over a period. It doesn’t tell you when cash arrives and leaves your bank account, which is a different question entirely.
A client who owes you S$100,000 appears as revenue on your P&L the moment you invoice them. But if they pay on 60-day terms, that cash doesn’t hit your account for two months. Meanwhile, you’re paying staff this week, rent next week, and suppliers by end of month. The gap between recognising revenue and receiving cash is where growing businesses get into trouble.
Cash flow forecasting Singapore: the 13-week rolling model
The most practical format for SME cash flow forecasting is a 13-week rolling model. Thirteen weeks is long enough to be useful for planning, short enough that the numbers remain reasonably reliable. “Rolling” means you update it every week by dropping off the week just passed and adding a new week at the end.
Cash inflows:
- Expected customer payments (not invoices issued: actual cash expected based on payment terms and customer behaviour)
- Any other cash coming in: loans, asset sales, tax refunds
Cash outflows:
- Payroll (date-specific, you know when salaries hit)
- CPF contributions (due by 14th of the following month, per CPF Board requirements)
- Rent and fixed overheads (date-specific)
- Supplier payments (based on your payment terms and current payables)
- Tax payments: GST quarterly, ECI, corporate tax
- Loan repayments and planned capital expenditure
Each week shows opening cash, total inflows, total outflows, and closing cash. Run it forward 13 weeks and you can see exactly when your cash gets tight — or when you’ll have surplus you can put to work.
Common mistakes that make forecasts useless
Using invoice dates instead of payment dates
The most common error. Your forecast needs to reflect when cash actually arrives, not when you raised the invoice. If a customer pays 45 days late on average, model that.
Not separating committed from expected outflows
Some outflows are fixed and certain e.g. payroll, rent, loan repayments. Others are variable or discretionary. Keeping these separate helps you understand your minimum cash burn versus normal operating burn.
Building it once and never updating it
A forecast that’s two months old is nearly worthless. The discipline of updating weekly is what makes it useful. Each week, compare actual cash movements against what you forecast. The variances tell you where your assumptions need adjusting.
Making it too complicated
A 13-week cash forecast doesn’t need to be a 40-tab spreadsheet. If you can’t update it in 30 minutes a week, it’s too complicated and you’ll stop doing it.
Scenario planning
The real value of a cash flow forecast isn’t the base case. It’s understanding what happens when things don’t go to plan. Build at least two scenarios alongside your base case:
- Downside scenario: What if your two largest clients slow their payments by 30 days? What if you lose a contract that’s currently in the base case?
- Upside scenario: What if that large proposal converts next month? You’ll need to hire and buy inventory ahead of the revenue — what does the cash requirement look like?
Scenario planning tells you how much buffer you need and where your real vulnerabilities are. It’s also useful for conversations with your bank — showing a cash flow model and scenarios is a sign of financial maturity that improves your credit relationship.
Linking the forecast to decisions
Before you take on a large contract: model the working capital impact. Before you hire a batch of people: model the additional payroll cost against your revenue trajectory. Before you offer a client better payment terms: model the cash flow impact. These aren’t complicated calculations, but they require someone who’s thinking about finance rather than just recording it.
When to get help
If your business has predictable, simple cash flows, you can maintain a basic forecast in a spreadsheet. If your business has multiple revenue streams, variable payment terms, or significant capital expenditure, a simple spreadsheet will miss things. Running out of cash with two weeks’ notice is a crisis. Seeing it coming eight weeks away is a problem you can solve.
Maintaining the cash flow model and running scenario analysis is one of the core deliverables of our CFO as a Service Singapore engagement. If your business has reached the point where a spreadsheet isn’t enough — or where nobody is maintaining the model consistently — that’s typically where an outsourced CFO adds the clearest, most immediate value.
