Perpetual Inventory System: How It Works Across Every Sales Channel

SECTION 01Perpetual inventory in one paragraph

In brief: A perpetual inventory system updates stock records continuously, every time something is received, sold, returned, transferred or adjusted, so the system always shows what you hold. Cost of goods sold is recorded at each sale. It replaces the periodic approach, where stock is known only after a physical count at the end of a period.

Under perpetual inventory, the record moves with the stock. A unit scanned in at the dock is added the moment it is received. A unit sold is deducted when the order is confirmed. A return is added back when it is checked and restocked. At any moment, the system can tell you how many units of each product you have and where they are, without anyone counting.

That constant record is what modern eCommerce runs on. Marketplaces show your stock to shoppers, reorder points fire automatically, and orders route to the warehouse that has the unit. None of that works if stock is only known once a month.

SECTION 02How it works, sale by sale

In brief: Every stock movement creates a transaction that updates the record immediately: receipts add, sales and transfers out deduct, good returns add back and count differences adjust. In accounting, each sale also moves the item's cost from inventory to cost of goods sold, so profit is known per sale, not only at period end.

Each movement in the warehouse becomes an entry in the system:

• Receiving: goods scanned in against the purchase order increase stock on hand.
• Orders: a confirmed order reserves stock, so it cannot be sold twice; shipping it deducts it.
• Transfers: stock moving between warehouses, or to a marketplace or dark store, leaves one location and arrives at another.
• Returns: units come back into stock only after they are checked; damaged units go to a separate, unsellable bucket.
• Adjustments: when a count finds a difference, the record is corrected and the reason is logged.

One accounting example. Say you sell an item for $50 that cost you $30. Under perpetual inventory, the sale is recorded twice at the moment it happens: revenue (cash or receivable up $50, sales up $50) and cost (cost of goods sold up $30, inventory down $30). Under periodic inventory, only the revenue is recorded at the sale; cost of goods sold is worked out at the end of the period with the formula below.

Periodic cost of goods sold = beginning inventory + purchases − ending inventory (from a physical count)

SECTION 03Perpetual vs periodic inventory

In brief: Perpetual inventory updates stock with every transaction and records cost of goods sold at each sale. Periodic inventory updates stock only after a physical count and calculates cost of goods sold at period end. Perpetual needs scanning and software but gives real-time accuracy; periodic is simpler and cheaper but leaves you blind between counts.

For an eCommerce brand, the choice is rarely close. Marketplaces need a live stock figure to list against, and a periodic system cannot supply one. The real question is not which system to use but how to keep a perpetual one accurate.

SECTION 04Pros and limits

In brief: Perpetual inventory gives live stock by location, automatic reorder triggers, per-sale profit and early sight of shrinkage. Its limits: it costs more to run, and it only reflects what is recorded, so unscanned movements, delayed syncs and misplaced stock make it drift. Regular cycle counts keep the record honest.

Advantages

• Live stock by product and location, which marketplaces, quick commerce and your own site can list against.
• Automatic reorders, because the system knows when a SKU crosses its reorder point.
• Profit per sale, with cost of goods sold recorded as each order ships.
• Shrinkage you can find: when a count differs from the record, the gap points to a specific period and location. Our guide to shrinkage covers what to do next.
• No shutdown counts, because daily cycle counts replace the annual stocktake.

Limits

• It records what it is told. A unit moved without a scan, a return restocked without a check or a damaged item left in a sellable bin all put the record out of step with the shelf.
• It costs more than a count-based system: software, scanners and training.
• It can drift quietly. Without verification, small errors compound until the record cannot be trusted.

SECTION 05What breaks perpetual inventory in multichannel selling

In brief: In multichannel selling, perpetual inventory breaks when channels see stock at different times. Slow syncs cause oversells, missing reservations let two channels sell the same unit, returns restocked late hide sellable stock, marketplace-held stock sits outside the main record and unscanned movements make the record drift from the shelf.

One warehouse and one website make perpetual inventory easy. Each extra channel and location adds a way for the record and reality to drift apart:

• Sync latency. If a marketplace learns about a sale on your website ten minutes late, it can sell the last unit again. The longer the delay, the more oversells and cancellations, and the more marketplace penalties.
• No reservations. A confirmed order must reserve its unit immediately, so on hand, reserved and available are tracked separately. Without that split, two channels can promise the same unit.
• Returns restock timing. A return in transit, or sitting unchecked at the dock, is neither sellable nor gone. Systems that add it back too early oversell; too late, and they hide stock you could sell.
• Separate stock pools. Stock sent to a marketplace's own fulfillment centers or to quick-commerce dark stores leaves your warehouse but is still yours. It has to stay in the record as its own location.
• Bundles and kits. A gift set built from three SKUs must reduce all three components when it sells, or the components look available when they are not.
• Unscanned movements. Picking the wrong bin, moving stock without a transfer or fixing a count without logging a reason all create drift no software can see.

SECTION 06Making it work: scanning, sync and cycle counts

In brief: Three habits keep perpetual inventory accurate across channels. Scan every movement so the record matches the shelf, keep one stock pool that syncs every channel within about a minute and reserves stock at order confirmation, and verify the record with daily cycle counts so small errors are caught before they compound.

• Scan every movement. Receiving, putaway, picking, packing, transfers and returns all happen against a barcode scan. In EasyEcom's warehouse management, goods are scanned in against the purchase order with batch and expiry captured at the door, units are graded good or bad before putaway, and FIFO and FEFO are enforced automatically.
• Keep one stock pool, synced fast. Every channel should sell from the same record and see changes within about a minute. Multichannel order management in EasyOMS keeps one stock pool across warehouses, syncs it to every channel in 60 seconds and checks live availability across every warehouse before an order is routed, so no unit is promised twice.
• Verify with cycle counts. Perpetual inventory does not remove counting; it replaces the yearly shutdown with small daily counts. Cycle counting covers how to schedule them.
• Log every adjustment with a reason, so patterns in shrinkage or damage are visible.

Done consistently, the record and the shelf stay in step. Relaxo reached 100% inventory accuracy and more than 99% bin-level accuracy on EasyEcom, as its customer story describes.

SECTION 07A worked example: one SKU, three channels, one day

In brief: Follow one SKU through a day of orders on a webstore, a marketplace and quick commerce. Each event changes on hand, reserved or available stock, and every channel sees the new available figure within the sync interval. A cycle count at day's end catches a one-unit difference and the record is corrected.

A linen shirt, size M, sells on the brand's webstore, a marketplace and a quick-commerce app, all from one warehouse. The day starts with 100 units on hand.

Three things make this work. Reservations stop the 20 units promised to the dark store from being sold online in the afternoon. The return only becomes sellable after it is graded, not when the courier drops it off. And the end-of-day count catches the one missing unit while it is still a one-unit problem. The 20 units at the dark store remain the brand's stock, tracked as their own location.

For definitions of on hand, reserved, available and other terms used here, see our inventory glossary, and for the wider picture, our guide to eCommerce inventory management.

Selling on more channels than your stock record can keep up with? Book a demo and we will show you one stock pool running across your own channels and warehouses.