E-Com Profit Matrix

Sign in to access your business analytics

Invalid credentials. Please check your username and password.

E-Com Profit Matrix

V11 — Server-hosted. Multi-company data persistence, Amazon merge-dedup & Web Worker pipeline.

Signed in as admin

Company & Data Sources

OMS & Ad Spend replace on upload · Amazon merges & pre-aggregates on server (no need to re-upload old months).

Required · Replace
OMS Guru Dump
Not uploaded
Optional · Merge
Amazon Custom Unified Transaction
Not uploaded — SmartConnect will fall back to OMS
Optional · Replace
Ad Spend CSV
Month,Channel,Amount

Global Filters & Toggles

Data still ripening. A large share of orders are in unresolved statuses. Settlement lag is ~45 days — analyse older months for reliable numbers.

Total Orders

0

All dispatched (excludes pre-ship)

Total Net Profit

₹0

Settlement − COGS (− Ads if toggled)

Data Resolution

0%

Delivered + CR + RTO + Cancelled / All

RTO % (of shipped)

0%

Cancelled Return Received / Shipped

Customer Return %

0%

CR / (Delivered + CR)

Cancel %

0%

Cancels / Total (pre-dispatch)

Avg Profit / Order

₹0

Net Profit / All Dispatched Orders

True Profit / Delivered

₹0

Net Profit / Delivered Orders

Return Cost / Delivered

₹0

Return Losses / Delivered Orders

Contribution Margin

0%

Net Profit / Revenue (Settlement)

Net Profit by Channel

Order Fulfillment Distribution

Return & Cancel Mix by Channel

Monthly Trend (Profit & Return %)

P&L Waterfall

Revenue (Settlement) → COGS → Product Profit → Ad Spend → Net After Ads

Top 5 SKUs by Net Profit

SKUOrdersProfit

Design SKU Performance

Variants collapsed to design SKU code. Click column headers to sort.

0 SKUs
Design SKU Category Brand Orders Units Avg SP Revenue Net Profit Avg Profit/Ord CM % RTO % CR %

Threshold Controls

Kill Candidates (Net Loss)

Delist, raise price, or re-negotiate COGS

SKUOrdersLossCM %Return %

Watch List (High Risk / Thin Margin)

Profitable today, but vulnerable to return spikes

SKUOrdersProfitCM %Return %Flags

Top 20 Star SKUs (Highest Profit / Order)

Scale ad budget and protect stock on these

SKUCategoryOrdersTotal ProfitAvg Profit/OrdCM %Return %

Category Profitability Summary

CategoryOrdersDeliveredRevenueNet ProfitAvg ProfitCM %RTO %CR %

Category × Channel Profit Heatmap

Values are Net Profit (₹). Green = profitable, red = loss.

Monthly Profit Trend by Category (Top 6)

Brand Performance Comparison

BrandOrdersDeliveredRevenueNet ProfitAvg ProfitCM %RTO %CR %

Monthly Profit Trend by Brand

Returns by Reason Bucket

BucketCountShare %

Top Raw Return Reasons (from OMS)

Raw ReasonBucketCount

SKU × Return Reason Bucket Heatmap

Top 25 returned SKUs. Identify whether sizing, fabric, or defect is the root cause.

RTO % by Courier

Top 15 by shipped volume — variants collapsed to canonical courier names

CourierShippedRTORTO %

RTO % by State

Top 15 by shipped volume

StateShippedRTORTO %

COD vs Prepaid RTO

Order Type normalized: `COD` → COD, else Prepaid

PaymentShippedRTORTO %

Data Sources Summary

Channel Marketing Efficiency

Amazon variants (Amazon, Amazon FBA, Amazon SmartConnect) pooled since Cost of Advertising covers all three. Amazon ad spend auto-extracted from Amazon report; other channels from Ad Spend CSV.

Channel GroupOrdersRevenueProduct ProfitAd SpendROASBreak-evenNet After Ads

Awaiting Data

Pick a company from the dropdown. If no OMS file is on file for this company yet, upload one to begin.

Processing data in background worker...