FIFO and real profit: what each sale really earned
FIFO (first in, first out) means each sale is costed at the price of the oldest units still in stock, so the profit on a sale uses what you actually paid for that unit. Add shipping, payment and packing costs, and you get the profit an order really made, not the margin the price list suggests.
Why prices differ, and how FIFO handles it
The price you pay for a product changes from delivery to delivery: the supplier raises prices, the exchange rate moves, you get a discount for a bigger order, freight costs more in one month than another. If you work out profit with today's catalogue price, every sale of older stock is costed wrongly.
FIFO assumes that the units that came in first go out first. Each sale takes its cost from the oldest delivery that still has units left. When that delivery runs out, the next sale takes its cost from the next one.
It matches how most warehouses try to work physically anyway: older stock is sold before newer stock, especially with products that age or expire.
A small worked example
Example with made-up numbers. You receive two deliveries of the same product:
- Delivery 1: 10 units at 20 each.
- Delivery 2: 10 units at 26 each.
- You then sell 15 units at 40 each, so 600 in sales.
- FIFO cost: 10 units from delivery 1 at 20 (200), then 5 from delivery 2 at 26 (130), so 330.
- Gross profit: 600 − 330 = 270.
- The 5 units left are valued at 26 each, because they came from delivery 2.
Compared with the latest price
If you had costed all 15 units at the latest price of 26, the cost would be 390 and the profit 210. If you had used the old price of 20 throughout, the profit would look like 300. Neither is what really happened. Over hundreds of products and months of price changes, the gap between a guessed margin and the real one adds up.
Costs beyond the purchase price
Purchase cost is only part of it. An order also carries its own costs, and they often decide whether a small order made money at all:
- Shipping: what the courier charges you, which may differ from what the customer paid.
- Payment: card fees, cash on delivery charges and marketplace commissions.
- Packing: boxes, filling and labels.
Continuing the example
Take one order from the example above: a single unit sold at 40, costed at 20 under FIFO. Say the courier charges you 6, the payment costs 2 and the box and filling cost 1. The order earned 40 − 20 − 6 − 2 − 1 = 11, not the 20 the price list suggests.
Now take a unit from the second delivery, costed at 26, sold on a channel with a higher commission. The same order might earn almost nothing. This is how a product can sell well and still not pay for itself, and why profit is worth looking at per product, per order and per channel.
What you need to get it right
Profit is only as accurate as the costs behind it. Leave one out and the figure looks better than the truth. Three things have to be in place:
- Deliveries booked in with the price you actually paid, at the time they arrive.
- Your real shipping, payment and packing costs entered, not estimates from a year ago.
- Regular stock counts, because FIFO can only cost the units the system knows about.