Overview
Account Mapping in GATHER.nexus links a company's local Chart of Accounts (COA) to the Group Reporting Template (GRT).
This allows the company's accounts to be presented within the group's reporting structure when group reports are produced.
GATHER.nexus provides two methods for mapping accounts:
Manual Mapping
AutoMap with AI
The mapping screen also includes the platform-generated consolidation accounts that form part of the GRT.
1) Access Account Mapping
From your GATHER.nexus dashboard, go to Group Financial Reporting > Group Reporting Template.
Select the relevant GRT and open its Mapping Status.
Click Setup Group Accounts to open the account mapping screen.
2) Review the Mapping Screen
The mapping screen displays:
Your company's Chart of Accounts.
The GRT accounts used for group reporting.
The current mapping status of the source accounts.
Map each source-company account to the appropriate GRT reporting account.
Mapping is optional, so source accounts can remain unmapped where required.
3) Map Accounts Manually
Manual Mapping allows you to select the appropriate GRT account for each source-company account.
Review the source company's Chart of Accounts.
Identify the corresponding account in the GRT.
Map the source account to the appropriate GRT account.
Continue until the required accounts have been mapped.
Click Save.
The mapped source accounts contribute to group reporting through the relevant GRT accounts.
4) Use AutoMap with AI
AutoMap with AI generates suggested mappings for applicable source accounts.
GATHER.nexus uses Microsoft Azure AI to generate the suggested mappings based on the available account information and the group reporting structure.
Open the account mapping screen for the relevant GRT.
Click AutoMap with AI.
Review the suggested mappings.
Change any suggested mapping that is not appropriate.
Apply the mappings.
Review the remaining mapped and unmapped accounts.
Manually map any accounts that still require mapping.
AI-generated mappings are suggestions and should be reviewed before they are applied.
5) Review Platform-Generated Consolidation Accounts
GATHER.nexus automatically adds consolidation accounts to the GRT.
These accounts are identified with a Platform generated tag. They are locked, which means they cannot be hidden or deleted.
Where a platform-generated parent account has subsidiary-specific child accounts, GATHER.nexus creates one child account for each subsidiary. If the number of subsidiaries changes, the child accounts change to match.
These subsidiary-specific accounts form part of the group reporting structure and are not created in the individual companies' QuickBooks Online or Xero books.
Profit & Loss
The platform-generated Profit & Loss accounts include:
Profit Attribute to Minority Interest
One child account per subsidiary, where applicable.
Total
Profit excluding minority
Balance Sheet
The platform-generated Balance Sheet accounts include:
Investment in Subsidiary
Goodwill
One child account per subsidiary, where applicable.
Total Goodwill
Equity attributable to the minority
Child accounts per subsidiary, where applicable.
Total
NCI Acquisition Reserve, when any subsidiary has a step acquisition or disposal.
Capital Gain on Bargain Purchase, when goodwill is negative for any subsidiary.
FX in reserves, when a subsidiary's currency differs from the group currency.
6) Map the Investment in Subsidiary Account
Investment in Subsidiary is used for the amount recorded in the holding company's books for the purchase of the subsidiary.
Map the holding company's source account used to record the investment in the subsidiary to Investment in Subsidiary in the GRT.
This is the source account that needs to be mapped for the investment amount used in the consolidation calculation.
7) Goodwill
Goodwill is automatically created as a platform-generated account in the GRT.
You do not need to map a source-company account to Goodwill.
GATHER.nexus calculates Goodwill as part of the consolidation process using the acquisition information and the subsidiary's net assets.
The Goodwill calculation can be reviewed in the Working Paper.
8) Capital Gain on Bargain & Purchase
Capital Gain on bargain & purchase is a platform-generated Balance Sheet account.
GATHER.nexus creates this account when the consolidation calculation results in negative goodwill for a subsidiary.
The account is populated through the consolidation process and does not require a source-company account to be mapped to it.
9) FX in Reserves
When a subsidiary reports in a currency other than the group currency, GATHER.nexus creates FX in reserves accounts to capture the applicable foreign-exchange differences.
The platform creates:
An FX in reserves parent account.
Child accounts for applicable equity elements that can carry an exchange difference.
A Total account.
An FX in reserves (Purchase Consideration) account is created when the purchase consideration is in a currency other than the group currency.
Step-acquisition-related FX accounts are created when a step acquisition or disposal exists.
The Capital Gain FX account is created when goodwill is negative.
10) Using Platform-Generated Child Accounts
Where platform-generated accounts have subsidiary-specific child accounts, these accounts can be selected when posting consolidation journals.
This allows NCI and related consolidation adjustments to be posted directly against the relevant subsidiary account.
11) Complete Your Account Mapping
After reviewing the mappings:
Save your manual mappings or apply the reviewed AI suggestions.
Review the mapping status.
Review any accounts that remain unmapped.
Complete any additional mapping required for your group's reporting structure.
Your mapped accounts will then feed into the group's reporting structure through the GRT.
Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or contact support for assistance.