Profitability & COGS

The profitability dashboard

See revenue, COGS, fees, shipping, and overhead stacked together to understand real net margin per order, SKU, channel, and warehouse.

Where to find it

Open /admin/reports/profitability or click Reports → Profitability from the main nav. The page loads with the last 30 days selected by default; use the date picker to change the window. Numbers refresh in near real-time as orders ship and fees ingest, with a small lag for marketplaces that publish fee data on a delay.

The stacked bar

The headline chart is a stacked bar with one bar per day (or week, depending on window). From top down each bar shows: Net profit (green), Revenue (full bar height), COGS (red), Marketplace fees (orange), Shipping cost (blue), Allocated overhead (gray). Hover any segment to see exact dollars. Click a bar to drill into the orders that day.

Per-SKU drill-down

Below the chart is a table of every SKU sold in the window with: units sold, revenue, FIFO COGS, fees, shipping, allocated overhead, net profit, and margin %. Sort by margin to find your most-profitable lines or your loss-makers. Click a row to open the per-SKU detail page with a time-series of margin and a list of orders with their individual P&Ls.

Channel and warehouse splits

Toggle the Split by dropdown to slice by channel (Shopify, Amazon, eBay, Walmart, manual), warehouse, or both. Useful patterns: "Are my Amazon orders profitable after FBA fees?", "Is my California warehouse cheaper to ship from than New York for West-Coast orders?". The splits use the same underlying data, just grouped differently.

CSV export

Click Export CSV for a row-per-order dump with all the line items: order ID, channel, ship-date, revenue, COGS, fee_amazon, fee_shopify_payments, shipping_cost, overhead_allocated, net_profit. Pull this into Excel or your accountant's software for deeper analysis. The export respects whatever date range and filters are currently set.

FAQs

Why does my net profit number disagree with my bank statement?
Bank statements show cash flow, not accrual P&L. Cash inflows lag the order ship date (Shopify Payments holds funds, Amazon disbursements are bi-weekly). The profitability dashboard is accrual—profit at the moment of ship.
Are returns reflected?
Yes. A refunded order has its revenue reversed, the COGS layer restored (in the appropriate return mode), and any return shipping label cost added. The order's net profit becomes negative by the return cost.
How is overhead allocated?
See <a href="/help/overhead-allocation">Overhead allocation</a>. You pick a monthly $ amount and a method (units / revenue / weight), and ShipWave spreads it across SKUs in that period.
Can I see profitability for a specific date in the past?
Yes&mdash;the dashboard accepts any historical date range. Fees that haven't ingested yet (e.g. Walmart settlements) will be estimated until the real numbers arrive.

More in Profitability & COGS

  • FIFO COGS: how ShipWave costs your inventory

    Why First-In-First-Out costing matters for accounting accuracy, how cost layers are built from receipts and adjustments, and how consumption stays atomic at ship time.

  • Marketplace fee ingestion

    How ShipWave pulls real fee data from Amazon, Shopify, eBay, and Walmart so your profitability numbers reflect what each channel actually charges you.

  • Inventory valuation

    See the dollar value of every SKU sitting on your shelves and snapshot month-end totals for accounting.

  • Opportunities Found: 8 ways ShipWave spots money on the table

    Heuristics that surface SKUs losing money, declining margins, cheaper suppliers, slow movers, and shipping outliers&mdash;capped to a human-reviewable cadence.

  • Overhead allocation

    Spread fixed monthly overhead (rent, utilities, software, salaries) across SKUs so the profitability dashboard shows fully-loaded margin.

Back to Help Center