How to Consolidate MYOB Companies
Guide by RankerToolAI · Updated October 2026 · Based on each vendor's published pricing and feature pages, not a hands-on test. See our methodology.
Disclosure: this page contains affiliate links, including to Joiin. We may earn a commission if you buy through them, at no extra cost to you. Read our disclosure.
MYOB doesn't consolidate company files on its own. Use a master company file or Excel for two simple companies; for more, connect them to an app like Joiin (read-only daily sync, eliminations included).
Quick Navigation
What MYOB Offers Natively
MYOB Business and AccountRight keep each company in its own company file, and there's no built-in report that consolidates several files. MYOB's support guidance on consolidating reports for multiple company files says that in most cases you export and import accounts into one master company file, and that there's no one-size-fits-all solution. Its community also suggests exporting reports to Excel and combining them there.
Option A: A Master Company File
MYOB's suggested route is to create a master company file, import each company's accounts into it and post the balances there. It keeps everything inside MYOB, but it's a manual monthly import, eliminations still have to be journalled by hand, and the master file has to be kept in step with every chart of accounts change in the subsidiaries.
Option B: Combine Reports in Excel
- Run the trial balance for the same period in each company file.
- Export to Excel, one tab per company.
- Map accounts to a group chart of accounts.
- Add an eliminations column for intercompany transactions and balances.
- Sum to a consolidated trial balance and build the group P&L and balance sheet.
Our free consolidation Excel template sets this up for you, with eliminations and balance checks built in. Fine for two simple companies; slow and error-prone beyond that.
Option C: A Consolidation App
Reporting apps connect to each MYOB company and refresh automatically, so the mapping and eliminations are set once. Options that connect to MYOB include Joiin, Fathom (MYOB AccountRight cloud and desktop) and Calxa. Joiin is usually the cheapest for small groups, and it also connects to Xero, QuickBooks, Sage and others if part of the group runs a different ledger, which is common in Australia and New Zealand where Xero and MYOB sit side by side.
Using Joiin With MYOB
According to Joiin's MYOB page, the connector suits any business or accounting firm using MYOB. It uses a secure OAuth connection with no API keys, imports each company's trial balance automatically and syncs daily. The connection is one-way and read-only, so nothing is written back to MYOB.
- Start Joiin's free trial (14 days on the Max plan, no card).
- Connect each MYOB company through the OAuth prompt.
- Map each company's accounts to the group reporting structure.
- Set eliminations for intercompany accounts.
- Run the consolidated P&L, balance sheet and cash flow, and save them as a monthly report pack.
| Companies | Joiin monthly | Joiin annual (per month) |
|---|---|---|
| 1 | $28 | $23 |
| 2 | $36 | $29 |
| 5 | $70 | $57 |
| 10 | $111 | $92 |
| 20 | $167 | $139 |
USD, joiin.co/pricing, October 24, 2026. Joiin also bills in AUD and NZD.
Consolidate your MYOB companies
Connect them to Joiin's 14-day Max trial. No credit card, read-only connection.
Start a Free Joiin Trial →Affiliate link. We may earn a commission at no extra cost to you.
FAQ
Can MYOB produce consolidated reports for multiple companies?
Not as a built-in group report. MYOB's own support guidance says that in most cases you export and import accounts into one master company file, and that there's no one-size-fits-all solution. Many groups use a reporting add-on instead.
Which tools consolidate MYOB companies?
Joiin, Fathom and Calxa are among the tools that connect to MYOB. Joiin syncs each MYOB company's trial balance daily through a read-only connection and consolidates it with eliminations. Fathom connects to MYOB AccountRight cloud and desktop.
Does Joiin write anything back to MYOB?
No. Joiin's MYOB page describes a one-way, read-only connection: data flows into Joiin and nothing is written back to MYOB.
How much does Joiin cost in Australia or New Zealand?
Joiin bills in AUD and NZD as well as USD. In USD, its table is $36/mo for two companies billed monthly ($29/mo annually) and $111/mo for ten ($92 annually). Check the AUD or NZD figure on Joiin's pricing page.