Overview
Auto Journals in GATHER.nexus automatically clear intercompany balances during consolidation. This keeps group reports clean, accurate, and ready for review without manual re-entries.
If your entities use different currencies, you can also turn on Auto FX2 to automatically handle currency translation differences.
Setting Up Auto Journals
1. Open the Auto Journals App
From the dashboard, go to Group Financial Reporting → Auto Journals.
Click Setup New Auto Journal.
2. Fill in the Basics
Narration – Short, clear label (e.g., “IC Sales Elimination”).
Group – Select the relevant reporting group.
Start Period – Define the first reporting month (MM-YYYY).
Reference Number – Auto-generated, editable for tracking.
3. Choose Draft or Live
Draft ON – Journals are created but excluded from reports (ideal for testing).
Draft OFF – Journals are active immediately.
4. Set the First Company
Select the company.
Choose the Intercompany Account (from its COA).
(Optional) If applicable, select the Counterparty (Customer/Vendor from that company’s records).
Add a description for clarity.
5. Set the Second Company
Repeat the setup for the second entity.
Match the correct intercompany account.
(Optional) Select the matching Customer/Vendor, if tagged.
Keep descriptions consistent to maintain a clear link.Note: Counterparty relationships must match - if Company A lists Company B as a customer, Company B should list Company A as a vendor.
Note: Counterparty relationships should be consistent where used. However, some intercompany accounts are not tagged to Customer/Vendor records - in these cases, eliminations are set up using the intercompany accounts directly.
6. Optional – Enable Auto FX2
Why Auto FX2 is needed
When intercompany transactions occur across entities with different base currencies, timing differences in exchange rates can create imbalances.
Each entity records transactions in its local currency using the exchange rate on the transaction date.
At consolidation, those same amounts are retranslated into the Group Reporting Currency using average (P&L) or closing (Balance Sheet) rates.
This can leave small differences between sales and costs, overstating or understating Profit After Tax (PAT).
Without adjustment, these FX mismatches would:
Distort consolidated P&L by leaving unexplained gains/losses in PAT.
Misstate Current Year Earnings in the Balance Sheet.
How Auto FX2 works – Practical Example
UK company invoices £1,000.
US company records it as $1,300 at transaction date rate (1.30).
At month-end, average rate is 1.25 → $1,300 converts to £1,040.
Consolidation imbalance = £40.
Auto FX2 posts automatically:
Moves £40 out of Profit After Tax → into FX Differences (2) in the Consolidated P&L.
Posts £40 into FX Differences in Reserves (2) in the Consolidated Balance Sheet.
Keeps Current Year Earnings aligned with the P&L.
Where Auto FX2 is posted: Auto FX2 journals appear in Working Papers, alongside other consolidation journals, ensuring they are fully visible in the review and audit trail.
7. Create the Journals
Click Start Creating. GATHER will:
Detect intercompany transactions.
Generate elimination entries.
Apply FX2 adjustments (if enabled).
Review and Manage Journals
Review and Manage Journals
Open View Journals to check details:
Date created
Narration
Group
Status (Draft or Published)
Amount eliminated
Actions available:
Edit – Adjust narration or amounts
History – Review changes over time
Inactive – Pause journals without deleting
Need help? Visit gather.nexus, click the chat icon in the bottom-right corner, or email us at [email protected] for assistance.