How intercompany eliminations work in Intuit Enterprise Suite

Go to Advanced accounting and select Multi-entity.

Select Select intercompany accounts.

For each company, choose the accounts that are used solely for intercompany transactions or balances. If you're unsure which accounts should be eliminated, consult with your accountant for guidance.

Once you've selected the appropriate accounts, select Save. QuickBooks will automatically eliminate the full balances of these accounts from your consolidated reports.

If you haven’t already, set up Spreadsheet Sync.

In the Spreadsheet Sync panel, select Build multi-company reports.

Select the group you want to run the reports for.

Select the report you want to view:

Select Filters to download the data you want from the source.
Note: The filters may vary depending on the type of report.

Select  Run Report to get the data onto your spreadsheet.

Use the spreadsheet's built-in features to create custom charts and graphs with your QuickBooks data.

Adjust the amounts in both the Eliminations and the Consolidated statement columns.

Save your spreadsheet.  These adjustments won’t be posted to QuickBooks.