Quantity on Hand and Quantity Available

When working with inventory you will often see QuickBooks describe inventory quantity using two different terms. Quantity on Hand and Quantity Available.

The terms are fairly straightforward, but settings can change the way QuickBooks calculates.

Do you really know what the number you are looking at means?

Quantity on hand means just that. If your QuickBooks company file ‘thinks’ you have twenty-five widgets in stock, that’s the quantity you have on hand.

Quantity Available though can be manipulated. The purpose of quantity available is to show the QuickBooks user more than just how much inventory is on hand. It shows what other transactions in the system may be affecting the amount that is truly available.

The screenshot above shows preference settings that affect quantity available amounts. Rock Castle Construction in the sample file has marked both of the options. When QuickBooks determines what should be shown as quantity available, it will take into account both sales orders and pending builds.

Sales orders are a non-posting transaction. They record the order of a customer that will be invoiced later. This may be because the customer wants a later ship date, it may be because there is insufficient quantity available to fulfill the order, or it could be a special order.

Whatever the reason, QuickBooks will subtract these amounts from the quantity on hand before displaying the quantity available.

A build in QuickBooks refers to the creation of Inventory Assembly type items. Assemblies are items that are made up of various components. Usually these components are other inventory items in the company file.

‘Making’ an assembly item is called a build. If there are insufficient quantities of any one component part, the build transaction cannot be completed. It can be set to Pending however.

That s the second option. Subtract pending builds from the quantity on hand before computing the quantity available.

So the formula would be Quantity on hand, less Quantity on sales orders, less quantities on pending builds. This would create the Quantity Available.

Hector Garcia, CPA
Certified Advanced QuickBooks ProAdvisor
12401 Orange Drive #136
Davie, FL 33330
954-414-1524
hector@garciacpa.com

Hector Garcia

Hector Garcia

Hector Garcia is a CPA and QuickBooks Consultant.
Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022