Morning Command Center: Complete Dashboard Guide

A comprehensive deep dive into the Brandstack Dashboard: understand gross-to-net waterfalls, COD vs. prepaid unit economics, channel profitability, and RTO risk.

The Brandstack Dashboard is engineered to be the single command center a D2C founder or operator checks first every morning. Instead of opening 8 to 12 separate portals—Shopify, Meta Ads, Amazon Seller Central, Flipkart Seller Hub, Myntra PPMP, and courier dashboards—Brandstack reconciles all your channels into one live, unified view.

Brandstack Morning Command Center: Top KPI strip and daily channel performance

The 8:00 AM Rule: Most founders lose 1 to 2 hours every morning cross-referencing mismatched spreadsheets. The Brandstack dashboard is built so you can assess top-line revenue, true bank margin, cash collection risk, and operational fires in under 3 minutes.

---

1. Top KPI Strip: The True Health of Your Brand

At the top of your dashboard sits the 6-metric executive health strip. In e-commerce, headline revenue is vanity, invoiced sales is reality, and net margin is survival. Brandstack displays this 3-tier truth side by side:

Gross Sales

Total value of all orders placed, before any customer discounts, cancellations, or returns.

Why it matters: Tells you total market demand and top-of-funnel checkout volume.

Invoiced Sales

Actual billed revenue generated from orders that were successfully confirmed and packed.

Formula: Gross Sales − Discounts − Pre-Dispatch Cancellations

Net Sales

Cash kept by your business after accounting for customer returns and RTOs (Return to Origin).

Formula: Invoiced Sales − Customer Returns − RTO Orders

Total Orders & Fulfilled

Shows total orders placed alongside the count of orders already fulfilled and dispatched by your warehouse.

Why it matters: Instantly flags dispatch backlogs before shipping SLAs breach.

% Contribution Margin

The percentage of revenue that lands in your bank after covering COGS, shipping, packaging, and payment fees.

Why it matters: If this drops below your target (e.g., 50%), scaling ad spend will burn cash.

AOV (Average Order Value)

Average net transaction size across all channels.

Why it matters: Higher AOV gives your marketing team breathing room against rising ad CPMs.

Every KPI card includes a real-time sparkline and a percentage change indicator comparing the current period (e.g., Last 30 days) to the previous period. A red indicator (↘) flags areas requiring attention, while green (↗) signals positive growth.

---

2. Overview: Daily Velocity & Profit Alignment

Directly below the KPI strip, the Overview section contrasts top-line channel volume against actual net margin.

A. Sales by Channel (Invoiced Sales)

This interactive, stacked bar chart maps your daily invoiced revenue across every storefront and marketplace:

• Shopify (D2C Store) — Direct web sales
• Amazon — Seller Central orders
• Flipkart — Seller Hub orders
• Myntra — PPMP orders
• Eternz — Partner marketplace sales

What to look for: Look for spikes and channel concentration. If Shopify spikes on a weekend while marketplaces stay flat, evaluate whether your D2C ad spend cannibalized marketplace organic discovery or if a specific influencer campaign drove direct traffic.

B. Net Sales vs Net Margin

This dual-axis visualizer plots Net Sales (tan vertical bars) against Net Margin (green line overlay):

• The Insight: High sales days do not always equal high profit days. If Net Sales shoots up by 2× on a promotion day but the Net Margin curve stays flat or dips, you are giving away margin through excessive discounting, expensive expedited shipping, or low-margin product mixes.
• Drilldown: Click Open Order P&L > in the top-right corner of the card to inspect line-item profitability down to the individual order level.

---

3. Performance & Margin Reconciliation

The middle section of the dashboard exposes where revenue leaks occur, which geographies buy the most, and which product categories drive your catalog.

Sales Summary waterfall reconciliation, top performing states, and category share

A. The Sales Summary Waterfall

