How to Consolidate Multiple MYOB Companies: A Practical Guide for Multi-Entity Groups

If your group runs two or more MYOB companies, you already know that MYOB does not consolidate them for you. Each MYOB file is a standalone set of books. At month-end, the finance team exports trial balances from each entity, pastes them into a master spreadsheet, maps accounts across the inconsistent chart-of-accounts structures, posts intercompany elimination journals, and attempts to produce a group P&L and balance sheet that balances. For a two-entity group with no intercompany complexity, this is manageable. For a three-entity group with intercompany loans, management fees, and a foreign subsidiary, it rapidly becomes the most error-prone and time-consuming part of the close.

This guide walks through the practical steps to consolidate multiple MYOB companies correctly — and shows where a dedicated consolidation platform removes the manual work entirely.

What MYOB Can and Can’t Do for Multi-Entity Groups

MYOB AccountRight and MYOB Business are excellent single-entity accounting tools. They handle invoicing, payroll, bank reconciliation, and financial reporting well within a single company file. What they do not do is link company files together or produce cross-entity consolidated accounts.

MYOB does have a “linked companies” concept in some versions, but this is limited to sharing lists such as items or cards between files — it does not consolidate financial data. There is no built-in MYOB report that combines the P&L or balance sheet of multiple company files, eliminates intercompany transactions, or produces a statutory consolidated set of accounts.

For groups that need consolidated financials — whether for a bank, an investor, a parent company, or simply for management visibility — the process has to happen outside MYOB, either manually in a spreadsheet or through a consolidation platform that connects to the MYOB files directly.

The Five Steps to Consolidate Multiple MYOB Companies

Whether you are consolidating manually or using software, the underlying process follows the same five steps. Understanding what each step involves — and where each one can go wrong — is the foundation for getting your MYOB group consolidation right.

Step 1 — Export trial balances from each MYOB company

The starting point is a trial balance from each MYOB company file for the same reporting period. In MYOB AccountRight, this is the “Trial Balance” report under Accounts; in MYOB Business, it is available under Reports. Export each to CSV or Excel. Every entity must be closed for the same period before you begin — starting the consolidation while one entity still has transactions in flight is a common source of balancing errors that are difficult to trace.

Step 2 — Map each entity’s accounts to a common group chart of accounts

Each MYOB company file likely has its own account structure, developed independently over time. “Sales Revenue” in one entity may be coded 4-0000; in another it may be 40100 or simply called “Income”. Before you can add the numbers together, every account in every entity must be mapped to a common group chart of accounts — a master list of account categories that applies across the whole group.

This mapping is a one-time setup task, but it must be maintained as entities add or rename accounts. A missed account mapping means revenue or costs are excluded from the consolidated totals without any obvious error signal. The group chart of accounts is the single most important piece of infrastructure for a reliable MYOB consolidation.

Step 3 — Identify and eliminate intercompany transactions

Any transaction between two entities in the group must be eliminated before the consolidation is finalised. The most common intercompany transactions in MYOB groups are management fees (the holding company charges operating entities for shared services), intercompany loans and the interest on them, intercompany sales of goods or services, and dividends paid by subsidiaries to the parent.

Each elimination requires a journal entry that removes both sides of the transaction from the consolidated totals. For management fees: debit management fee income, credit management fee expense. For intercompany loans: debit intercompany payable, credit intercompany receivable. Any balance sheet intercompany balances that do not match — because one entity has recorded a payment that the other has not yet processed — must be identified and resolved before the consolidated balance sheet can balance.

Step 4 — Translate overseas entities (if applicable)

If any MYOB company operates in a foreign currency, its accounts must be translated into the group presentation currency before consolidation. P&L items translate at the average rate for the period; balance sheet items at the closing rate; equity at historical rates. The residual difference is the cumulative translation adjustment, which sits in equity. This step is covered in detail in the MYOB multi-currency consolidation guide.

Step 5 — Produce and review consolidated reports

Once the mapped, eliminated, and translated data is combined, the consolidated P&L and balance sheet can be produced. The balance sheet must balance — if it does not, the error is almost always in the intercompany eliminations (a mismatch between payable and receivable) or the currency translation (an incorrect rate applied to an equity item). The consolidated cash flow statement, if required, must be built separately as MYOB does not produce one from the consolidated data.

Where the Spreadsheet Approach Breaks Down

