If you've experienced any issues importing the CSV file, make sure your file doesn't break any of the following formatting restrictions:
Special characters are not allowed. Do not use ( ) for negative amounts (use -234, not (234) for negative figures). Do not include currency symbols ($234 should be 234). Do not use commas to separate thousands (2, 111 should be 2111). Do not use characters such as #, %, and & anywhere in the file.
Zeros (0) are not allowed anywhere in the file ($0 should be left blank)
Correct any transactions that display an amount in the Description column
Remove the word amount if it appears in the name of the Credit or Debit column (Credit amount and Debit amount are incorrect)
Correct and standardize the Date format to a single format (for example, dd/mm/yyyy)
MAC users must save the file as a Windows CSV file