How to Convert a FAB (First Abu Dhabi Bank) Statement to Excel

First Abu Dhabi Bank is the UAE's largest bank by assets, which means a FAB statement lands on more bookkeepers' desks than almost any other document in the country. It is also one of the most tedious to work with. The transactions are all there — dated, described, debited and credited in dirhams — but locked inside a PDF designed to be read, not calculated with. Retyping a FAB statement by hand is slow, and it is the single worst way to prepare figures for a VAT return, because every mistyped decimal or transposed date is a number the Federal Tax Authority could one day ask you to justify.

This guide walks the whole path: getting the statement out of FAB, dealing with the password, converting it to Excel or CSV with our dedicated tuned FAB template, verifying the numbers survived the trip, and importing the result into Xero, Zoho Books or QuickBooks.

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 FAB online banking (desktop)

1. Sign in to FAB online banking in your browser.
2. Open the account you need from the accounts summary.
3. Go to Accounts → Statement (sometimes shown as e-Statement or Account Statement).
4. Choose 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 FAB Mobile app

1. Open the app and authenticate.
2. Tap the account, then the statement or documents 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. And if you are preparing a quarter for filing, pull the whole period in one file rather than month by month — one file means one reconciliation check instead of three.

Step 2 — Handle the password-protected PDF

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

Like most UAE banks, FAB 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 via Print → Save as PDF. Note that this can rasterise some documents, turning selectable text into an image and forcing OCR, which reduces accuracy. Prefer converting the original.

There is a fuller treatment 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 to Excel or CSV with the tuned FAB template

Unlike generic converters that guess at every layout, BayanSheet ships a hand-tuned template built and tested specifically for First Abu Dhabi Bank statements. It knows FAB's column order, its AED amount formatting and its mixed Arabic/English narration, so the columns land in the right places on the first pass — with far less manual cleanup than an auto-detected layout.

1. Open the FAB converter in your browser and load the PDF.
2. If the file is encrypted, enter the password when prompted. It stays on your machine.
3. The tuned template maps the date, description, debit, credit and balance columns and extracts every row.
4. The reconciliation check runs automatically (see below).
5. Download as Excel (.xlsx) for working in a spreadsheet, or CSV for accounting import.

Nothing is uploaded at any point. The parsing runs as JavaScript inside the browser tab you already have open.

⚡ Prove the privacy claim 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 — and for a client's FAB account, which exposes their suppliers, customers, payroll and cash position, that is exactly the property you want.

Even with a tuned template, a quick sample review of the rows stays good practice — not because the tool errs, but because checking is a professional rule before any number reaches the books.

Step 4 — Verify the output before it touches your ledger

The costly error in statement extraction is rarely the loud one; it is the silent one — a dropped row, a misread decimal, a debit that landed in the credit column. The table looks perfectly fine, and the problem surfaces three weeks later as a reconciliation that will not close.

The governing equation:

Opening balance + total credits − total debits = closing balance

Run these checks on the converted file:

Check	What to look for	Why it matters
Balances reconcile	Opening + credits − debits = the printed closing balance	Catches dropped rows and misread decimals
Row completeness	Row count matches the PDF's transactions	Missing or duplicated lines throw the totals
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

BayanSheet runs this check automatically after every conversion and flags any row whose arithmetic does not add up. That result does the heavy lifting: if opening 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. Our five-test method for evaluating any converter, including this one, is in how to verify a bank statement converter.

Step 5 — UAE record-keeping and VAT

For a VAT-registered business, the bank statement is a core supporting document: it reconciles declared sales against money actually received, and traces the supplier payments behind your input tax.

📁 Core rule: the Excel file is a working copy, not a replacement for the original record. The Federal Tax Authority requires accounting records and supporting documents to be kept for the statutory period — generally five years, longer in certain cases — and the bank's original PDF, in AED, stays the document of authority at audit. Keep both: the PDF as the record, the Excel as the tool.

A tidy arrangement that pays off at audit:

• Name files consistently: FAB_account-number_2026-Q1.pdf beside a matching .xlsx.
• Keep the balance column in the Excel file even after classification — it is the fastest way to trace any discrepancy.
• Add a column for VAT treatment (standard, exempt, out of scope) rather than editing the original narration.
• Do not delete non-VAT rows; keeping them keeps the sheet faithful to the statement.

Step 6 — Import into Xero, Zoho Books or QuickBooks

Each package wants a slightly different shape.

• Xero: use Accounting → Bank accounts → Import a Statement, upload the CSV, and map date, description, and amount (or separate debit/credit). Set the date format to DD/MM/YYYY — the usual Gulf convention — and Xero remembers the mapping next month.
• Zoho Books: go to Banking → the account → Import Statement, then map date, description, withdrawal (debit) and deposit (credit). Matching the date format exactly is the single most common import failure.
• QuickBooks Online: use Transactions → Bank transactions → Upload from file. It accepts either a single signed amount column or separate debit and credit columns — pick whichever matches your export, and confirm dates parsed as dates, not text.

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

Common mistakes

• Converting a screenshot or scan instead of the original text-layer PDF.
• Skipping the reconciliation check because the table "looks fine".
• Keeping only the Excel file and deleting the original FAB PDF — an error that shows up at a tax audit.
• Editing original transaction narration instead of adding new classification columns.

Conclusion

Converting a FAB statement to Excel saves hours of manual entry, but the real value is in Step 4: verifying that the balances reconcile before the numbers reach your ledger. Download the original PDF, unlock it if needed, convert it through the dedicated tuned template, check the reconciliation, then import — and always keep the PDF as your record of authority.

Try it on a single file at the FAB converter and compare the output to the PDF in front of you — the first 10 pages are free and no card is required. For more accounting guides, browse the BayanSheet blog.