How to Change Inventory in QuickBooks (Online & Desktop): Step-by-Step Guide

Table of contents

1. What “change inventory” really means in QuickBooks
2. Prep checklist before you adjust stock
3. QuickBooks Online: Adjust quantities (and understand cost impact)
4. QuickBooks Desktop: Adjust quantity or quantity & value
5. Counting methods: cycle counts vs physicals
6. Choosing accounts and understanding COGS impact
7. Common scenarios and how to post them
8. Reversals, audits, and reporting for inventory control
9. Top 10 inventory add-ons for QuickBooks
10. Troubleshooting and gotchas
11. Conclusion
12. FAQs

What “change inventory” really means in QuickBooks

“Changing inventory” covers a few different actions. You might adjust only the quantity (for shrink, found-on-floor, or count variances). You might also need to influence value (e.g., damage write-offs or correcting a bad cost). In QuickBooks terms, you’ll either make a quantity-only adjustment or a quantity and value adjustment, depending on your edition.

QuickBooks Online uses FIFO to value inventory. That means you don’t directly edit value on hand. Instead, you change quantities and correct costs by fixing source transactions (bills, item receipts, credit memos) so the right cost flows into FIFO layers. If you just need to align shelf counts, a quantity-only adjustment will do it. If cost is wrong, you edit or add the purchase-side transactions that created those layers.

QuickBooks Desktop (Pro/Premier) calculates cost by average cost by default. Enterprise can be set to FIFO with Advanced Inventory. Desktop lets you post both “Quantity” and “Quantity & Total Value” adjustments, so you can directly modify valuation alongside counts. The moment you do, QuickBooks recalculates average cost (or impacts FIFO layers in Enterprise if that setting is active).

Prep checklist before you adjust stock

Lock down your process first so the books don’t surprise you later. If your company closes prior periods, coordinate with accounting to pick an allowed date. Count variances posted into a closed month can push COGS where you don’t want it. If you must post to a prior period, note the reason and approvals for your audit trail.

Confirm you have the right user permissions to edit items and make inventory adjustments. In Online, turn on inventory tracking (Gear > Account and Settings > Sales > Products and services > Track quantity and price/rate). In Desktop, verify Inventory and Purchases users can access Vendors > Inventory Activities and the Inventory Adjustment window.

Finally, prepare reference reports before any change. In Online, run Inventory Valuation Summary and Physical Inventory Worksheet. In Desktop, run Inventory Valuation Summary/Detail and Stock Status by Item. Export or print PDFs. These snapshots help you compare pre- and post-adjustment values and prove data integrity during reviews.

QuickBooks Online: Adjust quantities (and understand cost impact)

In QuickBooks Online, the standard workflow is to change quantity on hand through Products and Services. You can add a reason and set the date so your count aligns with when you discovered the variance. After that, review your valuation reports to ensure the change had the expected financial effect.

To adjust quantity on hand in QuickBooks Online: open Sales > Products and services. Find the inventory item. Click the dropdown at the far right and choose Adjust quantity. Enter the Adjustment date, the Inventory adjustment account (commonly an “Inventory Shrinkage” expense), the New quantity on hand, and an optional Memo. Save and close. Repeat for each item you need to correct, or use the Physical Inventory Worksheet to guide your list.

Remember how QBO tracks value: it uses FIFO layers driven by your vendor transactions. Changing quantities affects the inventory asset and the offset account you select, but you do not directly set unit cost in an adjustment screen. If you need to fix historical costs (for example, a vendor bill was recorded with the wrong price), edit that bill so the cost flows to the correct FIFO layer. For freight or landed cost, add a bill or billable expense line assigned to the item or to an appropriate landed-cost account so valuation reflects reality.

Set starting quantities and costs for new items

For brand-new items, you can establish a starting quantity and initial cost at item creation. Go to Products and services > New > Inventory. Set Starting value, Starting quantity on hand, and the “as of” date. Use caution: this seeds your opening layer and valuation, so choose a date and numbers that match your prior system or your first received stock.

If you’re migrating from spreadsheets or another system, do not backdate starting quantities earlier than your first QuickBooks period without reconciling to beginning balances. Mismatched dates create confusing valuation gaps you’ll chase for months.

