Insights AR-AP
AR and AP Ageing Report Format UAE: The Layout Banks Actually Accept for Credit
A UAE AR and AP ageing report format UAE banks accept for credit and facility applications, with bucket structure, concentration analysis, dispute disclosure and lender presentation tips.
Key takeaways
- The standard UAE bank-acceptable ageing bucket structure is 0-30 / 31-60 / 61-90 / 91-180 / 180+ days, with each bucket broken down by customer or supplier name
- Top 10 debtor / creditor concentration is the single most important disclosure — UAE banks consider above 50% concentration in any single counterparty a material risk
- Disputed and doubtful balances must be flagged separately — hide them inside the 91-180 bucket and your credibility goes when the auditor reconciles
- The reconciliation back to the trial balance should appear on the cover of the ageing report — banks need to confirm the AR / AP totals tie to the latest audited or management financials
- Net AR after expected credit loss (ECL) provision is what most UAE banks discount as borrowing-base eligible — a 100% face-value AR is not 100% lendable
- Group consolidation matters — a debtor that appears small individually but is actually a related group needs to be aggregated to show real concentration
AR and AP ageing reports are the two schedules UAE banks read most carefully on any credit application. They are also the two schedules most SMEs submit in a format that costs them rate, limit or approval. The owner hands the accountant a one-page ageing summary on the morning of the bank meeting. The credit officer reads it in 30 seconds, makes assumptions about the gaps, and the working-capital line comes back smaller than asked.
This article is for owners, finance managers and CFOs of UAE SMEs preparing ageing reports for bank credit applications, facility renewals, invoice financing or supplier credit. It covers the bank-acceptable bucket structure, concentration analysis, dispute disclosure, ECL provisioning, and the presentation that gets a working-capital request approved in one round.
What an ageing report actually is
An ageing report (sometimes “aged debtors”, “aged creditors” or “aged trial balance”) lists every open AR or AP balance categorised by how long the balance has been outstanding. The bucket structure compresses thousands of transactions into a one-page view of collection or payment health.
What it tells a UAE bank
| Signal | What the bank reads from it |
|---|---|
| Total AR / AP | Does it tie back to the audited or management balance sheet |
| Distribution across buckets | Is the book current or tail-heavy |
| Concentration by counterparty | Single-name risk, group risk, sector risk |
| Disputed and doubtful balances | What is genuinely collectable / payable |
| DSO and DPO implied | Working-capital efficiency consistent with the business model |
| Month-on-month trend | Improving, stable or deteriorating |
A clean ageing supports a higher borrowing base, better facility pricing and faster approval. A messy one, or one that’s hiding something, triggers more questions, smaller limits, more security, or a flat decline. The credit officer isn’t being difficult. They’re reading the same signals they read every week, and they’ve learned what an evasive report looks like.
The bucket structure UAE banks expect
UAE banks — ADCB, FAB, Emirates NBD, HSBC, Mashreq, Dubai Islamic Bank, Abu Dhabi Islamic Bank, Commercial Bank of Dubai, Mashreq, RAKBank — use variations of the same five-bucket structure for credit application templates.
| Bucket | Days outstanding | Bank interpretation |
|---|---|---|
| Current (not yet due) | Within stated terms | Healthy — full borrowing-base value |
| 0-30 days past due | 1-30 days past invoice or due date | Normal slippage — minor haircut (usually 5-10%) |
| 31-60 days past due | 31-60 days | Escalating — moderate haircut (15-30%) |
| 61-90 days past due | 61-90 days | Concerning — heavy haircut (40-60%) |
| 91-180 days past due | 91-180 days | Problem — usually 70-90% haircut or excluded |
| 180+ days past due | Over 180 days | Doubtful — usually fully excluded |
Some banks separate “not yet due” from “0-30 past due” and treat them differently. Others use 0-30 as the first bucket inclusive of current. Match the bank’s template where it exists; otherwise use the five-bucket structure above with a clear definition of basis on the cover sheet.
The seven sections a bank-ready report includes
A bank-acceptable AR ageing report has the following structure:
Section 1: Cover and reconciliation
- Company name, trade licence number, TRN
- Report date (typically last day of the most recent month)
- Total AR (gross, before ECL) — must tie to the trial balance / balance sheet
- ECL provision
- Net AR (net of ECL)
- Currency (AED) with foreign-currency exposure noted separately
- Ageing basis (due-date or invoice-date) — pick one and disclose
- Preparer name and date
Section 2: Bucket summary
| Bucket | AED outstanding | % of total |
|---|---|---|
| Not yet due | 4,250,000 | 47% |
| 0-30 past due | 2,100,000 | 23% |
| 31-60 past due | 980,000 | 11% |
| 61-90 past due | 540,000 | 6% |
| 91-180 past due | 720,000 | 8% |
| 180+ past due | 410,000 | 5% |
| Total gross AR | 9,000,000 | 100% |
| ECL provision | (510,000) | |
| Net AR | 8,490,000 |
Section 3: Customer-level detail
For each open customer, columns showing:
| Customer | TRN | Stated terms | Total AED | Not due | 0-30 | 31-60 | 61-90 | 91-180 | 180+ | Disputed |
|---|
Sort by total AED descending. The top 10-20 customers are what the credit officer reads.
Section 4: Top 10 concentration analysis
| Rank | Customer (or group) | AED outstanding | % of total AR | Oldest balance | Status |
|---|
This is the section that drives credit officer’s view of single-name and group risk.
Section 5: Disputed and doubtful balances
| Customer | AED | Dispute reason | Date raised | Recovery action | Status |
|---|
Disclosed separately, not buried inside the regular ageing.
Section 6: GRE and government exposure
Separate listing of receivables from government-related entities (ADNOC, Etisalat, DEWA, Dubai Holding, Aldar, etc.) with stated terms, actual DSO and active facility usage. Banks treat these as a separate risk category — lower default risk, longer payment cycle.
Section 7: 12-month trend
A small table or chart showing month-end AR totals and bucket distribution for the prior 12 months. Demonstrates improvement, stability or deterioration over time.
A trader applying for AED 6m at ADCB
A UAE trading SME (AED 60m revenue, mainland Dubai, 200+ active customers) preparing for a AED 6m invoice-financing facility renewal with ADCB.
Cover
- Total gross AR: AED 11,400,000
- ECL provision: (AED 760,000)
- Net AR: AED 10,640,000
- Ageing basis: due-date
- Date: 31 May 2026
Bucket summary
| Bucket | AED | % |
|---|---|---|
| Not yet due | 5,800,000 | 51% |
| 0-30 past due | 2,400,000 | 21% |
| 31-60 past due | 1,150,000 | 10% |
| 61-90 past due | 680,000 | 6% |
| 91-180 past due | 890,000 | 8% |
| 180+ past due | 480,000 | 4% |
| Total | 11,400,000 | 100% |
Top 5 concentration (group-aggregated)
| Group | AED | % AR |
|---|---|---|
| Lulu Group (multiple entities) | 1,890,000 | 17% |
| Choithrams Holdings | 980,000 | 9% |
| ADNOC Distribution | 1,420,000 | 12% |
| Spinneys Dubai | 640,000 | 6% |
| Damac Properties subsidiaries | 510,000 | 4% |
| Top 5 total | 5,440,000 | 48% |
Disputed balances disclosed
| Customer | AED | Reason | Status |
|---|---|---|---|
| Damac subsidiary X | 220,000 | Short delivery, credit note expected | With supplier |
| Etihad Construction LLC | 145,000 | Pricing variance — Q1 unit rate | Under negotiation |
| Royal Trading Co | 60,000 | Quality hold — returned goods | Credit note expected |
Borrowing-base calculation (ADCB methodology)
| Bucket | AED | Eligible % | Eligible AED |
|---|---|---|---|
| Not yet due | 5,800,000 | 85% | 4,930,000 |
| 0-30 | 2,400,000 | 80% | 1,920,000 |
| 31-60 | 1,150,000 | 65% | 747,500 |
| 61-90 | 680,000 | 40% | 272,000 |
| 91-180 | 890,000 | 0% | 0 |
| 180+ | 480,000 | 0% | 0 |
| Less disputed | (425,000) | 0% | 0 |
| Eligible AR | 7,869,500 | ||
| Less concentration cap (top 1 over 15%) | (340,000) | ||
| Borrowing base | 7,529,500 |
At an 80% advance rate, the facility limit is approximately AED 6.0m — matching the requested renewal.
48%
of this trader's AR is concentrated in the top 5 customer groups — a material concentration that needs to be surfaced upfront, not discovered by the bank
Booking it under IFRS 9
Under IFRS 9, trade receivables carry an expected-credit-loss provision based on historical default experience, current conditions and forward-looking information. UAE banks expect to see ECL applied on the ageing.
A simplified provision matrix for UAE SMEs
| Bucket | Provision % | Adjustment for sector / customer |
|---|---|---|
| Not yet due | 0.5-1.0% | Plus specific identified concerns |
| 0-30 past due | 1.0-2.0% | Stable customers may stay at 1% |
| 31-60 past due | 3.0-7.0% | Higher for new or smaller customers |
| 61-90 past due | 10-20% | Plus specific provision on identified problems |
| 91-180 past due | 25-50% | Generally fully specific by this point |
| 180+ past due | 50-100% | Document recovery actions to justify under 100% |
This matrix is illustrative — the actual provision should reflect the SME’s historical loss experience, sector and customer base, and the IFRS 9 methodology applied by the external auditor.
A separate specific provision
Specific provisions on identified problem debts — customer in financial difficulty, dispute likely to result in write-off, recovery action stalled — sit alongside the general matrix and are usually 50-100% of the specific balance.
The total ECL = general matrix provision + specific provisions, deducted from gross AR to reach the net AR shown on the balance sheet.
Where AP ageing reads differently
The AP ageing report applies the same bucket structure to supplier balances. The interpretation differs:
| Signal | What the bank reads from AP ageing |
|---|---|
| Concentration in single supplier | Supply-chain dependency, leverage available to that supplier |
| Volume in 60-90 day bucket | Either negotiated long terms (good — DPO discipline) or stretching suppliers (bad — cash stress) |
| Volume past 90 days | Either disputed (needs explanation) or cash-pressured payments deferred |
| GRNI separately disclosed | Genuine accruals vs missed invoices |
| Mix of import vs local suppliers | LC and trade-finance utilisation context |
Key distinction: aged AP and DPO consistency
The implied DPO from the AP ageing should be consistent with the DPO stated in the credit application narrative. If the SME claims 45-day DPO but the AP ageing shows 40% of creditor balance past 90 days, the credit officer will question whether the SME is paying suppliers as fast as it implies, or whether the 90+ bucket is disputed balances rather than late payments.
GRNI on the AP ageing
GRNI (goods received not invoiced) should be shown separately from supplier-invoice payables. GRNI is an accrual; supplier-invoice payable is a real obligation matched to an issued invoice. Mixing them inflates the apparent supplier payable and distorts DPO.
See our supplier reconciliation guide for the GRNI register that feeds into the AP ageing.
Inside the credit officer’s head, step by step
When a UAE bank credit officer receives an AR / AP ageing report as part of a working-capital facility application, the typical flow is:
Step 1: 30-second triage (visual scan)
- Does the total reconcile to the balance sheet on file?
- Is the format recognisable? (Bank-template-style, or improvised?)
- Is there obvious tail (90+ days a high proportion)?
- Is concentration visible? (Top 10 disclosed?)
Step 2: 10-minute reasonableness check
- Do the implied DSO / DPO match the business model?
- Are GREs and government receivables identified?
- Are disputes flagged separately?
- Is ECL applied?
Step 3: Borrowing-base calculation
- Apply the bank’s standard haircuts by bucket
- Exclude or discount disputed balances
- Apply concentration caps (typically top 1 capped at 15-25% of base, top 5 at 50-60%)
- Discount GRE / government exposure separately (often a fixed % regardless of ageing)
- Net to eligible AR / AP and apply advance rate
Step 4: Question rounds
- Why is X% of AR in the 91-180 bucket?
- What is the recovery plan on the top 3 problem balances?
- What does the dispute log show on the Damac balance?
- Has the customer been formally notified that the SME considers the balance in dispute?
- Is the concentration in customer Y the same legal entity or related group?
A well-prepared report addresses these upfront. A poorly-prepared one means three rounds of email, two weeks of delay and a smaller approved limit.
Lender presentation tips
Lead with the reconciliation
The first thing the credit officer wants to confirm is that the ageing total matches the trial balance and the last audited or management financials. Put the reconciliation on the cover. Anyone trying to hide a mismatch loses credibility immediately.
Show concentration upfront, don’t hide it
If your top 5 customers are 50% of AR, say so. The credit officer will work it out regardless, so there’s no upside in being coy. Saying it first lets you frame the relationship on your terms: “ADNOC has been a customer for 8 years, terms are 60-day stated, average 80-day collection, no losses in 6 years.” Far better than having the same fact surface later as a concern you didn’t volunteer.
Disclose disputes honestly
The dispute log will eventually surface through the auditor’s confirmation letters, the customer’s response to direct bank contact, or the FTA reconciliation. Better to disclose AED 425k of disputed balances with reasons and recovery plans than be caught hiding them. Honesty about disputes increases credibility on the rest of the report.
Provide the 12-month trend
A single month-end snapshot tells the bank nothing about direction. A 12-month trend showing AR total, key buckets and concentration over time tells the bank whether the working-capital position is improving or deteriorating. Improving trends support better facility terms.
Pre-discount the GRE balances
Government-related entity receivables have specific characteristics — long stated terms (60-90), longer actual cycles (75-120 days), low default risk, slow but reliable collection. Present these in their own table with average collection cycles, ageing buckets and any factored portion. Banks have separate haircut rules for GREs and will apply them more favourably if the data is presented as a clean segment.
Match the bank’s template
Most major UAE banks have a credit-application template with specific schedules. Use the bank’s template format wherever it exists. Submitting a beautifully designed report in your own format that the credit officer then has to remap is a friction point that delays approval.
Where the report kills your facility
Total doesn’t reconcile to balance sheet
The ageing shows AED 9.2m, the trial balance shows AED 9.5m, the management accounts show AED 9.4m. Three different numbers from one source of truth means none of them is trusted. Fix the underlying ledger before sending anything.
Hidden disputes
Disputed balances buried inside the 91-180 bucket without a note. The bank finds them through external confirmation and discounts the credibility of the whole report.
Group entities not aggregated
Six subsidiaries of the same group, each showing AED 800k individually, no aggregation. The credit officer eventually works out the group exposure is AED 4.8m and assumes you were hiding it.
No ECL applied
Gross AR presented as if it were 100% collectable. The bank will impose its own ECL anyway — usually more conservative than yours would have been — and the apparent borrowing base shrinks accordingly.
Stale data
Ageing report dated 60-90 days before the application. The bank asks for a fresh one and your application sits in queue until you produce it.
Different ageing basis between AR and AP
AR on due-date basis, AP on invoice-date basis. Working-capital ratios become uninterpretable. Pick one basis and apply it consistently.
GRNI mixed into AP
GRNI sitting inside supplier-invoice payable lines inflates the apparent creditor balance and breaks the DPO calculation.
Most UAE credit officers approve facilities at the level of the most pessimistic reasonable view of the borrowing base. If your ageing report leaves room for a pessimistic interpretation, that’s the interpretation the credit officer is paid to take. Pre-empt every concern by disclosing it cleanly, and the facility comes back at the level the actual receivable book supports.
When to bring in outside help
The right time to engage external accounting or CFO support on ageing report preparation is when:
- A bank facility application or renewal is approaching and the current ageing report does not reconcile to the management accounts
- The dispute log is not integrated into the ageing
- ECL provisioning has not been applied or is not auditor-acceptable
- The 12-month trend has not been built and the bank is asking for it
- A previous facility request was declined or significantly haircut and the underlying analysis was a contributing factor
Typical engagement scope includes ageing structure rebuild, ECL methodology design and provisioning, dispute log integration, GRE / government segmentation, 12-month trend pack, and walk-through support with the bank credit team. See our CFO advisory and accounting and bookkeeping services for engagement scope and pricing.
How Velmont Crest helps
The ageing reports are the working-capital story your accounting system tells about your business. UAE credit officers see hundreds of them a year, and they know the polished-and-misleading version on sight just as well as they know the real-and-credible one. The credible version — clean reconciliation, honest concentration, transparent disputes, IFRS 9 ECL, a 12-month trend — supports the facility you actually need. The other version costs you rate, limit, or the deal itself.
So lead with the reconciliation, show the concentration upfront, keep disputes and GRE balances in their own sections, and put the 12-month trend on the page. That’s the difference between a one-round approval and six weeks of back-and-forth that ends in a 30% smaller limit.
Frequently asked questions
- What is an AR ageing report and why do UAE banks ask for it?
- It lists every open customer balance and sorts it by how long the money has been sitting there past the invoice or due date. You'll also hear it called a debtor ageing or aged receivables analysis. The standard UAE layout runs 0-30, 31-60, 61-90, 91-180 and 180+ day buckets, and the total has to tie back to the trade debtor figure on the balance sheet. Banks want it on every working-capital application because it's the clearest read on the real quality of your receivable book — how disciplined collections are, how concentrated the customers are, how much is in dispute, how much might never come in. Clean ageing gets you a bigger borrowing base; a tail-heavy one shrinks what they'll lend against.
- What is the standard ageing bucket structure UAE banks accept?
- 0-30 days (current and just past due), 31-60 (early past due), 61-90 (escalating), 91-180 (problem territory), and 180+ (doubtful, or you're actively chasing it). Some banks also want a separate 'not yet due' bucket split out from 0-30 past due. ADCB, FAB, Emirates NBD, HSBC, Mashreq, Dubai Islamic Bank, Abu Dhabi Islamic Bank and Commercial Bank of Dubai all run variations of this in their credit-application templates. If your system spits out 60-90 / 90-120 buckets or fortnightly ones, remap before you submit — don't make the credit officer do it.
- How should debtor concentration be shown on a UAE ageing report?
- Two layers. The first is your top 10 individual debtors by AED outstanding — name, total, percentage of AR, oldest balance, dispute status. The second is the same picture aggregated by related group, so subsidiaries of one parent count as a single exposure. That second view is the one that catches people out; concentration that looks fine entity by entity can be alarming once you roll the group up. Banks read anything above 25% of AR in one counterparty as a concentration risk, above 50% as material, and above 75% as single-name risk that may cost you extra security or a lower borrowing base.
- What is the expected credit loss (ECL) provision and how does it affect the ageing report?
- Under IFRS 9, ECL is a forward-looking provision across the receivable book reflecting the probability of default and the loss if it happens, bucket by bucket. Banks expect to see it applied to the ageing as its own column. A common SME approach runs roughly 0-1% on 0-30 days, 1-3% on 31-60, 3-10% on 61-90, 15-40% on 91-180, and 50-100% on 180+ depending on dispute and recovery status, with specific provisions layered on identified problem debts. Net AR after ECL is the number that actually anchors the borrowing base for invoice-financing or working-capital facilities. See our [working capital management UAE playbook](/insights/working-capital-management-uae-sme-playbook/) for the broader CCC framework.
- How should disputed receivables be disclosed in an ageing report?
- Pull them out into their own column or section — never bury them in the regular ageing. Show the customer name, the AED amount, why it's in dispute (short delivery, pricing variance, quality hold, credit note expected, payment contested), when you raised it, and what you're doing to recover it. Banks discount disputed balances hard, usually to 0-25% of face value depending on the nature of the dispute. The reason honesty pays here: hide a dispute in the 91-180 bucket and the bank finds it anyway through the dispute log or the auditor's confirmation letters, and at that point the whole report stops being believed.
- How does an AP ageing report differ from an AR ageing report?
- Same bucket structure, applied to what you owe suppliers rather than what customers owe you — 0-30 / 31-60 / 61-90 / 91-180 / 180+ past the supplier invoice or due date. What the bank reads from it is different, though. It's looking at whether you're paying suppliers on terms or stringing them out (a stretched AP ageing signals cash stress), whether your implied DPO matches the working-capital story in the application, and how dependent you are on any one supplier. Like the AR version, it has to reconcile to trade creditors on the balance sheet, with GRNI shown separately as an accrual.
- What does a UAE bank credit officer actually look for in an ageing report?
- Reconciliation first, always: does the AR or AP total tie to the trial balance and the last audited or management accounts? Then concentration — what's sitting in the top 10 names, and does it fit the customer base they'd expect for your model? How much is past 90 days, and is the trend improving or slipping month on month? Are the disputed and doubtful balances out in the open, with a realistic ECL? And are GRE and government receivables flagged separately, since those behave differently on working capital? Put all of that on the page and most of the questions never get asked.
- How frequently should a UAE SME prepare ageing reports?
- Monthly, at minimum — it should be a fixture in the board pack and management accounts, not something you build the night before a bank meeting. Under cash stress or active dunning, weekly is sensible. Your internal version can be simpler than the bank-submission format; the underlying data is identical either way. For a facility application or renewal the bank wants the most recent month-end ageing, often with a 12-month trend of month-end balances by bucket alongside. Anything more than about 60 days stale at submission tends to get discounted by the credit officer.
- What is the difference between invoice-date ageing and due-date ageing?
- Invoice-date counts from when the invoice was issued; due-date counts from the contractual payment date. The gap matters — a 30-day-old invoice on Net 60 terms is current on a due-date basis but already 'past 30 days' on invoice-date. Banks take either, as long as you pick one, say which, and stick to it. Due-date is the more useful basis because it isolates what's genuinely overdue.
- Does Velmont Crest help UAE SMEs prepare ageing reports for bank submission?
- Yes — ageing report preparation, ECL provisioning, dispute-log integration and bank-submission packs all sit within our [accounting and bookkeeping](/services/accounting-bookkeeping/) and [CFO advisory](/services/cfo-advisory/) work. A typical engagement rebuilds the AR or AP ageing inside your accounting system so it matches the bank-acceptable format, sets up the ECL methodology, folds the dispute log into the presentation, builds the 12-month trend pack, and walks you through the credit officer's question rounds. It's preparation and presentation support — the credit decision and facility terms stay between you and the regulated lender.
Filed under: AR ageing report, AP ageing report, debtor ageing UAE, bank credit application, working capital facility, lender presentation, DSO disclosure
Published · Updated
