How to Build a 13-Week Cash Flow Forecast for Your SME

Most SMEs don't run out of profit. They run out of cash, usually in a week they could have seen coming. A 13-week cash flow forecast is the simplest tool for spotting that week early, and you can build a working one in an afternoon.

Why 13 weeks, and why weekly

Thirteen weeks is one quarter. It is long enough to see a quarterly tax payment, a large supplier bill or a slow-paying customer coming, and short enough that you can forecast it with real invoices rather than guesses.

Monthly forecasts hide the problem. If salaries leave on the 3rd and your biggest customer pays on the 25th, a monthly view shows you as fine. A weekly view shows you three weeks in the red.

The golden rule: this is a cash forecast, not a profit forecast. Record money when it actually lands in or leaves the bank, not when the invoice is raised.

How to build it, step by step

1. Start with the real bank balance. Take today's closing balance across all operating accounts. If you hold several currencies, convert at a sensible rate and note it. Never start from the ledger balance, which may include uncleared cheques.

2. List receipts customer by customer. Take your receivables ageing and give each invoice a realistic receipt week. Use each customer's actual payment behaviour, not their contract terms. If a customer on 30-day terms usually pays in 70 days, forecast 70.

3. Add other cash in. Include new sales you are confident about (booked orders, retainers), advances, loan drawdowns and any refunds due. Be cautious here; optimism in the receipts line is a common reason forecasts fail.

4. Map the fixed outflows first. Salaries, rent, loan instalments, insurance and subscriptions go in on their exact dates. These are the payments you cannot move, so they set the floor.

5. Then add supplier payments. Take your payables ageing and place each bill in the week you intend to pay it. Add tax payments on their due dates, plus any one-off items such as visa renewals, annual licence fees or end-of-service settlements.

6. Calculate the running balance. Opening balance plus receipts minus payments gives the closing balance, which becomes next week's opening balance. Mark any week that falls below your minimum comfortable cushion.

7. Roll it every week. At the start of each week, replace last week's forecast with actuals, add a new week 13 at the end, and note why the biggest differences happened. After a month or two, you will know which lines you consistently get wrong.

What this means for your business in the GCC and India

Two rules, one brand new, make weekly cash planning more important for businesses in this region.

Qatar: salary dates are now fixed by law. Under Minister of Labour Decision No. (50) of 2026, published in the Official Gazette on 8 September 2026, wages for monthly-paid workers are due on the first day of each calendar month, and employers must transfer them through the Wage Protection System within seven days of that date. Workers paid on other terms are due every two weeks. The change took effect on 9 September 2026 and replaced the earlier approach, where the deadline ran from the employer's own contractual pay date.

In practical terms, if your payroll used to go out mid-month to match customer receipts, that flexibility has gone. Your largest fixed payment now sits in the first week of every month, and your forecast should show it there.

India: slow payment to small suppliers now costs tax. Under Section 43B(h) of the Income-tax Act, applying from 1 April 2024, payments to micro and small enterprises registered under the MSMED Act must be made within 15 days if there is no written agreement, or within the agreed period up to a maximum of 45 days. If you pay later, the expense is only deductible in the year you actually pay. The rule covers manufacturers and service providers, not traders.

So stretching MSE suppliers to protect your own cash can push up your tax bill. Flag these suppliers in your payables list and plan their payments within the limit. Check with your adviser how the rule applies to your suppliers and under the latest tax law.

For example, a Doha contracting company with QAR 400,000 of monthly payroll might find its forecast dips below its safety cushion in the first week of every month, while customer receipts cluster around the 20th. Seeing that pattern 10 weeks ahead gives it time to agree an overdraft limit, bring collections forward or move a supplier run, rather than scrambling on the 5th.

Your checklist for this week

• Pull today's bank balances across all operating accounts.
• Export your receivables and payables ageing reports.
• Set up 13 weekly columns, starting from the first day of next week.
• Forecast each customer's receipts on actual payment behaviour, not terms.
• Put payroll, rent, loan instalments and tax dates in first.
• In Qatar, place salaries within seven days of the 1st of each month.
• In India, tag MSE suppliers and schedule them within 15 or 45 days.
• Set a minimum cash cushion and highlight any week below it.
• Book a 20-minute review at the start of each week to roll the forecast forward.

If you would rather not rebuild the spreadsheet each week, NexCFO's 13-week cash forecasting can take the weekly roll-forward off your plate.

Cash surprises are rarely surprises; they are just weeks nobody looked at in advance.