3.3 Managing Inventory Counts, Quantity Adjustments & Reorder Points

Managing Inventory Counts, Quantity Adjustments & Reorder Points

Quick Answer: Maintaining inventory integrity requires active stock management and periodic reconciliations. QuickBooks Online provides Reorder Points to trigger automated low-stock warnings and streamline replenishment via purchase orders. When physical stock differs from software records due to shrinkage, damage, or theft, users record an Inventory Quantity Adjustment (+ New > Other > Inventory qty adjustment). This adjustment updates on-hand counts and automatically posts an offset between Inventory Asset and an Inventory Shrinkage (COGS or Expense) account. Additionally, QBO Plus and Advanced support Price Rules for dynamic, rule-based customer discounts.

---

Optimizing Stock Levels with Reorder Points

A Reorder Point is the minimum threshold of stock an organization wishes to maintain on hand before ordering replenishment from suppliers.

Setting and Monitoring Reorder Points

• Configured directly on the product edit screen in the Reorder point field.
• Once established, QBO monitors on-hand quantities continuously against this threshold.
• On the Products and Services dashboard (Sales > Products and services), QBO groups items into status tiles:
  • Low Stock: The quantity on hand is greater than zero but less than or equal to the reorder point.
  • Out of Stock: The quantity on hand has reached zero or gone negative.

[Products and Services Dashboard]
┌──────────────────────┐  ┌──────────────────────┐
│   12 Items Low Stock │  │  3 Items Out of Stock│
│ (At or below reorder)│  │    (At zero or neg)  │
└──────────┬───────────┘  └──────────┬───────────┘
           │                         │
           ▼                         ▼
    [Filter List] ─────────► [Select Items] ─────────► [Batch Action: Reorder]
                                                                 │
                                                                 ▼
                                                    [Automated Purchase Orders]

The Automated Reorder Workflow

When a user clicks on the Low Stock or Out of Stock summary tile, QBO automatically filters the product table to show only those items requiring attention.

1. Select the checkboxes next to the items to reorder.
2. Click the Batch actions drop-down menu and choose Reorder.
3. QuickBooks Online automatically generates Purchase Orders grouped by each item's Preferred Supplier, populating the suggested reorder quantities.

---

Conducting the Physical Inventory Count

Regardless of how rigorously transactions are recorded, perpetual records inevitably diverge from physical shelf quantities due to breakage, supplier miscounts, administrative mistakes, or theft (shrinkage). Periodic physical counts are necessary to maintain financial statement reliability.

The Physical Inventory Worksheet

QuickBooks Online includes a specialized report specifically designed for physical counts: the Physical Inventory Worksheet (Reports > Physical Inventory Worksheet).

• Displays: Product/Service Name, SKU, Description, and current book Quantity on Hand.
• Includes a blank Physical Count column formatted for staff to write down actual counted numbers on the warehouse floor.
• Can be sorted and filtered by Category to facilitate counting specific warehouse aisles or product lines.

Best Practices for Physical Counts

1. Freeze Operations: Ensure all sales shipments, receiving bills, and customer returns occurring prior to the count are fully recorded in QBO. Halt transaction entry while counting.
2. Count Blindly or Dual-Count: Prevent bias by having independent teams verify count discrepancies.
3. Isolate Damaged Stock: Separate broken or obsolete goods for valuation adjustment rather than standard count adjustments.

---

Recording Inventory Quantity Adjustments

When the physical count differs from the book quantity in QBO, the user must enter an Inventory Quantity Adjustment to synchronize the software with reality.

Step-by-Step Entry Workflow

1. Navigate to + New > Other > Inventory qty adjustment.
2. Adjustment Date: Enter the exact date the physical count took place (critical for historical reporting integrity).
3. Inventory Adjustment Account: Select the general ledger account that will absorb the offsetting financial impact. Typically, this is an expense or COGS account named Inventory Shrinkage, Inventory Adjustments, or Spoilage/Damage.
4. Add Items: In the table, select the products that showed discrepancies.
5. Enter Count: QBO displays the current book quantity. Enter the counted count in the New Qty column; QBO automatically calculates the value in the Change in Qty column.
6. Save and close.

┌────────────────────────────────────────────────────────────────────────┐
│                     Inventory Quantity Adjustment Form                 │
├────────────────────────────────────────────────────────────────────────┤
│ Adjustment Date: 12/31/2026      Adjustment Account: Inventory Shrinkage│
│ Reference No:    ADJ-1042        Memo: Year-end physical count         │
├───────────────────┬──────────┬──────────┬────────────┬─────────────────┤
│ Product/Service   │ Book Qty │ New Qty  │ Change Qty │ Unit FIFO Cost  │
├───────────────────┼──────────┼──────────┼────────────┼─────────────────┤
│ Smart Thermostat  │    50    │    46    │     -4     │     $100.00     │
│ Brass Fitting 1"  │   120    │   125    │     +5     │       $4.00     │
└───────────────────┴──────────┴──────────┴────────────┴─────────────────┘

Underlying General Ledger Mechanics

Scenario A: Inventory Shrinkage (Count < Book Qty)

