Questions? We have answers.

Creating an Excel template Account Grouping for an organization - Full workflow

Article author
Aman Rawat
  • Updated

Overview

This workflow takes 3 steps: 

  1. Create an account grouping
  2. Create a library 
  3. Applying a Library to a New Engagement

Workflow

Step 1: Create an Account Grouping

To perform this task, begin by navigating to Admin Settings

NOTE: Depending on your level of access, the ADMIN button may not be visible. If you’re not an Admin, contact your Admin to perform this task or give you access.

From the Admin Settings page, click the Account Groupings tab near the top of the page.

c898a57e-0a60-4bc4-8e20-dcc6de32c2c9.png

You’ll be taken to the Account Groupings page, which displays a list view of all the account groupings in your tenant. Click Create new account grouping on the upper right of the page.

5b21833e-8084-4892-b997-6c8ad4608f4f.png

The Import a Custom Account Grouping modal will appear on your screen. Select Excel Template and click Download Template.

mceclip0.png

Once you click on Download, the Mindbridge excel template will be downloaded to your system. Open the template and map your internal codes with MAC codes based on the possible nearest match.

You should provide the details in the top three rows in the template. The MAC codes can be mapped with the internal codes with help of MAC code tab in the template.

mceclip1.png

mceclip3.png

You can remove the Example Grouping tab but it doesn't matter because Mindbridge will read the first tab in the workbook. Once you are done mapping your internal codes with the MAC codes your file should look like the one shown in the Example Grouping tab.

mceclip2.png

When your excel template is ready, then select create account grouping and select Excel Template and then click Next

mceclip0.png

On the modal’s second page, give your account grouping a Name and upload your Excel file. You can upload this file using drag and drop or by browsing your computer.

2da803f7-1746-45ef-833f-10b7df90cd01.png

MindBridge will then begin uploading and validating your CCH Group Trial Balance. Once your Excel is uploaded, click Next.

mceclip4.png

You’ll be taken to the Account Grouping page, which includes a table containing the columns of your file. From this page, verify that your accounts are properly mapped to the appropriate MAC code and that every account has the proper account tags and industry tags. After verifying your accounts and tags, click Publish.

mceclip5.png

A modal will appear on your screen reiterating that changes can’t be made to an account grouping once it is published. Once you’re sure that the accounts are properly mapped and tagged, click Publish.

mceclip6.png

Your new account grouping will be available for use and listed on the Admin section’s Account Groupings tab.

mceclip7.png

Step 2: Creating a New Library

To perform this task, begin by navigating to the Admin Settings

NOTE: Depending on your level of access, the ADMIN button may not be visible. If you’re not an Admin, contact your Admin to perform this task or give you access.

From the Admin section, click the Libraries tab near the top of the page.

9aa5041b-1a04-41c5-b0ec-2402c3163470.png

From the Libraries tab, click Create New Library on the upper right of the page. 

0e2f88a7-0c89-446a-86be-880997a56cee.png

The Create New Library form will appear on your screen. Provide the following information for your Library:

mceclip9.png

  • Library name: The name you want to give your library. This will be reflected across MindBridge.
  • Base Library: All new Libraries must be based on an existing Library. This provides predefined ratios, filters, and control points for your analyses. Selecting a Base Library will match the parameters of this new library with your Base Library choice.
  • Account Grouping: Once you choose a base library, select the account grouping you created during Step 1.
  • Industry Tags: As auditors create account groupings containing many different accounts, there may be instances where overlap occurs and you only need a portion or a subset of a full account mapping. With industry tags, you can create libraries that employ only a portion of an account grouping’s accounts.

Once you have filled out the modal, click Create Library to create the library or Cancel to discard your changes and return to the Libraries tab.

Step 3: Applying a Library to a New Engagement

To perform this task, you'll need to navigate to your organization’s Engagements page.

From your organization’s Engagements page, click Create Engagement to the upper right of the page. 

11841730-b2ae-48b1-9665-ee0e4ceb7062.png

You’ll be taken to the Create Engagement page. Use the Library drop-down menu to choose the new engagement’s library. To learn more about this modal, visit Creating an Engagement. Once you’ve filled out the form and chosen your library, click Create Engagement at the bottom of the page.

08b68fb4-794b-486d-8edc-3d6bc315d8e2.png

Your new engagement will be listed with the rest of your organization’s engagements on the Engagement page.

 

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.