How to Import Bank Statement PDFs into QuickBooks & Xero (2026 Guide)

If your bank only gives you a PDF and your accounting software is asking for a CSV or QBO file, you've hit one of the most common gaps in small business bookkeeping. Neither QuickBooks nor Xero reads PDFs directly — here's the actual path from statement to clean import.

Why you can't just upload the PDF

QuickBooks and Xero are both built to read structured transaction data — a file where every row is clearly a date, a description, and an amount, in a format the software already understands (CSV, OFX, QFX, or QBO). A PDF is a visual document, not structured data; there's no reliable way for accounting software to know where one transaction ends and the next begins just by reading the page layout. You have to convert first.

The three format options, and which to use

• QBO (Web Connect) — the fastest option if available. QuickBooks reads it natively with no column mapping, no date-format guessing, and no sign confusion on debits vs credits. Not all banks offer a direct QBO download, especially for statements older than 90 days.
• CSV — the most universal option. Every bank and every converter can produce one, and both QuickBooks and Xero accept it. The trade-off is you'll map columns (date, description, amount) yourself during import.
• OFX/QFX — Xero's preferred direct-import format, similar tradeoffs to QBO for QuickBooks.

If your bank statement is a PDF and you need a QBO or OFX file, you'll typically convert to CSV first, then either import the CSV directly or use a converter that outputs QBO/Xero-ready formats.

Step-by-step: PDF to QuickBooks

1. Convert the PDF to Excel or CSV. BankConvert extracts transaction rows directly from the PDF — no manual retyping.
2. In QuickBooks Online, go to Banking → Upload transactions, and select the account the statement belongs to.
3. Browse for your CSV file and upload it.
4. Map the columns when prompted — date, description, and amount. If your file has separate debit and credit columns rather than one signed amount column, QuickBooks will ask you to map both.
5. Review before confirming. QuickBooks will show a preview of the transactions it's about to import — check the count and a few sample rows against your original statement before finalizing.

Step-by-step: PDF to Xero

1. Convert the PDF to Excel or CSV, same as above.
2. In Xero, go to Accounting → Bank Accounts, select the relevant account.
3. Click Import a Statement and select your CSV (or OFX/QFX if you have one).
4. Map the columns — Xero needs date, amount, and payee/description at minimum.
5. Review the import summary before confirming, checking transaction count and a handful of sample rows.

Common import errors and how to avoid them

• Date format mismatches — US (MM/DD/YYYY) vs international (DD/MM/YYYY) dates get silently misread if the software assumes the wrong format. Check a few dates near the start and end of the month after import; if they look shifted, fix the format before re-importing.
• Sign confusion on debits/credits — if your converted file has a single "amount" column instead of separate debit/credit columns, make sure negative numbers consistently mean withdrawals (or consistently mean deposits) before importing, not a mix of both conventions.
• Duplicate transactions — if you've previously connected your bank account for direct feed and are now also importing a PDF-derived file for the same period, you'll get duplicates. Check for existing transactions in that date range before importing.
• Missing transactions from wrapped descriptions — some PDF layouts wrap long transaction descriptions onto a second line, and low-quality converters treat that second line as a separate (empty) transaction. Verify your row count matches your bank statement's stated transaction count before importing.

Before you import: verify the conversion

Whatever converter you use, check these four things before trusting the file enough to import it into your books:

1. Row count matches the transaction count on the statement
2. Opening and closing balances match
3. Deposit and withdrawal totals match the statement totals
4. A handful of spot-checked transactions match exactly

Fixing a bad import after the fact — hunting through QuickBooks or Xero for the wrong entries — takes far longer than catching it before you click import.

The bottom line

The PDF-to-accounting-software gap is a one-extra-step problem, not a hard one, once you have a reliable way to get from PDF to clean Excel or CSV. From there, both QuickBooks and Xero's import flows are straightforward.

Try BankConvert free to convert your next statement, then follow the steps above to bring it into QuickBooks or Xero.