Profitability cockpit
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 | Product margin | Freight | Net profit | After returns | Total margin | Manufacturer | Products | 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?
Freight evidence
Observed, corrected, modelled, and still-unverified freight stay visibly separate.
Imputed freight calibration —
| Carrier | Weight band | Zone | Observed | Median | P90 | Median error | Usable |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
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… | ||||||
Freight: mis-keyed PO references —
| PO memo | Carrier reference | Order | Shipments | Bills | Lines | Summed amount | Resolved by tool | Bill numbers |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
| Bill | Vendor | Bill date | Amount | Memo ref | Ref raised | Gap | Order | Status |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Freight: carrier overrides —
| Order | Date | Chosen method | Billed by | Freight | Ship revenue | Net |
|---|---|---|---|---|---|---|
| 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
Net margin by product family across the whole book. Shipping revenue and freight are allocated by product-revenue share.
| Family | SKUs | Product revenue | Cost | Net profit | Net margin |
|---|---|---|---|---|---|
| Loading… | |||||
Margin by brand
Net margin by Akeneo brand, with shipping revenue and freight allocated by product-revenue share.
| Brand | SKUs | Product revenue | Cost | Net profit | Net margin |
|---|---|---|---|---|---|
| Loading… | |||||
Margin by vendor
What we make on each supplier's goods, and what each carrier costs us. Supplier rows cover bill-backed lines only — estimate-costed lines carry no vendor identity and are excluded, not guessed.
Vendor scorecard — revenue vs PO cost sent
Business we send each vendor, against the revenue their products generate. Multi-vendor SKUs are split by the vendor each order actually went to, never averaged across vendors.
| Vendor | Orders | SKUs | Revenue | Share | PO material COG | Rev per COG $ | Gross profit | Margin | Rev Δ | COG Δ |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||
Month by month
Attributed revenue and the material COG we sent out on POs, month by month, each against the month before.
| Month | Revenue | MoM | Orders | Margin | PO material COG | MoM |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Suppliers
Product margin on lines backed by this vendor's bills.
| Vendor | Orders | SKUs | Revenue (billed lines) | Cost | Net profit | Net margin |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Freight carriers
Freight billed vs shipping revenue collected, per carrier.
| Carrier | Orders w/ freight | Freight billed | Shipping revenue | Net |
|---|---|---|---|---|
| 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.