Profitability Dashboard with FIFO COGS
Stop guessing which SKUs make you money. ShipWave ingests real marketplace fees, allocates shipping costs to the right orders, runs first-in-first-out cost accounting, and surfaces 8 categories of opportunity in your catalog — at a fraction of the cost of Extensiv or Cogsy.
FIFO
COGS Engine
Layered cost lots, not blended averages
5+
Marketplace Fee Sources
Amazon, eBay, Walmart, Shopify, manual
8
Opportunity Heuristics
Catalog scans surface losing SKUs
1/10th
Cost of Extensiv
Same depth, not $999+/mo
Benefits
Why Businesses Choose This Feature
- FIFO Cost Accounting, Not Blended Averages
Most platforms blend your unit cost across all inventory. ShipWave tracks every receiving lot at its actual landed cost — so when prices change, your margins reflect reality, not a 6-month-old average.
- Marketplace Fees Pulled Automatically
Amazon referral fees, FBA fulfillment fees, eBay final value, Walmart commission, and Shopify Payments processing fees ingest directly from each platform — no manual entry, no spreadsheet reconciliation.
- Shipping Cost Allocated to the Right Order
Real EasyPost label costs (not estimates) attach to the order that paid for them. Multi-box, multi-warehouse, and split shipments all roll up correctly so you see true delivered cost per SKU.
- 8 Opportunity Heuristics
Automatic scans flag losing SKUs, declining margins, suspected cheaper-supplier candidates, fee outliers, slow movers eating capital, and 4 more patterns the catalog tells you about — if you bother to look.
- CFO-Ready Reporting
Period-over-period margin trends, gross profit by channel, blended ROAS reconciliation, and ad-hoc SKU drill-down. Export to CSV or hand a finance owner a read-only dashboard.
- Refund and Reversal Handling
Refunded orders reverse the cost lot they consumed, restocked units flow back into FIFO, and partial refunds attribute correctly to the unit being returned — your COGS stays honest through the whole lifecycle.
How Profitability Tracking Works in ShipWave
Capture Real Costs at Receiving
When inventory arrives at a warehouse, ShipWave records the unit cost, freight, duty, and any landed-cost adjustments — creating a dated FIFO cost lot for each SKU.
Ingest Marketplace Fees per Order
For every fulfilled order, ShipWave pulls the actual Amazon, eBay, Walmart, or Shopify Payments fee — never an estimate. Shipping label cost attaches from the EasyPost transaction.
Calculate True Gross Margin
Revenue minus FIFO COGS minus fees minus shipping minus overhead = your real per-order, per-SKU, per-channel margin. Roll it up daily, monthly, or for any custom window.
Why FIFO COGS Matters More Than You Think
Blended Averages Hide the Truth
Most ecommerce platforms calculate margin using a "weighted average cost" — they take all your inventory, divide total dollars spent by total units, and call it your unit cost. The problem: when supplier prices rise, the average lags reality for months. You see fat margins on paper while your actual replacement cost has climbed 15%. By the time the average catches up, you have been underpricing for half a year. FIFO accounting fixes this by tracking each receiving lot separately at its actual landed cost. The unit you ship today is costed against the oldest available lot — exactly how the IRS expects you to do it. When you reorder at a higher price, the next sold unit reflects the new cost lot immediately, and your dashboard tells you margin is compressing before your bank account does.
Marketplace Fees Are Where Margins Die
On a $100 Amazon sale, you might pay 15% referral, $5.50 FBA fulfillment, $0.50 storage allocation, plus advertising spend. That is 25-30% of revenue gone before COGS. eBay takes 13.25% final value plus PayPal fees. Walmart commissions vary by category. Shopify Payments hits you for 2.9% + $0.30. Sellers who track "Amazon fees" as a single estimated line item routinely miss when fee structures change — Amazon increases storage fees, FBA size tier rebands, eBay raises a category commission. ShipWave pulls the actual fee charged on each transaction from the platform itself, so when fees change you see it immediately at the SKU level, not in a quarterly accounting reconciliation.
Shipping Cost Allocation Is Not Trivial
A customer buys three SKUs in one order. The label cost is $14.50. Most platforms divide that evenly: $4.83 per SKU. But what if one SKU is 40 pounds and the other two are 6 oz each? The heavy SKU drove the cost, and a 1/3 split makes the light SKUs look unprofitable. ShipWave allocates shipping cost by dimensional weight contribution, so the SKU that caused the cost absorbs it. For multi-box orders, each box costs its own label and attaches to the items in that box. For multi-warehouse splits, each warehouse leg costs independently. The result: you can compare margin across SKUs honestly — instead of a heavy SKU subsidizing its lighter cart-mates.
The 8 Opportunity Heuristics
After analyzing thousands of catalogs, eight patterns reliably surface money on the table: (1) Losing SKUs — items sold at a gross margin below 0% after all fees, (2) Declining Margins — SKUs whose 30-day margin has dropped >5pts vs the prior period, (3) Cheaper Supplier Candidates — SKUs with above-category landed cost suggesting a better sourcing opportunity, (4) Fee Outliers — SKUs where marketplace fees exceed the category norm, often a misclassified product type, (5) Slow Movers — units sitting >90 days eating storage and capital, (6) Price Compression — listings where competitor underpricing is dragging your blended margin down, (7) Refund-Heavy SKUs — items with refund rates >2x the catalog average, (8) Channel Imbalance — SKUs that profit on one marketplace but lose on another, ripe for a channel-specific pricing rule. ShipWave runs these scans nightly and presents the dollar value of each opportunity on the dashboard.
Comparable to Extensiv, Without the Price Tag
Extensiv (formerly Skubana Profit), Cogsy, and Sellerboard are the established players in ecommerce profitability — all priced between $399 and $1,499 per month with annual contracts. They are excellent products. ShipWave matches their FIFO COGS depth and fee ingestion accuracy because the underlying accounting is well-defined: FIFO is FIFO, marketplace APIs return what they return. The difference is we built profitability as a feature of an integrated shipping and inventory platform, not as a standalone SaaS with sales reps and onboarding fees. If you already use ShipWave for shipping, returns, and warehousing, the profitability dashboard comes included. If you currently pay Extensiv $999/month, that money could be back in your operating account.
ShipWave Profitability vs. Extensiv Profit
Same FIFO accounting depth, integrated with your shipping platform, without the enterprise price tag.
| Feature | ShipWave | Extensiv ($999+/mo) |
|---|---|---|
| FIFO COGS engine | Built-in, layered cost lots | Built-in, layered cost lots |
| Marketplace fee ingestion | Amazon, eBay, Walmart, Shopify, manual | Amazon, eBay, Walmart, Shopify |
| Shipping cost allocation | Real EasyPost label cost, dim-weighted | Estimated, requires integration setup |
| Opportunity heuristics | 8 automatic catalog scans | Manual filtering required |
| Pricing | Included with platform | $999-$1,499/mo + annual contract |
| Setup time | Hours (already connected) | Weeks (separate onboarding) |
| Shipping platform included | Yes — full multi-carrier | No — separate tool |
Who Needs True Per-SKU Profitability
CFOs at $5M-$50M Brands
Finance owners who have outgrown QuickBooks-level reporting need SKU-level visibility to defend pricing decisions, evaluate new product launches, and reconcile marketplace settlements.
Multi-Channel Sellers
Brands selling on Shopify, Amazon, eBay, and Walmart can finally see which channel is actually profitable per SKU — instead of relying on blended P&L lines that hide channel-specific bleed.
Founders Deciding What to Reorder
Operators who buy inventory in 60-90 day cycles need to know which SKUs to reorder, which to discontinue, and which deserve a price increase before they place the next PO.
Frequently Asked Questions
How does FIFO COGS work in ShipWave?
When inventory arrives, ShipWave creates a dated cost lot at the actual landed cost (unit price + freight + duty). When you ship a unit, it consumes the oldest available lot first. This matches IRS-acceptable FIFO accounting and reflects real margin changes when supplier prices move — unlike blended-average methods that lag reality.
How accurate are the marketplace fees?
Fees come from the platforms themselves — Amazon SP-API settlement reports, eBay financial events, Walmart commission ledgers, and Shopify Payments transaction records. They are not estimates. If a category fee changes overnight, your dashboard reflects it the next day.
What happens with refunds and returns?
A refund reverses the cost lot the original order consumed. If the unit comes back to inventory (a real return), it flows back into the FIFO queue at its original cost lot. Partial refunds (e.g., a 10% discount adjustment) attribute against the order without restocking. Your COGS and gross margin stay honest through the full lifecycle.
Can it handle multi-currency or international sourcing?
Yes. Landed cost can be entered in the receiving currency and converted at the FX rate of the receiving date. The cost lot stores the USD-equivalent at that moment, so your margin reporting stays consistent even when supplier currency moves.
How is shipping cost allocated across multi-item orders?
By dimensional weight contribution. If a 40-pound SKU ships with two 6-oz SKUs, the 40-pound SKU absorbs most of the label cost — not an even split. For multi-box and multi-warehouse orders, each shipment costs independently and attaches to the items it carried.
What are the 8 opportunity heuristics?
Losing SKUs (negative gross margin), Declining Margins (>5pt drop vs prior 30d), Cheaper Supplier Candidates (above-category landed cost), Fee Outliers (marketplace fees above category norm), Slow Movers (>90 days on hand), Price Compression (competitor underpricing), Refund-Heavy SKUs (>2x average refund rate), and Channel Imbalance (profitable on one channel, losing on another).
Is this comparable to Extensiv Profit or Cogsy?
Yes, with the same FIFO COGS engine and marketplace fee ingestion. The difference is pricing and integration: ShipWave includes profitability with the platform you already use for shipping and inventory, instead of charging $999-$1,499/month on a separate contract.
Explore More
Related Features
Landed Cost Tracking
Capture true landed cost (freight, duty, customs) on every receiving lot so FIFO COGS reflects reality.
Learn more →
Marketplace Selling
List on Amazon, eBay, and Walmart with fee data flowing back into profitability automatically.
Learn more →
Warehouse Management
Lot tracking and bin-level inventory feeds the FIFO engine that powers true COGS.
Learn more →
See Which SKUs Actually Make You Money
Stop running on blended averages. Get FIFO COGS, real marketplace fees, and 8 opportunity heuristics — included with ShipWave.