Inventory Accounting for eCommerce Operators

Inventory is money in a different form, and inventory accounting is how you keep that money honest on your books. For an eCommerce operator, it is not an abstract finance exercise. It decides your reported profit, your tax bill, and whether the number on your balance sheet matches what is actually sitting on the shelf.

This guide covers the parts operators actually have to reason about: the four costing methods, how they roll into cost of goods sold, how inventory is valued as an asset, how you reconcile the books to the shelf, and how landed cost quietly changes every one of those numbers. A short set of answers to the most common accounting-for-inventory questions is at the end.

One boundary up front, because it is the honest one. SkuNexus is inventory, order, and warehouse software. We keep the quantities, movements, and costs accurate so your financials start from real data. We are not accountants, and this is not tax advice. Which valuation method to elect, and how it affects your tax position, is a decision to make with your own accountant. What follows is the operator's half of that conversation.

Where the numbers come from: your inventory system and your accounting system

In most mid-market eCommerce back offices, two systems are in play. One holds the money view of the business. The other holds the goods view. Getting them to agree is most of what inventory accounting is in practice.

Across the sales conversations behind our mid-market WMS buying benchmark, QuickBooks showed up constantly as that money view. It appears in 26 of 76 conversations (34 percent), almost always as the accounting system of record that any new platform has to integrate with, and in several cases as the only inventory tool the business currently has. As one merchant put it about QuickBooks for inventory, "it's not very good." That is the tension this whole topic lives inside: the accounting system is the system of record, but it was never built to run a warehouse.

The practical takeaway is that inventory accounting works when the operational system feeds accurate quantities and costs into the accounting system, and both agree on the valuation method. When operators reach the point where QuickBooks stops keeping up with their inventory, the fix is not to abandon the accounting system. It is to put a real inventory system underneath it so the books are fed clean numbers instead of guesses.

The four inventory costing methods

Costing is the process of assigning a cost to each unit you hold and each unit you sell. Because you rarely buy every unit at the same price, the method you choose changes the reported cost of what you sold and the value of what remains. There are four methods operators encounter.

FIFO (first in, first out)

FIFO assumes the earliest units purchased are the first ones sold. It aligns reported cost with the natural flow of goods out of a business, so it usually gives the most realistic picture of current inventory value. A worked example makes it concrete.

A company buys 1,000 units at $6 each, later buys 1,000 more at $8 each, then sells 600 units. Under FIFO, the cost of goods sold for those 600 units is $6 each, because the oldest units are sold first. That leaves 1,400 units in inventory: 400 valued at $6 and 1,000 valued at $8. Sell another 600 and the cost of goods sold is 400 units at $6 plus 200 units at $8, leaving 800 units valued at $8 each.

One point that trips people up: the costing method you elect on paper does not have to match how you physically move stock. A business should still sell its oldest physical goods first to avoid obsolescence, but it needs to be able to explain why it chose a given valuation method regardless of the physical flow.

LIFO (last in, first out)

LIFO is the mirror image: the most recently purchased units are treated as sold first. In an inflationary environment where newer stock costs more, LIFO raises reported cost of goods sold, which lowers reported profit and can reduce taxable income. Most online retailers avoid it, because there is rarely a real justification for selling recent stock ahead of older inventory, and it complicates every downstream number.

Weighted average

Weighted average does not track individual purchase lots. It divides the total cost of inventory by the total number of units to produce one blended cost per unit. It is the simplest method to operate and fits high-volume merchants with fast, uniform turnover where lot-level precision is not worth the overhead.

Specific identification

Specific identification assigns a cost to each individual item rather than grouping them. It suits high-value goods such as automobiles, collectibles, and luxury items, and any operation that tracks each unit by serial number or RFID and wants item-level financial data. It is precise and heavy, so it only makes sense when unit value or traceability justifies the tracking.

Cost of goods sold: why the method you pick shows up on your tax return

Cost of goods sold, or COGS, is what the products you sold in a period cost you. It is the direct link between the costing method above and your financial statements. Businesses deduct COGS against revenue, so the accuracy of your unit costs directly affects reported profit and the tax that follows.

This is exactly why the choice of FIFO, LIFO, weighted average, or specific identification is not cosmetic. Run the same 600-unit sale through FIFO versus weighted average and you get different COGS, different gross margin, and a different taxable figure, from identical physical activity. The operator's job is to keep the underlying cost data clean and consistent. Which method produces the best tax outcome is your accountant's call, not the software's.

