MindBridge requires that trial balance files have one unique account per row. Sometimes you will receive trial balances with duplicate account numbers, usually because several subsidiaries were manually combined into one.
Here is how to consolidate the duplicate account numbers:
- First copy and paste the account column (header and all entries) into its own column in another Excel workbook.
- In the new workbook, with the column still selected, go to Data -> Remove Duplicates
- Since the "Account" header has been copied, leave "My list has headers" checked
- Use an INDEX()/MATCH() formula to pull the first account description in the original TB for each account number:
Where the account number is in A2, sheetname is the name of the worksheet/workbook of the original TB with account number in column A and account description in column B.
Use a SUMIF() formula to sum up the amount for each unique account:
=SUMIF('sheetname'!$A:$A,$A2,'sheetname'!$C:$C)Where the account number is in A2, sheetname is the name of the worksheet/workbook of the original TB with account number in column A and amount in column C.
Finally, copy and paste values so that your new workbook, which you will be importing into MindBridge, does not have formulas.