Accounts Receivable Ageing for UAE SMEs: DSO Benchmarks and the Collection Playbook That Frees Trapped Cash

Accounts receivable ageing is the most under-used finance report on most UAE SME balance sheets. Owners track revenue weekly and gross margin monthly. The ageing report — the one document that shows where every dirham of trapped cash is sitting and how old it is — often goes unopened until the bank account stops growing.

This playbook is for owners, managing directors and finance managers of UAE SMEs running between AED 5 million and AED 80 million of revenue. It covers what AR ageing is, the bucket structure that works here, sector DSO benchmarks in AED, the 30-60-90-day collection cadence that beats ad-hoc chasing, and the IFRS 9 and FTA touchpoints UAE auditors test.

What accounts receivable ageing actually is

The accounts receivable ageing report is a list of every open customer invoice, grouped by how many days have passed since the invoice date. The standard UAE structure splits invoices into four buckets: 0-30 days, 31-60 days, 61-90 days and 90+ days. Each bucket is totalled in AED so the finance team can see at a glance how much cash is sitting at each stage of the collection cycle.

A tight ageing profile for a UAE SME running on 30-day terms looks like this:

A sloppy ageing profile on the same book looks very different:

Moving from a sloppy profile to a best-in-class one usually unlocks AED 800,000 to AED 4 million on a AED 30 million revenue book. Often enough to clear the overdraft, fund a year of payroll growth or pay a real owner dividend.

DSO is the headline metric

Days Sales Outstanding (DSO) is the headline metric the ageing report supports. It measures the average number of days between invoice issue and cash collection. The standard formula is:

DSO = (Accounts Receivable balance ÷ Credit Sales in the period) × Days in the period

A UAE trading SME with AED 4.5 million open receivables and AED 2.4 million of credit sales in the last 30 days has a DSO of (4.5 ÷ 2.4) × 30 = 56 days.

For SMEs with lumpy revenue — most contractors, project-based businesses, seasonal traders — the rolling 90-day DSO is more stable:

Rolling 90-day DSO = (AR balance ÷ Credit Sales in last 90 days) × 90

Track both a current DSO and a rolling 12-month trend on the monthly board pack so the cash-conversion-cycle movement can be attributed to the right driver — DSO, inventory days or DPO. For the wider working-capital context, see our working capital management playbook for UAE SMEs.

What we keep seeing in DSO across UAE sectors

DSO benchmarks vary widely by buyer profile, and this is where a lot of well-meaning targets fall apart. Set an aggressive 30-day target for an ADNOC subcontractor and you’ll miss it every quarter — the buyer dictates the payment cycle, not you. Set a relaxed 90-day target for a cash-and-carry retailer and you’re leaving money on the table that was never at risk in the first place.

Typical UAE DSO benchmarks in 2026:

Best-in-class peers in each sector usually beat the sector average by 15-25 days through disciplined invoicing, clean credit control policy and a calendar-driven dunning cadence. For the deeper DSO improvement plan, see our days sales outstanding improvement guide.

“

The DSO target that matters is not the textbook 30 days — it is 15-25 days inside the sector benchmark. Beat your peer group and the cash unlock is real; chase a number your buyers will not pay and the discipline collapses.

Building the AR ageing report in your accounting software

Most UAE SMEs run Zoho Books, QuickBooks Online, Xero, Tally or Sage. All five produce a standard AR ageing report out of the box.

Zoho Books

Reports → Receivables → Customer Balance Ageing. Default buckets are 0-15, 16-30, 31-45, 46-60, 60+. Edit the bucket configuration to match the four-bucket UAE standard (0-30, 31-60, 61-90, 90+). Schedule the report to email weekly to the finance manager and the owner.

QuickBooks Online

Reports → Who owes you → A/R Ageing Summary. Default 30/60/90/over-90 matches the UAE standard. Customise the columns to include PO number and customer phone. Save as a memorised report and schedule weekly.

Xero

Reports → Receivable Invoice Summary. Toggle to ageing view. Default 30/60/90 buckets. Customise the layout to show outstanding amount, days overdue and customer contact details.

Tally

Display More Reports → Statements of Accounts → Outstandings → Receivables → F6 Ageing Analysis. Define the four buckets in the ageing configuration screen.

For SMEs running custom or legacy systems, a weekly export to Excel with a pivot table by ageing bucket works — the format matters less than the discipline of weekly refresh.

The 30-60-90-day collection playbook

Good dunning is automated, predictable and escalating. The cadence that works for most UAE SMEs:

Day 0 — Invoice issued

