Xero & MYOB Guide: Integration, Migration and Reporting

Choosing, migrating, connecting and reporting: a plain-English guide for Australian businesses running on Xero or MYOB

What This Guide Covers

This guide covers everything about running a business with 10 to 200 staff on Xero or MYOB and the systems around them: choosing between them, moving from one accounting system to another, getting conversion balances right, connecting your CRM, job and payroll systems, fixing integrations when a vendor changes its API, reporting across several entities, and knowing when you have outgrown the accounts altogether.

It is written for owners, finance managers and operations managers, not developers. Each section gives the short, honest answer first, then links to the detailed articles, comparisons and service pages if you want to go deeper. Where a cheaper route exists, such as a marketplace app or a standard conversion tool, we say so.

The common thread is that the accounts are rarely the problem on their own. Trouble usually starts where information passes between Xero or MYOB and everything else: a job retyped into an invoice, a group report rebuilt in a spreadsheet, or a sync that quietly stopped. That is the part this guide focuses on.

In This Guide

  1. Choosing Between Xero, MYOB and the Alternatives
  2. Moving Between Accounting Systems
  3. Conversion Balances and the Trial Balance
  4. Connecting Xero or MYOB to Your Other Systems
  5. When an Integration Breaks or an API Changes
  6. Multi-Entity Groups and Tracking Categories
  7. Payroll, STP and Payday Super
  8. Reporting, Dashboards and Power BI
  9. Outgrowing Xero or MYOB: Exo, Acumatica and NetSuite
  10. Where to Start
  11. How Kenomont Helps
  12. Frequently Asked Questions

Choosing Between Xero, MYOB and the Alternatives

For a business with 10 to 200 staff, the choice between Xero and MYOB is rarely about the invoice screen. Both handle bank feeds, GST, BAS and the everyday accounts well. What matters is around the edges: payroll for your mix of staff, how much stock and job detail you need, which add-on apps you rely on, and which system your accountant knows best.

Xero has a very large app marketplace, so it often suits businesses that want to plug in a job system, a CRM or a stock app. MYOB keeps more under one Australian vendor, and its range runs from MYOB Business up to MYOB Acumatica, so some businesses like having a path to grow without changing vendors. QuickBooks Online is a real option too, particularly if you report by classes and locations, though Xero and MYOB are more common among Australian accountants.

The honest answer for most growing businesses: if your current system is doing the job and your reports are trusted, moving costs time and money for little gain. Change when something specific is in the way, such as an app you need that only connects to one system, an accountant who works in the other, or a team that keeps exporting to spreadsheets to get the numbers they need.

Go Deeper

  • Xero vs MYOB: The main differences in plain English: apps, payroll, stock, reporting and which suits which business.
  • Xero vs QuickBooks (Australia): How the two compare for a business with staff, including what happens to classes and locations in Xero.
  • MYOB vs QuickBooks: A side-by-side look for Australian businesses weighing up MYOB against QuickBooks Online.
  • MYOB vs Xero for sole traders: The same question for one-person businesses, where the trade-offs are different.
  • QuickBooks limitations: Where QuickBooks starts to pinch as a business grows, and what to do about it.
  • Why is MYOB so slow?: Common causes of a slow MYOB file and the fixes worth trying before you move.

Moving Between Accounting Systems

Most accounting migrations follow the same path. Agree a switch date with your accountant, usually the start of a financial year or BAS quarter. Clean the old file. Convert the chart of accounts, contacts, open invoices and bills, and as much history as is worth bringing. Load conversion balances. Reconnect bank feeds, payroll and every other system that talks to the accounts. Then check the result against the old file before anyone relies on it.

The conversion itself is often the easy part. What gets underestimated is the cleaning before and the reconnecting after. Duplicate customers and suppliers, old items and a messy chart of accounts come across exactly as they are unless someone fixes them first. And every system that fed the old file has to be pointed at the new one and tested, or invoices quietly stop flowing.

