Troubleshoot a CSV bank statement file import error
Learn how to fix an error you receive when uploading a CSV bank statement file to Xero.
The file you uploaded does not contain valid statement data
Reasons error occurs
The error message, 'The file you uploaded does not contain valid statement data', occurs for one of the following reasons:
- The data in the CSV file isn't prepared correctly.
- The CSV file is corrupt.
Ways to fix the error and import your file into Xero successfully
First, prepare the data in your CSV bank statement file again. You will need to save the file, then import it into Xero again.
Prepare data in the precoded CSV file (accountants and bookkeepers)
If you receive the same error when you import your file into Xero for the second time, your file may be corrupt.
Fixing a corrupt file involves creating a new file. To create a new file, download our bank statement template, then copy and paste the data you have already prepared into the template. Save the file, then import it into Xero again.
Bank statement template (CSV, 1KB)
A timeout error usually means your file contains too many bank transactions.
You'll need to split up the file if it contains more than 1,000 bank transactions.
Receive CSV file from your client or create one using template (accountants and bookkeepers)
There was a problem importing the file
Check for these common reasons that can cause this error.
A column in the CSV file has data in the wrong format
Make sure that columns contain data in the right format for that column. For example, the date column must only contain data in a date format and the amount column must only contain numbers.
Data in a column does not have the same alignment
Make sure that all data in a column has the same alignment, for example, all left-aligned. The type of alignment does not matter, that is, it can be aligned to the left, centre or right. But all data in the column must have the same alignment.
Maximum character limit for field (column) has been exceeded
If there are too many characters in either the Reference or Cheque number fields the import will fail. The limits are:
- Reference - 255 characters
- Cheque number - 20 characters