How To Calculate COGS For A Retail Inventory Cycle (Step-by-Step)

COGS The abbreviation for cost of goods sold. Accurate calculation across an inventory cycle requires clear inputs (beginning inventory, purchases, ending inventory), an inventory costing method, and controls that capture freight, duties, and adjustments such as returns and shrinkage.

This article walks through step-by-step calculations for both periodic and perpetual systems, shows what to include and exclude, and gives practical controls retailers should use when closing a period.

Step-By-Step Calculation (Periodic System)

1. Determine beginning inventory (the ending inventory balance carried forward from the prior period). 2. Aggregate net purchases during the period (gross purchases + freight-in + duties - purchase returns & allowances - purchase discounts taken). 3. Conduct a physical count and determine ending inventory at cost. 4. Apply the formula: Beginning Inventory + Net Purchases - Ending Inventory = COGS.

This method is common for smaller retail operations or when counting inventory at the end of each reporting period is the primary control.

Perpetual System: Real-Time COGS

Under a perpetual inventory system the accounting software posts inventory decreases and COGS in real time as sales occur. Each sale reduces inventory and increases COGS by the cost assigned to the units sold (based on FIFO, weighted average, or specific identification). Perpetual requires reliable SKU-level costing and integration between POS/WMS and accounting.

Which Costs To Include

• Purchase Cost: The invoice or landed cost per SKU.
• Freight-In/Duties: Capitalize if the buyer pays them (part of landed cost).
• Customs & Nonrefundable Taxes: Include in inventory cost when not recoverable.
• Direct Prep Labor: Capitalize only if labor specifically readies inventory (e.g., kitting before sale).
• Excluded Items: Sales commissions, store utilities, and marketing.

Adjusting For Returns, Allowances, And Shrinkage

Customer returns affect COGS when goods are returned for resale or destroyed. Typical approaches:

• Return Resalable Items: Reverse the original COGS entry and increase inventory at the original cost.
• Unsellable Returns: Record a loss or write-down; reduce inventory and recognize a cost of disposal.
• Shrinkage: After the physical count, record inventory shrinkage as an adjusting entry that reduces inventory and increases shrinkage expense. Shrinkage reduces gross margin indirectly by increasing COGS (periodic) or by being recognized as a separate operating expense depending on accounting policy.

Accounting Entries (Examples)

Periodic system at purchase:

Debit Purchases (or Inventory Purchases) — Credit Accounts Payable/Cash

At period close to record COGS:

Debit COGS — Credit Inventory (for calculated COGS amount)

Perpetual system at sale:

Debit Accounts Receivable/Cash — Credit Sales Revenue; Debit COGS — Credit Inventory (for cost per unit sold).

Systems, Controls, And Practical Tips

• Use SKU-Level Costing: Track cost per SKU including landed cost to avoid under- or overstating COGS when multi-sourcing or when mix changes.
• Perform Regular Cycle Counts: Cycle counting reduces dependence on a single year-end count and helps detect shrinkage early.
• Integrate POS/WMS/Accounting: Integration prevents timing gaps and reduces manual journal entries that introduce errors.
• Document Adjustments: Keep support for adjustments—supplier credits, returns, and write-downs—so auditors and tax preparers can verify COGS composition.

Practical Example

A toy retailer begins the quarter with $20,000 inventory. During the quarter they purchase $50,000 of toys and pay $1,500 freight-in. They return $2,000 worth of damaged items to suppliers and take $500 in purchase discounts. A physical count shows ending inventory at $25,000. Net purchases = 50,000 + 1,500 - 2,000 - 500 = $49,000. COGS = 20,000 + 49,000 - 25,000 = $44,000.

This $44,000 is reported on the income statement as the cost associated with the sales that occurred during the quarter.

In short, the COGS calculation for a retail inventory cycle depends on consistent inclusion of purchase-related costs, an applied costing method, accurate physical counts, and controls to capture returns and shrinkage. Systems that integrate inventory and accounting reduce errors and produce timely COGS for better margin management.