In multi-channel e-commerce, money leaks at multiple stages between customer intent and bank settlement. The Sales Summary Table provides a transparent reconciliation:

Stage	What It Measures	Business Impact
Gross Sales	Total order volume placed (e.g., ₹12,42,685 across 163 orders).	Unconstrained demand signal.
Discounts	Total promotional savings granted (e.g., −₹2,49,000).	Measures discount dependency and margin erosion.
Cancelled Orders	Orders cancelled before dispatch (e.g., 64 orders / −₹3,71,008).	Flags fake COD orders, payment gateway drop-offs, or slow warehouse packing.
Invoiced Sales	Real dispatched value (e.g., ₹6,22,677).	Revenue out the warehouse door.
Returned Orders	Delivered orders returned by customers (e.g., 12 orders / −₹1,01,774).	Sizing, quality, or expectation mismatches.
RTO Orders	Shipments undelivered and returned to origin (e.g., 1 order / −₹14,399).	Customer unavailability, incorrect address, or buyer remorse.
Net Sales	Final retained sales (e.g., ₹5,06,504).	Real revenue that pays your bills.
Shipping & Return Fees	Direct logistics costs deducted.	Friction costs of fulfillment.

The Silent Margin Killer: Notice in the example data that out of ₹12.42L in gross orders, ₹6.2L was lost to discounts and pre-dispatch cancellations alone, and another ₹1.16L was lost to customer returns and RTOs. Tracking only gross sales would make this business appear 2.4× larger than its real bankable revenue!

B. Top Performing States & Categories

• Top States: Ranks order volume and revenue by state (e.g., Gujarat with 18 orders / ₹95.3K, Maharashtra with 13 orders / ₹85.9K). Cross-reference this with courier delivery SLAs to see where to place regional warehouse inventory.
• Top Categories: Shows percentage contribution by catalog category (e.g., COMBO accounting for 50.8% of sales at ₹2.57L, followed by Necklaces at 19.1% and Earrings at 18.7%). When bundles/combos dominate, your AOV remains high and amortizes fixed shipping costs.

---

4. Unit Economics: COD vs. Prepaid & Channel Mix

Cash flow and unit economics vary wildly depending on how customers pay and where they purchase. Brandstack isolates these economics into dedicated scorecards:

COD vs. Prepaid unit economics comparison and channel net margin mix

A. COD vs. Prepaid Economics

Cash on Delivery (COD) remains the backbone of Indian e-commerce, but it carries higher working capital drag, customer refusal risk, and RTO expenses:

Metric	COD Orders	Prepaid Orders	Strategic Takeaway
Net Margin %	58.8%	59.0% (HIGHER MARGIN)	Prepaid yields higher clean margins.
Share of Orders	30.1% (49 orders)	69.9% (114 orders)	A healthy prepaid-dominant mix protects cash flow.
Net Sales	₹1,21,107	₹3,85,397	76.1% of revenue is prepaid.
COGS	₹49,860	₹1,58,215	Direct inventory replacement cost.
Net Margin	₹71,247	₹2,27,182	Bankable gross profit.
RTO Rate	2.0%	0.0%	Prepaid orders have zero RTO loss.

Founder Action: When COD RTO climbs above 10%, implement automated WhatsApp confirmation, address validation, or offer a 5% discount to switch buyers to UPI/Prepaid at checkout.

B. Channel Mix Scorecard

Ranks each sales channel by its Net Sales contribution and Net Margin %:

1. Shopify (D2C): ₹2,69,975 net sales · 59.0% margin (Highest volume and healthy direct margin).
2. Myntra: ₹1,08,160 net sales · 58.8% margin (High fashion volume with predictable commissions).
3. Amazon: ₹70,587 net sales · 58.4% margin.
4. Eternz: ₹47,936 net sales · 59.2% margin.
5. Flipkart: ₹9,846 net sales · 59.4% margin.

Comparing net margins across channels tells you where to allocate inventory when stock is constrained.

