How to Import Bank Statements into Xero (CSV, OFX, PDF)

Xero works best with a live bank feed, but almost every Xero user eventually needs to import a statement manually. The feed might start only from the day it was connected, a bank might not offer one, a feed may have dropped transactions, or you might be catching up a client who sent a year of PDF statements.

This guide explains exactly how statement imports work in Xero, how to build a CSV that imports cleanly, how to turn PDF statements into that CSV, and how to deal with duplicates, sign errors and date problems. Menu labels occasionally change as Xero updates its interface, so look for the nearest equivalent if your screen differs.

How Xero treats imported statements

Understanding the model avoids most confusion. In Xero, bank data comes in as statement lines, which are the bank's version of events. Your accounting entries are transactions (invoices, bills, spend money, receive money, transfers). Reconciliation is the act of pairing each statement line with a transaction, either by matching to an existing one or by creating a new one.

Importing a statement therefore does not change your accounts directly. It populates the Reconcile tab with lines waiting for you to deal with. That is why imported data can be safely reviewed before it affects reports, and also why imported lines that are never reconciled simply sit there as a growing backlog.

Supported file formats

Format	Supported	Notes
CSV	Yes	Most flexible; you map columns on import
OFX	Yes	Bank-feed style file with unique transaction IDs
QIF	Yes	Older format; less detail than OFX
QBO / QFX	Often accepted	Variants of OFX; test with your file
Excel (.xlsx)	No	Save as CSV first
PDF	No	Convert first

If your bank offers OFX downloads for the period you need, that is usually the cleanest option. For PDFs and older periods, CSV gives you the most control. Our format comparison explains the differences.

The Xero CSV layout

Xero accepts a CSV with these columns (only the first two are essential):

Column	Required	Example
Date	Yes	04/03/2026
Amount	Yes	-1850.00
Payee	Recommended	Elm Street Props
Description	Recommended	Rent March
Reference	Optional	INV-1042
Cheque number	Optional	1045

Guidelines:

Signs matter. Money received is positive, money spent is negative. If you import a file with only positive numbers, every line will appear as money received.
Use one date format throughout, and choose it correctly during import. Xero is used widely in countries that write dates day-first, so a US-format file needs extra care.
No currency symbols or thousands separators in the Amount column.
Put the counterparty in Payee. Xero's reconciliation suggestions and bank rules work best when the payee is clean and consistent.
Remove opening balance and total rows, page headers, and blank lines.
Keep files reasonably small. Xero applies a file size limit; split large histories into one file per statement period.

Our Xero CSV export produces this layout from PDF, scanned or photographed statements, with Payee and Description separated where the statement allows.

Step-by-step: importing a statement into Xero

Open the bank account. Go to the bank accounts screen (under Accounting) and find the account you want.
Choose Manage Account > Import a Statement. If the account does not exist yet, add it first, choosing the correct type (bank or credit card) and currency.
Browse to the file and select it.
Map columns (CSV only). Assign each column to a Xero field, choose the date format and tick whether the first row contains headings. Xero remembers your mapping for future imports to the same account.
Review the import summary. Xero shows how many lines will be imported and may warn about lines that look like duplicates.
Import. The lines appear in the account's Reconcile tab.
Reconcile. Match each line with an existing transaction, create a new transaction, use a bank rule, or create a transfer for movements between your own accounts.
Compare balances. When finished, compare the statement balance shown in Xero with the closing balance on the bank statement for the same date.

Importing credit card statements

Credit card accounts in Xero work the same way, with one twist: the sign logic is from the card account's perspective. Purchases are money spent (negative), and payments to the card and refunds are money received (positive).

Card statements often print purchases as positive amounts and payments as negatives, so a direct copy usually needs its signs flipped before import. Do a one-month test and compare Xero's statement balance with the card statement's new balance; if they differ by roughly double the period's activity, the signs are reversed.

When the card payment appears in both the bank account and the card account, reconcile it as a transfer, not as an expense. Our article on bank vs credit card statements explains why double counting happens.

Converting PDF statements to a Xero CSV

Xero cannot read PDFs, so PDF statements need converting first. The reliable workflow:

