# Intercompany reconciliation template

> This free Excel template compares what each group company records against its sister companies. It lists every pair by counterparty and transaction currency, shows the receivable, the payable and the difference, and records the reason, owner and due date for anything that does not agree. It has one sheet for each month and a filled example.

Source: https://finconsol.com/blog/resources/intercompany-reconciliation-template/ (updated 28 October 2026)

| Pair | Currency | Receivable | Payable | Difference | Reason | Owner | Due |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Zenvara and Palmridge | AED | 77,377 | 75,164 | 2,213 | Timing and rate | Palmridge finance | 7 Oct |
| Zenvara and Fernhollow | USD | 1,240,000 | 1,240,000 | 0 | Agrees |  |  |
| Fernhollow and Kestrelwick | USD | 317,500 | 317,500 | 0 | Agrees |  |  |

*September 2026 sheet, as it opens | GBP*

## How to use it

1. **Copy the month's sheet** and put the month-end date at the top. Use the same cut-off for every company.
2. **Enter each company's receivable and payable** by [counterparty](/blog/glossary/counterparty/), in the group currency. Show the currency of the transaction beside each pair.
3. **Read the difference column.** For every row that is not zero, choose a reason, name an owner and set a due date.
4. **Eliminate the agreed amount** in your consolidation, then carry the open rows into next month's sheet and review them first.

## Who is it for?

Finance controllers and group accountants who reconcile intercompany balances in Excel, for groups of about 2 to 50 companies, on any accounting system. It also suits accounting firms that close a group for a client. Once a group has more than a handful of pairs, a spreadsheet gets slow to keep right, and that is when [Finconsol compares the pairs for you](https://finconsol.com/intercompany-eliminations/). The method behind the sheet is in [why intercompany balances never agree](/blog/why-intercompany-balances-never-agree/).

## Questions

**What is an intercompany reconciliation?**

It is the monthly comparison of what one group company says it is owed, or owes, with what its counterparty has booked. Both sides must agree before the balance is eliminated in the group accounts. Differences usually come from timing, exchange rates, coding or a dispute.

**How often should intercompany balances be reconciled?**

Every month, before the group accounts are built, using the same cut-off date for every company. Leaving it to the quarter or the year-end lets small differences pile up and makes each one harder to trace.

**Which currency should I compare in?**

Compare each pair in the currency of the transaction to see whether both sides booked the same thing, then in the group currency to see what a rate difference is worth. The example rows are in GBP, the group presentation currency, with the transaction currency beside each pair.