Overview
Working Paper Validation within GATHER.nexus is used to help users analyse consolidation differences that may arise during intercompany Profit & Loss (P&L) reconciliation across entities operating in different currencies.
The workflow focuses specifically on Auto FX 2 scenarios where:
Intercompany transactions reconcile successfully within Intercompany Reconciliation using transaction-date FX rates
Consolidation reporting applies average FX translation rates
A remaining variance may still appear within Working Papers due to FX translation behaviour
Working Paper Validation helps users assess whether a remaining consolidation difference is likely caused by FX translation impacts or whether it may indicate an underlying reconciliation or accounting issue requiring further investigation.
Fundamental Context
Within intercompany P&L reconciliation workflows:
Transactions are typically matched and reconciled using transaction-date exchange rates
This reflects the original values recorded within the source ledgers
However, during consolidation reporting:
P&L balances may be translated using average monthly FX rates
Consolidation outputs may therefore differ from transaction-date reconciliation balances
As a result:
Transactions may reconcile operationally
A remaining variance may still appear within Working Papers
The variance may arise due to FX translation behaviour during consolidation
Working Paper Validation is designed to help users analyse and validate this scenario before relying on the resulting Auto FX 2 consolidation treatment.
Validation Objective
The objective of Working Paper Validation is to:
Compare transaction-date reconciliation balances against consolidation translated balances
Analyse remaining consolidation variances
Improve visibility into FX translation impacts
Help distinguish FX-related differences from operational reconciliation issues
Support review of Auto FX 2 consolidation outcomes
The process helps users understand why a consolidation difference may still exist even when the underlying intercompany transactions reconcile successfully.
Example Scenario
The following example demonstrates a typical Auto FX 2 validation workflow for an intercompany P&L reconciliation pair.
Reconciliation Stage (Transaction-Date FX Rates)
An intercompany transaction exists between two entities operating in different currencies.
For example:
Holdco records Intercompany Sales
US Sub records Intercompany Purchases
Within Intercompany Reconciliation:
Entity | Account | Transaction-Date Balance |
Holdco | Intercompany Sales | 1,000 |
US Sub | Intercompany Purchases | 1,000 |
At transaction-date FX rates:
The balances reconcile successfully
No operational discrepancy exists
The reconciliation workflow is balanced
Working Paper Validation Stage (Average FX Rates)
Within Working Paper Validation, the same balances are translated using average monthly consolidation FX rates.
Example:
Entity | Average-Rate Balance |
Holdco | 1,000 |
US Sub | 995.62 |
Remaining variance:
4.38
In this scenario:
The underlying reconciliation remains operationally correct
The remaining difference is created by FX translation behaviour within consolidation reporting
This demonstrates how:
A reconciliation can balance successfully at transaction-date rates
A variance may still appear within consolidation outputs due to translation methodology differences
Validation Logic
Working Paper Validation follows two review stages.
1. Transaction-Date Validation
Balances are reviewed using transaction-date FX rates.
Where balances reconcile successfully:
This indicates the underlying transactions reconcile operationally
The reconciliation workflow itself is balanced
2. Average FX Validation
Balances are then translated using average consolidation FX rates.
Where:
Transaction-date balances reconcile
A remaining variance still exists at average rates
the remaining difference may indicate FX translation impacts arising during consolidation.
The comparison helps users assess whether:
The remaining difference is consistent with FX translation behaviour, or
Additional reconciliation investigation may still be required
Importance of Validation
A remaining consolidation variance is not automatically proof that the difference is genuinely FX-related.
For example:
A transaction may be missing
An amount may be incorrectly posted
A reconciliation imbalance may still exist operationally
In these situations:
A difference may still appear within consolidation outputs
The variance may not genuinely arise from FX translation
Working Paper Validation helps users review the nature of the remaining difference before relying on the resulting Auto FX 2 consolidation outcome.
Accessing Working Paper Validation
Navigate to:
Intercompany Reconciliation > Continue Reconciliation
Open the relevant reconciliation workflow and reporting period.
For Auto FX 2 workflows:
Select the relevant intercompany P&L reconciliation pair
Open the Working Paper Validation section
Review:
Transaction-date balances
Average-rate translated balances
Remaining consolidation variances
Auto FX 2 Consolidation Treatment
Where Auto FX 2 is configured:
The intercompany P&L elimination is processed during consolidation
A remaining FX-related variance may still exist
The remaining difference may then be posted through the Auto FX 2 consolidation treatment
Within Working Papers:
One side of the adjustment may post against the intercompany elimination
The offset may post to FX Differences in Reserves (2) or the configured FX adjustment account
The exact configuration may vary depending on the consolidation setup.
Relationship to Intercompany Elimination
Auto FX 2 operates alongside intercompany elimination processing.
Within this workflow:
The underlying intercompany P&L balances are eliminated
FX translation differences may still remain
Auto FX 2 supports the handling of the resulting consolidation variance
This allows:
The operational elimination
And the related FX translation impact
to be reflected separately within the Working Papers.
Summary
Working Paper Validation within Intercompany Reconciliation helps users analyse consolidation variances relating to Auto FX 2.
The workflow demonstrates how:
Intercompany P&L transactions may reconcile successfully at transaction-date FX rates
Consolidation reporting may apply average FX translation rates
A remaining difference may still appear within Working Papers due to FX translation behaviour
The validation process helps users assess whether:
A remaining variance is consistent with genuine FX translation impacts, or
Additional reconciliation investigation may still be required
This improves visibility into consolidation outcomes, strengthens auditability, and supports more accurate and controlled multi-currency consolidation reporting.
Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or email us at [email protected] for assistance.