- Home
- QuickBooks automation
- QuickBooks inventory
QuickBooks inventory: Intuit lists FIFO only, no serial numbers, no stock locations
QuickBooks Online can track inventory, but only in some editions and only in a simple way. Intuit's developer guide lists what it supports: FIFO costing, quantity on hand and up to four levels of item categories. It also lists what it does not: LIFO or average cost, serial numbers and separate stock locations. If you need those, the stock lives in another app or an ERP, and QuickBooks keeps the accounting.
QuickBooks Online tracks stock simply, in some editions
QuickBooks Online inventory works, within limits Intuit writes down. Intuit’s developer guide says some versions of QuickBooks Online have no inventory features. Where they exist, they start switched off. Intuit’s guide advises asking users to change those settings themselves, rather than having an app do it.
Intuit’s developer guide sorts QuickBooks Online inventory features into supported and not supported:
Scroll the table sideways to see every column.
| Inventory feature | In QuickBooks Online |
|---|---|
| FIFO inventory accounting | Supported |
| LIFO or average cost | Not supported |
| Tracking quantity on hand | Supported |
| Tracking single units, such as by serial number | Not supported |
| Up to four levels of item categories | Supported |
| Tracking by different stock locations | Not supported |
FIFO means first in, first out: the oldest units are treated as sold first. Separately, Intuit’s guide says QuickBooks tracks quantity on hand, cost of goods sold and total stock value.
We could not read Intuit’s help pages for the screen steps, because quickbooks.intuit.com refuses our fetch tool. This page covers what Intuit’s developer guide says.
Each inventory item needs three accounts and a unique name
An inventory item is one of four item types: inventory, non-inventory, service and bundle. Intuit’s guide says every inventory item links to three accounts:
- Income account. It tracks money from sales, and its type must be Sales of Product Income.
- Cost of goods sold account. It tracks what the stock cost you, and its type must be Cost of Goods Sold.
- Inventory asset account. It tracks the value of what is on the shelf.
The name must be unique across all items, so an import should search by name first. Intuit’s FIFO page warns that a wrong starting cost or quantity puts a wrong value in the inventory asset account.
Stock moves when bills and sales are recorded
Quantity on hand changes as transactions are saved. Intuit’s guide says that once goods arrive from a vendor, QuickBooks updates quantity on hand, as long as the purchase was recorded as a bill or an expense. Sales on invoices and sales receipts take stock out.
FIFO shows up in reports in a way that surprises people. When one sale draws on two batches bought at different costs, a transaction report shows two lines for that sale. Intuit says this is intended, and the totals are right.
Our team has run bookkeeping, inventory sync, order sync and invoicing in QuickBooks.
Intuit’s adjustment API fixes counts on one site only
Counts drift, and Intuit has an API for fixing them. Its Inventory Adjustment endpoint changes quantity for reasons such as a stock take, a write-off, customer returns, a transfer or manufacturing. Intuit says it is available on QuickBooks Online Plus and Advanced in the US.
The rules are tight:
- Quantity only. An adjustment changes how many units you hold. It cannot change their value.
- Primary site only. Multi-site stock is not supported, and neither are class or location tags.
- Partial updates only. A change must send only the fields that change.
- No edits to the date. The transaction date cannot be changed later.
- Closed books stop it. Once the books are closed, no adjustment can be made, in the screen or through the API.
Your team can check the result in QuickBooks’ Inventory Valuation reports. Our QuickBooks reporting page lists the report endpoints an app can read.
Bundles and categories have their own API limits
Two item features behave differently through the API. Bundles, which group items sold together, can only be read and queried through the API. They have to be created and changed in the QuickBooks screen. Intuit’s API docs say bundles are not supported on purchase transactions. Categories need two API calls for a new item in a new category: one for the category, one for the item.
Sales orders sit beside inventory, and an invoice can link back to one. Intuit says they work on Plus, Advanced and Intuit Enterprise Suite, and on Simple Start and Essentials only with the Inventory Add-on. The Sales Order API is for restricted use for now.
When stock lives in another app, QuickBooks keeps the books
Many companies keep stock outside QuickBooks. Intuit’s guide describes two ways to link an app:
- QuickBooks has inventory turned on. The app syncs its items with QuickBooks’ own inventory items.
- QuickBooks does not. The app manages stock itself and sends only the accounting to QuickBooks.
The second route fits when you need serial numbers or several stock sites, since QuickBooks tracks neither. Our Shopify and QuickBooks integration page covers that pairing. Supplier orders that feed stock are on our QuickBooks purchase orders page.
Signs your stock has outgrown QuickBooks
The gaps in Intuit’s table are the signs. You need serial numbers, stock in several warehouses or a costing method other than FIFO.
If you are weighing a move, start with ERP consulting or AI for distribution.
What a food plant needs beyond Intuit’s table
A food plant also needs to know which batch stock came from and when it expires. Intuit’s table does not list either. In an ERPNext rollout for a food processor that had kept its accounts in Tally and spreadsheets, our team put batch tracking, expiry dates, yield reports and lot tracing in the same system as buying and stock. See our case study of an ERPNext rollout.
Questions
Does QuickBooks Online support inventory management?
Yes, in some editions, and it is off until you turn it on. Intuit's developer docs say inventory features are not on by default, and that some versions of QuickBooks Online do not support inventory at all. Intuit's Inventory Adjustment API works on Plus and Advanced in the US. Where it is on, QuickBooks tracks quantity on hand, cost of goods sold and total stock value.
Is QuickBooks a good inventory system?
It suits simple stock. Intuit's own table says QuickBooks Online costs stock first in, first out, and does not support LIFO or average cost. It cannot track single units by serial number or keep stock in separate locations. Intuit's Inventory Adjustment API works on the primary site only. If any of those matter to you, plan for a stock app or an ERP alongside or instead.
Is there a free inventory management system?
QuickBooks has a free plan, with tight limits. When we read Intuit's pricing page on 10 October 2026, QuickBooks Free allowed 1 user, no accountant access and no third-party integrations. Open-source ERPs are another route. Our ERPNext page calls ERPNext a free, open-source ERP. Our case study of a food processor's rollout says "We chose ERPNext because it is a full ERP, built in modules, with no license fee to pay."
Why are people leaving QuickBooks?
We can only point to the limits Intuit publishes, not a survey. For stock, Intuit's developer guide lists no serial numbers, no separate stock locations and FIFO costing only. Intuit's Inventory Adjustment API covers the primary site only, and no adjustment can be made once the books are closed. Our team has moved companies off QuickBooks, Xero or Sage into a full ERP.
What is the best system for inventory management?
We don't rank systems, because the answer depends on your stock. Start from the gaps in Intuit's own table: serial numbers, stock locations and costing method. If QuickBooks covers what you track, add an app or a link. If not, compare ERPs. Our team has taken NetSuite, Odoo, Sage, SAP, Microsoft Dynamics, ERPNext and custom ERPs live.
How do we add inventory to QuickBooks with the API?
Turn inventory on first, then create an item of type Inventory. Intuit's guide says the item needs an income account, a cost of goods sold account and an inventory asset account. Set TrackQtyOnHand to true and give a starting quantity. Item names must be unique, so search by name before you create one. A wrong starting cost gives a wrong stock value.
Sources
Every source behind a figure or a vendor fact on this page, with the day we read it.
- Intuit Developer, create products, services and inventory itemsRead 18 Nov 2026
- Intuit Developer, items and inventory in QuickBooks OnlineRead 18 Nov 2026
- Intuit Developer, inventory cost accounting (FIFO)Read 18 Nov 2026
- Intuit Developer, inventory adjustmentRead 18 Nov 2026
- Intuit Developer, item hierarchies using categoriesRead 18 Nov 2026
- Intuit Developer, item bundles using groupsRead 18 Nov 2026
- Intuit Developer, implement inventory featuresRead 18 Nov 2026
- Intuit Developer, manage sales ordersRead 18 Nov 2026
- Intuit, QuickBooks pricing pageRead 10 Oct 2026
Talk through where your stock should live
Bring your QuickBooks Online plan, how many items and stock sites you run, and the store or warehouse system that holds stock today. On the first call we go through what QuickBooks can track and where it stops. The first call is free.