How items and inventory data differ across accounting systems

Of all the data in an accounting file, items and inventory differ the most between systems — which is exactly why they’re the hardest thing to move. An “item” looks simple, but each system attaches different structure, valuation and behaviour to it, and those differences are where migrations break.

Item types aren’t universal

Systems classify what you sell differently. QuickBooks distinguishes inventory items (tracked for quantity and value), non-inventory items, service items and others — and the type changes the behaviour entirely. Import an inventory part as a non-inventory item and it won’t track stock or value at all. Matching source item types to the right destination type is step one.

Valuation methods differ

Inventory value depends on the costing method — average cost, FIFO and others — and systems don’t all use the same one, or let you choose. If the source valued stock differently from how the destination will, the values won’t line up without deliberate adjustment.

Quantity and value are separate numbers

Inventory is really three figures that must agree: quantity on hand, its value, and the cost of goods sold when it’s sold. Moving inventory means bringing opening quantity and value across, matched to a valuation report — not just letting items land with blank stock, which is a leading cause of inventory being wrong after an import.

Assemblies, kits and units

Bundled products (assemblies, kits, bills of materials) and units of measure are modelled differently or missing entirely across systems — more places where a one-to-one copy simply can’t work.