Invoice raised the same day the work is complete or the goods are delivered. Mandatory content: invoice number, invoice date, supply date, buyer name and TRN, supplier TRN, line-item description, line-item AED and VAT, totals, PO reference, payment terms, IBAN. Email the invoice plus an updated statement of account to the buyer’s AP contact and copy the commercial contact.

Day 7 — Cordial reminder

Polite email — “this is a courtesy reminder that invoice [number] for AED [amount] becomes due on [date]. The invoice and current statement of account are attached for your convenience.” No escalation language. Send before the invoice is overdue so the buyer treats it as service, not chasing.

Day 14 — Courtesy phone call

Call the AP contact. Confirm the invoice is in their system, ask if any documentation is missing, ask for the expected payment date. Most slow payments in the UAE are caused by missing PO references, mismatched line items or invoices stuck in approval workflows — a phone call surfaces these issues before they become disputes.

Day 21 — Firm written reminder

Email — “Invoice [number] for AED [amount] was due on [date] and remains unpaid. Please confirm the payment date by return.” Copy the buyer’s finance manager. Attach the invoice, statement of account and any supporting delivery notes.

Day 30 — Statement of account + commercial escalation

Email to the buyer’s finance manager and commercial contact — “Invoice [number] is now 30 days past due. Please find the statement of account attached and confirm the payment date.” For high-value invoices, follow up with a phone call to the finance manager.

Day 45 — Commercial escalation

Email to senior management on both sides — “Invoice [number] for AED [amount] is now 45 days past due. We would like to resolve this commercially before considering further action.” Mention the wider trading relationship and any pending orders or commitments.

Day 60 — Stop-supply trigger

Email — “Further supply will be placed on hold until the outstanding balance of AED [amount] is settled.” Implement the hold the same day in the ERP so the commercial team cannot override it informally.

Day 75 — Final demand letter

Formal demand letter on letterhead. State the amount, the cumulative days past due, the trading history and the consequences of non-payment (legal recovery, credit-bureau reporting if applicable, termination of the supply agreement). For the full letter library, see our dunning letter template guide.

Day 90 — Legal review

Refer the file to a UAE-licensed recovery firm or law firm. Velmont Crest does not provide legal recovery — this is referred work. Decide at this point whether to pursue through the UAE courts, write off as bad debt and claim VAT bad-debt relief under Article 64 of the VAT Executive Regulations, or sell the receivable to a recovery firm at a discount.

IFRS 9 expected credit losses on UAE AR

IFRS 9 requires that the SME provision for expected credit losses (ECL) on all trade receivables at each reporting date, not only those past due. The simplified provision matrix approach lets SMEs apply historical loss rates by ageing bucket.

A typical UAE trading SME matrix:

The percentages should be tuned to the SME’s actual collection history — a trading business with three years of clean GRE collections at 100% will have lower stage-1 rates than a B2B distributor selling to high-turnover SME buyers in Sharjah.

UAE auditors increasingly test that the AR ageing report reconciles to the ECL provision and that the matrix is reviewed annually against realised losses. The reconciliation walk — opening provision plus charge for the year less write-offs less recoveries equals closing provision — is a standard audit working paper.

FTA bad-debt relief on uncollected invoices

Article 64 of the UAE VAT Executive Regulations allows VAT-registered suppliers to recover the output VAT paid on invoices that have become bad debts, subject to conditions:

• The supply has occurred and VAT has been charged on the tax invoice.
• The consideration has been written off in full or in part in the supplier’s books.
• More than six months have passed since the date of the supply.
• The supplier has notified the customer of the amount written off.

The bad-debt relief is claimed by adjusting the output tax in the VAT return for the period in which the four conditions are met. UAE FTA auditors expect to see the written notification to the customer, the write-off entry in the general ledger and the original tax invoice on file.

For SMEs running tight ageing discipline, the bad-debt relief working paper is built directly from the 180+ ageing bucket on a quarterly cycle.

EmaraTax 28-day VAT payment cycle and AR drag

FTA rules require VAT-registered businesses to file VAT returns and pay the net VAT within 28 days from the end of the tax period. Output VAT on invoices issued during the period must be paid even if the underlying invoice has not yet been collected.

A UAE SME with AED 3 million of sales in a quarter and a 75-day DSO will typically pay AED 150,000 of VAT (5% on AED 3m) to the FTA before collecting more than half of the underlying invoices. The cash gap is funded out of overdraft, supplier payment delay or owner equity.

Tight ageing discipline reduces this drag — every 10 days of DSO improvement on a AED 12m quarterly revenue book frees roughly AED 160,000 of VAT-timing cash. For the full VAT mechanics, see our VAT registration guide.

Weekly AR ageing review meeting

