Foundations · Track 2 · Tutorial 2 of 7

Clear intercompany balances

Charges and balances between your own companies are not group revenue, expenses or assets. Set up rules once to remove them every month, then check nothing is left.

You will needThe month loaded, from the previous tutorial, with every company mapped to the Common COA. Administrator or Journals & Eliminations Admin access.
By the endRules that clear your recurring intercompany items every month, one-off items eliminated by hand, and a group with no intercompany balances left.

1Understand why intercompany items must go

When your companies trade with each other, each one books its side correctly. Added together, though, both sides land in the group figures.

A management fee between two group companies: the elimination removes it from both income and expense, leaving zero for the group
The elimination cancels both sides, so the group shows only what it did with the outside world.

The same applies to the balance sheet: if Company B has not paid the fee yet, Company A shows a receivable and Company B a payable — the group owes the money to itself. Both must go.

2List your intercompany items

Before setting anything up, write down each item your companies book between themselves, and the account each side uses. In the running example:

ItemFrom sideTo side
Monthly management feeCompany A — 4900 Management fee incomeCompany B — 6420 Management fees
Unpaid feesCompany A — 1250 Due from Company BCompany B — 2150 Due to Company A
A loan made in OctoberCompany A — 1300 Loan to Company CCompany C — 2400 Loan from Company A
Goods sold in OctoberCompany A — 4000 Sales, invoice INV-1043Company B — 5000 Purchases, bill BILL-778

The first two recur on the same accounts every month, so a rule handles them (steps 3–6). The loan and the sale are entered by hand (steps 7–9). Rules are easiest when intercompany accounts are kept apart from outside customers and suppliers — see Intercompany Account Naming Conventions.

3Let BrizoElim suggest rules

  1. Select your group, and open Intercompany → Elimination Rules.
  2. Click Suggest Rules, then Get Suggestions.
  3. Read down the suggested rules. Untick any that pair the wrong accounts.
  4. Click Confirm & Add.

BrizoElim reads your companies’ charts of accounts and suggests pairs that look intercompany, leaving out pairs that already have a rule. Check each suggestion against your list from step 2 — it only sees account names, not how your companies actually use them.

Suggest Rules is not included in the Standard edition. Add the rules by hand instead, as in the next step.

4Add a rule by hand

  1. Click Add an Auto Elimination Rule.
  2. Enter a Description and choose the Intercompany Type — for the fee, Management Charges.
  3. Choose the Method (see step 5).
  4. Under Leg Scope, choose Company A and its income account as the From side, and Company B and its expense account as the To side.
  5. Leave Tolerance at 0.5% and click Confirm.
Adding a new elimination rule: the method, the From and To company and account, and the tolerance, then Confirm
The method (1), the two sides (2) and the tolerance (3).

Saving a rule recalculates the group. From then on the rule runs on every consolidation, for every month — next month, the fee is cleared without you doing anything.

5Choose the right method

The method decides what happens when the two sides do not agree exactly.

MethodWhat it doesUse it for
1 · From Organisation onlyClears both sides at the From side’s amount. If the other side differs by more than the tolerance, the month is held back for review.The management fee — Company A’s invoice is the reliable figure.
2 · Both OrganisationsClears each side at its own amount, and sends any difference to the treatment you choose: FX, Timing or Write off.The unpaid fees. Company A holds the receivable in SGD and Company B the payable in AUD, so they differ after translation — choose FX.
3 · Lowest amountClears the amount both sides agree on, and leaves any excess visible on the larger side.Items where a difference should stay in the figures until someone investigates.
4 · Review and approvePrepares the entry but never posts it until someone approves it.Items that need sign-off every month.

6Deal with anything held back

When a rule cannot post on its own — a Method 4 proposal, a Method 1 difference beyond the tolerance, or a Timing difference set to review — Elimination Review appears in the Intercompany menu.

  1. Open Intercompany → Elimination Review, and choose the month.
  2. On each row, read the Difference and Warning, then click Review.
  3. Adjust the entry if needed, and click Approve & Post — or Confirm & Replace for a Method 2 difference.
  4. If the rule itself is wrong, click Reject instead and correct the rule.

A difference usually means one company has booked something the other has not — for example Company B has not recorded October’s fee yet. Fix it in that company’s books, reload the month, and the rule posts on its own.

7Know when to enter an elimination by hand

A rule reads whole accounts, month after month. Enter an elimination yourself when that does not fit:

UseWhenIn the example
A ruleThe same accounts carry only intercompany amounts every month.The management fee and the unpaid fees.
A GL entryA one-off item, or one the rules do not cover. You name the companies, accounts and amounts.The October loan from Company A to Company C.
A document entryYou want to eliminate specific invoices and bills — for example when an account also holds sales to outside customers. The entry keeps the documents it was built from.Invoice INV-1043 from Company A and Company B’s bill for it.

