How to Convert a Dubai Islamic Bank Statement to Excel (UAE Guide)

At VAT-return time a Dubai Islamic Bank statement tends to become the bottleneck. Every profit distribution, murabaha instalment and card payment is sitting there on the PDF, correctly dated and described — but locked inside a document built to be read, not summed. Retyping a quarter of DIB transactions by hand is slow, and every keyed row is a chance to transpose a figure that only surfaces weeks later when a reconciliation refuses to close.

This guide takes the whole route end to end: pulling the statement out of DIB, dealing with the password, converting it to Excel or CSV with the tuned template, checking the arithmetic survived, meeting your Federal Tax Authority record-keeping obligations, and importing the result into Xero, Zoho Books or QuickBooks.

🕌 A quick note on Islamic banking. Dubai Islamic Bank is the world's first full-service Islamic bank, and its statements reflect that: instead of an interest line you see profit distributions, murabaha instalments, ijara rentals and Takaful charges. That changes the wording on the page, not the shape of the data. Every one of those is still a dated row with a debit or a credit, so the converter reads and reconciles them exactly like any conventional statement.

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, and that text layer is what makes clean extraction possible.

From DIB Online Banking (desktop)

1. Sign in to DIB Online Banking in your browser.
2. Open Accounts and select the account you need.
3. Choose Statement (sometimes shown as Account Statement or e-Statement).
4. Pick the period. Full statement-cycle periods are cleaner than custom date ranges, because the opening and closing balances are printed on the document — and those two figures are exactly what the reconciliation check depends on.
5. Download in PDF format.

From the DIB 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 — emailing it to yourself or saving it to files both work.

💡 Prefer the download over the emailed copy. Statements you pull while signed 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 DIB accounts offer a direct CSV or Excel export. If you can get it, take it — but inspect it. Bank-generated spreadsheets often drop 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 usually the safer artefact.

Step 2 — Handle the password-protected PDF

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

Like most UAE banks, DIB derives the password from details you already hold, and the covering email states the exact formula. Common ingredients across Gulf banks include:

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 waste time, and the wording is right there in front of you.

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 anywhere.
• Save an unlocked copy. Open the PDF, enter the password, then use Print → Save as PDF to write out a decrypted version. Be aware this can rasterise some documents, turning selectable text into an image and forcing OCR, which lowers 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 with the tuned Dubai Islamic Bank template

This is where DIB gets easier than most banks. BayanSheet ships a tuned Dubai Islamic Bank template — the engine already knows the DIB statement layout, so it does not have to guess which column is the date, which is the debit, which is the credit and which is the running balance. That means fewer surprises on the very first file and consistent mapping across statement formats.

1. Open the Dubai Islamic Bank converter in your browser.
2. Drag the DIB 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 template maps the date, description, debit, credit and balance columns and extracts every row — profit, murabaha, ijara and ordinary card lines all included.
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, not silently emitted.
6. Download the result as Excel (.xlsx) or CSV, whichever your accounting software prefers.

Nothing is uploaded at any point in that sequence. The parsing runs as JavaScript inside the browser tab you already have open — no server, no stored copy.

⚡ 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.

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 resurfaces three weeks later as a reconciliation that will not close.

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 murabaha or profit 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. A converter that simply hands you rows and tells you to "review carefully before making financial decisions" is quietly transferring the checking work back to you.

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

A converted statement is not just convenient — it feeds a legal obligation. The UAE Federal Tax Authority (FTA) requires businesses to keep accounting records, bank statements included, for at least five years, and VAT is filed in AED.

Two practical habits keep you compliant:

• Keep the original DIB PDF as the record. It stays the authoritative document. The Excel or CSV is the working copy you actually post and calculate from — not a replacement for the source.
• Keep amounts in AED and dates exact. DIB statements are already in dirhams, so no conversion is needed; your job is to make sure the converter preserved the figures and read DD/MM/YYYY dates the right way round, so each transaction falls into the correct tax period.

✅ VAT tip: reconcile each DIB statement the month it lands rather than in a quarter-end rush. A flagged row is trivial to fix against a fresh statement and painful to chase three months later.

Step 6 — Import into Xero, Zoho Books or QuickBooks

Each package wants a slightly different shape.

Xero

Use Accounting → Bank accounts → the DIB account → Manage account → Import a statement. Xero accepts CSV; map date, description, and either a single signed amount column or separate debit and credit columns. Set the date format to match your file exactly — mismatching DD/MM/YYYY is the most common Xero import failure.

Zoho Books

Go to Banking → the relevant account → Import Statement, upload the CSV, then map date, description, debit (withdrawal), credit (deposit) and optionally reference. Save the mapping and Zoho reuses it next month.

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. Confirm the dates parsed as dates rather than text before you accept the batch.

Common mistakes to avoid

Mistake	Consequence	Fix
Converting a scanned or photographed statement	OCR guesswork, lower accuracy	Always use the native PDF from DIB
Ignoring the reconciliation flag	A dropped or misread row reaches the ledger	Resolve every flagged row before exporting
Treating profit/murabaha lines as "special"	Manual re-entry and errors	Let the template extract them like any other row
Discarding the original PDF	Fails FTA's five-year record rule	Archive the PDF as the legal record
Importing a year at once, unmapped	500 mis-mapped rows to untangle	Import one month, reconcile, then batch

Conclusion

A Dubai Islamic Bank statement carries everything your books need — it is just wrapped in a format built for reading, not posting. With a tuned DIB template, a reconciliation check that flags any row that does not add up, and parsing that never leaves your browser, converting one is a matter of seconds rather than an afternoon of retyping. Profit, murabaha and ijara lines all come across the same as any other transaction, and the original PDF stays put as your FTA record.

Ready to try it on a real file? Start with the Dubai Islamic Bank converter — the first 10 pages are free and no card is required. For more UAE bank guides, browse the blog.