How Merchants Calculate COGS Valuation For Lost Inventory Claims

Cost of Goods Sold (COGS) Valuation A method of valuing lost inventory by the merchant’s cost rather than its retail selling price, when used in a contract or claim.

Accurate COGS valuation for a claim is a repeatable, auditable process. Merchants and their logistics partners should follow a clear step sequence: identify the lost units, determine the applicable costing method, assemble supporting documents, calculate landed unit cost, and apply any contract adjustments or deductions for spoilage or obsolescence. Doing this consistently shortens dispute timelines and improves recovery rates.

Step-By-Step Calculation

• Identify the SKU and quantity: Match physical count, pick/manifest records, and order numbers to the inventory ledger.
• Select the costing method: Use the merchant’s accounting method (FIFO, LIFO, weighted average, or specific identification) as applied in the periodic inventory records.
• Calculate landed unit cost: Add purchase price + freight-in + duties + direct packaging/kitting costs, then divide pooled costs by units if necessary.
• Adjust for returns/credits: Subtract supplier credits, vendor allowances, or discounts that reduce the merchant’s net cost.

Supporting Documentation To Compile

• Purchase invoices: Supplier invoices showing quantities and unit prices.
• Freight and duty bills: Bills of lading, freight invoices, and customs entries showing inbound charges.
• Inventory records: Receiving reports, WMS records, and periodic stock counts that reconcile quantity lost.
• Accounting ledgers: Cost of goods accounts and cost-calculation worksheets matching the merchant’s published accounting method.

Adjustments And Exceptions

Contracts sometimes permit or require deductions: damaged or partially usable items may be claimed at a lower per-unit cost; obsolete items might be discounted to reflect marketability; and certain overheads may be excluded unless expressly included. Also note that under IFRS LIFO is not permitted — an important consideration in international claims or when applying accounting policies consistently across subsidiaries.

Common Pitfalls To Avoid

• Inconsistent costing: Switching valuation methods between accounting and claims will raise red flags and delay settlement.
• Missing source documents: Lack of supplier invoices or freight bills often reduces recoverable amounts or causes claim denial.
• Ignoring contract language: Valuation clauses that define "cost" differently can nullify otherwise-supported calculations.
• Overlooking landed costs: Failing to include freight-in or duties undervalues the merchant’s actual loss when contract language requires them.

Example Calculation

Merchant A loses 250 units of SKU 123. Accounting records use FIFO. Recent purchase invoice shows 300 units bought at $12.50 each; freight-in for the lot is $250; customs duty for the lot is $150; packaging cost allocated to the lot is $100. Landed cost per unit = ($12.50 × 300 + $250 + $150 + $100) / 300 = ($3,750 + $500) / 300 = $14.17. Claim amount = 250 × $14.17 = $3,542.50. Merchant provides the invoice, freight bill, customs entry, and WMS receiving sheet as evidence.

Tips For Faster Recovery

• Standardize templates: Create a claim packet template listing required documents and calculation worksheets.
• Pre-negotiate valuation: Include explicit cost components and proof standards in service contracts to prevent surprise denials.
• Keep landed-cost records: Maintain periodic landed-cost per-SKU snapshots tied to purchase lots to speed evidence assembly.
• Use WMS timestamps: Correlate receiving, putaway, and shipping events to strengthen quantity reconciliation.

In short, the Cost of Goods Sold (COGS) Valuation for lost inventory requires matching the merchant’s accounting method with a detailed, document-backed landed-cost calculation. Accurate records and clear contract language make the difference between a quick settlement and a prolonged dispute.