Guide · inventory accounting for small businesses

Perpetual vs periodic inventory

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 stock

How the two systems work

Perpetual 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.

PerpetualPeriodic
Stock recordChanges with every receiving and saleChanges only at the count
Cost of goods soldRecorded with each saleWorked out once, after the count
Stock on hand todayOn screenUnknown until you count
ShrinkageShown as its own lineHidden in the cost of goods sold
Reorder pointsPossibleNot possible
WorkEvery document must be enteredOnly 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.

Worked example: one month in a gift shop

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 costPeriodicPerpetual
Opening stock8,000.008,000.00
Purchases12,500.0012,500.00
Cost of the goods sold, from the sales—12,950.00
Closing stock in the records—7,550.00
Closing stock counted7,300.007,300.00
Shrinkage—250.00
Cost of goods sold in the accounts13,200.0013,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.

Why a perpetual record still needs counts

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.

Which one fits a small business?

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.

How to switch from periodic to perpetual

  1. Pick a quiet day and count everything.
  2. Enter the counted quantities and their cost as the opening stock.
  3. From that day, enter every receiving and every sale in the program, not on paper first.
  4. Start cycle counts in the first month, and fix the causes of the first differences.

Golden Inventory System 5 is perpetual

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.

Questions

Is a perpetual system the same as real-time inventory?

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.

Do I still need a year-end count with a perpetual system?

Usually yes, or a cycle count program that covers every item during the year. Ask your accountant which one your auditor accepts.

Can the cost method be FIFO or average in both systems?

Yes. The system decides when the stock is updated; the cost method decides at what price. See FIFO vs moving average cost.

Is the periodic system allowed for the accounts?

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.

What is shrinkage?

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.

A stock record that is always current

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.