Before you move, make sure you can get your data out in a form your auditor, your accountant and any future system can use. Keep the old file, or full reports from it, for payroll history and for the years you are not bringing across.

Go Deeper

Conversion Balances and the Trial Balance

Conversion balances are the opening figures in the new system on your switch date. They are the closing balances from the old one: bank accounts, debtors and creditors, stock, GST, payroll liabilities, loans, equity and so on. If they are wrong, every report from the new system is wrong from day one, and the mistake can sit unnoticed until the year-end accounts don't reconcile.

The check that matters is simple. Run a trial balance from the old system at the switch date, run one from the new system at the same date, and make sure every account agrees, line by line. Debtors and creditors should also agree to the open invoice and bill lists, because a total that matches can still hide the wrong customers owing the wrong amounts.

Things that commonly go wrong: accounts mapped to the wrong place when the chart of accounts changes, GST balances that don't line up with the last BAS lodged, payroll liabilities left behind, and foreign currency balances converted at the wrong rate. Your accountant or bookkeeper should sign off the balances. Our part is preparing the file, doing the mapping and handing over a reconciliation pack they can review before you go live.

Go Deeper

Connecting Xero or MYOB to Your Other Systems

In most businesses with staff, the accounts are fed by other systems: a CRM where quotes and deals live, a job or project system, stock software, timesheets, a weighbridge or production system, or a custom database. When those systems don't talk to Xero or MYOB, someone retypes invoices, costs and customer details, and the two sides slowly drift apart until nobody is sure which number is right.

Start with the marketplace. If a well-supported app does what you need, use it. The catch is that official integrations often carry less than people expect. Many sync invoices and contacts but not costs by job, retentions, variations, tracking categories or the detail your reports need. Before you buy, ask the vendor exactly which records move, in which direction, how often, and what happens when one side fails.

A custom integration makes sense when your process or mix of systems is unusual enough that apps keep breaking or need constant manual fixing. Both Xero and MYOB have APIs, the doors other software uses to read and write data, so a custom connection can send exactly what your business needs and alert a named person when something fails.

Go Deeper

When an Integration Breaks or an API Changes

Integrations rarely fail loudly. More often, invoices stop arriving one day and nobody notices until a customer queries a statement or month-end won't reconcile. The common causes are a change on the vendor side, an expired login or permission, a change in your own setup such as a new tracking category or tax code, or an integration someone built years ago that was never designed to report its own errors.

Vendor changes have been a real issue in 2026. MYOB has retired the broad API permission that many older integrations relied on, so connections that haven't moved to MYOB's newer, narrower permissions need re-authorising and sometimes code changes. Xero introduced tiered pricing for app developers in March 2026, and some connector apps are passing costs on, which changes the sums on whether to keep an app or build something of your own.

If an integration has stopped, write down when it stopped and keep a list of what hasn't synced, so nothing is lost once it is fixed. Then decide whether to repair it, replace it with a well-supported app, or rebuild it. A rebuilt integration should log every run, retry sensibly when an API is briefly unavailable, and alert a person when something genuinely fails, rather than silently dropping records.

Go Deeper

Multi-Entity Groups and Tracking Categories

Many growing businesses end up as a group: a trading company, a property or equipment entity, a family trust, perhaps a second business. In Xero and MYOB each entity is its own file or organisation. That keeps the books clean, but it means there is no single place to see the group, and intercompany charges, loans and recharges have to be matched by hand at month-end.

The usual answer is a consolidation layer that reads every entity, maps each chart of accounts to one group structure, and removes intercompany items, so you get group profit and loss and balance sheet figures without rebuilding a spreadsheet every month. It works best when the charts of accounts are lined up first and intercompany transactions are coded consistently in every entity.

Tracking categories are the other half of reporting structure. They let you report by division, location, job or project inside one entity. Xero allows up to two active tracking categories, which is enough for many businesses and tight for others. When you need more, there are options: combine categories, use Xero Projects for jobs, or move some of the reporting into a connected job system or reporting tool. Choose before the data builds up, because changing structure later means recoding history.

