Intercompany Reconciliation Workpaper Template

Use this practical workpaper to match due-to, due-from, intercompany revenue, cost, loan, and recharge entries before consolidation. Enter or paste transactions in blue cells. The workbook calculates entity-pair differences, flags matched, review, and unresolved items, and summarizes open exceptions.

Sample rows show timing, FX, and missing-counterparty scenarios. Set a tolerance, attach supporting evidence outside the workbook where required, and resolve each exception before posting eliminations.