How to Import Bank Statements into Zoho Books, QuickBooks & Xero

Every accountant in the UAE eventually hits the same wall: the bank sends a PDF, but Zoho Books, QuickBooks Online and Xero all want structured data. You cannot simply drag a PDF into your accounting software and expect it to book transactions. This guide walks through why that is, and exactly how to import a bank statement into accounting software using a clean CSV.

Why accounting software needs a CSV, not a PDF

A PDF statement is designed for humans to read. It looks like a table, but to a computer it is just text and lines placed on a page. There are no defined columns, no reliable row boundaries, and often no consistent spacing. Your accounting software has no way to know which number is a debit, which is a credit, and which is a running balance.

A CSV (comma-separated values) file is the opposite. It is pure structured data: one row per transaction, with clearly separated columns. When you upload a CSV, Zoho Books, QuickBooks or Xero can ask you to map each column to a field it understands, then import hundreds of transactions in seconds. That mapping step is only possible when the data is already clean and columnar.

How to get a clean CSV from a PDF statement

The reliable path is to convert the PDF first. Using the BayanSheet converter, you upload your statement and it extracts every transaction into a proper spreadsheet, entirely in your browser. Nothing is uploaded to a server, which matters when you are handling a client's confidential banking data.

BayanSheet is built for Gulf and UAE banks, so it recognises the layouts used by Emirates NBD, ADCB, FAB, Mashreq and others. The first 10 pages are free, and you can export directly to CSV, the format your accounting software prefers. If you want a deeper walkthrough of the conversion itself, see how to convert a bank statement to Excel.

A good CSV for import should have, at minimum:

• A date column in DD/MM/YYYY format
• A description or narration column
• Separate debit and credit columns
• Optionally, a balance column for verification

Keep debits and credits in separate columns

This is the single most common cause of a broken import. Some statements list all amounts in one column, using a minus sign or a "DR/CR" flag. Accounting software handles this far more reliably when debits (money out) and credits (money in) sit in two distinct columns.

When your CSV keeps them separate, the mapping is unambiguous: the software knows a value in the credit column increased your balance and a value in the debit column reduced it. BayanSheet outputs debits and credits in their own columns by default, so you avoid the sign-error headaches that lead to reversed transactions.

Get the date format right

UAE banks almost always print dates as DD/MM/YYYY. If your accounting software assumes the US MM/DD/YYYY order, "05/07/2026" becomes 7 May instead of 5 July. Every import screen in Zoho, QuickBooks and Xero lets you pick the date format during mapping. Set it to DD/MM/YYYY and confirm a few sample rows look correct before you commit.

Importing into Zoho Books

1. Go to Banking, select the relevant bank or credit card account.
2. Choose Import Statement and upload your CSV.
3. On the mapping screen, match your columns: Date to Date, Description to Description, Debit to Withdrawals, Credit to Deposits.
4. Set the date format to DD/MM/YYYY.
5. Preview, then import. Zoho will list the transactions for categorisation.

Importing into QuickBooks Online

1. Open Transactions or Banking, then select Upload from file.
2. Choose your CSV and pick the bank account.
3. Map the columns. QuickBooks lets you use either a single amount column or separate credit and debit columns, choose the two-column option.
4. Confirm the DD/MM/YYYY date format.
5. Review the preview and import. Transactions land in the "For review" tab.

Importing into Xero

1. In the target bank account, choose Manage Account, then Import a Statement.
2. Upload the CSV.
3. Map Date, Description, and your Debit and Credit columns (Xero calls these amounts spent and received).
4. Set the statement date format to DD/MM/YYYY.
5. Import, then reconcile against your invoices and bills.

Verify reconciliation before you import

Before uploading anything, confirm the file is complete. BayanSheet runs a reconciliation check that compares the opening balance, all debits and credits, and the closing balance to make sure nothing was dropped during conversion. If the totals tie out, you can import with confidence. If they do not, you catch the gap now, on your screen, rather than three weeks later when the account will not reconcile at month-end.

A quick manual check helps too: does the number of rows in your CSV match the number of transactions on the PDF? Does the final balance match the statement? Two minutes here saves hours of chasing a mismatch later.

The short version

Accounting software runs on structured data, so the whole job comes down to producing one clean, verified CSV: separate debit and credit columns, DD/MM/YYYY dates, and a reconciliation check that ties out. Convert the PDF, confirm the totals, then let Zoho, QuickBooks or Xero do the heavy lifting.

Ready to try it on your next statement? Convert your first 10 pages free with BayanSheet, no upload, no sign-up friction, just a clean CSV ready to import.