---

5. Operations, Returns & The State Action Matrix

The bottom section of the dashboard safeguards your business against reverse-logistics bleed.

Operational intelligence: Returns by channel, top return reasons, return SKUs, and highest RTO states

A. Returns by Channel

Not all channels experience the same customer behavior. In this breakdown:

• Shopify: 10 returns out of 87 orders (11.5% return rate — highlighted in amber). D2C customers often order multiple sizes or change their minds.
• Amazon: 1 return out of 23 orders (4.3% return rate).
• Myntra: 1 return out of 29 orders (3.4% return rate).
• Eternz & Flipkart: 0.0% return rate.

B. Root-Cause Analysis: Return Reasons & Top Return SKUs

• Top Return Reasons: Pinpoints why customers are sending products back (Unspecified, Customer Cancellation, Restocking Fee, Duplicate Order).
• Top Return SKUs: Identifies your highest-return individual products:
  • Meenakari Chandbali: 2 returns totaling ₹8,998
  • Layered Gold Chain: 2 returns totaling ₹8,598
  • Pearl Midi Ring, Slim Stack Bangles, Kundan Cocktail Ring

Watch Out for Trojan Horse SKUs: A product may be your top seller by gross volume, but if it has a 25% return rate, reverse logistics charges and damaged packaging will silently destroy its profitability. Check this table weekly to identify products needing sizing guides, better imagery, or sturdier packaging.

C. Highest RTO States (State Action Matrix in Action)

Return to Origin (RTO) occurs when a courier cannot deliver a parcel (customer refused, incorrect phone number, fake address). You pay forward shipping, reverse shipping, and tie up stock:

State	RTO Count	RTO %	Recommended Action
Madhya Pradesh	2	33.3%	🚨 High Risk: Restrict COD or mandate OTP verification.
Uttar Pradesh	2	22.2%	🚨 High Risk: Require prepaid or pre-call customer before dispatch.
West Bengal	1	14.3%	⚠️ Monitor: Route only via top-performing courier partners.
Karnataka	1	10.0%	Standard processing.
Rajasthan	1	10.0%	Standard processing.

---

6. Interactive Features: Inline AI & Instant Drilldown

Every card on the dashboard is interactive:

[ Card Header ] ---------------------------- [ Filter ⌄ ] [ View detail > ] [ ✨ AI ]

1. The Inline AI Sparkle (✨): Click the sparkle icon on any card to ask natural-language questions directly about that card’s data without switching to a different tab.
   • Examples:
     • “Why did cancellations spike on September 14?”
     • “Which pin codes in Madhya Pradesh caused the 33% RTO?”
     • “Which ad campaign drove the COMBO category sales?”
2. One-Click Drilldowns: Click View detail >, Open Order P&L >, or Open Scorecard > to jump straight into the full ledger backing any number.
3. Date & Channel Scoping: Use the global date picker in the top-right header to switch between Today, Last 7 days, Last 30 days, or custom accounting quarters.

---

7. The Founder’s 3-Minute Morning Routine

Follow this quick morning checklist to stay completely on top of your brand:

1. Step 1: Check Invoiced vs Net Sales (Top Strip)

   Look at the gap between Invoiced Sales and Net Sales. If the gap is widening, returns or RTOs are compounding.

2. Step 2: Review Cancellations & Returns (Sales Summary)

   Check if pre-dispatch cancellations spiked yesterday. If so, inspect whether payment gateway OTPs failed or warehouse dispatch was delayed.

3. Step 3: Check COD vs. Prepaid RTO

   Ensure COD RTO remains under your tolerance threshold (e.g. under 8%). If COD RTO is spiking, check which states are responsible.

4. Step 4: Inspect High-RTO States & Return SKUs

   If any state exceeds 20% RTO or a specific SKU accounts for multiple returns, notify your fulfillment team to hold dispatches or require customer phone confirmation.