Before you begin, make sure:

You have started the consolidation and mapped your Chart of Accounts of companies properly with GRT Accounts
Your Xero or QuickBooks data are synced and up to date
You have access to the Complete Consolidation screen

Step 1: Access your consolidation data

Navigate to Complete Consolidation from your main dashboard
Select the appropriate financial year and period from the dropdown menus
Ensure you're viewing the Profit & Loss tab (this process works the same for Balance Sheet)

Step 2: Switch to entity view

Click the Aggregated button on the column you want to explore
The view will expand to show individual company contributions

What you'll see: Instead of just one consolidated figure, you'll now see separate columns for each legal entity in your group, showing exactly how much each company contributes to that line item.

Step 3: Drill into specific company data

Find the company whose transactions you want to examine
Click on the amount figure (the blue hyperlinked number) for that specific company
A detailed transaction pop up will appear titled "GRT Account Detail Transaction"

Step 4: Review transaction details

In the pop up window, you'll see:

Company information: The selected entity's name (e.g., "Demo Silo AUD")

Account mapping:
- GRT Account: The standardised account name used across your group
- Mapped account: The actual chart of accounts from Xero/QuickBooks for this company
Represent amount as:
- None: The actual amount
- Thousands: showing amounts in thousand
- Millions: showing amounts in million
- Billions: showing amounts in billion

Transaction breakdown:

Reference URL: Direct links to view transactions in your accounting system
Date: When each transaction occurred
Transaction Type: The nature of the transaction (e.g., "Accounts Receivable invoice, Accounts Payable invoice, Manual Journal etc")
Description: Details about the transaction (from records in Xero/QuickBooks)
Debit/Credit: The amounts in your Group Reporting Currency

Step 5: Customise your view

Change account mapping: Click the Mapped account dropdown to select or deselect specific accounts if multiple accounts map to the same GRT account

Change company: Use the Company dropdown to quickly switch between entities without closing the pop up

Adjust GRT account: Select a different GRT Account from the dropdown to analyse other line items

Understanding currency translation

Important: All amounts shown in the drill-down are displayed in your Group Reporting Currency. The original transaction data in Xero/QuickBooks is recorded in the company's local currency.

FX Translation approach in GATHER:

Profit & Loss accounts: Translated using monthly average exchange rates
Balance Sheet accounts: Translated using month-end exchange rates

Confirming your analysis

After reviewing the drill-down data:

The individual transaction amounts should add up to the company total shown in the main consolidation
Reference URLs should take you directly to the source transactions in Xero or QuickBooks
Currency translations should reflect the FX Translation approach detailed above

Common questions

Q: The amounts don't match what I see in Xero/QuickBooks. Why?

A: Remember that drill-down amounts are converted to your Group Reporting Currency. Check the currency tabs to see both local and group currencies. Also, ensure your data sync is complete and up to date.

Q: Can I export this drill-down data?

A: Whilst you can't export directly from the drill-down pop up, you can use the Reference URL links to access the original transactions in your accounting system for further analysis or export.