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. Much of that trapped cash traces back to the terms you set: the choice between net 30 and net 60 payment terms shapes every bucket that follows.

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. If you would rather have this run for you, our accounts receivable management in the UAE service builds and operates the whole ageing and dunning cycle. Before an overdue invoice hardens into a write-off, a clean statement of account sent to the customer is often what gets it reconciled and paid.

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. Behind every line sits a simple accounts receivable journal entry — debit trade receivables, credit revenue and output VAT when the invoice is raised; debit bank, credit trade receivables when the cash lands — so the report is only ever as accurate as the bookkeeping feeding it.

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 unlocks real cash 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.

Accounts receivable aging or ageing? Same UAE report, two spellings

Search for accounts receivable aging in the UAE and you will find the term written two ways: “aging” and “ageing”. They point at exactly the same report. The split is house style, nothing more. US-built software and American finance texts use aging, while British, IFRS and Commonwealth materials use ageing. UAE finance teams meet both because the local market draws on both traditions — QuickBooks Online and NetSuite label the report “A/R Aging”, whereas Zoho Books, Sage and most audit files here follow the British ageing.

The spelling changes nothing about the method. Whichever version your software prints, the accounts receivable aging report does the same job: it groups open invoices into 0-30, 31-60, 61-90 and 90+ day buckets so you can see where cash is trapped. If you have inherited a US-format chart of accounts, expect “A/R Aging Summary” and “A/R Aging Detail” as the two standard views. If your auditor works to IFRS, expect “receivables ageing” in the file. British-trained teams may equally label it the debtors ageing — debtor being the standard accounting term for a customer who owes you money — and it is still the same four-bucket report. Pick one spelling as your own house standard, keep it consistent across the board pack, and put the effort into the part that pays — collecting the cash.

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.

Some finance texts present this as the accounts receivable days formula, and a common variant uses the average accounts receivable formula — opening receivables plus closing receivables, divided by two — as the numerator so a single month-end spike does not distort the result.

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 drives DSO across UAE sectors

Accounts receivable in the UAE is shaped less by your credit policy than by who your buyers are. DSO varies 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.

Roughly fastest to slowest, based on who is paying rather than what you sell:

Whatever your sector, the best-run peers consistently beat the sector average — not because of a different target, but through disciplined invoicing, a 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 a target set meaningfully inside your own sector’s norm. Beat your peer group and the cash unlock is real; chase a number your buyers will not pay and the discipline collapses.

Accounts receivable aging KPIs beyond DSO

DSO is the headline, but a mature accounts receivable aging process in the UAE tracks three or four numbers alongside it. Each one answers a question DSO on its own cannot.

• Percentage current — the share of the book sitting in the 0-30 bucket. The cleanest single-glance health check; best-in-class UAE SMEs hold 70% or more here.
• Average days delinquent (ADD) — average days past the due date, not days from invoice. It strips out your credit terms and shows how late buyers actually pay, which is what really drives cash timing.
• Collection effectiveness index (CEI) — collections achieved against collections available in a period, shown as a percentage. A CEI near 100% means the team is bringing in almost everything it could; a falling CEI flags trouble before DSO has moved.
• Bad-debt-to-sales ratio — write-offs as a share of revenue, read straight off the 180+ bucket and the IFRS 9 workings.

A close cousin of these is the accounts receivable turnover ratio — credit sales divided by average receivables — which tells the same collection-speed story as DSO, expressed as a multiple per year rather than in days. Put these on the same monthly board page as DSO and its trend line. DSO tells you how long cash takes to arrive; ADD and CEI tell you why the number is moving and whether the team is winning. For the step-by-step plan to shift the metrics, our days sales outstanding improvement guide sets out the levers in the order that works.

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, so you rarely need to build an accounts receivable template UAE finance teams can rely on from scratch — you configure the one already inside the software. The same platforms carry most of the accounts receivable automation an SME needs — scheduled ageing emails, automatic invoice reminders and overdue flags — which is what lets documented accounts receivable procedures run on the calendar instead of on memory.

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(1) of Federal Decree-Law No. 8 of 2017, 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.

