Blog
Choosing a system
Perspective

QuickBooks Inventory Management: What the Books Know and What the Shelf Knows

QuickBooks can tell you how many you own and what they cost. Jane Mercer follows one item from purchase order to shipment to show what it can't see.

Manager in a white shirt working on a laptop at a standing desk on a manufacturing and warehouse floor

Here is an item record in QuickBooks Online, with made-up figures. Item: 3/4-inch brass ball valve. Quantity on hand: 140. Reorder point: 50. The unit cost is filled in, and the item shows up on the Inventory Summary report.

On the shelf, there are 128 of them, split between a bin in aisle 4 and a pallet by the dock that nobody has put away yet.

Both numbers can be true at once. QuickBooks Online inventory answers the first one: how many you own and what they cost. The second, where they are and whether the count is right, gets answered on the floor. If you're deciding what should run the warehouse itself, our posts on choosing a warehouse system cover the wider options. This one walks a single item through QuickBooks and marks where the warehouse leaves the system.

How inventory works in QuickBooks Online

Inventory tracking comes with QuickBooks Online Plus and Advanced. On Simple Start or Essentials, Intuit says you can buy the inventory add-on or upgrade your subscription to start tracking it. Intuit's own setup guide covers the switch.

Once it's on, each inventory item carries a quantity on hand. Receive against a purchase order and the quantity goes up by what you received. Sell it and the quantity goes down. Set a reorder point and QuickBooks tells you when an item runs low.

On the cost side, QuickBooks Online values inventory using first in, first out (FIFO) or moving average cost. Intuit warns that the method can't be changed later, and that if you create an inventory item before choosing, it defaults to FIFO and the choice disappears from your settings. Pick it before you set up a single item.

For an accountant, that covers most of what inventory needs to do: a quantity, a cost method and a value. I mean that as praise: a system that keeps the books well is worth keeping.

What QuickBooks Desktop Enterprise adds

Desktop Enterprise goes further. With Advanced Inventory, which comes with the Platinum and Diamond subscriptions, you get multiple inventory sites, lot or serial numbers, barcode scanner support and cycle counts on an Android device. Intuit's help for multiple sites describes stock tracked by warehouse, transfers between sites and between bins, and an Items by Bin Location report.

So the Desktop Enterprise answer to "where is it?" can be "site 2, bin 14-C". The catch is how the record gets there. A transfer, a bin or a lot number is only as current as the person who keys or scans it in. If you're weighing Desktop against Online for this reason, our post on what is changing with QuickBooks Desktop covers which editions are still sold and what doesn't convert to Online.

One item, purchase order to shipment

Here is the valve again, this time moving. At each step, the question is what QuickBooks Online has a place to record and what only the floor knows.

StepWhat QuickBooks Online recordsWhat only the floor knows
Purchase orderItem, quantity, cost, vendorNothing yet
ReceivingQuantity received, which updates on handWhich pallet, whether the count matched the label
PutawayNo step for itWhich bin it went to
Moves and overflowNo step for itThe pallet by the dock, the second bin
PickingNo step for it; quantity drops when the sale is enteredWhich bin it came from, whether it was the right item
Shipping and invoicingQuantity sold, cost of goods sold, the invoiceWhich carton, which lot
CountingAn inventory quantity adjustmentWhich bin was wrong, and what the counter found there

QuickBooks Online records the order, the receipt, the sale, the count adjustment and the dollars attached to each. Everything in the right-hand column happens in the building, and unless someone records it, it lives in the warehouse lead's head.

That right-hand column is where reconciliations go sideways. I used to approve count adjustments in a batch every Friday. One week I asked a counter why the same bin needed adjusting three Fridays running, and she showed me an overflow location that existed only on a whiteboard. The stock had never left the building. The books had no way to know about a location nobody had ever entered.

Is QuickBooks good for inventory management?

For the books, yes. Quantity on hand, reorder points, FIFO or average cost and an inventory value are the parts finance needs, and QuickBooks Online Plus and Advanced do them.

For the floor, it depends on how much of your inventory question is "where". A business with one stockroom, a short item list and one person who receives and ships can live inside QuickBooks Online for a long time. The strain shows up when:

  • the same item sits in more than one place, and someone has to know which
  • you buy or sell items with lot or serial numbers, and a customer or auditor asks which one shipped
  • receipts and counts are entered after the fact by someone who wasn't there
  • more than one person picks, and nothing checks that they took the right item

The first physical-to-book reconciliation I ran came out close in dollars, and I was relieved until I read the lines. Overages on some items and shortages on others had canceled each other out, and the small total told me nothing about whether any single count was right. Any accounting system will report a total like that faithfully, because a total is all it was asked for.

Your options when QuickBooks stops

There are four, and the right one depends on what is costing you money.

  1. Stay and tighten the process. If the problem is late entry, a receiving routine and a weekly count of your fastest movers may be enough. It costs time, not software.
  2. Move to Desktop Enterprise with Advanced Inventory. Sites, bins, lots and serials live inside QuickBooks Desktop Enterprise. Check the Desktop timeline first, and remember the data still gets keyed or scanned in by someone.
  3. Add a warehouse system that posts to QuickBooks Online. The books stay in QuickBooks. The warehouse system holds bins, lots and the scan history, and sends the results to QuickBooks so nobody retypes them.
  4. Move to an ERP. If the business has outgrown QuickBooks on the accounting side too, the warehouse question becomes part of a larger selection.

What to ask any QuickBooks inventory add-on

  • Which QuickBooks edition does it connect to, Online or Desktop, and what exactly does it post there?
  • Does it keep bins, lots and serials in its own records, or try to push them into QuickBooks?
  • When its quantity and QuickBooks' quantity disagree, which one wins, and who gets told?
  • How does a count adjustment reach QuickBooks: by item, or with the bin and the reason attached?

For comparisons by name, the QuickBooks rows of our warehouse management software shortlist list the products that publish a QuickBooks connection.

Where Endpoint fits

Endpoint Cloud is the third option. It is its own warehouse system, with bin locations, lot and serial tracking and pack verification, and it connects to QuickBooks Online so scanned receipts, picks and counts flow into your accounting without anyone retyping them. That connection is to QuickBooks Online only; there is no Desktop connection.

Before you change anything, count one item by bin and put the result next to its QuickBooks quantity on hand. If the two agree, QuickBooks may be all the inventory system you need for now. If they don't, start with the bin that disagrees.

Share this post

More from the blog

Subscribe to the Endpoint Blog

Stay connected with Endpoint and receive new blog posts in your inbox.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.