Go Deeper

Payroll, STP and Payday Super

Payroll is where the accounts meet the rest of the business most often. Hours come from timesheets, job systems or rosters; pay runs happen in Xero, MYOB or a separate payroll system; each pay run is reported to the ATO through Single Touch Payroll (STP); and the costs need to land against the right jobs and cost centres. Each hand-off is a place where information can be late, retyped or wrong.

Payday Super has made those hand-offs matter more. Super now has to be paid much closer to each pay day instead of quarterly, so a timesheet that arrives late, a pay run done twice to fix errors, or a super payment that waits for someone to approve it now shows up quickly. Businesses that bill and pay from the same hours, such as labour hire and trades, need pay, billing and super to stay in step.

The practical checks: confirm your payroll settings and super payment method keep up with each pay run, check that hours flow from the system where they are captured into payroll without retyping, and make sure payroll costs post to the accounts with the detail your job and cost reports need. If you still run MYOB Exo Payroll, plan the move now.

Go Deeper

Reporting, Dashboards and Power BI

Xero and MYOB have good standard reports, but most growing businesses want things they don't provide on their own: figures across several entities, profit by job or customer combined with data from other systems, cash flow looking forward, or a short weekly report that shows the owner what needs attention. When those reports are built by hand in spreadsheets, month-end slows down and people start asking which spreadsheet is correct.

A reporting layer such as Power BI can read your Xero or MYOB data alongside your job, stock, CRM or payroll data, refresh on a schedule and show everyone the same numbers. The quality of the report depends on the quality of the structure underneath: a consistent chart of accounts, tracking categories used the same way, and jobs or projects coded properly. Fixing those first is often the bigger part of the work.

Keep dashboards small: the few numbers that show whether the business is on track, with detail available when needed. Work-in-progress (WIP) reporting for builders and professional services firms is a common example, because the accounts alone rarely show how far through each job you are compared with what has been billed.

Go Deeper

Outgrowing Xero or MYOB: Exo, Acumatica and NetSuite

Some businesses genuinely outgrow Xero or MYOB AccountRight. The signs are usually what has been bolted on around the accounts: several entities that need real consolidation, complex stock or manufacturing, or a pile of apps and spreadsheets holding the business together. Before moving up, check whether connecting what you already have would fix the problem more cheaply.

When moving up is right, the common options include MYOB Acumatica (renamed from MYOB Advanced in 2024) and NetSuite, with SAP Business One and Pronto among the alternatives. These are bigger projects than an accounting move: data migration, rebuilt integrations, reporting and changes to how people work all need planning.

MYOB Exo users have a specific decision. MYOB has announced the retirement of Exo Payroll, while saying in its April 2026 software lifecycle article that Exo Business remains fully supported, though it is being supplanted by newer cloud products. Confirm the dates for your licence with MYOB. Some businesses will move payroll and keep Exo Business for now; others will plan a move to MYOB Acumatica or another system. Another option for some is ERPNext running operations such as stock, manufacturing and projects alongside Xero or MYOB, which keep the accounts.

Go Deeper

Where to Start

Find the line that sounds most like your business today and start there.

  • If you are deciding between Xero, MYOB or QuickBooks: Read Xero vs MYOB first, then Xero vs QuickBooks if QuickBooks is on the list. Xero vs MYOB
  • If you have one company file and want to switch systems: Compare the conversion services, clean your data, and have your accountant check the trial balance. Jet Convert vs MMC Convert
  • If you are moving and other systems feed the accounts: Plan the reconnection before the switch date, not after. Accounting data migration
  • If an integration has stopped syncing: Keep a list of what has not synced, then check for a vendor-side change. Integration repair
  • If someone retypes invoices or costs into Xero or MYOB: Check the marketplace first; if no app fits, look at a custom connection. Integration consulting
  • If you run several entities and build group numbers in a spreadsheet: Line up the charts of accounts, then add a consolidation layer. Multi-entity reporting
  • If month-end reports take days and people argue about the numbers: Start with the few numbers that matter, then build the report on clean structure. Reporting dashboards
  • If you are on MYOB Exo or feel you have outgrown your accounts: Read the Exo options and the outgrowing guide before you choose a new system. Outgrowing Xero or MYOB
  • If you know something is wrong but not what to fix first: Our Process & Systems Audit maps your processes and systems and gives you a written report. $5,000 Process & Systems Audit

