How to Value Ecommerce Inventory: FIFO vs Weighted Average in Practice

Two sellers with identical sales and identical purchases can report different profits, and pay different taxes, purely because they value inventory differently. The method is not a formality.

The inventory valuation method you pick is not an accounting technicality you can wave off to your bookkeeper. It directly sets your cost of goods sold, which sets your gross margin, which sets your taxable profit. Two sellers who bought the same units at the same prices and sold the same quantity can post different net income for the year, legally, because one used FIFO and the other used weighted average. When your supplier costs are rising, that difference is not small.

Most ecommerce sellers default into a method without choosing it, usually whatever their software does automatically, and then discover at tax time that they cannot explain their own COGS. This walks through the two methods that actually matter for ecommerce, what each does to your numbers, and how to apply them when the same SKU sells across multiple channels.

Why valuation method changes your profit

Inventory sits on your balance sheet as an asset at cost. When a unit sells, its cost moves to COGS on the P&L. The question valuation answers is simple to state and consequential to get wrong: when you hold units bought at different prices, which cost do you assign to the unit that just sold?

Say you bought 500 units at $6 in Q1 and 500 units at $9 in Q3. You then sell 500 units. Under FIFO you relieve the $6 layer, booking $3,000 of COGS. Under weighted average you assign the blended cost of $7.50, booking $3,750. Same sale, $750 difference in COGS, $750 difference in gross profit, and a corresponding difference in tax. The units left on the shelf carry the opposite distortion.

FIFO: first in, first out

FIFO assumes the oldest units sell first. The cost of your earliest purchases flows to COGS, and your remaining inventory is valued at your most recent costs.

What FIFO does to your numbers when costs are rising: older, cheaper costs hit COGS, so COGS is lower, gross profit is higher, and ending inventory on the balance sheet is higher because it holds the newer, pricier units. Higher reported profit means higher tax in that period.

FIFO matches how most physical ecommerce inventory actually moves. You sell the older stock first to avoid expiry, obsolescence, and dead stock. It is also the method most aligned with how lenders and acquirers expect to see ecommerce books, because the inventory asset reflects current replacement cost.

ConnectBooks applies FIFO COGS per unit by default, which is the right fit for ecommerce. It tracks each cost layer and relieves the oldest one when a unit sells, on every channel.

Weighted average

Weighted average cost blends all units into one average cost, recalculated as new purchases arrive. Every unit sold carries the same blended cost regardless of when it was bought.

What weighted average does to your numbers: it smooths out cost swings. When supplier prices bounce around, weighted average dampens the volatility in your COGS and margin from period to period. It is simpler to maintain in some legacy systems because you track one cost per SKU rather than a queue of layers.

The downside is that the blend can mask reality. If your costs are climbing, weighted average understates the current replacement cost of your inventory asset and overstates it when costs are falling. It also makes per-batch profitability harder to see, because every unit looks the same on the books even when some cost far more to acquire.

FIFO vs weighted average side by side

Using the same example, 500 units at $6 then 500 units at $9, selling 500:

Neither method is "more profitable" in reality. Your actual cash and actual units are identical. The methods only change which period recognizes which cost. Over the full life of the inventory the totals converge. The difference is timing, and timing is what tax and decision-making run on.

Which should an ecommerce seller use

For most US ecommerce sellers, FIFO is the better default, for three reasons:

1. It matches physical flow. You ship oldest stock first, so the cost flow follows the goods flow.
2. It produces a clean inventory asset. Ending inventory reflects recent costs, which is what lenders, accountants, and acquirers expect.
3. It supports per-unit decision-making. When you can see the true layered cost of a SKU, you can price and reorder intelligently.

Weighted average earns its place when you carry truly fungible, high-volume goods where layer tracking is impractical and cost swings are small. Whichever you choose, the rule from the IRS and from sanity is consistency. Pick a method, apply it the same way every period, and do not switch to flatter a single year's numbers.

The multi-channel wrinkle

The harder problem is not the method, it is applying it across channels. The same SKU sells on Amazon, Shopify, and Walmart from FBA, a 3PL, and your warehouse. FIFO only works if there is one cost-layer queue per SKU that every channel draws from in order. Run separate queues per channel and you get inconsistent costs for identical units, which breaks both your COGS and your per-channel margin comparison.

ConnectBooks solves this with ConnectStock, its multi-location inventory feature. ConnectStock maintains one FIFO cost queue per SKU across FBA, 3PL, home warehouse, and in transit, relieves the correct layer when any channel sells, and posts the cost into per-channel P&L inside QuickBooks or Xero. ConnectStock is bundled with Platinum and available as an add-on on Gold and Diamond. The detail is covered further in multi-channel inventory accounting (/blog-posts/multi-channel-inventory-accounting).

Does FIFO or weighted average produce higher profit?

In a rising-cost environment, FIFO produces higher reported profit because it assigns older, cheaper costs to COGS. Weighted average blends costs and dampens the swing. Neither changes your actual cash; they change which period recognizes which cost.

Can I switch inventory valuation methods?

You can, but it is a deliberate accounting change with tax implications, not something to flip year to year to manage earnings. The IRS expects consistency. If you change methods, document the reason and apply it going forward consistently.

Which method does ConnectBooks use?

ConnectBooks applies FIFO COGS per unit by default, which matches how ecommerce inventory physically moves and produces a clean inventory asset. It tracks cost layers and relieves the oldest when a unit sells on any channel.

How does FIFO work when one SKU sells on several channels?

Correctly applied, there is one FIFO queue per SKU that all channels draw from in order. The oldest cost layer is relieved by whichever channel sells next. Separate per-channel queues would produce inconsistent costs for identical units.

Is LIFO an option for ecommerce?

LIFO, last in first out, is allowed under US tax rules but rarely used by ecommerce sellers. It runs against physical flow, is barred under IFRS, and complicates lending and exit conversations. FIFO and weighted average cover almost all real ecommerce cases.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo