Profitability cockpit
Whole-book margin at a glance — net of returns, where profit lives, and where it leaks.
Where profit lives — by marketplace
Where profit lives — by family
Margin leak radar
Per-product profitability
Each row is one SKU. Numbers below default to evidence-only — lines whose product cost is backed by a real NetSuite VendBill or NS landed cost. Click any row to see every order it appears in with the bill behind each cost.
Products
Sortable, searchable. —
| Product | Orders | Quantity | Revenue | Cost | Profit | Margin | Evidence |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Orders
Sales orders ranked by net margin. Defaults to complete only — orders where every product line has a vendor bill behind its cost AND freight is matched. Toggle filters to widen.
Orders
—
| SO | Date | Customer | Revenue | Cost | Freight | Net profit | After returns | Margin | Completeness | Audit |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||
Data health
Is the headline number trustworthy? One page, every signal at a glance.
Where each dollar of cost comes from
Trust ranked. Real bill at top, estimates and fallbacks below.
Sales channel mix
Revenue by channel. Marketplace external IDs covered —.
Cost validation
For every SKU on netsuite_cost_estimate, do our actual vendor bills agree?
Top variance SKUs —
| SKU | Vendor | NS est. | Bills wavg | Variance | Revenue |
|---|---|---|---|---|---|
| Loading… | |||||
Trust calibration (within 5%) SKUs where NS estimate matches bills exactly
| SKU | NS est. | Bills wavg | Variance | Revenue |
|---|---|---|---|---|
| Loading… | ||||
Missing-cost SKUs —
| SKU | Family | Orders | Revenue at risk | Sources tried |
|---|---|---|---|---|
| Loading… | ||||
Full channel breakdown All channels with margin, profit, ID coverage
| Channel | Orders | Lines | Revenue | Profit | Margin | External ID |
|---|---|---|---|---|---|---|
| Loading… | ||||||
SKU database
Every distinct SKU we’ve sold in the window. Sort, filter, drill down. Kits roll up their members automatically; cost gaps are surfaced, not hidden.
How the SKU database is built
- Source
- Local table
margin_snapshots, pre-computed per-line. Refreshed nightly viasync_all_margins.py. - SKU revenue
- Sum of
transactionline.netamountacross every SO line for the SKU. - SKU cost
- Priority chain: NetSuite
costestimate/landedcost→forecast.dbfallback → kit rollup → missing (surfaced with a gap tag). - Kits
- A kit’s cost is the rolled-up sum of its members from NetSuite
itemmember.
| SKU / product | Family | Brand | Qty sold | Orders | Revenue | Cost | Profit | Margin |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Margin by family
Profit by product family (Akeneo taxonomy) across the whole book — all sales orders. Product revenue / profit; margin is product-only (excludes freight & returns).
| Family | SKUs | Product revenue | Cost | Profit | Product margin |
|---|---|---|---|---|---|
| Loading… | |||||
Margin by brand
Which manufacturers give us the best pricing-to-retail spread. Brand from Akeneo (attribute + shop-by-brand category). Product revenue / profit; margin is product-only.
| Brand | SKUs | Product revenue | Cost | Profit | Product margin |
|---|---|---|---|---|---|
| Loading… | |||||
Margin by marketplace
Whole-book net per channel: revenue − product cost − freight − returns. Amazon Vendor Central rolls up under Amazon; Wayfair & Home Depot recovered from the customer.
| Loading… |
Shipping revenue vs freight cost
By channel
| Marketplace | Orders | Shipping revenue | Freight cost | Shipping P/L | Cost recovery |
|---|---|---|---|---|---|
| Loading… | |||||
Data coverage
What’s missing, by source. Every line we can’t cost, every order we can’t freight-match — ranked by dollar impact.
Missing-cost SKUs — ranked by revenue at risk
Products generating revenue without a bookable cost. Fixing these in NetSuite’s item master unlocks margin visibility.
| SKU | Family | Orders | Revenue at risk | Sources tried |
|---|---|---|---|---|
| Loading… | ||||
Cost-source breakdown
Which fallback is actually carrying us.
Missing cost by family
Which product lines have the worst item-master hygiene — usually a workflow gap.
| Family | SKUs with gaps | Revenue at risk | Share of missing $ |
|---|---|---|---|
| Loading… | |||
Needs review — us vs. NetSuite
Your weekly review list: orders where our gross profit disagrees with NetSuite’s by more than 5%, biggest dollar gap first. A negative delta usually means we found a cost NetSuite doesn’t have. Click any row to inspect & mark audited.
| Sales order | Customer | Reason | Our profit | NS profit | Δ $ | Δ % | Audited |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Single-order drill-down
Line-by-line reconstruction of one sales order — revenue, cost, freight, and the source tag for each number.