Skip to main content

Starting Consolidation in Working Papers

Updated: August 23, 2025

Updated over a month ago

Overview

Working Papers in GATHER.nexus provide a complete environment for creating, managing, and finalising consolidations. They bring together multi-entity data, journal adjustments, and FX translations into one place, giving you:

  • A structured consolidation workflow.

  • Clear visibility over P&L and Balance Sheet across multiple entities.

  • Tools to manage years, frequencies, exchange rates, and journals.

  • Built-in notes, saving, and sign-off for audit-ready reporting.

Beyond creating consolidations, Working Papers also serve as the review and validation hub: drill into source transactions via deep links, confirm that intercompany eliminations and auto journals are posting as intended, check that reserves roll correctly through Auto FX, and use manual journals to resolve items that automation cannot address.

This guide walks you through the essentials: accessing Working Papers, creating a consolidation, managing reporting years and frequencies, working with exchange rates, adding journals, and completing sign-off.


Access & Navigation

  • From Group Financial Reporting, open Working Papers.

  • Dashboard shows: Consolidation Name, GRT, Group, Completion Status, Actions.

  • If empty, click Start Consolidation at the upper-right hand side to begin.


Creating a Consolidation

  1. Start Consolidation → complete the form:

    • Name (e.g., Q1 2025 Consolidation).

    • Financial Years (select 1–5 years).

    • Group (entities included).

    • Group Reporting Template (GRT) (structure to use).

  2. Start to create the working papers.

Note: One active consolidation per GRT.


Managing Years & Frequencies

  • Years selector → add/remove years (up to 5) → Apply.

  • Consolidate Frequency → choose Monthly / Quarterly / Semi-Annual / Annual.

  • Optional segmentation: enable Group Class to view by region, department, or product line.


Working with Exchange Rates

  • Profit & Loss uses monthly average FX rates.

  • Balance Sheet uses month-end FX rates.

  • Click Exchange Rates to view the rates applied to each period.


Adding Journals

Add journals directly within the consolidation:

  • P&L Journal — period adjustments and eliminations.

  • Recurring P&L Journal — automated repeats (review/edit as needed).

  • Balance Sheet Journal — BS adjustments and eliminations.

  • Linked Journal — impacts both P&L and Balance Sheet.

Quick tip: Utilize the Refresh Data after adding/editing journals or when source data changes to ensure the latest figures are reflected.


Completing & Signing Off

  • Notes: document assumptions, methodology, and audit support.

  • Save frequently to preserve progress and enable collaboration.

  • Sign-off when reviews are complete to lock the consolidation for audit and approval workflows.


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?