Xero bank feed doesn't go back far enough: importing older transactions

A Xero bank feed brings in new transactions from the day it connects, plus whatever history the bank makes available at setup. If the books need to start earlier, for a catch-up, a year-end request or a new client, the older months have to come in as statement files. This guide covers how to do that without breaking the opening balance or doubling up lines.

How much history a feed brings in

• Xero's own answer is that it depends on the bank. Its US page says that when you set up a feed you may be given the option to pull historical data, and if not, you can upload the data from a PDF instead (Xero US, connect your bank).
• Xero's New Zealand page puts the range at the past 90 days up to 2 years, depending on the bank (Xero NZ). Treat any number as bank-specific and check what your connection actually brought in.
• Some banks have no feed. In Accounting → Bank accounts → Add bank account, a Manual upload label next to the bank means a feed isn't available, and you import statements instead (Xero Central, About bank feeds).

1. Find where the feed starts

1. In Accounting → Bank accounts, open the account's menu and choose Bank Statements, then show Statement lines.
2. Sort or scroll to the oldest line and note its date. That is the first day the feed covers.
3. Everything before that date has to come from your own statement files. Your last imported file should end on the day before the first feed line.

2. Set the starting point: conversion date and opening balance

• In Xero, the conversion date is the date you start recording transactions in Xero, and it is always the first of a month. Conversion balances are the opening balances, taken as at the day before the conversion date (Xero Central, Convert to Xero).
• For bank and credit card accounts, Xero says to enter the balance from your bank statements as at the conversion date. Enter all balances as positive numbers: a bank account in credit goes in the Debit column, and an overdraft, loan or credit card balance goes in the Credit column (Xero Central, Tips for entering conversion balances).
• Conversion balances live under Accounting → Accounting settings → Conversion balances. Each time you click Save, Xero reverses the previous conversion journal and posts a new one (Xero Central, Enter conversion balances).

In practice: the first statement you import should start on the conversion date, and the bank account's conversion balance should equal that statement's opening balance (the previous statement's closing balance). If the months you need fall before the current conversion date, the conversion date and balances would have to move earlier too. That changes the starting point of every report, so agree it with whoever looks after the file before you change it.

Xero also recommends that you don't reconcile bank accounts until all unpaid invoices and bills from before the conversion date are entered, to avoid duplicate transactions.

3. Get the older months as files

• Bank download: for months still inside your bank's download window, Xero recommends OFX, QFX or QuickBooks files where the bank offers them, or CSV otherwise (Xero Central, Import a bank statement in CSV format). Download one file per account.
• PDF statements in Xero: in Xero organizations in the US and Canada, you can import a PDF statement directly (not on the Xero Ledger plan). Xero's limits include English-language statements, 35 MB, 100 pages, at least 200 DPI and no password. Xero lists banks where extraction has been validated and says accuracy may vary for others. It still recommends OFX over PDF where the bank offers it (Xero Central, Import a PDF bank statement).
• PDF to CSV: elsewhere, or when you want to check every month before it goes in, convert the PDFs to CSV. Steps: statement into Xero and statement PDF to CSV.

4. Shape the CSV the way Xero expects

• Only Date and Amount are required, but payee, description and reference make reconciling easier. Put a header row in row 1 with unique column names, or start from the template linked on Xero's Import a Statement screen.
• One Amount column: money in positive, money out negative (a minus sign or brackets). No commas as decimal points. For credit cards, payments are positive and purchases negative.
• Delete opening and closing balance columns (Xero works out the balance from the transactions), the account number and empty rows. A CSV can't have more than 100,000 rows.
• Use one date format. When Xero asks you to confirm it, the choice applies to the whole statement and to future CSV imports.
• Trim the last file so it ends the day before the first feed line.

Source for this section: Xero Central, Import a bank statement in CSV format.

5. Tie out each month before you import

1. For each statement: opening balance + all amounts = closing balance.
2. Chain the months: each closing balance must equal the next statement's opening balance.
3. The first month's opening balance should match the conversion balance from step 2.

A month that doesn't tie has a missing, doubled or mis-signed line. It is much easier to find in the file than after it is reconciled in Xero. See check a statement is complete before you import it.

6. Import, oldest month first

1. In Accounting → Bank accounts, open the account's menu and choose Import a Statement.
2. Upload the file, assign the columns (CSV) and confirm the date format if asked.
3. On the review screen, clear the checkbox next to any line you don't want, then click Complete import.

Xero says lines matching transactions already in Xero are treated as duplicates and not imported. That is a safety net, not a plan: keep your file dates clear of the feed's dates anyway.

7. Avoid and clean up overlap duplicates

• Duplicate statement lines can arrive through a bank feed or a manual import. Run Reporting → All reports → Duplicate Statement Lines for the account and date range. It compares dates and amounts, then looks for an exact match on reference, particulars or payee. It does not show partial matches, or the duplicates Xero already removed at import (those are on the Statement Exceptions report in the Bank Reconciliation report pack) (Xero Central, Duplicate Statement Lines report).
• To delete a duplicate: Bank accounts → the account's menu → Bank Statements → show Statement lines, tick the line and click Delete. Deleting changes the statement balance in Xero, so only delete true duplicates.
• Don't mark a transaction as reconciled by hand and then import its real line. Marking as reconciled creates its own statement line, so you end up with two. If it has happened, delete the manual one (Xero Central, Compare the statement balance).

8. Check the statement balance

When the files are in, compare Xero's statement balance with the bank's balance for the same date. If they differ, Xero says either the opening balance is wrong or there is an error in the statement lines:

1. Check the bank account's opening balance equals the bank's closing balance for the day before you started using Xero, and that the conversion balances are saved.
2. Run the Bank Reconciliation Detail report month by month from the last date the balances matched, to find the month where they part.
3. In that month, look for a missing line (import it), a duplicate (delete it), a line deleted by mistake (restore it) or a manual line from marking as reconciled (delete it).

Import errors (rejected files, wrong dates, flipped signs): see Xero bank statement import errors. Same problem in QuickBooks: fill the gap before your QuickBooks bank feed.

Xero details are from the Xero Central articles and xero.com pages linked above, as read on 24 Oct 2026. Menus and limits change, so check Xero's current help if a screen looks different.

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.