How to Convert an ADCB Statement to Excel (UAE Guide)

Month-end at an Abu Dhabi practice usually has the same bottleneck: a stack of ADCB statements that have to become rows in a ledger. Everything you need is on the page — value dates, narrations, debits, credits, running balance — but it is sealed inside a PDF built to be read, not summed. Retyping it by hand is slow, and every keystroke is a chance to transpose a digit that nobody catches until a reconciliation refuses to close.

This guide takes an ADCB statement the whole way: out of the bank, past the password, into a clean spreadsheet, checked for accuracy, and loaded into Xero, Zoho Books or QuickBooks. ADCB is a large conventional Abu Dhabi bank, and it is one of the formats BayanSheet has a dedicated, hand-tuned template for — which changes where this guide starts.

✅ Good news up front. ADCB is a tuned bank. BayanSheet ships hand-mapped layout templates for ADCB, Emirates NBD, FAB and Dubai Islamic Bank. The engine already knows how ADCB arranges its columns and wraps long descriptions, so the very first file converts cleanly instead of needing a manual column-by-column check.

Step 1 — Export the statement as a PDF

Reach for the bank's own PDF, not a screenshot and not a scan of a printout. A native PDF carries a genuine text layer underneath the page, and that text layer is what lets a converter lift exact figures instead of guessing at pixels.

From ADCB Personal Internet Banking (desktop)

1. Sign in to ADCB Personal Internet Banking in your browser.
2. Open Accounts and select the account you are working on.
3. Choose Statements (you may see it labelled Account Statement or e-Statement).
4. Set the period. A full statement cycle beats a custom date range, because the cycle prints an opening and a closing balance — the two anchors the accuracy check depends on.
5. Export in PDF format.

From the ADCB mobile app

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

💡 Grab the download, not the emailed copy. Statements pulled while you are already logged in are often unencrypted, whereas the versions ADCB emails almost always carry a password. Exporting directly removes the unlock step before it starts.

If ADCB offers a direct CSV or Excel export

Some account views let you download transactions straight to CSV or spreadsheet. It is tempting, but read it before you trust it: bank-generated exports frequently drop the opening and closing balance lines, and without those two numbers you cannot reconcile the file against the statement it came from. A PDF fed through a converter that checks the arithmetic is usually the safer artefact.

Step 2 — Deal with the password-protected PDF

If the file demands a password on open, that is ADCB's encryption doing its job, not a damaged download.

Like most UAE banks, ADCB builds the password from details you already possess, and the email that delivered the statement states the exact recipe. Formulas across Gulf banks tend to combine some of these:

Ingredient	Typical form
Date of birth	DDMMYYYY or DDMM
Customer / CIF number	Full number or trailing digits
Card or account number	Last 4–6 digits
Registered name	First few letters, often capitalised
Mobile number	Trailing digits

Read the formula off the covering email rather than guessing — a run of wrong attempts wastes time, and the correct wording is sitting right there in the message.

Once the file opens, two routes are open to you:

• Convert it encrypted. BayanSheet accepts a password-protected PDF and asks for the password locally, in the browser. Neither the file nor the password ever travels off your machine.
• Save a decrypted copy. Open the PDF, key in the password, then use Print → Save as PDF to write out an unlocked version. Be aware this can flatten some documents into images, which forces OCR and dents accuracy — so prefer feeding the original.

The whole topic gets a deeper treatment in our guide to converting password-protected bank statements.

🔒 Keep the password out of the statement's email thread. Sending both together undoes the encryption entirely. If a colleague needs both, use two separate channels.

Step 3 — Convert with the tuned ADCB template

With the PDF ready:

1. Open the ADCB converter in your browser.
2. Drop the ADCB PDF onto the page, or pick it with the file selector.
3. If it is encrypted, type the password when asked. It stays on your device.
4. The ADCB template takes over: it already knows where the value date, description, debit, credit and running-balance columns sit, and how ADCB wraps a long narration across lines, so the mapping happens without you nudging it.
5. The reconciliation check runs on its own — opening balance + credits − debits, measured against the closing balance printed on the statement. Any row that breaks the arithmetic is flagged, not hidden.
6. Download as Excel (.xlsx) or CSV, whichever your accounting package prefers.

At no point in that sequence does the file leave your browser. The parsing is JavaScript executing inside the tab you already have open — there is no server in the loop.

If you juggle several UAE banks, the UAE banks hub shows what is supported and how each layout behaves. The general mechanics live in how to convert a bank statement to Excel.