When the physical count is lower than recorded in QBO (e.g., 4 missing thermostats @ $100 FIFO cost = $400):

• Debit: Inventory Shrinkage / Inventory Adjustment (COGS or Expense account increases by $400)
• Credit: Inventory Asset (Balance Sheet asset decreases by $400)

Scenario B: Inventory Overage (Count > Book Qty)

When the physical count exceeds software records (e.g., 5 extra fittings found @ $4 FIFO cost = $20):

• Debit: Inventory Asset (Balance Sheet asset increases by $20)
• Credit: Inventory Shrinkage / Inventory Adjustment (COGS or Expense account decreases by $20, offsetting past shrinkage)

---

Handling Inventory Value Adjustments (Impairment & Obsolescence)

Under US GAAP (ASC 330), inventory must be stated at the Lower of Cost and Net Realizable Value (LCNRV). If inventory becomes obsolete, damaged, spoiled, or commercially devalued below its acquisition cost, the asset value must be written down on the balance sheet even if the physical quantity remains unchanged.

The QBO Limitation

Unlike desktop enterprise software, QuickBooks Online does not offer a native screen to adjust inventory dollar value while leaving quantity unchanged. Attempting to enter an adjustment with a quantity change of 0 is rejected by the system.

ProAdvisor Remediation Workarounds

To write down the value of damaged or obsolete stock, ProAdvisors utilize one of two accepted methods:

Method 1: The Two-Step Quantity Adjustment

1. Step 1 (Zero-out stock): On the date of impairment, enter an Inventory Quantity Adjustment reducing the on-hand quantity of the impaired item to 0. This relieves the entire historical FIFO asset balance to the adjustment account.
2. Step 2 (Re-enter at reduced cost): On the same date or the following day, enter a second Inventory Quantity Adjustment restoring the physical quantity to its actual count, but specifying the new, lower unit cost in the initial valuation/bill, or by entering a zero-dollar vendor bill allocating the reduced total asset value.

Method 2: Inventory Valuation Allowance (Balance Sheet Journal Entry)

Instead of altering the perpetual item subledger, the accountant creates a contra-asset account on the Balance Sheet named Allowance for Obsolete Inventory.

• Debit: Loss on Inventory Obsolescence / Impairment (Expense/COGS)
• Credit: Allowance for Obsolete Inventory (Contra-Asset on Balance Sheet)

ProAdvisor Note: Method 2 preserves exact subledger unit counts and avoids disturbing FIFO layers, but creates a permanent variance between the gross Inventory Asset control account and the subledger unless reconciled against the contra-asset account.

---

Dynamic Pricing Strategies: Configuring Price Rules

For businesses running complex promotional campaigns or serving tiered clienteles (such as wholesale vs. retail), manually editing line-item prices on invoices is inefficient and error-prone. QuickBooks Online Plus and Advanced feature Price Rules to automate custom pricing.

Enabling and Navigating Price Rules

1. Go to Gear icon > Account and Settings > Sales.
2. In the Products and services section, toggle on Turn on price rules.
3. Access rules via Gear icon > All Lists > Price Rules or through Sales > Products and services > More > Price rules.

┌────────────────────────────────────────────────────────────────────────┐
│                         Price Rule Configuration                       │
├────────────────────────────────────────────────────────────────────────┤
│ Rule Name: Summer Wholesale Special      Status: Active                │
│ Start Date: 06/01/2026                   End Date: 08/31/2026          │
├────────────────────────────────────────────────────────────────────────┤
│ Customer Applicability:                                                │
│   ( ) All customers   (•) Customer types: [Wholesale]   ( ) Select     │
├────────────────────────────────────────────────────────────────────────┤
│ Product Applicability:                                                 │
│   ( ) All items       (•) Category: [Outdoor Power]     ( ) Select     │
├────────────────────────────────────────────────────────────────────────┤
│ Price Adjustment:                                                      │
│   • Decrease by: [ 15.00 ] [%]                                         │
│   • Rounding: [ Round down to .99 ]                                    │
└────────────────────────────────────────────────────────────────────────┘

Price Rule Capabilities and Parameters

When building a Price Rule, ProAdvisors can combine multiple conditional filters:

• Date Restrictions: Set optional start and expiration dates for seasonal sales or promotional campaigns.
• Customer Targeting: Apply the rule to All customers, specific Customer Types (e.g., Wholesale, Non-Profit, VIP), or manually selected individual customers.
• Product Scope: Apply to All products and services, specific Product Categories, or hand-picked individual items.
• Adjustment Types:
  • Percentage discount (e.g., 15% off standard sales price).
  • Percentage markup (e.g., cost plus 25%).
  • Fixed dollar discount (e.g., $10.00 off standard rate).
  • Fixed custom prices per item.

Behavior on Sales Transactions

When an invoice or sales receipt is created for a customer who meets the active price rule criteria:

1. QBO automatically identifies the applicable rule.
2. The system populates the adjusted rate in the Rate column.
3. The original base price is displayed with a strike-through or clearly noted, confirming to the user that a promotional or contract price rule was applied without manual override.