How to Prepare Cashflow Forecasts in the UAE

A profitable UAE business can still face a cash shortfall. The usual cause is timing: customers pay after costs, salaries, VAT and supplier commitments fall due. Knowing how to prepare a cashflow forecast gives founders and finance teams early warning, so they can collect faster, adjust spending or arrange funding before pressure becomes a problem.

A useful forecast is not a static spreadsheet prepared for a bank and then ignored. It is a decision-making tool, updated against actual bank balances and used to plan the next commercial move. For many businesses, that means looking closely at the next 13 weeks while maintaining a monthly view for the rest of the financial year.

Start with the right purpose and timeframe

First decide what the forecast needs to answer. A start-up may need to know whether it can fund payroll and launch costs. An established trading business may be assessing whether it can take on a large contract, open a new location or tolerate slower customer collections. A real estate business may need to map commission receipts against fixed overheads and regulatory costs.

The purpose determines the level of detail. A weekly forecast is normally best for the next three months because it highlights precisely when cash is expected to enter and leave the bank. A monthly forecast is usually sufficient for the following nine to 12 months, where the aim is to plan growth, tax payments, capital expenditure and funding requirements.

Use the opening bank balance that is actually available to the business. Do not include undrawn facilities, shareholder funds that have not been agreed, or invoices that have not yet been collected as if they were cash. If the business has separate AED, USD, GBP or other currency accounts, forecast each material currency separately or clearly state the exchange-rate assumption.

How to prepare a cashflow forecast from real records

The most dependable starting point is clean bookkeeping. Your bank reconciliations should be current, sales invoices should show accurate due dates, supplier bills must be entered promptly, and payroll liabilities should be known. A forecast built on incomplete records may look detailed, but it will not be dependable.

Begin with the opening cash balance, then add expected cash receipts and subtract expected payments for each week or month. The closing balance for one period becomes the opening balance for the next. The core calculation is straightforward:

Opening cash + cash received - cash paid = closing cash

What makes forecasting valuable is the judgement behind each line. Revenue in the profit and loss account is not the same as cash received. If an AED 100,000 invoice is issued in September but the customer normally pays 60 days later, the cash belongs in November, not September. The same principle applies to costs: record them when payment is expected, rather than when the supplier invoice is dated.

Forecast cash receipts by collection date

List outstanding customer invoices individually when they are significant. Use their contractual payment dates, but adjust those dates for the customer’s actual payment behaviour. A client with 30-day terms who routinely pays after 50 days should not be forecast at day 30 merely because that produces a more attractive result.

For recurring income, use signed contracts, confirmed orders and established customer patterns. Pipeline opportunities can be included in a separate upside scenario, but should not be relied upon to fund essential commitments until the likelihood and timing are credible.

Include other expected receipts where relevant, such as shareholder loans, VAT refunds, bank interest, asset-sale proceeds or approved financing drawdowns. Keep these distinct from operating receipts. This makes it easier to see whether the business is generating enough cash from normal trading.

Forecast every material cash payment

Fixed costs are usually easier to forecast: salaries, rent, software subscriptions, insurance, loan repayments and regular professional fees. Variable costs require more care. Link inventory purchases, subcontractor costs, sales commissions and delivery expenses to the sales activity that will trigger them, while allowing for supplier credit terms.

Your forecast should also account for items that are often missed because they do not appear as routine operating expenses:

• VAT liabilities or expected VAT refunds, based on the relevant tax period and filing position.

• UAE corporate tax payments, normally due within nine months of the end of the applicable tax period, subject to the business’s circumstances and current rules.

• Payroll, gratuity provisions where payments are expected, visa renewals and other employment-related costs.

• Loan principal repayments, finance charges, owner drawings, dividends and capital purchases.

VAT deserves particular attention. VAT collected from customers is not operating cash that can safely be spent without a plan. Where the business is consistently generating a VAT payable position, ring-fence an appropriate amount as invoices are paid. This avoids an avoidable squeeze when the VAT return and payment deadline arrive.

Build assumptions that can be challenged

Every forecast rests on assumptions. Good forecasts make them visible rather than hiding them in formulas. Record the expected sales growth rate, collection days, gross margin, supplier terms, headcount changes, exchange rates and planned investment. Then ask who owns each assumption and what evidence supports it.

This is especially valuable when directors have different expectations. A sales team may expect a new contract to start next month, while the finance team may know that procurement approval will take longer. Putting both views into the forecast turns a vague disagreement into a practical question: what happens to cash if the receipt moves by four weeks?

Avoid false precision. Forecasting AED 42,183 of marketing spend three months ahead may imply a certainty that does not exist. For controllable, recurring costs, precision is appropriate. For discretionary or volatile items, a sensible range and clear scenario may be more honest and more useful.

Test the base case before relying on it

A single forecast is a plan, not a guarantee. Prepare a base case using realistic assumptions, then test at least two alternatives. The downside case might assume slower collections, lower sales or an unexpected cost. The upside case may reflect a signed contract, improved collection discipline or delayed non-essential expenditure.

Focus on the minimum closing cash balance, not just the year-end number. A forecast can show a healthy annual result while revealing that the business will fall below its required cash level in one particular week. That is the point at which action is needed.

Actions can include chasing overdue invoices earlier, requesting deposits or milestone payments, renegotiating supplier terms, phasing a capital purchase, reducing discretionary spend, or arranging an overdraft or shareholder funding. The right response depends on the underlying issue. Delaying supplier payments may protect cash temporarily, but it can damage supply relationships and should not become a substitute for a workable operating model.

Reconcile the forecast every week

The forecast becomes reliable through routine review. At least weekly, compare projected receipts and payments with actual bank activity. Investigate material differences: did a customer pay late, did a supplier take payment early, was a cost omitted, or has the commercial outlook changed?

Then roll the forecast forward by one week. This creates a continuous planning process rather than a document that expires at month-end. Maintain a short commentary beside the numbers, particularly for major movements, decisions required and risks to the minimum cash balance. Directors should be able to understand the position without interpreting a complex workbook.

Accounting software and connected bank data can reduce manual work, but they do not replace judgement. Automated forecasts commonly rely on invoice due dates and recurring payment patterns. They may not know that a customer is disputing an invoice, a project has been paused or a director intends to hire three people next quarter. Finance oversight is what turns data into a forecast the business can act on.

Give the forecast clear ownership

A founder does not need to prepare every line personally, but someone must be accountable for maintaining the forecast and escalating risks. In smaller businesses, this may be the owner supported by an outsourced bookkeeping and finance team. In larger businesses, it may sit with the finance manager, with sales and operations responsible for validating their inputs.

Set a practical cash threshold. This should cover essential payments, allow for normal uncertainty and reflect the business’s risk appetite. A consultancy with low fixed costs may need a different buffer from a distributor carrying inventory or a regulated business managing substantial operating commitments.

The value of a cashflow forecast is not that it predicts the future perfectly. It gives you enough visibility to make choices while there is still time to make them. Keep it current, challenge the assumptions behind it and treat any approaching cash gap as a management decision to address, not a surprise to explain.