Why overseas sellers need a China warehouse inventory reconciliation process
When a business purchases from multiple suppliers in China and consolidates goods in a China warehouse, inventory data is often scattered across supplier shipping records, tracking numbers, warehouse receiving records, and its own sales system. Without a unified reconciliation process, problems arise such as "the system shows stock available but it can't actually be shipped," "the received quantity doesn't match the purchase order," and "inventory isn't deducted after outbound shipment." This article focuses on the China warehouse inventory reconciliation workflow, outlining a basic set of account verification methods from arrival to outbound shipment, suitable for overseas businesses and e-commerce sellers that need receiving, consolidation, quality inspection, warehousing, relabeling, repackaging, picking and packing, and arranging international shipping.
It should be noted that different warehouses have different operating systems and document formats. This article provides a general process framework; the specific fields and operations are subject to the actual process of the warehouse you use.
The five basic steps involved in inventory reconciliation
1. Arrival registration
After the supplier ships to the warehouse, the warehouse registers receipt based on the courier tracking number or delivery note. This step should record: arrival date, supplier name, courier tracking number, number of boxes, pieces per box, and appearance condition. If the supplier includes a packing list with the shipment, verify whether the packing list matches the actual arrival.
2. Inventory ledger
The inventory ledger is the foundation for all subsequent verification. It is recommended to record by SKU: inbound quantity, available quantity, locked quantity, and defective quantity. Recording available quantity and locked quantity separately can prevent inventory already reserved by orders from being allocated again to new orders.
3. Order locking
When an order enters the picking and packing stage, the quantity of the corresponding SKU should move from available to locked. Locked means this batch of goods has been reserved and can no longer be allocated to other orders. The rules for locking and releasing need to be confirmed with the warehouse in advance.
4. Outbound deduction
After a package has been picked, reviewed, packed, and handed over for shipment, its inventory should move from locked status to outbound deduction. Outbound records should include: order number, SKU, quantity, outbound date, and shipping tracking number.
5. Discrepancy verification
Regularly compare the warehouse ledger with your own sales system or purchasing records to identify SKUs with quantity discrepancies, and investigate the cause of each one.
Inventory reconciliation workflow table
| Step | Key Records | Items to Verify | Common Discrepancies |
|---|---|---|---|
| Arrival Registration | Tracking No., Number of Boxes, Number of Pieces | Supplier Packing List | Missing items, extra items, damaged |
| Inventory Ledger | SKU, Available, Locked, Defective | Purchase Order | Wrong SKU entered, wrong quantity entered |
| Order Locking | Order No., SKU, Locked Quantity | Sales Order | Duplicate lock, not released |
| Outbound deduction | Order number, tracking number | Shipping records | Outbound not deducted |
| Discrepancy verification | Discrepancy list | System and ledger | Reason not closed out |
Practical steps for verifying discrepancies
- Set a fixed reconciliation cycle, such as once a week or once a month; a consistent rhythm is more effective than occasional spot checks.
- Export the warehouse ledger and your own system inventory, and sort by SKU.
- Compare the available quantities item by item and mark the SKUs that do not match.
- Trace the discrepant SKU back to arrival records, lock records, and outbound records.
- Determine the type of discrepancy: entry error, unrecorded outbound, unregistered damage, or actual physical shortage.
- Confirm the handling method with the warehouse: correct the ledger, add a supplementary registration, or arrange a stock count.
- Record the handling results in the discrepancy list to form a closed loop.
The role of quality inspection and photography in inventory reconciliation
Basic quality inspection and photography are not only means of quality control, but also a source of evidence for inventory reconciliation. Photo records taken upon arrival can be used to verify quantity and appearance; when damage or defects are found, photos can help determine which stage is responsible. It is recommended to clarify photography requirements at the arrival stage, such as the recording rules for panoramic, detail, label, quantity, and defect photos, to avoid lacking evidence in case of later disputes.
The relationship between relabeling, repackaging, and inventory
Label replacement and repackaging change the outer packaging state of the product, but do not change the inventory ownership of the SKU. During the operation, note the following: the SKU correspondence before and after label replacement must be clearly recorded; consumables generated by repackaging are not counted into product inventory; defective items generated during the operation need to be registered separately and must not be mixed into available inventory.
Inventory reconciliation preparation before peak season
Before peak seasons such as Black Friday and Christmas, order volume rises, and the impact of inventory discrepancies gets amplified. It is recommended to complete a full reconciliation before the peak season to confirm the accuracy of available inventory, locked inventory, and defective inventory; at the same time, confirm with the warehouse how picking, packing, and outbound records are transmitted, to ensure that accounts can still be updated promptly during the peak season.
For the overall workflow of China warehouse fulfillment, you can refer to China Warehouse Fulfillment Services . If you'd like to discuss your inventory management and reconciliation needs, you're welcome to Contact Us.
Frequently Asked Questions
How often should reconciliation be done?
It depends on order volume and the number of SKUs. Sellers with many SKUs and fast turnover usually need more frequent reconciliation. You can start with once a month and adjust based on discrepancy patterns.
What should be done first after discovering a discrepancy?
First freeze the available quantity of the relevant SKU to avoid further allocation, then trace back through the records to investigate the cause. Do not directly adjust inventory numbers before the cause is identified.
How should defective goods be handled?
Defective items should be registered separately and kept apart from available inventory. Whether to return, scrap, or dispose of them at a discount should follow your business rules and your agreement with the warehouse.
Summary
A clear China warehouse inventory reconciliation process is essentially about linking the records of five stages—inbound receiving, inventory, locking, outbound, and discrepancy verification—and maintaining a consistent comparison rhythm. It cannot eliminate all discrepancies, but it enables discrepancies to be discovered and resolved promptly, thereby supporting stable fulfillment during peak seasons and daily shipping.
