How to make a 13-week cash flow forecast for a Malaysian SME
A week-by-week view of the next three months shows a cash shortfall while there is still time to fix it. Here is how to build one in a spreadsheet in an afternoon.
A 13-week cash flow forecast (ramalan aliran tunai) lists, week by week, the cash a Malaysian business expects to receive and pay over the next three months. Start from today's bank balance, add expected customer payments, subtract salaries, EPF, SOCSO, PCB, SST, CP204, rent and suppliers, and carry the closing balance forward. Update it every week.
Most Malaysian SME owners find out about a cash shortfall the week it happens, when the bank balance won't cover salaries or the 15th-of-the-month EPF payment. A 13-week cash flow forecast (in Bahasa Malaysia, ramalan aliran tunai or unjuran aliran tunai) moves that moment forward by weeks, when you still have options: chase a customer, delay a purchase, or talk to the bank.
This guide builds one step by step for an illustrative Shah Alam workshop, using a plain spreadsheet. No accounting knowledge is needed beyond knowing what you pay and when.
What is a 13-week cash flow forecast?
It is a week-by-week table of the cash you expect to receive and pay over the next quarter, ending in a projected bank balance for each week. Thirteen weeks is one quarter: long enough to see trouble coming, short enough to estimate with reasonable accuracy.
It differs from a budget or a profit and loss statement in one way: it only records cash, on the date it actually moves. An invoice issued this week but paid in six weeks goes in week six.
Why should a Malaysian SME use weekly rather than monthly forecasts?
Because in Malaysia many large payments cluster around a few dates in the month, and a monthly total hides them. Your cash can look fine at month end and still run short in the middle.
Salaries usually go out at month end. EPF, SOCSO, EIS and PCB for the previous month are due by the 15th. Companies paying CP204 tax instalments pay those by the 15th too. Rent is often due on the 1st. A weekly view shows that, say, week 2 and week 4 of every month carry most of your fixed costs.
How do I build a 13-week cash flow forecast step by step?
Work through six steps: set up the weeks, enter opening cash, forecast receipts, list fixed payments by date, add variable payments, then calculate closing cash for each week.
1. Set up 13 weekly columns
Start from the Monday of the current week. Label each column with its dates (for example, 5–11 Oct) so you can see which week contains the 15th and the month end.
2. Enter your opening cash
Use your actual bank balance today, across all business accounts, after a bank reconciliation if possible. Don't include overdraft limits or money you hope to borrow.
3. Forecast customer receipts
Go through your unpaid invoices and place each one in the week you realistically expect payment, based on that customer's past behaviour, not the due date printed on the invoice. Then add expected cash sales and new invoices you are confident of. Be conservative: leave out a big payment you are not sure about.
4. List your fixed payments by date
These are the payments you can predict to the day:
| Payment | Typical timing |
|---|---|
| Net salaries | Month end (your payroll date) |
| EPF, SOCSO, EIS | By the 15th of the following month |
| PCB (monthly tax deduction) | By the 15th of the following month |
| CP204 tax instalment | By the 15th of each month, if your company pays them |
| SST-02 payment | By the last day of the month after each taxable period, if you are SST-registered |
| Rent, loan repayments, hire purchase | Your agreed dates |
For the statutory dates, EPF contributions for September salaries are due by 15 October, and the same rule applies to SOCSO, EIS and PCB. See our guides to SST and corporate tax and CP204 for those dates in detail.
5. Add supplier and other variable payments
Place each supplier bill in the week you plan to pay it, on its due date. Add a weekly allowance for utilities, fuel, small purchases and anything irregular you know is coming, such as an insurance renewal or a year-end bonus.
6. Calculate closing cash
For each week: closing cash = opening cash + receipts − payments. Each week's closing cash becomes the next week's opening cash.
What does a 13-week cash flow forecast look like? A worked RM example
Here is a forecast for an illustrative Shah Alam workshop starting on Monday 5 October 2026, with RM60,000 in the bank. Net salaries are RM38,000 a month, EPF, SOCSO, EIS and PCB together come to RM12,000, its CP204 instalment is RM3,000, rent is RM8,000, and it has RM9,000 of service tax to pay with its SST-02 return on 30 November. Other costs run at RM2,000 a week. All figures are in RM thousands.
| Week | Opening | Receipts | Suppliers | Salaries and statutory | CP204 and SST | Rent and other | Closing |
|---|---|---|---|---|---|---|---|
| 1 (5 Oct) | 60 | 30 | (15) | – | – | (2) | 73 |
| 2 (12 Oct) | 73 | 22 | (12) | (12) | (3) | (2) | 66 |
| 3 (19 Oct) | 66 | 35 | (18) | – | – | (2) | 81 |
| 4 (26 Oct) | 81 | 18 | (10) | (38) | – | (10) | 41 |
| 5 (2 Nov) | 41 | 28 | (14) | – | – | (2) | 53 |
| 6 (9 Nov) | 53 | 20 | (12) | (12) | (3) | (2) | 44 |
| 7 (16 Nov) | 44 | 25 | (16) | – | – | (2) | 51 |
| 8 (23 Nov) | 51 | 30 | (14) | – | – | (2) | 65 |
| 9 (30 Nov) | 65 | 15 | (10) | (38) | (9) | (10) | 13 |
| 10 (7 Dec) | 13 | 32 | (15) | – | – | (2) | 28 |
| 11 (14 Dec) | 28 | 24 | (12) | (12) | (3) | (2) | 23 |
| 12 (21 Dec) | 23 | 18 | (20) | – | – | (2) | 19 |
| 13 (28 Dec) | 19 | 10 | (8) | (38) | – | (10) | (27) |
Two things stand out. Week 9 drops to RM13,000 because November salaries, rent and the SST-02 payment all land in the same week. And week 13 goes RM27,000 negative: December salaries and January rent fall due just as customers slow down for the holidays, while the workshop has stocked up in week 12.
The workshop has twelve weeks to deal with it, which is far better than finding out on 31 December.
How do I update the forecast every week?
Spend 20 to 30 minutes on the same day each week. Replace the forecast for the week just ended with the actual figures, roll the table forward by adding a new week 13, and adjust receipts for anything you have learned.
- Check that last week's closing cash matches the real bank balance. If not, find out why.
- Compare forecast receipts with what actually came in. Move late payments to a later week and note which customers slipped.
- Add new invoices and bills from the past week.
- Add the new week 13 at the end.
Over time, comparing forecast with actual shows you where your estimates are too hopeful, usually customer receipts.
What should I do if my forecast goes negative?
Act on the earliest negative week first, starting with steps that don't cost money: bring receipts forward, then push back or reduce payments that can move, and only then arrange financing.
- Chase overdue invoices and call the customers whose payments the forecast depends on. Our guide to accounts receivable covers how.
- Ask for deposits on new orders, or bill a project in stages.
- Reschedule purchases that are not urgent, such as the week 12 stock order in the example.
- Talk to suppliers about extended terms for a specific bill, before it is due.
- Talk to your bank about an overdraft or short-term facility while the forecast still shows you can repay it.
Do not plan to delay salaries or statutory payments. EPF, SOCSO, PCB, SST and CP204 all carry late-payment charges or penalties.
Where do the numbers for my forecast come from?
From your accounting records: unpaid customer invoices, unpaid supplier bills and your bank balance. The forecast is only as good as those records are current.
In HumbleBear, invoices, bills and payments are in one system, and every invoice's payment status and ageing shows on one listing, which is most of what step 3 needs. Placing each payment in the right week is still your judgement.
Frequently asked questions
What is a cash flow forecast in Bahasa Malaysia?
It is usually called ramalan aliran tunai or unjuran aliran tunai. The method is the same: expected receipts minus expected payments, week by week or month by month.
Can I make a 13-week cash flow forecast in Excel or Google Sheets?
Yes. A spreadsheet with one row per type of receipt or payment and one column per week is enough for most small businesses. Keep formulas simple so anyone in the business can follow them.
How accurate does a cash flow forecast need to be?
It doesn't need to be exact. Its job is to show the weeks when cash gets tight, early enough to act. Be conservative with receipts and complete with payments, and accuracy improves as you compare forecasts with actual results each week.
Should I include SST and CP204 in my cash flow forecast?
Yes, if they apply to your business. Service tax and sales tax collected from customers are not your money, and the SST-02 payment can be large. CP204 instalments are due by the 15th of every month, so leaving them out understates your payments.
What is the difference between a cash flow forecast and a budget?
A budget plans income and expenses for the year, usually month by month and on a profit basis. A cash flow forecast tracks only when cash actually comes in and goes out. Most SMEs benefit from both, but the cash forecast is the one that warns you about a shortfall.
Sources
- KWSP: Employer mandatory contribution (payment by the 15th)
- PERKESO: Frequently asked questions (contributions due by the 15th of the following month)
- LHDN: Employer responsibilities (PCB remitted by the 15th of the following month)
- LHDN: Corporate tax (CP204 instalments by the 15th)
- RMCD MySST: Filing tax returns