Once items are live, avoid editing starting values retroactively. Use quantity adjustments for variances discovered in operations, and use purchase-side transactions to fix costs that were entered wrong.

Best practices for Online adjustments

Batch your adjustments by date and reason. For example, use one adjustment date for a cycle count in Zone A and a separate date for damaged returns. Keep your memos clear, such as “Cycle count Aisle 12 2026-08-03” or “Breakage – inbound pallet.” These notes matter when you audit variances.

Use a consistent offset account. “Inventory Shrinkage” (expense) is common for count losses. For count gains (stock you found), talk to your accountant about whether to use “Inventory Over/Short” or the same shrinkage account. Above all, be consistent, and document what you do.

Re-run Inventory Valuation Summary and compare to your pre-adjustment snapshot. Validate that asset changes equal the net of all adjustments posted for the session. This habit catches typos quickly.

QuickBooks Desktop: Adjust quantity or quantity & value

QuickBooks Desktop gives you a purpose-built adjustment form. You can change quantity only or quantity and total value. This flexibility is powerful, but it also carries risk: value edits can unintentionally swing average costs or alter FIFO layers (in Enterprise). Work methodically and document your rationale.

To adjust in Desktop: go to Vendors > Inventory Activities > Adjust Quantity/Value on Hand. In Adjustment Type, choose Quantity or Quantity and Total Value. Pick your Adjustment Account (often an “Inventory Shrinkage” expense). Select the Date and Reference No. Next, add your Item(s). For quantity-only changes, fill in New Qty or Qty Difference. For value adjustments, enter New Value or adjust the Total Value as needed. If you use Advanced Inventory, you can specify Site, Bin, Lot, or Serial at the line level.

When you save, QuickBooks recalculates cost. In Pro/Premier (average cost), changing quantity or total value impacts the calculated average. In Enterprise (FIFO enabled), Desktop adjusts layers by your input. Either way, run Inventory Valuation Summary/Detail after posting. If the impact looks off, use the Audit Trail to review who changed what and when, and correct as needed.

Practical patterns for Desktop adjustments

Post physical count results as a single dated batch per location or per counting wave so it’s easy to reconcile. Use clear Memos and Ref Nos, like “FY26 Physical – Zone C.” If you found a receiving mistake (e.g., bill quantity wrong), fix the bill first; then your count adjustment becomes smaller or unnecessary.

Use distinct accounts for different variance types if your finance team wants granular analysis, for example: Inventory Shrinkage (losses), Inventory Over/Short (gains), Damage/Obsolescence (write-offs), Purchase Price Variance (if you track PPV). If that’s overkill for your size, one standard account consistently applied is still a lot better than ad-hoc choices.

Keep an eye on negative inventory. Desktop allows it, but negative balances can distort average cost and cause confusing COGS postings. If you must ship before receiving, consider using Sales Order workflows or backdating the receipt the same day, and then true-up with a small, well-documented adjustment.

Counting methods: cycle counts vs physicals

You don’t need to wait for year-end to correct the books. Cycle counts (smaller, recurring checks) let you spread the effort and catch errors earlier. Many companies count high-movers weekly, medium movers monthly, and slow movers quarterly. Each cycle produces quantity updates that you then post in QuickBooks with clear dates and memos.

A full physical inventory count still matters. It validates location integrity, bin labeling, and long-tail items you rarely touch. Plan physical counts during low activity or a planned shutdown. Freeze movements, print worksheets, count, recount variances, and only then post your adjustments. Tie the physical back to signed count sheets or digital logs for audit readiness.

Modern teams accelerate counts with mobile barcode/RFID scanning and guided workflows. If you’re still walking the aisles with paper, consider a mobile layer that connects to your ERP or accounting system, speeds scanning, and syncs results for posting. It cuts recount loops and reveals phantom stock faster.

Some operations add a mobile warehousing layer specifically to make counting and posting safer. One such option is Cleverence Inventory, which provides guided Android scanning, offline-first data capture for dead zones, and ERP-friendly posting patterns. It’s designed as a mobile extension that keeps workers fast while protecting the ERP as the system of record - useful if you want sub-second device response on the floor and cleaner variance capture before anything hits QuickBooks.

