By Terry Bennett | 10 December 2025
Switching to Xero should be a fresh start for your finances - not the beginning of a six-month cleanup. But conversion balances are where most Xero setups go sideways, and it usually comes down to one of three mistakes: picking the wrong conversion date, bringing in the wrong level of detail, or not thinking about what your chart of accounts needs to look like going forward
We do a lot of Xero conversions at Digit. From MYOB, from Reckon, from QuickBooks, from Sage, from spreadsheets held together by hope and a colour-coded tab system. And the conversation almost always starts the same way: "We just want everything moved across."
That instinct makes sense. You don't want to lose anything. But "everything" is usually the wrong answer - and the businesses that end up with the cleanest Xero files are the ones who treat conversion as a chance to think about what they actually need, not just a data migration exercise
What conversion balances actually are
Your conversion balance is a snapshot of your financial position on the day before you start using Xero. Think of it as a photo of the scoreboard at halftime. It tells Xero what the score was so it can keep counting from the right number
Without it, your bank balance in Xero starts at zero. So if you had $47,000 in the bank on your conversion date and then received a $2,000 payment, Xero would show $2,000 - not $49,000. Every report you run from that point is wrong
The conversion balance covers your full trial balance including bank accounts, accounts receivable and payable, GST liabilities, loan balances, equity, fixed assets - everything on your balance sheet. It also includes any outstanding invoices and bills that were unpaid at conversion, because those individual documents need to exist in Xero for you to match payments against them later
Picking a conversion date
This is the first decision, and it affects everything that follows. Your conversion date is the day Xero "starts" - every transaction from that date forward lives in Xero
Best practice is to align your conversion date with the start of a financial year. In Australia, that's 1 July. If you can't wait for a financial year, the next best option is the start of a BAS quarter such as 1 October, 1 January, or 1 April. Failing that, the start of any month
Why does this matter? Two reasons
First, comparative reporting. If you convert on 1 July, your first full year in Xero gives you a clean year-on-year comparison the following July. Convert on 15 March, and your first "year" of data is actually nine and a half months. Every report you run for the next 12 months has an asterisk on it
Second, GST. If you convert mid-quarter, you've got transactions for that Business Activity Statement (BAS) period split across two systems. Your old system has January and February, Xero has March. You'll need to manually reconcile the GST across both, finalise activity statements in Xero for periods you didn't actually use Xero for, and make sure nothing gets double-reported to the ATO. It's doable, but it's fiddly work that's entirely avoidable if you convert at the start of a quarter
I've seen businesses convert on random dates - the 14th of a month, a Wednesday in the middle of a BAS period - because they were excited to get started. The excitement wears off pretty quickly once you're trying to reconcile GST across two systems while your accountant asks uncomfortable questions about why the numbers don't match
The chart of accounts question
Here's where it gets interesting. Most businesses converting to Xero are also cleaning up their chart of accounts, whether they realise it or not
MYOB files, especially ones that have been running for a decade, tend to accumulate accounts like a kitchen drawer accumulates takeaway menus. You'll find three separate accounts for motor vehicle expenses because someone created a new one instead of finding the existing one. Accounts with names like "Misc Expenses 2" that nobody can explain. Revenue accounts split in ways that made sense to whoever set it up in 2014 but don't reflect how the business operates now
Xero gives you a chance to fix this. But - and this is the critical bit - you need to decide on your new chart of accounts before you enter conversion balances, not after
If you restructure your chart of accounts after entering conversion balances, the balances won't automatically redistribute to the new accounts. You'd need to re-enter them. And if you've already started transacting in Xero, you've got a mess on your hands because you can't change the conversion date once transactions have been recorded after it
So the process is to design your new chart of accounts first, then map your old accounts to the new ones, then enter your conversion balances against the new structure
Mapping old accounts to new ones
This is the part that takes the most thought. You're essentially deciding where every dollar from your old system sits in the new one
Say your old MYOB file has three separate expense accounts for vehicle costs including "Motor Vehicle - Fuel", "Motor Vehicle - Rego & Insurance", and "Motor Vehicle - Repairs". In Xero, you might consolidate these into a single "Motor Vehicle Expenses" account and use tracking categories to separate the cost types if you need that level of detail
Or you might keep them separate. The point is that you're making a deliberate choice, and the conversion balance for each new Xero account is the total of whichever old accounts map to it
For a trades business we converted last year, the old MYOB file had 187 accounts. The new Xero chart of accounts had 64. That's not unusual. Most small businesses need far fewer accounts than they think - and Xero's tracking categories can do a lot of the heavy lifting that people traditionally solved by creating more accounts
The practical mapping exercise looks like this. Export a trial balance from your old system as at the day before your conversion date. Put it in a spreadsheet. Add a column for the Xero account each old account maps to. Sum the balances by Xero account. Those summed balances are what you enter in Xero's conversion balance screen
What happens to historical comparisons
If you restructure your chart of accounts, your historical data from the old system won't line up with Xero's reports. That's expected. You can't run a comparison in Xero that says "Revenue was X last year" if last year's revenue was spread across differently named accounts in MYOB
Xero handles this through comparative balances, which you can enter after the initial conversion. These are summary totals - not transactions - for prior financial years. You enter them against your new chart of accounts structure, which means you're manually translating last year's numbers into this year's account categories
You can add multiple years of comparatives. But keep in mind these are just totals - they give you high-level year-on-year comparisons, not transaction detail. For the full detail, you'd need to go back to your old system
One thing to flag here is that Xero only lets you enter comparative P&L data at the annual level through conversion balances. You can't enter monthly comparatives through the standard conversion balance screen. If you need monthly historical P&L data in Xero (for example, to compare this January against last January), you'd need to journal those entries manually or use a conversion service that imports transactions rather than just balances
How much history to bring in
This is the biggest strategic decision in the whole process, and it depends entirely on what you need from your Xero file
Option 1 - balances only
You enter the conversion balance as at your conversion date and start fresh. No historical transactions in Xero at all. Your old system becomes the archive for anything before the conversion date
This is the simplest approach and works well for businesses that don't need to run Xero reports against historical periods. The downside is that you can't compare this quarter's revenue to last quarter's in Xero - you'd need to pull up the old system for that. But comparative balances (entered as annual totals) can bridge some of this gap
Option 2 - full transaction history
Some businesses want every historical transaction in Xero. Every invoice, every bill, every bank transaction going back years. This gives you full reporting history in one system, which is genuinely useful if you rely on trend analysis or need to look up old customer transactions regularly
The trade-off is that it's significantly more work, especially if you're changing the chart of accounts at the same time. Every transaction needs to map to the new account structure. Conversion services like Jet Convert can automate this, but even automated conversions have limitations - line item descriptions might not carry across perfectly, custom tax rates need manual adjustment, and multi-currency transactions can lose their original exchange rates
A full transaction import also means your bank reconciliation in Xero needs to account for transactions that have already been reconciled in the old system. If the conversion service handles this (Jet Convert does), it's seamless. If you're doing it manually, it's a significant time investment
The middle ground
Most businesses we convert land somewhere between these two extremes. They bring in conversion balances plus 12 months of comparative data, enter all outstanding invoices and bills individually so they can track who owes what and what they owe, and accept that anything older lives in the old system
This gives you enough history for meaningful reporting without the complexity of a full transaction import. And it keeps the Xero file clean from day one
The detail that catches people out - outstanding invoices and bills
Your conversion balance includes a total for accounts receivable (what customers owe you) and accounts payable (what you owe suppliers). But those totals aren't enough on their own
You need to enter each outstanding invoice and bill individually as historical transactions in Xero. The reason is straightforward - when a customer pays invoice #1047 next month, Xero needs to know that invoice exists so it can match the payment to it. If all you have is a lump sum in accounts receivable, there's nothing to match against, and your debtor reports, your aged receivables, and your payment reminders won't work
This is one of the most commonly skipped steps. People enter the conversion balance, see that accounts receivable shows the right total, and assume they're done. Then three weeks later they can't figure out why Xero won't let them allocate a customer payment to an invoice
The historical invoices and bills need to be dated before your conversion date, and their total must match the corresponding line in your conversion balance. If your accounts receivable conversion balance is $23,500, the total of all your historical invoices needs to add up to $23,500. If they don't match, Xero adjusts the conversion journal to compensate - which creates a discrepancy that's hard to track down later
Same logic applies to prepayments and overpayments from before conversion. If a customer overpaid an invoice and had a credit balance, that needs to be entered as a historical prepayment. If you paid a supplier deposit that hasn't been applied to a bill yet, same thing. Miss these and you'll spend weeks figuring out why your bank reconciliation is off by $1,200
Tracking categories and conversion balances
Here's a limitation that surprises people - Xero doesn't support tracking categories on conversion balances
If you use tracking categories to separate departments, locations, or projects, your opening balances in Xero won't have tracking attached to them. This means your first month's reports filtered by tracking category will show the month's transactions but not the opening position
The workaround is to skip the conversion balance for accounts you need tracked, and instead enter the opening balance as a manual journal with tracking applied. It works, but it's fiddly - you need to make sure the journal date is the day before your conversion date, and that the amounts don't duplicate what's in the conversion balance screen. Some accountants set up temporary clearing accounts to bridge the gap between the conversion balance and the tracked journals
If tracking is critical to your reporting (and for businesses with multiple locations or cost centres, it usually is), factor this workaround into your conversion plan from the start. It's much easier to set up correctly the first time than to retrofit tracking onto an existing conversion
GST on conversion balances
If you're registered for GST, your conversion balance needs to include the GST liability (or asset) as at conversion date. This is the net GST you've collected minus the GST you've paid, for the current BAS period up to your conversion date
But here's the thing - conversion balances in Xero are entered exclusive of GST. The individual amounts against each account should be the net (ex-GST) amounts. The GST balance sits in the GST account as a separate line
Where it gets complicated is the historical invoices and bills. These do include GST, because they're actual transaction documents. When you enter a historical invoice for $1,100 (including $100 GST), Xero records the GST component. This GST needs to be accounted for in your first BAS in Xero
If you convert at the start of a BAS quarter, this is clean - all GST in Xero relates to transactions within the current BAS period. If you convert mid-quarter, you need to finalise the activity statements in Xero for the pre-conversion portion of the quarter (even though those transactions were in the old system) to keep your GST reconciliation correct. Xero has a process for this - you publish the pre-conversion activity statements without lodging them with the ATO, since you already lodged from the old system
It's not hard once you understand the process. But if nobody tells you, you'll discover it three months later when your GST reconciliation report shows a variance that nobody can explain
The bank balance test
Once you've entered everything including conversion balances, historical invoices, historical bills, and any prepayments, there's a simple test to confirm it's right
Check that the bank balance in Xero matches the actual bank statement balance on your conversion date. Not the day after. Not approximately. Exactly, to the cent
If it doesn't match, something is wrong. Common causes include the conversion balance being taken from the wrong date, a bank transaction recorded after the conversion date that should have been before it, or an outstanding cheque or pending transfer that was missed
This is the first thing we check on every conversion, and it catches problems before they compound. A $200 bank balance discrepancy on day one becomes a $200 mystery you're still trying to solve six months later
When to get help
Setting up conversion balances correctly isn't technically difficult - it's conceptually detailed. There are a lot of moving pieces that need to agree with each other, and the consequences of getting it wrong show up weeks or months later when reports don't balance and nobody can remember what happened at conversion
If your old system is relatively clean, your chart of accounts isn't changing much, and you're converting at the start of a financial year, you can probably handle conversion balances yourself with Xero's built-in tools and a trial balance from your old system
If your old system is messy, you're restructuring the chart of accounts, you need tracking categories on opening balances, you're converting mid-year, or you have multi-currency transactions - get a bookkeeper or accountant involved. The cost of professional help at conversion is a fraction of the cost of cleaning up a botched conversion six months in
We've converted businesses from pretty much everything into Xero - MYOB, Sage, QuickBooks, Reckon, AccPac, Agrimaster, Wave, and more than a few Excel files that made us question our career choices. The accounting platform matters less than the quality of the data and the thought that goes into how it's restructured for Xero
The conversion is the foundation. Get it right and everything built on top of it including your BAS, your reporting, and your cashflow visibility just works. Get it wrong and you're troubleshooting reconciliation variances for months
If you want a hand with your conversion, get in touch. We'll take a look at what you've got and tell you what's involved