An illustrative provision 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.

In bookkeeping terms, the accounting entry for the provision for bad debts is a debit to impairment loss in the P&L and a credit to the ECL allowance sitting against trade receivables. Accounts receivable and payable audit procedures in the UAE now routinely trace that entry from the ageing report through to the trial balance and the financial statements.

FTA bad-debt relief on uncollected invoices

Article 64(1) of Federal Decree-Law No. 8 of 2017 allows VAT-registered suppliers to recover the output VAT paid on invoices that have become bad debts, subject to four conditions (FTA Public Clarification VATP024, checked 4 August 2026):

• 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. Whether you call it VAT bad debt relief or bad debt recovery, it is the same output-tax adjustment under Article 64 — the label changes, the four conditions do not.

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

The deadline is not a rule of thumb. Article 64(1) of the VAT Executive Regulation — Cabinet Decision No. 52 of 2017, read against the instrument in August 2026 — states that a tax return “must be received by the Authority no later than the 28th (twenty eighth) day following the end of the Tax Period concerned or by such other date as directed by the Authority.” Output VAT on invoices issued during the period is payable on that date whether or not the underlying invoice has been collected, which is what turns a slow ageing profile into a financing problem rather than merely a collections one.

A UAE SME with AED 3 million of sales in a quarter and a 75-day DSO will 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.

Tightening the ageing shrinks that gap, and it is worth doing the arithmetic rather than reaching for a rule of thumb. On a AED 12m quarterly revenue book, one day of sales is AED 12,000,000 ÷ 91 = about AED 131,900. Ten days of DSO improvement therefore converts roughly AED 1.32 million of receivables into collected cash. The VAT-specific slice of that — the output tax you had already remitted on invoices you had not yet been paid for — is 5% of it, or about AED 66,000. Both numbers matter, but they are different numbers, and conflating them is how AR business cases end up overstated.

Carry the larger figure through and the picture sharpens further. If that AED 1.32 million was being funded on an overdraft, the annual cost of carrying it is the balance multiplied by your own facility rate — at 10% that is AED 132,000 a year, at 14% it is AED 184,800. Use your bank’s current pricing rather than either of those, because the point of the exercise is a number you can defend to your own board. For the full VAT mechanics, see our VAT registration guide.

What accounts receivable aging means for your Corporate Tax

Corporate Tax gives you a second reason to keep the accounts receivable aging under control, on top of the cash-flow one. Under Federal Decree-Law No. 47 of 2022, taxable income is worked out on an accruals basis for most businesses — so revenue is taxed in the period you invoice it, not the period you collect it. An invoice sitting in the 90+ bucket has usually already been counted as taxable income. Let receivables drift and you can find yourself paying the 9% Corporate Tax on profit that is still stuck in a customer’s payables ledger.

Two aging-linked points are worth watching. First, bad-debt write-offs: a specific receivable written off in the books because it is genuinely irrecoverable is generally a deductible expense, whereas a general IFRS 9 expected-credit-loss provision may need adding back — the treatment turns on the detail, so confirm it with your tax adviser. Second, Small Business Relief: a business with revenue at or below AED 3 million can elect the relief for eligible tax periods, which changes how much the timing of collections matters on the return. We set out the detail in our Small Business Relief guide and the wider taxable income and deductions guide. This is general guidance to help you prepare, not a tax filing service.

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.

Where one or two buyers dominate the book, it can also be worth pricing accounts receivable insurance in Dubai — trade credit insurance on your largest exposures — against the simpler route of tightening terms. Get a current written quote before deciding either way.

AR/AP advisory engagements for UAE SMEs are priced by scope — an initial 8-12 week diagnostic and process build, followed by a monthly retainer to run the weekly review meeting and refine the cadence over the first year. Request a quote or book a free call for a fixed price against your book size.

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.