11.7 Account Mapping - Automating Report Content

Preparing for Automation

Before automating report content, You must have completed the following:

1. Configure Your Excel Adaptor to utilise account mapping.
2. Upload Your Chart of Accounts: This should encompass your primary accounts and any applicable sub-accounts or dimensions.
3. Create Your Account Mapping Hierarchy: Set up the account mapping hierarchy for your accounts, sub-accounts, and dimensions.
4. Map Your Accounts and Sub-Accounts/Dimension Members: Map your chart of accounts to your account mapping hierarchy.

Once these prerequisites are fulfilled, you can proceed with automating your report content.

Automation Panel

Your account and any sub-account/dimension account mapping hierarchies will be replicated in the Automation panel.:

Account Mapping

You can use any Account node to create an account mapping data object in the report. Here's what you can do:

• Drag-and-drop: Drag an account and drop it onto a number, a table cell or a preselected range of table cells.
• Keyboard Shortcut: Select an account, number, table cell, or a range of table cells in the report and press the {ctrl} + {t} keyboard shortcut.
• Value Editor Panel: Select a data object within the report and change its Data Adaptor to Account Mapping using the Value Editor panel.

Each data object created using these methods will return the total of all the balances of accounts mapped to this account mapping node and any of its children.

Sub-account/Dimension Mapping

After automating an item in the report using an account, you can further refine its value by incorporating Sub-Accounts/Dimension member nodes. This allows you to filter the balances, including only those linked to the designated sub-accounts or dimension members.

For instance, if you need to automate a table like the one below:

In this scenario, you can apply the same "Revenue" account node to all rows and apply different sub-account nodes to distinguish between various products.

Please refer to this video which illustrates the many ways you can combine account and sub-account nodes to automate report content:

Drilling Down on an Automated Data Object

To inspect which account mapping nodes have been used in automating a report data object, and to see the list of filtered trial balance entries that contribute to the total, select the object and click on the "Configure Adaptor" button in the Value Editor panel:

This will open the following form:

With this form, you can:

• Change the account mapping nodes
• Review the trial balance line items contributing to the total.