Upload the statement to a converter that understands statement layouts, such as our bank statement to Xero tool. It handles digital PDFs, scans and phone photos.
Check the balance proof. The converter compares the extracted transactions with the statement's opening and closing balances, and with any printed running balance. A statement that reconciles has no missing or duplicated rows.
Fix anything flagged in the review table, for example a wrapped description or a smudged digit on a scan.
Download the Xero CSV, choosing the date format you will select in Xero.
Import into Xero as above, one statement per file.

The same approach works for converting PDFs to Excel for review first; see how to convert a bank statement PDF to Excel. Avoid generic PDF-to-CSV tools that produce a visual copy of the page; they rarely produce the clean Date and Amount columns Xero needs.

Choosing a PDF to CSV converter for Xero

If you are evaluating converters specifically for Xero work, these features matter most:

Xero-specific CSV output with signed amounts and separate Payee and Description columns.
Balance verification, so you know each file is complete before import.
Scan and photo support for older or client-supplied statements.
Batch processing for catch-up jobs covering many months.
Date format control, especially if you work with clients in several countries.
Data retention and security appropriate for client financial data.

Our roundup of the best bank statement converters compares options in more depth.

Worked example: a twelve-month catch-up

A bookkeeper takes on a café that has used Xero since July but never connected its business current account. The owner provides twelve monthly PDF statements, July to June, and the café also connected its credit card feed in October.

1. Plan the boundaries. The current account has no feed, so all twelve statements are needed. The credit card has a feed from October, so only the July, August and September card statements need importing.

2. Convert and verify. All fifteen PDFs are converted to Xero CSV. Two of the bank statements are scans the owner photographed, and the converter flags one row on each where a digit was unclear. Comparing against the printed running balance resolves both before export. Every file reproduces its statement's closing balance.

3. Check opening balances. The July statement's opening balance matches the conversion balance entered in Xero for the bank account, so no adjustment is needed. If it had not matched, the bookkeeper would fix the conversion balance first rather than importing on top of a wrong starting point.

4. Import month by month. Each file is imported and reconciled before the next. The first month takes the longest because bank rules do not exist yet. By the third month, rules for the coffee supplier, rent, card processor payouts and the bank's monthly fee handle most lines automatically.

5. Handle the card payments. Each month's payment from the current account to the credit card is reconciled as a transfer on both sides, so it is never counted as an expense.

6. Confirm. At the end, Xero's statement balance for each account equals the June closing balance on the bank and card statements. The bookkeeper saves the PDFs and the converted CSVs in the client's document folder for the year-end file.

The total time is dominated by reconciliation decisions, not data entry, which is exactly where a bookkeeper's judgement adds value.

Building good bank rules from imported data

Bank rules are where imports pay off over time. A few principles keep them reliable:

Base rules on the payee, not the full description. Descriptions often contain dates, reference numbers or card digits that change every month. A clean Payee column makes rules far more stable.
Be specific with amounts only when amounts are fixed. A rule for a fixed monthly rent can include the amount; a rule for a utility bill cannot.
Avoid over-broad keywords. A rule that matches "AMAZON" may sweep business supplies and personal purchases into the same account.
Review rules quarterly. Supplier changes and new services make old rules wrong without anyone noticing.
Document why each rule exists, especially in a firm where several people work on the same client.

Our guide to categorising business expenses offers a starting chart of accounts and categorisation logic that translates directly into rules.

Avoiding duplicate statement lines

Duplicates are the most common problem with manual imports, especially when a bank feed is also connected.

Know where the feed begins. Import only statement periods before the feed's first transaction, or periods the feed missed.
Don't import the same file twice. OFX files carry a unique ID per transaction, which helps Xero spot repeats; CSV files do not.
Use exact statement periods. Overlapping date ranges between files create duplicates at the boundaries.
Delete duplicates promptly. In Xero you can delete unreconciled imported statement lines from the account's statement view. Clearing them early keeps the Reconcile tab manageable.

Troubleshooting

