How to import a bank statement into Xero from a PDF (CSV layout and checks)

 Xero's Import a Statement screen takes CSV files, not PDFs, so a PDF bank statement has to become a CSV first. In practice each line needs a date, a signed amount and a payee to be useful in Xero. A description and a reference help you reconcile, and anything else, including a balance column, should stay out of the file. Then you import into the matching bank account and check that Xero's balance lands on the statement's printed closing figure.

Here is the whole job for one fictional statement.

The statement

Ferncliff Studio is a made-up two-person design studio. Its April 2026 checking statement, account ending 7731, opens at $5,240.00 and closes at $7,176.52 with six lines on it.

Step 1: Convert the PDF to a CSV with one signed amount column

Banks print money in and money out in separate columns. Xero wants one Amount column, positive for money in and negative for money out. Here is Ferncliff's April as a Xero-friendly CSV, five columns wide:

Date	Amount	Payee	Description	Reference
04/01/2026	-1450.00	Lakeshore Holdings	ACH DEBIT LAKESHORE HOLDINGS RENT
04/06/2026	2800.00	Mabry and Cole	ACH CREDIT MABRY AND COLE
04/09/2026	-312.48	Pixelworks Software	CARD PURCHASE PIXELWORKS SOFTWARE
04/15/2026	-1036.00	Check	CHECK 1187	1187
04/22/2026	1950.00	Otterbrook Gardens	ACH CREDIT OTTERBROOK GARDENS
04/30/2026	-15.00	Monthly Service Fee	MONTHLY SERVICE FEE

A few details in that file matter. Amounts are plain numbers with two decimals, no dollar sign and no comma for thousands. The check number sits in Reference, so you can match the check when you reconcile. There's no Balance column, because Xero's own guidance is to remove balances, account numbers and empty rows; it works the balance out from the lines.

Step 2: Prove the file before it goes anywhere

Add up the Amount column:

-1,450.00 + 2,800.00 - 312.48 - 1,036.00 + 1,950.00 - 15.00 = 1,936.52

Opening balance plus that net change: 5,240.00 + 1,936.52 = 7,176.52. That's the printed closing balance, so the file is complete and the signs are right. If it hadn't tied, you'd want to know now, not after the lines are sitting in Xero waiting to be reconciled.

Step 3: Import a Statement in Xero

In Xero, go to the Accounting menu, then Bank accounts. Find the account this statement belongs to, open its menu and choose Import a Statement. Pick the CSV.

Xero imports into one bank account at a time. If your PDF holds checking and savings together, make two files.

Step 4: Assign the columns, and check the date format

The first time, Xero asks which statement field each column fills. Match Date, Amount, Payee, Description and Reference to the fields of the same name. Xero keeps the assignment for later imports with the same headings.

The date format is the setting that does the most quiet damage. The file above is month first. If your Xero organisation is set up for the UK, Australia or New Zealand and reads day first, 04/09/2026 becomes 4 September. Lines dated the 13th or later won't fit at all, which is at least a visible clue. Confirm month first before you import.

Step 5: Review, import, then check the numbers

Check	Ferncliff's April	What a miss means
Lines imported	6	Fewer means some were left out at review; more means a doubled line
Xero balance at April 30	7,176.52	Must equal the printed closing balance
Size of any gap	0.00	Equal to one line: missing or doubled. Twice a line: wrong sign. Equal to 5,240.00: the account started at zero

That last case catches people setting up a new Xero account. If the account's starting balance wasn't set to the first statement's opening balance, every month will be off by the same 5,240.00, however carefully the lines went in.

What about a year of statements?

Import them in date order, one account at a time, and make sure each statement starts the day after the previous one ended. A statement plus a custom date-range download for the same days will put those lines into Xero twice. Xero has a Find and remove duplicate bank statement lines tool, but it's easier not to need it.

Our full guide to importing a bank statement into Xero has the column rules side by side, what breaks an import and how to fix each cause.

Disclosure: I'm Damin and I run ZeraBooks, so weigh this part accordingly. ZeraBooks Convert reads PDF bank statements and downloads a Xero-ready CSV in the five-column layout above, with MM/DD/YYYY dates, a minus sign on money out and the payee cleaned from the description. It proves each account against the printed opening and closing balances before you download, which is step 2 done for you. There's no Xero connection; you import the file yourself. Convert is part of the ZeraBooks subscription at $79 a month billed annually or $149 monthly for 1,000 pages a month, after a 7-day trial. The rest of what it reads is on the bank statement converter page.

Whatever tool makes your CSV, do step 2 by hand at least once. It takes a minute and it's the only step that tells you the file is complete.