How to Import a PDF Bank Statement into Xero (Convert to CSV First)

Xero is built around bank feeds, but there are plenty of times a feed does not help: a new client brings a year of old statements, a bank account was never connected, a feed broke for a few months, or a bank only gives you PDFs. Xero cannot read a PDF statement. You need to turn it into a file Xero accepts, check it, and import it. Here is how to do that cleanly.

What Xero accepts

Xero's help centre lists statement imports in formats such as CSV, OFX, QIF and QBO. For a converted PDF, CSV is usually the best choice because you can open it in Excel or Google Sheets, check every row against the original, and fix anything before it reaches the ledger.

For a CSV import, Xero's guidance says two columns are required:

• Date, in a supported format such as DD/MM/YYYY or MM/DD/YYYY.
• Amount, as a single column, with money in as positive numbers and money out as negative numbers.

Optional columns such as Payee, Description and Reference make bank rules and reconciliation much easier, so keep them when you can.

Step 1: Convert the PDF statement

Use the ConverterFreaks bank statement converter. Choose your bank or leave it on auto-detect, drop in the PDF, and download the result as CSV or Excel (.XLSX). The converter produces columns for the date, transaction description, category, amount, running balance and reference. Multi-page statements come out as one continuous list.

New users can test it on a limited number of free pages first, which is a good way to check how your bank's layout converts before you process a whole year.

Step 2: Check the converted file against the PDF

Never import a converted statement without checking it. Open the file and compare it to the PDF:

1. Count the transactions on one page of the PDF and match them to the rows.
2. Check the opening and closing balances. Opening balance plus the sum of all amounts should equal the closing balance shown on the statement.
3. Spot-check a few descriptions and amounts, especially long card descriptions that wrap across two lines in the PDF.
4. Look for page breaks: make sure no transaction was dropped or repeated where one page ends and the next begins.

If the balance check works, you can be confident the amounts are right.

Step 3: Prepare the CSV for Xero

• Signs: make sure money out is negative and money in is positive. If your file has separate debit and credit columns, combine them into one Amount column (credit minus debit).
• Dates: use one consistent format for every row, and make sure Excel has not swapped day and month. Format the column as text in DD/MM/YYYY or MM/DD/YYYY before saving.
• Balance column: Xero does not need the running balance. You can delete it or leave it unassigned when you map columns.
• Remove non-transaction rows such as "Balance brought forward", page totals or blank lines.
• Save as CSV (comma-separated), not XLSX.

Step 4: Import into Xero

1. In Xero, go to the bank account you want to import into.
2. Choose the option to import a statement and select your CSV file.
3. Map the columns: assign Date and Amount, then Payee, Description and Reference if you have them. Leave anything else unassigned.
4. Check the preview, then complete the import. The transactions appear as statement lines ready to reconcile.

Menu names change from time to time, so if you cannot find the option, search Xero Central for "import a CSV bank statement".

Step 5: Avoid duplicates

Duplicates are the most common problem with manual imports. Before you import:

• Check which dates are already in the bank account from a bank feed or an earlier import.
• Trim the CSV so it covers only the missing date range.
• If you import a whole statement period, note the first and last dates so you do not import them again next time.

Step 6: Reconcile

Once imported, reconcile each line against invoices, bills and transactions in Xero as you normally would. Good descriptions help Xero suggest matches and make bank rules work. For a spreadsheet-based check outside Xero, see our guide to doing a bank reconciliation in Excel.

CSV or QBO?

The converter can also produce a QBO (QuickBooks Web Connect) file, and Xero lists QBO among the formats it accepts. QBO is quicker because there are no columns to map. CSV takes a few more minutes but lets you inspect and edit every line first, which is safer for old or messy statements. If you also work in QuickBooks, see how to convert a PDF statement to QBO.

Privacy

Bank statements contain account numbers and personal spending. ConverterFreaks processes statements in memory rather than keeping them in a permanent database. Whatever tool you use, delete downloaded CSVs you no longer need and store client files in your normal secure system.

Frequently Asked Questions