Skip to main content

Set up Profit & Loss Group Reporting Template (GRT)

Updated: August 23, 2025

Updated over a month ago

Option1: CSV Import - upload your existing structure

  • Ideal if you already maintain a P&L format in spreadsheets and want to replicate it quickly in GATHER.nexus.

Steps

  1. Go to Group Financial Reporting → Group Reporting Template → Add GRT.

  2. Choose Profit & Loss and select Import from CSV.

  3. Download the sample CSV to check required columns (code, name, parent, classification, order).

  4. Prepare your CSV to match the layout.

  5. Upload the file and click Create & Setup.

  6. Confirm import results, then edit account order or visibility as needed.

  7. Click Update & Map Account to finalise.

After import

  • Review structure and make adjustments.

  • Map each entity’s accounts to the new template.


Option2: Industry Templates - start from a ready-made model

  • Choose from pre-configured templates based on IFRS or specific industries, then adjust them for your group.

Steps

  1. Go to Add GRT → Profit & Loss → Industry Templates.

  2. Preview options like IFRS, SaaS, or Manufacturing.

  3. Select the template that fits your group’s reporting style.

  4. Click Create & Setup to load it.

  5. Modify sections, add/remove accounts, or rename as needed.

  6. Click Update & Map Account to save.


Option3: Manual Creation - build your template line by line

  • Use full flexibility to define your reporting structure exactly as you need.

Steps

  1. Go to Add GRT → Profit & Loss → I will create Group CoA manually.

  2. Click Create & Setup to start from the default framework: Revenue, COGS, Expenses, Key metrics.

  3. Add new lines, create subgroups, and reorder accounts to reflect your structure.

  4. Build out categories (e.g., industry-specific, intercompany, custom KPIs).

  5. Click Update & Map Account to finish setup.

Note:

  • Define high-level categories first, then expand into detail.

  • Keep names consistent for easy mapping and reporting.

Common features across all methods

  • Show / Hide toggle: control which accounts appear in detailed vs summary reports.

  • Editable anytime: rename, add, or hide lines after creation.

  • Multiple templates: create different versions for regulatory, investor, or internal use.

  • Mapping: link each legal entity’s COA to the new template for consolidation.


Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or email us at [email protected] for assistance.

Did this answer your question?