Last updated: 6 October 2026 · Independent buyer’s guide · We do not sell rankings or coverage.
For most mid-market Australian groups, Oracle NetSuite with OneWorld is the strongest single-system option for financial consolidation and real-time reporting, provided you can accept quote-only pricing and budget separately for its EPM modules if you need formal close management. Sage Intacct is the closest finance-led alternative and documents automatic non-controlling interest calculations, but it needs a separate operations system for inventory-heavy businesses. Microsoft Dynamics 365 Business Central suits groups that want published AUD pricing and plan to report through Power BI or Jet Reports. MYOB Acumatica fits Australian groups that want local payroll in the same platform. Groups still on Xero or MYOB Business can get consolidated management reports through Fathom or Spotlight Reporting, and very large or complex groups are often better served by a dedicated consolidation platform such as OneStream sitting above the ERP.
This guide is written for Australian CFOs, financial controllers and finance managers who need to close the month faster, produce consolidated statutory accounts for ASIC lodgement, and give the board reliable numbers between closes. It focuses on the close and reporting layer. If your main question is how to structure entities, intercompany trading and multi-currency ledgers, read our separate guide to multi-entity ERP in Australia first.
Key takeaways
- If your group is a large proprietary company, ASIC thresholds are measured on consolidated figures, and the financial report is generally due within four months of year end.
- AASB 10 requires intragroup balances and transactions to be eliminated in full, and non-controlling interests must be shown separately in equity. Test both in every demo.
- NetSuite OneWorld and Sage Intacct handle consolidation inside the core ledger. Business Central and MYOB Acumatica consolidate well but usually lean on an add-on for board-ready reporting.
- Real-time dashboards are standard in modern cloud ERP. The harder part is a consistent chart of accounts and a clean intercompany process across entities.
- Budget for the reporting layer explicitly: Power BI Pro is AU$21.00 per user per month, while NetSuite EPM, Jet Reports and Sage Intacct are quote-only.
- A separate consolidation platform makes sense when you have several ERPs, frequent acquisitions or a listed-company reporting timetable.
What Australian finance teams need from consolidation and reporting
Statutory consolidation and ASIC lodgement
A proprietary company is classed as large if it meets at least two of three tests: consolidated revenue of $50 million or more, consolidated gross assets of $25 million or more, or 100 or more employees across the company and the entities it controls (ASIC, page last modified 20 October 2014; thresholds apply to financial years from 1 July 2019). Large proprietary companies must prepare and lodge a financial report and a directors’ report each year. Disclosing entities must lodge within three months of year end, and other companies within four months (ASIC, 2 October 2026).
ASIC is enforcing these deadlines. In August 2026 it announced that three Mainfreight Group companies paid infringement notices of $198,000 each, a total of $594,000, for failing to lodge financial reports for the year ended 31 March 2025 by the 31 July 2025 deadline (ASIC media release 26-188MR, 10 August 2026). A slow consolidation process is therefore a compliance risk as well as an efficiency problem.
The accounting rules set the minimum your system must do. AASB 10 requires consolidated statements to eliminate in full intragroup assets, liabilities, equity, income, expenses and cash flows between group entities (AASB 10 fact sheet published on fwc.gov.au, 10 March 2023). Under AASB 1060, which governs Tier 2 simplified disclosures, non-controlling interests are presented within equity separately from the parent’s equity, and you must disclose any difference between the reporting dates of the parent and its subsidiaries (AASB 1060, compiled 30 June 2021).
Management reporting and real-time dashboards
Management reporting is where your executives spend their time. It usually needs segment views by business unit, region or product, comparisons to budget and forecast, and a small set of operational KPIs such as cash, debtor days and gross margin. These reports do not follow AASB presentation rules, so the ERP needs flexible dimensions and a report builder that finance staff can maintain without a developer.
“Real-time” is a reasonable expectation for transactional data in any modern cloud ERP. It is less meaningful for consolidated results, because consolidated numbers depend on period-end exchange rates, accruals and eliminations that only exist once the close is complete. A useful question for vendors is which dashboards update as transactions post and which only become reliable after the month is closed.
Month-end close speed
Close speed depends more on process design than on software. The software helps by automating intercompany matching, period-end revaluation, account reconciliations and the elimination journals. When you compare vendors, ask each one to show the exact sequence of steps from the last subledger cut-off to a signed-off consolidated balance sheet, and count how many of those steps happen outside the ERP in spreadsheets.
How the main ERPs handle consolidation and reporting
Oracle NetSuite with OneWorld
NetSuite OneWorld consolidates subsidiaries within a single ledger. Consolidated exchange rates are maintained for each accounting period and translate amounts from each child subsidiary’s base currency to its parent, and Oracle advises updating them at the end of each period as part of close (Oracle NetSuite help, created 6 May 2016, no update date shown). OneWorld financial statements support subsidiary-specific layouts and cumulative translation adjustment, and Oracle notes that default reporting periods may not match every subsidiary’s fiscal periods (Oracle NetSuite help, no update date shown).
Intercompany elimination runs from the Period Close Checklist and posts elimination journals to an elimination subsidiary. You can run it more than once in a period, but you cannot run two elimination processes at the same time, and Oracle notes that currency differences may need manual journal adjustments (Oracle NetSuite help, no update date shown). For dashboards, NetSuite documents role-based dashboards with KPIs, saved searches that return real-time results, and SuiteAnalytics Workbook for charts and pivot tables (NetSuite Australia, no date shown).
For formal close management and planning, Oracle sells NetSuite Enterprise Performance Management as an add-on. It includes Planning and Budgeting, Account Reconciliation, Close Management and Consolidation, and Narrative Reporting, priced as an annual subscription based on the core platform, optional modules and user count, plus a one-time implementation fee. No prices are published (NetSuite Australia EPM page, no date shown). See our NetSuite pricing guide for Australia for how quotes are typically built.
Microsoft Dynamics 365 Business Central
Business Central consolidates by importing general ledger entries from each subsidiary, set up as a business unit, into a separate consolidation company. Data can come from the same environment, from other Business Central environments through an API, or from an XML file. Each account can use a different translation method, including average, closing, historical, composite and equity rates, and a dedicated report posts consolidation eliminations (Microsoft Learn, 23 June 2025).
One point needs care. The business unit card has a consolidation percentage, and Microsoft’s example shows a 70% owned subsidiary consolidating only 70% of its transactions (Microsoft Learn, 23 June 2025). AASB 10 generally requires full consolidation of controlled entities with non-controlling interests shown separately, so ask your partner to show exactly how a partly owned subsidiary will be presented in your statutory accounts.
Native reporting uses Financial Reporting row and column definitions, which support formulas and budget comparisons (Microsoft Learn, 1 April 2026). Microsoft also publishes nine Power BI apps for Business Central, including Finance, Sales, Inventory and Projects (Microsoft Learn, 13 May 2026). Users who install, refresh or view these apps need Power BI Pro licences or Premium capacity, because free Power BI licences are not supported (Microsoft Learn, 31 October 2025). Business Central lists at AU$119.70 per user per month for Essentials and AU$164.60 for Premium, and Microsoft states that multiple companies are included (Microsoft Australia, checked 6 October 2026).
Sage Intacct
Sage Intacct is a finance-first cloud system, and consolidation is one of its strongest documented areas. It offers three consolidation subscriptions. Domestic Consolidation covers wholly owned entities in one base currency with automatic inter-entity elimination. Global Consolidation adds two or more base currencies and automated cumulative translation adjustments at extra cost. Advanced Ownership Consolidation adds multi-level structures and automatically generates non-controlling interest based on ownership percentages (Sage Intacct help, 1 October 2026).
Sage’s Australian consolidation page claims you can consolidate hundreds of entities in minutes and refers to ASC 830 for translation adjustments (Sage Australia, no date shown). ASC 830 is a US GAAP standard, so ask for a demonstration of translation under AASB 121 rather than relying on the page. Pricing is by request only. Sage Intacct does not include inventory depth comparable to NetSuite or Business Central, so it is a better fit for services, SaaS, property and not-for-profit groups.
MYOB Acumatica
MYOB Acumatica supports general ledger consolidation from subsidiary branches into a parent company branch, and you can run it as often as needed within each period (MYOB help, no date shown). Kilimanjaro Consulting, an MYOB partner, states that it can eliminate intercompany transactions automatically on company-wide reports, hold an unlimited number of subsidiaries in one tenant and support multiple base currencies. The same partner lists Velixo as a reporting integration (Kilimanjaro Consulting, 12 January 2026). The main advantage for Australian groups is native payroll in the same platform. Compare it in more detail in our NetSuite vs MYOB Acumatica guide.
Xero and MYOB with Fathom or Spotlight
Xero does not consolidate multiple organisations natively. In July 2025 Xero said that work on consolidated reporting is not currently planned and pointed users to third-party apps (Xero Product Ideas, response dated 23 July 2025). Fathom offers multi-currency consolidations with eliminations for up to 300 entities across systems, with the Pro plan listed at A$605 per month for 25 companies and A$19 for each additional company, excluding GST (US$450 and US$17 in US dollars). Fathom says it consolidates results from Xero, QuickBooks, MYOB AccountRight (cloud and desktop) and Excel (Fathom pricing, no date shown, checked 6 October 2026). Spotlight Reporting’s Australian business plans start at A$65 per month for one organisation and A$329 per month for up to 10 organisations, excluding GST, and Spotlight says its reporting product can consolidate up to 50 entities and eliminate intercompany accounts (Spotlight Reporting AU pricing, no date shown, checked 6 October 2026). Spotlight imports from Xero, QuickBooks and MYOB AccountRight Plus, but its help centre states that MYOB Business Lite and MYOB Business Pro are not supported (Spotlight help centre, no date shown, checked 6 October 2026). These tools suit smaller groups, but they do not replace a group ledger. If you are reaching their limits, read our guide to outgrowing Xero and MYOB.
At-a-glance comparison
| System | Consolidation in the core product | Typical reporting and FP&A layer | Published AUD pricing |
|---|---|---|---|
| NetSuite OneWorld | Yes, single ledger with elimination subsidiaries and period-close checklist | SuiteAnalytics dashboards; NetSuite EPM add-on | No, quote only |
| Business Central | Yes, via a consolidation company and business units | Financial Reporting, Power BI apps, Jet Reports | Yes, from AU$119.70 per user per month |
| Sage Intacct | Yes, three tiers including automatic non-controlling interest | Built-in dimensional reporting and dashboards | No, quote only |
| MYOB Acumatica | Yes, GL consolidation into a parent branch | Native reports; Velixo through partners | Partner-published only |
| Xero or MYOB AccountRight | No native group consolidation | Fathom or Spotlight Reporting | Fathom and Spotlight publish AUD pricing |
Reporting and FP&A add-ons: what to budget for
Many groups buy the ERP for transactions and then discover the board pack is still built in Excel. Plan the reporting layer at the same time as the ERP so it appears in your business case. The table below shows what each common option costs, based on what the publisher discloses.
| Tool | Works with | Published price | Best use |
|---|---|---|---|
| NetSuite EPM | NetSuite | Not published; subscription plus implementation fee | Formal close management, reconciliations, budgeting |
| Power BI Pro | Business Central and most ERPs | AU$21.00 per user per month, paid yearly, excluding GST | Dashboards and the Business Central Power BI apps |
| Jet Reports | Business Central, Dynamics NAV | Not published; quoted after discovery call | Excel-based financial statements and board packs |
| Fathom | Xero, QuickBooks, MYOB AccountRight, Excel | Pro A$605 per month for 25 companies, excluding GST | Group management reporting before ERP |
Sources for the table: NetSuite Australia EPM page (no date shown); Microsoft Australia Power BI pricing, checked 6 October 2026, which also lists Premium Per User at AU$35.90; ERP Research, August 2026, an independent review site; Fathom pricing page, AUD prices, no date shown, checked 6 October 2026.
When a separate consolidation tool beats the ERP
An ERP-based consolidation works best when every entity runs on the same ERP with a shared chart of accounts. A dedicated consolidation and corporate performance management platform becomes the better choice in four situations.
- You run several ERPs, often after acquisitions, and replacing them all is not realistic in the next two to three years.
- You have complex ownership, such as joint ventures, partly owned subsidiaries at several levels, or frequent changes in ownership percentages.
- You are a disclosing entity with a three-month lodgement deadline and a half-year review, so the close timetable leaves little room for manual work.
- Planning, forecasting and statutory consolidation need to share one data model and one audit trail.
OneStream is one example used in Australia. It describes its platform as combining planning, financial close and consolidation, reporting and analytics, and in December 2020 it announced an Asia-Pacific headquarters in Sydney, naming Seven Group Holdings as a customer (OneStream, 8 December 2020). For mid-market groups, NetSuite EPM and Sage Intacct’s higher consolidation tiers cover much of the same ground at lower complexity. For a broader view of the consolidation process itself, see our CFO’s playbook for multi-entity consolidation.
Our independent take
Most Australian groups that struggle with consolidation do not have a software problem. They have inconsistent charts of accounts, intercompany transactions recorded differently on each side, and a board pack rebuilt manually each month. A new ERP fixes these issues only if you redesign the chart of accounts and the intercompany process during implementation.
On software alone, NetSuite and Sage Intacct give you the most complete consolidation inside the ledger. Business Central gives you the clearest pricing but usually needs Power BI or Jet Reports to produce board-ready reporting. We would not recommend buying a separate consolidation platform until you have tried to standardise the ledger, unless you are running several ERPs or report to a listed-company timetable.
Australian buyer scenarios
Melbourne property and services group, eight entities, about $90 million revenue. The group has two partly owned subsidiaries and lodges as a large proprietary company. Its controller spends a week each month rebuilding consolidated accounts in Excel. Sage Intacct with Advanced Ownership Consolidation is a strong candidate because it generates non-controlling interest automatically, and the business has no inventory to manage. NetSuite OneWorld is the alternative if the group expects to add trading operations.
Brisbane wholesale distributor, three entities including a New Zealand subsidiary, about $60 million revenue. The business needs inventory, multi-currency and a monthly board pack. It already uses Microsoft 365 and has an internal analyst who builds Power BI reports. Business Central with the Finance Power BI app and Power BI Pro licences gives a predictable cost. The finance team should confirm the elimination and translation process for the NZ entity during the demo. Our guide to ERP for wholesale distribution in Australia covers the operations side.
Sydney SaaS company, four entities in Australia, the UK and the US, about $35 million ARR. The CFO needs a fast close for investor reporting and a rolling forecast. NetSuite OneWorld with EPM Planning and Budgeting fits the requirement, although the EPM cost must be quoted separately. Sage Intacct is the main alternative. See our guide to ERP for SaaS companies in Australia.
When NetSuite is not the right choice
NetSuite is not the right choice if you need a firm price before you start, because Oracle publishes no list pricing for either NetSuite or EPM. It is also a poor fit if you only need consolidated management reporting across a few small entities, because Fathom or a similar tool on your existing accounting files will cost far less.
NetSuite also does not run Australian payroll, because SuitePeople Payroll supports only US payroll, so you will need a separate payroll system. Our article on whether NetSuite is worth it in Australia covers the cost trade-offs, and NetSuite vs Business Central compares the two most common shortlist options.
How we evaluated
We reviewed vendor documentation for consolidation, intercompany elimination, currency translation and reporting for NetSuite, Business Central, Sage Intacct and MYOB Acumatica, and the published pricing for reporting add-ons. We checked each system against the Australian statutory requirements published by ASIC and the AASB. Where a vendor or partner sells the product, we say so. Where no price or date is published, we say that too. We did not run hands-on tests of each system for this guide, and we do not accept payment for rankings. For a wider shortlist, see our guide to the best ERP software in Australia.
Frequently asked questions
Which ERP system is best for financial consolidation?
For a single-ledger consolidation across Australian and overseas subsidiaries, NetSuite OneWorld and Sage Intacct are the strongest documented options. Sage Intacct’s Advanced Ownership Consolidation is the clearest on non-controlling interest. Business Central and MYOB Acumatica also consolidate, but you should test partial ownership and currency translation carefully in a demo.
What is the best ERP system for real-time business reporting?
NetSuite provides real-time dashboards, KPIs and saved searches in the core product. Business Central offers real-time Financial Reporting and nine Power BI apps, which need Power BI Pro licences at AU$21.00 per user per month. Consolidated figures are only reliable after period-end rates and eliminations are processed, in any system.
Which ERP system is best for businesses with complex reporting needs?
If complexity comes from ownership structures, Sage Intacct or NetSuite with EPM fit best. If it comes from several ERPs, acquisitions or a listed-company timetable, a dedicated consolidation platform such as OneStream is often a better fit than any single ERP.
What is the best ERP for finance and operations?
For businesses that need inventory, purchasing and finance in one system, NetSuite and Business Central are the most common choices. MYOB Acumatica adds native Australian payroll. Sage Intacct is strong in finance but is not designed for inventory-heavy operations.
When must an Australian group lodge consolidated financial reports?
Large proprietary companies and public companies generally lodge within four months of year end, and disclosing entities within three months (ASIC, 2 October 2026). Large proprietary status is measured on consolidated revenue, assets and employees.
Can I consolidate Xero files without an ERP?
Yes, for management reporting. Xero has no native consolidation and has said it is not currently planned. Tools such as Fathom and Spotlight Reporting consolidate multiple Xero files and handle eliminations. If you must lodge consolidated statutory accounts, confirm with your auditor whether the tool’s output is suitable as the basis for them.
Sources
Every figure and claim in this article traces to one of these. Prices were checked on the date shown. Partner links are marked as such because those firms sell the software they write about.
- ASIC, Are you a large or small proprietary company, last modified 20 October 2014. asic.gov.au
- ASIC, Company financial reports, 2 October 2026. asic.gov.au
- ASIC, Media release 26-188MR, 10 August 2026. asic.gov.au
- AASB 10 Consolidated Financial Statements fact sheet, published on fwc.gov.au, 10 March 2023. fwc.gov.au
- AASB 1060 General Purpose Financial Statements, Simplified Disclosures, compiled 30 June 2021. standards.aasb.gov.au
- Oracle NetSuite help, Consolidated Exchange Rates, created 6 May 2016, no update date shown. docs.oracle.com
- Oracle NetSuite help, OneWorld Financial Statements, no update date shown. docs.oracle.com
- Oracle NetSuite help, Running Intercompany Elimination, no update date shown. docs.oracle.com
- NetSuite Australia, Enterprise Performance Management, no date shown, checked 6 October 2026. netsuite.com.au
- NetSuite Australia, Embedded business intelligence, no date shown, checked 6 October 2026. netsuite.com.au
- Microsoft Learn, Set up company consolidation in Business Central, 23 June 2025. learn.microsoft.com
- Microsoft Learn, Design financial reports in Business Central, 1 April 2026. learn.microsoft.com
- Microsoft Learn, Power BI apps for Business Central by functional area, 13 May 2026. learn.microsoft.com
- Microsoft Learn, Power BI apps FAQ for Business Central, 31 October 2025. learn.microsoft.com
- Microsoft Australia, Business Central pricing, checked 6 October 2026. microsoft.com
- Microsoft Australia, Power BI pricing, checked 6 October 2026. microsoft.com
- Sage Intacct help, About the Consolidation subscriptions, 1 October 2026. intacct.com
- Sage Australia, Sage Intacct consolidation accounting, no date shown, checked 6 October 2026. sage.com
- MYOB help, Configuring GL Consolidation in MYOB Acumatica, no date shown. help.myob.com.au
- Kilimanjaro Consulting, MYOB Acumatica for multi-entity organisations, 12 January 2026. MYOB partner. kilimanjaro-consulting.com
- Xero Product Ideas, Ability to consolidate multiple Xero organisations, Xero response dated 23 July 2025. productideas.xero.com
- Fathom, Pricing, no date shown, checked 6 October 2026. fathomhq.com
- Spotlight Reporting, Pricing AU Business, no date shown, checked 6 October 2026. spotlightreporting.com
- Spotlight Reporting help centre, MYOB AccountRight Plus connection, no date shown, checked 6 October 2026. help.spotlightreporting.com
- ERP Research, Jet Reports review, August 2026. Independent review site. erpresearch.com
- OneStream, Asia-Pacific headquarters in Sydney announcement, 8 December 2020. Sells consolidation software. onestream.com
- Oracle NetSuite help, SuitePeople Payroll country support, checked 30 August 2026. docs.oracle.com