Questions? We have answers.

Troubleshooting issues with a CCH account grouping import

Article author
Daniel O'Sullivan
  • Updated

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. 

Step 1:
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.

Step 2:
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:

 

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

Step 3:
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):

Screen Shot 2020-07-24 at 11.03.17 AM.png
Sheet 1 is furthest to the left

Step 4:

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:

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

 

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

Before:

Before


After:

After

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.