Choosing accounts and understanding COGS impact

An inventory adjustment always has two sides: Inventory Asset changes on the balance sheet, and an offset on your P&L. The offset is the “Adjustment Account” (Online) or the “Adjustment Account” you select in Desktop’s form. Typical choice: an expense called Inventory Shrinkage. For gains (found stock), some teams use the same account to keep net results together; others split gains to a separate Over/Short account.

Why not book everything to COGS? You could, but it hides process issues and mixes operational shrinkage with sales-driven cost. A dedicated shrinkage account makes trend analysis easier, supports internal controls, and helps you answer the “why” behind variances. If your accountant prefers COGS for materiality or simplicity, at least document the policy.

Value adjustments in Desktop can alter average cost or FIFO layers. That, in turn, changes COGS for prior or future sales depending on timing. If the item turns quickly, even small valuation edits ripple through margins. Use value adjustments sparingly and only with a clear paper trail. In Online, fix the source (vendor bills/receipts) to correct cost; quantity-only adjustments will not override FIFO cost calculations.

Common scenarios and how to post them

Damaged or expired items: If goods are unsellable, reduce quantity. In Online, use Products and services > Adjust quantity with Adjustment account set to Inventory Shrinkage or a Damage/Obsolescence expense. In Desktop, use Adjust Quantity/Value on Hand, choose Quantity only unless you must also reduce value beyond the quantity change, and pick a damage-related account.

Receiving mistake: If you received 100 but vendor billed 90, fix the purchase-side transaction first. Edit the bill or item receipt so quantities and costs match reality. After reconciling the purchase, reassess your on-hand count; you may find you no longer need a separate inventory adjustment.

Found stock or mislocated items: When you discover extra units, increase the quantity. Use a standard Over/Short or Shrinkage account per your policy. If the discovery spans multiple bins or sites in Desktop with Advanced Inventory, record the site/bin correctly to improve future pick accuracy. Then consider a root-cause review so you prevent repeats.

Reversals, audits, and reporting for inventory control

Sometimes you post an adjustment and later learn it was wrong. In those cases, reverse it with a new adjustment dated appropriately, with a memo referencing the original Ref No. Do not delete the original unless your accountant directs you to do so - deletion erases the audit trail and can create reconciliation puzzles.

Use reports to prove your numbers. In Online, run Inventory Valuation Summary, Sales by Product/Service Detail, and the Physical Inventory Worksheet to spot anomalies. In Desktop, Inventory Valuation Detail, Adjustments by Account, and Audit Trail help you triangulate what changed, who changed it, and why.

If you run counts across multiple days, post adjustments by day or wave and keep the signed count sheets or digital logs with them. That way, anyone auditing later can replay the event from worksheets to the exact journal entries in QuickBooks.

Top 10 inventory add-ons for QuickBooks

QuickBooks handles the basics of item master data, costing, purchasing, and sales. When operations grow, teams often add a specialized inventory or mobile warehousing layer to speed counts, picking, and transfers while keeping QuickBooks as the financial system of record.

The list below highlights ten commonly cited add-ons used alongside QuickBooks. Suitability depends on your use cases (receiving, counts, picking/packing, returns), device strategy (Android scanners, wearables), and integration depth (push vs buffered sync). Always pilot before you roll out widely.

Inclusion here isn’t a ranking of “best” for all companies. Instead, use the notes to screen by fit: offline capability, scanner support, deployment effort, and how the connector posts to QuickBooks.

1. Fishbowl Inventory - Mature manufacturing/warehouse features for SMBs, strong work order capability, on-prem footprint with QB integrations.
2. SOS Inventory - Cloud add-on for QBO with assemblies, serial/lot, and light MRP features, often chosen by product companies scaling beyond basic QBO items.
3. Cleverence Inventory - Mobile warehousing layer built for Android barcode/RFID devices; offline-first engine, guided workflows (receiving, counts, picking), and ERP-friendly connectors that buffer traffic so QuickBooks stays stable.
4. Cin7 (DEAR) - Cloud inventory with multichannel, procurement, and light WMS; fits retailers/wholesalers who need channel integrations.
5. inFlow Inventory - SMB-friendly inventory and order management; barcode support and simple workflows with QBO sync.
6. Unleashed - Cloud inventory with BOM and costing controls; solid for distributors and light manufacturers connected to QBO.
7. Finale Inventory - Strong eCommerce marketplace/channel support with kitting and reorder logic; QBO connector available.
8. Katana - Modern UI for make-to-order/light manufacturing; operations boards plus QBO sync for financials.
9. HandiFox - Mobile inventory for Desktop/QBO; barcode scanning for sales/deliveries and stock control.
10. SkuVault (Lightspeed) - Warehouse management focused on eCommerce/3PL workflows; integrates to QBO through connectors.