How Kenomont Helps

Kenomont is a small, founder-led data and systems consultancy. Aaron Chambers has more than 20 years of experience connecting business systems, and we work with businesses across Australia remotely. We work on the parts around your accounting software: migrations between accounting systems, Xero and MYOB integrations, repairing integrations that have stopped, multi-entity reporting and reporting dashboards.

We work alongside your accountant, bookkeeper or software partner rather than replacing them. Decisions about the books stay with the people who know them; we handle the data, the mapping and the connections, and hand back something they can check. If a marketplace app or a standard conversion tool will do the job, we will tell you, even though it means less work for us.

Every job is scoped and given a fixed quote after a free initial chat. If you know things aren't working but aren't sure what to fix first, our $5,000 Process & Systems Audit maps your processes and systems and gives you a written report with what to fix, in order.

Frequently Asked Questions

Either can work well. Xero suits businesses that want a large choice of add-on apps and an accountant or bookkeeper who already works in it. MYOB suits businesses that want payroll and accounts from one Australian vendor, or that already run MYOB well. The bigger question is usually what sits around the accounts: your job, stock, CRM and payroll systems, and whether they connect cleanly. Our Xero vs MYOB comparison goes through the differences in plain English.

Yes, but the start of a financial year or a BAS quarter is the cleanest time to switch, because it keeps reporting periods simple. Mid-year moves need more care with payroll year-to-date figures and conversion balances. Your accountant or bookkeeper should agree the switch date and sign off the opening balances.

For a single company file with one currency and nothing much connected to it, often yes. Use the tool and have your bookkeeper or accountant check the trial balance. You need more help when the tool turns your file away, when you run several entities, or when job, stock, CRM or payroll systems feed into the accounts and have to be reconnected and tested.

First check whether anything changed on the vendor side. MYOB has retired the broad API permission many older integrations relied on, and Xero changed its pricing for app developers in March 2026, so some connections need re-authorising, code changes or a different app. Keep a list of what has not synced since it stopped, so nothing is missed once it is fixed. We diagnose broken integrations and give a fixed quote for the repair.

No. Many connections are handled by marketplace apps that a bookkeeper or office manager can set up. Where no app fits, for example a job system, weighbridge, production system or custom database, we build and look after the connection. You need someone who knows how the business runs to tell us what should happen.

Not well inside the accounting software alone. Each entity is a separate file or organisation, so a group view usually means a consolidation tool or a reporting layer such as Power BI that reads every entity, maps the accounts to one structure and handles intercompany items. That gives you one set of group numbers without a month-end spreadsheet.

It can. With super due much closer to each pay day, any delay between timesheets, pay runs and super payments now shows up quickly. If timesheets come from a job or rostering system, check that the data reaches payroll on time and that super is paid through a method that keeps up with each pay run.

Every job is scoped and given a fixed quote after a free initial chat. What drives the cost is how many entities you have, how many systems connect to the accounts, and how much history and reporting is involved. If you are not sure what needs fixing first, our $5,000 Process & Systems Audit maps your processes and systems and ends in a written report.

Working Out Your Next Step With Xero or MYOB?

Tell us what you run and what isn't working. We'll tell you honestly whether it's something you can sort out with an app or your bookkeeper, or where we can help. Or call 1300 470 091.

Free initial chat. No sales pressure - if we're not the right fit, we'll say so.

Prefer to talk? Call 1300 470 091

Got a spec or files? Email [email protected]

Name, email and message are required. We'll respond within 24 hours.

See also