What should I fix so that a CVS file with exported transactions will import successfully? I have removed strange formatting and there are no blank lines.
Let's perform some troubleshooting steps to import your bank transactions through .CSV file, parentguide.
I appreciate you for removing strange formatting to successfully import the transactions. Aside from that one, let's make sure your CSV file is formatted correctly. Just check out the following criteria below:
We need to remove zeros from the file.
Correct any transactions that display a number in the Description column.
Remove the word amount if it appears in the name of the Credit or Debit column.
If you're using Mac, please save the file as a Windows CSV file.
The Date format must be in a single format (for example, dd/mm/yyyy).