Step 4 — Verify before the data touches your books

This is the step people skip and later pay for. Extraction errors are quiet — rarely a crash, usually one dropped row or one misread decimal that only shows up weeks later as a balance that will not tie out.

Run these four checks on the converted sheet:

Check	What to confirm	Why it matters
Balances reconcile	The tool reports opening + credits − debits = closing	Surfaces dropped rows and misplaced decimals
Debit / credit split	Two separate columns, correct direction	A merged amount column flips your net movement
Descriptions intact	A wrapped narration stays on one row	Split descriptions invent phantom transactions
Dates read correctly	Day and month not swapped; value date kept	A wrong date lands a transaction in the wrong VAT period

The reconciliation result carries most of the weight. If opening balance plus credits minus debits equals the closing balance printed on the PDF, no row was lost and no figure was mangled badly enough to matter — that is arithmetic proving itself, not a vendor promising it was careful. A converter that just hands you rows and tells you to "review carefully before relying on them" has quietly moved the checking work back onto your desk.

Because ADCB is a tuned format, the column mapping should be right on the first file — but the accuracy check is what actually earns your trust, so glance at the reconciliation banner every time.

Our five-test method for judging any converter, this one included, is laid out in how to verify a bank statement converter.

Step 5 — UAE record-keeping and VAT

A converted spreadsheet is a working tool, not a replacement for the record. Under UAE law the Federal Tax Authority (FTA) requires VAT-registered businesses to retain accounting records — bank statements among them — for at least five years. So:

• Keep the original ADCB PDF. It remains the legal record. The Excel file is the copy you reconcile, categorise and import from.
• Work in AED. ADCB statements are issued in dirhams; keeping the sheet in AED means it lines up with the figures on your VAT return without a currency detour.
• Preserve value dates. VAT is period-bound, so a transaction that slides into the wrong month by a mis-parsed date can distort the wrong return. This is exactly what the date check in Step 4 protects.

Step 6 — Import into Xero, Zoho Books or QuickBooks

Each package wants the sheet shaped slightly differently.

Xero

Go to Accounting → Bank accounts → the ADCB account → Import a Statement, upload the CSV, and map the columns Xero asks for: date, amount (or separate spent/received), description and reference. Set the date format to match your file precisely — Gulf statements are usually DD/MM/YYYY, and a format mismatch here is the classic reason an import silently misreads dates.

Zoho Books

Open Banking → the ADCB account → Import Statement, upload the CSV, then map date, description, withdrawal (debit) and deposit (credit). Save the mapping and Zoho reuses it for next month's file.

QuickBooks Online

Use Transactions → Bank transactions → Upload from file. QuickBooks takes CSV with either one signed amount column or separate debit and credit columns — pick whichever your export produced and map to match. Confirm the dates parsed as real dates, not text, before you accept the batch.

For a side-by-side across all three, see importing bank statements into accounting software.

✅ Import tip: load a single month and reconcile it before batching a whole year. A wrong mapping is far easier to spot across 40 rows than 500.

Common mistakes to avoid

• Converting a scan. A photographed or printed-then-scanned statement has no text layer, forcing OCR and inviting errors. Always start from the native PDF.
• Trusting the CSV export blindly. Bank exports that omit opening and closing balances leave you nothing to reconcile against.
• Skipping the reconciliation banner. Even with a tuned template, the accuracy check is the proof — read it every time.
• Ignoring the date format on import. DD/MM/YYYY versus MM/DD/YYYY is the single most common way transactions land in the wrong VAT period.
• Deleting the PDF. It is your five-year FTA record. Keep it.

Why in-browser processing matters here

An ADCB statement is not a neutral file. One month of a trading company's account lays bare its suppliers, customers, payroll, margins and cash position — the exact map 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, and you inherit that vendor's storage practices, retention window and breach exposure — usually under terms nobody at the practice ever read.

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

⚡ Prove it in fifteen seconds. Switch off your Wi-Fi and convert a statement anyway. A browser-based tool keeps working because nothing needs sending. A tool that uploads will stall. No marketing claim can fake that.

Quick reference

Question	Answer
Where do I get the PDF?	ADCB Personal Internet Banking or the ADCB mobile app, Accounts → Statements
Password?	Formula is in the covering email; in-banking downloads are often unencrypted
Tuned template?	Yes — ADCB has a hand-mapped layout, 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 is the FTA record for five years; the sheet is the working copy

Ready to try it on a real ADCB file? Start at the ADCB converter — the first 10 pages are free and no card is required. More UAE guides live on the blog.