Multi-Entity Consolidation Workbook
Resolve counterparties before eliminating matched inter-entity balances. Keep local ledgers separate from group adjustments.
Method And Expected Result
Resolve the $500 difference before elimination. When both balances are $10,000, eliminate $10,000 from group receivables and payables while retaining local records. Currency translation, income/expense elimination and consolidation scope require their own approved policies.
Worked planning examples, not customer performance results. Changes stay in this page until exported; reloading resets them. Keep sensitive personal information out of this planning tool.
Working Sheet
| Input | Value USD | Basis |
|---|---|---|
| Entity A receivable | 10000 | Worked same-currency example |
| Entity B payable | 9500 | Before reconciliation |
| Counterparty difference | Unresolved | Receivable less payable |
| Matched amount | Unresolved | Only available when difference is zero |
| Group elimination | Unresolved | Remove matched internal balance at group level |
The Excel toolkit includes the Consolidation worksheet for this resource. CSV exports contain current values; Excel retains the calculator formulas.
