QuickBooks Inventory Management: What It Can (and Can't) Do for Manufacturers
Inventory management in QuickBooks works well for businesses that buy finished goods and resell them, and it starts to break down for businesses that build things. QuickBooks Online Plus and Advanced track quantity on hand, reorder points, and cost of goods sold on a FIFO basis, but QuickBooks Online has no true inventory assemblies, no work orders, no material requirements planning, and no location tracking, which are exactly the four things a manufacturer needs most.
This guide covers what QuickBooks inventory genuinely does, how to set it up properly, the six specific places it stops for a manufacturing or job-shop business, and the honest options for closing that gap without ripping out your accounting system.
Ready for inventory that actually tracks your BOMs?
Fabrica ERP adds bills of materials, work orders, and MRP on top of the books you already keep in QuickBooks Online. 999 dollars one time, 14-day free trial, no per-user fees.
What this guide covers
- Which QuickBooks plan has inventory management, and what each one actually tracks
- How to set up and record inventory in QuickBooks Online, step by step
- The six limits manufacturers hit: no assemblies in QBO, no work orders, no MRP, one location, FIFO only, no shop-floor visibility
- Bundles versus assemblies, and why the difference wrecks inventory accuracy in a shop
- A side-by-side comparison of QuickBooks native, QuickBooks plus an add-on, and a full manufacturing system
What QuickBooks inventory management actually does
QuickBooks inventory is a valuation tool first and an operations tool second. Its job is to keep your balance sheet and your cost of goods sold correct as stock moves in and out. Judged on that job it does well, and for a large number of small businesses it is genuinely all that is needed.
On QuickBooks Online Plus and Advanced you get:
- Quantity on hand per item, updated automatically when you record a bill, an expense, an invoice, or a sales receipt against that item.
- Automatic cost of goods sold posting using FIFO, first in first out. QuickBooks Online applies FIFO as a fixed rule and does not offer LIFO or weighted average cost.
- Reorder points with a low-stock notification, so you get told when an item drops below the threshold you set.
- Inventory asset tracking, so the value of stock on hand flows to the balance sheet without a manual journal.
- Purchase orders that can be converted into bills when goods arrive.
- Bundles, which group several products onto one line of a sales form.
- Inventory reports such as Inventory Valuation Summary, Stock Status by Item, and Sales by Product or Service.
QuickBooks Desktop goes further. Premier and Enterprise support Inventory Assembly items, which carry a component list and let you record a build that consumes components and produces a finished good. QuickBooks Desktop Enterprise Platinum and Diamond add the Advanced Inventory feature set, which includes multiple inventory sites, barcode scanning, and serial or lot number tracking. Those are real manufacturing-adjacent capabilities, and they are the reason a lot of older shops are still on desktop.
Which QuickBooks plan has inventory management
Inventory tracking is not available on every QuickBooks plan, and this catches people out at exactly the wrong moment. Here is the current picture.
| Plan | Inventory tracking | Assemblies / BOM | Multi location and barcode |
|---|---|---|---|
| QuickBooks Online Simple Start | No | No | No |
| QuickBooks Online Essentials | No | No | No |
| QuickBooks Online Plus | Yes, FIFO only | Bundles only, not true assemblies | No |
| QuickBooks Online Advanced | Yes, FIFO only | Bundles only, not true assemblies | No |
| QuickBooks Desktop Premier | Yes | Inventory Assembly with component list | No |
| QuickBooks Desktop Enterprise Platinum or Diamond | Yes | Inventory Assembly with component list | Yes, via Advanced Inventory |
Two things are worth flagging before you plan around the desktop column. Intuit stopped selling new subscriptions for several QuickBooks Desktop products in 2024 and has been retiring older desktop versions on a rolling schedule, so building a 2026 manufacturing process on a desktop-only feature is a bet with a known expiry risk. And moving up to Enterprise Platinum or Diamond purely to get warehouse locations is an expensive way to buy one field.
How to record inventory in QuickBooks Online, step by step
If you are on Plus or Advanced and just need the mechanics, this is the whole setup.
- Turn inventory on. Go to Settings, then Account and settings, then Sales, then Products and services. Switch on Show Product/Service column on sales forms, Track quantity and price/rate, and Track inventory quantity on hand. Save.
- Create the item. Go to Sales, then Products and services, then New, then Inventory. Enter the name, SKU, category, initial quantity on hand, the as-of date, and the reorder point.
- Set the accounts. Confirm the inventory asset account, income account, and expense or cost of goods sold account. Getting this wrong at item creation is the most common source of inventory reports that will not reconcile later.
- Record purchases against the item. Use a purchase order, then convert it to a bill on receipt, or enter an expense directly. Quantity on hand increases and the inventory asset account is debited.
- Record sales against the item. An invoice or sales receipt reduces quantity on hand and posts cost of goods sold at the FIFO cost layer.
- Adjust when the count disagrees. Use the Adjust quantity option from the Products and services list after a physical count, and always leave a reason in the memo.
- Review monthly. Run Inventory Valuation Summary and compare it to the inventory asset balance on your balance sheet. If they differ, something was posted to the wrong account.
That process is reliable for buy-and-resell. Everything below is what happens when you start converting raw material into something else.
Where QuickBooks inventory stops for manufacturers
QuickBooks was never designed to run a shop floor, and it is fairer to describe the gaps as scope than as flaws. Here are the six that manufacturers actually hit, in the order they usually hit them.
1. QuickBooks Online has bundles, not assemblies
This is the biggest and most misunderstood one. A bundle in QuickBooks Online groups products together on a sales form so a customer sees one line. It does not consume component quantities and create a new finished-good item in stock. Intuit's own guidance is that inventory assemblies are a QuickBooks Desktop feature. So if you buy 40 dollars of steel, 12 dollars of fasteners, and 8 dollars of coating and build a finished part, QuickBooks Online cannot represent that part as a stocked item whose cost rolls up from its components. You end up either tracking components only and losing finished-goods visibility, or tracking finished goods only and losing raw-material control.
2. There are no work orders anywhere in QuickBooks
Neither QuickBooks Online nor QuickBooks Desktop has a work-order object. There is no record that says this quantity of this product is being built, by this date, for this customer, using these materials, at this stage of production. Shops improvise with a sales order plus a spreadsheet, or a printed job sheet, and the gap between what the spreadsheet says and what the shop is actually doing is where most late deliveries originate.
3. There is no MRP or shortage engine
QuickBooks reorder points fire on a single item in isolation. They do not know that three open jobs collectively need 180 units of a component you have 90 of. Real material requirements planning compares demand across all open work against current stock and tells you what to order. QuickBooks has no concept of committed demand at all, so a reorder point can look perfectly healthy on a part you are already short of.
4. One location, no bins
QuickBooks Online tracks a single quantity on hand per item with no location dimension. If you hold stock in a main store, a mezzanine, and a van, QuickBooks sees one number. Multiple inventory sites exist only in QuickBooks Desktop Enterprise with Advanced Inventory, on the Platinum and Diamond tiers.
5. FIFO only
QuickBooks Online applies FIFO and does not offer LIFO or weighted average cost. For a lot of shops that is fine. For anyone whose accountant expects average costing on commodity raw material, it is a hard constraint worth knowing about before your item list gets large.
6. No shop-floor visibility and no quality trail
QuickBooks has no operator view, no record of which operation started when, and no non-conformance or scrap-disposition tracking. Scrap ends up as an unexplained inventory adjustment, and nobody can answer how much of it was rework versus genuine scrap, or on which product it keeps happening.
Fabrica ERP does everything QuickBooks inventory can't.
Multi-level component lists, a live Material Check that flags shortages before you release a job, a real MRP view, and location and bin on every item. QuickBooks stays your book of record.
How Fabrica ERP handles it
Fabrica ERP is a manufacturing system built on Fuzen, sold as a 999 dollar one-time template with a 14-day free trial and no per-user fees. It is not an accounting replacement. It syncs invoices and customers to QuickBooks Online and maps your product categories to your QuickBooks chart of accounts, so the intended setup is deliberately a split: keep QuickBooks for the books, add Fabrica for the shop.
Here is how it addresses each of the six gaps above.
Inventory with the fields a shop actually needs
The Inventory list carries Name, SKU, Type, Location, Qty on Hand, Reorder Point, and Status, with status badges for In Stock, Low Stock when quantity is at or below the reorder point, and Out of Stock at zero. Every item has a full history log showing date, adjustment type, quantity changed, reason, and which team member made the change. Adjustments take a type of Add or Remove, a quantity, and a reason from Cycle Count, Received Shipment, Damaged or Scrap, or Manual Correction. Worth knowing up front: there is no draft or approval step, so an adjustment updates live on-hand immediately.
A real bill of materials that drives shortage checks
Products in Fabrica can be an Inventory Item, an Assembly, or a Service. An Assembly carries a component table with Component, Qty, Unit Cost, Ext Cost, and In Stock columns, plus a Markup percentage, an auto-summed BOM Cost, and a With Markup figure. The guide's own worked example is a BOM Cost of 664 dollars at 125 percent giving 830 dollars With Markup. This is the thing a QuickBooks Online bundle cannot do, because the BOM is not a sales-form grouping, it is the definition the rest of the system plans against.
The product documentation states the failure mode plainly, and it is worth repeating because it is the entire argument for a real BOM module: if a component is missing from the BOM, it will not appear in the shortage check, and materials will not be deducted from inventory when issued. A BOM is only as good as its maintenance.
Work orders with a material check before you release
Work Orders run on a four-status board: Pending for unscheduled, Planned once scheduled with materials confirmed, Released once approved and materials issued, and In Production once an operation has actually started. Each work order carries an auto-numbered WO reference, priority, start and due dates, an assigned operator, the linked sales order, and an Items to Build table.
The part that matters most is the Material Check, which shows Component, Required, and On Hand, and turns On Hand red when there is not enough. The documented rule is to not issue materials or start production until the shortage is resolved. Issue Materials is a one-way action: inventory deducts immediately, components are marked Issued to Production, and the button hides so the same job cannot be issued twice. Completing a work order automatically advances the linked sales order to Ready to Ship.
MRP that compares demand to stock
The Purchasing and MRP screen uses a three-column model: Demand, the total quantity needed across open work orders and sales orders, On Hand, current inventory, and Available, which is On Hand minus Demand. A negative Available is shown in red and means you need to order. It covers both sales-order demand for finished goods and component availability for raw materials via the BOM.
One honest limitation to plan around: the MRP view reflects the current state of open work orders and live inventory, and it does not auto-generate purchase orders. It flags what is short and you act on it. Re-check it after receiving stock or creating new work orders.
Shop floor and quality, without exposing your pricing
Shop Floor is an operator-only terminal that deliberately excludes pricing and customer data. An operator finds a Released work order, hits Start Operation which flips it to In Production, and later hits Log Completion, which advances the linked sales order to Ready to Ship. Log Completion is irreversible without manager intervention, which is worth training people on.
Quality Control logs non-conformances with a disposition of Rework, Scrap, or Accept as Is, and tracks a scrap rate and rework rate. One caveat to build a habit around: logging a Scrap disposition does not automatically adjust inventory, so a manual inventory adjustment is still required afterwards.
The QuickBooks Online sync
Invoices in Fabrica push to QuickBooks Online as invoices, and customers sync with a Sync to QBO button. Three mechanics are worth knowing before you set it up. Sync after the invoice is finalized rather than on creation, because amounts and customer details need to be confirmed first. Post-sync edits do not auto-push, so if you change a synced invoice you must re-sync it manually. And Product Groups, which map your product categories to QuickBooks income, asset, and cost of goods sold accounts, must use account names that match your QuickBooks chart of accounts exactly, including capitalisation, or the sync errors.
QuickBooks native, QuickBooks plus an add-on, or a manufacturing system
| Capability | QuickBooks Online Plus (native) | QuickBooks plus an MRP add-on | Fabrica ERP plus QuickBooks |
|---|---|---|---|
| Quantity on hand and COGS | Yes, FIFO | Yes | Yes, ledger stays in QuickBooks |
| Bill of materials | Bundles only, no component consumption | Varies by add-on | Built in, with cost roll-up and markup |
| Work orders | Not available | Varies by add-on | 4-status board, Material Check, one-way Issue Materials |
| MRP shortage detection | Reorder points only, no demand awareness | Usually yes | Demand, On Hand, Available with red shortage flags |
| Location and bin | No, Enterprise Advanced Inventory only | Usually yes | On the item record |
| Shop-floor terminal | Not available | Rare | Operator view with no pricing exposed |
| Quality and NCR tracking | Not available | Varies | Rework, Scrap and Accept as Is dispositions with rates |
| Pricing model | Monthly subscription | Per user per month, on top of QuickBooks | 999 dollars one time, no per-user fees, hosting billed on usage |
For context on that last row, the common alternatives price very differently. MRPeasy runs 49 to 149 dollars per user per month plus 79 dollars per month for each additional block of 10 users. Katana is 299 dollars per month for Core plus a 199 dollar per month manufacturing add-on before onboarding fees. Fishbowl Manufacturing, being desktop software bought outright, lands around 21,885 to 26,395 dollars up front for 11 to 15 users before annual support. Competitor figures reflect publicly listed plans at time of writing and vary by team size and configuration.
So should you keep QuickBooks?
Almost certainly yes. Your accountant knows it, your bank feeds run through it, and your historical books live in it. The mistake is asking it to be a manufacturing system, then blaming it when finished-goods numbers do not reconcile.
A reasonable decision rule:
- You buy and resell finished goods, one location. QuickBooks Online Plus alone is enough. Do not add a second system.
- You assemble simple kits and ship them the same day. QuickBooks Online plus a disciplined spreadsheet can hold for a while, but you will feel it as soon as component lead times get long.
- You run jobs that take days, hold raw material, and take custom orders. You need a bill of materials, work orders, and shortage detection. Add a manufacturing layer and keep QuickBooks as the ledger.
- You are already paying per user for an MRP subscription and the seat count keeps growing. Compare the three-year total against a one-time template before you renew.
Try the full manufacturing ERP free for 14 days.
Fabrica ERP: bills of materials, work orders, shop floor, MRP, quality control, and QuickBooks Online sync in one system. 999 dollars one time, no per-user fees. If your setup needs multi-entity or non-QuickBooks accounting, book a call about a custom build instead.
Frequently asked questions about inventory management in QuickBooks
Can you use QuickBooks for inventory management?
Yes, for basic inventory management. QuickBooks Online Plus and Advanced track quantity on hand, cost of goods sold, and reorder points for inventory items, and QuickBooks Desktop editions go further with inventory assemblies. It works well if you buy finished goods and resell them. It stops working well the moment you manufacture, because QuickBooks has no work orders, no material requirements planning, and in the Online version no true assembly build that consumes components into a finished good.
Which QuickBooks plan has inventory management?
Inventory tracking in QuickBooks Online requires the Plus or Advanced plan. Simple Start and Essentials do not include inventory tracking. On the desktop side, inventory assemblies with a component list require QuickBooks Desktop Premier or Enterprise, and Advanced Inventory features such as multiple warehouse locations, barcode scanning, and serial or lot tracking are included only in QuickBooks Desktop Enterprise Platinum and Diamond subscriptions.
How do I record inventory in QuickBooks?
In QuickBooks Online, turn on inventory tracking under Settings, then Account and settings, then Sales, then Products and services, and switch on Track inventory quantity on hand. Create each item as an Inventory item with a starting quantity, an as-of date, a reorder point, and an inventory asset account. Record purchases with a bill or expense against that item so quantity increases, and record sales with an invoice or sales receipt so quantity decreases and cost of goods sold posts automatically.
Does QuickBooks Online have a bill of materials?
Not in the manufacturing sense. QuickBooks Online has Bundles, which group several products together on a sales form, but a bundle does not consume its component quantities and produce a new finished-good item in stock. Intuit's own guidance is that inventory assemblies are a QuickBooks Desktop feature. If you need a component list that drives shortage checks and deducts materials when you build, you need a bill of materials in a manufacturing system rather than a bundle in QuickBooks.
Does QuickBooks have work orders?
No. Neither QuickBooks Online nor QuickBooks Desktop has a native work-order object. Manufacturers typically improvise with a sales order, a spreadsheet, a printed job sheet, or a second piece of software. This is the single clearest gap between accounting software and manufacturing software, and it is why most shops that grow past a few jobs a week end up adding a dedicated production tool.
What is the easiest way to keep track of inventory?
For a pure reseller, the easiest way is the inventory module already inside QuickBooks Online Plus, because it needs no second login and posts straight to your books. For a manufacturer, the easiest sustainable setup is a two-system split: keep QuickBooks as the book of record for invoices, bills, and financial reporting, and run stock, bills of materials, work orders, and purchase planning in a manufacturing system that syncs invoices and account mappings back to QuickBooks.
Which accounting software is best for inventory management?
For manufacturers the honest answer is that the accounting software is rarely the deciding factor, because accounting packages track stock value rather than production. QuickBooks Online Plus is a reasonable ledger for most small manufacturers. The decision that actually matters is what you put on top of it for BOMs, work orders, and material planning.
What are people replacing QuickBooks with?
Most small manufacturers do not replace QuickBooks at all, they add to it. The common paths are an inventory add-on that sits on QuickBooks Online, a standalone MRP subscription priced per user, a desktop system bought outright, or a one-time manufacturing template such as Fabrica ERP at 999 dollars that syncs invoices and customers back to QuickBooks Online. Replacing the ledger itself is usually the most disruptive and least necessary option.
Does QuickBooks Online support LIFO or average cost?
No. QuickBooks Online values inventory using FIFO, first in first out, only. It does not support LIFO or weighted average cost. QuickBooks Desktop Enterprise offers more valuation flexibility. If your accountant needs a costing method QuickBooks Online does not support, that is a conversation to have before you scale your item list, not after.
Can QuickBooks track inventory across multiple warehouses?
Not in QuickBooks Online, which tracks a single quantity on hand per item with no location dimension. Multiple inventory sites are available in QuickBooks Desktop Enterprise with the Advanced Inventory feature, included in Platinum and Diamond subscriptions. If you hold stock in more than one place and you are on QuickBooks Online, you need either a location field in a separate system or a manufacturing platform that carries location and bin on the item record.
Related reading
- Manufacturing ERP software for small business, the full Fabrica ERP product page with all 13 modules, pricing, and the free trial.
- When should manufacturing businesses stop using SOS Inventory, if you already run an inventory add-on on top of QuickBooks Online.
- Best MRPeasy alternative for small manufacturers, if you are weighing per-user MRP subscriptions against a one-time option.
