Emirates NBD Statement to Excel Converter

TL;DR

Emirates NBD ships statements as password-protected PDFs in both retail and ENBD smartBUSINESS variants. ClearlyLedger unlocks them for the requested conversion, normalizes AED amounts, and keeps the bilingual Arabic / English narration intact, turning each statement into a balance-verified Excel file or into CSV formatted for Tally, Zoho, or QuickBooks — ready for your 5% VAT return.

Why Emirates NBD PDFs Are Hard

Emirates NBD is the largest bank in the UAE and its statements are the single most-converted file format in our pipeline. They are also the trickiest: every download is password-protected, the layout differs between retail (Personal Banking) and ENBD smartBUSINESS (SME), the bilingual Arabic column overlaps the English description on certain pages, and the AED amounts use a thousand separator that generic table-extractors split on.

The result with most tools is missing rows, broken decimals, and an opening / closing balance that does not reconcile. For VAT and Corporate Tax filings that is a non-starter.

Step 1: Download Your ENBD Statement

1. Log in to Emirates NBD Online Banking or the ENBD Mobile app.
2. Go to Accounts → Statements, pick the account and date range.
3. Choose PDF (the only machine-readable format ENBD offers — there is no native CSV).
4. Email statements arrive password-protected by default. The password is usually your date of birth in DDMMYYYY format or the last 4 digits of your Emirates ID — check the ENBD email body.

Step 2: Upload to ClearlyLedger

Drag the PDF onto the homepage. If it is password-protected — which, per the download step above, an emailed ENBD statement almost always is — you will be prompted for it in the browser. Whichever it turns out to be, DDMMYYYY or the last four of your Emirates ID, that value does one thing and one thing only: it opens this file for this conversion. ClearlyLedger doesn't log it, doesn't attach it to your account, and doesn't keep a copy once the PDF is unlocked.

Step 3: What ClearlyLedger Does

• Auto-detects whether the file is retail ENBD or ENBD smartBUSINESS and loads the matching parser profile.
• Splits AED amounts into Debit / Credit columns with sign awareness.
• Stitches multi-line narration (Direct Remit, cheque references, IBAN of remitter) back into a single Payee field, capped at 30 characters for QuickBooks compatibility.
• Keeps the Arabic narration as a secondary reference field so RTL accountants and auditors lose nothing.
• Runs the opening + credits − debits = closing balance reconciliation. Export is blocked until the math reconciles, with a clear repair UI if it does not.

ENBD smartBUSINESS Specifics

This is where SME accounts diverge sharply from retail, and it's the layout generic tools mangle most. Retail Emirates NBD statements post one date per line. smartBUSINESS statements add a second, separate value-date column for merchant settlement — the date card-scheme funds actually land in the account, which for a busy POS or e-commerce business can run a day or more behind the transaction date shown on the same row. A generic extractor either drops the value-date column outright or, worse, merges it into the description text, which is exactly what breaks settlement reconciliation at month-end.

The smartBUSINESS profile keeps the transaction date and the value date as two distinct columns all the way through export, alongside the denser merchant-settlement batching that smartBUSINESS statements use for card acquiring. That separation is what lets an accountant match a settlement batch to the day the funds actually cleared, instead of the day the sale was rung up.

Step 4: Export

Excel (.xlsx) and Standard CSV are available on every plan including Free. Starter and above add direct-import CSV formats for Xero, QuickBooks, and Tally Prime, with DD/MM/YYYY dates and clean AED amounts that need no reshaping.

VAT & Corporate Tax Notes

The export schema (Date, Description, Reference, Debit, Credit, Balance) maps directly onto what FTA auditors ask for in the 5-year VAT record retention rule and the 9% Corporate Tax filing introduced in June 2023. Free-zone companies (DMCC, JAFZA, ADGM) and mainland LLCs both benefit — same schema, no reshape.

Common Issues & Fixes

• Wrong password. ENBD passwords for emailed statements are not the same as your online banking password. Try DDMMYYYY of your date of birth first.
• Scanned PDF. If you photographed a paper statement, the parser will route it through OCR. Use at least 300 DPI for clean results.
• Closing balance off by a few fils. Usually a thousand-separator misread on one row. The repair UI highlights the suspect row before you export.
• Multi-currency (FCY) sub-accounts. Emirates NBD reports USD, EUR, and GBP holdings as separate statement pages, each with its own opening and closing balance in that currency. ClearlyLedger keeps each currency as its own reconciled export rather than folding the balances into an AED-equivalent figure, so a USD FCY sub-account's closing balance stays in USD, not converted.
• Inbound SWIFT narration looks truncated. International wires post with the sender's bank, a partial reference, and the SWIFT message type crammed into one line, and ENBD's own PDF wraps it mid-word on some statements. The Payee field capture reads across the wrap point, so the correspondent bank name and reference land intact rather than split across two rows.

Key Takeaways

• Both retail and smartBUSINESS layouts are auto-detected.
• smartBUSINESS keeps transaction date and value date in separate columns so settlement timing doesn't get lost.
• Balance verification before every export — FTA-ready by default.
• Same conversion-scoped password rule as every profile: unlock only, never logged, never stored.
• CSV imports cleanly into Tally Prime, Zoho Books and QuickBooks Online.

Ready? Convert your Emirates NBD statement free, or read the broader UAE bank statement converter hub.

Written by John Snow, Financial Data Specialist.