QuickBooks Online Groups · Track 2 · Tutorial 2 of 3

Eliminate intercompany invoices and bills

When your QuickBooks companies charge each other, one raises an invoice and the other records the bill, each naming the other as a customer or supplier. BrizoConsol can use those documents to eliminate the charge — and, because your companies keep different currencies, treat the difference as FX.

You will needOctober reloaded with invoices and bills, as in Close the books in QuickBooks, then reload. Each company mapped to the group chart.
By the endMaple Inc’s management fee to Maple UK Ltd eliminated every month by a rule that only posts when the invoice exists, with the currency difference posted as FX, and the October sale to Maple Pacific Pte Ltd eliminated from its invoice and bill.

1List what your QuickBooks companies charge each other

In Your Group, two intercompany items go through QuickBooks in October 2026:

Monthly management feeMaple Inc invoices Maple UK Ltd USD 20,000 (invoice 1031) to 4500 Management Fee Income. Maple UK Ltd enters the bill in USD, and QuickBooks records it in GBP to 6500 Management Fees. Only intercompany amounts go through these accounts — a rule handles it (steps 2–4).
Goods sold to SingaporeMaple Inc invoices Maple Pacific Pte Ltd USD 30,000 (invoice 1045) to 4000 Sales, the same account as its outside customers. A rule can’t pick out the Singapore part of 4000, so you eliminate the documents (step 5).
Maple Inc invoices Maple UK Ltd for the management fee and Maple UK Ltd records the bill in QuickBooks; a Method 2 rule from 4500 to 6500 eliminates both sides when an invoice or bill names Maple UK Ltd
The fee as it sits in each company’s QuickBooks, and the rule that clears it.

In QuickBooks, set each sister company up as a customer or supplier under its real name — Maple UK Ltd, not Maple London. BrizoConsol finds the documents by those names.

2Add a rule for the fee

  1. Select Your Group, and open Intercompany → Elimination Rules.
  2. Click Add an Auto Elimination Rule.
  3. Enter the Description Inc management fee to UK, and choose the Intercompany Type Management Charges.
  4. Choose Method 2: Use the amount in both Organisations.
  5. Under Leg Scope, choose Maple Inc and 4500 as the From side, and Maple UK Ltd and 6500 as the To side.

Why Method 2: Maple Inc’s USD 20,000 and Maple UK Ltd’s GBP expense almost never translate to the same SGD amount, because QuickBooks converted the bill at its own rate and the group translates each company’s figures at the month’s average rate. Method 2 clears each side at its own amount and posts the small difference to the treatment you choose. Method 1 would hold the month for review whenever the difference is over the tolerance.

3Only eliminate when the invoice exists, and treat the rest as FX

  1. Under Only eliminate when an invoice or bill names, tick Maple UK Ltd under Customers.
  2. Set Default residual treatment to FX, and choose the Treatment account for exchange differences.
  3. Click Confirm.
Adding a new elimination rule: Method 2 from Maple Inc 4500 Management Fee Income to Maple UK Ltd 6500 Management Fees, eliminating only when an invoice or bill names Maple UK Ltd, with differences treated as FX
The two sides (1), the name the month’s invoice must carry (2), and where the difference goes (3).
Where the names come fromThe customers and suppliers on the invoices and bills of the two companies in the rule. Choose the companies first; the lists fill from their documents.
What countsAn invoice or bill of either company, dated in the month, naming Maple UK Ltd, with an amount on it. A voided document doesn’t count.
How names are comparedIgnoring capitals, punctuation and endings such as Inc, Ltd or Pte Ltd. So Maple Ltd and Maple Pte Ltd would count as the same name: give sister companies names that differ by more than their ending, as Maple UK Ltd and Maple Pacific Pte Ltd do.

Saving the rule recalculates the group: October’s fee is eliminated, and the difference is posted to the FX account. The entry is listed in Elimination Review, where you can adjust the treatment.

The check needs the month’s invoices and bills in BrizoConsol. The nightly read brings in the last 6 months; for an older month, reload it with Invoices and Bills ticked.

4Deal with a month the invoice is missing

In November, the month is loaded before Maple Inc’s invoice has been entered in QuickBooks. The rule doesn’t post. It holds the entry in Intercompany → Elimination Review, with the reason:

Elimination Review: November’s management fee held back because no invoice or bill in November 2026 names Maple UK Ltd, with Review and Reject buttons
Why the entry was held (1), and what you can do with it (2).
The invoice is just lateEnter it in QuickBooks and reload November for Maple Inc. The rule then finds it and posts on its own.
The fee was booked without an invoiceClick Review, check the entry, and click Confirm & Replace to post it anyway.
The amounts shouldn’t be eliminatedClick Reject.

5Eliminate the sale to Singapore from its documents

Maple Inc’s 4000 Sales also holds sales to outside customers, so eliminate the October sale from the QuickBooks invoice and bill themselves:

  1. Open Intercompany → Sales / Purchases / Services, keep the scenario on Actual and Oct-2026, and click Add a new Elimination Entry.
  2. Click Documents at the top of the dialog.
  3. On the From side, choose Maple Inc and 4000 Sales; on the To side, Maple Pacific Pte Ltd and its purchases account.
  4. Tick invoice 1045 and Maple Pacific Pte Ltd’s bill for it, or click the match button to pair them.
  5. Check the lines, and click Confirm, allocating any difference to FX difference.

The full dialog is in Clear intercompany balances.

Document entries aren’t included in the Standard edition. There, post a GL entry for the amounts instead.

Check

On the group Profit & Loss for Oct-2026 with Show Entities on, the eliminations cancel the fee income against the fee expense, and the sale to Singapore against its purchase. On Month End Status, the Eliminations card shows Posted.

6If something goes wrong

The name lists are emptyNo invoices or bills are loaded for those companies. Reload a month with Invoices and Bills ticked.
The sister company isn’t in the name listIt has no invoice or bill in the loaded months, or is a customer or supplier under another name in QuickBooks. Fix the name in QuickBooks and reload.
Every month lands in Elimination ReviewThe invoices name the company differently from the name you ticked, or are entered after the month is loaded. Check the customer name in QuickBooks, and reload the month once the invoice is in.
The rule posts in a month with no fee invoiceAnother document that month names Maple UK Ltd — any invoice or bill between the two counts.
A large amount lands in FXIt isn’t an exchange difference: one side is missing or wrong, such as a bill entered for the wrong amount. Fix it in QuickBooks and reload.