Symptom	Likely cause	Fix
Everything imported as money received	Amounts all positive	Make money out negative, then delete and re-import
Dates in the wrong month or year	Day and month swapped, or two-digit years	Choose the correct date format; use four-digit years
Import rejected	Non-numeric amounts, blank required fields, or wrong file encoding	Remove symbols and blank rows; save as plain CSV (UTF-8)
Statement balance in Xero doesn't match the bank	Missing or duplicate lines, or opening balance mismatch	Compare line counts and totals with the statement; check the account's opening balance in Xero
Payee suggestions are poor	Payee column empty or messy	Split payee from description during conversion; create bank rules
Lines appear but cannot be reconciled to invoices	Different amounts due to fees	Use split transactions or add a bank fee line during reconciliation

Reconciling efficiently after import

Imported lines need the same treatment as feed lines. To keep it efficient:

Create bank rules for recurring payees such as rent, software subscriptions and bank fees.
Use transfers for movements between your own accounts so income and expenses are not inflated.
Match to invoices and bills where possible; it keeps receivables and payables accurate.
Reconcile in date order and check the statement balance at each month end.
Leave a note on unusual items using the transaction's reference or a history note, so reviewers understand why a line was treated the way it was.
Run the bank reconciliation report at month end and file it with the statement, which gives auditors and lenders the evidence they expect.

Bank reconciliation in Xero is still the same accounting control described in our guide to reconciling a bank statement; Xero simply provides the interface.

Xero import vs bank feed: what you gain and lose

Manual imports fill gaps, but they behave a little differently from feeds, and it helps to know the trade-offs.

What you gain: full control over the period imported, the ability to cover any history you have statements for, the option to clean payee names before they reach Xero, and verification against the statement before a single line is imported.

What you lose: automation. Imports need someone to do them each month, whereas a feed arrives daily. Imported CSV lines also lack the unique transaction IDs that feeds and OFX files carry, so duplicate protection relies on your process.

For most businesses the right setup is a feed for current activity, with imports used deliberately for history, gaps, closed accounts and banks without a feed. Record which method covers which period for each account, so the next person working on the file knows where the boundaries are.

Opening balances and conversion dates

If you are moving a business into Xero, imported statements must line up with the conversion balances.

Set the conversion date to the start of a statement period where possible.
Enter the bank balance at the conversion date as part of conversion balances, using the bank statement's closing balance from the day before, and account separately for any unreconciled items at that date if your accountant prefers.
Import statements starting from the conversion date onward.
Remove any "opening balance" row from converted CSVs before import; it would otherwise be treated as a transaction.

Multi-currency accounts

On plans with multi-currency, a bank account can be held in a foreign currency. Import statement lines in that account's currency only. If the PDF shows both a foreign currency amount and a converted amount, export the amount that actually moved through the account. Xero calculates home-currency values from its exchange rates.

Frequently asked questions

Can I import a PDF bank statement directly into Xero?

No. Xero imports CSV, OFX and QIF files, not PDFs. Convert the PDF to a Xero CSV first, check it reproduces the statement's closing balance, and then import it.

What columns does a Xero bank statement CSV need?

At minimum Date and Amount. Adding Payee, Description and Reference makes reconciliation faster and enables better bank rules. Money spent must be negative and money received positive.

Why did all my transactions import as money received?

The Amount column contained only positive numbers. Xero relies on the sign to know the direction. Delete the imported lines, make money-out amounts negative, and import again.

How do I remove a statement I imported by mistake?

Unreconciled imported statement lines can be deleted from the bank account's statement view in Xero. Lines that are already reconciled must be unreconciled first. Check Xero's help centre for the current steps.

Can I import statements for periods before my bank feed started?

Yes. Manual imports are the usual way to fill history before a feed connection. Import only the periods the feed does not cover to avoid duplicates.

Does Xero accept QBO files?

Xero is built around OFX, which QBO is based on, and many QBO and QFX files import successfully. If one is rejected, export OFX or a Xero CSV instead. Our converter offers OFX and Xero CSV output.

Summary

Xero imports statement lines from CSV, OFX and QIF files through Manage Account > Import a Statement. Make sure amounts are signed, dates are consistent and the payee is clean, import one statement period at a time, and reconcile each period to the bank's closing balance. If your statements are PDFs, convert them with balance checks so every import starts complete. QuickBooks users can follow our QuickBooks import guide.

How to Import Bank Statements into Xero, Including From PDF

Key takeaways