Export Bank Statement — bank statement PDF to Excel
linkXero · read-only connection

Bank statement PDFs into Xero

When a bank feed breaks or a client sends a year of PDFs, you still need statement lines in Xero. Convert the PDF, check it balances, and import lines you can reconcile normally.

Export Bank Statement connects to Xero read-only and converts bank statement PDFs into Xero's statement-import CSV or an OFX file. Before you download, it checks that opening balance plus credits minus debits equals the closing balance printed on the statement. In Xero you import the file from the bank account's Manage Account → Import a Statement menu, and the lines arrive ready to reconcile.

  • check_circleChecked to the closing balance
  • check_circleScanned PDFs too
  • check_circleFiles deleted after processing
How it works

From PDF to Xero in four steps

link
1

Connect Xero

From your account page, sign in with Xero and choose the organisation to share.

upload_file
2

Convert the statement

Upload the PDF. Scans and multi-account statements are handled.

download
3

Download Xero CSV or OFX

Built from figures that already tie to the statement's closing balance.

fact_check
4

Import and reconcile

In Xero: bank account → Manage Account → Import a Statement, then reconcile line by line.

verified

Statement lines, not coded transactions

Xero's API would let us push transactions that are already coded to an account, but that means guessing the account and skipping reconciliation. A statement import gives you lines to reconcile yourself, which is what a bookkeeper wants, so that's the route we use. The connection itself is read-only.
Why it helps

What you get with Xero

verified

Nothing half-imported

Xero will happily accept a file that's missing a page of transactions. The balance check catches that before the import, not at the next reconciliation.

history

Useful for catch-up work

Backfilling months before a feed started, or a year-end for a new client, is where PDF statements pile up. Convert them in one sitting.

account_tree

Several accounts in one PDF

Statements that bundle a current and a savings account are split into separate statements, so each imports into the right Xero bank account.

lock_open

Locked PDFs stay private

Password-protected statements are unlocked in your browser. The password is never sent to us.

Formats

Files Xero can import

Xero CSV

Matches Xero's statement import columns.

Paid plans

OFX 1.0.2

Xero also accepts OFX statement files.

Paid plans

QIF

For older workflows that still use it.

Paid plans

Excel and CSV

Free, for checking figures first.

Free

Paid plans start with Starter. See pricing for your currency.

Questions

Frequently asked questions

Is this a Xero bank feed?expand_more

No. Bank feeds come from banks through Xero's partner programme. This converts statement PDFs into files you import, which is the right tool for backfills, closed accounts, and banks without a feed.

Does it write anything to my Xero organisation?expand_more

No. The connection is read-only. You import the statement file yourself.

Where do I import the file in Xero?expand_more

Open the bank account in Xero, choose Manage Account, then Import a Statement. Select the CSV or OFX file and follow the prompts.

Do I need a paid plan?expand_more

Converting and downloading Excel, CSV or JSON is free. The Xero CSV, OFX and QIF exports are included with every paid plan, starting with Starter.

How do I disconnect Xero?expand_more

Click Disconnect from Xero on your account page. You can also remove the connection from Xero's connected apps settings.

verifiedChecked to balance

Convert your bank statement — every transaction verified

Upload any PDF, get clean Excel or CSV ready for Xero & QuickBooks. Scanned statements too.

upload_fileConvert a statement free