Xero bank statementsready to import.
Collect statement lines with dates, signed amounts, payees and references, checked on every row, and download a clean CSV for Xero's statement import.
Xero Bank Statement
Try the template with up to 3 statement lines
What You'll Collect
Date
DateDay first (DD/MM/YYYY), one format throughout. Impossible dates are flagged.
Amount
NumberMoney out negative, money in positive. Currency symbols are flagged; thousands separators are removed for you.
Payee
StringWho the money went to or came from, which helps Xero suggest matches.
Description
StringWhat the transaction was.
Reference
StringAn invoice number or payment reference, kept as text so leading zeros stay.
Need more than three statement lines?
Collect up to a thousand statement lines instead.
The free template is limited to three rows so you can try the workflow. Create your own form when a client needs to send a whole statement, for an account without a bank feed or a period before the feed started.
Create your own formUp to 1,000 rows
A month or more of statement lines in one file.
Clean columns
Date, amount, payee, description and reference, ready to match to Xero's fields.
Checked as they type
Bad dates, symbols in amounts and missing descriptions are fixed before you get the file.
Your own columns
Need a cheque number or analysis code? Add them to your own form.
How it works
From statement to Xero import in three steps.
01
Collect
Send the form to the client, or paste the statement lines in yourself.
02
Complete
Problems are highlighted on each row until every date and amount is right.
03
Download
Download the CSV, import it into the bank account in Xero, and match each column to a statement field.
Why use a form?
Bank exports aren't built for Xero.
Bank CSVs come with balance rows, mixed date formats, amounts with currency symbols and debits in separate columns. Each one can stop a Xero import or bring in wrong amounts.
A form produces the same clean layout every time, whoever fills it in.
Wrong date formats
Every date uses the same day-first format, ready for Xero.
Signs the wrong way round
Money out must be negative; the column explains it.
Junk rows and symbols
Only real statement lines with plain numbers make it into the file.
Xero bank statement template
Importing a bank statement into Xero
Xero can import bank statement lines from a CSV file when an account has no bank feed, or for transactions from before the feed started. In the import, you match each column in your file to a statement field. Column headings are optional, but named columns make that matching easier.
A clean file needs a date and an amount on every line, with money out as a negative number and no currency symbols. Use one date format throughout, in the order your Xero organisation uses. This template uses day-first dates, as organisations in the UK, Australia and New Zealand do. A payee, description and reference help Xero suggest matches when you reconcile.
Very large files can time out during the import. If that happens, split the statement into smaller files and import them one at a time.
Use this form to collect statement lines from a client, or paste them in yourself and let the checks catch problems first. If your organisation uses month-first dates, or you need extra columns such as a cheque number, create your own form with that setup.
How-To Guides
Related Templates
Collecting contacts too? See the Xero Contacts template. More for accountants: Import Builder for accountants.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started