Inventory costing methods

Reviewed by Ijaz Ali, ACCA · Updated November 2026

In this lesson you will learn to

  • Calculate cost of goods sold (COGS) and ending inventory using FIFO and weighted average.
  • Record a credit sale and its inventory cost under a perpetual system.
  • Apply the lower of cost and net realisable value at month-end.

Quick recap

Cost of goods available for sale equals opening inventory plus purchases. The cost assigned to boxes sold becomes COGS. The cost assigned to boxes on hand stays in inventory, subject to a month-end valuation check.

Worked example

Great Lakes Supply Ltd. in Mississauga, Ontario, sells safety gloves by the box. It sells 250 boxes on credit for $20 each before HST. All amounts are in Canadian dollars.

January safety glove transactions
DateTransactionBoxesCost per boxTotal
Jan 1Opening inventory100$10.00$1,000
Jan 10Purchase200$12.00$2,400
Jan 20Purchase100$13.00$1,300
—Available for sale400—$4,700
Jan 25Sale at $20 per box250See calculations belowRevenue $5,000

FIFO

First in, first out assigns the oldest costs to the sale. The 250 boxes sold use all 100 boxes from opening inventory and 150 from the January 10 purchase. The remaining 50 boxes from January 10 and all 100 boxes from January 20 make up ending inventory.

  • COGS = 100 × $10 + 150 × $12 = $2,800.
  • Ending inventory = 50 × $12 + 100 × $13 = $1,900.
  • Cost check = $2,800 + $1,900 = $4,700.
  • Gross profit = $5,000 − $2,800 = $2,200.

Weighted average

Divide total cost by total boxes available. This weights each purchase price by the quantity bought at that price.

  • Weighted average cost = $4,700 ÷ 400 = $11.75 per box.
  • COGS = 250 × $11.75 = $2,937.50.
  • Ending inventory = 150 × $11.75 = $1,762.50.
  • Cost check = $2,937.50 + $1,762.50 = $4,700.
  • Gross profit = $5,000 − $2,937.50 = $2,062.50.

Under perpetual moving average, recalculate the average as stock is received. After January 10 it is $3,400 ÷ 300, or about $11.33 per box. After January 20 it is $4,700 ÷ 400, or $11.75. The sale follows both purchases, so perpetual moving average and periodic weighted average produce the same figures here. A sale between the purchases could produce different results.

Compare the results

January results before the NRV adjustment
MeasureFIFOWeighted average
COGS$2,800$2,937.50
Ending inventory$1,900$1,762.50
Gross profit$2,200$2,062.50

With rising unit costs, FIFO assigns the older, lower costs to COGS. In this example that leaves both gross profit and ending inventory $137.50 higher than under weighted average.

Journal entries under perpetual FIFO

On January 25, record the credit sale and Ontario HST at 13%. Then transfer the cost of the boxes sold from inventory to COGS.

January 25 journal entries
EntryAccountDebitCredit
Credit saleAccounts receivable$5,650—
Credit saleSales revenue—$5,000
Credit saleHST payable—$650
Cost of saleCost of goods sold$2,800—
Cost of saleInventory—$2,800

Lower of cost and net realisable value

Net realisable value (NRV) is the estimated selling price less any costs to complete and make the sale. At January 31, NRV is $11 per box. For the 150 boxes still on hand, total NRV is 150 × $11 = $1,650. FIFO cost is $1,900, so write inventory down by $250.

January 31 inventory write-down
AccountDebitCredit
Cost of goods sold$250—
Inventory—$250

After the write-down, inventory is $1,650, January COGS is $3,050 and gross profit is $1,950. If the same boxes are still on hand and the revised NRV supports $1,800, reverse $150 by debiting Inventory and crediting Cost of goods sold. Any reversal is capped at the original $250 write-down. The carrying amount cannot exceed the original $1,900 cost.

Standards note

IAS 2 under IFRS and Section 3031 under ASPE permit FIFO or weighted average for interchangeable inventory and do not permit last in, first out (LIFO). Both use the lower of cost and NRV for inventory like these gloves.

In the workplace

In SAP ECC, use MM03 and select Accounting 1 for the relevant valuation area to see the material’s price control. V is moving average price. S is standard price. With S, stock is posted at standard price and differences from actual prices on relevant receipts or invoices go to price difference accounts.

At month-end, reconcile stock quantities and values to the ledger, review slow-moving stock, and support the NRV estimate with evidence such as recent selling prices, planned markdowns and costs to sell. Document any write-down or reversal separately from ordinary inventory movements.

SAP Help Portal · Price control and MM03

Common mistakes

  • Using the $20 selling price to calculate COGS. Use the assigned inventory cost.
  • Taking a simple average of $10, $12 and $13. Weight each cost by its box quantity.
  • Including the $650 HST in revenue. It is a liability in this example.
  • Applying the NRV test to all 400 boxes. Only 150 are still in inventory at month-end.

Check your understanding

  1. Which cost layers are left after the FIFO sale?

    Show answer

    50 boxes at $12 and 100 at $13, for a total of $1,900.

  2. What is weighted average COGS, and why does moving average give the same result here?

    Show answer

    $2,937.50. Both purchases happened before the only sale, so the same 400 boxes and $4,700 of costs determine the rate.

  3. How much does the customer owe, and how much is sales revenue?

    Show answer

    The customer owes $5,650. Revenue is $5,000 and the remaining $650 is HST payable.

  4. After the write-down, NRV rises to $2,000 for the same boxes still on hand. How much can you reverse?

    Show answer

    Reverse $250 to bring inventory from $1,650 back to its $1,900 original cost.

Key takeaways

  • FIFO assigns the oldest costs to sales. Weighted average spreads total cost across the boxes available.
  • Under perpetual inventory, record the sale and the cost of the stock sold in separate entries.
  • At close, compare the cost of stock on hand with NRV. Cap any reversal at the original write-down.

About the tutor

Ijaz Ali is an ACCA-qualified Senior Accountant with over 10 years of experience in financial reporting, month-end close and SAP FICO. He is a former SAP FICO instructor and runs The Accounting Nest YouTube channel.

Watch on YouTube