UAE Bank Statement Converter

UAE bank statement PDFs often mix AED formatting, value dates, bilingual narration, VAT and fee rows, WPS payroll references and password protection. ClearlyLedger converts Emirates NBD, ADCB, FAB, Mashreq and similar UAE statements into Excel or CSV with balance verification before download.

Last updated 2026-06-15

TL;DR

ClearlyLedger is a UAE-ready bank statement converter that turns PDFs from Emirates NBD, ADCB, FAB, Mashreq, DIB, RAKBANK, ADIB and HSBC UAE into clean Excel and CSV. It handles AED formatting, password-protected files, bilingual Arabic/English narration, and outputs FTA-compliant transaction history that imports straight into Tally, Zoho Books and QuickBooks.

Why UAE Businesses Need a Specialist Converter

Since the introduction of 5% VAT in 2018 and the 9% Corporate Tax in 2023, every UAE company — from a single-owner mainland LLC to a DMCC free-zone entity — has to keep five years of transaction-level bank records for the Federal Tax Authority. The catch: UAE banks still deliver statements as locked PDFs, not CSV.

Generic PDF-to-Excel tools choke on UAE statements because of bilingual headers, AED thousand separators, multi-line transaction references (IBAN, Mashreq Quick Remit codes, ENBD smartBUSINESS narration), and password protection. A specialist converter is faster than re-keying and safer than emailing statements to an offshore outsourcer.

UAE Banks Supported

ClearlyLedger ships dedicated parsing profiles for every major UAE bank:

Emirates NBD & ENBD smartBUSINESS

Both retail and SME (smartBUSINESS) statement layouts are detected automatically. AED currency rows, Direct Remit narration, cheque numbers, and bilingual headers are mapped to clean columns. Password-protected PDFs are unlocked in your browser.

Start with the Emirates NBD converter page for bank-specific layout and export behavior. For the deeper workflow, read the Emirates NBD statement to Excel guide.

Abu Dhabi Commercial Bank (ADCB)

ADCB statements use a tightly packed multi-line description format with separate transaction reference and value-date columns. ClearlyLedger stitches multi-line descriptions back into a single Payee field while preserving the value date for accountants doing reconciliation.

The ADCB converter page covers value-date handling, WPS narration, and reconciliation-ready export structure. The dedicated ADCB statement to Excel guide goes deeper on business statements and VAT-ready exports.

First Abu Dhabi Bank (FAB)

FAB statements (post-merger of NBAD and FGB) include both consumer and corporate variants. The converter handles FAB's Arabic-English column ordering and preserves IBAN references from incoming remittances.

Use the FAB converter page for bank-specific bilingual layout handling. For more detail, see the FAB statement to Excel guide.

Mashreq Bank & Mashreq NEO

Mashreq's legacy and NEO digital-only statements use slightly different schemas. Both are auto-detected. Quick Remit, NEOPay and DirectFX reference codes are kept in the Reference column rather than being dumped into the description.

The Mashreq converter page explains how legacy and NEO statement variants are normalized. For remittance and NEO-specific guidance, read the Mashreq statement to Excel guide.

Dubai Islamic Bank (DIB)

DIB statements include Sharia-compliant transaction labels (Murabaha, Wakala). These labels are preserved verbatim — important for accountants filing for Islamic finance entities.

RAKBANK, ADIB, HSBC UAE, CBD, Citi UAE

RAKBANK, Abu Dhabi Islamic Bank (ADIB), HSBC UAE, Commercial Bank of Dubai and Citi UAE are all supported via the universal AED-region profile. New layouts auto-learn after the first upload.

AED, Fils and the Thousand-Separator Trap

UAE banks format amounts as 12,345.67 AED — but a handful of templates (notably older ADCB and DIB exports) use space separators or Eastern Arabic numerals. Generic converters frequently lose the decimal or misread fils as dirhams. ClearlyLedger normalizes every amount to two-decimal AED with a sign-aware Debit/Credit split, then verifies the result with the opening + credits − debits = closing balance check before letting you export.

FTA, VAT and 5-Year Retention

The UAE Federal Tax Authority requires every taxable person to keep transaction-level records for five years (seven for real estate). The CSV export schema — Date, Description, Reference, Debit, Credit, Balance — matches exactly what FTA auditors ask for and imports cleanly into Tally Prime, Zoho Books and QuickBooks Online, all popular with UAE-based accountants.

Bilingual & Arabic-Only Statements

Many UAE accounts default to bilingual statements (Arabic narration on the right, English on the left). The parser uses the English column by default and keeps the Arabic narration as a secondary reference field so nothing is lost. Pure Arabic statements from DIB and ADIB Islamic accounts are processed via OCR with right-to-left awareness.

Privacy: Why 0-Second Retention Matters in the UAE

The UAE's Personal Data Protection Law (PDPL, Federal Decree-Law 45 of 2021) and DIFC Data Protection Law treat bank statement data as sensitive personal data. ClearlyLedger processes every file in memory with 0-second retention — your PDF is never written to disk on our servers, and there is no off-site copy for an attacker or rogue insider to exfiltrate.

How to Convert a UAE Bank Statement

  1. Download the PDF from your online banking portal (Emirates NBD Online, ADCB Personal Internet Banking, FAB Mobile, Mashreq Online).
  2. Upload it to ClearlyLedger. Drag-and-drop or click to browse.
  3. Enter the PDF password if prompted. It is used only for that conversion and is never logged or stored.
  4. Review the extracted preview — opening balance, every transaction, and closing balance with a green ✓ if the math reconciles.
  5. Export to Excel (.xlsx) or CSV (.csv). Import directly into Tally, Zoho Books, QuickBooks or your VAT-return workbook.

Common UAE Use Cases

  • Quarterly VAT returns for mainland LLCs and free-zone companies
  • Corporate Tax filings under the 9% regime introduced in June 2023
  • Golden Visa applications requiring six months of bank statements
  • Mortgage applications with Emirates NBD, ADCB, Mashreq home finance
  • Trade licence renewal evidence for DED, DMCC, JAFZA, ADGM
  • Outsourced accounting firms in Dubai & Abu Dhabi processing client books

FAQs

Is it free? Yes. Free conversions include full Excel and Standard CSV output. Starter adds higher limits, batch processing, and accounting-specific export formats.

Does it work for personal accounts too? Yes — Emirates NBD Liv., ADCB TouchPoints, and FAB personal accounts are all supported.

Will it handle a 12-month combined statement? Yes, on any paid plan you can batch dozens of statements and merge.

Key Takeaways

  • Purpose-built for UAE banks — no generic AED guesswork
  • FTA-compliant CSV schema, ready for Tally / Zoho / QuickBooks import
  • Bilingual Arabic / English statement handling
  • Secure conversion with source PDFs deleted after processing
  • Balance verification before every export

Ready to convert your UAE bank statement? Upload your first file free or see the dedicated UAE bank hub.

Loading interactive converter… Try ClearlyLedger free