Inventory looks simple until it meets the real world: backorders, partial receipts, returns, and a dozen item variations that all need to post cleanly to accounting. The good news? QuickBooks can handle core stock control if you set it up correctly and follow consistent workflows. This guide walks you step by step through doing inventory in QuickBooks - both Online and Desktop - so quantities, costs, and financials stay in sync without surprise write‑offs.
Table of contents
- What “inventory in QuickBooks” actually means
- Prerequisites and account setup
- Enable and configure inventory in QuickBooks Online
- Enable and configure inventory in QuickBooks Desktop
- Build your item master the right way
- Purchasing: POs, receiving, and vendor bills
- Selling: invoices, sales receipts, and fulfillment
- Counting, adjustments, and shrink
- Costing methods, COGS, and valuation
- Reports and reconciliation
- Barcode, mobile scanning, and integrations for speed
- Controls, roles, and audit readiness
- Common pitfalls and troubleshooting
- Conclusion
- FAQs
What “inventory in QuickBooks” actually means
When people say “do inventory in QuickBooks,” they usually mean three connected things. First, tracking on‑hand quantities by item so you always know what’s available to promise. Second, calculating cost of goods sold (COGS) accurately as items are sold. Third, tying these two to purchasing and sales processes so the general ledger reflects reality without manual journal entries.
QuickBooks supports inventory items that carry both a quantity on hand and a cost. Purchases raise quantity and capitalize cost into inventory assets; sales reduce quantity and move the proper cost into COGS. As long as your item setup and workflow are correct, QuickBooks will post to the right balance sheet and income statement accounts automatically.
Different editions handle valuation differently. QuickBooks Online uses FIFO for inventory valuation. QuickBooks Desktop traditionally uses average cost, and some Desktop editions support FIFO when specific features are enabled. You don’t have to be a cost accountant to use QuickBooks, but knowing which method your edition uses helps you interpret margins and catch anomalies faster.
Prerequisites and account setup
Before flipping any inventory switches, confirm your subscription supports it. In QuickBooks Online, inventory tracking is available in certain plans (commonly Plus and Advanced). In QuickBooks Desktop, inventory features are present in most business editions, and advanced capabilities may require specific Desktop tiers. If you’re unsure, check your subscription details inside the product.
Next, prepare your chart of accounts. You’ll want a dedicated Inventory Asset account on the balance sheet and a COGS account on the income statement. If you already have inventory on hand from a previous system or from manual tracking, decide on a clean cutover date and gather current quantities and costs; that opening balance snapshot is your foundation.
Finally, get your item data ready. A good item master includes clear names, SKUs, categories, purchase and sales descriptions, units of measure, vendor part numbers, standard costs if you maintain them, and default sales prices. Clean data here pays dividends later - fewer posting errors, clearer reports, and faster onboarding for new staff.
Enable and configure inventory in QuickBooks Online
Turning on inventory in QuickBooks Online is straightforward. Go to Settings and review Sales and Expenses preferences. Enable product and service tracking, turn on inventory tracking, and confirm that purchase order and bill features are active. While you’re there, set default sales form content and taxes to match your business rules so item behavior is consistent from day one.
Create or verify your Inventory Asset and COGS accounts. QuickBooks Online will suggest defaults, but you can point items to custom accounts if your accountant prefers a specific structure. If you sell both stock and non‑stock items, consider creating separate income accounts for each to maintain reporting clarity.
Now add your first inventory item: navigate to Products and Services, choose New, and select Inventory. Enter a unique name and SKU, sales and purchase descriptions, sales price, and preferred vendor. Specify the initial quantity on hand and as‑of date only at the point of initial load; for subsequent receipts, use purchase and receiving workflows (not item edit screens) so valuation stays accurate.
When you receive stock, use purchase orders (optional) and vendor bills to track costs. Use item receipts or mark bills as partially received to mirror real‑world timing. When you sell, use invoices or sales receipts with the exact items and quantities. QuickBooks Online will apply FIFO automatically to relieve inventory and post COGS.
Enable and configure inventory in QuickBooks Desktop
In QuickBooks Desktop, open Preferences and select Items & Inventory. Enable inventory and purchase orders, and confirm that warnings for negative inventory are on - these guardrails prevent many common errors. If your edition supports advanced features such as alternate valuation or multiple locations, review those settings with your accountant before enabling them.
Set up the Inventory Asset and COGS accounts in your Desktop company file. Desktop’s item types include Inventory Part, Non‑inventory Part, Service, and more. Choose Inventory Part when you need on‑hand tracking and automatic COGS posting. If you manufacture or kit items, consider Inventory Assembly items to capture component usage and finished goods receipts.
Add inventory items via the Item List. For each, complete the name/number, purchase and sales data, cost and price, tax codes, and linked accounts. Use the “On Hand” and “As Of” fields only for the initial load. After go‑live, receive stock through the Vendors menu (Enter Bills or Receive Items) to maintain audit trails and accurate costing.
Desktop posts COGS using your edition’s valuation method - commonly average cost, with certain editions supporting FIFO when configured. Keep an eye on the average cost shown in the item window; sudden spikes are a clue to mis‑dated bills or negative inventory that needs review.
Build your item master the right way
Think of the item master as your language for inventory. If names and SKUs are cryptic, your team will improvise - and that’s when duplicate items and wrong postings creep in. Adopt a clear naming pattern that encodes the essentials (category, size, color, or spec) and standardize abbreviations so “BLK” always means black and “EA” is each.
Classify items by type. Use Inventory for stocked goods, Non‑inventory for items you buy but don’t stock or that pass through quickly, and Service for labor. If you assemble kits or bundles, ensure the structure is consistent and components are accurate. This keeps reporting meaningful and fulfillment predictable.
Capture vendor part numbers and preferred vendors. When staff can search by your SKU or the vendor’s code, errors drop sharply. If you buy in one unit (case) and sell in another (each), document the conversion and use a consistent method so pricing and counts align.
Purchasing: POs, receiving, and vendor bills
Purchase orders aren’t required in QuickBooks, but they add useful control. Create a PO with expected items, quantities, costs, and dates. When goods arrive, receive against the PO to record quantities actually received, including partials and backorders. This creates a clean audit trail from request to receipt.
Next, match vendor bills to receipts. If costs differ from the PO (they often do), enter the actual amounts. In QuickBooks Online, receiving can be combined with billing in one step or split across steps depending on your workflow. In Desktop, you can Receive Items (with or without Bill) and then Enter Bills against received items. The key is to date documents as of their real arrival and bill dates to keep valuation accurate.
Watch for common exceptions: substitutions, short ships, or free goods. If items are substituted, update the item on the receipt so your on‑hand counts stay aligned. For free goods, record the receipt at zero cost but consider an adjustment or landed cost treatment later if you need to spread freight or fees across items.
Selling: invoices, sales receipts, and fulfillment
On the sell side, always choose the exact inventory item on invoices or sales receipts - never a generic “miscellaneous” line. That one choice is what tells QuickBooks to relieve stock and post COGS correctly. If you take orders before stock arrives, you can use estimates or sales orders (Desktop) to map future demand without changing inventory yet.
When you fulfill, ship the precise quantities and update documents for partial shipments. If you ship complete orders only, set a policy and stick to it; if partials are common, make sure the team knows how to mark partial fulfillment in your edition of QuickBooks so the remaining balance stays open.
Returns happen. Create a credit memo tied to the original item, and decide whether to return to stock. If items are damaged or non‑saleable, don’t put them back into sellable inventory; create a write‑off adjustment instead. This keeps on‑hand counts honest and margins accurate.
Counting, adjustments, and shrink
Cycle counts beat annual physicals for most businesses. Rather than shutting down once a year, count a slice of items daily or weekly. Prioritize fast movers, high‑value SKUs, and problem areas. In QuickBooks, use the inventory quantity adjustment to correct counted quantities with a memo describing why the change occurred.
Separate reasons for adjustments: damage, theft, vendor error, receiving error, or count variance. Use distinct adjustment accounts or classes if you want to analyze trends; for example, if shrink spikes in a location, you’ll see it quickly and can respond with process changes or security measures.
Never use item edits to change quantities after go‑live. Always use adjustment transactions with dates and memos. That way, your valuation layers (FIFO or average cost) remain intact, and auditors can see when and why changes occurred.
Costing methods, COGS, and valuation
In QuickBooks Online, FIFO means the oldest received costs flow to COGS first. If purchase prices are rising, FIFO tends to show higher margins early and higher inventory valuation on the balance sheet. Understand this dynamic when you compare month‑to‑month margins; timing matters.
In QuickBooks Desktop, average cost typically pools all costs for an item and divides by quantity on hand. That means a single high‑cost receipt can affect COGS across several sales until more receipts arrive. Some Desktop editions support FIFO when configured - verify your edition and settings before you rely on a specific valuation in reports.
Mixed‑mode operations add nuance. If you assemble kits, costs for components roll up into finished goods. If you apply landed costs (freight, duties), spread them consistently - either increase item costs at receipt or record separate adjustments - so valuation reflects the true cost to get items sale‑ready.
Reports and reconciliation
Inventory reports are your early‑warning system. Run the Inventory Valuation Summary to see quantity, average or FIFO cost, and total value by item. The Inventory Valuation Detail shows the flow of receipts and sales by date - perfect for tracing anomalies back to a specific document.
Reconcile the total inventory value to the balance sheet. The sum of item values on the valuation report should match the Inventory Asset account (or accounts) on the balance sheet for the same “as of” date. If they don’t, investigate transactions dated outside the reporting window, manual journal entries, or negative inventory periods.
COGS trends tell a story too. Compare gross margin by item or category over time. Sudden drops may signal mis‑dated bills, returns processed incorrectly, or component costs that weren’t captured. Use report filters and drill‑downs to isolate the issue quickly.
Barcode, mobile scanning, and integrations for speed
Typing item codes is slow and error‑prone. If your team receives, picks, or counts more than occasionally, barcode‑driven mobile workflows can boost accuracy and throughput. QuickBooks provides the accounting backbone, and specialized mobile layers connect scanners and warehouse steps to your books with fewer keystrokes and better validation.
One option purpose‑built for this bridge is Cleverence Inventory. It adds a mobile data collection layer for common warehouse tasks - receiving, labeling, put‑away, picking, shipping, transfers, and cycle counts - running on rugged Android barcode/RFID devices with on‑device validation and label printing. Its offline‑first engine keeps workers moving in dead zones and syncs safely back to the ERP or accounting system via certified connectors and APIs. For QuickBooks environments, this “software glue” approach protects the core system while capturing sub‑second scans and posting clean, auditable transactions. Teams often pilot in a few weeks, see faster counts with fewer recount loops, and surface phantom stock early. If mobile accuracy and ERP‑friendly posting matter to you, explore Cleverence Inventory as a complement - not a replacement - to QuickBooks.
Whether you choose scanning or stay manual, standardize item labels, decide where barcodes live (bin vs item vs carton), and train staff on exceptions like substitutes and partial receipts. Consistency beats any single tool feature.
Top 10 QuickBooks‑friendly inventory add‑ons (neutral snapshot)
- Excel/CSV import utilities for mass item updates and initial data loads - simple, low cost, familiar to most teams.
- SOS‑style cloud inventory layers for light manufacturing and reorder management that sync with QuickBooks.
- Cleverence Inventory for barcode/RFID mobile workflows, offline‑first scanning, and ERP‑friendly posting that complements QuickBooks on the warehouse floor.
- eCommerce/channel connectors to pull online orders into QuickBooks and push inventory back to marketplaces.
- Shipping platforms that rate‑shop carriers, print labels, and write tracking numbers onto QuickBooks documents.
- Point‑of‑sale systems integrated with QuickBooks for retail counter sales and real‑time stock updates.
- Label design and printing tools supporting ZPL/CPCL for item, shelf, and shipment labels.
- Business intelligence dashboards that visualize margins, turns, and aging beyond standard QuickBooks reports.
- Mobile sales apps for field reps that quote from live inventory and create QuickBooks transactions.
- Returns/RTV trackers to streamline customer credits and vendor returns while keeping counts accurate.
Controls, roles, and audit readiness
Strong inventory control is as much about people and process as software. Separate duties where possible: one person creates POs, another receives, a third approves bills. Even in small teams, a minimal rotation or second‑person review catches most mistakes before they hit the ledger.
Use roles to limit who can add or edit items, post adjustments, or change dates. If you add mobile scanning or connectors, ensure they offer role‑based access, audit logs, and secure transport. Inventory moves touch revenue recognition and tax; traceability matters when questions arise.
Document your workflows: how to receive, how to pick, how to process returns, how to count. Post a one‑page checklist at receiving and shipping stations. When processes are clear and visible, training time drops and compliance rises.
Common pitfalls and troubleshooting
Backdating is the silent killer. Entering a bill weeks after items were sold can distort costs, average prices, or FIFO layers. If you must backdate, review margin reports and valuation details for that item to make sure the effect is understood and acceptable.
Negative inventory is another frequent culprit. Selling before receiving creates placeholder costs that later get replaced - often with surprising results. Use ordering and receiving discipline to avoid going negative, and turn on warnings so staff know to pause and resolve exceptions.
Duplicate items fragment data. If staff can’t find the right item fast, they will create a new one. Solve that with better search fields (SKU, vendor code), clear naming, and governance over who can create new SKUs. Periodically merge duplicates after reviewing history.
Conclusion
QuickBooks can absolutely carry day‑to‑day inventory for many product businesses - as long as you set it up carefully and stick to clean workflows. Start with a solid item master, enable the right preferences, and run purchasing and sales through the intended documents so the system can do its job.
From there, build discipline: cycle counts to keep reality aligned with records, exception handling for returns and damages, and regular report reviews to catch drift early. If your operation adds complexity - multiple locations, mobile scanning, assemblies - layer in specialized tools that integrate cleanly without overwhelming your accounting core.
Inventory accuracy isn’t a one‑time project; it’s a habit. A few steady practices - consistent item usage, timely receipts, controlled adjustments - deliver accuracy you can bank on and margins you can trust.
FAQs
-Do I need a specific QuickBooks plan to track inventory?
Yes. QuickBooks Online offers inventory tracking in certain plans (commonly Plus and Advanced). QuickBooks Desktop includes inventory in most business editions, with advanced features available in specific tiers. Check your subscription to confirm availability before you proceed.
-How should I load opening quantities and costs?
Use the item’s initial quantity on hand and as‑of date at go‑live for the one‑time opening. After that, never edit item quantities directly - receive stock through normal purchasing steps or use inventory adjustments with memos so valuation remains accurate and auditable.
-Why did my margins change after entering late vendor bills?
Backdated bills can alter average costs (Desktop) or reorder FIFO layers (Online) for prior sales. To minimize surprises, enter bills promptly, avoid selling into negative inventory, and review valuation detail for affected items if you must backdate.
-Can I use barcodes with QuickBooks?
Yes, via integrated tools that connect scanners to QuickBooks workflows. Barcode layers can accelerate receiving, picking, and counts while reducing keying errors. Evaluate mobile options that validate on device, work offline when needed, and post cleanly to QuickBooks.
-What’s the best way to handle returns and damaged goods?
Create a credit memo for returns tied to the original item, and decide whether to return to sellable stock. For damaged or unsellable items, use an inventory adjustment to remove them and post the loss to an appropriate account. Avoid putting unsellable items back into regular on‑hand counts.