Consolidated Financial Statements in MYOB

Short answer

MYOB does not support consolidated group financial statements natively — whether you're using MYOB AccountRight or MYOB Business. Each company file is a single entity; there's no built-in way to combine multiple files into one consolidated P&L, balance sheet, or cash flow, or to eliminate intercompany transactions across them. To run group consolidated reports from MYOB, you need either a manual Excel process or a consolidation platform that connects to MYOB via API.

If your group runs multiple entities through separate MYOB company files — common for Australian and New Zealand businesses with subsidiaries or holding structures — this limitation becomes the primary reporting constraint. MYOB is well-suited to managing each entity’s books, local compliance, GST, and payroll. Running the group is a different task. This article covers what MYOB can and can’t do for group reporting, what the manual workaround specifically involves for MYOB users, and how BrizoConsol connects directly to your MYOB entities to produce proper consolidated statements.

MYOB AccountRight vs MYOB Business — What Each Can Do

MYOB’s product range matters for consolidation because the two main products have different capabilities and different API access levels.

	MYOB AccountRight	MYOB Business (formerly Essentials)
Target user	Larger SMEs, inventory, job tracking	Smaller businesses, simpler bookkeeping
Chart of accounts	Header accounts + detail accounts (two-tier hierarchy)	Simpler flat structure
API access	Full API — trial balance, journals, transactions	API available — more limited transaction detail
Multi-currency	Available within a single company file	Limited multi-currency support
Native consolidation	Not available	Not available

BrizoConsol connects to both MYOB AccountRight and MYOB Business via API. For groups with a mix of AccountRight and Business entities — or MYOB alongside Xero or QuickBooks — BrizoConsol handles the full entity set through API connections and Excel import as a fallback.

What MYOB Can and Can’t Do for Group Reporting

What MYOB can do	What MYOB can’t do
Produce full P&L, balance sheet, and cash flow for a single company file	Combine multiple company files into one consolidated report
Handle multi-currency within a single AccountRight file	Translate foreign entity financials at group-level exchange rates for consolidation
Export trial balance data for use in external consolidation	Eliminate intercompany transactions across company files
Connect to third-party consolidation software via API (AccountRight)	Calculate NCI, CTA, or apply group accounting adjustments
Track intercompany invoices within each individual file	Produce group-level management reports or dashboards

The Manual Workaround — MYOB-Specific Failure Points

The standard manual approach for MYOB groups is to export trial balances from each company file and combine them in Excel. In MYOB AccountRight: Reports → Accounts → Trial Balance → select date range → export. In MYOB Business, the report export path is similar but the trial balance format is less granular.

The process follows the same steps as any manual consolidation: map accounts to a common structure, apply exchange rates, post eliminations, aggregate into a single worksheet. The MYOB-specific problems are:

🚩 MYOB AccountRight header/detail account structure: AccountRight organises accounts in a two-tier hierarchy — header accounts (which group detail accounts) and detail accounts (which carry actual balances). When you export a trial balance, both header rows and detail rows appear in the output. Header accounts show a subtotal balance that is the sum of their detail accounts. If you include header rows in your consolidation model, every transaction is double-counted — the detail balance and the header subtotal are both included. The header rows must be stripped before the data is usable, and the correct column to identify them varies between export formats.

GST tax codes in the export: MYOB AccountRight accounts have GST tax codes applied (GST, FRE, INP, CAP, etc.) that appear in the export. These codes are relevant for BAS reporting in the entity’s own books but are meaningless in a group consolidation context — the consolidated statements are net of GST. The GST code column needs to be excluded from the consolidation mapping to avoid confusion and ensure account-level values are the net (ex-GST) amounts.

Financial year alignment: MYOB AccountRight defaults to an April–March financial year for Australian entities following the standard Australian tax year. If the group parent reports on a calendar year (January–December) or a different period, the MYOB entity’s trial balance must be extracted for a custom date range that may span two MYOB financial years — which sometimes produces output in a different format than a within-year extract.

Running Consolidated Statements from MYOB Using BrizoConsol

BrizoConsol connects to MYOB AccountRight and MYOB Business via API — pulling trial balance data from each company file into a single consolidation environment. The connection is set up once; data flows in automatically at each reporting period.

Connect your MYOB entities Each MYOB AccountRight or MYOB Business company is connected to BrizoConsol via secure API authorisation. Once connected, BrizoConsol pulls the trial balance and chart of accounts directly. For entities not on MYOB — or for groups with a mix of MYOB and other platforms — BrizoConsol accepts Excel trial balance import alongside the API-connected entities, so the full group can be included regardless of which accounting software each entity uses.

