Northshore Outfitters buys trail backpacks three times in October: some at $20 each, more at $22, and a last batch at $25 because the supplier raised prices. The backpacks are identical, sit on the same shelf, and sell for the same $40. When a customer buys one, what did that backpack cost the store: $20, $22, or $25? Physically there is often no way to tell, so accountants agree on a cost formula, a rule for which costs leave with the goods sold and which stay in ending inventory. The choice does not change how many backpacks were sold or how much cash came in, but it does change cost of goods sold, gross profit, net income, and the inventory on the balance sheet.
Perpetual and periodic systems compared
- Merchandise Inventory is updated with every purchase and every sale
- Each sale has a second entry: Dr Cost of Goods Sold, Cr Merchandise Inventory
- COGS and inventory on hand are known at any moment
- A physical count is compared with the records to find shrinkage
- Usually run by a point-of-sale system with barcode scanning
- Purchases are debited to a Purchases account, not to Inventory
- No cost entry at the time of sale
- COGS is calculated only at the end of the period
- A physical count is the only way to know ending inventory
- COGS = Beginning inventory + Net purchases − Ending inventory
Both systems start from the same idea, shown in the cost flow below. Beginning inventory plus purchases gives the cost of goods available for sale. That pool of cost must end up in one of exactly two places: Cost of Goods Sold on the income statement, or Merchandise Inventory on the balance sheet. A cost formula just decides which costs go where.
| Date | Event | Units | Unit cost | Total cost |
|---|---|---|---|---|
| Oct 1 | Beginning inventory | 100 | $20 | $2,000 |
| Oct 8 | Purchase | 200 | $22 | $4,400 |
| Oct 15 | Sale | (220) | ||
| Oct 22 | Purchase | 200 | $25 | $5,000 |
| Oct 29 | Sale | (180) | ||
| Goods available for sale | 500 | $11,400 | ||
| Units sold / units on hand Oct 31 | 400 / 100 |
Specific identification, FIFO and average cost
- Specific identification: track the actual cost of each individual item, often by serial number. Required for items that are not interchangeable, such as custom canoes, vehicles or fine jewellery. Impractical for thousands of identical backpacks.
- FIFO (first-in, first-out): assume the oldest costs leave first. Cost of goods sold uses the earliest costs; ending inventory is made of the most recent costs.
- Weighted average (periodic): divide total cost of goods available by total units available, and apply that one average to both units sold and units on hand.
- Moving average (perpetual): recompute the average after every purchase, and cost each sale at the average at that moment.
| Date | Purchased | Cost of goods sold | Balance on hand |
|---|---|---|---|
| Oct 1 | 100 @ $20 = $2,000 | ||
| Oct 8 | 200 @ $22 = $4,400 | 100 @ $20 + 200 @ $22 = $6,400 | |
| Oct 15 | 100 @ $20 + 120 @ $22 = $4,640 | 80 @ $22 = $1,760 | |
| Oct 22 | 200 @ $25 = $5,000 | 80 @ $22 + 200 @ $25 = $6,760 | |
| Oct 29 | 80 @ $22 + 100 @ $25 = $4,260 | 100 @ $25 = $2,500 | |
| Totals | $9,400 | $8,900 | $2,500 |
Check the FIFO card: cost of goods sold $8,900 plus ending inventory $2,500 is $11,400, the cost of goods available. With the periodic formula: Under FIFO, perpetual and periodic always agree, because the oldest units are the oldest units no matter when you look.
Weighted average (periodic): ending inventory is and cost of goods sold is . Again the two add to $11,400. Moving average (perpetual) recomputes the average after each purchase, so its answer is slightly different. Keep unit costs to four decimal places and round dollar amounts to the cent.
| Date | Units on hand | Total cost | Average unit cost | Cost of goods sold |
|---|---|---|---|---|
| Oct 1 | 100 | $2,000.00 | $20.0000 | |
| Oct 8 (+200 @ $22) | 300 | $6,400.00 | $21.3333 | |
| Oct 15 (−220) | 80 | $1,706.67 | $21.3333 | $4,693.33 |
| Oct 22 (+200 @ $25) | 280 | $6,706.67 | $23.9524 | |
| Oct 29 (−180) | 100 | $2,395.24 | $23.9524 | $4,311.43 |
| Totals | $9,004.76 |
LIFO, and why Canadian companies cannot use it
LIFO (last-in, first-out) assumes the newest costs leave first. For the backpacks, periodic LIFO would charge the last 400 units bought to cost of goods sold, leaving the oldest 100 units at $20 in ending inventory, $2,000. LIFO is allowed in some other countries, notably the United States, so you will see it in American financial statements. It is NOT permitted under IFRS or ASPE, so Canadian companies use specific identification, FIFO or a weighted average cost formula. The main criticism: when prices rise for years, LIFO leaves inventory on the balance sheet at very old, unrealistically low costs.
| Rising costs ($20, $22, $25) | Cost of goods sold | Ending inventory | Gross profit |
|---|---|---|---|
| FIFO | $8,900.00 | $2,500.00 | $7,100.00 |
| Moving average (perpetual) | $9,004.76 | $2,395.24 | $6,995.24 |
| Weighted average (periodic) | $9,120.00 | $2,280.00 | $6,880.00 |
| LIFO (not permitted in Canada) | $9,400.00 | $2,000.00 | $6,600.00 |
Effects on the statements: rising and falling costs
When costs are rising, FIFO sends the old, cheap costs to cost of goods sold, so it reports the LOWEST cost of goods sold, the HIGHEST gross profit and net income, and the HIGHEST ending inventory, which is close to current replacement cost. Average cost lands in between. When costs are falling, everything flips: FIFO now sends the old, expensive costs to cost of goods sold and reports the lowest profit. Over the whole life of a business the total cost charged is the same; the methods only shift profit between periods. Higher reported income also means higher income tax in that period.
| Falling costs ($30, $27, $24) | Cost of goods sold | Ending inventory | Gross profit |
|---|---|---|---|
| FIFO | $10,800.00 | $2,400.00 | $7,200.00 |
| Weighted average (periodic) | $10,560.00 | $2,640.00 | $7,440.00 |
| LIFO (not permitted in Canada) | $10,200.00 | $3,000.00 | $7,800.00 |
Lower of cost and net realizable value (LCNRV). Inventory should never be reported at more than the business expects to get for it. Net realizable value is the estimated selling price minus the costs needed to sell it. If NRV falls below cost (goods become damaged, out of style, or the market price drops), inventory is written down to NRV, usually item by item or by groups of similar items, and the loss is charged to cost of goods sold. Under both ASPE and IFRS, if NRV later recovers, the write-down is reversed, but never above the original cost.
| Date | Account | Debit | Credit |
|---|---|---|---|
| 2026 Dec 31 | Cost of Goods Sold | $200.00 | |
| Merchandise Inventory | $200.00 |