How to build a cash flow forecast for a small business in the UAE

Thirteen weeks is a quarter: long enough to see a VAT payment, a rent cheque and a slow month coming, short enough to forecast with reasonable accuracy. Weekly columns matter because cash crunches happen in specific weeks. A monthly forecast can show a healthy month-end balance while hiding a week in the middle where you are AED 80,000 short.

Our point of view: every UAE business with more than ten staff or more than AED 3 million of annual revenue should run a weekly forecast. Below that size, a monthly forecast plus a payroll-week check may be enough.

Start with today’s actual bank balance across all accounts. Then list expected receipts by week, based on the AR ageing and each customer’s real payment habits, not their terms. Then list payments: payroll, rent, supplier bills by due date, loan instalments, PDCs issued, and the fixed UAE dates that often get forgotten.

• Payroll: salaries are due on the first day of the following month under the wage rules on u.ae
• VAT: returns and payment due 28 days after each tax period ends
• Corporate tax: return and payment within nine months of the year end
• Rent cheques, trade licence renewal, visa and Emirates ID renewals
• Insurance premiums, annual software licences and audit fees

A Dubai interiors firm starts week 1 with AED 210,000 in the bank. Weekly receipts average AED 95,000. Weekly supplier and overhead payments average AED 70,000. Payroll of AED 185,000 goes out in week 5. The Q3 VAT payment of AED 62,000 is due in week 4, and a AED 90,000 rent cheque clears in week 5.

Week 4 closing balance: 210,000 + 4 × 25,000 − 62,000 = AED 248,000. Week 5: 248,000 + 25,000 − 185,000 − 90,000 = AED −2,000. The business is profitable, yet the forecast shows it overdrawn in week 5. With five weeks’ notice, the owner can chase two large invoices, ask the landlord to move the cheque date by a week, or arrange a small facility before it is urgent.

Each week, replace the oldest week’s forecast with actuals, add a new week 13, and compare forecast to actual for the week just gone. If receipts keep coming in 20% below forecast, your assumptions about customer payment are too optimistic; adjust them.

Use realistic, not hopeful, collection dates. If a customer has paid in 65 days for the last year on 30-day terms, forecast 65 days.

A forecast is only as good as its inputs. HelloBooks holds open invoices with due dates, open bills with due dates, recurring entries for rent and loan instalments, and the bank balance from your latest statement upload. The cash flow report shows actual movements; the AI agent can project receipts and payments by week from that same data.

Ask “what will our bank balance look like in each of the next eight weeks if Al Mansoori pays 30 days late?” and the agent works it through from open items, showing its assumptions. You still decide what goes into the board pack. Partner firms that want a weekly cash report in their own format for clients can request it by booking a call at /book-a-demo.