Inventory valuation on the balance sheet

Inventory is an asset. When you buy products to resell, those goods are listed as assets on the balance sheet because they represent invested capital you expect to convert back into cash. In most cases inventory is also a current asset, meaning it is expected to convert to cash within a year, though liquidity, seasonality, price point, and sector all affect whether a given item really clears in that window.

The asset framing has a catch that operators feel directly. Holding inventory is not free. Holding cost includes warehousing (rent, utilities, labor), the opportunity cost of capital tied up in stock, and losses from depreciation, perishability, shrinkage, and insurance. Carry too much for too long and a literal asset behaves like a liability, because the cost of holding it eventually outweighs its value. Accurate valuation is what surfaces that problem early, which is why it depends on a real-time inventory management platform rather than a monthly guess.

Reconciling the books to the shelf: perpetual, periodic, and cycle counts

A valuation is only as good as the count behind it. There are two ways to keep that count. A periodic system measures inventory and cost of goods sold through an occasional full physical count. A perpetual system updates balances continuously as goods are received and sold. Large operations cannot realistically count everything by hand often enough to run periodic well, and very small ones may not need the machinery of a perpetual system, so most mid-market operators land in between.

The practical bridge is cycle counting: reconciling a small subset of SKUs on a rolling schedule so the perpetual record and the physical shelf never drift far apart. When you sell multi-channel inventory across locations, this reconciliation is where accounting accuracy is won or lost, because a discrepancy in one warehouse quietly corrupts the valuation for the whole business. Systematic cycle counts keep the number on the balance sheet tied to reality.

Landed cost: the number that quietly breaks your margins

The cost of a unit is not just what you paid the supplier. Landed cost adds freight, duties, customs, insurance, and handling to arrive at the true cost of getting that unit onto your shelf ready to sell. Operators who cost inventory at the supplier invoice alone consistently overstate margin, because the real cost of goods sold is higher than the purchase price suggests.

Landed cost flows straight into everything above. It changes the per-unit figure in your costing method, which changes COGS, which changes reported profit and inventory valuation. This is a common failure point for merchants who outgrow spreadsheets, and it is one of the clearest signals that it is time to consider graduating from spreadsheet-based inventory into a system that captures landed cost at receipt so every downstream number is correct by construction.

Where SkuNexus ends and your accountant begins

To be plain about the boundary: SkuNexus keeps your quantities, movements, costs, and landed costs accurate in real time, and feeds them cleanly into your accounting system of record so your financials start from truth instead of estimates. That is the operational half.

The other half belongs to your accountant. Which valuation method to elect, how it interacts with your tax position, and how to present inventory on your statements are decisions for a qualified professional who knows your business and your jurisdiction. Any inventory or warehouse vendor who tells you otherwise is overreaching. Good software makes the accounting easier and the data trustworthy. It does not replace the person signing off on your books.

Inventory accounting questions and answers

Is inventory an asset?
Yes. Products you have bought to resell are listed as assets on the balance sheet because they represent invested capital you expect to convert back into cash. Hold too much for too long, though, and the cost of carrying it can outweigh its value.

Is inventory a current asset?
Usually. Current assets are those expected to convert to cash within a year, so it depends on how liquid the specific inventory is. Seasonality, price point, and sector all affect whether a given item will really clear within twelve months.

What is the difference between periodic and perpetual inventory systems?
A periodic system measures inventory and cost of goods sold through an occasional physical count. A perpetual system tracks balances continuously and updates automatically as goods are received or sold. Most mid-market operators run perpetual with rolling cycle counts to reconcile.

Which inventory costing method should we use?
There is no blanket answer. FIFO fits most eCommerce operators and matches the natural flow of goods. Weighted average suits high-volume, uniform turnover. Specific identification fits high-value or serialized items. LIFO is rarely justified for online retail. The final election, and its tax effect, is a decision for your accountant.

Does my costing method have to match how I physically sell stock?
No. The valuation method you elect on paper does not have to mirror physical flow. You should still sell your oldest physical stock first to avoid obsolescence, but you need to be able to explain why you chose a given method regardless of the physical movement.

What is landed cost, and why does it matter for accounting?
Landed cost is the true cost of getting a unit onto your shelf: supplier price plus freight, duties, customs, insurance, and handling. It matters because it raises the real per-unit cost, which flows into cost of goods sold and inventory valuation. Ignoring it overstates your margins.