A 13-week cash flow forecast for a small UAE business

A business can have a good year on paper and still face an anxious week before payroll. The accounts say things are going well. The bank balance, on one particular Wednesday, says otherwise. Profit measures whether you earned money over a period. Cash measures whether the money is in the account on the day a payment leaves it. For a business that bills its clients, the gap between the two usually comes down to a few late payers whose money lands in the same weeks as the rent and the VAT.

Why thirteen weeks, and why weekly

A 13-week forecast covers exactly one quarter. That is enough to capture a full VAT cycle and three payroll runs, yet near enough that every line is an informed estimate rather than wishful thinking. The weekly columns matter as much as the time span: a monthly view averages away the short, sharp shortfalls you are trying to find.

Step one: the cash that is genuinely yours

Open with today's balance, summed across all of the business's bank accounts. Resist using the figure you will have once a large invoice clears, or the number from last month's management accounts. And if any of the balance is money held for a client, say to pay media or creators on their behalf, strip it out. That money is spoken for.

Step two: receipts, dated by habit rather than terms

Now list every unpaid invoice already issued, plus every invoice you plan to raise in the next thirteen weeks. The skill is in the dating. Put each receipt in the week you genuinely expect the cash, based on the client's track record. A client whose invoices say 30 days but who has settled at 60 days three months running belongs at 60.

Record receipts at their VAT-inclusive value, since that is what the client transfers. Remember, though, that the VAT slice is not yours to spend. You are collecting it on behalf of the Federal Tax Authority, and it goes back out when the return is due.

Step three: the outgoings that will not move

Next, add the payments that are certain, in the week each one falls.

• Salaries, in the week they are paid, with any allowances that go out at the same time.
• Rent, on each cheque date. Office rent in the UAE is often paid by post-dated cheques, which means a quarterly or twice-yearly cheque can arrive as one large payment.
• VAT, usually on a quarterly cycle. The return and any payment are generally due within 28 days of the end of the tax period, so place last quarter's net VAT in its due week.
• Recurring running costs: software subscriptions, phones, insurance, freelancers on retainer.
• Annual or one-off costs landing in the window, such as the licence renewal, visa renewals or equipment. Corporate tax, if due, is paid within nine months of the end of the tax period, so check whether that date sits within your thirteen weeks.

None of this is tax advice. Not every business has VAT periods that follow the calendar quarters, so confirm your own periods and due dates with your tax agent and the FTA.

A worked quarter

What follows is an illustration, not a benchmark. A small services firm has three clients on monthly retainers, all invoiced on the first of the month. Client A's fee is AED 50,000 plus VAT, so AED 52,500 lands in weeks 2, 6 and 10. Client B's is AED 40,000 plus VAT, so AED 42,000 arrives in weeks 1, 5 and 9. Client C's is AED 30,000 plus VAT, so AED 31,500 comes in during weeks 3, 7 and 11.

On the other side of the ledger: AED 90,000 of payroll in weeks 4, 8 and 12, a AED 30,000 rent cheque in week 6, AED 7,000 of other monthly costs in weeks 1, 5, 9 and 13, and AED 17,000 of net VAT from the previous quarter, due in week 4. The opening balance is AED 60,000.

• Week 1: AED 42,000 in, AED 7,000 out. Balance AED 95,000.
• Week 2: AED 52,500 in. Balance AED 147,500.
• Week 3: AED 31,500 in. Balance AED 179,000.
• Week 4: AED 90,000 payroll and AED 17,000 VAT out. Balance AED 72,000.
• Week 5: AED 42,000 in, AED 7,000 out. Balance AED 107,000.
• Week 6: AED 52,500 in, AED 30,000 rent out. Balance AED 129,500.
• Week 7: AED 31,500 in. Balance AED 161,000.
• Week 8: AED 90,000 payroll out. Balance AED 71,000.
• Weeks 9 to 12: AED 126,000 in, AED 97,000 out. Balance AED 100,000.
• Week 13: AED 7,000 out. Balance AED 93,000.

At a glance, a comfortable quarter. The firm finishes with more than it started with, and its lowest point is AED 71,000. Look closer, though. Across these weeks it has collected AED 18,000 of VAT that belongs in the next return, so a slice of that closing balance is already owed.

The what-if that matters

The forecast really pays for itself when you test a single change. Suppose that from week 5, Client B starts paying a month later. Over the quarter the total is unchanged, since all three payments still arrive, only later. But the week 5 payment slides to week 9, and the balance after the week 8 payroll falls from AED 71,000 to AED 29,000.

Cash trouble is rarely about how much comes in. It is about which week it comes in.

A month-by-month view of this firm would show nothing alarming. The weekly view picks out the one Thursday of the quarter when a late client and a payroll meet.

What six weeks of warning buys you

Spotting a tight week well in advance gives you room that a same-day bank balance never does.

• Chase the invoices due before the tight week early, with a named person on each.
• Request a deposit on any new work that starts before it.
• Time your invoices to fall in step with each client's payment run.
• Talk to suppliers about timing before the due date, not after it.
• Delay discretionary purchases, such as equipment, until the week has passed.

Keep it rolling

Update the forecast at the same point every week. Replace last week's estimates with actual figures, add a new week at the end, and note which receipts moved and why. Within a month or two, that record of when each client really pays becomes the most reliable input you have.

The forecast inherits every weakness in your invoicing. The two lines most often wrong are the invoices to chase, which should be listed overdue first, and the net VAT payable for the period, so give both proper attention. Sending a correct UAE tax invoice from the outset helps as well, because an invoice that is paid first time never needs re-forecasting.

If your invoicing and payment reminders still live in memory and spreadsheets, that is usually the best place to begin. Talk to ALXO about which parts of that routine could be automated, so your forecast starts each week from figures you can rely on.