Inventory Valuation for Retailers: FIFO vs Weighted Average, Explained Plainly

Inventory valuation is the method you use to put a dollar figure on the stock sitting in your stockroom and on the units you just sold. For most retailers the real choice is between two methods: FIFO (first-in, first-out) and weighted average cost. Pick one, apply it consistently, and it changes three numbers on your books: the value of inventory on your balance sheet, your cost of goods sold, and — because COGS drives gross margin — your taxable income for the year.

What does "inventory valuation" actually mean for a retail store?

Every unit you buy has a cost, and that cost often changes over time — your vendor raises prices, a container shipment costs more than the last one, a seasonal item gets cheaper toward year-end. When you sell a unit, you have to decide which cost moves from inventory to cost of goods sold. That decision is inventory valuation.

Inventory valuation is the accounting method used to assign a cost to unsold inventory and to the units already sold, so a business can report an accurate cost of goods sold and an accurate ending inventory value.

• Cost of goods sold on your income statement, which drives gross margin — see how margin actually breaks down by category
• The inventory line on your balance sheet, which affects how a lender or buyer sees the business
• Taxable income for the year, since a higher COGS means lower reported profit
• Insurance claims and loan applications that ask for a current inventory value
• Any write-down you take on damaged or unsellable stock

What's the difference between FIFO and weighted average cost?

FIFO (first-in, first-out) assumes the oldest units in stock are the ones sold first. Cost of goods sold reflects the older, usually cheaper, purchase costs, and what's left in inventory carries the most recent, usually higher, costs. This mirrors how most retailers actually move physical stock — you sell the older case before the new one.

Weighted average cost blends every unit currently in stock into one per-unit cost, recalculated each time you receive new inventory. Every sale after that pulls from the same blended cost, and so does the ending inventory value. There's no "oldest" or "newest" unit — just one average.

• FIFO — matches physical flow for most retailers, and in a rising-cost environment shows a lower COGS, higher gross margin, and a higher ending inventory value
• Weighted average — one blended cost per item, simpler to explain to staff, and it smooths out price swings instead of tracking which batch a unit came from
• Specific identification — tracks the exact cost of each individual unit; it only makes sense for unique, serialized items like jewelry or furniture, not commingled stock

How do FIFO and weighted average change your margin and your tax bill?

Say you sell a home-goods item and bought it in three batches as your vendor's price crept up:

• January: 100 units at $10.00 = $1,000
• February: 100 units at $12.00 = $1,200
• March: 100 units at $14.00 = $1,400
• Total: 300 units on hand, $3,600 total cost

In March you sell 150 units at $20.00 each, for $3,000 in revenue. Here's what each method does with that sale.

FIFO: the first 100 units sold cost $10.00, and the next 50 cost $12.00. COGS = (100 × $10.00) + (50 × $12.00) = $1,600. Gross margin = $3,000 − $1,600 = $1,400, or 46.7%. The 150 units left in inventory carry the newer costs: (50 × $12.00) + (100 × $14.00) = $2,000 on the balance sheet.

Weighted average: the blended cost across all 300 units is $3,600 ÷ 300 = $12.00 per unit. COGS = 150 × $12.00 = $1,800. Gross margin = $3,000 − $1,800 = $1,200, or 40%. Ending inventory = 150 × $12.00 = $1,800.

Same sale, same revenue, two different profit numbers. FIFO reported $200 more gross profit on this batch and a $200 higher inventory value — which, at scale across a full year, means a higher taxable income under FIFO whenever your costs are rising, and a lower one whenever they're falling. Weighted average smooths both directions out. Neither number is wrong; they're just two different, both-acceptable ways of splitting the same $3,600.

Which method should a small or multi-location retailer use?

Most independent retailers use FIFO, mainly because it matches how stock physically moves off the shelf and it's the default most inventory systems calculate against. Weighted average tends to make more sense when units are genuinely commingled — bulk bins, liquids, or fast-moving items where tracking which specific receiving batch a unit came from isn't realistic.

Multi-location adds a wrinkle: if two stores pay different landed costs for the same item (different freight, different vendor terms), you need to decide whether you're valuing inventory per location or blended across the business. A shared, per-location inventory ledger makes this easier because the cost and quantity are already split by store rather than lumped into one warehouse figure — you can hand your accountant location-level numbers instead of one blurred total.

Whichever method you land on, treat it as a one-time decision, not a lever. Tax authorities generally expect a business to apply the same costing method consistently from year to year, so this is a conversation to have with your accountant once, up front — not something to switch back and forth on to flatter a given quarter's numbers.

What about LIFO and specific identification?

LIFO (last-in, first-out) assumes the newest units are sold first, so COGS reflects the most recent, often higher, costs. It shows up more in manufacturing and distribution than in small retail, and it adds recordkeeping overhead that rarely pays off for a shop selling off the floor. Most independent retailers can ignore it.

Specific identification tracks the literal cost of each individual unit rather than pooling costs together. It's the right call for big-ticket, serialized inventory — a repair shop tracking jewelry by serial number or a store selling furniture with special orders and deposits, where every unit really does have its own distinct cost and story. For a shop selling dozens of the same SKU, it's not practical.

What should an inventory valuation report include for your accountant?

At period-end, your accountant needs a clean list, not a guess. A usable inventory valuation report should show, as of a specific date:

• Item and SKU
• On-hand quantity, by location if you run more than one store
• Unit cost, based on whichever method you've chosen
• Extended value (quantity × unit cost) per item
• A total across all locations, and a subtotal per location if requested

This is also the number that reconciles against cost of goods sold on your income statement — if ending inventory value doesn't tie out, COGS is wrong somewhere, usually from a receiving cost that was never entered or a write-off that was never recorded. It's worth reading how POS systems that claim built-in accounting actually handle this step before assuming a tool does it automatically.

How does Retailer OS track inventory cost so you can hand this to your accountant?

Retailer OS keeps a per-item, per-location inventory ledger, and cost is captured as part of that ledger, not tracked separately in a spreadsheet. When you receive a purchase order, the cost on that receipt is recorded against the item at that location; every sale, transfer, and adjustment after that writes its own row to the same movement ledger, so on-hand quantity and cost stay tied together instead of drifting apart.

That pairing — accurate on-hand quantity plus the cost it was received at, per item, per location — is the raw material your accountant needs to calculate ending inventory value under whichever method (FIFO or weighted average) your business uses. Retailer OS's reporting and dashboards surface that quantity and cost data so you're not reconstructing it from paper receiving logs at year-end.

One thing worth being clear on: Retailer OS does not run a general ledger, chart of accounts, or journal entries. It tracks vendor bills and customer receivables, and sends a daily sales journal per channel — plus received purchase orders as bills — to QuickBooks Online, where the actual valuation method and journal entries live. Retailer OS's job is keeping the underlying quantity-and-cost data honest so what reaches QuickBooks Online is accurate in the first place.