Skip to content
Tutorials Center
My learning

Topics

Lesson 25 of 36 ยท Payroll and Inventory

Inventory and Cost of Goods Sold

Track products in QuickBooks: inventory items, purchase orders, receiving stock, reorder points and cost of goods sold with FIFO, and verify the math with runnable stand-ins.

If you sell physical goods, two things must be right: how many units you have, and what they cost you. QuickBooks Online Plus and Advanced track inventory and calculate cost of goods sold (COGS) when you sell. Lower plans do not track quantities, and QuickBooks Desktop has its own inventory features, so check what your plan includes.

QuickBooks cannot run on this site. The TryIts are JavaScript stand-ins that show the arithmetic. They are not the QuickBooks engine and do not model every setting.

How inventory flows through the books

Inventory is an asset until you sell it. At that moment its cost moves to an expense-like account, Cost of Goods Sold, so that profit equals sales minus the cost of what you actually sold.

  1. Buy: a purchase of $500 of stock increases Inventory Asset by $500 (and cash or accounts payable).
  2. Sell: selling part of it records Sales income at the selling price and moves the cost of the units sold from Inventory Asset to Cost of Goods Sold.
  3. Profit (gross profit) = Sales - COGS.
flowchart LR
    A["Purchase"] --> B["Inventory Asset"]
    B -- "Sale of units" --> C["Cost of Goods Sold"]
    D["Sale at price"] --> E["Sales income"]
    E --> F["Gross profit = Sales - COGS"]
    C --> F

Cost leaves the balance sheet only when the goods leave the shelf.

Buying stock is therefore not an expense. A common mistake is entering inventory purchases as ordinary expenses, which understates profit in the month you buy and overstates it later.

Setting up an inventory item

First turn on inventory tracking: Gear icon > Account and settings > Sales > Products and services > Show Product/Service column and Track quantity and price/rate (labels vary by version). Then in Sales > Products and services choose New > Inventory:

  • Name and SKU (a unique code you control).
  • Initial quantity on hand and as-of date. This date is the day tracking begins; entering it carelessly corrupts reports.
  • Inventory asset account (default: Inventory Asset), Income account (Sales of Product Income) and Expense account (Cost of Goods Sold).
  • Sales price/rate and Cost.
  • Reorder point: the quantity at which you want to restock.

Use Bundles for sets sold together, and Non-inventory items for goods you do not track, plus Service items for labor.

Buying and receiving

Record purchases either as a Bill or Expense with the item filled in (quantity and cost per unit), or with a Purchase order first. A purchase order does not affect the books; it is a request to the supplier. When the goods arrive, you convert it into a Bill (or Expense), which increases quantity on hand and Inventory Asset. Compare quantities and costs against the supplier invoice, including shipping that should be added to the cost of the goods.

Selling

Add the inventory item to an Invoice or Sales receipt. QuickBooks reduces quantity on hand and, when the sale posts, records COGS at the cost it calculates. By default QuickBooks Online uses FIFO (first in, first out): the oldest units are assumed sold first. You can see quantity and value in Reports > Inventory valuation summary and Inventory valuation detail, and reorder needs in Product/Service list or the stock report.

QuickBooks Online will let you sell more than you have, creating negative quantity on hand, if you allow it. Negative stock distorts cost, so fix the receiving record rather than ignoring the warning.

JS FIFO cost of goods sold

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The 15 units sold consumed all 10 January units at $4 and 5 February units at $5, so COGS is 65.00, not 15 times the latest cost.

Reorder points and valuation

A reorder point turns stock checking into a rule: when quantity on hand falls to the point, reorder. A reasonable point is the units you sell during the supplier's lead time, plus a safety buffer.

JS Reorder point and stock value

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The total should agree with the Inventory Asset balance on the balance sheet. If it does not, find the difference before closing the month: common causes are items purchased as plain expenses, a wrong "as of" date, or a manual journal entry to the inventory account.

Physical counts

Count your stock at least yearly (monthly for high-value goods). Compare the count with QuickBooks and record differences with Inventory quantity adjustment (QuickBooks Online: + New > Inventory qty adjustment), choosing an Inventory shrinkage expense account for losses. Do not "fix" differences by editing old invoices.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. When is the cost of inventory recorded as Cost of Goods Sold?

    Inventory is an asset until sold; the cost of units sold then moves to COGS.
  2. 2. What does a purchase order do to your books?

    A purchase order is a non-posting document. Stock and the liability appear when you record the bill or expense.
  3. 3. Under FIFO, which units are assumed sold first?

    First in, first out uses the cost of the earliest purchased units first.
  4. 4. How should a physical count difference be recorded?

    The adjustment corrects quantity and value and records the loss in a clear account.

Summary

  • Inventory is an asset; cost moves to COGS only when you sell.
  • Set up items with SKU, cost, price, opening quantity and reorder point.
  • Purchase orders do not post; bills or expenses receive stock.
  • QuickBooks Online uses FIFO; reconcile inventory value to the balance sheet and count regularly.

Next: Profit and Loss and Balance Sheet