Free tool
Intercompany elimination worksheet. Entries in seconds.
List the loans, fees, sales, and dividends between your entities. Get the elimination entry for each, a check that both sides agree, and what drops out of the consolidated statements.
Short answer
An intercompany elimination entry removes a transaction between two entities in the same group from the consolidated financial statements. A loan from the parent to a subsidiary, for example, is eliminated by debiting the intercompany payable and crediting the intercompany receivable, so the group does not report money it owes itself. The entry is made only at the consolidated level, and each entity's own books stay as recorded.
Intercompany elimination entries: example
Holdings lent OpCo A $10,000, and OpCo A charged OpCo B a $2,500 management fee. The worksheet produces these entries:
| Account | Entity | Debit | Credit |
|---|---|---|---|
| Intercompany payable | OpCo A | $10,000 | |
| Intercompany receivable | Holdings | $10,000 | |
| Management fee revenue | OpCo A | $2,500 | |
| Management fee expense | OpCo B | $2,500 |
Consolidated receivables and payables each drop by $10,000, and consolidated revenue and expenses each drop by $2,500. Nothing changes on any entity's own books.
How to use this worksheet
- Add one row per intercompany item, naming both entities, the kind (loan or balance due, management fee, sale, or dividend), and the amount.
- Enter what the other entity's books show for the same item, so the worksheet can flag any pair that disagrees.
- Copy the entries into your consolidation workpaper, or copy the share link to send the set to a colleague.
Intercompany items
2 items- Item 1
Holdings lent to (or is owed by) OpCo A. Both sides agree.
- Item 2
OpCo A charged OpCo B a management fee. Both sides agree.
Both sides agree
2 of 2 items agree
Elimination entries, consolidated level only
| Item | Account | Entity | Debit | Credit |
|---|---|---|---|---|
| 1 | Dr Intercompany payable | OpCo A | $25,000 | |
| Cr Intercompany receivable | Holdings | $25,000 | ||
| 2 | Dr Management fee revenue | OpCo A | $4,000 | |
| Cr Management fee expense | OpCo B | $4,000 |
These entries belong in the consolidation workpapers only. Each entity keeps its own books exactly as recorded. Unrealized profit in inventory, investment-in-subsidiary eliminations, and ownership-percentage (non-controlling interest) effects are out of scope for this worksheet.
Removed from the consolidated statements
- Assets (receivables)
- $25,000
- Liabilities (payables)
- $25,000
- Revenue and income
- $4,000
- Expenses
- $4,000
- Equity (dividends declared)
- $0
Sources & citations
The requirement to eliminate intercompany balances and transactions in consolidated financial statements comes from US GAAP, ASC 810 (Consolidation).
Keep reading
- → Intercompany elimination entries, with worked examples
- → How to consolidate financial statements across subsidiaries
- → How to choose intercompany accounting software
- → Accounting for holding companies
- → Multi-entity savings calculator, to compare your cost against QuickBooks, Xero, and FreshBooks.
Ready to simplify your multi-entity accounting?
Start your 14-day free trial and manage every entity in one ledger.
14 days free. Card on file, nothing charged until day 14.