November 13, 2026
QuickBooks Desktop average cost vs Online FIFO: what happens to inventory value when you migrate
The short answer: QuickBooks Desktop Pro and Premier value inventory at average cost; QuickBooks Online uses FIFO (first in, first out). When you move a Desktop file to Online, inventory starts fresh on the migration date and Online recalculates cost from there using FIFO. So the stock value and cost of sales after the move will not follow the numbers Desktop would have produced. Choose the inventory start date deliberately, because Intuit says it can’t be changed once set, and agree the change of costing method with your tax adviser before you migrate.
The rules below are from Intuit’s own help articles on moving inventory from Desktop to Online and on what changes when you switch, read in November 2026. Intuit’s US and Canadian articles say the same things on the points below.
Average cost vs FIFO in one example
Intuit’s inventory article puts it plainly: QuickBooks Online uses FIFO, QuickBooks Pro and Premier use average cost, and QuickBooks Enterprise can use either. The difference shows up as soon as purchase prices change. Illustrative numbers, any currency:
- You buy 10 units at 10 each, then 10 more at 14 each. You hold 20 units that cost 240.
- You sell 12 units.
- Average cost (Desktop Pro/Premier): every unit costs 12, so cost of sales is 144 and the 8 left are worth 96.
- FIFO (Online): the first 10 sold cost 10 each and the next 2 cost 14, so cost of sales is 128 and the 8 left are worth 112.
Same purchases, same sales, a 16 difference in profit and in stock value. Neither method is wrong. The problem is switching between them partway through without knowing which numbers moved, and why.
What happens to inventory when the file moves
Intuit’s switching guide (updated 5 November 2026) says inventory starts fresh on your migration date, and that QuickBooks Online recalculates inventory using FIFO from that date and records any adjustments. In practice:
- Accrual-basis reports should match Desktop, according to the same guide; cash-basis reports may differ.
- Inventory needs Plus or Advanced. Intuit says inventory tracking is only included in QuickBooks Online Plus and Advanced. Migrate into a lower plan and you lose quantity tracking.
Item types change too. The guide says inventory parts become inventory items and non-inventory parts become non-inventory items. Assemblies become single inventory items on sales transactions, and group items become bundles, which aren’t tracked as inventory. If you build products from components, they won’t behave as Desktop assemblies did. Plan how you will record builds before go-live.
The start date you can’t change
During the move you set an inventory start date. Intuit is firm on two points. Once you set it, you can’t change it, and you can’t edit any transactions before it. Its recommendation is the first day after your company’s last tax filing period.
That recommendation makes sense in any country. Your filed returns were prepared on average cost, so the switch to FIFO should start in a period nobody has reported yet. Picking a date inside a period that has already been filed means re-explaining old numbers. Picking one far in the future leaves Desktop-era transactions you still need to correct locked out.
The tax side: a change of method
Moving from average cost to FIFO is a change in how inventory is valued. Intuit’s US article says you’ll need to file IRS Form 3115 for the tax year you first use the new method, and tells you to consult your tax adviser or accountant. That form is US-specific.
Outside the US the details differ. Australia, the UK, Canada and the Gulf each treat inventory valuation and changes in method under their own rules, and Intuit’s articles don’t set them out country by country. Take this example and your current stock valuation report to your adviser before the move. Ask whether the change needs disclosing, and in which period.
A sequence that keeps the numbers explainable
- Clean up quantities first. Negative stock carries straight across. Fix it in Desktop using our guide to negative inventory before migrating.
- Agree the start date with your adviser: normally the first day after your last filed period.
- Save Desktop’s reports at that date: Inventory Valuation Summary, Inventory Asset on the balance sheet, and stock status by item.
- Decide how assemblies and groups will work in Online before go-live, not after the first build.
- After the move, compare quantities item by item and the Inventory Asset balance. Explain any difference as the FIFO recalculation, a cash-basis report effect, or a real error. Our five reports to test after a Desktop move covers the rest of the tie-out.
Still deciding which way to go? What doesn’t convert lists the other items that need a plan.
FAQ
Can QuickBooks Online use average cost?
No. Intuit’s help article says QuickBooks Online uses FIFO. Pro and Premier use average cost, and Enterprise can use either.
Will my inventory value change after I move from Desktop to Online?
It can. Intuit says inventory starts fresh on the migration date, and Online recalculates it using FIFO from that date and records any adjustments. Where purchase prices changed, FIFO and average cost give different values.
Can I change the inventory start date later?
No. Intuit says the start date can’t be changed once set, and transactions before it can’t be edited. It recommends the first day after your last tax filing period.
Related service: QuickBooks Desktop to Online conversion