Error: "The CSV file must contain an amount, date and description column"
If you have more than 4 columns, try removing any columns that are not your date, description or amounts.
Error: "Wave is having difficulty reading the file you uploaded"
Your CSV file name is too long. Rename your file as 'month-year-account.csv' or just 'monthyear.csv.'
Error: "Wave can't find any transactions in your file"
Try downloading the statement again from your bank, ensuring that the date range and any other criteria are such that the report will contain at least 1 transaction.
Error: "Wave is having difficulty reading the dates of your transactions"
The date must be presented in one of these formats: YYYY/MM/DD, YYYY/DD/MM, DD/MM/YYYY. Remove any future dates in your date column.
Error: "Wave is having difficulty reading the amounts of your transactions"
Verify that all of your amounts are numerical values and not words.
Error: "Wave can't find a description for your transactions"
Your statement must have a column for the description. There does not have to be a description and there are no limitations on the content of the description.
Error: "The file you provided doesn't match any format we support"
The file you provided to upload does not match up with any formats that we support (.ofx, .qbo, .qfx, .aso, .csv). A common error is saving an excel sheet as .xls instead of .csv.
Error: "File contains transactions in multiple currencies" OR "File contains an unknown currency code"
If you have USD and CAD transactions in one file, split the currencies into two separate files, and upload them into separate payment accounts. For unknown currency, remove any currency symbol from your file, and choose the correct currency payment account when you upload it.
Still won't work?
One other possibility is that you have an account balance above or below your transaction amounts. Remove the row that shows the balance, and attempt the upload again.
For screen shots and step-by-step guides, please click View original article below.
- Uploading a bank or credit card statement in .csv format
- Two ways to import your transactions into Wave