How to Convert an Emirates NBD Statement to Excel (UAE Guide)

Emirates NBD is Dubai's largest bank, which makes its statement one of the most common PDFs on a UAE bookkeeper's desk — and one of the most tedious to retype. Every transaction is there, dated, described, debited and credited, but locked inside a document designed to be read, not calculated with. Retyping it by hand is exactly where VAT filings go wrong: one transposed digit or dropped row and the return no longer matches the account.

This guide walks the whole path: getting the statement out of Emirates NBD, dealing with the password, converting it to Excel or CSV with a template built for this bank, verifying that the numbers actually survived the trip, and importing the result into Xero, Zoho Books or QuickBooks.

✅ Good news up front. Emirates NBD is one of the banks BayanSheet ships a hand-tuned template for, alongside FAB, ADCB and Dubai Islamic Bank. The date, description, debit, credit and balance columns are mapped for the Emirates NBD layout rather than guessed at — and the full reconciliation check still runs on top. Start straight at the Emirates NBD converter.

Step 1 — Download the statement as a PDF

You want the bank's own PDF, not a screenshot and not a printed-then-scanned page. A native PDF carries a real text layer, which is what makes clean extraction possible.

From Emirates NBD online banking (desktop)

1. Sign in to Emirates NBD online banking in your browser.
2. Open Accounts and select the account you need.
3. Go to Statements (sometimes shown as Account Statement or e-Statement).
4. Select the period. Statement-cycle periods are cleaner than custom date ranges, because the opening and closing balances are printed on the document.
5. Download in PDF format.

From the Emirates NBD mobile app

1. Open the app and authenticate.
2. Tap the account, then the Statements or transaction-history section.
3. Select the month or date range you need.
4. Download or share the PDF — mailing it to yourself or saving it to files both work.

💡 Prefer the download over the emailed copy. Statements you pull while logged in are frequently unencrypted, whereas emailed statements almost always carry a password. Downloading directly saves you the unlock step entirely.

If you only have a CSV or XLS export

Some Emirates NBD accounts offer a direct CSV or Excel export of transactions. If you can get it, take it — but check it carefully. Bank-generated spreadsheets often omit the opening and closing balance lines, which means you lose the ability to reconcile the file against the statement it came from. A PDF plus a converter that checks the arithmetic is frequently the safer artefact.

Step 2 — Handle the password-protected PDF

If the PDF asks for a password when you open it, that is the bank's encryption, not a corrupted file.

Emirates NBD, like most UAE banks, derives the password from details you already hold, and the covering email states the exact formula. Common patterns across Gulf banks include some combination of:

Ingredient	Typical form
Date of birth	DDMMYYYY or DDMM
Customer / CIF number	Full or last digits
Card or account number	Last 4–6 digits
Name	First few letters, often uppercase
Mobile number	Last digits

Always take the formula from the email that delivered the statement rather than guessing — repeated wrong attempts are a waste of time, and the wording is right there.

Once you can open it, there are two routes:

• Convert it as-is. BayanSheet accepts encrypted PDFs and asks for the password locally in your browser. Neither the file nor the password is transmitted.
• Save an unlocked copy. Open the PDF, enter the password, then use Print → Save as PDF to write out a decrypted version. Note that this route can rasterise some documents, turning selectable text into an image, which forces OCR and reduces accuracy. Prefer converting the original.

There is a fuller treatment of the whole problem in our guide to converting password-protected bank statements.

🔒 Never email the password in the same thread as the statement. It defeats the entire point of the encryption. If you must send both to a colleague, use separate channels.

Step 3 — Convert the statement to Excel or CSV

With the PDF in hand:

1. Open the Emirates NBD converter in your browser.
2. Drag the Emirates NBD PDF onto the page — or use the file picker.
3. If the file is encrypted, enter the password when prompted. It stays on your machine.
4. The tuned Emirates NBD template maps the date, description, debit, credit and balance columns to the bank's known layout and extracts every row — no manual column-guessing on the first file.
5. The reconciliation check runs automatically: opening balance + credits − debits, compared against the closing balance printed on the statement. Any row that does not add up is flagged.
6. Download the result as Excel (.xlsx) or CSV, depending on what your accounting software wants.

Nothing is uploaded at any point in that sequence. The parsing runs as JavaScript inside the browser tab you already have open — statements never leave your device. That in-browser privacy is not a setting you enable; it is how the tool is built.

If you handle several UAE banks, the UAE banks hub is the fastest way to see what is supported and how each format behaves. The general mechanics are covered in how to convert a bank statement to Excel.

Step 4 — Verify the output before it touches your ledger

This is the step most people skip and later regret. A conversion error is rarely loud; it is a single dropped row that surfaces three weeks later as a VAT return that will not tie out.

Run these four checks on the converted file:

