Questions? We have answers.

Create an account grouping via a CCH group trial balance

  • Updated

Summary

Create an account grouping to see your organization’s financial accounts displayed across the analysis results dashboards and within exports.

An account grouping represents the structure of an organization's financial statements and is organized into distinct account groups, each of which are mapped to MindBridge Account Classification ("MAC") codes that MindBridge uses to analyze and score your financial data.

Learn how to create and publish an account grouping with a CCH group trial balance file, and how to start using it in MindBridge:

Tip: Learn more about account groupings and read about account grouping strategy in MindBridge.
Note: The account grouping applied to a given engagement is a point-in-time copy of the account grouping selected for use in the given library. Changes made to the account grouping from within an engagement will not affect the original version. Similarly, changes made to the original version will only be reflected once it has been selected for use in a new library and applied to new engagements — existing engagements will not be affected.

Go to the Account groupings tab

  1. Select Admin ( Admin icon ) near the bottom of the MindBridge sidebar on the left side of the screen. You will go to the User Management tab in the Admin settings by default.
  2. Go to the Account groupings tab. You will see a list view of all the account groupings in your tenant.
Note: You must be an App Admin to access the Admin settings. Learn about user roles

Create an account grouping with a CCH group trial balance

Note: You will need a CCH trial balance file to proceed.

Step 1: Import a CCH trial balance file

  1. Select Create account grouping near the top-right of the Account grouping page. A selection window appears and CCH Group Trial Balance is selected by default.
  2. Select Next to go to the next step.
  3. Enter a unique Account grouping name.
  4. Import the CCH trial balance file with drag and drop or browse for it on your computer. Once the file has been selected, MindBridge will begin importing and validating the data.
  5. When file has been imported successfully, select Next. You will go to the account grouping details page.

Step 2: Verify the accounts and MAC mappings

MindBridge assigns MAC codes to the accounts automatically, so it's important to verify that all accounts are present and that they have been mapped to the most appropriate MAC code.

On this screen, you can...

Search for accounts

The search bar is located above the table. Use the search bar to find specific account categories by name or description.

  1. Enter the keyword into the Search bar.
  2. To search, press enter/return on your keyboard, or select the magnifying glass icon ( Search icon ). The table will display account categories that match your search criteria.

Use the X icon to the right of a search term to clear the field and reset the table.

Filter for accounts

  • MAC code: Allows you to filter for accounts based on the MAC codes applied.
  • Account tags: Allows you to filter for accounts based on the account tags applied.

Use the checkboxes to select relevant account tags. The table will update dynamically based on your selection.

Deselect a checkbox or use the X icon to the left of the selection to remove it from the filter. Alternatively, use the X icon (located on the right side of the top-most field) to remove all of your selections.

Select Reset filter (located to the right of the filters, above the table) to remove all applied search terms and filters. 

Re-map an account manually

If you want to re-map an account, select a MAC code that best represents the lowest-level account in the hierarchy. Learn more about the MAC code system

Use the chevron icon to expand ( Expand icon ) or collapse ( Collapse icon ) each category level.

Note: Accounts must be mapped to a valid MAC code and cannot be left blank.

Re-map multiple accounts at once

You can also re-map multiple accounts using the bulk actions feature. Be sure to select a MAC code that best represents the lowest-level account in the hierarchy.

  1. Use the chevron icon ( Expand icon ) to expand the desired categories, down to the lowest-level accounts.
  2. Use the checkboxes to the left of each account to select those you want to update. Once a checkbox has been selected, a bulk actions bar appears.
  3. Open the Actions menu within the bulk actions bar.
  4. Select Edit MAC code. A selection window will appear.
  5. Use the chevron icon ( Expand chevron ) to open the field menu, then select one of the lowest-level categories in the hierarchy. If you know the name or code of the MAC code, you can search for it in this window.
  6. When you are satisfied that the mapping is correct, select Done to save your changes.

