Sign in to access your business analytics
V11 — Server-hosted. Multi-company data persistence, Amazon merge-dedup & Web Worker pipeline.
OMS, Ad Spend & Overheads replace on upload · Amazon merges & pre-aggregates on server (no need to re-upload old months).
Upload the panel's .xls / .xlsx directly (or CSV) · feeds into whichever company is selected above (currently only Vardhman Mavericks has BC data) · these merge & dedup on upload — upload only the newest month's export each time, same as Amazon above.
Loading coverage…
Data still ripening. A large share of orders are in unresolved statuses. Settlement lag is ~45 days — analyse older months for reliable numbers.
0
All dispatched (excludes pre-ship)
₹0
Settlement − COGS − Packaging (− Ads if toggled)
0%
Paid/written-off Delivered + CR + RTO + Cancelled / All
0%
Cancelled Return Received / Shipped
0%
CR / (Delivered + CR)
0%
Cancels / Total (pre-dispatch)
₹0
Net Profit / All Dispatched Orders
₹0
Net Profit / Delivered Orders
₹0
Return Losses / Delivered Orders
0%
Net Profit / Revenue (Settlement)
Revenue (Settlement) → COGS → Packaging → Product Profit → Ad Spend → Net After Ads → Overheads → Operating Profit
| SKU | Orders | Profit |
|---|
Profit change vs the previous month, split into drivers: Volume = more or fewer orders at the previous month’s profit per order; then per-order changes in Settlement (price, fees, returns), COGS, Packaging and Ads. The drivers add up exactly to the change. Respects the toggles.
| Month | Orders | Profit | Δ vs prev | Volume | Settlement / order | COGS / order | Packaging / order | Ads / order | Return % | Main reason |
|---|
Variants collapsed to design SKU code. Click column headers to sort.
| Design SKU | Category | Brand | Orders | Units | Avg SP | Revenue | Net Profit | Avg Profit/Ord | CM % | RTO % | CR % |
|---|
Delist, raise price, or re-negotiate COGS
| SKU | Orders | Loss | CM % | Return % |
|---|
Profitable today, but vulnerable to return spikes
| SKU | Orders | Profit | CM % | Return % | Flags |
|---|
Scale ad budget and protect stock on these
| SKU | Category | Orders | Total Profit | Avg Profit/Ord | CM % | Return % |
|---|
| Category | Orders | Delivered | Revenue | Net Profit | Avg Profit | CM % | RTO % | CR % |
|---|
Values are Net Profit (₹). Green = profitable, red = loss.
| Brand | Orders | Delivered | Revenue | Net Profit | Avg Profit | CM % | RTO % | CR % |
|---|
| Bucket | Count | Share % |
|---|
| Raw Reason | Bucket | Count |
|---|
Top 25 returned SKUs. Identify whether sizing, fabric, or defect is the root cause.
Top 15 by shipped volume — variants collapsed to canonical courier names
| Courier | Shipped | RTO | RTO % |
|---|
Top 15 by shipped volume
| State | Shipped | RTO | RTO % |
|---|
Order Type normalized: `COD` → COD, else Prepaid
| Payment | Shipped | RTO | RTO % |
|---|
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 Group | Orders | Revenue | Product Profit | Ad Spend | ROAS | Break-even | Net After Ads |
|---|
Delivered orders only. Paid = settlement received · Awaiting = no payment yet, 75 days or less (unresolved) · Written off = still no/negative payment after 75 days (counted as a loss) · Exchanges = Meesho size-exchange and Amazon replacement orders (product paid on the original order; only shipping is charged on the replacement, and the item cost is applied) · Not tracked = Ajio dropship/API (no settlement in OMS). Brand Central is always paid (invoice value).
| Channel | Delivered | Paid | Exchanges | Awaiting | Awaiting % | Cost tied up | Written off | Write-off loss | Not tracked |
|---|
Days since delivery (or order date if no delivery date). Shows which channels pay late.
| Channel | 0–15 d | 16–30 d | 31–45 d | 46–60 d | 61–75 d | Total |
|---|
Delivered more than 75 days ago with zero or negative settlement. Worth raising a claim / ticket with the channel. Top 300 by loss.
| Channel | Order ID | SKU | Order Month | Days | Settlement | Loss |
|---|
Paid, delivered orders only (Brand Central excluded — its price is already the settlement). Kept % = settlement ÷ selling price: how much of your selling price actually reaches you after commission, shipping and fees.
| Channel | Paid Orders | Units | Avg Selling Price | Avg Received / Unit | Kept % | Deducted / Unit |
|---|
Top 60 designs by paid orders.
| Design SKU | Paid Orders | Avg Selling Price | Avg Received / Unit | Kept % |
|---|
Grouped by selling price per item (Brand Central excluded). Respects the Ads / Packaging / Awaiting toggles.
| Price Band | Orders | Delivered | CR % | RTO % | Revenue | Profit | Profit / Order | Margin |
|---|
Size and colour are read from the SKU code (e.g. VM-DOVE-BEIGE-46E). Brand Central excluded (its returns are warehouse returns, not customer returns). Red = customer-return % at least 5 points above your average.
e.g. 32, 34, 36 …
| Band | Orders | Delivered | Cust. Returns | RTO | CR % | RTO % | Profit | Profit / Order |
|---|
e.g. B, C, D, E, F
| Cup | Orders | Delivered | Cust. Returns | RTO | CR % | RTO % | Profit | Profit / Order |
|---|
Top 60 sizes by orders.
| Size | Orders | Delivered | Cust. Returns | RTO | CR % | RTO % | Profit | Profit / Order |
|---|
Top 40 colours by orders.
| Colour | Orders | Delivered | Cust. Returns | RTO | CR % | RTO % | Profit | Profit / Order |
|---|
High · Unpaid 15+ days
0
Medium · Unpaid 7–14 days
0
Low · Delivered 0–6 days
0
Delivered, not yet paid (awaiting), oldest first. Value = selling price × qty. Myntra and Snapdeal normally pay late — chase anything well past their usual cycle (see the ageing table in the Settlement tab).
| Channel | Order ID | SKU | Order Month | Days since delivery | Sales Value |
|---|
RTO orders with a negative settlement (the channel charged you for the failed delivery) — check whether each charge is valid. Not listed: Snapdeal (charges RTO by design) and exchange/replacement orders (their shipping charge is expected). Both are still counted in profit.
| Channel | RTO Orders | Charged | % Charged | Total Charge | Avg / Charged RTO | Note |
|---|
Every charged RTO, biggest charge first. Export it to raise disputes.
| Channel | Order ID | SKU | Order Month | Settlement | Note |
|---|
Full SKUs (size level) where customer returns + RTO exceed delivered orders, minimum 3 returns. Usually a sizing, quality or listing-image problem.
| SKU | Delivered | Cust. Returns | RTO | Returns ÷ Delivered | Profit |
|---|
Design SKUs whose return % in the latest mature month (ended at least 30 days before your last order date, so most returns have arrived) is clearly worse than their previous 3-month average. Needs at least 10 resolved orders that month and 15 in the baseline.
| Design SKU | Month | Return % (month) | Return % (prev 3 mo) | Change | Orders (month) | Profit (prev 3 mo) |
|---|
Delivered sales value → what the channel actually paid (net of returns, RTO charges and fees) → your costs → net profit. Marketplace deductions = Gross Sales − Settlement. Brand Central counts its invoice as both sales and settlement. Respects the toggles.
| Channel | Orders | Gross Sales (delivered) | Settlement | Marketplace Deductions | Deductions % | COGS | Packaging | Ads | Net Profit | Net % of Sales |
|---|
FBA orders by the Amazon fulfilment centre they shipped from.
| Warehouse | State | Orders | Units | Share of FBA Orders | Delivered | Return % | Profit | Profit / Order |
|---|
Pick a company from the dropdown at the top, or upload an OMS Guru CSV if no data is on file yet.