Symptom

One of the following errors appears when importing a trial balance file.

Scenario 1: Single duplicate value

MindBridge detected the value {value} in column {columnName} has been duplicated. Remove the duplication and re-import the file. If the issue persists, grant MindBridge access to your engagement so Customer Support can dig into the issue.

Scenario 2: Multiple duplicate values

The imported file contains the following duplicate values.

• {value} in column {columnName}
• {value} in column {columnName}

Remove the duplications and re-import the file. If the issue persists, grant MindBridge access to your engagement so Customer Support can dig into the issue.

What does the error mean?

The error occurs of an uploaded Opening Balance or Closing Balance file contains a duplicate value(s) within the mapped Account column.

Resolution

Identify and remove all duplicate value(s) within the specified column.

• Refer to the following guide to learn how to remove all duplicates: Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts

Some common causes include the following:

• Dataset contains balances from multiple fiscal years.
  • Remove those rows that do not pertain to the analysis period to which this balance file applies.
• Account number needs to be qualified with something like a company code or a sub-account number in order to make it unique.
  • You can use the Join function in column mapping to do this. Please see How do I adjust my column data? for more details.
    Note: You will need to do this across all files so the Account numbers in the Opening Balance and Closing Balance files match those found in the General Ledger and account mappings.
    
    

Anything else on your mind? Chat with us or submit a request for further assistance.