Home › Blog › SME Digital Leadership
SME Digital Leadership

The December–February Cash Squeeze: Building a 13-Week Cash Flow Forecast Before Peak Spending Starts

The December–February Cash Squeeze: Building a 13-Week Cash Flow Forecast Before Peak Spending Starts

For most Singapore SMEs, the 90 days from 1 December to 28 February are the tightest cash period of the year — not because the business is doing badly, but because peak-season stock purchases, pre-Chinese New Year supplier prepayments, AWS and bonus payouts, the GST payment for the October–December quarter and January licence renewals all land inside the same 13 weeks, while the customer receipts that pay for them arrive 30 to 60 days later. The answer is a 13-week rolling cash flow forecast built now, in October, before the first purchase order is committed. Not a budget, not a P&L — a week-by-week view of what leaves the bank account and when.

Why does cash get tight in December even when sales are strong?

Because profit and cash are on different clocks. A strong November and December show up in your profit and loss immediately, but the cash behind those sales lands in January and February if you sell B2B on credit terms, or is partly held back by marketplaces and payment gateways on settlement cycles even if you sell direct.

Meanwhile the spending runs ahead of the selling. You buy stock in October and November for a December peak. You prepay or place deposits with China-based suppliers in November and December because Chinese New Year falls on 17 February 2027 and factories wind down well before it. You pay staff their December salary plus AWS and any discretionary bonus, with employer CPF on top. Every one of those is cash out before the peak receipts are in.

Businesses do not usually fail this period because the total year does not work. They fail it because week seven does not work.

What actually leaves the bank account between December and February?

Build the list before you build the spreadsheet. For a typical Singapore trading, services or e-commerce SME with no finance department, the December-to-February outflows are:

Write each one against the week it actually clears the bank, not the month it belongs to in the accounts. A 31 January GST payment and a 14 January CPF payment are two weeks apart, and that gap is the whole point of the exercise.

How do you build the forecast without an accountant?

Thirteen columns, one per week, starting the week of 1 December 2026 and running to the end of February 2027. Four blocks of rows: opening bank balance, receipts, payments, closing bank balance. The closing balance of one week becomes the opening balance of the next. That is the entire mechanic.

Fill receipts from your actual debtors ageing, not from your sales forecast. Take each open invoice, add the average number of days that customer really takes to pay — not the terms on the invoice — and drop the amount into that week. If a customer has paid at 52 days for the last six invoices, that customer pays at 52 days, whatever the invoice says. For direct or marketplace sales, use the settlement cycle, and be conservative on December volumes.

Fill payments from your creditors ledger, your standing payment schedule and the outflow list above. Then add one row you will be tempted to leave out: a contingency line of 5 to 10 per cent of weekly outflow for the reorder you did not plan, the airfreight upgrade when sea freight slips, and the return or chargeback wave that follows every peak.

Update it every Monday morning with the actual closing bank balance. A forecast that is not re-based against reality weekly becomes fiction by week three.

Which numbers do you need before you can forecast anything?

Four, and if you cannot produce them in an hour, that is the real finding of this exercise:

  1. Current cash position across every bank account, including any amount sitting in payment gateways or marketplace balances.
  2. Debtors ageing with real days-to-pay per customer, not just a 30/60/90 bucket total.
  3. Creditors ageing with committed purchase orders — including orders placed but not yet invoiced, which is where peak-season commitments hide.
  4. Available headroom on overdraft, trade finance or credit lines, and what the drawdown lead time actually is.

If pulling those four together means exporting from three systems and reconciling by hand, you have found your Q1 2027 digitalisation priority — and October is when you can still get that decision signed off and funded.

What do you do when the forecast shows a shortfall in week seven?

You have options in October that you will not have in January, and that asymmetry is why the timing of this work matters more than its sophistication.

Re-sequence rather than cut. Split a large supplier order into two shipments so the second deposit falls after peak receipts land. Ask for 30-day terms on the CNY prepayment in exchange for committing volume earlier — suppliers filling their pre-shutdown production slots have a reason to say yes in October that they will not have in December. Move a January system go-live or a non-urgent renewal out of the squeeze window entirely.

On the receipts side, tighten collections before December, not during it. Send statements in the first week of December, before your customers' own finance staff go on leave, and agree payment dates for your five largest debtors in writing. Arrange any facility headroom now — credit applications assessed in November are assessed on calm numbers and processed by people who are at their desks.

What should you automate before December?

Three things, in this order. First, automated bank feeds into your accounting system, so the Monday re-base takes ten minutes instead of an afternoon of manual entry. Second, automated invoicing and statement runs, so collections do not depend on someone remembering during the busiest fortnight of the year. Third, a scheduled report — debtors ageing, creditors ageing, bank balances — that lands in your inbox every Monday at 8am without anyone building it.

None of that is an ERP project. It is configuration work on systems most SMEs already pay for, and it is the difference between a forecast that survives peak season and one that is abandoned on 12 December.

Frequently asked questions

Is 13 weeks the right horizon, or should I forecast further out?

Thirteen weeks is the working horizon because it is long enough to cover the full December-to-February squeeze and short enough that your assumptions are still credible. Keep a rougher 12-month annual view alongside it for budgeting and grant planning, but make weekly decisions off the 13-week forecast. Roll it forward one week every Monday so the horizon stays at 13.

Do I need to include GST in the cash flow forecast if it is not my money?

Yes. GST collected is cash that sits in your bank account until the payment date, and forecasting on net-of-GST figures is one of the most common ways an SME overestimates available cash. Forecast receipts and payments gross, then show the GST settlement as its own payment line in the week it clears. If you are on GIRO, the deduction date differs from the filing deadline — use the deduction date.

What is the minimum cash buffer I should be holding going into December?

There is no universal figure, but a practical test is whether your forecast closing balance stays above one full month of fixed outflows — payroll, CPF, rent and committed debt service — in every one of the 13 weeks. If any week breaches that line, treat it as a shortfall to fix in October rather than a number to watch nervously in January.

If producing those four numbers took longer than an hour, the forecast is not your problem — the plumbing underneath it is. That is a fixable, fundable Q1 project, and the sign-off window is open now.

Ready to Transform Your Business?

Let Digital Perpetual help you automate, streamline, and grow.

Get Started with Digital Perpetual →
cash flow forecast peak season chinese new year 2027 gst payment aws bonus cpf working capital financial planning