# Import Older Bank Statements into Xero

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2026-01-02
- Updated: 2026-01-02
- Category: Xero imports
- Canonical: https://www.simplebankconvert.com/blog/import-older-bank-statements-into-xero

> How to import older bank statements into Xero when the feed won't reach back: convert the PDFs, upload them oldest first and stop at the feed's start.
To import older bank statements into Xero, find the date of the first line your bank feed delivered, then build statement files for every earlier month you need, ending the day before that date. Convert PDF statements to CSV, upload them one month at a time, oldest first, and check each closing balance against the paper statement.

## Why the Xero bank feed stops short of older statements

A bank feed is built to keep Xero current, not to rebuild your past. When you connect an account, the bank shares a limited stretch of recent history and then sends new transactions as they post. Anything older than that window never arrives through the feed, however long you wait.

### Who sets the limit

The reach is set mostly by the bank and by the type of connection, not by a setting you can change in Xero. Two businesses connecting the same day to different banks can get very different amounts of history. Reconnecting rarely helps; the window is usually measured back from the day of the new connection.

### The usual reasons to need older months

- You started using Xero partway through the year and your accountant wants the whole year.
- You are catching up after months of not keeping books.
- You are moving from another program and want bank history in Xero as well as in the old file.
- A lender or auditor asked for reconciled accounts going back further than the feed reaches.

### The other way in

Xero's own [bank reconciliation page](https://www.xero.com/us/accounting-software/reconcile-bank-transactions/) says that if your bank does not connect, you can import your transaction data manually. The same import is how you add history a feed will not reach. Older lines brought in by file become ordinary statement lines that you reconcile the same way as fed ones.

## Finding the feed's first date before importing older statements to Xero

The feed's first date is the boundary for everything you import. Open the bank account in Xero, sort its statement lines from oldest to newest, and note the date of the very first line the feed delivered. Your older statement files must end the day before that date, or the overlapping days will be doubled.

### How to read the boundary

Look at the statement list for that account. If you have never imported anything into it, the oldest line is the feed's first. If you have imported files before, look for the oldest line that came from the feed rather than from a file. Write that date down.

### A worked timeline

These dates are an example. A business connected its checking account to Xero on 2026-03-20. The feed's oldest line is dated 2026-03-04. The accountant wants the books to start on 2025-07-01, the start of the financial year.

| Period | Source | Action |
| --- | --- | --- |
| 2025-07-01 to 2026-02-28 | Monthly PDF statements | Convert and import, one file per month |
| 2026-03-01 to 2026-03-03 | The March statement, first three days only | Import as a short file |
| 2026-03-04 onward | Bank feed | Leave alone |

The March file is the one people get wrong. The bank's March statement covers the whole month, but only the first three days are missing from Xero.

### Several accounts, several boundaries

Each bank account and card has its own feed and its own first date, even at the same bank. A checking account connected in March and a card connected in May have two different boundaries. Make a short list with one row per account, its feed's first date, and the earliest month you need. Work through one account completely before starting the next, so files never end up in the wrong place.

### When the feed's first date is mid-statement

Trim the file, never the feed. Convert the whole statement, then delete every row dated on or after the boundary before you upload. Deleting lines in Xero afterward is slower and more likely to remove the wrong copy.

## Converting older PDF bank statements for Xero

Older months usually exist only as PDF statements, which Xero imports directly only in US and Canadian organisations, so each one usually becomes a CSV or OFX file first. A CSV is the easier choice for history work, because you can open it, check the totals and trim boundary rows in any spreadsheet.

### What each file should contain

One row per transaction with the posting date, one signed amount, the payee and any reference. No opening balance row, no closing balance row, no page totals. The general layout is covered in [importing a PDF bank statement into Xero](/blog/import-pdf-bank-statement-into-xero), which shows a converted statement row by row.

### Statements that are already spreadsheets

Some banks offer older history as an Excel download rather than as PDFs. Those still need tidying and saving as CSV; [importing an Excel bank statement into Xero](/blog/import-excel-bank-statement-into-xero) covers the date and amount fixes that sheet usually needs.

### A tool for the PDF step

Converting a year of PDFs by hand is the slowest part of this job. SimpleBankConvert is being built to turn each PDF statement into a CSV with Xero's columns, dates in one format and withdrawals shown as minus amounts; you can ask for access on the [get started page](/get-started).

## Uploading older statements to Xero, oldest month first

Upload one month per file, starting with the oldest and working forward to the feed boundary. Going in order lets you check each month's closing balance as you go, so a problem in August is found in August and not discovered in February. Use the account's Import a statement option for every file.

### The steps

1. Put the converted files in date order and name each one by account and month, such as "checking-4417-2025-07.csv".
2. Open the matching bank account in Xero and open its menu, then choose Import a Statement.
3. Upload the oldest file. Match the columns if Xero asks.
4. On the review screen, confirm the first and last dates and the line count.
5. Save, then check the running total of imported lines against that month's statement.
6. Repeat for the next month, ending with the short boundary file.

### The check for each month

For each month, the opening balance plus the sum of imported lines should equal the statement's closing balance. In the example, if July opens at 4,200.00, its imported lines total -615.40, and the July statement closes at 3,584.60, the month is complete. These are example figures. If they do not agree, fix that file before moving on.

### Size and line limits

Large files can be refused, and a year in one file is harder to check anyway. Monthly files avoid both problems. [The Xero bank statement import limit](/blog/xero-bank-statement-import-limit) covers how big a single upload can be.

## Does the Xero opening balance need changing for older statements?

Usually yes. If your Xero books were set up to start on the feed's first date, the opening balance for the bank account was set as of that date. Importing older months moves the real starting point back, so the conversion date and balances need to move back too, or the account will be out by a fixed amount.

### What goes wrong if you skip it

The older lines arrive and you reconcile them, but the balance in Xero now counts them on top of an opening figure that already included their effect. Every month after shows the same difference, equal to the total of the older lines.

### What to change

Xero holds your starting figures as conversion balances, set as of a conversion date in your settings. When you extend history backward, the conversion date should become the day before your oldest imported line, and the bank account's conversion balance should be the opening balance on that oldest statement. This touches your whole balance sheet, so agree it with your accountant before you change it.

### A check that confirms it worked

After changing the conversion balances, the balance in Xero on the day before the feed's first line should equal the bank's closing balance on that day. In the example, that is the bank balance at the end of 2026-03-03.

## Should statements from before your Xero start go in at all?

Not always. Import older statements when someone needs reconciled transactions for those months: a tax return, a financial year, a lender. Leave them out when the months are already closed and reported in another system, or when all you need is a record you can look up.

### Cases where older history is not worth importing

- **The year is filed and closed elsewhere.** The previous program holds the reconciled detail. Re-entering it in Xero can disturb figures your accountant has already reported.
- **You only need to find old payments.** The PDF statements themselves are a searchable record. Keep them filed by account and month.
- **The account is closed.** A closed account with no activity after your Xero start may not need a Xero account at all.

### Keeping personal or side records somewhere else

Not every old statement belongs in your business books. A household account, or a project you track only for yourself, may suit a personal finance program better. [Importing a bank statement into Moneydance](/blog/import-bank-statement-into-moneydance) shows one option for that kind of record.

### Deciding

Ask one question: will anyone reconcile or report on these months in Xero? If the answer is no, store the statements and stop. If it is yes, import them oldest first and move the conversion date to match.