In this article we will cover a couple of the most common issues found when importing a Classified Grouped Trial Balance into MindBridge as part of the CCH account grouping creation process.
There are more accounts than expected after import
This happens with some CCH exports because you are using a template that has more account groupings than you use when mapping your client's accounts. There is a quick formatting solution if this happens.
Open the Classified Grouped Trial Balance in Microsoft Excel and select all the data. Then right-click the upper left-hand corner and unhide all the hidden columns before column E.
Select all the data again and then on the Home tab in the ribbon, use the Go To Special tool to select the Visible Cells Only option as shown below:
Selecting Go To Special
Selecting Visible cells only
With only Visible cells selected, Copy all the data and Paste it into a new document or worksheet (ensure you paste with formatting). Ensure that the worksheet containing your revised data is the furthest one to the left (as shown below):
Sheet 1 is furthest to the left
Save your file and create new account grouping in MindBridge. Use the revised file when prompted to provide your Classified Grouped Trial Balance.
All of the account codes begin with Net Profit or Net Assets
Sometimes after importing your CCH trial balance you may notice that all of the account codes start with Net Profit or Net Assets. This can be for one of two possible reasons:
1. The Sum of Account Groupings box was not checked off when exporting the Classified Grouped Trial Balance out of CCH.
This is the most common reason for this issue. To resolve this issue, simply go back to CCH and re-export the proper file. You need to make sure the following box is checked off:
2. Your organization is not using the Classification feature within CCH.
This less common issue can take longer to resolve.
Export the Account Grouping by clicking Actions and clicking Export prior to publishing the CAG.
Update the Level 1 name to something more applicable than Net Assets as shown in the images below