US Intercompany Elim
Multi-entity consolidation worksheet: intercompany eliminations, minority interest, currency translation and a consolidated trial balance for SMB groups
Multi-entity consolidation worksheet: intercompany eliminations, minority interest, currency translation and a consolidated trial balance for SMB groups
Key Features
Per-entity trial balance input
Per-entity trial balance input — capture each subsidiary's TB in its own functional currency, tagged by account type (asset, liability, equity, income, expense) so every downstream step knows how to treat the line.
Current-rate currency translation
Current-rate currency translation — balance-sheet lines translate at the entity closing rate and income-statement lines at the average rate, and the resulting cumulative translation adjustment (CTA) is booked to equity so the consolidated c
Automatic intercompany elimination
Automatic intercompany elimination — tag reciprocal accounts with a shared intercompany key and the worksheet nets AR against AP, intercompany sales against cost of sales, and loans receivable against loans payable, all on consolidation wit
Manual elimination rules
Manual elimination rules — for anything the auto-matcher cannot infer, define explicit rules that eliminate a chosen amount between two named accounts across two entities (investment vs. subsidiary equity, dividends, unrealised profit in in
Non-controlling / minority interest
Non-controlling / minority interest — for less-than-wholly-owned subsidiaries the worksheet reclassifies the minority share of equity and of net income into a dedicated Non-controlling Interest line.
Consolidated trial balance output
Consolidated trial balance output — a single balanced report with Combined, Eliminations, Minority Interest and Consolidated columns for every account caption, ready to feed the consolidated financial statements.
Balance checks everywhere
Balance checks everywhere — the worksheet refuses to leave the computed state imbalanced and surfaces the debit/credit control totals for each column.
Account caption mapping
Account caption mapping — roll many local chart-of-account codes up to a common consolidated caption so entities on different charts still combine.
Copy & roll-forward
Copy & roll-forward — duplicate a prior period's worksheet, ownership and rules to start the next close in seconds instead of rebuilding the workbook.
Full audit trail
Full audit trail — chatter tracking on the worksheet plus a drill-down into every elimination entry that was posted during the run.
Screenshots
Why Choose This Module
Load (or import) each entity's trial balance in its own functional currency, declare the ownership structure and the intercompany relationships once, and press Compute. The worksheet translates every entity into the presentation currency, automatically eliminates the intercompany receivables, payables, sales, cost of sales and loans, splits out the non-controlling (minority) interest and hands you a fully balanced consolidated trial balance with a transparent adjustment column for every step.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: base, mail
- Support: support@pokutsoft.com
Update date: 2026-07-05