Xero to QuickBooks: Handling Inventory and Fixed Assets

Most of a Xero to QuickBooks Online migration is routine. Contacts move, the chart of accounts maps across, and historical transactions convert through supported tools. Then you hit the two areas that trip up almost every migration: inventory and fixed assets.

These are the items automated conversion handles least well, and the ones where a small mistake distorts your balance sheet and tax position. This guide explains why they are hard and how to move both cleanly.

Why inventory and fixed assets are different

Ordinary transactions are self contained. An invoice is an invoice in either system. Inventory and fixed assets are different because they carry running calculations. Inventory holds a valuation that depends on cost method and purchase history. Fixed assets hold a depreciation schedule that unwinds over years.

You are not just copying a number. You are moving a calculation that has to stay internally consistent after the move. That is why these two need deliberate handling, not a straight import.

Inventory: the valuation method problem

Here is the detail that catches people out. Xero and QuickBooks Online do not necessarily value inventory the same way.

Xero tracks inventory using the average cost method. QuickBooks Online, on its inventory enabled plans, uses FIFO, or first in first out. These are two genuinely different ways of costing what you sell and what you hold. Because the underlying method differs, you cannot simply lift Xero's cost layers and drop them into QuickBooks and expect them to behave identically.

What this means in practice is that inventory is migrated as a position, not as a history. You establish, at the cutover date, the quantity on hand for each item and the total value of that stock. Those become your opening inventory figures in QuickBooks Online. From the cutover date forward, QuickBooks applies FIFO to new movements.

Forcing a line by line historical rebuild across two different costing methods usually creates mismatches that are hard to explain later. Migrating the on hand position at a clean cutover date is accurate and defensible.

Preparing inventory before you migrate

Do this groundwork in Xero first.

Run a stock on hand or inventory valuation report at your chosen cutover date and save it. This is your reference. Reconcile it against a physical count if you can, because migration is a good moment to correct drift between your records and your actual shelves.

Check that each item is set up the way you want it to appear in QuickBooks, and clean up obsolete or duplicate items so you do not carry clutter across. Note which items are tracked and which are not, because that distinction affects how they are recreated.

Setting inventory up in QuickBooks Online

Confirm your QuickBooks Online plan supports inventory tracking, since this feature sits on the higher tiers rather than the entry level plan. Then create each inventory item with its quantity on hand and value as at the cutover date, matching your saved Xero valuation report.

After setup, your total inventory asset value in QuickBooks should equal the figure from your Xero report at the cutover date. Confirm that before you carry on. If it agrees, your inventory has migrated correctly and FIFO takes over from there.

Fixed assets: the register that does not travel

Fixed assets are the second sticking point, and for a structural reason.

Xero includes a built in fixed asset register. You record an asset, set its depreciation method and rate, and Xero runs depreciation for you on a schedule. QuickBooks Online does not offer the same native, automated fixed asset depreciation module. In QuickBooks, fixed assets are typically tracked through asset accounts, with depreciation recorded by journal entry or managed through a connected third party app.

Because the two systems treat fixed assets so differently, the register does not simply convert. It has to be re established.

Moving fixed assets across

Start in Xero. Export your fixed asset register at the cutover date, capturing each asset's original cost, accumulated depreciation to date, current book value, depreciation method, and rate. This export is your blueprint.

In QuickBooks Online, set up your fixed asset accounts and enter the opening position for each asset: its cost and its accumulated depreciation as at the cutover date, so book value carries across correctly. These opening balances must tie back to your exported Xero figures and to your Trial Balance.

Then decide how to run depreciation going forward. Two common approaches work. You can record depreciation through regular journal entries in QuickBooks, using the schedule you exported from Xero as your guide. Or you can use a dedicated fixed asset app that connects to QuickBooks Online and automates the schedule the way Xero did. For a handful of assets, journals are fine. For a large register, an app pays for itself.

Verify both against your balance sheet

Inventory and fixed assets both sit on your balance sheet, which makes verification straightforward. After migration, compare your QuickBooks Online Balance Sheet at the cutover date to the Xero Balance Sheet you exported.

Your inventory asset value should match. Your fixed asset cost and accumulated depreciation should match, leaving the same net book value. If either is off, trace it now. These are exactly the figures a tax preparer will scrutinise, so getting them right at migration saves real pain later.

A note on data and compliance

Inventory and fixed asset records are less personal than payroll, but a migration still moves a whole file that includes customer and employee information. Standard data protection duties apply throughout. Under frameworks such as Australia's Privacy Act and Canada's PIPEDA, you stay accountable for personal information handled during the transfer, including any cross border processing. Treat this as general guidance and confirm your specific obligations with a qualified adviser.

Get the hard parts right

Inventory and fixed assets are where Xero to QuickBooks migrations most often go wrong, and where the cost of getting it wrong is highest. The method is clear: migrate inventory as an on hand position at a clean cutover date, rebuild the fixed asset register with correct opening cost and accumulated depreciation, choose how you will run depreciation going forward, and verify both against your balance sheet.

Move inventory and assets without the headaches

WOW BookSwitch handles the parts of a Xero to QuickBooks Online migration that automation cannot, including inventory revaluation and rebuilding your fixed asset register with a working depreciation approach. To move these cleanly and verified, talk to our migration team.