How to Review Inventory Count Adjustments in QuickBooks Online

October 6, 2026

Bottom line: A physical count variance is a signal, not a ready-made journal entry. Freeze or control movement, preserve blind count evidence, reconcile receipts and shipments around the cutoff, verify item and unit-of-measure mapping, and obtain approval for both quantity and value before updating QuickBooks Online.

Plan the count before counting

Define the locations, items, ownership categories, count date and time, cutoff, count teams, recount thresholds, and supervisor. Identify consigned goods, customer-owned stock, goods at third-party warehouses, inventory in transit, damaged goods, kits, and work in process. Physical presence does not always mean company ownership, and company-owned stock may be off-site.

Use controlled count sheets or devices with unique identifiers. Blind counts reduce the temptation to copy the system quantity. Capture item code, description, bin, unit of measure, observed quantity, condition, counter, timestamp, and reviewer. Preserve voided sheets and corrections; do not erase the original mark.

Control movement during the count. If operations cannot stop, maintain a movement log for every receipt, transfer, pick, shipment, return, and production event crossing the count window. Record the last receiving and shipping document numbers before the cutoff. Otherwise a real movement can be mistaken for shrinkage.

Normalize items and units

Compare the count list with the QuickBooks item master and any warehouse or ecommerce system. Confirm SKU, active status, inventory versus non-inventory type, location convention, purchase unit, stocking unit, sales unit, and conversion factors. Duplicate item codes or inconsistent descriptions can split one product into several apparent balances.

Unit errors can be dramatic. If a case contains 24 units, a physical count of 10 cases is 240 units, not 10. Keep the packaging label and approved conversion with the count. Do not change the item master merely to make a variance disappear; master-data changes can affect future transactions and need separate approval.

Flag negative on-hand quantities, inactive items with balances, zero-cost items, unexpected decimal quantities, and items stored in the wrong location. These conditions help prioritize investigation but do not prove theft or error.

Build the variance population

Take a system snapshot at the precise cutoff. For each item and location, show book quantity, counted quantity, unit variance, approved unit cost basis, value variance, percentage variance, and recount status. Keep quantity investigation separate from valuation so a cost problem does not obscure a unit problem.

Set risk-based recount rules. High-value items may require recount even for a small unit difference; inexpensive bulk items may use a percentage or value threshold. The recount should be performed by someone independent of the first count when practical. Retain both observations and the final adjudication.

Suppose QuickBooks shows 125 units, the first count finds 101, and a recount finds 121. The movement log then shows four units shipped after the system snapshot but before the aisle was counted. The adjusted physical quantity at cutoff is 125, so no shrinkage entry is supported. Posting the first 24-unit difference would manufacture a loss from count timing and a counting error.

Investigate in transaction order

Review recent receipts for unentered bills, item receipts, wrong SKUs, duplicate quantities, and dates on the wrong side of cutoff. Match purchase orders, packing slips, warehouse receipts, vendor documents, and QuickBooks entries. A bill can be financially recorded while the inventory item or quantity is miscoded.

Next inspect shipments and sales. Compare pick tickets, carrier scans, invoices or sales receipts, cancellations, and returns. Goods may have left the warehouse without the related sales transaction, or revenue may have been recorded before the physical shipment. Escalate revenue cutoff questions rather than changing dates casually.

Then test transfers, assemblies, bundles, samples, internal use, spoilage, damage, returns to vendors, customer returns, and write-offs. For each resolved variance, identify the source transaction and correction owner. For unresolved variance, use the approved reason code and preserve the investigation performed.

Review valuation before adjustment

QuickBooks inventory valuation depends on product configuration and transaction history. Export the inventory valuation detail and summary for the cutoff and confirm that total inventory agrees with the general ledger under the company’s setup. Investigate negative quantities, backdated transactions, and item-type changes that can distort cost behavior.

Do not multiply a variance by a convenient latest purchase price unless policy calls for that method and the accounting system supports it. The accountant should approve the value basis and accounts. Obsolete, damaged, or slow-moving stock may require a valuation decision separate from correcting physical quantity.

If an external inventory platform is the operational subledger, reconcile its item quantities and values to QuickBooks before posting. Define which system owns quantities, costs, and adjustments. Uploading an adjustment independently to both systems without a shared reference can double the change.

Approve and post a controlled adjustment

The adjustment packet should include count instructions, signed count sheets, movement log, system snapshot, variance report, recounts, investigation evidence, proposed quantity and value, reason codes, and approvals. Separate preparer and approver where practical. Apply higher approval thresholds to large, unusual, or sensitive items.

Use the approved effective date and a stable count reference in QuickBooks. Record the transaction ID back in the variance register. Never backdate into a closed period merely to align with the physical count; if the close is locked, the accountant decides the correction period and disclosure.

After posting, rerun the inventory valuation and general ledger. Confirm that approved item quantities changed exactly once, the total effect equals the authorized amount, and no unrelated items moved. Preserve before-and-after reports.

Turn variances into operational action

Summarize variance by location, item family, reason, value, and repeat occurrence. A recurring receiving mismatch calls for a different remedy than spoilage, unit conversion, or undocumented samples. Assign corrective actions with owners and dates rather than treating the accounting entry as the end of the problem.

The IRS publishes general information about inventory and cost of goods sold, but accounting methods and tax consequences require qualified advice. QBOAssistant can organize count packets, reconcile cutoff documents, maintain variance registers, and prepare approved updates. If inventory adjustments are currently unexplained plugs, contact QBOAssistant to build a count-to-ledger workflow.