Ask most e-commerce founders how they know their inventory value on any given day, and you get a shrug. They know what they counted last quarter, and they know roughly what came in and went out since then. That gap between “roughly” and “exactly” is the reason the perpetual inventory method exists, and it is also a big part of why so many e-commerce financial forecasts drift away from reality within a few months.
This guide covers what the perpetual inventory method actually is, the formula behind it, how FIFO and LIFO change the numbers it produces, and why the costing method you use matters far more to your financial forecasting than most accounting explainers admit.
What Is the Perpetual Inventory Method
The perpetual inventory method is an inventory accounting system that updates inventory quantities and recognizes the related cost of goods sold as each transaction happens, based on the costing method a business has adopted. Every sale, purchase, and return is recorded in the system in close to real time, rather than being reconciled once at the end of a period.
This sits in contrast to the periodic inventory method, where a business only knows its inventory value after a physical count, and cost of goods sold is calculated as a single figure at period end rather than tracked transaction by transaction. Periodic accounting worked fine for a small shop with a few hundred SKUs and a cash register. It becomes impractical fast for an e-commerce business selling across a website, Amazon, and a wholesale channel, where a single day can generate thousands of transactions that each need to hit inventory at the correct cost.
Most modern e-commerce platforms, and most inventory or order management tools that connect to Shopify, Amazon, or a warehouse management system, are built around perpetual inventory logic by default. Every sale decrements stock. Every purchase order receipt increases it. Inventory accounting under US GAAP is governed broadly by ASC 330, and while the standard does not mandate a specific system, perpetual tracking is what makes it realistic to apply a costing method consistently at the volume most e-commerce businesses operate at.
Related reading: for the accounting logic that governs which costing rules a system like this can apply, see our guide to FIFO vs LIFO for e-commerce businesses.
Perpetual vs Periodic Inventory: A Quick Comparison
| Factor | Perpetual Inventory | Periodic Inventory |
| Update frequency | Continuous, updated with every transaction | Updated only at the end of a set period |
| COGS recognition | Recognized transaction by transaction as sales occur | Calculated once, as a plug figure, at period end |
| Inventory visibility | Real-time inventory value at any point | Unknown between physical counts |
| Dependence on physical counts | Physical counts confirm and adjust the running balance. | Physical counts are the only source of the balance. |
| Ecommerce suitability | Built for high transaction volume and multichannel selling | Workable for very low-volume, single-channel sellers |
The Perpetual Inventory Method Formula
The foundational inventory equation is this:
Beginning Inventory + Purchases − Cost of Goods Sold = Ending Inventory
It is worth being precise about what this formula is and is not. It is a reconciliation equation, a way of confirming that the inventory value on the books ties out logically over a period. It is not a literal description of how a perpetual system processes each individual transaction. In practice, a perpetual system recognizes COGS at the moment of each sale, using the unit cost assigned under the company’s selected costing method, and the running inventory balance simply reflects the cumulative result of those entries. The formula above is the summary check, not the mechanism.
That per-unit cost is where the accounting gets interesting, because it depends on two things: the landed cost recorded when the inventory was received and the cost flow assumption, FIFO or LIFO, applied when a unit is sold.
Landed cost typically includes the product’s purchase price plus the freight, duty, and other directly attributable costs a company’s accounting policy treats as part of getting that inventory ready for sale. Not every cost incurred around a shipment is automatically capitalized this way. Which specific charges get included is a policy decision made with an accountant, applied consistently, rather than a fixed universal rule.
FIFO vs LIFO: What They Actually Assume
FIFO and LIFO are cost flow assumptions, not descriptions of how physical inventory moves off a shelf. This distinction trips up a lot of founders. A business can use FIFO for accounting purposes while its warehouse team ships whatever unit is closest to the door. The costing method determines which recorded cost gets matched to a sale in the books. It does not dictate, and is not required to match, the literal physical sequence in which units leave the warehouse.
FIFO Perpetual Inventory Method
FIFO stands for first in, first out. Under the FIFO perpetual inventory method, the accounting system assumes the oldest costs on the books are the ones matched to the next sale, and it assigns that cost the moment the sale is recorded, not at period end.
Here is where it matters practically. Say a business bought one hundred units at eight dollars each in March, then another hundred at ten dollars each in June after a supplier price increase. Under FIFO perpetual, the next hundred units sold after June are still costed at eight dollars, because the March cost layer is the one assumed to be consumed first. Only once that layer is exhausted does the system begin drawing from the ten-dollar layer.
LIFO Perpetual Inventory Method
LIFO stands for last in, first out, and the assumption runs in the opposite direction. Under the LIFO perpetual inventory method, the most recently recorded cost layer is matched to each sale as it happens.
Using the same example, once the ten-dollar June layer is on the books, any sale processed under LIFO perpetual draws from that layer first, regardless of which physical units actually ship. During a period of rising supplier costs, this produces a higher recognized COGS and lower reported gross profit, because the newer, more expensive cost layer is hitting the income statement sooner.
LIFO is uncommon in e-commerce, for reasons that go beyond preference. It is permitted under US GAAP but not under IFRS, since IAS 2 explicitly prohibits its use, which matters for any e-commerce business reporting internationally or considering a future listing outside the US. In the US, LIFO also carries a conformity requirement: a company that uses LIFO for tax reporting generally must also use it for financial statement reporting. That combination, a real reduction in taxable income during inflationary periods, alongside a mandatory hit to reported book profit, is why the decision to adopt LIFO is made deliberately with a tax and accounting advisor, weighing cash tax savings against how the numbers will read to lenders or investors, rather than treated as a simple preference.
Average Cost Method
The average cost method assigns inventory and COGS based on the average cost of the units available for sale, rather than matching each sale to a specific cost layer. The basic calculation is total cost of inventory available divided by the total number of units available. When purchase costs change frequently, this approach smooths out the effect of individual price increases or decreases instead of allowing one older or newer cost layer to determine COGS.
For example, if an e-commerce business has 100 units costing $8 each and receives another 100 units at $10 each, the average cost is $9 per unit. If it sells 50 units, those units would be recorded at an average cost of $9 each, producing $450 of COGS.
For e-commerce businesses, average costing can make financial reporting easier to interpret because short-term supplier price changes have less immediate impact on reported gross margin. However, the exact way average cost is calculated depends on the accounting system and whether the business uses a moving-average or periodic-average approach, so the method should be applied consistently.
FIFO vs LIFO at a Glance
| Factor | FIFO Perpetual | LIFO Perpetual |
| Cost assigned to a sale | Oldest recorded cost layer | Most recently recorded cost layer |
| Effect on COGS, rising costs | Lower COGS | Higher COGS |
| Effect on reported profit | Higher reported gross profit | Lower reported gross profit |
| Effect on ending inventory | Ending inventory reflects newer, higher costs. | Ending inventory reflects older, lower costs |
| US GAAP vs IFRS | Permitted under both | Permitted under US GAAP, prohibited under IFRS (IAS 2) |
| Typical e-commerce relevance | The default for most e-commerce and retail businesses | Rare, generally a deliberate tax and reporting decision |
Why the Costing Method Actually Matters for Ecommerce Financial Forecasting
This is the part most inventory explainers skip, and it is the part that connects directly back to your budget forecast.
Cost of goods sold is one of the largest single drivers in any e-commerce financial model. The chain runs in a straight line: inventory cost layers determine COGS, COGS determines gross margin, gross margin flows into the P&L, and the P&L is the base your financial forecast is built on. Every downstream decision—how much cash you can commit to inventory reorders, how much room exists in the marketing budget, how comfortable your working capital position really is—traces back to that first link.
If you are forecasting gross margin using a flat, historical COGS percentage instead of the actual costing method your books run on, your forecast and your actual P&L will diverge the moment supplier costs shift, and supplier costs virtually always shift eventually. A business running FIFO through a period of rising costs will show margin holding up longer than a comparable LIFO business would, purely because of the accounting method, not because the underlying operation is performing any differently. If your forecast model does not account for which costing method is generating your actuals, you end up comparing a forecast built on one logic against results built on another, and any variance analysis you run on top of that becomes close to meaningless.
There is a second, more operational reason this matters. Because a perpetual system updates continuously, it gives your forecast a current, reconciled starting inventory value every time you rebuild the model, instead of a stale figure from the last physical count. Your cash forecast, which has to account for how much capital is tied up in unsold stock at any given point, is only as reliable as the inventory data feeding it. A periodic system leaves you forecasting blind between counts. A perpetual system gives you a real number to build from.
A Practical Example
Picture a small apparel brand carrying one SKU. It starts the month with two hundred units at twelve dollars each, landed cost. Mid-month, it receives another two hundred units at fourteen dollars each, after a freight surcharge from its forwarder. It sells three hundred units that month.
Under FIFO perpetual, the first two hundred units sold draw from the twelve dollar layer, and the remaining one hundred draw from the fourteen dollar layer, for a total COGS of $2,800. Under LIFO perpetual, the same three hundred units would draw first from the fourteen dollar layer, then the twelve dollar layer, for a total COGS of $3,200.
That $400 difference, on a single SKU in a single month, changes gross margin on those sales even though nothing about the business, its pricing, or its actual unit economics changed. Scale that gap across a full catalog and a full quarter, and it becomes exactly the kind of variance that quietly throws off a forecast built without the costing method in mind, and exactly the kind of number a founder needs explained in plain terms before it shows up as an unexplained miss in a board deck.
Common Mistakes to Avoid
Businesses often switch fulfillment or inventory software without checking which costing method the new system defaults to, then wonder why margin shifts with no change in pricing or supplier costs. Others build a financial forecast using a flat, averaged COGS percentage pulled from last year, without accounting for the fact that their perpetual system is actively applying FIFO or LIFO logic layer by layer, which behaves very differently once supplier prices move. It is also common to see landed cost applied inconsistently between purchase orders, which quietly distorts every downstream cost layer even before FIFO or LIFO enters the picture. For a closer look at keeping that input clean, see our guide to inventory reconciliation for e-commerce.
The fix is straightforward, if not always easy to implement. Know which costing method your inventory system runs on, keep landed cost recording consistent at the point of purchase, and build your forecast’s COGS assumption around that specific method rather than a rough historical average. For the broader process this fits into, our ecommerce financial forecasting guide walks through how COGS assumptions like this one connect to revenue, cash timing, and scenario planning across a full forecast model.
Accurate inventory costing will not, on its own, fix a shaky forecast. But a forecast built on top of inconsistent COGS logic is unreliable before a single revenue assumption is even added, which is exactly the kind of foundational detail our team at SmallBizController works through with ecommerce clients when we build out or clean up a forecasting model.
