Skip to main content

Inventory quantities explained

What QTY in stock, committed, expected and available mean, and what changes each one.

With Inventory Management on, Method tracks four numbers for each inventory item at each location.

Label

What it means

QTY in stock

What is physically at the location right now.

QTY committed

What you've promised to customers on Sales Orders but haven't shipped yet, plus stock reserved on Open Stock Transfers leaving the location.

QTY expected

What you've ordered from vendors on Purchase Orders but haven't received yet, plus stock on Stock Transfers heading to the location.

QTY available

What you can still promise: QTY in stock - QTY committed.

📌 Note: These four numbers live only in Method and never sync to QuickBooks Online. QuickBooks keeps its own number, shown in Method as Accounting QTY on hand.


Why Method and QuickBooks show different quantities

QuickBooks Online keeps one inventory count for each item, its Quantity on Hand (QOH). Method shows it as Accounting QTY on hand. QuickBooks changes it when you record a transaction, mainly:

  • an Invoice for goods you sold

  • a Bill for goods you bought

However, QuickBooks doesn't track what happens to your stock between those transactions. Inventory Management does:

  • Locations: it tracks stock at each location, and moves stock between them with Stock Transfers.

  • Reordering: it shows what's committed to customers and expected from vendors, so you can see when to order more.

  • Overselling: it shows what's still available, so you don't promise stock you don't have.

Method tracks the goods, and QuickBooks tracks the money. Method changes QTY in stock as soon as goods ship or arrive. QuickBooks changes its Quantity on Hand later, when you invoice the sale or record the Bill.

Accounting QTY on hand vs QTY in stock

Accounting QTY on hand

QTY in stock

Where it comes from

QuickBooks Online's Quantity on Hand (QOH). Method reads it from QuickBooks, and you can't change it in Method.

Method's own count, also called Quantity in Stock (QIS).

What it counts

One number for the whole company. QuickBooks doesn't track locations.

Each location separately. The Items List shows the total across all locations.

What it's for

Your books: inventory value and cost of goods sold.

Day-to-day stock: taking orders, shipping, receiving and moving goods.

What changes it

Transactions recorded in QuickBooks, such as Invoices, Bills and Inventory Adjustments.

Shipping, receiving, Stock Transfers, Stock Adjustments and reverts in Method.

When you turn on Inventory Management, Method copies each item's QuickBooks Quantity on Hand into QTY in stock, so the two start out the same.

After that, they change at different moments. Method changes QTY in stock when the goods move. QuickBooks changes Quantity on Hand when the Invoice or Bill is recorded.

What you do

QTY in stock (Method)

Accounting QTY on hand (QuickBooks)

Ship a Sales Order

Down right away

No change yet

Create the Invoice from the order

No change

Down when the Invoice syncs

Receive a Purchase Order

Up right away

No change yet

Create the Bill from the order

No change

Up when the Bill syncs

Make a Stock Adjustment

Up or down

Up or down when the adjustment syncs

Ship or receive a Stock Transfer

Moves between locations. The total doesn't change

No change

Revert a shipment or receipt

Undone

No change

Create a Sales Receipt or Credit Memo, or change a quantity, in QuickBooks

No change

Changes

So a difference between the two columns is normal for a while. It closes once you invoice what you've shipped and bill what you've received.

What to do when the quantities don't match

If QTY in stock is…

The usual cause

What to do

Lower than Accounting QTY on hand

Goods have shipped but aren't invoiced yet.

Open the Sales Order and use Convert to → Invoice.

Higher than Accounting QTY on hand

Goods have arrived but aren't billed yet.

Open the Purchase Order and use Convert to → Bill.

Different, and every order is invoiced and billed

Something changed the quantity in QuickBooks only, such as a Sales Receipt or a manual quantity change.

Find the QuickBooks transaction that caused it, and check with your accountant before you change stock in Method. A Stock Adjustment also syncs to QuickBooks, so it would change QuickBooks' number a second time.

Comparing the two columns is a good month-end check. On the Items List, look for items where the two numbers differ.

📌 Note: Make all stock changes in Method. Sales Receipts and quantity changes made directly in QuickBooks Online change QuickBooks' Quantity on Hand but not Method's QTY in stock, so the two drift apart.


What changes each quantity number

When you…

QTY in stock

QTY committed

QTY expected

Save a Sales Order

—

Up

—

Ship a Sales Order

Down

Down

—

Save a Purchase Order

—

—

Up

Receive a Purchase Order

Up

—

Down

Save a Stock Transfer as Open

—

Up at the source

Up at the destination

Ship a Stock Transfer

Down at the source

Down at the source, if it was saved as Open first

Up at the destination, if it wasn't saved as Open first

Receive a Stock Transfer

Up at the destination

—

Down at the destination

Make a Stock Adjustment

Up or down

—

—

Revert a shipment or receipt

Undone

Undone

Undone

Edit quantities on an open order

—

By the difference (Sales Orders)

By the difference (Purchase Orders)

Create or edit an Invoice or Bill

—

—

—

QTY available recalculates whenever QTY in stock or QTY committed changes. Invoices and Bills never change any of these numbers, because they're accounting documents.


Two rules to know

  • Nothing you do can take QTY in stock below zero. Method blocks anything that would, such as shipping more than you have, transferring more than is available or decreasing stock too far. Add stock first, with a Stock Adjustment or by receiving a Purchase Order.

  • QTY available can go below zero. You can sell more than you have. Method saves the order and shows a message, because selling ahead of incoming stock is normal.

📌 Note: The one exception to the first rule is when you turn on Inventory Management. An item with a negative quantity in QuickBooks starts with negative stock in Method. Nothing can push it lower, and adding stock brings it back up.


What gets tracked

  • Only Inventory Part items. Service and Non-Inventory items have no stock numbers.

  • Only items linked to a location. See Manage inventory locations and items.

  • Only inventory orders: Sales Orders and Purchase Orders created in Method while Inventory Management is on. Older orders, orders created in QuickBooks, and orders created while Inventory Management was off never affect stock.

The QTY available on an order line is a snapshot from when you picked the location. It doesn't update live if a teammate changes stock at the same time, so refresh the page if you think something has changed.

Did this answer your question?