Check	What to look for	Why it matters
Balances reconcile	The tool confirms opening + credits − debits = closing	Catches dropped rows and misread decimals
Debit / credit split	Two distinct columns, correct signs	A merged amount column inverts your net movement
Descriptions intact	A wrapped narration stays on one row	Split descriptions create phantom transactions
Dates correct	Day and month not transposed; value date preserved	Wrong dates land transactions in the wrong VAT period

The reconciliation result does most of the heavy lifting. If opening balance plus credits minus debits equals the closing balance on the PDF, no row was lost and no amount was misread badly enough to matter — that is arithmetic, not a promise. Where a converter simply hands you rows and tells you to review them carefully before making financial decisions, it is transferring the checking work back to you.

Because Emirates NBD runs through a tuned template, the column mapping is already correct for the standard layout — but a quick glance on your first file of a new statement format is always time well spent.

Our five-test method for evaluating any converter, including this one, is in how to verify a bank statement converter.

Step 5 — Record-keeping and UAE VAT

For any VAT-registered business in the UAE, the Emirates NBD account is a primary source of the numbers on the return. The Federal Tax Authority (FTA) requires businesses to keep accounting records — including bank statements — for at least five years, and to be able to produce them on request. Amounts on the return are in AED, which is exactly what an Emirates NBD statement reports, so no currency conversion enters the picture for a dirham account.

💡 Keep the PDF as the legal record. The original bank PDF stays the official document the FTA expects to see. The converted Excel or CSV is your working copy — the version you sort, categorise and reconcile against your ledger. Keep both, filed by period.

A clean, reconciled sheet per statement cycle is the difference between a filing you can defend line by line and one you are reconstructing under time pressure. The reconciliation check matters here specifically: it is your evidence that the working sheet still equals the bank's own record.

Step 6 — Import into Xero, Zoho Books or QuickBooks

Each package wants a slightly different shape.

Xero

Go to the relevant bank account, choose Import a statement, and upload the CSV. Xero expects a date, an amount (either a single signed column or separate debit/credit columns) and a description. Set the date format to match your file exactly — DD/MM/YYYY is the usual Gulf convention — and save the mapping so Xero reuses it next month.

Zoho Books

Go to Banking → the relevant account → Import Statement, upload the CSV, then map the columns: date, description, debit (withdrawal), credit (deposit) and optionally reference. Mismatching the date format is the single most common import failure, so confirm it before you commit the batch.

QuickBooks Online

Use Transactions → Bank transactions → Upload from file. QuickBooks accepts CSV with either a single signed amount column or separate debit and credit columns; pick whichever matches your export and map accordingly. Confirm the dates parsed as dates rather than text before you accept the batch.

For a side-by-side of the main packages, see importing bank statements into accounting software.

✅ Import tip: import one month first and reconcile it before batching a whole year. If the mapping is wrong, you would much rather find out across 40 rows than 500.

Common mistakes to avoid

• Converting a scanned copy. A printed-then-scanned statement has no text layer, so it forces OCR and multiplies errors. Always start from the bank's native PDF.
• Skipping the reconciliation result. The balance check is the whole point; ignoring it puts you back to trusting rows blind.
• Trusting a merged amount column. If debits and credits share one column without signs, your net movement can silently invert. Confirm the split.
• Ignoring the date format on import. DD/MM/YYYY read as MM/DD/YYYY moves transactions into the wrong VAT period — a quiet error that only shows up at filing.
• Deleting the PDF once you have the sheet. The PDF is the record the FTA expects; keep it for the full five-year window.

Why in-browser processing matters for client statements

A bank statement is not an ordinary file. One month of a trading company's Emirates NBD account exposes its suppliers, its customers, its payroll, its margins and its cash position — everything a competitor or a fraudster would want.

When a converter uploads that PDF, the client's financial history is copied onto infrastructure you do not control. You inherit that vendor's storage practices, retention window, staff access and breach exposure, usually under terms nobody in the practice has read.

BayanSheet converts entirely inside your browser. There is no upload, so there is no stored copy to leak, subpoena or breach.

⚡ Prove it in fifteen seconds. Disconnect your Wi-Fi and convert a statement anyway. A browser-based tool keeps working because nothing needs to be sent. A tool that uploads will hang. No marketing page can fake that result.

Quick reference

Question	Answer
Where do I get the PDF?	Emirates NBD online banking or the mobile app, Statements section
Password?	Formula is in the covering email; downloads from inside banking are often unencrypted
Tuned template?	Yes — Emirates NBD is a hand-tuned template, with full reconciliation on top
Is the file uploaded?	No — parsing runs in your browser
Output formats	Excel (.xlsx) and CSV
Keep the PDF?	Yes — it stays the official FTA record; the sheet is the working copy

Ready to try it on a real file? Start at the Emirates NBD converter — the first 10 pages are free and no card is required. Browse more UAE bank guides on the blog.