Module 07 · Inventory Accounting and COGS in Practice

Retail COGS: How to Calculate Cost of Goods Sold for a Store

Learn how to calculate retail COGS for a store: the formula, average cost per item, the retail method, shrinkage hidden in COGS and a margin check.

10 min readLesson 4 of 10 in this moduleUpdated 2026-11-09

Retail COGS is the cost of the merchandise your store actually sold in a period. The formula is beginning inventory plus net purchases minus ending inventory. Example: a shop that starts with $30,000 of stock, buys $66,000 more and counts $33,000 at the end has COGS of $63,000. On $105,000 of net sales, that leaves a gross profit of $42,000, or a 40.0% gross margin.

Key takeaways

  • Retail COGS = beginning inventory + net purchases (including freight-in) - ending inventory, all at cost.
  • Count or estimate ending inventory at cost, never at shelf price.
  • With thousands of items, use a weighted average cost per item, or the retail method to estimate ending stock between counts.
  • In a periodic system, shrinkage (theft, breakage, miscounts) quietly raises COGS and lowers margin.
  • Check gross margin every month. A sudden drop usually means a pricing, markdown or stock-loss problem.

The retail COGS formula

A store does not make what it sells, so its cost of goods sold is built from stock movements.

COGS = beginning inventory + net purchases - ending inventory

Net purchases = purchases - returns to suppliers - purchase discounts + freight-in. Everything is at cost.

Beginning inventory is last period's ending inventory. Net purchases are what the shop paid for goods during the period, adjusted for returns, discounts and the cost of getting the goods to your door. Ending inventory is what is on the shelves and in the back room when the period closes. Inventory is valued at what you paid, not at the price on the tag.

The general theory is in cost of goods sold, and COGS by business type compares retail with manufacturing and services. This lesson is the store-level version: how to get the three numbers when you carry hundreds or thousands of items.

Retail COGS example: a gift shop for one month

The figures in this example are fictional. Maple Street Gift Shop reports the following for June.

ItemAmount
Beginning inventory at cost$30,000
Net purchases at cost (after returns and discounts, plus freight-in)$66,000
Goods available for sale$96,000
Ending inventory at cost (from count or estimate)$33,000
Cost of goods sold$63,000
Net sales$105,000
Gross profit$42,000
Gross margin40.0%

Goods available for sale is the sum of what you started with and what you bought: $30,000 plus $66,000. Subtract what is left and what remains was sold. Gross profit is net sales minus COGS ($105,000 minus $63,000), and gross margin is gross profit divided by net sales ($42,000 divided by $105,000).

Should you work out retail COGS per period or per transaction?

You can arrive at COGS in two ways, and they suit different stores.

Per period (periodic). You record purchases during the month, count the stock at the end and calculate COGS once, as above. It needs little software but gives you no cost figure until the count is done. It also depends entirely on the quality of the count.

Per transaction (perpetual). Every sale takes its cost out of Inventory and puts it into COGS at once. A barcode scanner or point-of-sale system makes this practical. You see margin sale by sale and can compare book stock with a count. The journal entries are shown in inventory accounting journal entries.

Many small shops start periodic, then move to perpetual as the range grows. Whichever you use, the total COGS for a month should agree when nothing is lost, as the full worked example shows.

How do you calculate average COGS for a retail item?

Prices from suppliers change, so the same product can sit on your shelf at two costs. The weighted average cost method gives every unit the blended cost.

Weighted average cost of one candle line

A shop holds 40 candles that cost $12.00 each and then buys 60 more at $13.50.

StepCalculationResult
Value of old stock40 x $12.00$480
Value of new purchase60 x $13.50$810
Total value$480 + $810$1,290
Total units40 + 60100
Average cost per unit$1,290 / 100$12.90
COGS if 70 are sold70 x $12.90$903
Ending inventory for 30 left30 x $12.90$387

Goods available ($1,290) equals COGS ($903) plus ending inventory ($387), so the arithmetic closes. In a perpetual system, the average is recalculated after each purchase and every sale uses the latest average. If you want to compare it with first-in, first-out, see FIFO vs average costing. Pick one method per product and apply it consistently. Some countries restrict which methods are acceptable for tax or reporting; check local rules.

What is the retail inventory method?

Counting every item each month is slow. The retail method estimates ending inventory from numbers you already have: the price tags. It is permitted in some places for financial reporting and tax, in others not, so confirm with your accountant. Use it as an estimate between counts, not a substitute for them.

You need goods available for sale at both cost and retail (selling) price. The ratio of the two is your cost-to-retail percentage.

StepCostRetail
Beginning inventory$30,000$50,000
Net purchases$66,000$110,000
Goods available for sale$96,000$160,000
Cost-to-retail ratio$96,000 / $160,00060%
Less net sales$105,000
Ending inventory at retail$55,000
Ending inventory at cost$55,000 x 60%$33,000

COGS is then $96,000 minus $33,000, which is $63,000, the number in the earlier example. The retail method assumes that the mix of items you sold has the same markup as the mix you started with. If the shop sells mostly high-margin gifts one month, the estimate drifts. Markdowns and special pricing need extra adjustments that go beyond this lesson; follow your accountant's method if you use them.

How does shrinkage get hidden in retail COGS?

Here is the problem with a periodic system. COGS is calculated as a leftover: goods available minus whatever you can find at the end. Any stock that disappeared, whether through theft, breakage, spoilage, receiving errors or a miscount, is not on the shelf, so it lands in COGS without a label.

Suppose Maple Street's retail method says $33,000 should be on hand, but a count finds only $31,500 at cost.

