Intercompany balances that agree.
Add your group companies once. Each month, enter what each company shows for the others, explain any difference, and get the elimination journal.
For group finance teams and accounting firms
$9 a month · Cancel any time
Intercompany elimination example
Group accounts show only what the group owes, and is owed by, outsiders. Balances between group companies cancel out, but only once both companies agree. Here is a recharge between two companies, from difference to elimination.
| Example Ltd's booksDue from Example Inc | 18,000.00 Dr |
| Example Inc's booksDue to Example Ltd | 15,600.00 Cr |
| Difference | 2,400.00 |
Example Ltd sent recharge invoice IC-114 for 2,400.00 on 28 November. Example Inc hasn't booked it yet.
| Dr Recharge costsExample Inc's books | 2,400.00 |
| Cr Due to Example LtdExample Inc's books | 2,400.00 |
| Both books now | 18,000.00 |
| Dr Due to Example LtdExample Inc's books | 18,000.00 |
| Cr Due from Example IncExample Ltd's books | 18,000.00 |
Intercompany income and costs, such as the recharges themselves, are eliminated the same way.
Out of the spreadsheet
Most groups match intercompany in a workbook: an email to every company for its balances, a grid of who owes whom, and eliminations typed by hand the day before consolidation. The tracker keeps every pair, shows the differences as balances come in, and builds the journal.
SPREADSHEET
INTERCOMPANY TRACKER
A preparer and a reviewer for each pair of companies, and the ones still waiting for a side flagged.
Invoices not yet booked and cash in transit stay on the pair until they clear.
The journal comes from balances both sides agree, so debits equal credits.
What you get
- ✓Your group companiesAdd them once.
- ✓Every pair, side by sideWhat each company shows for the other.
- ✓Differences explainedItems carried forward until they clear.
- ✓Preparer and reviewerSign-off with a name and date.
- ✓The elimination journalReady to copy or export.
- ✓Export to ExcelEvery pair for the audit file.
How it works
- 1Add your companies
Enter your group companies and their intercompany accounts, then set who prepares and reviews each pair.
- 2Enter both sides
Paste each company's trial balance or type the balances in. Explain any difference with items.
- 3Agree and eliminate
The reviewer signs off and the elimination journal is ready for consolidation.
One price, the whole group
- Every group company
- Every pair of companies
- Reconciling items
- Items carried forward
- Notes and support links
- Preparer and reviewer
- Elimination journal
- Export to Excel
FAQ
Is the check free?
Yes. It matches one pair of companies: enter what each side shows and any items not yet booked, and it gives the difference and the elimination journal. The tracker keeps every pair, every month, with sign-off.
What gets reconciled?
Checking that what one group company says another owes it matches what the other company says it owes. The balances must agree before they are eliminated in the group accounts.
Where do the balances come from?
Paste each company's trial balance, or type the intercompany balances in. Each pair shows both sides together.
Different currencies?
Enter every balance in the group currency. If two books differ only because of exchange rates, add the difference as an item.
What happens if I cancel?
Your reconciliations stay saved. Subscribe again and they come straight back.
