Insights AR-AP
Supplier Reconciliation in the UAE 2026: The Monthly Statement Process That Survives Your Year-End Audit
A UAE finance team playbook for supplier reconciliation — monthly statement matching, GRNI ageing, three-way match, dispute log and the AP close cadence that survives audit.
Key takeaways
- Monthly supplier reconciliation matches the vendor's statement to your ledger creditor balance, catching timing, missing invoices, duplicate postings and disputed items before close.
- GRNI (goods received not invoiced) sits on the balance sheet as a payable accrual — UAE SMEs without GRNI tracking under-accrue 15-30% at month-end, distorting gross margin and net profit.
- Three-way match (PO + GRN + invoice) is the AP control that prevents duplicate payment, fictitious supplier fraud and incorrect VAT input recovery
- Dispute log captures short-deliveries, pricing variances, missing credit notes and quality holds — without one, disputed balances roll forward indefinitely and silently inflate creditors
- AP close cadence typically runs day 1-3 (cut-off), day 4-7 (statement requests), day 8-12 (matching), day 13-15 (dispute resolution and accrual posting) for a clean month-end creditor balance
- VAT input recovery depends on a valid tax invoice and matching GRN — supplier reconciliation surfaces missing tax invoices that would otherwise block AED 50,000-200,000 of recoverable input VAT.
Supplier reconciliation decides whether your monthly close is clean, your year-end audit is short, and your VAT input recovery survives an FTA review. It is also the one AP routine most UAE SMEs either skip entirely or do badly. They chase supplier statements at year-end, post random journals to balance creditors, and watch the auditor sample-test the mess for two weeks.
This guide is for finance managers, AP team leads and owner-operators of UAE businesses running between AED 5 million and AED 100 million of annual purchases. It covers the full monthly supplier-reconciliation cycle, the GRNI register and ageing, the three-way match, the dispute log, the AP close cadence, and the controls that keep the creditor balance honest.
Why this one routine quietly runs your close
The supplier reconciliation is the only routine that confirms — from an independent source — that your accounts payable balance is real. Without it the creditor balance is whatever your team has posted, and “whatever your team has posted” is rarely the same as what the supplier thinks you owe.
The gap between the two numbers is where audit issues, VAT exposure and fraud risk live. A typical UAE SME running 60-120 active suppliers and no monthly reconciliation will, by year-end, carry:
- AED 30,000-150,000 of duplicate or stale invoices that should have been credited out
- AED 20,000-100,000 of missing credit notes against returns and short deliveries
- AED 40,000-200,000 of GRNI under-accrued (goods received in the period, invoice never entered)
- AED 10,000-60,000 of payments allocated to the wrong invoice, inflating apparent disputes
- AED 50,000-200,000 of unrecovered input VAT against invoices that were paid but never properly captured in the ledger
AED 80k-400k
typical undetected creditor errors carried by a UAE SME with no monthly supplier reconciliation
The external auditor will find a sample of these and demand adjustments. The FTA may flag the input-VAT mismatches on a routine review. And the bank, when sizing your working-capital facility, will haircut the creditor strength because they cannot rely on the balance.
The monthly cycle, end to end
A working monthly cycle for a UAE SME with 60-120 active suppliers runs over 10-15 working days. The principle is simple: get the supplier’s statement, get your ledger, agree the differences, post the adjustments, lock the period.
Step 1: Cut-off (Days 1-3)
The cut-off is the cleanest single decision in the AP close. Agree the last day of the period at which:
- The last goods-received note will be matched into the period
- The last supplier invoice will be entered into the period
- The last payment run will be allocated to the period
Anything after the cut-off rolls into next month. The cut-off is communicated to the warehouse, AP team and any operational managers who raise POs. Without a hard cut-off the period never closes — there is always one more invoice “we should add”.
Step 2: Request statements (Days 4-7)
Email or system-trigger a statement request to every key supplier. For a typical SME the top 20 suppliers by spend cover 80% of value — these are non-negotiable. The remaining tail can be sampled.
A useful request template:
Dear [Supplier],
For our month-end close, please send us your statement of account as at [date] showing all invoices, credit notes and payments allocated to our account. Our supplier code with you is [code]. Please reply by [date + 3 working days].
Thank you, [AP team lead]
Plenty of UAE suppliers won’t have a polished statement function and will just send a manual list, sometimes a photo of a printout. That’s fine. What matters is that the document is dated, comprehensive and genuinely from the supplier’s own records.
Step 3: Line-by-line matching (Days 8-12)
Open the supplier statement on one side and the supplier ledger on the other. Walk down the supplier’s statement line by line and mark each item as one of:
- Matched — exists on both with the same amount
- In transit — on supplier’s statement, not yet on your ledger (invoice not received or not posted)
- Disputed — pricing variance, short delivery, missing credit note, quality hold
- Reverse direction — on your ledger, not on supplier’s statement (credit note expected, payment not yet allocated by supplier)
- Duplicate — posted twice on either side
- Wrong account — posted to a different supplier in error
Each unmatched item generates a line in the dispute log (see below) with an assigned owner and target resolution date.
Step 4: Resolve and post (Days 13-15)
Work the dispute log down. Some items will close in the same period (missing invoice received, credit note issued, mis-posting corrected). Items that will not close inside the period are accrued — GRNI accrued as a payable, expected credit notes accrued as a receivable adjustment, disputed balances flagged on the schedule.
The reconciled creditor balance now matches the supplier’s statement (with documented timing differences and disputes) and can be locked.
Running a GRNI register without losing track
GRNI — goods received not invoiced — is the accrual that bridges the gap between the moment inventory or services arrive and the moment the supplier’s tax invoice is entered into the ledger. It is one of the highest-error areas in UAE SME accounting because:
- Goods often arrive without paperwork (especially from import suppliers via Jebel Ali, DAFZA or DMCC)
- The warehouse team is not the AP team — GRNs are raised, then sit
- The PO and the invoice may differ on quantity, pricing or freight allocation
- VAT cannot be recovered until the tax invoice arrives
GRNI ageing buckets
| Bucket | Action |
|---|---|
| 0-15 days | Normal — no action |
| 16-30 days | First reminder to supplier |
| 31-60 days | Escalation to commercial contact; check whether goods were short-shipped or quality-held |
| 60-90 days | Senior AP review; investigate whether the invoice was raised at all |
| 90+ days | Escalate to finance manager; consider whether the GRN is real or whether goods were returned without paperwork |
At any point in time the GRNI register is part of the balance sheet — accrued payables. At year-end every open item must be accrued in full so that purchases and cost of goods sold are not understated.
The single most expensive month-end mistake we see UAE SMEs make is missing the GRNI accrual. Goods are in the warehouse, sold to the customer, gross margin is booked — but the supplier cost is sitting in someone’s email queue waiting to be entered. The P&L looks great until the invoice lands two months later and it all goes the wrong way.
Three-way match, the foundation control
The three-way match is the AP control that, when enforced, prevents the four most common AP losses — duplicate payment, ghost supplier fraud, price overruns and incorrect VAT recovery.
What is matched
| Document | Source | Confirms |
|---|---|---|
| Purchase order (PO) | Procurement / commercial team | What was agreed to be bought, at what price and quantity |
| Goods-received note (GRN) | Warehouse / receiving team | What actually arrived, in what quantity and condition |
| Tax invoice | Supplier | What the supplier is charging, including VAT |
Quantities and unit prices must agree across all three documents within a tolerance (typically AED 50 or 1% of invoice value, whichever is lower). If they do not, the invoice is held, the variance is logged, and the buyer chases the variance with either the supplier (pricing) or the warehouse (quantity).
Why three-way match also protects input VAT
UAE Federal Tax Authority rules require a valid tax invoice for input VAT recovery, and the goods or services must have been received for use in taxable supplies. Three-way match is the audit trail that proves the second leg — you bought what you said you bought, received it, and have the invoice to support recovery. Without it, an FTA reviewer can disallow input VAT and assess penalties.
For a primer on the format requirements that an FTA-compliant invoice must meet, see our UAE tax invoice format 2026 and credit note UAE rules guides.
Build a dispute log before you need one
The dispute log is the single document that turns supplier reconciliation from “an ongoing argument with vendors” into a managed process. It lives in a shared spreadsheet, ERP module or shared workspace — the format matters less than the discipline.
Minimum columns
| Column | Purpose |
|---|---|
| Supplier name | Sortable by vendor |
| Supplier code | Cross-reference to master file |
| Document type | Invoice, credit note, statement entry |
| Document number | The disputed reference |
| Document date | Aged from this date |
| Amount AED | The disputed value |
| Dispute reason | Short delivery / price variance / missing credit note / quality hold / duplicate / wrong account |
| Raised with supplier | Date the dispute was formally raised |
| Owner | The person in your team responsible for resolution |
| Expected resolution date | A real date, not “ASAP” |
| Status | Open / with supplier / credit note expected / credit note received / closed |
| Closing reference | The credit note number, journal reference or correction that closed the dispute |
Review cadence
- Weekly — AP team lead reviews open items, chases owners
- Monthly — Finance manager reviews items older than 30 days, escalates items older than 60 days
- Quarterly — Senior management reviews items older than 90 days; write-off or formal demand decisions
Without a log, disputes drift indefinitely. The original AP clerk leaves, the supplier contact changes, the warehouse manager who knows what happened moves on, and three years later the auditor finds a AED 47,000 unreconciled item nobody can explain.
A 15-day AP close, day by day
A worked example for a UAE trading SME with 80 active suppliers and a 15-day close window:
| Day | Activity | Owner |
|---|---|---|
| -3 | Cut-off communication issued to warehouse, procurement, AP | Finance manager |
| 0 | Period end — cut-off enforced | All |
| 1 | Final GRN posting from warehouse; final invoice batch entered | AP clerk |
| 2 | Internal AP control check — duplicate invoice scan, missing tax invoice list | AP clerk |
| 3 | Cut-off lock; AP module frozen for new period postings | AP team lead |
| 4-7 | Statement requests issued to top 20 suppliers and key tail | AP clerk |
| 8-12 | Line-by-line reconciliation; dispute log populated; resolution work begins | AP clerk |
| 13 | GRNI register aged; year-end-style accrual journal posted for open items | AP team lead |
| 14 | Dispute log reviewed; provisions raised where credit notes will not arrive in time | Finance manager |
| 15 | Final creditor balance agreed; period locked; AP pack prepared for management | Finance manager |
Day-16 onward is management review and any final escalations. The audit trail produced — reconciliations, dispute log, GRNI register, journal supports — is the workpaper pack a UAE external auditor will ask for at year-end.
Five differences you’ll see every month
Difference 1: Invoice on supplier statement, not on your ledger
Most common cause: invoice in transit (post, email queue, ERP integration delay) or invoice received but not entered. Action: request a copy of the invoice from the supplier, enter into the ledger in the next period (or accrue if the goods/services were received in the current period). Check whether the supplier’s TRN, format and VAT amount allow input recovery — if not, hold for an FTA-compliant replacement before posting.
Difference 2: Payment on your ledger, not on supplier statement
Most common cause: payment was made via bank transfer and the supplier has not yet allocated it (often because the remittance advice did not specify which invoices were being paid). Action: forward the remittance advice to the supplier’s AR team, ask them to allocate. Check whether the payment was made to the correct bank account — UAE has seen recurring vendor-impersonation fraud where bank details are changed by email.
Difference 3: Credit note expected but not received
Most common cause: short delivery or pricing dispute agreed verbally with sales contact, never converted to a credit note. Action: log in dispute register, chase supplier in writing with reference to the original PO/GRN/invoice. If the credit note will not arrive within 60 days, raise a provision in the ledger.
Difference 4: Duplicate invoice posted
Most common cause: emailed invoice and posted hard-copy both entered by different AP clerks. Action: reverse one entry, document the duplication, review controls. If payment was made on both, request a refund from supplier or apply credit against future invoices.
Difference 5: Postings to the wrong supplier
Most common cause: two suppliers with similar names, or a generic supplier code used as a default. Action: reverse and re-post; consider whether the supplier master file needs deduplication.
Stopping it happening again
The reconciliation cleans up the past. The controls below stop the same issues happening again.
Supplier master file hygiene
- New supplier creation requires trade licence, VAT certificate, bank letter, TRN verification (see TRN verification guide)
- One person creates suppliers, a different person approves
- Dormant suppliers (no activity for 12 months) are flagged inactive
- Duplicate supplier records are deduplicated quarterly
Three-way match enforced in the ERP
- No invoice can be moved to “approved for payment” without matched PO and GRN
- Variances above tolerance route to an AP supervisor for manual approval with documented reason
- Reports of invoices held for variance > 14 days are reviewed weekly
Payment release controls
- Payments are released against approved invoices only
- Bank account changes for existing suppliers require dual authorisation and a callback to a previously verified contact (defends against vendor-impersonation fraud)
- Round-sum payments and first-time payments above AED 10,000 are reviewed individually before release
Segregation of duties
- AP entry, supplier master maintenance, payment approval and bank reconciliation are not all performed by the same person
- For very small finance teams (1-2 people), the owner or external accountant performs the payment-approval and bank-reconciliation review as a compensating control
What your auditor and the FTA will ask to see at year-end
External auditor (year-end)
- Reconciled creditor balance with supporting statements from at least the top 20 suppliers
- Dispute log with status of all open items
- GRNI register with ageing and year-end accrual journal
- Three-way match controls evidenced for a sample of invoices
- Supplier master file review and dormant-supplier write-off support
FTA (on VAT review)
- Valid tax invoices for all input VAT claimed
- No duplicate input VAT claims
- Reverse-charge mechanism applied correctly for imported services (see reverse-charge mechanism UAE)
- Output VAT collected and input VAT recovered reconciled to the supplier ledger and bank
A clean monthly supplier reconciliation produces all of the above as a natural byproduct. A messy or absent reconciliation means the audit and any FTA review become reconstruction exercises — expensive, slow, and frequently producing adverse adjustments.
When to call us
The right time to bring in external bookkeeping or backlog cleanup support is when one or more of the following is true:
- The creditor balance has not been reconciled to supplier statements for 6+ months
- Year-end is approaching and the auditor’s preliminary creditor schedule is materially different from the ledger
- VAT input recovery has been flagged on a return review or by an FTA reviewer
- The AP team is more than two months behind on invoice entry
- A bank facility application or refinance requires audited or audit-ready financials
Engagements of this kind typically cover a baseline cleanup of prior-period balances, implementation of the monthly cadence inside the client’s accounting software, training of the in-house AP team, and a monthly AP pack handover. See our backlog accounting and accounting and bookkeeping services for scope and pricing.
Velmont’s take
Supplier reconciliation is repetitive, unglamorous work, and it’s also the single most important AP control most UAE SMEs are missing. The monthly cadence (cut-off, statement request, line-by-line match, dispute log, GRNI register, three-way match) is what separates a five-day clean close from a twenty-day year-end mess.
None of it turns on software. It turns on someone owning the routine, putting the calendar on the wall and refusing to release payments without a three-way match. Do that and the creditor balance becomes audit-ready, VAT input recovery holds up on review, and the working-capital picture the bank sees is a number you can actually trust.
Frequently asked questions
- What is supplier reconciliation and why does it matter for UAE businesses?
- It's the monthly job of comparing a vendor's statement of account against your own AP ledger and resolving every difference. It matters because those differences are real money, not rounding noise — invoices that should have been accrued and weren't, duplicate postings inflating creditors, credit notes never received against returns, payments sitting on the wrong invoice, disputes everyone quietly forgot. A UAE trader buying AED 30 million a year who skips the monthly reconciliation will usually be carrying AED 80,000-400,000 of wrong creditor balances by year-end.
- What is GRNI and how should a UAE SME track it?
- GRNI is goods received not invoiced — stock or services you've received where the tax invoice hasn't arrived yet, or hasn't been keyed in. In the books it's an accrued payable. Most UAE SMEs run a GRNI balance of 8-15% of monthly purchases at any given moment, simply because goods tend to turn up before the paperwork does. The control is a GRNI register listing every open goods-received note with no matched invoice, aged into buckets (0-15, 16-30, 31-60, 60+ days). Chase the supplier on anything past 30 days. Anything past 60 with no explanation is worth digging into — quality hold, dispute, or a pricing snag.
- What is the three-way match in accounts payable?
- Before an invoice is cleared for payment, you line up three documents: the purchase order the buyer raised, the goods-received note the warehouse signed for what actually turned up, and the supplier's tax invoice. Quantities and unit prices have to agree across all three. If they don't, the invoice is held for query and the variance goes on the log. It's a simple control that blocks the four AP failures that cost the most — paying for goods that never arrived, paying above the agreed PO price, paying the same invoice twice, and paying a fictitious supplier with no real PO behind it.
- How should a UAE finance team structure the monthly AP close?
- For an SME with 60-120 active suppliers, a repeatable close runs over 10-15 working days. Days 1-3 are the cut-off: last invoices entered, GRN cut-off agreed with the warehouse, intercompany balances confirmed. Days 4-7 you request statements from the key suppliers — the top 20 by spend usually cover 80% of value, so start there. Days 8-12 are the line-by-line reconciliation against the ledger, with every unmatched item dropping into the dispute log. Days 13-15 you post the GRNI and disputed-balance accruals, agree the final creditor balance and lock the AP module. What you're left with is a creditor figure the external auditor can lean on without re-sampling it.
- What goes into a supplier dispute log?
- It tracks every unmatched item from the monthly reconciliation right through to resolution. At minimum: supplier name, the invoice or credit-note number, document date, AED amount, the dispute reason (short delivery, price variance, missing credit note, quality hold, duplicate, returned goods), the date you raised it, an assigned owner, an expected resolution date, and the current status. Status walks through open, with supplier, credit note expected, credit note received, closed. Anything older than 60 days goes to the commercial team. Anything past 90 days gets reviewed for write-off or a formal demand — that's where things turn expensive if you let them sit.
- How does supplier reconciliation interact with UAE VAT input recovery?
- You can only recover input VAT against a valid UAE tax invoice that meets the FTA format — supplier TRN, sequential invoice number, date, line items with the VAT amount, and your details as the buyer. No tax invoice, no recovery, even if the goods turned up and you paid. Monthly reconciliation is what surfaces these gaps: the GRN's there, the payment may have gone out, but the tax invoice never arrived and the recovery is blocked. A mid-market trader who chases those missing invoices every month tends to unlock AED 50,000-200,000 of recoverable input VAT a year that would otherwise be lost or claimed too late.
- What is the difference between a supplier statement and a supplier ledger?
- The statement is the vendor's version of events — the document they send out, usually monthly, listing every invoice raised, every payment received and the open balance as they see it. The supplier ledger (your creditor account) is the same relationship from your side, sitting in your accounting system. Reconciliation is the act of making the two agree. Where they don't, it's almost always timing (invoices in transit, payments not yet allocated), a missing document like an unreceived credit note, a posting error, or a live dispute over price or short delivery. Done properly, you end up with one agreed closing balance and every difference categorised and tracked.
- How often should a UAE SME reconcile its suppliers?
- Monthly for active suppliers — anyone with a transaction in the period or an open balance. Your top suppliers by spend get reconciled every month, no exceptions. Mid-tier names with patchy activity can drop to quarterly, and dormant suppliers with nothing for 12 months should just be marked inactive in the master file. The annual-only approach, which thinly staffed teams quietly fall into, leaves it far too late: by year-end the disputes are months stale, the warehouse staff who'd remember have often moved on, and the supplier may have closed prior years on their side. Monthly catches problems while they're still fixable and keeps the creditor balance audit-ready.
- What controls reduce supplier-payment fraud risk in UAE SMEs?
- Most of the exposure comes down to a handful of controls. Enforce the three-way match as a hard gate before any payment goes out. Split duties so whoever creates a supplier in the master file isn't the one approving invoices or releasing money. Make bank-account changes need dual authorisation, ideally with a callback to a contact you've already verified. Onboard new suppliers only against trade licence, VAT certificate, bank letter and TRN verification. And run payments dual-approved, with a documented look at the odd items — round sums, first-time payees. The UAE keeps seeing vendor-impersonation fraud, where a fake bank-change email diverts a real payable, and that callback is far and away your best defence.
- Does Velmont Crest help UAE businesses with supplier reconciliation and AP close?
- Yes — supplier reconciliation, GRNI tracking, three-way match and AP close support are a core part of our [accounting and bookkeeping](/services/accounting-bookkeeping/) and [backlog accounting](/services/backlog-accounting/) work. A typical engagement starts with a baseline cleanup, reconciling prior-period creditors against current supplier statements, then builds the monthly cadence inside the client's own accounting software. From there it's the dispute log set up and reviewed weekly, a GRNI register with an ageing routine, and a monthly AP pack that lands on management's desk alongside the management accounts.
Filed under: supplier reconciliation, GRNI tracking UAE, three-way match, accounts payable UAE, AP close process, vendor statement matching, dispute log template
Published · Updated
