E-commerce

How to Record Inventory Shrinkage After a Physical Warehouse Count

Writing off the difference between system inventory and actual physical count due to loss, damage, or picking errors.

Account NameTypeDebit ($)Credit ($)
Inventory Shrinkage ExpenseExpense (+)650.00-
Merchandise InventoryAsset (-)-650.00

💡 Accountant's Note

Shrinkage in e-commerce warehouses results from picking errors, damage, or theft. Regular cycle counts identify discrepancies that must be written off to keep the balance sheet accurate.

Practitioner & Systems Framework

💻 ERP Architecture

Conduct cycle counts by location or ABC category on a rotating schedule — high-value SKUs should be counted monthly. When the physical count is confirmed, generate a variance report in the WMS comparing system quantity to count. Approved variances are posted to Inventory Shrinkage Expense. Investigate variances exceeding a materiality threshold (e.g., >5% of SKU value or >JOD 100) before posting.

⚠️ Audit Flags

Auditors attend or observe the year-end physical inventory count. Key procedures: (1) Counting teams are independent of the records, (2) All items are tagged to prevent double-counting, (3) Count results are reconciled to the perpetual system before the adjustment is posted, (4) High shrinkage rates by category (>1.5% of sales value) warrant investigation of internal controls.

📄 Required Documentation

Cycle count or full physical count sheets (counters' signatures, count dates, locations), variance report (system quantity vs. physical count by SKU), investigation notes for material variances, write-off approval from warehouse manager or finance, and cumulative shrinkage rate trend (% of inventory value) by period.

Automate this entry with the JEH Accounting Suite

Stop doing manual entry. Our VBA-powered ERP automatically generates your ledgers, Trial Balance, and Financial Statements.

No Subscriptions. Own your data.

QA

Expert Analysis by Qusai Ahmad

General Accountant Supervisor & IFRS Specialist

Specialized in SAP GUI automation and Middle Eastern tax compliance. Building digital tools for the next generation of finance leaders.

LinkedIn Profile

Discussion & Community Questions