Guides

How to Import Bank Statements into Xero

Xero bank feeds miss months. A feed starts late, a bank is not supported, or a client only sends PDFs. In those cases you import the statement yourself. This guide shows how to import bank statements into Xero from a PDF: convert the file with bank statement converter, reshape it to Xero's signed-amount rule, upload it, and check it before you reconcile.

When you need to import bank statements into Xero by hand

Use a manual import when the feed cannot give you the lines. Common cases are history from before the feed started, a closed account, a bank with no Xero feed, or a gap left by a feed outage. Xero itself frames manual import for exactly those gaps.

Do not import a whole period blindly. First check which dates are already in Xero for that account. Importing lines that already exist creates duplicates that you then have to hunt down in the reconciliation queue.

  • Write down the missing date range for the one bank account.
  • Keep each bank and card account in a separate file.
  • Keep the original PDF beside the converted file, so any row can be traced back.

Step 1: Convert the PDF to a file Xero can read

Xero does not build statement lines directly from most PDF statements, so convert the PDF first. Drop it into the bank statement converter and review every row against the PDF page. Check the balance result before you download: opening balance plus money in, minus money out, should equal the closing balance.

That balance check matters more for Xero than for a spreadsheet. A spreadsheet error stays visible. A wrong statement line in Xero can be matched to an invoice and reconciled before anyone notices. Our guide on how to check a bank statement conversion explains the test in detail.

Download CSV for the simplest Xero route, or OFX if you will import the same account every month. OFX carries a transaction ID for each line, which helps Xero spot duplicates. Our comparison of OFX, QBO and QIF formats explains why QBO, the QuickBooks variant, is not the file to send to Xero.

Step 2: Reshape the CSV to Xero's rules

Xero only requires two fields: Date and Amount. Everything else is optional, but Payee, Description and Reference make reconciliation much faster, because Xero can suggest matches from those words.

Xero fieldRequiredWhat to put there
DateYesTransaction date in one consistent format, for example 2026-03-14
AmountYesOne signed column: money in positive, money out negative
PayeeNoWho paid you, or who you paid
DescriptionNoThe statement line narrative
ReferenceNoBank reference, cheque number or invoice number
The Xero CSV shape: what each column should hold.

The signed Amount column is where most imports go wrong. A normal statement conversion gives you separate money-in and money-out columns. Xero wants them combined: a $1,200 deposit becomes 1200.00, and a $45 fee becomes -45.00. If you upload two columns and map only one, half the statement will be missing or have the wrong sign.

  • Remove the running Balance column, the account number and any summary rows. Xero ignores balance on import, and summary rows are not transactions.
  • Remove currency symbols, commas inside numbers and blank rows.
  • Use one date format throughout, and remember which one you chose. You will confirm it during import.
  • Keep one transaction per row, even when the PDF wrapped its description over two lines.
If you prefer separate Debit and Credit columns, Xero's importer can map those instead of a single Amount column. Pick one shape or the other for a file — do not mix both.

Step 3: Import bank statements into Xero, step by step

  1. In Xero, open Accounting, then Bank accounts.
  2. Find the account you want, open its menu, and choose Import a Statement.
  3. Upload the CSV or OFX file and click Next.
  4. For CSV, assign each column to a Xero field. Date and Amount must be assigned. Xero remembers your mapping for the next file with the same headers.
  5. Confirm the date format matches the format in your file.
  6. Review the preview. Untick any line you do not want, especially lines that overlap a feed or an earlier import.
  7. Complete the import. The lines land in the account's reconciliation queue as statement lines — they are not reconciled yet.

After import, reconcile as normal: match lines to invoices and bills, or create transactions where no match exists. Importing and reconciling are two separate jobs, and keeping them separate is what lets you review the file before it touches the ledger.

Duplicates, date errors and other import problems

ProblemLikely causeWhat to do
Dates are a month and day swappedFile uses DD/MM/YYYY but Xero read MM/DD/YYYY, or the reverseRe-import with the correct date format confirmed at the import step; delete the wrong lines first
Money out shows as money inSeparate in/out columns were mapped as one unsigned AmountCombine them into a signed Amount column and re-import
The same lines appear twiceThe period overlaps a bank feed or a previous importDelete the duplicate statement lines, then narrow the next file to the missing dates only
Import fails or times outVery large file or blank rows throughoutRemove blank rows and split large histories into monthly files
A row imports as 0.00A summary or fee note was converted as a transactionRemove zero rows before import; Xero cannot use them as statement lines
Problems people hit when they import bank statements into Xero, and the fix for each.

If a statement will not reconcile after import, work backwards from the totals. Compare the imported total for the month with the PDF closing balance movement. If the totals differ, the file was wrong before Xero saw it — go back to the conversion check rather than fixing lines one by one in Xero.

Xero or QuickBooks? The file choice is different

If you also work in QuickBooks, do not reuse the same export without thinking. QuickBooks Online wants its own CSV mapping, and QuickBooks Desktop uses QBO. Xero accepts OFX and CSV, and rejects QBO. Our guide to importing bank statements into QuickBooks covers that side, so you can keep one clean conversion and export the right file for each system.

Whichever system you use, the workflow is the same at its core: get a clean, balance-checked file from the bank statement converter, reshape only what the target system requires, import a defined date range, and review before you reconcile. That habit turns a messy historical cleanup — a shoebox of PDFs from a new client — into a set of monthly imports you can prove, one statement at a time.

Sources and further reading

Put it into practice

Convert a statement now and watch the balance check run on your own file. The first 10 pages each month are free, and exports are never cut short.

Convert a statement See plans

More guides

How to Convert a Bank Statement PDF to CSV · How to Convert a Bank Statement PDF to Excel · How to Import Bank Statements into QuickBooks (QBO Files) · OFX vs. QBO vs. QIF: Which Format Should You Download? · Why a Converted Bank Statement Does Not Balance — and How to Fix It · How to Check a Converted Bank Statement Is Correct · Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not · How to Convert a Password-Protected Bank Statement PDF · How to Convert Many Bank Statements at Once (and Merge Them Cleanly) · Is It Safe to Convert Bank Statements Online? A Privacy Checklist · How to Reconcile a Bank Statement in Excel After Converting PDF to CSV