Questions? We have answers.

Create an account grouping from template

  • Updated

Summary

The accounts in your imported dataset must be mapped to appropriate MAC codes. This teaches MindBridge the structure of your account hierarchy, and allows MindBridge’s control points to run effectively against the data.

Creating your own account grouping allows you to replace the MAC code accounts displayed across MindBridge’s interface with your own.

Learn how to create an account grouping using the template provided below this article.

Tip: Read about account grouping strategy in MindBridge.

Go to the Account groupings tab

Note: You must be an App Admin to access and manage account groupings.
  1. Open the sidebar ( Sidebar open-close icon ) from anywhere in MindBridge.
  2. Select Admin ( Admin icon ).
  3. Go to the Account groupings tab.
    You will see a list view of all the account groupings available in your tenant.


Overview

In order to apply your financial hierarchy within MindBridge, fill out the MindBridge account grouping template* (below this article), ensuring that each row of the template contains a unique account group (i.e., the level descriptions used in one row should not appear in another row).

After importing an account grouping, MindBridge will reflect the accounts across all tables, etc.

Template overview

The following columns are included in the template. 

Column name Contents Required
Name

The unique name assigned to the new account grouping, displayed in MindBridge under Admin > Account groupings.

Note: When importing the template, you have the option to change the account grouping name.

Yes
Code Display Name

The name of the account code hierarchy system used within the dataset, displayed in MindBridge under Admin > Account groupings > View details.

Note: This is the name of the code system your firm uses. The name may be pre-defined by an ERP, or if your firm uses a proprietary code system, it can be assigned a custom name.

For example, the company Highland Wilding Technologies uses an internal code system called HWT Code. This name will be displayed within MindBridge if it is added to the cell beside "Code Display Name".

Recommended
Delimiter

Account grouping codes are typically delimited (i.e., separated by a character) to represent a hierarchical structure. This field indicates the delimiter character used in the dataset.

Note: If a delimiter is indicated but is not found in the actual data, it will be deleted.

If no delimiter exists, this field should be blank.

Note: If no delimiter exists, the account hierarchy will be determined based on the names or descriptions provided at each level.

Recommended
Code

The account being referenced in the new hierarchy. For example, "Current Assets" may reference code "10.2"

Note: Codes in this template must match those that appear within the imported trial balance, account list, and general ledger files.

Yes
Level 1

The name or description of the primary account grouping. For example:

  • Assets
    • Current Assets
      • Cash and Cash Equivalents
        • Cash

Note: This text will appear across the MindBridge interface.

Yes
Level 2

The name or description of the secondary account grouping. For example:

  • Assets
    • Current Assets
      • Cash and Cash Equivalents
        • Cash

Note: This text will appear across the MindBridge interface.

Yes
Level 3

The name or description of the tertiary account grouping. For example:

  • Assets
    • Current Assets
      • Cash and Cash Equivalents
        • Cash

Note: This text will appear across the MindBridge interface.

Recommended
Level 4

The name or description of the most granular account within the grouping. For example:

  • Assets
    • Current Assets
      • Cash and Cash Equivalents
        • Cash

Note: This text will appear across the MindBridge interface.

Recommended
Account tags

When added to the template, these "tags" will be automatically applied to the corresponding account when it is mapped within MindBridge.

Multiple tags can be separated by comma.

Account tags can also be used to filter for results after the analysis has been run.

Recommended
Industry tags

When added to a master list of accounts, these "tags" allow you to use a subsection of the account grouping (based on the industry) when creating new libraries.

Multiple tags can be separated by comma.

Recommended
MAC code

The code hierarchy MindBridge uses to map accounts to a single, consistent classification system.

Learn about the MindBridge Account Classification system

Yes

 


Map MAC codes to the most granular level

MAC codes may appear over 4 levels and are used to specify accounts. Each level indicates a higher level of account granularity. For example,

  • Assets (Level 1)
    • Current Assets (Level 2)
      • Cash and Cash Equivalent (Level 3)
        • Cash (Level 4)

Only the deepest account level must be mapped. MindBridge will deduce the account mappings for the higher levels.

excel spreadsheet with mindbridge MAC code highlighted


When you are satisfied, save the file as a comma-separated file (CSV) or Excel file, then import the account groupings via the Account Groupings Template (attached).


📚 MindBridge Academy

Learn more about account grouping through MindBridge Academy.


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


Related articles

Was this article helpful?