- Before
- Owns the intercompany position across 62 entities and signs it before consolidation locks, and will not lock on a plug that cannot be supported.
- Now
- Starts the day with a briefing that says what is out, why, and what needs a decision; decides only the pairs the agreements cannot settle.
Intercompany reconciliation in the last two days before a quarter-end lock
The company closes the quarter across 62 entities. It is working day 10 of 11, and consolidation locks the next day at 12:00. Here is how the group controller and two entity controllers work with the agents, screen by screen, in the working solution.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 0107:00
A morning briefing in place of a spreadsheet
Group controllerThe group controller's home is a conversation with the agents. The close coordinator reports the night: 9,847 intercompany lines read from 18 ledgers and 9,611 matched; 354 pairs agree to the cent and 37 sit inside the €5,000 tolerance. 21 pairs are out: 16 with a true-up ready, 2 waiting on an answer, 3 that need a person. Below it, the break investigator puts the largest first, and each figure carries a numbered citation.
“True-ups are due today at 17:00; consolidation locks tomorrow at 12:00.”
- 02Who is out with whom
The pair map shows where the money is
Group controllerEach cell is one pair of group entities, net of everything both ledgers hold for the quarter: a tick when it agrees, “<5k” inside tolerance, or the difference with a dot sized by amount and colored by status. Three cells hold 63% of the money that is out. The group controller picks the pair of the US entity and the German entity (€212,025.89, FX rate, awaiting approval), and the agents' brief opens beside the map.
- 03Open the pair
Two ledgers side by side, the break dashed
Break investigatorThe US entity holds €14,576,181.92 against the German entity, which holds €14,364,156.03 against it. Five of six lines match to the cent (IT licenses, a travel recharge, a netting settlement), joined across the two ledgers. The sixth is the quarter's management fee: the US entity invoiced it on the quarter's last business day at 1.1640, €14,314,776.63; the German entity accrued it a week later at 1.1815, €14,102,750.74.
Seven sources, one click each: the German journal, the intercompany agreement and its fee schedule, both rate tables, the US invoice and the group policy.
- 0404:47, overnight
How it found the cause, step by step
Break investigatorThe investigator shows its plan and lets anyone replay it: collect both ledgers, match line by line, look for the cause (the same US-dollar amount on both sides, so not a price or a missing booking), read the agreement, check the rate tables, draft the true-up in the German entity, the side that used the wrong rate, and ask the checker. Confidence 0.97.
Its limit: below 0.80 confidence it does not guess. It hands the pair to a named person.
- 05One citation
The clause that decides which side is wrong
Agreement readerEach statement opens its source with the passage the agent relied on marked. The agreement's §5, Currency and rates: fees are invoiced in euros, and the US-dollar fee converts at the group closing rate for the last business day of the service period. That was the quarter's last business day, 1.1640 in Group Treasury's monthly rate table. The German entity used the daily rate of the day it accrued.
“The US-dollar fee is converted at the group closing rate published by Group Treasury for the last business day of the service period. No other rate applies.”
- 0609:21
The adjusting controller asks the agents back, in plain words
German entity controllerThe true-up lands in the German entity's books, so its controller asks the question each entity controller asks: why my side? The investigator answers from the agreement and the invoice, with citations. Above it, the elimination checker has already re-performed the pair from its own copy of both ledgers, with the true-up applied: the pair nets to €0.00. The controller could also tell the agents to book it as group reporting only; they would argue against it and offer a version 2 that restarts the approvals.
“Adjusting the US entity instead would break §5: its invoice already uses the rate the agreement sets.”
- 07The approval
Approval with a reason code and the evidence read
German entity controllerThe proposal is a real entry: in the German entity, Dr Intercompany management fees, Cr Intercompany payables to the US entity, €212,025.89, in the quarter's last period, reason code “FX rate set by the agreement”, version 1. The controller picks the reason code, may add a note for the auditor, and confirms having read the 7 sources the agents cited before approving.
“Your approval is signed with your name and time. The entry is parked once the other approvers sign.”
- 08Both sides signed
The US side signs too, and the entry is parked
US entity controllerThe US entity's controller sees the same proof and approves, and the US books stay as booked. Under €250,000 the group controller is kept informed rather than asked, as §8 of the group policy sets. Only now does the true-up drafter park the entry in the German entity for posting. The pair moves to “Approved, posting”, and both approvals are on the audit trail with their reason code.
“Approved by everyone. Parked in the German entity for posting.”
- 09The three it will not guess
Where the agreement is silent, a person decides
Group controller and transfer pricing managerThe UK and US entities are out by €34,879.73: the US entity recharged 17.1% of the quarter's shared IT cost, the UK entity booked 16.4%, and neither version of Schedule D is signed by both parties. The investigator stops at 0.52 confidence and, under §11, hands it to the group controller with the transfer pricing manager. The group controller records the decision and why; the drafter turns it into a new version for both controllers.
“3 I cannot explain. I will not guess; tell me what you decide and I will draft it.”
- 10Before the lock
407 of 412 pairs net to €0.00, and nothing is plugged
Elimination checkerAn independent agent copies all 18 ledgers, applies the 16 true-ups as drafted and eliminates all 412 pairs. Receivables and payables fall from €1,158,965.02 apart to €83,379.73, all of it in open pairs. Five pairs, €99,364.73, are carried open with an owner and a note. Unsupported top-side adjustments: €0.00. The check is the consolidation accountant's to sign before consolidation locks.
“I do not reuse another agent’s numbers.”