The profit and loss account tells you whether the agency made money last month. It does not tell you whether there will be enough in the bank on the day salaries are due. The two can disagree for months, and the gap between them is usually a handful of clients who pay later than their terms, landing in the same weeks as rent and VAT.
A 13-week forecast is the simplest tool for seeing that gap before it arrives. Thirteen weeks is a quarter: long enough to include a full VAT cycle and three payrolls, short enough that the numbers are estimates rather than guesses. Weekly rather than monthly, because cash problems happen in particular weeks, not on average.
Start with the cash you actually have
The opening figure is the balance in the bank today, across every account the agency uses. Not the balance you expect after a client pays, and not the figure in the accounts from last month. If some of that balance is a client's money held for media or creator payments, take it out, because it is already spoken for.
Receipts: when clients really pay
List every invoice that is sent and unpaid, and every invoice you will send in the next thirteen weeks. For each one, put it in the week you expect the money to arrive, based on how that client actually pays, not on the terms printed on the invoice. A client on 30 day terms who has paid in 60 days for the last three months goes in at 60.
Include the VAT in each receipt, because the client pays the full amount into your account. Then remember that the VAT part is not yours. It is collected on behalf of the Federal Tax Authority and leaves again when the return is due.
Payments: the fixed dates first
Put in the payments that happen whatever else changes, on the dates they fall.
- Payroll, in the week salaries are paid, including any allowances that are paid with them.
- Rent, on the dates the cheques fall. Office rent in the UAE is often paid by post-dated cheques, so a quarterly or twice-yearly cheque can land as one large payment.
- VAT. Returns are usually quarterly, and the return and any payment are generally due within 28 days of the end of the tax period. Put the net VAT for the last quarter in the week it is due.
- Recurring costs: software, phones, insurance, freelancers on retainer.
- Annual and one-off costs that fall in the window: licence renewal, visa renewals, equipment. Corporate tax, if due, is paid within nine months of the end of the tax period, so check whether that date falls inside the thirteen weeks.
This is general information, not tax advice. Check your own VAT periods and deadlines with your tax agent and the FTA, because not every agency's quarter lines up with the calendar.
A worked example
The figures below are an illustration, not a benchmark. Picture a small agency with three retainer clients, invoiced on the first of each month. Client A pays AED 50,000 plus VAT, so AED 52,500 arrives in week 2, 6 and 10. Client B pays AED 40,000 plus VAT, AED 42,000, in weeks 1, 5 and 9. Client C pays AED 30,000 plus VAT, AED 31,500, in weeks 3, 7 and 11.
On the other side: payroll of AED 90,000 in weeks 4, 8 and 12; a rent cheque of AED 30,000 in week 6; other monthly costs of AED 7,000 in weeks 1, 5, 9 and 13; and net VAT of AED 17,000 for the previous quarter, due in week 4. The agency starts with AED 60,000 in the bank.
- Week 1: in 42,000, out 7,000. Closing balance AED 95,000.
- Week 2: in 52,500. Closing AED 147,500.
- Week 3: in 31,500. Closing AED 179,000.
- Week 4: out 90,000 payroll and 17,000 VAT. Closing AED 72,000.
- Week 5: in 42,000, out 7,000. Closing AED 107,000.
- Week 6: in 52,500, out 30,000 rent. Closing AED 129,500.
- Week 7: in 31,500. Closing AED 161,000.
- Week 8: out 90,000 payroll. Closing AED 71,000.
- Weeks 9 to 12: in 126,000, out 97,000. Closing AED 100,000.
- Week 13: out 7,000. Closing AED 93,000.
On paper, the quarter looks comfortable. The agency ends with more than it started, and the lowest balance is AED 71,000. Notice, though, that the receipts in this window include AED 18,000 of VAT that belongs in the next return, so part of that closing balance is already owed.
Test the weeks that could break
The forecast earns its keep when you change one assumption. Suppose Client B, from week 5, starts paying a month later. The quarter's total does not change: the same three payments arrive, just later. But the week 5 payment moves to week 9, and the balance after payroll in week 8 falls from AED 71,000 to AED 29,000.
Most agency cash problems are not about how much money comes in. They are about which week it arrives in.
That is the value of weekly figures. A monthly view of the same agency would show nothing wrong. The weekly view shows the one Thursday in the quarter when a single late client and a payroll meet.
What to do when a week looks thin
A forecast that shows a problem six weeks away gives you options that a bank balance on the day does not.
- Chase the invoices that fall before the thin week, early and by name.
- Ask for a deposit on any new project that starts before it.
- Move invoice dates so they match the client's payment run.
- Talk to suppliers about timing before the date, not after it.
- Hold discretionary spending, such as equipment, until after the week has passed.
Keep it rolling every week
Update the forecast once a week, at the same time. Replace last week's estimates with what actually happened, add a new week at the end, and note any receipt that moved and why. After a month or two, the pattern of which clients pay when becomes the most reliable input you have.
The receipts side is only as good as the invoicing behind it. Wiro's finance screen lists the invoices to chase, overdue first, and its VAT report shows the net VAT payable for the period, which are the two lines most forecasts get wrong. If you are not ready for software, the free invoice generator lays out a UAE tax invoice so the ones you send are paid on the first attempt.
