Inventory Reconciliation: Fix Stock Count Differences

Inventory reconciliation means comparing your stock records with what is physically present, then explaining and correcting the differences. Start with one SKU, one location and one agreed time. Count the goods, trace movements around that time, separate unavailable units, and approve any correction only after the evidence supports it. Changing a number until two screens match can hide the problem instead of fixing it.

This guide is for ecommerce sellers holding goods in China for individual customer orders shipped by air parcel. Use it when your store shows stock that the warehouse cannot pick, or when a warehouse count appears higher than your records. It is not a guide to financial inventory valuation or bulk sea-freight replenishment.

What should inventory reconciliation compare?

Agree on the meaning of each number before asking someone to count again. Physical stock includes goods that are present but cannot be sold: damaged units, returns awaiting inspection, and products already allocated to orders. Available stock answers a narrower question: how many units can you promise to another customer?

Your store and warehouse may use different labels for these quantities. Ask which events increase or reduce each field. Does an order reserve stock immediately, when it is accepted, or when picking begins? Does a return become available on arrival or only after inspection? Write down the actual rules instead of assuming them.

The UTS fulfillment workflow separates purchasing, warehouse arrival, inspection, preparation and dispatch. Use those handoffs to agree which goods belong in each count. This does not mean every store connection uses the same inventory fields or update timing; confirm your own setup during onboarding.

Keep on-hand, reserved and unavailable quantities distinct. If your system already excludes reserved units from its available figure, do not subtract them again. A reliable comparison uses the same definition on both sides, not merely two columns with similar names.

Set a cutoff time and identify the exact variant

Stock moves while people investigate it. A count taken at 10:00 cannot be compared directly with a report exported at 11:30 if orders were picked in between. Choose a cutoff time, include the time zone, and save the relevant records before anyone changes the balance.

For a small affected area, agree a brief pause in movement if the warehouse can support it. Otherwise, log every receipt, pick, return and transfer during the count. Inventory reconciliation does not require stopping the entire operation, but it does require a way to account for moving goods.

Record the SKU, meaning the identifier for the exact product variant, alongside color, size, pack quantity and location. Include an approved reference photo if similar versions are easy to confuse. A blue pouch sold individually is not the same stock unit as a two-pack, even when the outer packaging looks alike.

Assign one person to gather the evidence for inventory reconciliation and another to approve any balance correction. Give the warehouse a specific request: count SKU POUCH-BLUE-1 at the named locations, record the count time, and separate damaged or allocated units. “Please check our inventory” leaves too much room for incompatible answers.

Count every relevant location, not just the picking bin

Start with the normal picking location, then check reserve shelves, receiving areas, inspection holds and packing stations. Ask whether the same SKU has a temporary location or an older label. Products can be physically present yet effectively unavailable because the person picking the next order cannot find them.

Count units using the agreed sales unit. Verify the contents of opened cartons; do not multiply every carton by the printed pack size when some are partly used. For sealed cartons, agree what evidence supports the stated quantity and when opening a carton is necessary. Packaging alone does not prove the contents.

If the result differs from the record, request an independent recount without showing the first total where practical. Record counts by location before adding them together. A single grand total can conceal that one bin is short while another contains the same variant under the wrong label.

Useful evidence includes the location identifier, count sheet, time, counted unit and relevant photos. Photos can help distinguish products or document damage, but they rarely prove every unit in a closed carton. During inventory reconciliation, use images to support the count rather than replace it.

Rebuild the expected balance from actual movements

Take the last balance you trust and add confirmed receipts and transfers in. Subtract confirmed dispatches and transfers out. Include other documented changes that affect physical stock, such as approved disposal. Apply the same cutoff to every movement and check whether a transaction was recorded more than once.

Follow references, not memory. Match a supplier delivery to its receiving record, a dispatch to its order or parcel record, and a return to its inspection outcome. A supplier invoice shows what was billed; it does not establish how many units were physically received and accepted.

