Skip to contentSkip to search

Accounting for Inventory

1 Introduction

This chapter looks at how inventory is accounted for.

2 What is inventory and why is it important?

Inventory can be any of the following:

Raw materials are purchased and then undergo further processing or are incorporated into products. Raw materials can be basic materials such as chemicals, flour, or lengths of wood. Or raw materials can be items which have been manufactured by the supplier, such as components and parts for use in production.

Work in progress refers to partly made products. They have progressed from the bought in stage (raw materials) but are not yet complete.

Finished goods are complete and are ready for sale.

When producing a set of financial statements, inventory has two effects:

The statement of financial position: closing inventory is an asset and must therefore appear on the statement of financial position. It will be included in current assets.

The statement of profit or loss: an inventory adjustment is needed to match sales revenues with the cost of the goods sold. Not everything purchased in a period is necessarily sold in that period and to achieve proper matching inventory has to be taken into account.

3 The standard inventory adjustment

Opening inventory = 2,000 units

Closing inventory = 2,300 units

Units purchased = 8,000 units

All units in inventory and those purchased cost $5 each. All are sold at $9 each.

Expenses amount to $3,700

Draft the statement of profit or loss.

Statement of profit or loss

Units

$/unit

$

$

Show answerHide answer

Example 1

Opening inventory = 2,000 units

Closing inventory = 2,300 units

Units purchased = 8,000 units

All units in inventory and those purchased cost $5 each. All are sold at $9 each.

Expenses amount to $3,700

Note:

Available units for sale = 2,000 (opening) + 8,000 (purchased) = 10,000.

Of these, the 2,300 units in closing inventory were not sold, so 10,000 – 2,300 = 7,700 units must have been sold.

Statement of profit or loss

Units

$/unit

$

$

Sales

7,700

9

69,300

Opening inventory

2,000

5

10,000

Purchased

8,000

5

40,000

10,000

50,000

Closing inventory

(2,300)

5

(11,500)

Cost of sales ie cost of units sold

7,700

5

38,500

Gross profit

30,800

Expenses

(3,700)

Net profit

27,100

So, the standard inventory adjustment for the statement of profit or loss is:

Cost of sales = opening inventory + purchases – closing inventory

4 The standard inventory adjustment in ‘T’ accounts

So, now we know the principle of the inventory adjustment, but how is this recorded in the books of account? Here again are the figures and the statement of profit or loss:

Opening inventory = 2,000 units

Closing inventory = 2,300 units

Units purchased = 8,000 units

All units in inventory and those purchased cost $5 each. All are sold at $9 each.

Expenses amount to $3,700

Statement of profit or loss

Units

$/unit

$

$

Sales

7,700

9

69,300

Opening inventory

2,000

5

10,000

Purchased

8,000

5

40,000

10,000

50,000

Closing inventory

(2,300)

5

(11,500)

Cost of sales ie cost of units sold

7,700

5

38,500

Gross profit

30,800

Expenses

(3,700)

Net profit

27,100

In ‘T’ accounts this would be recorded as follows:

The opening balance on the inventory account is the closing inventory from the last period. During the year, purchases are debited into the purchases account and sales credited into the sales account, as shown. The inventory account is not touched.

Inventory

Balance brought down (opening inventory)

10,000

Purchases

Cash/supplier

40,000

Sales

Cash/customer

69,300

At the end of the period, the amount of closing inventory is assessed and the inventory adjustments will be:

Dr     Cost of sales account     10,000

  Cr     Inventory account     10,000

being the transfer of the opening inventory into cost of sales

Dr     Inventory account     11,500

  Cr     Cost of sales       11,500

being the removal of the closing inventory from cost of sales and establishing it as an inventory asset.

Dr     Cost of sales account     40,000

  Cr     Purchases       40,000

being the transfer of purchases to the cost of sales account.

After these adjustments the accounts will be:

Inventory

Balance brought down (opening inventory)

10,000

To cost of sales

10,000

Cost of sales (closing inventory)

11,500

Balance carried down
(closing inventory)

11,500

21,500

21,500

Balance brought down (closing inventory)

11,500

Purchases

Cash/supplier

40,000

To cost of sales

40,000

Sales

To statement of profit or loss

69,300

Cash/customer

69,300

Cost of Sales

Inventory (opening)

10,000

Inventory (closing)

11,500

Purchases

40,000

To statement of profit or loss (balance)

38,500

Note that the closing inventory adjustment is:

Dr     Inventory account     11,500

  Cr     Cost of sales       11,500

A business could put any figure it wanted to into that adjustment and the financial statements would still balance. Every extra $ of closing inventory increases the inventory asset by $1 and decreases cost of sales (hence increasing profits) by $1. Therefore, inventory valuation is a very critical area in the preparation of financial statements – and for the audit of those statements.

5 Continuous and period-end inventory records

There are two ways a business can know what inventory it holds, and the study guide asks you to explain both.

