How to Import a Bank Statement into Xero

Working out how to import a bank statement into Xero comes up whenever a direct bank feed is missing, broken, or covers the wrong dates. Xero is excellent at pulling transactions automatically, but feeds do not cover every bank, they sometimes skip a period, and they cannot help with a closed account or a historical statement. In those cases you import a statement file by hand. This guide covers the formats Xero accepts, the manual import steps, and how to convert a PDF first when that is all your bank gave you.

When you need a manual import

A manual statement import is the right move when:

• Your bank is not supported by a Xero direct feed.
• A feed dropped transactions or has a gap you need to backfill.
• You are bringing in history from before the feed was connected.
• You are reconciling a closed or old account from a saved statement.

What Xero can import

Xero reads a handful of structured formats, not PDFs:

OFX is often the smoothest because the structure removes the date-format guesswork. CSV is the most flexible when your data needs tidying first.

Step one: convert your PDF statement

Most statements arrive as a PDF, and Xero cannot read that. Convert it first. BankConvert detects the layout from any major bank and exports a clean file you can import straight into Xero. You can convert a PDF bank statement to CSV for full column control, or generate a standards-based OFX file from your PDF statement for a smoother import. Either way you get date, description, amount, and balance extracted accurately, with a review step before you download.

Importing a CSV into Xero

Once you have a CSV, the Xero import runs like this:

• Open the bank account in Xero, then choose Manage Account, then Import a Statement.
• Upload your CSV file.
• Map the columns: tell Xero which column is the date, which is the amount, and which is the description or payee.
• Confirm the date format. This is the step that catches most people, so match it to your file.
• Complete the import and review the new statement lines on the Reconcile tab.

Xero needs a clear amount column. Some banks split debits and credits into two columns, so a clean converter that normalizes this into a single signed amount, or into the columns Xero expects, saves a round of cleanup.

Importing an OFX file into Xero

OFX is simpler because there is no column mapping:

• Open the bank account, choose Manage Account, then Import a Statement.
• Upload the OFX file.
• Xero reads the dates, amounts, and descriptions from the file structure.
• Review the imported lines on the Reconcile tab.

Because OFX carries its own date and amount structure, it sidesteps the format-mismatch errors that CSV imports sometimes produce. If you have a choice and your file is clean, OFX is usually the lower-friction path.

Avoiding duplicates

The most common manual-import headache is double-counting transactions that the feed already brought in. To stay clean:

• Import only the date range the feed missed, not overlapping periods.
• Check the opening and closing balance after import against the statement.
• If you do import a duplicate, Xero usually flags it on reconciliation so you can remove it.

Bank-by-bank consistency

Layouts vary between institutions, which is exactly why a converter that adapts per bank is useful. Whether you start from a Bank of America statement or a Chase statement, the convert-then-import workflow is identical.

Security and scope

Because a statement is sensitive, it matters how a tool handles it. BankConvert encrypts files, processes them only to convert, then discards them, and never stores or sells your data, as detailed on the security page. And to be clear, BankConvert converts files rather than offering accounting or tax advice, so review the imported data and your account mappings before you reconcile.

Bottom line

When a Xero feed cannot do the job, a manual import fills the gap. Convert your PDF into a clean CSV or OFX, import it into the right account, mind the date format on CSV, and import only the periods you actually need. With the data already structured, the Xero side takes a couple of minutes and reconciliation stays clean.