FIFO COG Tracking in 2026: How Mid-Market Brands Stop Bleeding Margin to Stale Cost Numbers
Most ecommerce brands report margin against a Cost of Goods Sold number their bookkeeper typed in last quarter. Real costs moved. Reported margin doesn’t match P&L reality. Here’s why FIFO COG fixes that, and how SKU Compass calculates it nightly across your catalog.
Quick Answer
FIFO COG means calculating your Cost of Goods Sold from the actual prices on your most-recent purchase orders, working backward through the warehouse stock you currently have on hand. The COG number you’ve been reporting (typed into your bookkeeping tool last quarter) is almost certainly wrong by the time you read it — supplier prices moved, freight changed, currency shifted.
For a mid-market multi-channel brand at $5M-$50M ARR with 500-5,000 SKUs and quarterly buying cycles, the gap between “saved COG” and “FIFO COG” routinely runs 5-20% per SKU. That’s 5-20% of your reported margin not matching reality. Multiplied across catalog, that’s tens of thousands of dollars of misreported P&L every quarter.
SKU Compass calculates FIFO COG nightly across every SKU per brand, flags every SKU where the stale Current COG disagrees with the freshly-calculated FIFO COG, and exports the variance list as a CSV your bookkeeper can use to refresh the books in one batch.
What FIFO actually means (in plain English)
FIFO stands for “first in, first out.” It’s a costing method that assumes you sold the oldest inventory first.
Imagine you have 100 widgets in your warehouse. They came in across three POs:
- PO #001: 60 widgets at $4 each (oldest)
- PO #002: 30 widgets at $5 each
- PO #003: 10 widgets at $7 each (newest)
FIFO says: when you sell a widget, you sold the oldest one first. So if you’ve sold 30 widgets, FIFO assumes those 30 widgets came from PO #001 at $4 each — that’s your COGS for the period.
The 70 widgets you have remaining in inventory are: 30 at $4 (rest of PO #001) + 30 at $5 (PO #002) + 10 at $7 (PO #003). Your current per-unit inventory cost is the weighted average of those = ((30×$4) + (30×$5) + (10×$7)) ÷ 70 = $4.86 per widget.
That $4.86 is your FIFO COG — the per-unit cost based on actual recent purchase prices, not a number frozen in your books last quarter.
Why your saved COG is probably wrong
Supplier prices moved (and you didn’t update)
Your last PO came in at $5/unit. The one before that was $4.50. The book COG still says $4.20 from a quarter ago. Your reported margin per unit is overstated by $0.80 because the cost number stopped tracking reality.
This is the #1 reason mid-market brands have stale COG: the bookkeeping process for updating cost is manual, batched, and easy to skip. Especially when you’re sourcing 500+ SKUs from multiple suppliers.
Freight + tariff costs changed but unit cost didn’t capture it
The supplier invoice didn’t change but ocean freight went up 30%. Tariffs got renegotiated. Customs broker adjusted. Your landed cost moved but the unit cost in your books reflects only the supplier line.
FIFO COG calculated from the actual PO line totals (including freight/tariff/handling allocated proportionally) gives you the real landed cost — not the supplier-invoice-only number that misses 5-15% of true cost.
Currency shifted on international suppliers
Sourcing from China? Vietnam? Mexico? FX rates moved 3-8% over the last six months. Your USD-denominated landed cost moved with it. The book number didn’t.
For brands sourcing 60%+ of catalog overseas, this gap alone can run 3-5% of catalog margin in any direction.
Bookkeeper hasn’t updated the COG since last close
Honest reality. Most bookkeepers update COG quarterly during the close, not continuously. Between closes, the stored COG number is slightly stale by definition — and the gap compounds across hundreds of SKUs.
Worked example — what 12% COG drift costs a $10M brand
Mid-market brand, $10M annual revenue, 100 SKUs averaging 50% gross margin on book numbers ($5M reported gross profit). Average COG drift across catalog: 12% (not unusual for brands with quarterly book updates and overseas sourcing).
| Metric | Book number | FIFO reality |
|---|---|---|
| Average COG per unit | $10.00 | $11.20 (12% higher) |
| Average sell price | $20.00 | $20.00 |
| Reported gross margin | 50% | 44% |
| Annual reported gross profit | $5.0M | $4.4M |
| Margin overstatement | — | $600K/year |
That $600K isn’t lost money — the cash is real. But the brand is making strategy decisions on a 50% margin number that’s actually 44%: pricing, marketing spend allocation, channel-mix decisions, hiring plans. All of those get distorted by the 6-point gap.
Catch it earlier with nightly FIFO calculation, fix the books quarterly with proper data, and your decision-making input gets honest.
How SKU Compass calculates FIFO COG
Pulls every PO line for every SKU, by date
SKU Compass connects to your purchase order data (manual entry, integration, or import). Every PO line — supplier, unit cost, quantity, landed cost allocations — is captured with its receive date.
Reconciles against current warehouse stock
For each SKU, the system asks: how many units do I have in the warehouse right now? Then it walks backward through PO history (newest to oldest) to allocate cost layers — newest stock gets the newest PO price, older stock gets older prices, until total allocated quantity matches what’s physically on hand.
Computes weighted-average per-SKU FIFO COG
The weighted average across the allocated PO layers IS the FIFO COG. Stored, dated, and presented as a per-SKU number on the FIFO COG dashboard.
Surfaces the variance vs your saved Current COG
The dashboard shows Current COG (what’s saved on the SKU today), FIFO COG (what was just calculated), and % Diff (the gap). Sortable, searchable, filterable. The “Missing Current COG” filter surfaces SKUs without any COG saved at all (highest-priority fixes). The “FIFO Higher” and “FIFO Lower” filters surface where costs went up vs down since the last book update.
Exports the variance list as a CSV
Filter to the SKUs that need attention (e.g., “COG Different” with > 10% variance), export, hand to your bookkeeper or accountant. The export filename includes brand + filter + date, so multiple exports don’t overwrite each other.
The calculation runs nightly. Your books stay current within 24 hours of the most recent PO update. Margin reports stop drifting away from reality.
What we’re not telling you yet (per the new feature rule)
FIFO COG is in private beta on SKU Compass today. Some capabilities are still rolling out and the help docs reflect current state per release. Today’s safe-to-promise: see your FIFO-calculated COG nightly, filter by variance, export a review list as CSV your bookkeeper can act on. Audit-trail / change-log capabilities are being scoped — when they ship we’ll update copy here. For the most current feature state, refer to the in-app help docs.
Who needs FIFO COG tracking?
The brands that benefit most from nightly FIFO COG calculation:
- Mid-market multi-channel brands ($5M-$50M ARR) with 500-5,000 SKUs and meaningful supplier-price drift
- Brands sourcing 30%+ of catalog overseas — currency + freight drift compounds quarterly
- Brands preparing for fundraising or acquisition — clean COG data is a due-diligence requirement; stale book numbers fail it
- Brands with multi-supplier sourcing per SKU — averaging across suppliers manually is error-prone; FIFO + per-SKU allocation does it correctly
- Brands whose bookkeeper updates COG quarterly or less — every brand we’ve audited in this category has 8-15% drift per quarter
If you’re sub-$2M revenue with 50 SKUs and a single domestic supplier, the manual book updates are probably keeping pace with reality. The FIFO COG tracking layer adds operational cost without proportional margin recovery. Stay manual.
Where this fits in the broader margin stack
FIFO COG is one piece of the margin-accuracy stack:
- FIFO COG — accurate per-unit cost (this post)
- Per-channel fee tracking — Amazon FBA fees + 3.5% fuel surcharge + storage + per-FNSKU low-inventory fee per true cost of FBA
- Per-channel margin allocation — different channels have different fees, returns, and customer-acquisition costs
- Bundle component cost rollup — kits and multi-packs need accurate underlying SKU costs to report bundle margin honestly
FIFO COG is the foundation. Without honest per-SKU cost, every downstream margin number is built on a wrong base.
Frequently asked questions
What is FIFO COG?
FIFO stands for “first in, first out.” FIFO COG calculates your per-SKU Cost of Goods Sold by allocating costs from your most recent purchase orders backward through your current warehouse stock, then computing the weighted-average per-unit cost. It reflects actual recent purchase prices rather than a frozen number in your books.
Why is my saved COG different from my FIFO COG?
Three common reasons: supplier prices moved since the last book update, freight/tariff/landed costs changed but only the supplier line was updated, currency shifted on international suppliers. Most mid-market brands with quarterly book updates have 5-20% drift per SKU between saved COG and FIFO COG.
Should I always update my saved COG to match FIFO COG?
No — FIFO is one accounting method; some businesses use weighted-average or LIFO depending on tax strategy. The FIFO COG dashboard gives you the FIFO answer to consider — applying it is your decision, ideally with your accountant. SKU Compass shows the variance so you can decide; it doesn’t push the change automatically.
How often does the FIFO COG calculation run?
Nightly across every SKU + brand. Edits to PO costs save instantly to the database; the FIFO calculation refreshes on the next scheduled run. An on-demand recalc option is also available so users can trigger immediate refresh after large PO updates.
What’s the difference between Total Cost and Current COG times Warehouse Stock?
Total Cost is a real sum from PO lines — what you actually paid for the warehouse stock you have. Current COG times Warehouse Stock is what your books say you have invested. If they disagree by a lot, your saved COG number is out of date. The percent variance column shows that gap as one number per SKU.
Is FIFO COG available now?
Private beta on SKU Compass for current customers as of 2026-Q2. General availability with the SKU Compass platform over the coming weeks. Book a strategy call for early access.
Does SKU Compass support LIFO or weighted-average COG too?
FIFO is the primary live tab. LIFO Weighted Average is rolling out alongside FIFO COG for current customers. The dashboard supports method-selection per SKU as additional methods become available.