What are Duplicate Accounts in CSV files and how to fix them?

When data is loaded into RealTime CEO each month, the software checks for duplicate accounts in the CSV files – that is, the same account name more than once in a file.  RTC uses a tagging mechanism on the account description to identify the account and the file will not be imported if there are duplicates.

On importing CSV files into RTC, the system will report if duplicates are found and displays the rows within the CSV files the duplicates are found on.  There are 2 ways to fix this:

1. Manually fix the duplications in the CSV file by editing the account name but you will need to do this every future month.
2. Edit the duplicate account names in your General Ledger so you don’t need to manually edit every future CSV file.

After the CSV is fixed, you will need to reselect the file for uploading.

Note that an account description without a value (e.g. a heading) and the same account description with a value, is not considered a duplicate.