1
Chapter 5
Accounting for
merchandising operations
Appendix 5B:
The accounting worksheet
for merchandisers
2
1. Prepare an accounting worksheet for
merchandisers (perpetual and periodic)
Learning objective
3
▪ Aim is to highlight the differences between the
worksheet of a service business and the worksheet
prepared for merchandisers under the perpetual
and periodic inventory systems
▪ Assumes you already know how to construct a
worksheet
▪ Refer to chapter 4 if you need a refresher on how a
worksheet is constructed
Worksheet for merchandisers
4
▪ New accounts presented in the worksheet for
merchandisers are:
– Merchandise Inventory (periodic and perpetual)
– Sales Revenues (periodic and perpetual)
– Sales Returns and Allowances (periodic and perpetual)
– Sales Discounts (periodic and perpetual)
–
Cost of Goods Sold (perpetual only)
Worksheet for merchandisers
5
Under the perpetual inventory system:
▪ The Merchandise Inventory account in the
unadjusted trial balance column shows the balance
of the account before adjusting entries
▪ The adjusting entries column includes the adjusting
entry for inventory shrinkage
Worksheet – perpetual inventory
6
Under the perpetual inventory system:
▪ The income statement column reports:
– Credit balance for Sales Revenues
– Debit balance for Sales Returns and Allowances
– Debit balance for Sales Discounts
– Debit balance for Cost of Goods Sold
▪ The balance sheet reports the debit balance of
Merchandise Inventory after the adjustment for
inventory shrinkage
Worksheet – perpetual inventory
7
Worksheet – perpetual inventory
8
Under the periodic inventory system:
▪ New accounts presented in the worksheet for the
periodic inventory system are:
– Purchases
– Purchase Returns and Allowances
– Purchase Discounts
– Transportation In
Worksheet – periodic inventory
9
Under the periodic inventory system:
▪ The Merchandise Inventory account in the
unadjusted trial balance column shows the balance
of the account at the beginning of the accounting
period
– Merchandise Inventory account is only updated once at
the end of the period
▪ The adjusting entries column has no adjusting entry
for inventory shrinkage
– Shrinkage is accounted for when taking inventory
Worksheet – periodic inventory
10
▪ The income statement column reports the accounts
used in the calculation of cost of goods sold
Worksheet – periodic inventory
11
Calculation of the Cost of Goods Sold under the periodic inventory system
$
Opening inventory 56,000
Add: Purchases 530,000
Less: Purchase Returns and Allowances 4,000
Less: Purchase Discounts 8,000
Add: Transportation In 13,000
Equals: Cost of merchandise available for sale 587,000
Less: Ending inventory 68,000
Equals: Cost of Goods Sold 519,000
▪ Accounts that increase cost of goods sold are
recorded in the debit column
– Opening inventory
– Purchases
– Transportation In
▪ Accounts that decrease cost of goods sold are to
be reported in the credit column
– Purchase Returns and Allowances
– Purchase Discounts
– Ending inventory
Worksheet – periodic inventory
12
▪ The balance sheet reports the ending balance of
inventory as revealed by the physical count of
inventory taken at the end of the period
Worksheet – periodic inventory
13
Worksheet – periodic inventory
14
