I need to import transactions older than the limit that exists in Quickbooks. I have a CSV of all transactions from my business bank account.
- I have manipulated it into the four column format of; date, description, credit, debit.
- I have removed all amounts that equal zero in the credit and debit columns.
- The date format is all dd/mm/yyyy.
- I have removed the symbols *,-/ from the description column
- I have deleted all blank rows under the data just in case of any hidden characters.
This CSV document absolutely refuses to be imported. I can't think of anything else that would need to be fixed.