Overview
The Profit & Loss (P&L) report consolidates performance across your entities in a single, presentation currency. Use it to configure periods and currency, customise what’s shown, drill into source transactions, and share polished outputs.
Create a P&L Report
Go to Group Financial Reporting → Reports and click Add Report.
Set Report Name, select the Group, and choose the GRT (Group Reporting Template).
Pick the Year, Frequency (Monthly / Quarterly / Annually), and Report Periods.
Choose the Report Presentation Currency (figures are translated from the Group Reporting Currency using average monthly rates).
Click Add. The report appears in your list; open Preview to view it.
Customise the View
Use Settings in the report toolbar to:
Periods: Add/remove months in-view.
Group Class: Filter to analyse specific segments.
Journals: Include consolidation journals or view pre-adjustment data; optionally show intercompany accounts separately.
Entities: Select which entities to include alongside the consolidated total.
Currency & Display: Switch display currency or adjust format options.
Workpapers Status & Currency Logic
Completion status: Monthly columns show a green tick when the month is completed in Working Papers.
Currency: The “in Actual” indicator confirms conversion from Group Reporting Currency using average monthly rates for each period.
Drill-Down & Audit Trail
Click any account line to see:
Underlying transactions and dates/refs sourced from Xero or QuickBooks.
Entity-level contributions and any intercompany eliminations.
A complete path from source data to consolidated figures.
In Reports, drill-down lets you analyse contributions and adjustments at the entity and consolidation level.
For transaction-level deep links back to the source system, open the corresponding period in Working Papers, where every entry is traceable to its origin.
Manage Reports
Edit: Reopen the configuration to adjust periods, entities, currency, or template.
Duplicate: Create a copy for a new variant; rename as needed.
Delete: Remove a report you no longer need.
Share & Export
Email: Send to up to 10 recipients; choose PDF, XLSX, or XLS and add a short note.
Export: Download from the toolbar for offline analysis or board packs.
Exchange Rates
Select Exchange Rate in the toolbar to view the FX rates used for translation, ensuring transparency in multi-currency reporting.
Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or email us at [email protected] for assistance.