What makes ageing actually work is a weekly 30-45 minute review meeting, owned by the finance manager and attended by the owner or commercial director.

Agenda:

1. 90+ bucket — invoice by invoice. Owner of the relationship, status of last contact, next action, escalation needed yes/no.
2. 61-90 bucket — top five exposures. Same drill on the largest five only; the rest go on a watch list.
3. 31-60 bucket — portfolio level. Trend versus last week and last month. Any new entries that came in from 0-30 unexpectedly?
4. 0-30 bucket — exception only. Disputes or hold-ups that need commercial intervention.
5. DSO trend. Current DSO, rolling 90-day, versus target and sector benchmark.
6. Stop-supply list. Buyers currently on hold; criteria to release the hold.

The meeting minutes — decisions, owners, next-action dates — are recorded on the ageing report itself. Most accounting software supports inline comments on customer records; for SMEs running export-to-Excel, a simple comment column does the job.

Multi-currency invoicing and AR ageing

UAE SMEs trading internationally — exporters to Saudi Arabia, Oman or wider GCC, importers from India, China or Europe — face multi-currency AR. Most accounting software allows invoicing in foreign currency with AED revaluation at month-end.

The ageing report should be run in AED equivalent for the management view (so the owner sees one number for trapped cash) and in original currency for the AP contact view (so the buyer sees the invoice in their own currency). Foreign-exchange gains and losses on collection are booked separately from the trade receivable.

For SMEs with significant foreign-currency AR, a monthly FX revaluation of the AR balance to spot is standard, with the unrealised gain or loss booked through P&L.

Where UAE SMEs slip up on ageing

The first is treating the ageing report as a finance task. AR is a commercial discipline, and the owner, sales manager and commercial director all need to be in the weekly review or the cadence won’t stick.

Running too many buckets is another. Five-plus-bucket structures look thorough but rarely change behaviour, and the cost of preparation usually exceeds the analytical value. Four buckets is the right answer for SMEs.

Letting the stop-supply trigger drift is the expensive one. The day-60 trigger is the most powerful lever you have, and once it becomes negotiable, buyers learn the cadence is theatre.

A subtler mistake is confusing invoice date with due date. Most accounting software defaults to invoice-date ageing, but the more useful view for collection is due-date ageing — days past due, not days from invoice — so configure the report to show both columns.

Ignoring credit notes and on-account payments distorts everything too: a buyer with AED 200,000 of open invoices and AED 80,000 of unallocated credit notes has net exposure of AED 120,000, so the ageing report should show net exposure per buyer, not gross open invoices.

And plenty of SMEs run the ageing report without a credit control policy behind it. The ageing is the diagnostic; the policy is the prescription. Run one without the other and the discipline rarely sustains.

When to bring in advisory support

Most UAE SMEs benefit from advisory support on AR ageing when one or more of the following is true:

• DSO is above the sector benchmark by more than 20 days.
• The 90+ bucket exceeds 15% of total AR.
• Cash flow stress is causing VAT-payment or payroll-timing problems.
• Audit has flagged inadequate IFRS 9 ECL provisioning or weak credit-control documentation.
• The business is preparing for an investment round, bank facility renewal or sale where receivables quality will be diligenced.

Typical AR/AP advisory engagements for UAE SMEs run AED 12,000-35,000 for the initial 8-12 week diagnostic and process build, followed by monthly retainer of AED 4,000-9,000 to run the weekly review meeting and refine the cadence over the first year. The cash unlock in the first quarter normally exceeds the annual fee by 3-6x.

For owners wanting a CFO-level review across AR, AP, inventory and the wider working-capital cycle, see our CFO advisory page.

How Velmont Crest helps

Velmont Crest builds and runs AR ageing processes for UAE SMEs as part of our accounts receivable and payable management work. Typical engagements include:

• AR ageing template build in Zoho Books, QuickBooks, Xero, Tally or Sage
• Four-bucket configuration aligned to UAE auditor expectations
• Sector DSO benchmark and 12-month target setting
• Dunning template library — cordial, firm, final, legal-review — bilingual where the buyer requires
• Weekly review meeting facilitation for the first quarter
• IFRS 9 ECL provision matrix construction and back-testing against actual losses
• FTA bad-debt-relief documentation and quarterly working paper
• Multi-currency revaluation and FX exposure reporting
• Integration with the wider accounting and bookkeeping cycle

This is advisory and accounting support — Velmont Crest is a DED-licensed accounting and advisory firm, not a licensed debt-collection agency or financial-services entity. Legal recovery and litigation are referred to UAE-licensed law firms.

To discuss your AR ageing position and where the cash unlock sits, book a free consultation or WhatsApp the team directly.