The 13-Week Cash Flow Forecast — The Turnaround Profession's Standard Tool, and Why Thai SMEs Should Have One Before They Need It

This article covers internal financial-planning principles. It is not accounting, tax, legal, or investment advice.

This tool was born in rooms where businesses were about to fail

When a turnaround adviser walks into a company in difficulty, the first thing they ask for is usually not the financial statements or the sales report. It is the 13-week cash flow forecast — and if the company does not have one, building it is the first job of the first week, before anything else.

One of the most cited texts in the field, Corporate Turnaround (Slatter & Lovett, 1999), gives the reason plainly: businesses do not die of losses, they die because the money runs out on a day when a payment is due — and standard financial statements never say in advance which day that is.

The more interesting question is why wait for that room at all. The same instrument in the hands of a healthy business is not a resuscitation device; it is what keeps you out of that room entirely.

Profit and cash are different numbers, and it is the second one that kills

Everyone has heard the phrase. Far fewer people have seen the mechanism laid out. Take one month at an ordinary trading business.

Invoices issued: 3 million baht. Cost of goods: 2.2 million. Other expenses: 400,000 — a profit of 400,000 baht for the month. On paper, an excellent month.

The cash line runs elsewhere. The 2.2 million of goods came on 30-day supplier credit, payable next month. Payroll goes out at the end of this month. Customers are on 60-day terms, so the 3 million arrives two months from now. And if next month is bigger, you buy more goods, pay more labour, and wait exactly as long to collect.

Growth consumes cash. Accounting profit can rise every month while the bank balance falls every week, quite comfortably. This is not an edge case; it is the standard shape of a fast-growing business hitting a wall.

Why weekly — because monthly hides the problem in an average

Suppose next month brings in 2.5 million and pays out 2.3 million. Monthly, that looks comfortable: 200,000 to spare.

Break it into weeks and the picture changes. The largest receipt, 1.8 million, arrives on the customer's 25th-of-the-month payment run, while payroll, rent, social security and VAT all cluster between the 1st and the 15th. Week 2 is the week the money is not there — even though the month as a whole is positive.

A monthly average never reveals this, and in practice creditors do not wait for averages, employees do not wait for averages, and the Revenue Department does not wait for averages.

Go finer still, to daily, and the maintenance burden becomes high enough that nobody sustains it past two weeks. Weekly is where resolution and sustainable discipline meet — and thirteen weeks is exactly one quarter, long enough that inexpensive options still exist.

Direct method: follow the actual money, do not adjust from profit

The statement of cash flows most accountants prepare uses the indirect method — start from net profit, add back depreciation, adjust for movements in receivables and payables, and arrive at net cash. Correct for reporting, useless for planning, because it cannot answer whether there is money to pay for goods next Thursday.

A 13-week forecast uses the direct method: this invoice, this customer, expected on this date, this amount; this payment, due on this date. Accounting profit is never touched, not on a single line.

An important side effect is that anyone can audit it. An owner who never studied accounting can point at a line and ask "are we sure that one lands that week?" — something no indirect-method report allows.

Negative is not the same as dead: where imported templates misread Thailand

Cash flow templates from abroad usually carry a single red flag: closing balance below zero. Applied directly to a Thai SME, this is wrong, because a great many Thai businesses run on an overdraft facility as ordinary working capital. Dipping 200,000 baht negative mid-month and recovering by month end is daily life, not an emergency.

Three states genuinely need to be distinguished:

1. Below the minimum cash line you set — still positive, but too thin to absorb anything unexpected.
2. Negative, drawing on the overdraft — carries interest, deserves attention, but is a financial instrument being used deliberately.
3. Negative beyond the approved overdraft limit — the real crisis, because it means bounced cheques, collapsed supplier credit, and damaged banking relationships all at once.

A forecast with only one alarm will startle the owner with state 2 every single month until they stop looking — and so they miss the month it genuinely becomes state 3.

The endurance test: "if customers pay two weeks later than expected, which week do we run dry?"

A forecast filled in with hope is worth no more than no forecast, because everyone enters the payment dates they wish for.

A usable tool therefore needs two things.

Confidence weighting. Money a customer has not confirmed should not count at full value. An invoice against a signed purchase order and one still "under consideration" should not carry equal weight in a plan.

A whole-board delay switch. One control that pushes every expected receipt one, two, or three weeks later, so you can see which week the red light appears. This is the single most important question in the file, because its answer changes today's decisions: if the answer is week 9, there are eight weeks to negotiate; if the answer is week 3, the large customer needs a phone call this afternoon.

Thailand's recurring payments have timing rules generic templates do not know

The fixed outgoings of a Thai business follow holiday logic that deliberately runs in opposite directions — and this is where generic templates always get it wrong.

• Payroll and rent, when the due date falls on a public holiday or a weekend, are by Thai employer custom paid early, not deferred — nobody makes staff wait for wages across a long holiday.
• Social security contributions and VAT returns (Form PP.30), when the deadline falls on a holiday, move later, to the next working day, per the filing rules.

Two opposite directions. A forecast applying one rule to both groups will place money in the wrong week every time a long holiday comes around — which, on the Thai calendar, happens several times a year.

The most-skipped part, and the one that is actually the product: weekly actual versus forecast

A cash forecast built once and never revisited drifts quietly away from reality until the week arrives when nobody in the business believes it.

The discipline that separates this instrument from an ordinary spreadsheet is weekly reforecasting: every Monday, enter last week's actual figures beside what had been forecast, and look at the variance.

That variance is not there to make anyone feel guilty; it is data. If one customer runs three weeks late three times in a row, that is not coincidence — that is that customer's real credit term, as distinct from the one written in the contract. Knowing it changes both your pricing and your decision on the next job from them.

The tool that does all of this in one file

13-Week Cash Flow Forecast is an Excel file built from everything in this article. Enter invoices and payments as rows and the file converts every date into a week number itself, then assembles a live-calculating 13-week plan · net receipts computed with withholding tax taken on the pre-VAT base · confidence weighting for money customers have not yet confirmed · a test switch that delays every expected receipt at once · four recurring outgoings (payroll, rent, social security, PP.30 VAT) that know the Thai public holiday calendar and shift in opposite directions according to actual local practice · input-VAT credit carried across months · warning lights tiered from below-minimum-cash through overdraft use to breaching the overdraft limit · and an actual-versus-forecast sheet that enforces the weekly reforecasting discipline — plus a 48-case live self-test sheet that computes in front of you. One purchase includes both the Thai edition and the English (Thailand) edition.

→ See the product