Skip to main content

Set up Balance sheet Group Reporting Template (GRT)

Updated: August 23, 2025

Updated over a month ago

Step 1: Access Balance Sheet Templates

  • From your GATHER.nexus dashboard, go to Group Financial Reporting → Group Reporting Template.

Step 2: Review Existing Templates

  • Your dashboard lists any existing P&L or Balance Sheet templates.

    • New users will see an empty list ready for setup.

Step 3: Create a New Template

Click Add GRT (top right).

  • Select the Balance Sheet tab.

  • Enter Template Name (e.g., “Group Balance Sheet” or “IFRS Position”).

  • Choose the Group it applies to.

  • Select one of the three setup methods.


Option 1: CSV Import (for existing Balance Sheet structures)

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

  2. Select Balance Sheet and choose Import from CSV.

  3. Download the sample CSV to see required columns and hierarchy. Typical columns: account code, account name, parent/group, classification (current/non-current), and order.

  4. Prepare your file following the sample format (Assets, Liabilities, Equity). Use consistent account numbering if you have it.

  5. Upload via Browse or drag & drop, then click Create & Setup.

  6. Confirm import results (the system shows how many accounts were created).

  7. Edit imported lines if needed: change labels, reorder, or hide accounts.

  8. Click Update & Map Account when you’re satisfied.


Option 2: Industry Standards (GAAP / IFRS scaffold)

  1. From Add GRT, choose Balance Sheet then select Industry Standards.

  2. Preview available templates (e.g., IFRS) to inspect sections and level of detail (current vs non-current assets/liabilities, equity breakdown).

  3. Select the template and click Create & Setup.

  4. The template loads with a standard hierarchy. Review and modify categories to match your reporting needs (add or hide lines, adjust labels).

  5. Save via Update & Map Account.


Option 3: Manual Creation (full custom structure)

  1. From Add GRT, choose Balance Sheet then select I will create Group CoA manually and click Create & Setup.

  2. You’ll start from a basic framework (Assets / Liabilities / Equity). Add sections or subgroups as needed.

  3. Use the management controls to: add a line, edit account details, set parent/child relationships, and reorder the hierarchy.

  4. Build industry- or region-specific categories, and name values clearly for management reporting.

  5. When finished, click Update & Map Account.


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?