Select Cancel anytime to go back without saving your changes.

Update the account tags for an account

Use the field menus in the Account tags column to add and remove account tags for each account, as desired.

  • Add account tag: Select the desired field, then select an account tag from the list or enter your own then press enter/return on your keyboard to save it.
  • Remove account tag: Select the X icon to the left of any account tag to remove it from the given field.

Add account tags to multiple accounts at once

You can also add account tags to multiple accounts using the bulk actions feature.

  1. Use the chevron icon (located to the left of each account category) to expand ( Expand chevron.svg ) the desired categories, down to the lowest-level accounts.
  2. Use the checkboxes to the left of each account to select those you want to update. Once a checkbox has been selected, a bulk actions bar appears.
  3. Open the Actions menu within the bulk actions bar.
  4. Select Edit account tags. A selection window will appear.
  5. Select the empty field, then then select an account tag from the list or enter your own then press enter/return on your keyboard to save it.
  6. Optionally, use the X icon to the the left of any account tag to remove it from the field, or use the X icon on the right side of the field to remove all selected account tags.
  7. When you are satisfied with the account tags, select Save to apply them to the selected accounts.

Select Cancel anytime to go back without saving your changes.

Step 3: Finalize the account grouping

  1. When you are satisfied with your changes, select Publish (located at the bottom-right corner of the page). A confirmation window will appear.
  2. Select Publish to finalize the account grouping. The new account grouping will be available for use and you will go back to the Account groupings tab.


Export the account grouping

You can export the current account grouping to see it laid out in an Excel template. If the account grouping has been updated within MindBridge, those changes will be reflected in this export.

  1. On the Account groupings tab, open the Actions menu in line with the desired account grouping.
  2. Select Export grouping. The file will appear in your default download location.


Append to the account grouping

You can append to any account grouping, provided it has not been archived.

Note: In order to append accounts to an account grouping, you must export the current account grouping and add new account groups to the bottom of the existing list (following the same conventions). For each new account group, map each of the lowest-level accounts to the most appropriate MAC code based on their nature (using the MAC codes sheet within the export for reference).
  1. On the Account groupings tab, open the Actions menu in line with the desired account grouping.
  2. Select Append. A selection window will appear.
  3. Import the appendment file with drag and drop or browse for it on your computer. Once the file has been selected, MindBridge will begin importing and validating the data.
  4. When file has been imported successfully, select Next. The new accounts will be added to the account grouping and you will go to the account grouping details page.
  5. Select Update. A confirmation window will appear.
  6. Select Publish. The appended account grouping will be published and you will go back to the Account groupings tab in the Admin section.


Apply the account grouping to a new library

  1. Within the Admin settings, go to the Libraries tab.
  2. Select Create library. A form appears.
  3. Provide the following information:
    • Library name: The name used to identify the library across MindBridge.
    • Base library: New libraries must be based on an existing library in order to leverage predefined ratios, filters, and control points across different analyses. Select a base library (or import a library configuration file) to copy settings into this new library.
    • Account grouping: Select the account grouping you created.
    • Industry tags: As auditors create account groupings with different accounts, instances of overlap may occur. Industry tags can be leveraged to employ only a portion of an account grouping’s accounts.
  4. Select the Risk score display type you want to see across analysis results.
  5. Use the checkboxes below to determine the Risk scoring permissions for your team.
  6. When you are satisfied, select Create library. The new library will be created and you will go back to the Libraries tab.

Select Cancel anytime to return to the Libraries tab without creating a new library.


Apply the library to a new engagement

To perform this task, go to the organization’s Engagements page.

  1. Select Create engagement. You will go to the Create engagement page.
  2. Use the Library menu to select the library you created.
  3. Once you’ve filled out the required fields on this page*, select Create engagement.
    Your new engagement will be listed on the Engagements page.

*Learn more about creating an engagement


Anything else on your mind? Chat with us or submit a request for further assistance.

Was this article helpful?