Trace an inventory difference through item identity, units, locations, timing, and movement records before making a correction. Includes a practical investigation record.
On this page
The shelf holds 18 cable packs, while the inventory record shows 24. Changing the record to 18 would make the screen agree with the shelf, but it would leave the team unable to explain what happened. A missed issue, an unrecorded transfer, and a counting error each call for a different response.
Begin by establishing that the physical count and recorded quantity describe the same item, place, unit, and moment. Then trace the relevant movements. A useful investigation ends with an explained correction or a clearly owned unresolved difference, plus a change to the process that allowed the problem.
Define the quantity you are comparing
Identify the item by its maintained SKU or other stable identifier. Similar descriptions can hide differences in size, packaging, or specification. Check the label on the physical stock against the item record before comparing numbers.
Follow a hypothetical service visit through customer booking, staffing, equipment, delivery, and follow up. See how named owners keep changes consistent across the work.
·7 min read
Operations Insights
Record the location and count time. A total across two storage rooms cannot be compared directly with one shelf. If the item uses batch or serial tracking, keep that identity within the count scope. A correct total can still conceal stock recorded against the wrong batch or individual unit.
Distinguish recorded stock on hand from the quantity available for new work. Reserved stock may still be physically present. Incoming stock may be on an order but not yet received. Neither should be treated as a missing item merely because the figures differ.
Choose one base unit for the comparison. If the item is recorded in individual pieces, convert sealed cartons and opened packs into pieces before totaling them. Write down the conversion used so another person can reproduce it.
Recount without changing the evidence
Arrange a second physical count when the first result is uncertain or consequential. Give the counter the item identity, location, and unit. Where practical, let them establish the physical result before seeing the expected quantity, so the recorded total does not become a target to reproduce.
Check adjacent shelves, receiving areas, workbenches, vehicles, and any other location within the agreed scope. Separate damaged or otherwise unusable stock from missing stock. A damaged item can still be physically present even when it should not be offered for use.
Record what was observed, including unopened packs and loose units. Preserve the first count and its circumstances rather than replacing it without explanation. If the second count differs, resolve the counting method before investigating the inventory history.
Control movement during the count under the team's operating process. If work must continue, record each receipt, issue, or transfer during the count window. The later reconciliation needs that bridge between the recorded snapshot and the physical observation.
Follow the movement history in order
Start from the most recent reliable count or verified balance. Trace receipts, issues, returns, transfers, and adjustments through the count time. Compare each relevant record with its supporting evidence rather than relying on the description alone.
Scrollable article table
Possible explanation
Evidence to check
Question to resolve
Receipt not recorded
Delivery and receiving record
Did these goods arrive before the count?
Issue not recorded
Release or job record
Did stock leave before the count?
Transfer incomplete
Source and destination records
Is the stock elsewhere or still in transit?
Unit mismatch
Item unit and package contents
Were cartons entered as pieces?
Duplicate movement
References and movement history
Was the same physical event recorded twice?
Timing difference
Event time and entry time
Does the snapshot include later activity?
Check the item and location on each movement. A receipt entered against a similar SKU can produce one shortage and one excess. Searching only the shortage record may miss the matching error.
Ask the people who handled the stock for factual context. “Six packs were taken for the Tuesday job” is a lead to verify against that job. Keep an unconfirmed recollection distinct from a supported explanation.
Separate a timing difference from a missing movement
An inventory event and its data entry may happen at different times. Suppose goods were counted at 3 p.m., but a 2 p.m. issue was entered at 4 p.m. Comparing the physical count with a later screen without considering that issue can create a misleading variance.
Write a short sequence showing what happened physically and when it was recorded. Use the same cutoff for the reconciliation. Where a system report uses an entry date rather than the physical event time, explain the difference in the investigation record.
For a transfer, establish the stock's actual position at the cutoff. It may have left the source while awaiting receipt at the destination. Use the team's transfer process to resolve that state; do not add stock at both locations to make separate counts look correct.
The Purchase Request Checklist covers the receiving handoff. This investigation starts after the team needs to reconcile the receiving or movement evidence with the stock that is actually present.
A hypothetical cable pack investigation
Consider a hypothetical maintenance team whose storage-room record shows 24 cable packs. A physical count finds 18. The item is recorded in packs, and both counters confirm that each counted pack matches the SKU. There are no loose packs in the receiving area or vehicle storage.
The investigator starts from the last verified count of 30 packs. A recorded issue accounts for six packs. A second job record shows another six released before the current count, but the corresponding inventory issue was never entered.
The physical sequence is therefore 30 minus six minus six, leaving 18. The difference is supported by the release record and the receiving technician's confirmation. The authorized inventory operator follows the approved correction process for the missing issue and preserves the job reference.
The team also changes the release handoff: the person releasing stock must record the movement or explicitly hand that action to a named colleague. This is a hypothetical diagnosis, not a customer result. If the second release could not be established, the six-pack difference would remain unexplained rather than acquiring an invented cause.
Correct the record through the authorized process
Choose a correction that represents the finding. A missing movement and a genuine unexplained shortage should not silently receive the same description. Follow the system's approved way to record or correct the event, retaining the relevant reason and source references.
Have the responsible person review the proposed change where the organization's rules require it. Avoid repeatedly adjusting the current balance while the investigation continues. Multiple unexplained changes make it harder to reconstruct the original difference.
After the correction, reconcile the affected item and locations again. If new movements occurred during the investigation, include them in this later check. The corrected current balance may legitimately differ from the earlier physical count.
Keep any financial effect with the person responsible for inventory and financial records. An operational explanation does not by itself determine valuation, loss treatment, or other accounting decisions.
Keep a short investigation record
Use these fields for a difference that needs follow through:
Scope: Item identity, location, tracking identity, and base unit.
Cutoff: Count time, recorded snapshot, and movements during counting.
Observation: First count, recount, method, and evidence references.
Variance: Comparable recorded quantity, physical quantity, and difference.
Investigation: Relevant receipts, issues, transfers, and open questions.
Finding: Supported explanation or the remaining unexplained difference.
Correction: Authorized action, operator, date, and resulting reference.
Verification: Later balance check and activity included in it.
Prevention: Process change, owner, and date to review its use.
Figena's Inventory workspace supports structured item and location records, units, batch or serial tracking, and a movement history for stock in, out, adjustments, and transfers. Use that history to investigate the sequence. Physical checks and supporting records establish what happened; an adjustment should preserve the explanation the team reached.
Separate decisions, actions, and open questions in meeting notes. Use a practical handoff template to confirm owners, define completion, manage dependencies, and review the result.
Decide which inquiries deserve the next sales step using evidence of need, fit, timing, and decision process. With a decision matrix, two hypothetical examples, and a reusable lead review.
