To record inventory on hand, count every item in your warehouse, write down the actual quantity, and enter that number into your system of record. In QuickBooks, use Adjust Quantity on Hand under the Inventory menu. The counted number replaces whatever the system shows. That single update brings your records back to reality.
Reviewed September 2026. Figures are worked from the assumptions stated beside them, so you can substitute your own and the arithmetic still holds.
Reviewed and updated: June 2025
Book a callInventory on hand is the physical count of goods sitting in your warehouse or storage location right now. It is not what you ordered last week. It is not what is on a truck. It is what a person could walk over and touch today.
This number is different from inventory on order, which is stock you have paid for but not yet received, and inventory in transit, which is moving toward you but not yet yours to ship.
Every other inventory decision, when to reorder, what to promise a customer, how much cash is tied up in stock, starts with an accurate on-hand count. If that number is wrong, every decision built on it is also wrong. Get this one right first.
If you would rather not compare products, describe how your operation already works and we build the system around it.
No build cost. You see it running on your own process first, and the monthly subscription starts only once it is live.
Book a callInaccurate on-hand counts cost real money in two directions. Overselling means you promise stock you do not have. Underselling means you turn away orders because the system shows zero when the shelf is full.
QuickBooks inventory quantities drift from reality when receipts are logged late or shipments are entered in the wrong place. That drift compounds over weeks until the system number and the shelf number no longer resemble each other.
Accurate on-hand data tells you exactly when to reorder, which keeps you off emergency freight. The IRS is direct about why this matters legally: IRS Publication 538 states, "To figure taxable income, you must value your inventory at the beginning and end of each tax year."
GS1, the global body behind barcode standards, notes that scan-based tracking "enables real-time visibility of inventory" across the supply chain. Read their barcode standards at gs1.org. Money tied up in stock you cannot see is money you cannot use elsewhere.
The 2 main methods for recording inventory on hand are periodic and perpetual, and choosing between them depends on how much your team can capture in real time.
Periodic inventory means you count everything at a scheduled interval, then update your records in bulk. Monthly or quarterly counts are common. It is simple and needs no special software, but your records lag behind reality between counts.
Perpetual inventory means you update the on-hand quantity every time a unit moves in or out. Every receipt, every pick, every return adjusts the count at once. This is more accurate, but it only works if your team captures every movement without skipping steps.
Most small distributors start with periodic counting and move toward perpetual as they add scanning or warehouse software. Neither method is wrong. The right one is the one your team will actually follow.
Before anyone walks the warehouse with a clipboard, every SKU needs a unique identifier in your system. A count that maps to the wrong item is worse than no count at all.
Check that item names in your count sheet match exactly what is in QuickBooks. One extra space or a different abbreviation creates a duplicate record and splits your on-hand quantity across 2 lines.
Assign a storage location to each item. Aisle, shelf, and bin numbers work well. Then print or export your count sheet sorted by location, not by item name. A counter walking Aisle A should not have to jump around a list to find the next item. Sorting by location cuts count time and reduces the chance of skipping a shelf.
Stop receiving and shipping while the count is in progress. If stock moves during a count, you cannot know whether the counter saw it before or after the move. That uncertainty makes the count unreliable.
For operations that cannot shut down completely, use a cutoff document. Write down every item that moves during the count window, note the direction (in or out), and apply those movements as adjustments after you enter the main count.
Even a 1-hour freeze on a small warehouse makes matching far easier. A 5-person team counting 200 SKUs can finish a zone in under an hour if the item list is sorted by location. Plan the freeze, tell the team, and stick to it.
Off-the-shelf means fitting your process to the software. We do it the other way round, and the first look costs nothing.
Book a callUse 2 counters per zone and have them count independently. One person counts; the other records. Then swap and recount anything where the numbers differ. Two independent counts catch the errors that a single counter misses.
Record counts on a printed sheet or a mobile device. Do not enter numbers into the live system during the count. If a counter types directly into QuickBooks while walking the floor, any interruption or recount creates confusion about what is already saved.
Count in the unit of measure that matches your records. If QuickBooks tracks an item by the case, count cases, not individual units. Flag damaged or unsellable items on a separate line so they do not inflate your usable on-hand totals. Unsellable stock is a real cost, but it belongs in a different bucket.
In QuickBooks, open the Inventory menu and select Adjust Quantity on Hand. This is the correct path for updating on-hand quantities after a physical count.
Enter the actual counted quantity for each item. Do not calculate the difference yourself and enter that. QuickBooks compares the number you type against the current system quantity and posts the adjustment automatically. Typing the difference instead of the actual count is a common mistake that doubles or cancels the adjustment.
Assign each adjustment to the correct account, usually an inventory adjustment or shrinkage expense account. Check with your bookkeeper if you are unsure which account to use.
Before you close the screen, save a copy of the count sheet. A printed page or a scanned PDF stored in a shared folder gives you a paper trail if a question comes up later.
An inventory variance is the gap between the quantity your system showed and the quantity you actually counted. Small variances often point to unit-of-measure mismatches; large ones signal a process gap that will keep growing.
Common causes include:
For each large variance, write down the most likely cause before you close the adjustment. That note becomes the basis for fixing the process. A variance with no documented cause will reappear at the next count, often larger. The goal is not just to correct the number today but to stop the same gap from opening again.
Cycle counting keeps on-hand accuracy high without shutting down the warehouse for a full count. Count a rotating subset of items every week so that every SKU gets checked several times a year.
Here is what the habit looks like in practice:
These habits shrink the size of variances you find at the next full count. The NIST Manufacturing Extension Partnership recommends building inventory accuracy into daily routines rather than treating it as a periodic event. Cycle counting best practices for fulfillment centers follow the same principle: small, frequent checks beat large, infrequent ones.
No build cost. The subscription starts once it is live and doing the job, not before.
Book a callSpreadsheets and paper count sheets work until they do not. The moment 2 people edit the same file at once, one person's changes overwrite the other's.
Paper count sheets get lost between the warehouse floor and the office desk. Handwritten numbers get misread. A 4 becomes a 9. A count sheet for 300 items takes time to key in, and every keystroke is a chance for a typo.
QuickBooks handles accounting well, but it lacks bin-level location tracking, mobile scanning, and multi-user receiving workflows. Those gaps are where on-hand records drift. How to reduce inventory variances starts with closing the gaps that paper and spreadsheets leave open. A system that captures the movement at the moment it happens removes the delay that causes most of the drift.
If your team spends hours each week reconciling counts, the manual process is already costing more than a software fix. Consider the math: 3 people spending 4 hours a week on manual matching at $22 an hour, the median rate for stock clerks according to the US Bureau of Labor Statistics, adds up to $13,728 a year. That figure does not include the cost of errors those hours fail to catch.
A custom system can capture receipts, picks, and adjustments in real time and push the updated totals back to QuickBooks automatically. QuickBooks integration for warehouses built this way means your accounting stays in QuickBooks and your warehouse data stays accurate without double entry.
Custom warehouse management systems built around how your warehouse already works do not need you to replace QuickBooks or learn a full ERP. The right tool fills only the gaps that exist in your operation. Inventory management software for small distributors should fit your process, not force you to fit its template. If the manual work is costing more time than it saves, that is the signal to act.
Use this checklist before, during, and after every physical inventory count.
Before the count:
During the count:
After the count:
A count you finish and document is worth far more than a perfect count you never start.
Personal-use inventory is not tracked the same way as business stock. If you take items from your business inventory for personal use, remove them from your on-hand count and record the withdrawal as an owner draw or personal expense in QuickBooks. Do not leave personal-use items in the inventory account, because that overstates the value of your business stock.
Inventory should be recorded at cost, meaning what you paid to acquire it, and updated every time stock moves in or out. For tax purposes, IRS Publication 538 needs you to value inventory at both the start and end of each tax year. For day-to-day operations, record every receipt against a buy order and every shipment against a sales order so the on-hand quantity stays current.
Manual tracking works best with a printed count sheet sorted by storage location, a scheduled count cycle (weekly, monthly, or quarterly), and a single person responsible for entering the results. Use a two-counter system to catch errors. Log every receipt and shipment on paper the moment it happens, then transfer to your system the same day. Delays between the physical movement and the system entry are where manual records fall apart.
To count inventory by hand, print a count sheet listing every item and its storage location. Walk the warehouse zone by zone. Count each item in the unit of measure your records use (each, case, or pallet). Write the count on the sheet. Have a second person recount any item where you are unsure. Enter the final numbers into QuickBooks using Adjust Quantity on Hand. Investigate any item where the counted number differs from the system number by more than a small rounding gap.
Start by separating small variances from large ones. A difference of 1 unit on a high-volume item is often a timing issue, such as a receipt logged after the count started. A difference of 10 or more units needs a root-cause investigation. Check for unlogged receipts, picking errors, items stored in a second location, and damaged goods that were never written off. Document the cause, fix the process, and enter the adjustment in QuickBooks.
The most common reasons are receipts logged after stock hit the shelf, shipments entered after the truck left, and items received to the wrong SKU. Each delay or mismatch creates a gap between the system and reality. Running a physical count and using Adjust Quantity on Hand corrects the current number. Fixing the receiving and shipping workflow prevents the gap from reopening.
Cycle counting means counting a small group of items every week instead of counting everything at once. It keeps accuracy high without a warehouse shutdown. Use it once you have completed at least one full physical count and know your baseline on-hand quantities. Count your fastest-moving items most often, and rotate through slower items over a quarter. Cycle counting best practices for fulfillment centers suggest counting high-velocity SKUs at least once a month.
Move beyond spreadsheets when reconciling counts takes more time than the count itself, when 2 or more people need to update inventory at the same time, or when variances keep reappearing despite your best efforts to fix them. A custom system that feeds QuickBooks in real time removes the manual entry step that causes most of the drift, and it does not need replacing QuickBooks or adopting a full ERP.
Personal-use inventory is not tracked the same way as business stock. If you take items from your business inventory for personal use, remove them from your on-hand count and record the withdrawal as an owner draw or personal expense in QuickBooks. Do not leave personal-use items in the inventory account, because that overstates the value of your business stock.
Inventory should be recorded at cost, meaning what you paid to acquire it, and updated every time stock moves in or out. For tax purposes, IRS Publication 538 needs you to value inventory at both the start and end of each tax year. For day-to-day operations, record every receipt against a buy order and every shipment against a sales order so the on-hand quantity stays current.
Manual tracking works best with a printed count sheet sorted by storage location, a scheduled count cycle (weekly, monthly, or quarterly), and a single person responsible for entering the results. Use a two-counter system to catch errors. Log every receipt and shipment on paper the moment it happens, then transfer to your system the same day. Delays between the physical movement and the system entry are where manual records fall apart.
To count inventory by hand, print a count sheet listing every item and its storage location. Walk the warehouse zone by zone. Count each item in the unit of measure your records use (each, case, or pallet). Write the count on the sheet. Have a second person recount any item where you are unsure. Enter the final numbers into QuickBooks using Adjust Quantity on Hand. Investigate any item where the counted number differs from the system number by more than a small rounding gap.
Start by separating small variances from large ones. A difference of 1 unit on a high-volume item is often a timing issue, such as a receipt logged after the count started. A difference of 10 or more units needs a root-cause investigation. Check for unlogged receipts, picking errors, items stored in a second location, and damaged goods that were never written off. Document the cause, fix the process, and enter the adjustment in QuickBooks.
The most common reasons are receipts logged after stock hit the shelf, shipments entered after the truck left, and items received to the wrong SKU. Each delay or mismatch creates a gap between the system and reality. Running a physical count and using Adjust Quantity on Hand corrects the current number. Fixing the receiving and shipping workflow prevents the gap from reopening.
Cycle counting means counting a small group of items every week instead of counting everything at once. It keeps accuracy high without a warehouse shutdown. Use it once you have completed at least one full physical count and know your baseline on-hand quantities. Count your fastest-moving items most often, and rotate through slower items over a quarter. Cycle counting best practices for fulfillment centers suggest counting high-velocity SKUs at least once a month.
Move beyond spreadsheets when reconciling counts takes more time than the count itself, when 2 or more people need to update inventory at the same time, or when variances keep reappearing despite your best efforts to fix them. A custom system that feeds QuickBooks in real time removes the manual entry step that causes most of the drift, and it does not need replacing QuickBooks or adopting a full ERP.
A 30 minute call, your operation mapped, and a clear picture of what we would build. No obligation and nothing to install.
Book a callThe rest of this guide, for the parts of the job this page does not cover.
