Questions? We have answers.

Troubleshooting issues with a CCH account grouping import

  • Updated

Summary

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. 

  1. Open the Classified Grouped Trial Balance in Microsoft Excel and select all the data.
  2. Right-click the upper left-hand corner and unhide all the hidden columns before column E.
  3. Select all the data again.
  4. Open the Home tab and use the Go To Special tool to select Visible Cells Only.
    Screen Shot 2020-07-24 at 11.02.55 AM.png
    Selecting Go To Special
    Screen Shot 2020-07-24 at 11.03.02 AM.png
    Selecting Visible cells only
  5. With only visible cells selected, press ctrl+c to copy the data.
  6. Press ctrl+v to paste it into a new document or worksheet (ensure you paste with formatting).
  7. Move the worksheet with your revised data to the leftmost tab.
    Screen Shot 2020-07-24 at 11.03.17 AM.png
    Sheet 1 is furthest to the left
  8. 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:

Screen Shot 2020-07-24 at 10.38.49 AM.png

 

Your organization is not using the Classification feature within CCH.

This less common issue can take longer to resolve. 

  1. Export the Account Grouping by opening the Actions menu and selecting Export prior to publishing the account grouping.
  2. Update the Level 1 name to something more applicable than Net Assets
    • Before
      Before

    • After
      After


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Related articles

Was this article helpful?