Perpetual vs Periodic Inventory: Which System to Use and How COGS Differs
Practice · 8 min read
Nothing you paste is stored.
The scan could not run.
A live preview of Storekeeper's forecasting engine on fictional sample dataon the rows you pasted. The full product connects to your POS and store and runs this continuously.
A perpetual inventory system updates stock levels and cost of goods sold continuously, after every sale and receipt, usually through software and barcode scans. A periodic system updates them only at set intervals, by physically counting stock at the end of a month, quarter or year. Perpetual gives you a real-time count; periodic gives you a snapshot in time and calculates COGS by subtraction. For most growing product businesses, perpetual is the right default, and periodic survives mainly in very small or very simple operations.
The choice is not just accounting trivia. It decides whether you can trust your stock numbers on any given Tuesday, whether you can set automatic reorder points, and how much manual counting your team does.
What is a perpetual inventory system?
A perpetual inventory system records every stock movement as it happens. When you sell a unit, software decrements the quantity and books the cost of goods sold in the same moment; when you receive a shipment, it increments. The result is an inventory balance that is always current, at least in the system, which is what makes real-time reorder alerts and multichannel stock sync possible. It relies on accurate data capture, typically barcode scanning, to stay honest.
What is a periodic inventory system?
A periodic inventory system does not track stock in real time. Instead, it starts with a known opening inventory, records purchases through the period, and then determines ending inventory by a physical count. Cost of goods sold is backed out with the formula: beginning inventory + purchases − ending inventory. Between counts, you genuinely do not know your exact stock level from the books, only your best estimate.
Perpetual vs periodic: the difference at a glance
| Factor | Perpetual | Periodic |
|---|---|---|
| Stock count | Updated continuously | Updated at period end |
| COGS | Recorded per transaction | Calculated by subtraction |
| Real-time reorder points | Yes | No |
| Setup cost | Software, barcodes, process | Low; mostly manual |
| Best for | Most growing product businesses | Very small or low-SKU operations |
| Main weakness | Only as good as the data captured | Blind between counts |
How do you calculate COGS in each system?
In a periodic system, COGS is a single end-of-period calculation:
COGS = beginning inventory + purchases − ending inventory
In a perpetual system, COGS accumulates transaction by transaction: each sale books the cost of the units sold as it happens, so the COGS figure is live all period. Both should land in the same place at year end if counts are accurate, but the perpetual version tells you the number in real time, while the periodic version makes you wait for the count. Either way, that COGS figure flows straight into your income statement and balance sheet, which is why an accurate count is an accounting issue, not just an operations one.
Which inventory system should you use?
Use a perpetual system if any of the following is true: you carry more than a few dozen SKUs, you sell across more than one channel, you need reorder alerts, or you cannot afford to be wrong about stock between counts. That covers almost every ecommerce and retail business past the hobby stage. Periodic still makes sense for a tiny operation with a handful of products, low order volume, and no appetite for software, where an occasional count is genuinely enough.
The honest catch: perpetual is only as accurate as the data you feed it. Miscounts at receiving, unrecorded shrinkage and unscanned sales all cause the system balance to drift from reality. That is why even perpetual-system operators still count, just smarter.
Do you still need to count with a perpetual system?
Yes, but not with a disruptive annual shutdown. Perpetual systems pair naturally with cycle counting: counting a small subset of SKUs on a rolling schedule so the system balance stays trustworthy without ever closing the warehouse. The gap you find between the system and the shelf is inventory shrinkage, and catching it early is one of the main reasons to run perpetual in the first place.
How does software fit in?
A perpetual system is effectively defined by software: you need something that records every movement, ties it to a barcode or SKU, and keeps the running balance. That is the baseline job of any inventory control software or inventory management system. The real difference between tools shows up one layer higher: a perpetual count tells you what you have right now, but only a forecasting layer turns that live balance into a decision about what to reorder and when. Recording stock perpetually is table stakes; deciding on it is the harder, more valuable job.
Running a perpetual system well means watching the live balance, the reorder points and the drift between system and shelf across every SKU at once. Our live stock scan shows the decision layer in miniature: paste your rows and it returns per-SKU verdicts on cover, safety stock and slow movers, so a real-time count turns into a real-time plan.
See this math run itself
The free stock scan computes cover, safety stock and verdicts per SKU on sample data or rows you paste. No signup.
Run the stock scanMore from the stockroom
- Working capital GMROI: Formula, Benchmarks and How to Improve It
- Practice ABC vs XYZ Analysis: The Difference and How to Combine Them
- Working capital How to Value Inventory for Taxes: Methods, Rules and COGS
- Practice Consignment Inventory: How It Works, Pros and Cons, and the Accounting
- Practice Par Level Inventory: What It Is and How to Set Par Levels
- Practice How to Reduce Supplier Lead Time (9 Practical Ways)
- Working capital What Is Landed Cost? Formula, Components and How to Calculate It
- Practice Just-in-Time Inventory (JIT): How It Works and When to Use It
- Practice Min/Max Inventory: How the System Works and How to Set Levels
- Lost sales How to Avoid Stockouts: 7 Ways to Stop Running Out of Stock
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Practice How to Do a Physical Inventory Count (Step by Step)
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How to Forecast Inventory Demand (Methods and a Practical Process)
- Metrics How to Calculate Inventory Turnover (Formula, Example, Days)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Metrics How to Calculate Inventory Value: FIFO, LIFO and Weighted Average
- Practice How to Reduce Inventory Without Causing Stockouts
- Metrics Inventory KPIs: The 7 Metrics That Actually Matter
- Metrics Days of Inventory on Hand (DIO): Formula, Benchmarks and How to Lower It
- Practice Inventory Optimization: Techniques to Cut Stock Without Stocking Out
- Working capital Inventory Shrinkage: Formula, Causes and How to Reduce It
- Working capital Inventory Carrying Cost: Formula, Percentage and How to Lower It
- Practice Cycle Counting: What It Is, Methods and How Often to Count
- Metrics ABC Analysis in Inventory Management: Formula, Classes and a Worked Example
- Metrics Inventory Turnover Ratio: Formula, Benchmarks and What Good Looks Like
- Formulas Economic Order Quantity (EOQ): The Formula and When to Trust It
- Practice Inventory Management in Excel: How to Build It, and When to Stop
- Formulas Safety Stock: What It Is and How to Calculate It
- Formulas Reorder Point Formula: How to Calculate When to Reorder
- Working capital Dead Stock: Why It Happens and How to Clear It
- Lost sales Stockouts: The True Cost of Running Out