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

Image of the CSV bank statement file error "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 CSV file

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.

CSV icon.  Bank statement template (CSV, 1KB)

Timeout error

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.

Download CSV file from online banking or create one using template

Receive CSV file from your client or create one using template (accountants and bookkeepers)

There was a problem importing the file

Image showing error message saying "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, center 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 Check number fields the import will fail. The limits are:

  • Reference - 255 characters
  • Check number - 20 characters