A physical count can be perfectly accurate and still lead to the wrong customer promise. You may have 600 units on shelves, carts, or packing tables, but some are reserved, missing labels, waiting for a quality decision, damaged, or sitting in an unknown status.
If all 600 appear as available inventory, sales may accept an order production cannot honestly fulfill. Purchasing may reorder the wrong item. The team may start another batch while nearly finished stock waits for one small action. Cash looks like inventory, but part of that inventory still cannot move.
A sellable inventory reconciliation separates the physical count from the quantity the business can actually promise today. The goal is not a more impressive number. It is an honest one.
A correct physical count is only the starting point
The physical count answers, “How many units are here?” It does not answer, “How many can we sell?”
A filled skincare jar may still need a label and final review. A candle may be boxed but assigned to a wholesale order. Soap may be cut but still curing. A food product may be sealed yet held while required batch paperwork is completed. A damaged carton may protect a usable product, but someone still has to inspect and rework it.
These distinctions affect inventory cash flow and reveal cash tied up in inventory because each unit represents materials, packaging, labor, and attention already committed. They also affect customer trust. A unit should not support a promise until every required step is complete and it is not already committed elsewhere.
The broader guide to cash tied up in products that are not ready to sell explains why these waiting points matter. The reconciliation below turns that idea into a weekly count control.
Give every physical unit one status
Use status buckets that are mutually exclusive. Every unit belongs in one bucket at the time of the count—not two, and not none.
- Available to promise: Complete, released, correctly packaged, and not reserved for an order.
- Committed: Sellable, but already reserved for a customer, wholesale order, subscription, sample commitment, or replacement.
- Incomplete: Missing a production, curing, assembly, labeling, or packaging step.
- Quality hold: Waiting for a required check, review, test, documentation decision, or release approval.
- Damage or rework: Not sellable in its current condition; inspect, repair, repackage, downgrade, or remove it according to the business’s rules.
- Unknown: Physically present, but its product version, lot, ownership, count unit, or status cannot be confirmed.
“Unknown” is not a permanent storage category. It is a control signal. If units cannot be identified, they should not quietly increase the number available to sell.
Reconcile 600 units without double-counting
Suppose a business counts 600 units of one SKU across its finished-goods shelf, packing table, quality area, and rework cart.
| Status | Units | What the number means |
|---|---|---|
| Available to promise | 220 | Released and uncommitted |
| Committed | 150 | Sellable but reserved |
| Incomplete packaging | 90 | Product present; labels or cartons still needed |
| Quality hold | 70 | Awaiting a required review or release decision |
| Damage or rework | 40 | Not sellable in current condition |
| Unknown | 30 | Identity or status not verified |
| Physical count | 600 | All buckets reconciled |
The control equation is simple:
Physical count = available + committed + incomplete + quality hold + damage/rework + unknown
For this count:
600 = 220 + 150 + 90 + 70 + 40 + 30
The available-to-promise check reaches the same answer from the other direction:
Available to promise = physical count − committed − incomplete − quality hold − damage/rework − unknown
220 = 600 − 150 − 90 − 70 − 40 − 30
The business owns 600 physical units, but it can promise only 220 new units today. The 150 committed units may be ready to ship, yet promising them again would create an allocation problem. The remaining 230 units need work or a decision before they can contribute to a new sale.
Fix the status that blocks the next cash movement
Do not combine every unavailable unit into one vague “not ready” total. The reason determines the action.
For incomplete packaging, confirm the missing component, quantity, expected arrival, and owner. For a quality hold, record the exact decision or evidence still required. For rework, decide whether recovery is economically and operationally sensible rather than letting the cart become permanent inventory. For unknown units, stop and identify them before changing the count.
Then rank the work using a short decision window. Customer commitments and safe release requirements come first. Among eligible items, favor actions that make real units sellable soon without bypassing curing, documentation, safety, or quality controls.
When several open batches are competing for limited labor or cash, use the unfinished-batch cash-release queue to decide which completion effort should go first.
Run the count as a controlled weekly routine
Pick one consistent cut-off time. Pause movements for the SKU if practical, or record every movement that occurs during the count. Count by location so shelves, hold areas, packing tables, and rework carts are not missed.
Use one row per status and location. The person counting should not assume a unit is released because it looks complete. Check the release record, order allocation, packaging condition, and product identity. If evidence is missing, place the unit in the appropriate hold or unknown bucket.
Before closing the count:
- Confirm that all status buckets sum to the physical count.
- Compare available-to-promise units with open sales channels and order commitments.
- Assign one owner, next action, and due date to each blocked bucket.
- Record adjustments with a reason instead of overwriting yesterday’s quantity.
- Investigate repeated differences by location, product version, or process step.
This routine also improves production planning. If 90 units repeatedly wait for labels, the answer may be better packaging readiness—not another production run. If quality holds grow faster than reviews close, release capacity is the constraint.
Watch the trend, not just today’s snapshot
A single reconciliation protects today’s promise. A weekly series reveals the operating pattern.
Track available units, committed units, blocked units, unknown units, and the age of the oldest exception. If physical inventory rises while available stock remains flat, cash is accumulating somewhere between production and release. If unknown units keep returning, product identification or movement recording needs attention.
Pair the status count with inventory turnover guidance to see both sides of the issue: whether units are honestly available now and how quickly stock becomes sales over time.
Practical takeaway
Count one important SKU this week and force every physical unit into exactly one status. Reconcile the buckets to the shelf total, then publish only the available-to-promise quantity to sales and ordering decisions.
The useful question is not “How much product do we have?” It is “How much can we honestly promise, what is already spoken for, and what specific action will release the rest?”
Frequently asked questions
Is committed stock still finished goods?
It may be fully finished and sellable, but it is not available for a new promise. Keep committed units separate so the same stock is not allocated twice.
Should quality-held units count as available inventory?
No. Units waiting for a required check or release decision should remain unavailable until the business’s established requirements are completed.
How often should a sellable-inventory reconciliation be done?
Run it at least weekly for important SKUs and more often during launches, wholesale fulfillment, shortages, or periods when inventory status changes quickly.
What if a unit could fit more than one exception bucket?
Use one primary status that describes the current controlling blocker. Record secondary notes separately, but never count the same unit in two buckets.