A period-end inventory record. No running record is kept. Goods bought are debited to Purchases and nothing is written down when goods are sold. At the year end the business shuts the warehouse, counts everything physically, values it, and that count is the closing inventory figure used in the year-end adjustment. This is the system assumed everywhere else in this chapter.

A continuous (perpetual) inventory record. A record is kept for each line of inventory and updated at every movement - every receipt and every issue - so the quantity and value held are known at any moment. The cumulative weighted average table later in this chapter is exactly such a record. Instead of one big count, the business counts a few lines each week or month (continuous counting), checking the physical quantity against the record and investigating differences as they arise.

Period-end

Continuous

Cost

Cheap - no records to maintain

Expensive to set up and keep accurate

Disruption

Trading usually has to stop for the count

None - counting is spread through the year

Information

Inventory and cost of sales known only at the year end

Inventory and cost of sales known at any time, so profit can be reported monthly

Control

Losses and theft show up once a year and cannot be traced

Differences show up quickly and can be investigated

Suits

A small business with few, low-value lines

A business with many lines, high values, or a need for reordering data

A continuous record does not remove the need to count. The record is compared with a physical count and, where they differ, it is the count that is right: the record is adjusted to it, and the difference is written off to cost of sales.

6 Different methods used to price materials issued from inventory and to value closing inventory

In the examples above, all inventory, whether opening, purchases or in closing inventory had the same cost. In practice, the cost of purchases can fluctuate and this forces us to consider how to calculate the cost of the units sold and the cost of the units still in inventory.

Consider the following:

12 March 20X4: buy 1000 units at $5 each

21 March 20X4: buy 500 units at $6 each

31 March 20x4: sell 800 units at $12 each.

It is clear that revenue will be 800 x $12 = $9,600, but what is the cost of the units sold? Which have been sold?

What is their value and the value of the inventory left?

You have to know three approaches:

  • FIFO

  • Cumulative weighted average

  • Periodic weighted average

FIFO (First-in, first out)

This method assumes that the goods that arrive first are the first to be used. It is only an assumption: apart from their price all goods of a given type are identical and therefore you don’t know, or care, how they are physically used.

So, in the above case, all 800 units sold would be assumed to be those delivered on 12 March. They would have a cost of 800 x $5 = $4,000 and the value of the inventory remaining would be 200 x $5 + 500 x $6 = $4,000.

Note that receipts and sales are handled on a strict time basis.

Cumulative weighted average

Every time units are added, a new average price is calculated. Any time goods are removed they are removed at the prevailing average.

12 March 20X4: buy 1000 units at $5 each

21 March 20X4: buy 500 units at $6 each

31 March 20x4: sell 800 units at $12 each.

$

12 March 20X4

1,000

@ $5

5,000

21 March 20X4

500

@ $6

3,000

$5.33 = average cost

1,500

@ $5.33

8,000

31 March 20X4

(800)

@ $5.33

(4,267)

Closing inventory

700

@$5.33

3,733

Note:

Sales do not alter the average cost.

Receipts and sales are handled on a strict time basis.

Periodic weighted average

Here, a new inventory value is calculated at the end of a set period. The cost of goods used is given by:

Average cost per unit = (cost of opening inventory + cost of purchases in the period) ÷ (units in opening inventory + units purchased in the period)

So, all units used in the period will have the same cost.

In the above simple example this method would give the same result as the cumulative weighted average approach

Recent results of a division are:

Date

Units

Unit
price

1 April

Opening inventory

1,000

5.00

5 April

Purchased

500

6.00

9 April

Sold

200

N/a

14 April

Purchased

600

5.50

21 April

Sold

1,200

N/a

Calculate the cost of inventory used each time and the cost of the inventory remaining at the end of the period using:

  1. FIFO

  2. Average cumulative cost

  3. Periodic average cost

Show answerHide answer

Example 2

Date

Units

Unit price

1 April

Opening inventory

1,000

5.00

5 April

Purchased

500

6.00

9 April

Sold

200

N/a

14 April

Purchased

600

5.50

21 April

Sold

1,200

N/a

FIFO

Sale of 200 on 9 April: assumed to be units from opening inventory: 200 @ $5 = $1,000

Sale of 1,200 on 21 April: assumed to be the 800 remaining from opening inventory plus 400 from the purchase on 5 April: 800 @ $5 + 400 @ $6 = $6,400

Closing inventory will be all the 600 purchased on 14 April plus 100 left from the 5 April purchase = 600 @ $5.50 + 100 @ $6.00 = 3,900.

Cumulative weighted average

Date

Units

Unit
price

Cumulative weighted average

1 April

Opening inventory

1,000

5.00

5,000

5 April

Purchased

500

6.00

3,000

1,500

@5.333

[8,000/1,500 = 5.3333]

8,000

9 April

Sold

(200)

@5.333

(1,067)

1,300

@5.333

6,933

14 April

Purchased

600

5.50

3,300

1,900

@5.386

10,233

21 April

Sold

(1,200)

@5.386

(6,463)

Closing inventory

700

@5.386

3,770

Cost of sales = $1,067 + $6,463 = 7,530

