Last reviewed on 16 October 2026.
The short answer
A 13-week cash flow forecast is a weekly, direct-method forecast of cash coming in and going out over the next quarter, rolled forward every week. It shows the weeks where cash will run short while there is still time to act. Build it from bank balances, real customer payment timing and every payment date.
Key facts
- 13 weeks covers one quarter in weekly detail, short enough to be accurate and long enough to act.
- It is built from cash, not from profit, so it catches the gap between the two.
- UAE-specific lines matter: WPS payroll dates, post-dated rent cheques, VAT returns and Corporate Tax payments.
- It only works if someone updates it every week and compares last week’s forecast with what actually happened.
How to build it in five steps
Step 1: Start from actual bank balances
Take the opening balance of every bank account and currency on the first day of the forecast. Do not start from the balance sheet, which includes items that are not cash.
Step 2: Forecast receipts customer by customer
List expected collections by customer and by week. Use how each customer really pays, based on the last few months, not the payment terms on the invoice.
Step 3: Forecast every payment, including the UAE items people forget
Payroll through WPS on its actual date, rent cheques (often post-dated and paid quarterly or annually), supplier runs, VAT returns to the Federal Tax Authority, Corporate Tax due within nine months of the end of the tax period, loan instalments, and licence and visa renewals.
Step 4: Calculate weekly net flow and closing cash
Closing cash for each week becomes the opening cash for the next. Draw a minimum cash buffer line, for example six weeks of fixed costs, and mark every week that falls below it.
Step 5: Run it every Monday
Roll the forecast forward one week, compare last week’s forecast with the actual bank movement, and explain any variance above 10%. The comparison is what makes the forecast more accurate over time.
A worked example in AED
The figures below are illustrative. A services company holds a minimum cash buffer of AED 400,000.
| Week | Receipts (AED) | Payments (AED) | Closing cash (AED) | Status |
|---|---|---|---|---|
| 4 | 310,000 | 295,000 | 520,000 | Above buffer |
| 5 | 180,000 | 240,000 | 460,000 | Above buffer |
| 6 | 150,000 | 350,000 | 260,000 | AED 140,000 below buffer |
| 7 | 330,000 | 210,000 | 380,000 | Below buffer |
| 8 | 290,000 | 200,000 | 470,000 | Above buffer |
Week 6 falls short because an AED 180,000 annual rent cheque and a VAT payment land in the same week as payroll. Seen six weeks ahead, the fixes are simple: bring forward two large collections, agree to split future rent into four cheques with the landlord, and move one equipment order to week 8.
What to do when a week falls below the buffer
- Collections first: call the customers whose payments fall due in the weeks before the gap.
- Timing of payments: agree new dates with suppliers early, before the pressure shows.
- Discretionary spend: delay capital purchases and hiring that are not yet committed.
- Financing: if a gap remains, talk to the bank weeks before you need the facility, with the forecast in hand.
Common mistakes
- Forecasting from the profit and loss account instead of cash.
- Using invoice terms instead of how customers actually pay.
- Ignoring VAT and Corporate Tax timing.
- Running a single scenario with no downside case.
- Building the forecast once and never updating it.
How AIONSE helps
AIONSE builds and runs 13-week cash flow forecasts as part of its fractional CFO service in Dubai and across the GCC, and can automate the weekly update from your bank and accounting data.
Frequently asked questions
What is a 13-week cash flow forecast?
A weekly forecast of cash receipts and payments over the next 13 weeks, built with the direct method and rolled forward every week, used to spot cash shortfalls early enough to act.
Why 13 weeks?
Thirteen weeks is one quarter. It is short enough to forecast each customer receipt and supplier payment with reasonable accuracy, and long enough to fix a gap before it arrives.
What UAE items should a cash flow forecast include?
WPS payroll dates, post-dated rent cheques, VAT returns, Corporate Tax payments due within nine months of the end of the tax period, loan instalments, and trade licence and visa renewals.
How often should the forecast be updated?
Every week. Each update adds a new week at the end and compares last week’s forecast with the actual bank movement.
Templates from the AIONSE Toolkit
- Sales Pipeline Tracker: an Excel workbook for a weighted pipeline and forecast, so expected receipts rest on real deals.