If the discrepancy starts with an inbound delivery, share the item specification, expected quantity and receiving evidence with the team handling supplier purchasing coordination. Ask them to resolve that delivery before treating the difference as warehouse loss. Keep disputed units separate from confirmed sellable stock.

A transfer between two bins changes their individual totals, not the warehouse total. Moving goods from available to inspection hold changes availability without making the goods disappear. Inventory reconciliation becomes much easier when you distinguish a physical movement from a change in stock status.

Work through a stock difference before adjusting it

Suppose your last verified on-hand balance was 240 individual pouches. Before the cutoff, the warehouse received 80 more and dispatched 65. With no other physical movements, the expected on-hand quantity is 255: 240 plus 80 minus 65. These are example quantities, not a UTS customer record.

The first shelf count finds 247, apparently eight units short. A check of the packing area locates eight picked units that have not left the warehouse. Adding them brings physical on-hand stock to 255. In this example, the system reduces on-hand only at dispatch, so no loss adjustment is needed.

Now separate availability. Of those 255 units, 18 are reserved for open orders, including the eight at packing, and five different units are on inspection hold. If these groups do not overlap, 232 are available: 255 minus 18 minus five. Do not subtract the eight packed units a second time.

If your system removes on-hand at picking instead, use that rule consistently and document the difference. The point of inventory reconciliation is not to force every business into this example. It is to explain why the quantity being counted does or does not belong in the field being compared.

Protect open orders while you investigate

List the orders that depend on the disputed SKU and their outstanding quantities. Work out which can be fulfilled from confirmed available units. Do not keep promising unverified stock simply because the storefront still displays a positive balance, and do not cancel unrelated orders without checking their actual requirements.

Use the agreed store process to limit new commitments if necessary. Tell the person managing customer messages which orders are affected, what is known and when the next update is due. A clear investigation deadline is more useful than a delivery promise that depends on stock nobody has found.

For bundles, check component quantities as well as the finished-set count. Ten main products do not necessarily make ten complete sets when only six matching accessories are available. Keep those components visible in the investigation so a packaging or assembly issue is not mistaken for a missing main product.

Also confirm any cost before requesting extra inspection, repacking or documentation. The UTS pricing page lists service categories, but it does not establish the scope or price of your particular discrepancy investigation. Agree the work required rather than assuming every corrective activity is included.

Approve the correction and preserve its explanation

Once the count and movement records agree, decide what actually needs correcting. It may be a duplicate receipt, an unrecorded transfer, an incorrect variant mapping or a confirmed shortage. Do not write off eight units merely because the first report was eight units lower than expected.

Record the original balance, verified balance, difference, reason, supporting references and approver. Correct the source transaction where your agreed process allows it, or make a clearly explained adjustment. Avoid changing both the warehouse and store independently if a later synchronization could apply the same correction again.

Afterward, read the balances again and verify affected reservations and open orders. Check that the next normal update does not restore the old error. Inventory reconciliation is unfinished if the records briefly agree but the next import recreates the discrepancy.

Use repeat differences to improve the next count

Review discrepancies by cause rather than treating every case as an isolated mistake. Repeated confusion between individual units and multipacks calls for clearer identifiers. Differences concentrated around shift changes suggest a cutoff or handoff problem. Missing stock repeatedly found at packing suggests location visibility needs attention.

Schedule smaller checks for fast-moving, valuable or frequently disputed SKUs, with a frequency that fits your operation. Keep a simple record of what was counted, what differed and what changed afterward. A count that never leads to a better receiving, labeling or movement process will leave the same uncertainty in place.

Before your next inventory reconciliation, agree the stock definitions, cutoff, locations, evidence owner and correction approver. Then start with the SKU creating the greatest immediate order risk. For goods held with UTS, send that focused request alongside your product and order references so the investigation begins with a question someone can answer.