Inventory Tracking & FIFO Costing in QuickBooks Online

QuickBooks Online (QBO) makes it easy to keep a real‑time picture of what you have on hand and to apply the first‑in, first‑out (FIFO) method automatically. Understanding the difference between inventory and non‑inventory items, how QBO moves costs through the purchase‑to‑sale cycle, and how to handle adjustments will keep your balance sheet accurate and your cost of goods sold (COGS) reliable.

Inventory vs Non‑Inventory

• Tracked inventory items – When you create an item as “Inventory,” QBO records the quantity on hand (QOH) and maintains a corresponding asset balance on the balance sheet. Every receipt adds to QOH and the asset value; every sale reduces both.
• Non‑inventory items – These are treated as expenses at the moment of purchase. Use them for drop‑shipped goods, office supplies, or any item that never physically resides in your warehouse. They bypass the inventory asset account and go straight to an expense line.

Choosing the correct type prevents the system from trying to track quantities that you don’t actually hold, which in turn avoids unnecessary adjustments later.

Automated FIFO Costing

QBO defaults to FIFO, meaning the cost of the oldest purchase batch is applied to COGS when you sell an item. The flow looks like this:

1. Purchase Order (PO) – Optional step to reserve the need.
2. Bill – When the vendor invoice is entered, QBO increases the inventory asset and records the purchase cost.
3. Sales Invoice – Creating a sales invoice automatically pulls the cost from the oldest available batch and posts it to COGS.

Because the costing is automated, you don’t need to manually calculate unit costs for each sale. The system also updates the inventory asset balance in real time.

Inventory Adjustments

Physical counts rarely match the system count perfectly. QBO provides a Quantity adjustment screen where you can record shrinkage, spoilage, damage, or simple count errors. When you submit an adjustment:

• The QOH is updated to the new count.
• An Adjustment account (typically “Inventory Shrinkage”) offsets the reduction in the inventory asset, preserving the integrity of your financial statements.

Never use a generic journal entry to tweak the inventory asset; the adjustment screen ensures the proper expense account is hit and audit trails are maintained.

The Negative Inventory Bug

If you sell an item before entering the vendor bill that creates the inventory, QBO will allow the transaction, resulting in a negative QOH. The system later retroactively re‑costs the sold units once the bill is entered, which can:

• Produce a temporary negative balance on the inventory asset.
• Distort historical COGS because the cost is reassigned after the fact.

To avoid this, always enter receiving bills before you generate sales invoices for the same items.

Do / Avoid

Do

• Conduct quarterly physical counts and post any differences through the inventory adjustment screen.
• Enter vendor purchase bills before issuing customer sales invoices.
• Use non‑inventory item types for custom‑order, drop‑shipped, or low‑value supplies that never sit in your warehouse.

Avoid

• Letting inventory quantities drop below zero; it triggers the negative inventory bug.
• Adjusting inventory asset balances with manual journal entries; use the built‑in adjustment workflow instead.
• Tracking low‑cost office supplies or packaging materials as inventory; treat them as expenses.

Keep the flow of purchase → bill → inventory → sale → COGS clean, and your books will reflect true cost and quantity at every step.