Overview
The Group Reporting Template (GRT) is the group-level reporting structure used across the Working Paper, consolidated Reports, and Group Budgets.
You can create a GRT in three ways:
Import an existing structure from CSV.
Select a ready-made template.
Build the structure manually.
GATHER.nexus automatically adds the default consolidation accounts required for group reporting to the GRT.
1) Access Group Reporting Template
From your GATHER.nexus dashboard, go to Group Financial Reporting > Group Reporting Template.
Click Add GRT.
Select Profit & Loss as the statement type, then choose how you want to create the reporting structure.
2) Import an Existing Structure from CSV
Use Import from CSV if you already have a Profit & Loss reporting structure that you want to use in GATHER.nexus.
From Add GRT, select Profit & Loss.
Select Import from CSV.
Download the sample CSV to review the required columns and structure.
Prepare your CSV using the required format.
Upload the CSV.
Click Create & Setup.
Review the imported reporting structure.
Click Update & Map Account to proceed to account mapping.
The platform automatically adds the default consolidation accounts required for group reporting.
3) Select a Ready-Made Template
Use Industry Templates to start with a pre-configured Profit & Loss reporting structure.
From Add GRT, select Profit & Loss.
Select Industry Templates.
Review the available templates.
Select the template you want to use.
Click Create & Setup.
Review the reporting structure.
Click Update & Map Account to proceed to account mapping.
The platform automatically adds the default consolidation accounts required for group reporting.
4) Create the GRT Manually
Use I will create Group CoA manually when you want to build your own Profit & Loss reporting structure.
From Add GRT, select Profit & Loss.
Select I will create Group CoA manually.
Click Create & Setup.
Build the required reporting structure.
Add and arrange the reporting accounts as required.
Click Update & Map Account to proceed to account mapping.
The platform automatically adds the default consolidation accounts required for group reporting.
5) Review Platform-Generated Consolidation Accounts
GATHER.nexus automatically adds default accounts required for consolidation to the GRT.
These accounts display a Platform generated tag and are shown as locked.
Locked accounts cannot be hidden or deleted because the platform's calculations rely on them. Hovering over the hide or delete action displays a note explaining why the action is unavailable.
Where a default parent account has subsidiary-specific children, GATHER.nexus creates one child account for each subsidiary. If the number of subsidiaries changes, the child accounts change to match.
The subsidiary-specific accounts form part of the group reporting structure. They are not created in the subsidiaries' own QuickBooks Online or Xero books.
6) Profit & Loss Consolidation Accounts
The platform-generated Profit & Loss accounts are added after Net Profit After Tax:
Profit Attribute to Minority Interest
One child account for each subsidiary with a non-controlling interest.
Total
Profit excluding minority
These accounts are used to present the portion of profit attributable to minority interests separately from profit excluding minority.
The minority-interest figures are generated as part of the consolidation process rather than being sourced from the individual subsidiaries' charts of accounts.
7) Map Your Accounts
After you finish setting up the GRT, GATHER.nexus takes you to the account mapping screen.
Map each company's QuickBooks Online or Xero chart of accounts to the matching accounts in the group reporting structure.
Mapping is optional, so you can leave source accounts unmapped where required.
The platform-generated consolidation accounts also appear in the GRT structure. As a general rule, do not map source accounts to these accounts. They are populated by GATHER.nexus through its consolidation calculations and journals.
8) Use Subsidiary-Specific Accounts in Consolidation Journals
Where GATHER.nexus creates subsidiary-specific child accounts under a platform-generated account, those accounts form part of the group reporting structure.
The subsidiary-specific child accounts can be selected when posting consolidation journals.
This allows NCI and related adjustments to be posted directly against the relevant subsidiary account.
9) Additional Consolidation Accounts
Some consolidation accounts are created only when the relevant circumstances apply.
These include:
NCI Acquisition Reserve when a subsidiary has a step acquisition or disposal.
Capital Gain on Bargain Purchase when goodwill is negative for a subsidiary.
FX in reserves when a subsidiary's reporting currency differs from the group currency.
For FX in reserves, GATHER.nexus creates a parent account, applicable child accounts for equity elements that can carry an exchange difference, and 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) Complete the GRT Setup
Review the Profit & Loss reporting structure and complete any required account mapping.
The completed GRT can then be used across:
Working Paper
Consolidated Reports
Group Budgets
The platform-generated consolidation accounts remain part of the GRT and cannot be hidden or deleted.
Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or contact support for assistance.