Every time you sell a unit, you have to decide what it cost you. That sounds trivial until you notice that identical units on the same shelf were bought at different prices: the spring shipment cost more than the winter one, or the exchange rate moved between orders. A costing method is the rule that answers the question consistently. FIFO, LIFO and weighted average are the three common rules, and none of them changes how much cash you spent. They change when that cost shows up as cost of goods sold and how much of it stays on the balance sheet as inventory, which is why the choice matters for margins, taxes and pricing decisions.
What is FIFO
FIFO is an inventory costing method: each sale is charged the cost of the oldest units. It is one of three common methods:
- FIFO (First In, First Out): each sale consumes the oldest remaining purchase layer first. Ending inventory is valued at the most recent costs.
- LIFO (Last In, First Out): each sale consumes the newest layer first. Ending inventory is valued at the oldest costs.
- Weighted average: every unit carries the average cost of all units on hand. A moving weighted average recalculates that average each time new stock arrives.
Example: FIFO vs LIFO
Say a store buys 100 units in January at $20 each and another 100 units in March at $26. In April it sells 150 units at $50 each, so revenue is $7,500.
| Method | Cost of goods sold | Gross profit | Ending inventory (50 units) |
|---|---|---|---|
| FIFO | 100 × $20 + 50 × $26 = $3,300 | $4,200 | 50 × $26 = $1,300 |
| LIFO | 100 × $26 + 50 × $20 = $3,600 | $3,900 | 50 × $20 = $1,000 |
| Weighted average | 150 × $23 = $3,450 | $4,050 | 50 × $23 = $1,150 |
What the table shows:
- Total cost is the same: $4,600 under all three methods.
- Only the split changes: between this period's cost of goods sold and the stock carried forward.
- With rising prices: FIFO reports the highest profit and inventory value; LIFO the lowest of both.
Inventory costing for an online store
The method feeds straight into your COGS and therefore every margin report:
- Underpricing: if you price off a margin calculated with old, cheap FIFO layers while your next shipment costs 30% more, you may be losing money without realizing it.
- Imported goods: each shipment carries its own freight, duty and exchange rate.
- Shifting unit cost: the per-unit landed cost can differ noticeably from one container to the next.
Common mistakes
- Assuming the method describes physical movement. FIFO accounting does not require you to ship the oldest box first, although for perishable or seasonal goods rotating stock that way is good practice anyway.
- Switching methods to flatter a quarter. Changing methods breaks comparability between periods, and tax authorities generally expect a consistent method.
- Treating LIFO as universally available. IFRS does not allow it; US GAAP does.
- Forgetting that averages hide price jumps. A weighted average smooths a sharp cost increase over many units, so margins on new stock can look better than they are.
FIFO in StoreChart
- Method per product: a fixed cost you enter, a moving weighted average, or FIFO. There is no LIFO option.
- Default: new products start on the fixed method. A product with no cost entered switches to weighted average automatically when it first receives stock.
- Purchase layers: for FIFO products, StoreChart keeps them per warehouse.
- Cost on the order: an estimated cost is recorded when an order is created and replaced with the exact cost of the layers consumed when it ships.
- Order profit: calculated from that exact cost.
Frequently asked questions
FIFO or LIFO, which shows higher profit when prices rise?
FIFO typically shows higher reported profit when supplier costs are rising, because it records the older, cheaper inventory as the cost of the goods sold, while LIFO records the newer, more expensive inventory as sold first, pushing COGS up and profit down.
Does FIFO match how stock physically moves?
For most perishable or trend-sensitive goods, yes: shipping the oldest stock first (physical FIFO) both reduces spoilage/obsolescence risk and aligns with FIFO accounting, so the physical and financial models reinforce each other.
Is LIFO allowed everywhere?
No, LIFO is permitted under US GAAP but is not allowed under IFRS, which many countries outside the US follow, so an internationally operating business needs to confirm which method its jurisdiction's accounting standards actually permit.
