Importing old bank statements into Xero

What Xero's own PDF bank statement import requires

• Xero's own help center documents importing a bank statement you've exported from your bank as a PDF file, one file per account if you have more than one. Where your bank offers OFX format, Xero recommends using OFX over PDF.

  https://central.xero.com/0/article/Import-a-PDF-bank-statement

• The PDF itself must be in English, 35MB or less, at most 40 inches (2880 points) in height and width, at least 200 DPI resolution, scanned straight rather than crooked or slanted, not password protected, and no more than 100 pages.

  https://central.xero.com/0/article/Import-a-PDF-bank-statement

• PDF bank statement imports aren't available for organizations on the Xero Ledger pricing plan, and are currently only available in Xero organizations in Canada and the United States.

  https://central.xero.com/0/article/Import-a-PDF-bank-statement

• Xero excludes transactions it identifies as duplicates during import; compare the imported statement lines with the source for any overlapping period.

  https://central.xero.com/0/article/Import-a-PDF-bank-statement

Checked 2026-09-28.

Catching up years of statements at once

1. 1Choose the import route for each account. Where native PDF import is available and the files meet Xero’s requirements, you can import them directly. If you choose Arkrel to prepare CSV or OFX files, start with a readable source and review the output before importing.
2. 2Reconcile the extracted totals against the printed opening and closing balance before export, for one statement or a hundred. Any mismatch in our reading is shown. The results identify the affected transaction numbers when running-balance checks locate them.
3. 3Import the Xero CSV or OFX file through the bank account's Import a Statement flow, mapping Date and Amount plus whichever of Payee, Description, Reference and Cheque Number your file has, then reconcile in Xero as usual.

Plan a client’s historical import around the Xero reporting period

Before importing a client’s older statements, confirm what history the firm needs inside Xero. Filling a missing month in an established account and bringing earlier years into the reporting history can require different preparation.

Confirm the conversion date before adding earlier history

Review the organization’s conversion date and conversion balances before importing older activity. Xero uses that starting point for reporting. If the client needs full detail for years before it, have the person responsible for the Xero setup decide how that earlier history should be brought into the accounts.

Record the agreed first period, the opening position your firm will use, and the source reports supporting it. Keep this decision alongside the original statements. Changing the conversion date can affect the balances and records that need review, so settle the approach before treating the folder as an import queue.

Map the missing interval for each account

For each destination bank or card account, compare the statement periods received with the statement lines already in Xero. Include lines supplied by a bank feed and previous manual imports. Identify the exact interval still needed, including partial months where one source ends and another begins.

Keep an import note in your firm’s own workpapers with the account, source filename, selected period, file submitted, and date imported. Record any rows held back for review. If the client supplies another copy later, the note gives you a place to check whether that activity has already arrived.

Review Xero’s import results before continuing

For a CSV upload, review which transactions are ready to import, which need correction, and which Xero excludes as duplicates. Compare the result with the interval you intended to add. Automatic duplicate handling is useful, but an unexpected count or a missing period still needs a source check.

When investigating possible duplicates, use Xero’s statement-line reports and the original statement together. Use the Duplicate Statement Lines report to investigate potential duplicates in the account and confirm each against the original statement before changing a record. A repeated amount can also represent two separate transactions.

Close the import review and continue reconciliation

Check that the bank statement history covers the agreed period, then reconcile those lines with the accounting transactions in Xero. Record unresolved differences and the person responsible for answering them. Keep the client’s source preparation, the import result and the firm’s reconciliation status separately visible in your workpapers.

The Xero import instructions cover file formats and upload steps. Xero’s US setup guidance explains how the conversion date and opening balances establish the starting point for reports and bank balances.

Every statement checked before you download

Arkrel reads the transaction table in any bank's PDF, not a specific bank's template, the same way whether you're converting one statement or a hundred: the opening balance, plus every credit, minus every debit, must equal the closing balance, and on a statement that prints a running balance, each row must follow from the one before it. A statement that fails either check is still exported when you ask for it, but the download is marked, and the dashboard or free tool shows any reconciliation mismatch. The results identify the affected transaction numbers when running-balance checks locate them.