MYOB Groups · Track 2 · Tutorial 2 of 3
Eliminate intercompany invoices and bills
When your MYOB 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, where the companies keep different currencies, treat the difference as FX.
1List what your MYOB companies charge each other
In Your Group, two intercompany items go through MYOB in October 2026:
| Monthly management fee | Wattle Pty Ltd invoices Kauri Ltd AUD 15,000 (invoice 00001031) to 4-2500 Management Fee Income. Kauri Ltd enters the bill in AUD, and MYOB records it in NZD to 6-2500 Management Fees. Only intercompany amounts go through these accounts — a rule handles it (steps 2–4). |
|---|---|
| Materials sold to Wattle Fitouts | Wattle Pty Ltd invoices Wattle Fitouts Pty Ltd AUD 30,000 (invoice 00001045) to 4-1000 Sales, the same account as its outside customers. A rule can’t pick out the Wattle Fitouts part of 4-1000, so you eliminate the documents (step 5). |
In MYOB, set each sister company up as a customer or supplier contact under its real name — Kauri Ltd, not Kauri Auckland. BrizoConsol finds the documents by those names.
2Add a rule for the fee
- Select Your Group, and open Intercompany → Elimination Rules.
- Click Add an Auto Elimination Rule.
- Enter the Description Wattle management fee to Kauri, and choose the Intercompany Type Management Charges.
- Choose Method 2: Use the amount in both Organisations.
- Under Leg Scope, choose Wattle Pty Ltd and 4-2500 as the From side, and Kauri Ltd and 6-2500 as the To side.
Why Method 2: Wattle Pty Ltd’s AUD 15,000 and Kauri Ltd’s NZD expense almost never translate to the same SGD amount, because MYOB 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
- Under Only eliminate when an invoice or bill names, tick Kauri Ltd under Customers.
- Set Default residual treatment to FX, and choose the Treatment account for exchange differences.
- Click Confirm.
| Where the names come from | The 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 counts | An invoice or bill of either company, dated in the month, naming Kauri Ltd, with an amount on it. A voided document doesn’t count. |
| How names are compared | Ignoring capitals, punctuation and endings such as Ltd or Pty Ltd. So Wattle Ltd and Wattle Pty Ltd would count as the same name: give sister companies names that differ by more than their ending, as Wattle Pty Ltd and Wattle Fitouts Pty 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 3 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 Wattle Pty Ltd’s invoice has been entered in MYOB. The rule doesn’t post. It holds the entry in Intercompany → Elimination Review, with the reason:
| The invoice is just late | Enter it in MYOB and reload November for Wattle Pty Ltd. The rule then finds it and posts on its own. |
|---|---|
| The fee was booked without an invoice | Click Review, check the entry, and click Confirm & Replace to post it anyway. |
| The amounts shouldn’t be eliminated | Click Reject. |
5Eliminate the sale to Wattle Fitouts from its documents
Wattle Pty Ltd’s 4-1000 Sales also holds sales to outside customers, so eliminate the October sale from the MYOB invoice and bill themselves:
- Open Intercompany → Sales / Purchases / Services, keep the scenario on Actual and Oct-2026, and click Add a new Elimination Entry.
- Click Documents at the top of the dialog.
- On the From side, choose Wattle Pty Ltd and 4-1000 Sales; on the To side, Wattle Fitouts Pty Ltd and its purchases account.
- Tick invoice 00001045 and Wattle Fitouts Pty Ltd’s bill for it, or click the match button to pair them.
- Check the lines, and click Confirm.
Both companies keep their books in AUD, so the two sides translate at the same rate and normally leave no 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 Wattle Fitouts against its purchase. On Month End Status, the Eliminations card shows Posted.
6If something goes wrong
| The name lists are empty | No invoices or bills are loaded for those companies. Reload a month with Invoices and Bills ticked. |
|---|---|
| The sister company isn’t in the name list | It has no invoice or bill in the loaded months, or is a contact under another name in MYOB. Fix the name in MYOB and reload. |
| Every month lands in Elimination Review | The invoices name the company differently from the name you ticked, or are entered after the month is loaded. Check the contact name in MYOB, and reload the month once the invoice is in. |
| The rule posts in a month with no fee invoice | Another document that month names Kauri Ltd — any invoice or bill between the two counts. |
| A large amount lands in FX | It isn’t an exchange difference: one side is missing or wrong, such as a bill entered for the wrong amount. Fix it in MYOB and reload. |
Want more detail? See the documentation