Migrate balances, not history. Pick a conversion date, bring the trial balance across as an opening journal, keep the QuickBooks file readable for the prior years, and start clean in Xero from day one of the new period. Sellers who try to replay three years of marketplace transactions into a new ledger spend six weeks on it, arrive at numbers that do not match the old file, and lose confidence in both systems. The checklist below assumes the balances approach.
Pick the conversion date. The first day of a fiscal year is easiest. The first day of a quarter is acceptable. Mid month is a choice you will regret at the first reconciliation.
Close the final QuickBooks period properly. Reconcile every bank and credit card account through the conversion date. Clear anything sitting in undeposited funds. Resolve any suspense or ask my accountant account to zero. A balance you cannot explain in QuickBooks becomes a balance you cannot explain in Xero, only now it has no history behind it.
Archive the reports you will want later. Export and save, as PDF and as CSV: trial balance, balance sheet, profit and loss for each of the last three fiscal years, the general ledger detail for the final year, the AR and AP aging, the inventory valuation summary, and the sales tax liability report. Do this while you still have a live subscription.
Decide what happens to the QuickBooks subscription. Most sellers keep it read only for a year. Budget for that rather than discovering the need after cancellation.
Chart of accounts. Do not import the QuickBooks chart as is. Rebuild it around the structure a multichannel seller needs: separate revenue, shipping income, discounts, and refunds; direct costs split between cost of goods sold, marketplace commissions, fulfillment, and processing; clearing accounts per channel. Import the finished list as a CSV so codes and account types are set in one pass.
Tracking categories. This is where classes and locations go. Intuit's published usage limits cap combined classes and locations at 40 on QuickBooks Online Plus, unlimited on Advanced, with the chart of accounts capped at 250 accounts below Advanced. Xero's tracking documentation allows two active categories with up to 100 options each. A QuickBooks Plus file running 12 classes for channels and 5 locations for warehouses maps cleanly: two Xero categories, one with 12 options and one with 5.
Where it does not map cleanly is a QuickBooks Advanced file using three or more dimensions. Xero gives you two. Decide now which dimension moves into the inventory system rather than discovering it after conversion.
Sales tax rates. Set these up before any transaction exists. Rates attached to accounts default onto every line coded there, and fixing that later means editing transactions.
One journal, dated the day before your conversion date, carrying the closing trial balance from QuickBooks. For a seller converting on 1 January:
Debits total 765,470. Credits total 765,470. If yours does not balance, the problem is in the QuickBooks file and it will not improve by being moved.
Two of those lines deserve attention. Marketplace Settlement Clearing at 31,880 means there were payouts in flight at year end, and you need to know which ones so they clear correctly in Xero in January. Inventory in Transit at 68,400 means there is a container you own that has not been received, and it has to exist in the inventory system as well as the ledger.
The opening journal gives you a total for Accounts Receivable and Accounts Payable. It does not give you the individual invoices and bills, and you need those to apply payments.
Enter open sales invoices and open supplier bills individually, coded to a suspense account rather than to revenue or expense, so they do not double count against the balances already in the opening journal. When the last one is entered, the suspense account should equal the AR and AP figures from the journal, and you reverse it out. This is fiddly and it is the correct way to do it.
QuickBooks Online applies first in, first out, per Intuit's inventory valuation documentation. Xero's tracked items use an average cost method. Those are different models, and item level cost history does not carry across in a way that preserves either one.
What you do instead:
That last point is the fork in the road. If Xero's tracked items are going to own inventory, you are accepting average costing and the 4,000 item ceiling Xero states on its inventory page. If an inventory layer is going to own it, load the units there with their FIFO cost layers intact, and let it post cost of goods sold, shrinkage, and adjustment entries into Xero. For a seller with multiple warehouses, bundles, or imported goods, the second path is the one that survives contact with a real month.
Connect the channels after the opening balances are in and before the first settlement of the new period lands. Then post one settlement end to end by hand, in parallel with the automation, and compare. Every mapping error you are going to have shows up in that first comparison, and fixing it once is cheaper than fixing it across a quarter.
The integrations directory lists the supported channel and ledger combinations, and the Xero integration page covers what arrives in the ledger.
Run one full month in both systems. Not three, which nobody sustains, and not zero, which is how conversion errors reach a tax return.
At the end of the month, compare four things: cash balances by account, revenue by channel, inventory value, and the trial balance. Differences are expected in the details and unacceptable in the totals. Chase every total level difference to a cause before you stop the parallel run.
It is not an opportunity to fix your accounting. Migrate the numbers you have, then fix the process going forward. Sellers who try to restate prior periods during a conversion end up unable to explain why the new file disagrees with the old one, and that disagreement is the thing that erodes trust in the books.
It is also not a fix for bad marketplace data. If your QuickBooks file recorded payouts as revenue, the same habit in Xero produces the same wrong answers in a different font. The structural work is settlement level recording, clearing accounts, and SKU level cost of goods sold, and it is the same work in either ledger.
For the Desktop and Enterprise side of this decision, see the QuickBooks integrations page. For how ConnectBooks handles reconciliation accuracy, see the accuracy guarantee, or walk a conversion with someone on a demo.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