Map accounts to a group chart of accounts In AccountRight, detail accounts are mapped individually to the group COA — header accounts are excluded from the mapping since they carry no direct balances. The AI-assisted mapping in BrizoConsol suggests classifications based on account names and types, which you review and confirm. New accounts added to any MYOB company are flagged for mapping before the next consolidation runs — preventing the silent unmapped-account problem that affects manual models.

COA mapping example — MYOB AccountRight AU AccountRight file: Header “4-0000 Income” → Detail accounts “4-1000 Sales – Domestic” and “4-2000 Sales – Export”
NZ Business file: “Revenue – NZ”, “Revenue – International”
SG Xero file: “Revenue”, “Export Revenue”

Group COA mapping:
All domestic/NZ revenue accounts → “Group Revenue – Domestic”
All export/international accounts → “Group Revenue – International”

MYOB header account “4-0000 Income” is excluded from mapping — only its detail accounts are mapped.

Configure exchange rates for the reporting period For entities with foreign functional currencies, you set the closing rate (balance sheet) and average rate (P&L) for each period centrally in BrizoConsol. For AU-centric groups, the typical setup is AUD as the group presentation currency, with NZD, SGD, GBP, or other subsidiary currencies translated at the relevant rates. Currency translation adjustments are calculated automatically and allocated to group equity.

Post intercompany elimination entries Intercompany transactions between MYOB entities — management fees, intercompany loans, shared cost recharges — are eliminated in BrizoConsol using either group-level eliminations (single debit and credit at consolidation level) or entity-pair eliminations (specifying which entity generated the income and which carries the expense). For groups with minority shareholders in any entity, entity-pair eliminations are used so that each entity’s contribution to the group is accurate net of intercompany charges before the NCI calculation runs.

Generate consolidated reports With COA mapping applied, exchange rates set, and eliminations posted, BrizoConsol generates the consolidated P&L, balance sheet, and cash flow in the group presentation currency. Drill-down from any consolidated line shows each entity’s contribution, and from there to the underlying account. Reports can be viewed in the platform, exported as PDF, or scheduled for automatic delivery to defined recipients.

Worked Scenario: AU/NZ/SG Group, Consolidated in AUD

Group structureAU HoldCo Pty Ltd (Australia, AUD) — parent on MYOB AccountRight, 100% owner of both subsidiaries
NZ OpCo Ltd (New Zealand, NZD) — trading entity on MYOB Business
SG OpCo Pte Ltd (Singapore, SGD) — trading entity on Xero

Intercompany transaction: AU HoldCo charges both subsidiaries a $6,000 AUD management fee per month, invoiced in AUD.

In BrizoConsol:

AU HoldCo and NZ OpCo connected via MYOB API; SG OpCo connected via Xero API — all three in the same consolidation
AccountRight detail accounts mapped individually; header accounts excluded
NZD figures translated at NZD/AUD closing rate (balance sheet) and average rate (P&L)
SGD figures translated at SGD/AUD closing and average rates; CTA allocated to group equity
Two eliminations posted: Dr Management Fee Income (AU HoldCo) AUD 6,000 / Cr Management Fee Expense (NZ OpCo) AUD 6,000; same entry for SG OpCo — NZ and SG each carry the AUD fee as a foreign currency payable in their own books, but the elimination uses the AUD amount

Output: a consolidated P&L in AUD with the management fees eliminated, all subsidiary figures translated at the correct rates, and entity-level drill-down available from any group line.

What BrizoConsol Requires from Your MYOB Setup

Each entity needs its own MYOB company file — BrizoConsol connects one company file at a time; entities sharing a file are treated as one entity
AccountRight files should be cloud-enabled — AccountRight can be used in local file mode, but API access requires the file to be stored in the MYOB cloud. Most AccountRight users are already cloud-enabled; confirm before connecting
Books should be reconciled before syncing — BrizoConsol pulls whatever is in the MYOB file at the time of the sync; unreconciled bank accounts or unapproved transactions flow through as-is
Header accounts in AccountRight do not need mapping — only detail accounts carry balances and need group COA mapping; header accounts are automatically excluded
Mixed-platform groups are fully supported — entities on Xero, QuickBooks Online, or Zoho Books alongside MYOB entities are connected via their respective APIs; non-cloud entities can be included via Excel import

BrizoConsol connects directly to MYOB AccountRight and MYOB Business — pulling trial balance data from each company file, mapping detail accounts to a group COA, handling multi-currency translation, and producing consolidated P&L, balance sheet, and cash flow alongside entity-level drill-down. Learn more or see it in action →

How Do I Run Consolidated Group Financial Statements in MYOB?