What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Add Inventory in QuickBooks Online
QuickBooks Online

How to Add Inventory in QuickBooks Online, Starting Quantity Included

You open a new product and the only choices are Service and Non-inventory. That means inventory tracking is off, or your plan doesn't have it. Inventory items are a QuickBooks Online Plus and Advanced feature, and they need one setting switched on before the option appears.

Add an inventory item

1. Check your plan. Simple Start and Essentials don't track inventory; Plus and Advanced include it. Desktop Pro, Premier and Enterprise all do too.

2. Switch it on: in the Sales settings, under Products and services, turn on Track quantity and price/rate and Track inventory quantity on hand.

Settings Account and settings Sales Products and services

3. Add the item: open your products and services list, choose New, then Inventory, and enter the quantity on hand with an as-of date.

Products and services New Inventory

Filling in the inventory item form

Your menu may label the list Products & services or put it under Inventory. The form is the same.

  1. 1

    Name, SKU and category

    Use the name your staff and customers recognize. A SKU makes items easier to find on invoices and purchase orders, and categories group them on reports.

  2. 2

    Initial quantity on hand and the as-of date

    Enter what's physically on the shelf and the date you counted it. QuickBooks values your opening stock from this, so the as-of date should be on or before the first sale or purchase you'll record for the item.

    Watch for: an as-of date after older sales of the item. Those sales then hit before any stock existed, and the quantity goes negative.

  3. 3

    Reorder point

    Optional. Set the quantity at which you want to restock, and QuickBooks flags the item as low on stock when it falls to that number.

  4. 4

    Inventory asset account

    Most businesses leave the default Inventory Asset account. Split it only if your accountant wants separate balances per product line. More on what this account holds in our inventory asset guide.

  5. 5

    Sales and purchasing details

    Set the sales price and income account, then the cost, the expense account (normally Cost of Goods Sold) and a preferred vendor if you have one. Save, and repeat for each item, or import a spreadsheet of items from the same list if you've got many.

Adding stock after the item exists

Don't edit the starting quantity to add stock later. Use the transaction that matches what happened.

  1. 1

    You bought more

    + New Bill

    Record the purchase on a bill, expense or check with the inventory item on an item line. Quantity on hand goes up by what you bought. With purchase orders, receive against the PO, as in receiving inventory.

  2. 2

    The shelf count is different from QuickBooks

    + New Inventory qty adjustment

    Pick the date and an adjustment account, find each item, and enter the counted quantity or the change. QuickBooks works out the difference and updates the item's value. The full process is in adjusting inventory.

Inventory item or non-inventory item?

Inventory

Stock you count and resell

  • Tracks quantity on hand, rising on purchases and falling on sales.
  • Its cost sits in Inventory Asset until it sells, then moves to Cost of Goods Sold.
  • Needs Plus or Advanced in QuickBooks Online.
Non-inventory

Things you buy or sell without counting

  • No quantity on hand, so no counts and no negative stock.
  • Fits drop-shipped goods, one-off resales and supplies used up on jobs.
  • Available on every QuickBooks Online plan.

If nobody would ever count it on a shelf, a non-inventory item is simpler and the books stay just as right.

Stock numbers that drift after setup

Quantity on hand shows a negative number

How you'll know: An item reads −3 even though you've never been out of stock.

Fix: A sale was dated before the purchase or starting quantity that covers it. Fix the dates or enter the missing purchase, rather than just adjusting the number up.

Parts used on jobs never leave stock

How you'll know: The count keeps coming up short of QuickBooks, by roughly what went into job work.

Fix: Materials only leave inventory when an invoice, sales receipt or adjustment records them. Put them on the job's invoice, or adjust them out regularly. Where techs log parts in a field app, n-frames builds the link that posts that usage to QuickBooks.

The same product exists twice

How you'll know: One item has stock and its twin has sales, both drifting from reality.

Fix: Pick the one to keep, adjust the other to zero and make it inactive, then point future sales and purchases at the survivor.

Inventory item questions after setup

What is the inventory asset account in QuickBooks?

It's the balance sheet account holding the cost of stock you have but haven't sold. Buying inventory adds to it. When an item sells, QuickBooks moves that item's cost out of it and into Cost of Goods Sold.

What's the difference between an inventory item and a non-inventory item in QuickBooks?

An inventory item tracks quantity on hand and runs through Inventory Asset as you buy and sell it. A non-inventory item is bought or sold without a count, which suits goods you don't stock yourself. The comparison above covers when to use each.

How do I adjust inventory in QuickBooks when the physical count is off?

Choose + New, then Inventory qty adjustment. Pick the items, enter what you actually counted, and save. The difference posts to the adjustment account you chose, and on-hand quantities match the shelf again.

Why is my inventory showing negative in QuickBooks?

QuickBooks lets a sale go through even when it takes the quantity below zero. It almost always means a sale was recorded, or dated, before the purchase or starting stock behind it. Correct the order of entries, and the negative clears on its own.

Can QuickBooks take parts off stock when a technician uses them on a job?

Only through a QuickBooks transaction, like the job's invoice or an inventory adjustment. If materials are logged somewhere else, such as a field service app or a paper ticket, they don't reach QuickBooks by themselves. n-frames builds the integration that turns those logged parts into the right QuickBooks entries.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.