Prerequisites
- A parent company with at least one subsidiary. DualEntry automatically creates a paired elimination company under the parent the moment you add the first subsidiary, so there’s nothing to set up for that part. If you don’t have a parent and subsidiary yet, see How to Configure Multi-Entity and Consolidation.
- Permission to create intercompany journal entries. Admin and Accountant have this by default; Controller can view and edit records but not create them.
- Permission to view financial reports. Admin, Controller, and Accountant have this by default.
Step 1: Create a practice intercompany transaction
We’ll start by creating a small intercompany transaction ourselves, so the rest of this tutorial has a known, reproducible entry to trace through the full elimination lifecycle. This tutorial assumes you’re working in a sandbox or test company. We’ll model a $100 management fee the subsidiary owes the parent. Each company’s lines have to balance on their own, so every company block needs at least two lines: one for the transaction itself, and one on IC Accounts Receivable or IC Accounts Payable to carry the intercompany side.- Navigate to Accounting → Transactions → Intercompany Journal Entries, and create a new one.
- Set the date to fall within the period you’ll use for the rest of this tutorial.
- In the Companies section, add a company block for the parent. Give it two lines: a credit of $100 to any revenue account, and a debit of $100 to IC Accounts Receivable, choosing the subsidiary’s auto-created intercompany customer. Leave Elimination switched on for both lines, it’s on by default for these account types.
- Add a second company block for the subsidiary, as the mirror image of the parent’s: a debit of $100 to any expense account, and a credit of $100 to IC Accounts Payable, choosing the parent’s auto-created intercompany vendor. Leave Elimination on here too.
- Save and post the entry.
Step 2: Run the report for one subsidiary
- Navigate to Reports → Report Center, then choose General Ledger.
- In the company filter, select only the subsidiary from Step 1. Leave the parent and the elimination company unselected.
- Set the date range to cover the period the transaction posted in.
Step 3: Widen the report to the whole group
- Open the company filter again. This time, select the parent, the subsidiary from Step 1, every other subsidiary under it, and the elimination company, all at once.
Step 4: Take the elimination company back out
- Open the company filter once more and deselect only the elimination company, keeping the parent and every subsidiary selected.
Step 5: See the elimination directly, account by account
Knowing that the balance changed is useful; seeing it cancel out line by line is better.- With the parent, every subsidiary, and the elimination company all selected, open the Pivot button in the report toolbar.
- Add Company as a dimension, place it below Account, then choose Apply.
- Open the IC Accounts Payable row.
What you built
You created a small intercompany transaction, then ran the same report three ways (one subsidiary, the whole group with the elimination company, and the whole group without it) and watched the IC Accounts Payable balance it created move from $100, to zero, and back again, depending only on whether the elimination company was part of your selection. Then you used Pivot to see the two offsetting lines side by side instead of inferring the effect from a total.Next steps
- Beyond a manual intercompany journal entry, you can also generate intercompany activity from an invoice or bill with a cross-company line, or from a customer invoice generated through Billable Expenses.
- To configure the entity hierarchy and intercompany rules behind this tutorial, see How to Configure Multi-Entity and Consolidation.
- To run this comparison on the income statement, balance sheet, or trial balance instead of the General Ledger, see Standard Financial Statements Reference.
- For the full set of Pivot and grouping options, see the custom report builder.
- If your entities report in different currencies, see multi-currency reporting before comparing totals across companies.