When comparing, look at offline behavior (can you count in dead zones?), device response time, how errors are stopped on-device, and whether the connector posts idempotently with clean audit trails. Pilots in 2–4 weeks on a narrow process (like cycle counts) are a healthy sign the solution won’t derail day one.

Be clear on your system-of-record boundary: QuickBooks should remain the financial source of truth; the add-on should speed floor work and feed reliable, summarized transactions back into QB without flooding it.

Troubleshooting and gotchas

Negative inventory: Both Online and Desktop can show negative on-hand. It’s a warning sign. In Desktop (average cost), negatives can distort costs dramatically. In Online, negatives can place FIFO cost recognition before the purchase layer exists. Solve it by receiving stock before shipping or by backdating receipts and then truing up with a small, documented adjustment if necessary.

Posting to the wrong account: If you used the wrong adjustment account, you can edit the adjustment and change the account (Desktop) or reverse/repost it (Online). Keep memos aligned so reviewers understand the change. If reporting periods are closed, coordinate with accounting before edits.

Performance and locks: During big physical counts, pause other transactions so your numbers don’t drift mid-session. In Desktop multi-user environments, consider scheduling the adjustment window when user load is low. If you see data integrity warnings, run Verify/Rebuild (Desktop) after you finish posting and before you run final reports.

Conclusion

Inventory adjustments are inevitable. The trick is to make them deliberate, documented, and aligned with how QuickBooks handles cost. QuickBooks Online keeps valuation pure through FIFO layers - so you fix quantity with adjustments and fix cost by editing purchase-side transactions. QuickBooks Desktop gives you more direct control over value, which can be powerful when used sparingly with a clear paper trail.

The operational side matters just as much. Good counts, barcode scanning, and clear variance reasons shrink the number of surprises that land in your P&L. Whether you cycle count weekly or do periodic physicals, batch your entries by date and location, and save your pre/post reports. That discipline pays back in fewer headaches during close.

If your team is outgrowing paper and manual spreadsheets, a mobile layer that’s ERP-friendly can help you move faster without breaking the books. Pilot narrowly - receiving or counts - and expand once you trust the flow. Your goal: real-time floor speed, steady QuickBooks, and reliable margins.

FAQs

-Can I change inventory value directly in QuickBooks Online?

No. QuickBooks Online values inventory with FIFO. You adjust quantities via Products and services. To change valuation, fix source transactions (bills, item receipts, vendor credits) so cost flows into the correct FIFO layers.

-What account should I use for inventory adjustments?

Most companies use an expense account called Inventory Shrinkage. Some split gains to Over/Short. Pick a policy, document it, and be consistent. For Desktop, choose the account in the adjustment form; in Online, set it on the adjustment screen.

-How do I handle damaged stock that’s partially sellable?

Split the item: reduce quantity of the normal item for the unsellable units, and if you repackage or discount the rest, move them to a separate item/SKU (e.g., “Item – Clearance”) via an assembly build or adjustment, then sell at the new price. Keep documentation with the adjustment memo.

-Why did my average cost change so much after a Desktop adjustment?

In Desktop (average cost), a quantity and value adjustment recalculates average. If you set a New Value far from prior cost, average will swing. Double-check whether a purchase transaction should be corrected instead of posting a value edit.

-How can I speed up physical counts and reduce recounts?

Use barcode scanning with guided workflows, lock movements during the count, and set variance thresholds that trigger recounts on the spot. A mobile warehousing layer like Cleverence Inventory can capture counts offline, validate entries on-device, and sync clean adjustments for posting.