Expected stockCounted stock
Ending inventory at cost$33,000$31,500
COGS$63,000$64,500
Gross profit$42,000$40,500
Gross margin40.0%38.6%

The $1,500 difference (about $2,500 at shelf prices, using the 60% ratio) did not turn into sales. It simply reduced ending stock, so COGS rose and the margin fell by 1.4 percentage points. A periodic COGS figure alone cannot tell you whether the 38.6% margin comes from pricing, mix or loss.

Do not read a margin drop as a pricing problem first

If gross margin falls and prices did not change, compare book stock with a count before touching prices. A missing $1,500 looks identical to a supplier price increase in a periodic COGS calculation.

In a perpetual system the ledger gives you the expected stock continuously. When the count comes in lower, you record the difference as a separate loss.

AccountDebitCredit
Inventory Shrinkage Expense1,500
Inventory1,500

COGS then stays at $63,000, and shrinkage of $1,500 is visible on its own line. Many retailers include it in cost of sales on their statements, but they can only do that deliberately if they have measured it first. For recording losses and damaged stock, see inventory shrinkage and write-downs. For how to run a count, see what is stock opname.

How do markdowns affect retail COGS and margin?

A markdown does not change COGS per unit. The shop still paid $12.90 for each candle. What changes is the revenue it collects, so gross margin per unit shrinks.

PriceUnit costGross profit per unitGross marginMarkup on cost
Full price $25.00$12.90$12.1048.4%93.8%
20% off, $20.00$12.90$7.1035.5%55.0%

A 20% price cut lowers the margin by 12.9 points and cuts gross profit per unit from $12.10 to $7.10, a fall of about 41%. The cut comes entirely out of gross profit, because the cost stays the same. So the shop must sell roughly 70% more units ($12.10 divided by $7.10) just to earn the same gross profit. Margin and markup are different measures, as markup vs margin explains. Do not set a markdown plan using one when the target is in the other.

If a markdown takes the price below cost, or the goods become unsellable, the loss belongs in the books through an inventory write-down. Do not wait for the sale to discover it.

Which items belong in retail COGS?

Include the invoice price of goods you bought for resale, freight-in, and import duties that you cannot recover. Take off returns to suppliers and purchase discounts. Leave out the cost of delivering goods to customers, shop rent, wages, card fees and marketing: those are operating expenses and sit below gross profit. Supplies you use in the shop, such as bags and tissue paper, are usually an operating expense unless they are packed into every sale and you track them as part of product cost. Whatever you decide, apply it every month so the margin trend means something.

A monthly retail margin check

A margin check takes five minutes and catches most problems. Use it every month.

  1. Calculate gross margin: (net sales - COGS) / net sales.
  2. Compare it with the same measure for the last three months, and with your price-list margin.
  3. If the figure is lower, check for markdowns, supplier price rises, freight-in not yet added to inventory and unrecorded returns.
  4. If those are clean, compare book stock with a count; a difference points to shrinkage.
  5. Record what you found, and what you will change, with the month's closing notes. The month-end inventory checks lesson turns this into a checklist.

Gross margin is only the first layer of profit; gross margin vs net margin shows what rent, wages and other expenses do to it. For ordering, stock levels and loss prevention in stores, see inventory management for retail.

How retail COGS runs in Reyuko

Reyuko posts COGS at the moment of sale. Each product has its own cost method (Average, FIFO, LIFO or FEFO), and the sale invoice debits COGS and credits Inventory at the cost taken from the product's purchase batches. A stock-take compares the counted quantity with the book quantity: a shortage is booked as Dr Inventory shrinkage expense / Cr Inventory at the unit's cost, and an overage as Dr Inventory / Cr inventory gain, so a count does not disappear into COGS.

Frequently asked questions

What is retail COGS?

Retail COGS is the cost of the merchandise a store sold during a period. You calculate it as beginning inventory plus net purchases minus ending inventory, all at cost. Selling prices, rent and wages are not included. It is the first deduction on the income statement and leads to gross profit.

How do you calculate cost of goods sold for a retail store?

Add the value of your opening stock to the cost of purchases during the period, including freight-in and after returns and discounts. Subtract the cost of the stock left at the end. For example, $30,000 plus $66,000 minus $33,000 gives COGS of $63,000.

How do you calculate average COGS for retail?

Divide the total cost of the units available by the number of units, then multiply by the units sold. If 40 units cost $480 and 60 units cost $810, the average is $1,290 divided by 100, or $12.90. Selling 70 units gives COGS of $903.

What is the difference between COGS in retail and in manufacturing?

A retailer buys finished goods, so COGS is mainly purchase cost plus freight-in. A manufacturer builds its COGS from materials, direct labor and production overhead, with work in progress and finished goods inventories in between. The retail calculation is simpler because there is no production cost to allocate.

Does shrinkage count as cost of goods sold?

It depends on the system and your reporting policy. In a periodic system, lost stock is automatically included in COGS because COGS is the leftover after the count. In a perpetual system you can record shrinkage as a separate expense, or include it in cost of sales; either way, measure it first.

What is a good gross margin for a retail store?

There is no single good number, because it depends on the product type, pricing and the market. Judge your own margin against your price list, your own history and your costs. A margin that drops without a price change is the signal to investigate markdowns, supplier costs and stock loss.

Put this into practice in Reyuko

Reyuko posts inventory, cost of goods sold and gross profit from the same ledger, so the numbers in this lesson are the numbers on your reports.

Download Reyuko freeSee what's included