Closing inventory = $3,770

Periodic weighted average

Value of purchases plus opening inventory = $5,000 + $3,000 + $3,300 = $11,300

Units purchased plus in opening inventory = 1,000 + 500 + 600 = 2,100

Periodic average = 11,300/2,100 = 5.381

Cost of sales = (200 + 1,200) x 5.381 = 7,533

Value of inventory = 700 x 5.381 = 3,767

7 The effect of the valuation method on profit, assets and capital

Example 2, now that you have done it, is worth going back to, because it gives three different closing inventory figures for the same goods:

Method

Closing inventory

Cost of sales

FIFO

3,900

7,400

Cumulative weighted average

3,770

7,530

Periodic weighted average

3,767

7,533

The goods are the same, the sales are the same, and the cash is the same. Only the split between what has been charged to cost of sales and what is still sitting in inventory has changed - and because cost of sales = opening inventory + purchases - closing inventory, a higher closing inventory always means a lower cost of sales and therefore a higher profit.

When prices are RISING, as they are in Example 2:

  • FIFO charges the oldest, cheapest goods to cost of sales and leaves the newest, dearest ones in inventory. So FIFO gives the highest closing inventory, the lowest cost of sales and the highest profit.

  • The weighted average methods mix old and new prices together, so they give a lower closing inventory and a lower profit than FIFO.

  • When prices are FALLING, all of this reverses: FIFO then gives the lowest closing inventory and the lowest profit.

The consequences follow automatically:

  • Assets. Closing inventory is a current asset, so the method that gives the higher inventory figure gives the higher total assets.

  • Capital. Profit is added to capital, so the method that gives the higher profit gives the higher closing capital by exactly the same amount.

  • Next year. The difference is only ever a timing difference. This year's closing inventory is next year's opening inventory, so a higher profit this year means a higher cost of sales and a lower profit next year. Over the life of the business the total profit is the same whichever method is used.

This is why the consistency principle matters here: a business cannot switch methods from year to year to flatter its profit.

8 Other inventory valuation issues: cost and net realisable value

The fundamental principle of IAS 2 is that inventories must be stated at the lower of cost and net realisable value. This valuation rule ensures a prudent approach to inventory accounting: profits are not recognised until earned (ie the inventory is sold at above cost), but losses would be taken as soon as foreseen (because inventory is valued at net realisable value if lower than cost).

Cost should include all:

  • Costs of purchase (including taxes, transport, and handling) net of trade discounts received.

  • Costs of conversion (including fixed and variable manufacturing overheads)

  • Other costs incurred in bringing the inventories to their present location and condition.

Net realisable value is the estimated selling price in the ordinary course of business, less the estimated cost of completion and the estimated costs necessary to make the sale.

Each line of inventory has to have its cost/NRV comparison carried out separately. The comparison is not performed on total inventory figures.

Value the inventory items shown below:

Product Number

Number of units

Purchase price of goods/unit

Carriage inwards/unit (delivery cost paid by purchaser)

Selling price of goods/unit

Costs of packing and delivering goods/unit (carriage outwards)

Inventory valuation for the financial statements

$

$

$

$

$

1435

400

10

1

20

2

1567

120

20

2

15

2

1577

300

15

1

18

3

1601

200

20

2

40

2

1733

150

30

2

10

1

Show answerHide answer

Example 3

Valuation of the inventory items shown below:

Product Number

Number of units

Purchase price of goods/unit

Carriage inwards/unit (delivery cost paid by purchaser)

Selling price of goods/unit

Costs of packing and delivering goods/unit (carriage outwards)

Inventory valuation for the financial statements

Basis

$

$

$

$

$

1435

400

10

1

20

2

4,400

Cost
10 + 1 = 11

1567

120

20

2

15

2

1,560

NRV
15 – 2 = 13

1577

300

15

1

18

3

4,500

NRV
18 – 3 = 15

1601

200

20

2

40

2

4,400

Cost
20+2 = 22

1733

150

30

2

10

1

1,350

NRV
10 – 1 = 9

Practice question

Opening inventory = $12,400

Cost of sales = $93,000

Closing inventory = $16,600

What were purchases?

Practice question

Which of the following are the proper journal entries for inventory when financial statements are to be prepared?

Practice question

The items in closing inventory cost $15,000 to purchase. In addition there was carriage inwards of $1,000.

The goods would cost $2,500 to clean, pack and distribute and they would then sell for $12,000.

At what amount should the goods be valued in the financial statements?

Practice question

Purchases and sales of an item of inventory were as follows:

DatePurchase / saleUnitsPurchase / sale price per unit ($)
12/1/2014Purchase1,00012.00
20/1/2014Purchase50013.00
21/1/2014Sale1,20020.00
25/1/2014Purchase70014.00
31/1/2014Sale10021.00

If the FIFO method of valuing inventory is used, what is the value of the goods remaining?

Practice questions

Accounting for Inventory

9 questions

Answer the questions one at a time. Your progress is saved so you can leave and come back.

Open chapter practice