Both kinds of manual entry are made from the same place:

  1. Open Intercompany and choose the type — Intercompany Loans for the loan, Sales / Purchases / Services for the sale.
  2. Keep the scenario on Actual, choose Oct-2026, and click Add Elimination Entry.

This tutorial records entries at subsidiary level, as each group does unless it changes it. The other option, Input at Group level, records entries on group accounts instead; it is set under Manual elimination configuration on the group’s Organisation Details page.

8Post a GL entry

For the loan, keep GL entry selected at the top of the dialog.

  1. Enter an Elimination ID, the Date and a Description.
  2. Under Debit Lines, choose Company C, its account 2400 Loan from Company A, the currency and the amount. Enter the Exch. Rate that translates it into the group currency — it starts at 1.0000.
  3. Under Credit Lines, do the same for Company A and 1300 Loan to Company C.
  4. If the two sides balance, click Confirm. If they do not, click Next.
A GL elimination entry: each line names the company, its account, currency and rate; a difference between the sides is allocated to FX difference, Timing difference or Write off before Confirm
GL entry (1), a line for each company’s side (2), and the difference allocated (3).

Each line is a company’s own account in its own currency, so the two sides often differ once translated into the group currency — here Company C’s GBP balance translates to 400 more than Company A’s SGD one. Next opens Allocate Difference Treatment, where you say what the difference is:

FX differenceExchange-rate movement, as in the example. Posted to the account you choose.
Timing differenceOne company has recorded something the other has not yet.
Write offA small difference nobody will chase.

Choose the treatment, the company and account it posts to, the amount and a justification, until Remaining is 0.00. Then click Confirm.

9Post a document entry

For the October sale, click Documents at the top of the dialog instead.

  1. On the From side, choose Company A and the account the sale is in. Its invoices for the month are listed.
  2. On the To side, choose Company B and its purchases account. Its bills are listed.
  3. Tick INV-1043 and BILL-778 — or click the match button between the lists to have BrizoConsol pair the documents for you.
  4. Check the lines under Review the entry, and click Confirm.
A document elimination entry: choose the From company, its account and invoices, the To company, its account and bills, or let BrizoConsol match them, then review the lines and Confirm
Documents (1), each side’s company, account and documents (2), automatic matching (3), and the entry it builds (4).

BrizoConsol builds the lines from the documents you chose, at the group’s rates. A difference between the two sides goes through the same treatment step as a GL entry. Because the entry remembers its documents, anyone drilling into the elimination later can see exactly which invoice and bill it removed.

TypesTrade receivables / payables, Management Charges, Inventory Transfers and Sales / Purchases / Services.
ScenarioActual only.
PlanNot included in the Standard edition.
Which documentsPosted documents dated in the month. For Trade receivables / payables, documents from the 90 days up to the entry date, so older unpaid invoices can be picked.
DataBoth companies’ invoices and bills must be loaded — check on Month End Status.

10Import entries from a file

For many entries at once, click Import from file on the same page and use the downloadable template. One row is one line, rows sharing an Elimination ID form one entry, and the whole file is refused unless every entry is valid.

11Check nothing is left

  1. Open Reports → Profit & Loss for the group, and turn on Show Entities.
  2. On each intercompany line, the Eliminations column should cancel the companies’ amounts, leaving zero for the group.
  3. Do the same on the Balance Sheet for the intercompany receivable and payable.

Check

Every intercompany line is zero in the group column, and every row in Elimination Review for the month has been approved, confirmed or rejected. On Month End Status, the Eliminations card shows Posted.

12If something does not look right

What you seeWhat to do
Add an Auto Elimination Rule is disabledRules need a Common COA with your companies mapped to it — see Map every company to one group chart of accounts.
A rule exists but nothing is eliminated for the monthThe From account did not move that month, or one of its accounts is not mapped. Check both in Account Mapping.
The rule says both sides post to the same group accountThe two accounts are mapped to the same group account, so there is nothing to eliminate between them. Map them to separate group accounts.
An intercompany line is still not zeroPart of the balance is on an account no rule covers. Drill into the figure to find it, then add it to a rule or post a one-off entry.
The same rule lands in Elimination Review every monthIts accounts, method or tolerance need adjusting. Edit it on Elimination Rules.
Documents is not offered in the entry dialogThe type does not support documents, the scenario is not Actual, or your plan is Standard. Use a GL entry.
No documents are listedThe month’s invoices or bills are not loaded for that company, or the account chosen is not mapped. Check Month End Status and Account Mapping.
An entry cannot be editedIts month is locked. Ask an administrator to unlock it on Month End Status.