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.
Configuration
You must be an App Admin to access account groupings.
Go to the Account groupings tab
- Open the sidebar (
) from anywhere in MindBridge.
- Select Admin (
).
- Go to the Account groupings tab.
You will see a list view of all the account groupings available in your tenant.
Overview
After importing an account grouping, MindBridge will reflect the accounts imported in the account grouping across all tables, etc.
The following columns are included in the MindBridge account grouping Excel* template below this article.
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:
Note: This text will appear across the MindBridge interface. |
Yes |
Level 2 |
The name or description of the secondary account grouping. For example:
Note: This text will appear across the MindBridge interface. |
Yes |
Level 3 |
The name or description of the tertiary account grouping. For example:
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:
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. |
Yes |
*Microsoft, Word, and Excel are trademarks of the Microsoft group of companies.
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)
-
Cash and Cash Equivalent (Level 3)
-
Current Assets (Level 2)
Only the deepest account level must be mapped. MindBridge will deduce the account mappings for the higher levels.
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.