| | A | B | C | | --- | --- | --- | --- | | 1 | | 31-Dec-2025 | | | 2 | Company A | ABC Corp | | | 3 | Company B | XYZ Ltd | | | 4 | Currency | USD | | | 5 | Reconciled By | [Your Name] | |
Look for any non-zero amounts in the "Variance" column.
Once the root cause is found, update the general ledger.
Who is responsible for fixing the entry in the ERP? How to Perform Reconciliation Using Your Template intercompany reconciliation template
Intercompany reconciliation is essential for accurate financial reporting, as it ensures that financial transactions between different entities within a company are properly matched and eliminated. This process helps to prevent errors, misstatements, and irregularities in financial reports, which can lead to incorrect business decisions. Intercompany reconciliation also enables companies to:
Using a standardized is the most effective way to eliminate these "out-of-balance" errors. This article explores why you need one, what it should include, and how to implement it. What is an Intercompany Reconciliation Template?
Check for missing invoices, data entry errors, or currency conversion mismatches. | | A | B | C |
Add columns for and Converted Amount if companies report in different currencies.
If your company does billions in revenue, don't spend five hours chasing a $2 discrepancy. Set a limit where variances are simply written off.
You can hide formula columns and print only: This article explores why you need one, what
For example, Entity A shipped goods on the 31st (recording a sale), but Entity B didn't receive them until the 2nd of the next month.
An intercompany reconciliation template is a structured document (typically in Excel or integrated into an ERP) used to compare the balances of related entities within a corporate group. Its primary goal is to ensure that all intercompany transactions—including loans, dividends, management fees, and inventory transfers—cancel each other out upon consolidation.
Intercompany reconciliation is the process of verifying and matching transactions between different entities under the same corporate umbrella . It ensures that what one subsidiary records as a receivable exactly matches what the other subsidiary records as a payable. The Essential Intercompany Reconciliation Template A standard template helps finance teams identify mismatches quickly during the month-end close. Use the following structure for your Excel or ERP-based sheets: 1. Header Information Reconciliation Period: (e.g., Q1 2026 or March 2026) Entity A (Provider): Name and Legal ID Entity B (Receiver): Name and Legal ID Functional Currency: (e.g., USD, EUR) 2. Transaction Data Table Transaction Date Ref # Description Entity A Balance (Dr/Cr) Entity B Balance (Dr/Cr) Difference 03/01/2026 INV-101 Management Fees $10,000 ($10,000) $0 03/15/2026 LOAN-05 Monthly Interest $2,500 ($2,450) $50 03/28/2026 SVC-99 IT Support $5,000 $0 $5,000 Blog Post: Mastering Intercompany Reconciliation Why Your Consolidated Statements Depend on Accurate Matching In a multi-entity organization, the "intercompany" category is often where the financial close slows down. If Subsidiary A sells goods to Subsidiary B, the balances must net to zero upon consolidation. If they don't, your group’s revenue and expenses will be misstated. Common Pitfalls to Watch For 12 sites Intercompany Reconciliation: Process, Examples, and Best ... Mar 4, 2026 —