Intercompany Eliminations in Intuit Enterprise Suite: The Accepted Fix
Consolidated statements in Intuit Enterprise Suite can double-count intercompany balances; here is the accepted setup that fixes it.
Intuit Enterprise Suite users who run more than one company on a single subscription have been hitting the same consolidation snag. Combined statements keep both sides of internal trade on the books, and totals come out overstated. We reviewed the accepted community answer, which traces the problem to redundant intercompany accounts and resolves it through designated elimination accounts, flagged journal entries, and scheduled templates.
The symptom behind inflated consolidated totals
When two companies in a group trade with each other, the revenue one records is an expense at the other. Consolidation is supposed to cancel those mirror-image amounts out. The reported pattern is that duplicate intercompany accounts let the same activity post twice, so combined revenue, receivables, and equity all read high. The fix begins with housekeeping: remove redundant intercompany accounts so nothing can be counted on both sides of the group.
Which accounts get eliminated during consolidation?
The accepted answer names the account families that normally drop out at consolidation. Intercompany revenue and expense accounts go first. Intercompany receivables and payables follow, since one entity’s receivable is another entity’s payable. Intercompany investments and equity accounts round out the list, because a parent’s stake in a subsidiary should not appear as an outside asset in combined statements.
Marking elimination accounts in each company
Designation happens from the parent company. Sign in there, open the Multi-entity menu, choose Overview, and select Intercompany elimination accounts. For each company in the group, pick the accounts that exist only for dealings between the companies, then confirm. From that point the suite knows which accounts to strip out when it builds combined reports.
Recording a journal entry that spans two companies
The eliminations themselves are journal entries with a flag turned on. Start a new journal entry from the Create menu and switch on Intercompany transaction. A Company column appears on the form. On the first line, choose the company, pick its account, and enter the debit or credit. Each amount lands in the company and account you selected, not in a shared pot. Add further lines for that company as needed. On a later line, choose the second company, the one the funds move to or from, and enter its account and amount. Saving records the entry in every company named on the form, so both sets of books stay in step.
Can recurring eliminations run on a schedule?
Routine eliminations do not have to be re-keyed each period. Complete a journal entry as usual, then choose Save as template. Give the template a name, confirm its details, and set a schedule. New instances then post automatically at the intervals you chose. Groups that clear intercompany balances on a fixed cadence can let the template carry the routine entries.
Consolidated reports built into the suite
Once eliminations are in place, the Consolidated reports section offers combined views. The list covers profit and loss, balance sheet, cash flow statement, receivables aging summary, and payables aging summary. These reports lean on the elimination setup described above, which is why the designation step matters. Skip it, and the combined views keep showing both sides of internal trade.
Pushing multi-company data into a spreadsheet
Heavier analysis moves to Excel or Google Sheets through Spreadsheet Sync. Set that up once if you have not already. In the Spreadsheet Sync panel, choose Build multi-company reports, select the group, then pick a report: balance sheet or profit and loss across multiple periods, or trial balances. Filters narrow the data pulled from the source, and the run buttons send the result straight to your spreadsheet. From there, the spreadsheet’s own charting tools can build custom visuals on top of the figures.
The limit worth knowing before you adjust anything
Spreadsheet Sync is a one-way street, and the accepted answer is blunt about it. If you change amounts in the Eliminations column or the Consolidated statement column of a downloaded report, those edits live only in the spreadsheet. Saving the file pushes nothing back into Intuit Enterprise Suite. Treat the spreadsheet as a scratch pad for review, and record any elimination that belongs in the books as a proper intercompany journal entry. That division of labor, spreadsheet for analysis and journal entry for the record, is the discipline the accepted answer settles on. It is also what keeps consolidated totals clean month after month.