A perpetual inventory system changes the stock record with every purchase and every sale, so it always shows what you have. A periodic system leaves the record alone and finds the stock, and the cost of goods sold, only when you count at the end of the period.
Periodic: cost of goods sold = opening stock + purchases − counted closing stockPerpetual inventory: a paper or automated inventory tracking system in which a new inventory balance is calculated whenever new transactions occur. A receiving adds to it, a sale takes from it, and each sale also records its cost.
The periodic system keeps no running balance. Companies using it examine and count their inventory periodically. A complete physical inventory count must then be conducted at the end of each reporting period, because the count is the only source of the closing stock. So the system has no way of knowing how much inventory is in stock between counts.
| Perpetual | Periodic | |
|---|---|---|
| Stock record | Changes with every receiving and sale | Changes only at the count |
| Cost of goods sold | Recorded with each sale | Worked out once, after the count |
| Stock on hand today | On screen | Unknown until you count |
| Shrinkage | Shown as its own line | Hidden in the cost of goods sold |
| Reorder points | Possible | Not possible |
| Work | Every document must be entered | Only the purchases and the count |
Shortages can arise if the stock is not permanently recorded (periodic count), if the stock is ordered too late, or when an order is delivered late. Only the first cause is about the system, and a perpetual record removes it: the shelf can be empty, but the record says so before a customer does.
The shop starts June with stock worth 8,000.00 at cost and buys goods for 12,500.00 during the month. On 30 June it counts the shelves and finds stock worth 7,300.00 at cost.
| June, at cost | Periodic | Perpetual |
|---|---|---|
| Opening stock | 8,000.00 | 8,000.00 |
| Purchases | 12,500.00 | 12,500.00 |
| Cost of the goods sold, from the sales | — | 12,950.00 |
| Closing stock in the records | — | 7,550.00 |
| Closing stock counted | 7,300.00 | 7,300.00 |
| Shrinkage | — | 250.00 |
| Cost of goods sold in the accounts | 13,200.00 | 13,200.00 |
Periodic: 8,000.00 + 12,500.00 − 7,300.00 = 13,200.00. That is everything that left the shop, sold or not.
Perpetual: each sale recorded its cost, 12,950.00 in all, so the record expects 8,000.00 + 12,500.00 − 12,950.00 = 7,550.00 on the shelves. The count finds 7,300.00. The difference of 250.00 is goods that left without a sale.
The total cost in the accounts is the same. The difference is what you learn: the periodic shop knows its cost of goods sold, the perpetual shop also knows that 250.00 of it was shrinkage, and the count tells it which items to look at.
When a business uses a perpetual inventory system or a periodic stock count, it will find some differences between the quantity found in stock and the quantity in its records. With a perpetual record, each difference belongs to one item, and you can find its cause. The stock count guide shows how.
Given the large volume of transactions, it is nearly impossible not to have some errors. A delivery is received into the wrong item, a sale is rung up under a similar product, a broken glass goes in the bin and not in the system.
When transactions are not entered at the time, the on-hand quantities of inventory can become inaccurate, making it hard to plan purchasing and sales, as well as cycle counting. An important control is making sure that transactions are entered in the inventory system at once. The other control is a short count of a few items every week, so the errors are found while the cause is still easy to see.
The periodic system can work for a business with few items, a low stock value and an accountant who only needs the year-end figure. It costs nothing but a count.
A perpetual record pays for itself when one of these is true:
A point of sale with a scanner makes the work small. Bar coding is tailor-made for perpetual records: the sale lowers the stock, and the receiving raises it, with no extra typing.
In System 5 every stock change is a document that writes the stock ledger: a receiving, an invoice or sales receipt, a transfer between locations, a work order and a stock count.
Nearly. The record changes when a document is entered. If every sale goes through the till and every delivery is received in the program the same day, the record is current all day.
Usually yes, or a cycle count program that covers every item during the year. Ask your accountant which one your auditor accepts.
Yes. The system decides when the stock is updated; the cost method decides at what price. See FIFO vs moving average cost.
Yes, if the count at the end of each period is complete and the cost of goods sold is worked out from it. Many small shops report this way.
Stock that left without a sale: theft, damage, spoilage, and receipts or sales entered wrongly. Only a perpetual record can show it apart from the cost of goods sold.
Golden Inventory System 5 is a Windows program that you pay for once: $99 for up to 5 users, $199 for any number. Every receiving and every sale changes the stock at once.