Appearance
Consolidation
Also known as
- run consolidation
- group
- elimination
- group reporting
- minority interest
- NCI
- CTA
- translation
- consolidated trial balance
- consolidated statements
Consolidation combines the trial balances of a group's legal entities into group statements: each member is translated to the presentation currency, intercompany balances are eliminated and the consolidated trial balance, balance sheet and P&L are produced. The page has three tabs: Run, History and Intercompany accounts.
Run a consolidation
- Go to FinanceConsolidation, or press Ctrl K and type
run consolidation. - Group and date: choose the Group and the As of date (default the end of last month) and select Translate.
- Translated balances: check each member's rates and translated balances: Closing rate for balance-sheet accounts, Historical rate for equity, Average rate month by month for the P&L. The difference per member is the Translation adjustment (CTA). Select Next.
- Eliminations: check each rule's Source balance, Target balance, Eliminated and Residual. A residual means the two sides do not agree; find the missing intercompany posting. Select Next.
- Statements: read the Trial balance, Balance sheet and Profit and loss. Check before finalising lists warnings (for example a missing historical rate).
- Select Save run (needs Permission:
finance.consolidation.run). The run is stored as a draft ("Run CONS-… saved"); finalise it on the run page.
Saving again for the same date replaces the earlier draft. Nothing is posted to any ledger: eliminations and CTA live in the consolidation only.
History
History lists the runs per group with their date, status (draft or final) and totals. Select a run to open it.
Set up intercompany accounts
"Receivable and payable used towards each counterparty (default: the intercompany account mapping)."
- Open Intercompany accounts and select Add pair (needs Permission:
finance.intercompany.manage). - Choose the entity, the Counterparty (or Any entity), the Receivable and the Payable account.
Related
- Consolidation groups, Consolidation run
- Intercompany, Exchange rates, Legal entities
- Report view: Consolidated trial balance, balance sheet, profit and loss
- Close and report
- Legal entities and currencies