For a two-entity MYOB group with a small number of intercompany transactions, a well-built spreadsheet can work. The problems compound as the group grows.

The account mapping table grows with every new account added to any entity’s MYOB file — and if the mapping is not updated immediately, the next consolidation will silently exclude that account. Intercompany balances that do not match require manual investigation each period, and the matching is only as reliable as whoever last reconciled the intercompany accounts. If a management fee invoice is raised in one entity but not yet posted in the other, the elimination will not balance — and finding the discrepancy in a large spreadsheet takes time the close does not have.

The spreadsheet is also entirely dependent on the person who built it. When that person is unavailable, the institutional knowledge of which formula does what, and why row 47 has a hard-coded override, is not easy to transfer. For MYOB groups that have been consolidating manually for several years, the spreadsheet often carries accumulated workarounds that nobody fully understands.

The most reliable signal that a manual MYOB consolidation has outgrown the spreadsheet is when the finance team spends more time reconciling and error-checking than it does reviewing the actual numbers. If the close produces a balance sheet that only balances after several rounds of investigation, the process is the problem — not the people.

A Practical Example: Meridian Group

Meridian Group comprises three MYOB companies: Meridian Holdings Pty Ltd (the parent, which charges management fees), Meridian Operations Pty Ltd (the main trading entity), and Meridian Properties Pty Ltd (which holds the group’s commercial property and charges rent to Operations).

Before eliminations, the combined figures are:

Entity	Revenue (A$)	IC Income (A$)	Total Expenses (A$)	Net Profit (A$)
Meridian Holdings	—	240,000	180,000	60,000
Meridian Operations	3,600,000	—	3,120,000	480,000
Meridian Properties	—	180,000	120,000	60,000
Combined (pre-elimination)	3,600,000	420,000	3,420,000	600,000

The intercompany income of A$420,000 comprises the management fee charged by Holdings (A$240,000) and the rent charged by Properties to Operations (A$180,000). Both flows also appear as expenses in Meridian Operations, inflating both total income and total expenses on the combined view. After eliminations:

Line Item	Amount (A$)
External Revenue	3,600,000
Total Expenses (net of IC eliminations)	(3,000,000)
Consolidated Net Profit	600,000

The consolidated net profit of A$600,000 is the same as the combined pre-elimination total — which is correct, because eliminating intercompany income and the matching intercompany expense has no net effect on group profit. What changes is the presentation: the consolidated P&L now shows only the A$3,600,000 earned from external customers, with no artificial inflation of either the income or expense lines.

How BrizoConsol Consolidates Multiple MYOB Companies

BrizoConsol connects directly to MYOB AccountRight and MYOB Business via the MYOB API. It pulls each company’s trial balance automatically each period — no manual export, no CSV reformatting, no copy-paste into a master spreadsheet.

Account mapping is handled through AI Auto-Map, which analyses each MYOB company’s chart of accounts and maps accounts to the group structure automatically, learning from any corrections made over time. The initial mapping for a three-entity MYOB group typically takes under an hour; subsequent periods require no remapping unless new accounts are added.

Intercompany eliminations are configured once. Management fees, rent charges, intercompany loans, dividends, and any other recurring intra-group transactions are set up as elimination rules that run automatically each period. The intercompany elimination process that previously required manual journal entries and balance-matching is reduced to a review step — confirming that the automated eliminations are complete and that no new intercompany transactions have been missed.

The consolidated P&L, balance sheet, and supporting schedules are available as soon as the last MYOB company has closed its period. For Meridian Group, the process that previously occupied two days of close time now runs in under two hours.

Getting Started with MYOB Consolidation in BrizoConsol

Connecting multiple MYOB companies to BrizoConsol requires MYOB administrator access for each company file. BrizoConsol connects via the MYOB API using OAuth authentication — no data is exported from MYOB, and the connection is read-only for trial balance data.

The setup process involves connecting each MYOB company, confirming the group chart of accounts structure, reviewing the AI-generated account mappings, and configuring the intercompany elimination rules. For most MYOB groups, this is a half-day exercise. The first consolidated output — mapped, eliminated, and balanced — is typically available on the same day.

Consolidate your MYOB companies without the spreadsheet.

BrizoConsol connects directly to MYOB AccountRight and MYOB Business, maps accounts automatically, eliminates intercompany transactions, and produces consolidated group accounts in minutes. Start Free Trial