Learn about 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 may occur 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.
- Right-click the upper left-hand corner and unhide all the hidden columns before column E.
- Select all the data again.
- Open the Home tab and use the Go To Special tool to select Visible Cells Only.
Selecting Go To Special
Selecting Visible cells only
- With only visible cells selected, press ctrl+c to copy the data.
- Press ctrl+v to paste it into a new document or worksheet (ensure you paste with formatting).
- Move the worksheet with your revised data to the leftmost tab.
Sheet 1 is furthest to the left
Save your file and create a new account grouping in MindBridge. Use the revised file when prompted to provide your Classified Grouped Trial Balance.
All 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:
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:
Your organization is not using the Classification feature within CCH.
This less common issue can take longer to resolve.
- Export the Account Grouping by opening the Actions menu and selecting Export prior to publishing the account grouping.
- Update the Level 1 name to something more applicable than Net Assets
Anything else on your mind?