Inventory Systems: Perpetual vs Periodic - YouTube

Channel: Accounting Stuff

[0]
In this video you'll find out what perpetual and periodic inventory systems are.
[5]
I'll explain the differences and show you how they both work
[8]
in a few simple steps.
[10]
[Music]
[12]
Hello there
[15]
welcome back to Accounting Stuff.
[16]
I'm James and in this week's video we're going to continue our
[20]
inventory mini-series.
[21]
Last time I showed you how to account for one unit of inventory
[25]
in a merchandising business and today I'd like to expand on that idea.
[29]
I want to show you how to account for many units of inventory at the same time.
[34]
We do that using the perpetual and periodic inventory systems.
[39]
But first some definitions…
[42]
In a merchandising business inventory is the goods
[46]
held by business that intends to sell
[49]
to earn revenue.
[50]
A perpetual system continuously updates a business's inventory account
[56]
as goods are bought and sold on a unit by unit basis.
[61]
Whereas a periodic system updates a business's inventory account
[65]
at regular intervals.
[67]
This is usually triggered by a physical inventory count
[70]
that happens at the end of each accounting period it could happen after
[74]
each month, quarter or at the end of a financial year.
[78]
So what are the pros and cons of the perpetual and periodic inventory systems?
[83]
A perpetual inventory system continuously updates your books
[88]
which means ‘in theory’ that it’s possible to see
[91]
your results in real-time.
[93]
This system also makes it easy to track your inventory levels
[96]
so you can spot stock shortages quickly.
[99]
Sounds great doesn't it?
[101]
Yes, but this comes at a price.
[104]
It can be expensive to set up a perpetual inventory system
[108]
and it's not always reliable.
[110]
You can sometimes find differences between inventory levels
[113]
in the system and what they are in real life.
[116]
Some of your inventory might have been lost or stolen
[119]
or there could be some human error involved
[121]
who knows?
[122]
Who knows.
[123]
But this uncertainty pushes some businesses to
[126]
double-check their numbers using periodic inventory counts.
[130]
The advantages of the periodic system are that
[133]
it’s relatively simple and set up costs tend to be lower.
[137]
However since you're only checking your inventory levels periodically
[140]
this can lead to delayed results.
[142]
I'll explain how that works later in this video.
[145]
Another problem with their system is that you have less control
[147]
of your inventory.
[148]
It can be hard to know what happened between each inventory count.
[152]
Now I'm going to show you how the perpetual and periodic inventory systems work
[156]
and help me explain we'll use an example.
[159]
Imagine that you own a book shop it's the end of September
[163]
and you're holding 300 books that cost you $8 per unit to buy.
[168]
In October you buy another 500 books at the same price
[172]
$8 per unit and you sell 450 books for $15 a unit.
[179]
Notice that we're keeping the cost price exactly the same in this example.
[182]
In the real world it changes and we need to make assumptions
[185]
to help us value our inventory.
[188]
There are three ways to do that FIFO, LIFO and Average Cost.
[192]
I'm going to cover all of these in future videos in this playlist
[195]
so remember to hit subscribe if you'd like to see those.
[198]
But my question here is…
[200]
How do you account for these transactions using the
[203]
perpetual and periodic inventory systems?
[205]
We’re going to do it both ways and what's your
[209]
cost of goods sold in October.
[211]
Let's find out.
[213]
We'll begin with a calculation.
[215]
At the top you have your opening inventory plus your additions for October.
[221]
When you add these together you work out your
[223]
cost of goods available for sale and below that
[227]
if you subtract your cost of goods sold
[230]
then you come to your closing inventory.
[233]
Your inventory on hand at the end of the period.
[236]
This calculation is going to be our foundation for the rest of the example.
[241]
We'll use it to work out your closing inventory and your cost of goods sold for October
[246]
using both the perpetual and periodic methods.
[249]
Now I want you to pay close attention to timing.
[252]
When is it that you first find out your cost of goods sold
[255]
under each method?
[257]
This is key to understanding the difference between the two systems.
[261]
Right I put together some steps to help us work this out.
[264]
We'll run through them now but you can also find them on my
[267]
inventory systems cheat sheet where I summarize all of the key points
[271]
I make in this video on one page.
[273]
You can help support this channel by buying it on my website
[276]
there should be a link to it up here and I’ll drop one in the description as well.
[280]
Step one.
[281]
Last period’s closing inventory becomes this period’s opening inventory.
[286]
If we refer back to our calculation we're thinking about this top line.
[291]
Opening inventory.
[292]
This is your beginning inventory the inventory that you have on hand
[296]
at the start of October.
[297]
How do we know that?
[300]
Well we said you closed out September with 300 books
[304]
costing $8 per unit.
[306]
300 multiplied by $8 gives you $2,400.
[312]
That's your closing September balance which you need to bring
[314]
forward into October.
[317]
Step one is exactly the same whether you’re using the perpetual or periodic system
[322]
and since inventory is a normal debit account
[326]
we can show this opening inventory as a debit of $2,400
[331]
on the left-hand side of your inventory T-account.
[335]
Remember debits always go on the left and credits
[338]
always go on the right.
[340]
Always always always.
[342]
Time for Step Two.
[343]
And here's where we start seeing some differences between
[345]
the two systems.
[347]
Under the perpetual system this is where you record additions
[351]
in your inventory account but under the periodic system
[355]
this is where you record additions in your purchases account.
[359]
In October you bought 500 books costing you $8 per unit.
[365]
500 multiplied by $8 is $4,000 that's your additions for October.
[371]
Under the perpetual system you record these additions
[375]
a debit to inventory of $4,000 and depending on how you
[380]
settled the transaction a credit to cash
[383]
or accounts payable of $4,000.
[386]
But what about the periodic system?
[389]
Here the journal entry is very similar however there's one subtle difference.
[393]
You don't debit your inventory account you debit your purchases account instead.
[399]
You debit purchases by $4,000 and you credit cash
[403]
or accounts payable by $4,000.
[406]
The purchases account only exists under the periodic inventory system.
[411]
It holds all of the inventory that you've purchased during a period.
[416]
At the end of the period this will get cleared out to zero.
[419]
I'll show you how that works towards the end of this video.
[422]
Which brings us on to step three.
[424]
How to recognize inventory sales under the perpetual system.
[429]
This is where you recognize revenue and record cost of goods sold
[433]
as sales take place.
[435]
But in the periodic system you only recognize your revenue
[439]
as sales take place.
[441]
You might remember from my last video that selling inventory triggers
[444]
two journal entries.
[446]
You recognize revenue in your income statement
[449]
and you release cost of goods sold from your balance sheet
[452]
to your income statement.
[454]
Under the perpetual system you'd record this by
[456]
crediting your revenue account and debiting your cash account
[460]
or accounts receivable but how much revenue
[463]
should you recognize?
[465]
Well you sold 450 books at $15 per unit.
[470]
450 multiplied by $15 gives you $6,750 so you credit revenue by $6,750
[480]
to increase your earnings in the income statement
[484]
and you debit cash or accounts receivable by $6,750 to increase your
[491]
assets in the balance sheet.
[493]
In the second journal entry you release the cost of goods sold
[497]
from your balance sheet to your income statement
[499]
you sold 450 books which you bought for $8 per unit.
[506]
450 multiplied by $8 is $3,600 and you need to release this
[512]
from your balance sheet because you're no longer
[514]
holding this inventory.
[516]
So you credit inventory by $3,600 to release it from your balance sheet
[521]
and you debit cost of goods sold by $3,600 to record the expense
[527]
in your income statement.
[528]
Okay but what about the periodic system?
[532]
In the periodic system you only recognize your revenue
[535]
as sales take place.
[537]
So selling inventory only triggers one journal entry
[540]
to recognize your revenue.
[542]
You have no idea what your cost of goods sold are at this point
[545]
because you haven't counted your inventory yet.
[548]
So you credit revenue by $6,750 and debit cash or accounts receivable
[556]
by $6,750 and that's it.
[560]
Step four.
[562]
With the perpetual method inventory is updated in real-time.
[566]
At any given point you know all of the variables in this calculation
[570]
so you're closing inventory balance is continuously updated.
[575]
In this example your cost of goods available for sale
[578]
were $6,400 and you sold 450 books costing you $3,600.
[586]
That's your cost of goods sold and when we take the difference
[589]
you're left with your closing inventory balance of $2,800 in October.
[596]
To find your closing inventory and your cost of goods sold
[598]
under the periodic system we need to fast forward to the end of October.
[603]
You still have two more steps to get through.
[605]
In step four you need to clear total purchases
[608]
to your inventory account.
[610]
What does that mean?
[612]
It means that you need to post a journal to clean all of your October
[615]
inventory additions out of your purchases account
[619]
and transfer them to your inventory account.
[621]
So you credit purchases by $4,000 and you debit inventory by $4,000.
[628]
This might seem a bit silly with only one addition in this example
[632]
but if you buy inventory in multiple batches throughout a period
[635]
then this way of doing things is a lot cleaner.
[638]
Right it's time for your inventory count.
[641]
You head to your storage room where you keep all of your books
[644]
and you physically count all of your inventory on hand.
[648]
350 books in total.
[650]
That's your closing inventory.
[652]
In step 5 you update your closing inventory
[656]
and calculate your cost of goods sold.
[659]
These books cost you $8 each to buy 350 multiplied by $8 is $2,800.
[668]
That's your closing inventory balance which we can pop into the calculation here.
[673]
But there's one final piece to this puzzle.
[676]
You still need to find out your cost of goods sold
[679]
and you can do that by rearranging this calculation.
[682]
Your cost of goods available for sale less your closing inventory gives you
[687]
your cost of goods sold.
[690]
$6,400 less $2,800 is $3,600.
[697]
So to recognize this in your income statement
[699]
you debit cost of goods sold by $3,600 and you credit inventory by $3,600.
[708]
You can see that your cost of goods sold
[710]
under the periodic method is exactly the same as
[713]
the cost of goods sold you calculated under the perpetual method.
[716]
The difference is in the timing.
[718]
In the perpetual system you were able to see your results in real time
[723]
because both your revenue and your cost of goods sold
[726]
were continuously updated as you sold your inventory
[729]
however in the periodic system you needed to wait for the inventory count
[734]
at the end of the month to find out your cost of goods sold.
[737]
It took longer to find out your results.
[740]
I've summarized all of this in the cheat sheet which
[742]
you can find linked on my website over here.
[745]
There are plenty more inventory videos coming out soon
[748]
so don't forget to subscribe if you'd like to see those
[750]
and I'll be popping them all in this playlist here
[753]
when they're done.
[754]
See you soon.