How to Import a PDF Bank Statement into QuickBooks, Xero & Excel

Here's the thing nobody tells you up front: QuickBooks and Xero can't read a PDF bank statement directly. They import structured transaction files — CSV, QBO, QFX, OFX — not the PDF your bank hands you. So the workflow is always two steps: convert the PDF to a supported file, then import that.

Step 1: Convert the PDF to CSV

CSV is the format both QuickBooks and Xero accept, so it's the safe target. Open your statement in a converter, review the detected transactions, and export to CSV.

Convert your bank statement with stmtify — it runs entirely in your browser, so your statement is never uploaded to a server. It's free, needs no signup, and works with statements from any bank.

For details on getting a clean export, see how to convert a bank statement to CSV.

Step 2a: Import into QuickBooks Online

1. Go to Transactions → Bank transactions.
2. Select the account, then Link account → Upload from file (or Upload transactions).
3. Choose your CSV file.
4. Map the columns — tell QuickBooks which column is the date, the description, and the amount. If debits and credits are in separate columns, choose the two-column option.
5. Confirm the date format, then import and review.

QuickBooks also accepts QBO/QFX/OFX files; some converters can produce QBO directly, but CSV works for every bank.

Step 2b: Import into Xero

1. Open the bank account and choose Manage account → Import a statement.
2. Upload your CSV.
3. Map your columns to Xero's fields (date, amount, payee, description, reference).
4. Save the mapping as a template so future imports are one click.

Xero offers direct PDF import on some plans, but it's bank- and region-dependent. The convert-to-CSV route works regardless of who you bank with.

Step 3 (optional): Just work in Excel

If you're reconciling by hand rather than feeding accounting software, skip the import and export to Excel instead — see converting a bank statement to Excel.

Tips for a clean import

• Match the date format. A DD/MM vs MM/DD mismatch silently scrambles your dates — set it explicitly during import.
• Decide on the amount layout. Some systems want one signed amount column; others want separate debit and credit columns. Export to match.
• Don't double-import. Importing overlapping date ranges creates duplicate transactions that you'll have to delete by hand.
• Verify the totals against your statement before you reconcile.