If your team handles high-volume intercompany (e.g., retail franchises, shared service centers), supercharge your template with these:
Perform reconciliations monthly to catch errors early rather than waiting for the high-pressure year-end close.
A high-level rollup for management review: intercompany transactions reconciliation template excel
Before diving into the mechanics of a template, it is vital to understand the stakes. Intercompany transactions occur when different divisions, subsidiaries, or branches of the same parent company do business with one another. This includes loans, management fees, sales of goods, and shared services.
Select data > Data > From Table/Range. Use Power Query to: If your team handles high-volume intercompany (e
That’s when Maya remembered the file she’d built last year:
Maya shared the read-only link with Leo and Clara. She didn’t ask for emails. She asked them to fill inside the same Excel workbook. This includes loans, management fees, sales of goods,
: A final checkpoint used during consolidation to ensure that these internal balances are removed so they do not artificially inflate the group's total assets or liabilities. Implementing the Reconciliation Workflow
The heart of the template. This tab automatically compares the two entity ledgers and highlights variances.