Ecommerce stocktake discrepancy: reconcile warehouse counts before recording a loss
Investigate cutoff timing, missed stock and duplicate records before assessing inventory loss and applicable VAT treatment.
A warehouse count is 10,000 units below the system balance. Has the business lost 10,000 units? Not necessarily. An uncounted quarantine area, a dispatch recorded after cutoff or a duplicate receipt can create the same apparent shortage.
Fix the comparison to the same owner, SKU, warehouse and cutoff time. Reconcile physical counts and warehouse-location records first, correct supported recording errors with an audit trail, and investigate the remaining difference before deciding on accounting, claims or tax treatment.
Break down a 10,000-unit apparent shortage
Assume a China ecommerce company counts one SKU of its own goods at month-end. At cutoff, the warehouse-location detail shows 130,000 units and the first physical count for that same warehouse is 120,000. Finance has established a uniform RMB 400 carrying cost per unit for this batch. Assume no other batch-cost differences or impairment for this comparison.
The initial gap is 10,000 units, or RMB 4 million at that unit cost. This is a quantity difference expressed at carrying cost, not a confirmed RMB 4 million loss.
| Evidence obtained | Effect on the cutoff comparison | Follow-up |
|---|---|---|
| 4,000 company-owned units were in a quarantine area omitted from the first count | Physical count increases from 120,000 to 124,000 | Recount and record the location and status; unavailable for sale does not itself mean the goods are not owned |
| 3,000 units left this warehouse before cutoff but the system recorded dispatch afterward | Warehouse-location balance falls from 130,000 to 127,000 at cutoff | Reconcile dispatch and later posting to prevent a duplicate correction; dispatch does not itself establish a sale |
| A 2,000-unit receipt was recorded twice for the same warehouse location | Location balance falls to 125,000 | Retain the original and duplicate records, correct with appropriate authority, and check whether the accounting ledger was also affected |
| 1,000 units remain unexplained | Corrected location detail 125,000 − recounted physical units 124,000 = 1,000 | At the assumed cost this is RMB 400,000; investigate rather than immediately treating it as a loss |
This example compares warehouse-location detail with stock physically in that warehouse. Whether the 3,000 units sent to a customer or another location remain the company's financial inventory depends on ownership, control and the actual transaction. Leaving this warehouse does not automatically remove them from total accounting inventory or establish revenue. Separately check whether timing or duplicate entries affected the inventory subledger and general ledger; a warehouse correction is not automatically an accounting journal entry.
Four categories that can look alike
Cutoff timing. A movement can be recorded at different times by the warehouse, ecommerce platform and finance system. Keep both event time and posting time. Align the cutoff first and check the later posting before making any correction, so that it is not counted twice across periods.
Location or status. Count normal, inspection, after-sales, returned and third-party locations separately. Verify ownership and condition before combining them. An order reservation or unavailable-for-sale status does not by itself mean goods have physically left the warehouse or no longer belong to the business.
Document or unit errors. Duplicate receipt imports, cases compared with individual units, or broken exchange references can create a discrepancy in the records. Match the unique business document, SKU, batch and unit rather than combining similar product names.
Actual damage, loss or dispute. After a recount and supporting documents establish a shortage or damage, record quantity, cause, photos, responsibility, residual value and the status of insurance or a claim. Do not attribute liability to a warehouse merely because goods are in transit, not yet accepted or of uncertain ownership.
Move from evidence to accounting and tax
Article 17 of China's Accounting Law requires periodic reconciliation of accounting books with physical assets and relevant records. Retain the count, review, cause and correction evidence required by the applicable rules and the company's authority. Keep unresolved items open rather than posting an unsupported balancing adjustment at month-end.
For entities applying China's Accounting Standard for Business Enterprises No. 1 — Inventories, Article 21, losses caused by inventory shortages are included in current profit or loss. Whether a shortage exists, its measured loss and any compensation are separate assessments based on established facts and applicable rules. An entity applying a different accounting framework should check its own requirements.
For businesses using the general VAT method, Article 22 of China's VAT Law, effective in 2026, disallows input VAT attributable to abnormal-loss items. Whether a particular event is an abnormal loss and how previously deducted input VAT is treated depend on the facts and applicable rules. An unexplained count gap is not automatically an abnormal loss, and multiplying the gap by a tax rate does not by itself establish tax due.
Assign and close each difference
For each open item record the owner, SKU, warehouse and bin, cutoff, system and recounted quantities, original document references, established cause, unresolved units, responsible person, reviewer and planned resolution date. Keep evidence for compensation, insurance and tax questions separate; one assumption cannot stand in for all three.
Once the records are reconciled, consider the effect on replenishment and cash using inventory and cash tied up and the reconciliation example. For a discussion of the workflow, contact CaiGeek, an AI financial assistant for small and medium-sized businesses.
Move the work forward with CaiGeek.
Start with your question, supported by business context, data and memory.