Financial Planning

Cash Flow Forecasting on Xero in Singapore and Malaysia

Kevin Brown
FP&AXeroSingaporeMalaysiacash flow

If you run Xero in Singapore or Malaysia and want to see your cash position forward, you have real options. Xero has forecasting built in, and several dedicated add-ons are available in both markets, including tools that will project your bank balance up to three years ahead and update daily.

They work. It is worth being clear about what they do and what they do not, because the distinction catches people out at exactly the wrong moment.

What the cash flow tools do well

They take your existing invoices, bills and recurring transactions and project them forward. Money you are owed with due dates, money you owe with due dates, standing costs.

For a business with an accounts receivable problem this is genuinely valuable. It shows you the week where three large invoices are late and payroll is due. It is a working capital tool and for the businesses that need one, it earns its subscription.

Setup is fast, it updates from your ledger automatically, and it requires no modelling skill. Those are real advantages and I would not talk anyone out of using one.

The limit, stated plainly

A cash flow forecast projects what is already committed. It cannot project what you are considering.

Everything in that projection derives from documents that already exist in your ledger. An invoice you have raised. A bill you have received. A recurring payment already set up.

Which means the moment your question involves something that has not happened yet, the tool is silent.

The questions it cannot answer

These are the ones founders actually have, and none of them are answerable from a receivables projection.

If we hire two engineers in March instead of June, when do we run out of cash? No invoice exists. No bill exists. There is nothing in your ledger to project.

If we increase paid search by fifty percent, does the revenue arrive before the cash runs out? Requires modelling a conversion rate and a sales cycle, neither of which lives in an accounting system.

What happens if the round slips a quarter? Requires a scenario, and a scenario is not a projection of committed items.

Are we on plan? Requires a plan. Your ledger has never contained one.

Is our CAC acceptable? Requires knowing which costs are acquisition costs and how many customers they produced. Your chart of accounts has one marketing line.

That last pair is the real gap. A cash flow tool tells you what will happen if nothing changes. Founders almost never ask that question, because something is always about to change.

The regional wrinkle

Two things specific to running this from Singapore or Malaysia.

Statutory employer costs. If you model a hire anywhere, that hire costs salary plus roughly 13 percent EPF before SOCSO and EIS in Malaysia, or roughly 17 percent CPF for a local employee in Singapore. Tools built for other markets either ignore this or make you hand-load it. Across a twelve-person plan that gap is larger than a month of runway.

Multi-currency. You bill in USD, pay salaries in local currency, and report to an investor in USD. Most cash flow add-ons handle this thinly, and the ones that handle it properly are priced for larger companies.

What to run alongside

The arrangement that works is two things doing two jobs, not one thing doing both badly.

Keep the cash flow tool for working capital. Late invoices, payment timing, the specific Thursday when things get tight. It is good at this.

Then run a driver-based forecast for decisions. Revenue built from leads and conversion rather than from existing invoices. Costs organised by initiative with an expected outcome recorded against each. Headcount with real statutory on-costs and a ramp. Scenarios, so that base, conservative and optimistic sit side by side rather than being three separate files.

And the connection matters more than either. If your actuals do not land in the forecast automatically, you will reconcile twice and then stop, and the forecast will be stale by the time it matters.

How to tell which one you need

If your problem is that customers pay late and you are managing week to week, buy the cash flow tool. It is cheaper and it is aimed at you.

If your problem is that you cannot tell whether a decision is affordable until after you have made it, no cash flow tool will help, because the thing you are asking about does not exist in your ledger yet.

Most growing companies eventually need both, and the mistake is buying the first and assuming it covers the second.

See how a driver-based forecast works

Keep reading