Introduction
By June, every UAE SME has six months of trading data and six months of unknowns ahead. The mid-year point is when a refreshed cash flow forecast adds the most value — early enough to act on what it reveals, late enough to be grounded in real numbers. This playbook is the same cadence outsourced CFOs use with their clients.
We will cover the two forecasts every SME needs, the drivers that matter, the review rhythm, and the warning signs that should change behaviour immediately.
The Two Forecasts You Need
First, a 13-week rolling cash flow. This is the operational forecast: weekly visibility on receipts, payments, payroll, tax, and bank position. It exists to prevent surprises.
Second, a full-year P&L-driven cash forecast: monthly profitability translated into cash via working capital movements, capex, tax, and financing flows. It exists to inform decisions — hiring, investment, dividends, debt.
Building the 13-Week Forecast
Start with opening cash, then layer in confirmed receipts (invoiced and contracted), expected receipts (pipeline-weighted), payroll, key supplier payments, rent, utilities, VAT and corporate tax, and any debt servicing. Update it every Monday with last week’s actuals and rolling-forward the new week 13.
The first version will feel optimistic. Track the variance between forecast and actual for four weeks and you will quickly find the levers that drive the most error — usually customer collection timing.
Building the Full-Year Forecast
Drive the full-year forecast from your operating model. Start with revenue assumptions, layer in gross margin and overheads to reach EBITDA, adjust for working capital (DSO, DIO, DPO), subtract capex and tax, and reach free cash flow. Run a base case, an upside, and a stress case.
The stress case is where the value lives. Test what happens if revenue lands 15% below plan or your largest customer pays 30 days late. The decision you make today is more informed when you have already considered the painful scenarios.
Working Capital: The Hidden Cash Lever
Most UAE SMEs have meaningful cash trapped in working capital. Receivables that drift from 45 to 60 days, inventory holding above customer demand, supplier terms shorter than they need to be — every one of these locks up cash that could fund growth or reduce debt.
A mid-year working capital review is one of the highest-ROI exercises a CFO can run. Quick wins typically include sharper credit limits, automated reminder cadences, supplier payment term negotiation, and SKU rationalisation.
Review Cadence That Actually Works
Weekly: 30-minute cash review with the founder/CEO walking through the 13-week forecast.
Monthly: 60-minute board-style review of the full-year forecast versus actuals, with a written commentary on variances.
Quarterly: a deeper re-baseline of assumptions tied to the strategic plan.
Red Flags Worth Acting On Immediately
- Cash buffer falls below six weeks of operating expenses.
- Top three customers concentration above 60% of revenue.
- DSO trending up four months in a row.
- VAT or corporate tax liability building without a paired cash reservation.
- Owner drawings exceeding free cash flow for two consecutive quarters.
Tools and Templates
Most UAE SMEs build the 13-week forecast in Google Sheets or Excel, with bank balances pulled in via Plaid or manual paste, AR data exported from the accounting system, and AP data pulled from a payment scheduler. The full-year forecast is usually a separate model linked to the 13-week. The exact tool matters less than the discipline of one source of truth and one update cadence.
Keep formulas simple. Models that try to do too much break under change. A model that fits on two screens with clearly separated assumptions, drivers, and outputs survives leadership turnover and scales with the business.
Communicating Cash Flow to Non-Finance Stakeholders
Cash flow forecasts are only useful if non-finance leaders understand them. Pair the model with a one-page summary: opening cash, expected receipts, expected payments, closing cash, and the three or four assumptions driving the most variability. Present the same one-pager every week and the conversation becomes about decisions rather than numbers.
Frequently Asked Questions
Q1. How accurate should a 13-week cash flow be?
Aim for ±5% variance against actuals by week four of the forecast. Anything wider points to weak inputs or unrealistic timing assumptions.
Q2. Do small UAE SMEs really need both forecasts?
Yes. The 13-week prevents tactical surprises; the full-year informs strategic decisions. They serve different purposes and one cannot replace the other.
Q3. Can Zoho Books or QuickBooks generate cash flow forecasts?
They produce historical cash flow statements but not forward forecasts. Forecasting is normally done in a linked Excel or Google Sheets model, with actuals fed in from the accounting system.
Q4. How do I build cash flow assumptions when I have no history?
Use industry benchmarks, sales pipeline data, and contracted recurring revenue, then update assumptions monthly as actual data lands.
Q5. How does corporate tax affect cash flow forecasting?
Build the corporate tax payment as a single cash line on the due date (nine months after year-end) and reserve cash monthly into a separate account.
Q6. Should the founder build the forecast or the finance team?
Finance builds it; the founder reviews it weekly. Joint ownership means the model reflects both operational reality and management priorities.
Call to Action
OPAB builds and runs cash flow forecasts for UAE SMEs as part of our outsourced CFO service — including 13-week models, scenario planning, and weekly cash reviews. Book a free CFO consultation.
