How To Calculate Cost of Goods Sold For Retail Inventory (Landed Cost, Freight, Packaging)

Cost of Goods Sold The direct cost of products sold, including product cost and sometimes freight, packaging, or landed cost depending on accounting method. Calculating COGS accurately requires consistent inventory valuation and clear rules about which acquisition-related costs to include.

Retailers with international suppliers or complex fulfillment networks must explicitly decide whether to include landed cost components — duties, insurance, freight to port, and inland transport — in inventory. These decisions affect unit economics and tax reporting. The following sections describe calculation steps, examples, and practical controls.

Step-By-Step Calculation

1. Determine beginning inventory value for the period from your closing count of the prior period. 2. Add purchases during the period at cost. Include purchase discounts, rebates, and any costs capitalized into inventory per policy (commonly freight-in and non-recoverable duties). 3. Subtract ending inventory as determined by physical count or perpetual system valuation. The result is COGS.

Deciding Which Acquisition Costs To Capitalize

Common capitalizable costs include the invoice price, non-refundable import duties, freight-in from port to warehouse, and insurance incurred to transport goods to the retailer’s location. Costs that prepare inventory for sale, such as inspection and special packaging integral to the product, are also often capitalized. Marketing packaging and outbound shipping are excluded.

Landed Cost Components

• Label:Product Cost: Invoice price paid to supplier.
• Label:Freight-In: Transportation from supplier to retailer’s receipt location.
• Label:Duties/Taxes: Customs duties and non-recoverable taxes related to acquisition.
• Label:Insurance: Marine or transit insurance included if paid as part of acquisition.
• Label:Handling Fees: Port handling and customs broker fees that are part of landed cost.

Inventory Valuation Methods And Their Effect

Choice of FIFO, LIFO (U.S. permitted for tax), or weighted average changes the specific cost layer assigned to COGS when purchase prices move. In rising cost environments, FIFO typically results in lower COGS and higher inventory on the balance sheet compared with LIFO. For retailers, method choice affects reported margins, tax outcomes, and sometimes operational KPIs such as gross margin return on investment (GMROI).

Systems And Practical Controls

• Label:Perpetual Inventory Systems: Use a WMS or inventory module that supports landed cost allocation to automatically roll freight and duties into unit costs.
• Label:Allocation Rules: Establish allocation bases (units, weight, value) for distributing common inbound charges across SKUs.
• Label:Reconciliation: Reconcile inventory subledger to the general ledger monthly and investigate variances promptly.

Worked Example — Landed Cost Allocation

A retailer imports 1,000 identical units for $20 each (supplier invoice $20,000). Freight to port is $1,000, customs duty $500, inland freight to warehouse $300, and broker fees $200. Total landed cost = $22,000. Per-unit landed cost = $22.00. If 400 units are sold in the period and ending inventory is 600 units, and beginning inventory was zero, COGS = 400 units × $22 = $8,800.

Special Situations

Returns and allowances: When goods are returned, adjust COGS and inventory per your returns policy. Promotions and bundled discounts: If discounts are applied at invoice level, allocate discounts to units to determine unit cost. Write-downs for obsolescence: Inventory impairments reduce ending inventory and increase COGS for the period when recognized.

In short, the Cost of Goods Sold is calculated by matching beginning inventory plus purchases (including any freight, duties, and packaging your accounting policy capitalizes) minus ending inventory. Accurate landed cost allocation, consistent valuation method, and systemized reconciliation processes make COGS reliable for pricing, margin analysis, and tax reporting in retail operations.