- In the Accounting menu, select Bank accounts.
- For the bank account you want to import the file into, click Manage Account, then click Import a Statement.
- Click Browse, select the saved CSV file, then click Open.
- Click Import.
- If prompted, assign the columns in your import file to the matching bank statement fields.
- Click Save.
Assign columns to statement fields
The first time you import a CSV bank file, you need to assign each column in the import file to a bank statement field. This assignment applies to future CSV imports, unless the new file contains extra columns or different column headers.
Match all the fields you want to import data into. The more fields you assign, the more information is imported into Xero for each bank statement line.
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 chosen format to the entire statement and all future CSV bank statements.
Create the CSV file
Download from online banking
Download the transactions from your bank account in a CSV file format. If you have multiple bank accounts, download a file for each account separately.
Split the file if it contains more than 1,000 bank transactions.
You may need to edit the data in the file before it can be imported into Xero.
Save each bank statement file to your computer in the .csv format.
Create your own import file
If you can't download a bank statement in a CSV format, create your own import file.
Download the bank statement import template file.
Enter your bank statement data into the file.
Save the bank statement file to your computer in the .csv format.
Prepare the data in the file
A CSV bank statement file can import without headings, but it's easier to map the columns to the statement fields in Xero if the columns have names. The bank statement import template has column headings that match the bank statement fields in Xero.
If the CSV file from your bank doesn't have a header row, insert one. The header row must be in row 1 and each column name should be unique.
Delete data not required
Delete the following data to ensure the import is successful:
- Empty rows
- Columns containing opening and closing balances, as Xero calculates the bank balance from the transactions
- The bank account number if it shows in the import file
Enter data into the fields
Mandatory fields are marked with an asterix in the import file. You only need the Date and Amount fields to create bank statement lines, but reconciling your transactions is easier if you include more detail.
- Date – Use the format DD/MM/YYYY or MM/DD/YYYY.
- Amount – Both income and expense amounts must be in the same column. Show income as positive amounts and expenses as negative amounts with a negative sign in front of the amount, for example -30.00. Don't include currency symbols or use commas to show decimal places.
- Payee – (Recommended) If the payee is an existing contact in Xero, make sure the name in your file matches exactly with the contact name in Xero to avoid creating duplicates.
- Description – Enter detail you want to include as a description on your transaction.
- Reference – Enter detail you want to include as a reference on your transaction.
- Cheque number – Enter the cheque number if applicable.