Import a CSV bank statement file into Xero
Download a CSV bank statement file from an online banking account or create one using our template, then import it into the matching bank account in Xero. Choose CSV format only if your bank doesn't offer bank statements in OFX or QIF format.
Download CSV file from online banking or create one using template
Download a CSV file from online banking containing the bank transactions you want to import into the matching bank account in Xero. If you have multiple bank accounts, download a file for each account separately.
You'll need to split up the file if it contains more than 1,000 bank transactions.
Alternatively, create your CSV file from scratch using our template.
Bank statement template (CSV, 1KB)
Prepare data in the file
Give each column a heading. Headings must be unique and in row 1.
Include necessary columns
The date column must be in the format DD/MM/YYYY or MM/DD/YYYY.
The amount column must be a single column. If your file contains 2 amount columns, combine income and expense columns into one column. Positive amounts are income. Negative amounts are expenses, and must begin with a negative sign.
The amount column must not contain currency symbols, or commas instead of decimal places.
Include recommended columns
Delete the following columns and rows, and other data
- Columns that contain no data, and sit between other columns of data
- Rows that contain no data, and sit between other rows of data
- Columns containing opening and closing balances
- Your bank account number
Save your CSV file
Save your file with .csv as the file extension. For example, you might name your file Jan13bankstatement.csv.
Import your file into Xero
- In the Accounts menu, select Bank Accounts.
- Find the bank account you want to import your file into. Click Manage Account, then click Import a Statement.
- Click Browse and select your saved CSV file.
Click Import.You may be prompted to set up CSV file import rules.
- Click Save.
Set up CSV file import rules
Assign CSV columns to Xero fields
The first time you import a CSV bank statement, you will need to assign each column heading in your file to a field in Xero. Xero applies this assignment to the entire statement, and CSV bank statements you import from now on.
Xero will prompt you to assign CSV files imported into this bank account again, if the files contain extra columns or different column headings.
The more fields you assign, the more information Xero will hold when you reconcile your bank account.
Choose the date format
If your file contains a date that could be either DD/MM/YY, MM/DD/YY or YY/MM/DD Xero prompts you to confirm the format. Xero applies the format you choose to the entire statement, and CSV bank statements you import from now on.