Dashboard
■ OVERVIEW
💰 Sales by channel LiveUpdated —
| Channel | Today | This month (MTD) | Daily avg (month) | Last month | Last 7 days |
|---|---|---|---|---|---|
| Loading channel breakdown… | |||||
| Total | — | — | — | — | |
TOTAL STORE SALES
—
Previous period —
Previous year —
TOTAL ADVERTISING COST
—
Previous period —
Previous year —
ORDERS
—
Previous period —
Previous year —
BLENDED ROAS
—
Previous period —
Previous year —
Check-ins today
—
Promoters checked in
Units sold today
—
Across all channels
Revenue today
—
All channel entries
Attendance today
—
Promoters on shift
Out of stock alerts
—
Store × SKU pairs
💰 Sales · Primary + Secondary
Loading…
🟦 Primary total
—
Curio invoiced revenue (Zoho)
🟩 Secondary total
—
Reached end consumer (portals)
🟨 Buffer (Primary − Secondary)
—
Stock sitting at chain warehouses
🟦 PRIMARY · by channel
Curio → Buyer · invoice booked
🟩 SECONDARY · by channel
Product → Consumer · sell-through
Activity today
No activity yet today.
Check-ins, submissions and alerts will appear here in real time.
Check-ins, submissions and alerts will appear here in real time.
Needs your attention
No alerts right now.
Real-time alerts (stock, attendance, payments) appear here as your team submits data.
Real-time alerts (stock, attendance, payments) appear here as your team submits data.
Check-ins today
📭
No data yet
This section populates as data flows in via the entry apps.
Attendance
📭
No data yet
This section populates as data flows in via the entry apps.
Closing stock
📭
No data yet
This section populates as data flows in via the entry apps.
Deliveries
📭
No data yet
This section populates as data flows in via the entry apps.
Shelf photos
📭
No data yet
This section populates as data flows in via the entry apps.
Sales log
📭
No data yet
This section populates as data flows in via the entry apps.
Monthly totals
📭
No data yet
This section populates as data flows in via the entry apps.
Promoters
LS
Laxmi Sharma
+91 88261 38871 · lovelysharma882613@gmail.com · MB Saket, MB Kailash Colony
LV
Laxmi Verma
+91 89200 01057 · laxmiverma87800@gmail.com · MB Dwarka Sec 21, Aap Ka Bazar Sec 12, Aap Ka Bazar Sec 21
A
Anjali
+91 93113 10547 · ahanasharma0026@gmail.com · MB Arjun Marg, MB Cyberhub
3 promoters covering 7 stores. Remaining 12 modern-trade stores are office-entry only (store manager sends daily report, office team enters).
Stores
🏬 Modern Bazaar 11 stores
| Code | Store | City | Promoter | Status | |
|---|---|---|---|---|---|
| MB001 | MB Saket | Delhi | LS Laxmi Sharma | Active | |
| MB002 | MB Vasant Vihar | Delhi | Office-entered | 📨 Office entry | |
| MB003 | MB Green Park | Delhi | Office-entered | 📨 Office entry | |
| MB004 | MB New Friends Colony | Delhi | Office-entered | 📨 Office entry | |
| MB005 | MB Kailash Colony | Delhi | LS Laxmi Sharma | Active | |
| MB006 | MB Dwarka Sec 21 | Delhi | LV Laxmi Verma | Active | |
| MB007 | MB Civil Lines | Delhi | Office-entered | 📨 Office entry | |
| MB008 | MB Cyberhub | Gurgaon | A Anjali | Active | |
| MB009 | MB Arjun Marg | Gurgaon | A Anjali | Active | |
| MB010 | MB SS Plaza | Gurgaon | Office-entered | 📨 Office entry | |
| MB011 | MB World Mark Sector 65 | Gurgaon | Office-entered | 📨 Office entry |
🏬 Le Marche 6 stores
| Code | Store | City | Promoter | Status | |
|---|---|---|---|---|---|
| LM001 | LM Chattarpur | Delhi | Office-entered | 📨 Office entry | |
| LM002 | LM Promenade Vasant Kunj | Delhi | Office-entered | 📨 Office entry | |
| LM003 | LM South Point Mall | Gurgaon | Office-entered | 📨 Office entry | |
| LM004 | LM Good Earth | Gurgaon | Office-entered | 📨 Office entry | |
| LM005 | LM Camelias | Gurgaon | Office-entered | 📨 Office entry | |
| LM006 | LM Galleria | Gurgaon | Office-entered | 📨 Office entry |
🏬 Aap Ka Bazar 2 stores
| Code | Store | City | Promoter | Status | |
|---|---|---|---|---|---|
| AB001 | Aap Ka Bazar Sec 21 | Gurgaon | LV Laxmi Verma | Active | |
| AB002 | Aap Ka Bazar Sec 12 | Gurgaon | LV Laxmi Verma | Active |
Data source mix: 7 stores covered by 3 promoters (📱 daily counts + attendance via app) · 12 stores report via office entry (📨 store manager sends sales, office team enters). You can convert any store to promoter mode by assigning one on the Promoters page. See for the daily entry queue.
Products
| Category | Product | Size | SKU Code | COP | Old MRP (pre-rollout) | Current MRP | Total stock | |
|---|---|---|---|---|---|---|---|---|
| 🫒 Cold Pressed Oils | Walnut Oil | 100 ml | OIL-WO-100 | ₹186 | ₹1,200 | ₹1,200 | 86 | |
| Walnut Oil | 250 ml | OIL-WO-250 | ₹331 | ₹3,000 | ₹3,000 | 42 | ||
| Apricot Oil | 100 ml | OIL-APO-100 | ₹186 | ₹1,200 | ₹1,200 | 74 | ||
| Apricot Oil | 250 ml | OIL-APO-250 | ₹331 | ₹3,000 | ₹3,000 | 35 | ||
| Almond Oil | 100 ml | OIL-ALO-100 | ₹134 | ₹1,155 | ₹1,155 | 98 | ||
| Almond Oil | 250 ml | OIL-ALO-250 | ₹201 | ₹2,800 | ₹2,800 | 51 | ||
| Mustard Oil | 500 ml | OIL-MO-500 | ₹196 | ₹430 | ₹650 ↑ | 142 | ||
| 🌰 Dry Fruits | Walnuts | 250 g | DRF-KW-250 | ₹317 | ₹700 | ₹1,000 ↑ | 128 | |
| Walnuts | 500 g | DRF-KW-500 | ₹587 | ₹1,200 | ₹1,800 ↑ | 85 | ||
| Walnuts | 1 kg | DRF-KW-1000 | ₹1,062 | ₹2,300 | ₹3,600 ↑ | 40 | ||
| Almond | 250 g | DRF-KA-250 | ₹350 | ₹750 | ₹1,000 ↑ | 105 | ||
| Almond | 500 g | DRF-KA-500 | ₹587 | ₹1,300 | ₹1,950 ↑ | 70 | ||
| Almond | 1 kg | DRF-KA-1000 | ₹1,062 | ₹2,500 | ₹3,600 ↑ | 32 | ||
| Apricot | 250 g | DRF-LA-250 | ₹287 | ₹600 | ₹950 ↑ | 98 | ||
| Apricot | 500 g | DRF-LA-500 | ₹462 | ₹1,150 | ₹1,550 ↑ | 55 | ||
| Apricot | 1 kg | DRF-LA-1000 | ₹812 | ₹2,300 | ₹2,700 ↑ | 28 | ||
| 🌸 Saffron | Kashmir Saffron Mogra A+ | 1 g | SAF-MGA-1 | ₹299 | ₹545 | ₹700 | 156 | |
| Kashmir Saffron Mogra A+ | 2 g | SAF-MGA-2 | ₹535 | ₹1,100 | ₹1,400 ↑ | 76 | ||
| 🧈 Ghee | Himalayan Badri Cow Ghee | 250 ml | GHE-HBG-250 | ₹329 | ₹800 | ₹1,100 ↑ | 142 | |
| Himalayan Badri Cow Ghee | 500 ml | GHE-HBG-500 | ₹541 | ₹1,400 | ₹1,800 ↑ | 112 | ||
| 🍯 Artisanal Honey | Multi-Floral Honey | 250 g | HON-MF-250 | ₹171 | ₹350 | ₹550 ↑ | 168 | |
| Multi-Floral Honey | 500 g | HON-MF-500 | ₹221 | ₹650 | ₹650 | 98 | ||
| Mono-Floral Borage | 250 g | HON-BOR-250 | ₹171 | ₹375 | ₹550 ↑ | 122 | ||
| Mono-Floral Borage | 500 g | HON-BOR-500 | ₹221 | ₹750 | ₹750 | 62 | ||
| Mono-Floral Sidr | 250 g | HON-SID-250 | ₹196 | ₹700 | ₹750 ↑ | 88 | ||
| Mono-Floral Sidr | 500 g | HON-SID-500 | ₹271 | ₹1,400 | ₹1,400 | 44 | ||
| Multifloral Black Forest | 250 g | HON-BF-250 | ₹196 | ₹600 | ₹650 ↑ | 105 | ||
| Multifloral Black Forest | 500 g | HON-BF-500 | ₹271 | ₹1,100 | ₹1,100 | 58 | ||
| 🍵 Tea & Infusions | Kashmir Qahwa | 150 g | TEA-KQ-150 | ₹238 | ₹550 | ₹650 ↑ | 125 | |
| Zafrani Kehwa | 200 g | TEA-ZK-200 | ₹206 | ₹550 | ₹650 ↑ | 108 | ||
| Himalayan Chamomile Tea | 50 g | TEA-HC-50 | ₹188 | ₹550 | ₹650 ↑ | 84 |
31 SKUs across 6 categories · Source: Profitability Analysis Curio.xlsx · New MRP is live — old MRP shown for historical reference only
Alerts sent
📭
No data yet
This section populates as data flows in via the entry apps.
Inventory · Live from Zoho
Factory Inventory
Items tracked
—
from Zoho Inventory
Out of stock
—
need reorder
Open POs (purchases in pipeline)
—
—
Open SOs (dispatches)
—
—
Stock on hand · tracked items
| Item | SKU | Unit | On hand | Reorder lvl | Status |
|---|---|---|---|---|---|
| Loading… | |||||
Purchases in pipeline
| PO # | Vendor | Delivery | Qty due | Total | Status |
|---|---|---|---|---|---|
| Loading… | |||||
Dispatches (sales orders)
| SO # | Customer | Shipment | Qty | Total | Status |
|---|---|---|---|---|---|
| Loading… | |||||
Legacy stock view (static)
Total stock in hand
₹32.77L
Raw + packaging + finished
Finished goods (ready to ship)
₹15.78L
1,552 units across 20 SKUs
Raw materials
₹10.29L
Oils · Nuts · Honey · Tea
Packaging inventory
₹8.86L
Labels · Boxes · Bottles · Caps
Finished — critical stock
7 SKUs
Chamomile 50g · Ladakh Apricot 500g · Kashmir Almond 500g
Zero-stock raw materials
4
Apricot Oil · Ghee · Saffron · Mono-Floral Borage
Zero-stock finished
3 SKUs
Walnut Oil 100/250 · Apricot Oil 250
Ready for production
12 SKUs
Raw + packaging both available
Finished goods · Ready to ship 20 SKUs · ₹15,78,015
From your 17 Jul stock statement. Red rows = zero or critically low. Amber = low but manageable. Green = healthy.
| Category | Product | Size | Units on hand | Value (₹) | Status |
|---|---|---|---|---|---|
| 🫒 Oils | Almond Oil | 100 ml | 43 | ₹49,665 | Healthy |
| Almond Oil | 250 ml | 44 | ₹1,23,200 | Healthy | |
| Walnut Oil | 100 ml | 0 | ₹0 | OUT OF STOCK | |
| Walnut Oil | 250 ml | 0 | ₹0 | OUT OF STOCK | |
| Apricot Oil | 100 ml | 13 | ₹15,600 | Very low | |
| Apricot Oil | 250 ml | 0 | ₹0 | OUT OF STOCK | |
| Mustard Oil | 500 ml | 268 | ₹1,74,200 | Healthy | |
| 🌰 Dry Fruits | Kashmir Almonds 500g | 500 g | 5 | ₹9,750 | Critical |
| Kashmir Walnuts 500g | 500 g | 41 | ₹73,800 | Healthy | |
| Ladakh Apricot 500g | 500 g | 3 | ₹4,650 | Critical | |
| 🌸 Saffron | Kashmir Saffron | 1 g | 402 | ₹2,81,400 | Healthy |
| Kashmir Saffron | 2 g | 5 | ₹7,000 | Critical | |
| 🧈 Ghee | Himalayan Badri Cow Ghee | 500 ml | 87 | ₹1,56,600 | Healthy |
| 🍵 Tea | Kashmir Qahwa | 150 g | 8 | ₹5,200 | Very low |
| Zafrani Kehwa | 200 g | 32 | ₹20,800 | Healthy | |
| Himalayan Chamomile Tea | 50 g | 1 | ₹650 | CRITICAL — 1 unit | |
| 🍯 Honey | Multi-Floral Honey | 500 g | 76 | ₹49,400 | Healthy |
| Mono Floral Borage | 500 g | 90 | ₹67,500 | Healthy | |
| Black Forest | 500 g | 104 | ₹1,14,400 | Healthy | |
| Sidr | 500 g | 303 | ₹4,24,200 | Healthy | |
| Total finished goods | 1,552 units | ₹15,78,015 | |||
🚨 Top production priorities — from real inventory
URGENT (out of stock and selling):
BLOCKED (raw material at zero):
1. Chamomile Tea 50g — only 1 finished pack. Raw + box + cap all available. Pack today.
2. Ladakh Apricot 500g — 3 units. Apricots raw + box available. Production run needed.
3. Kashmir Almond 500g — 5 units. Almonds (A+ 10kg + B 168 pieces) + box available. Pack this week.
4. Kashmir Saffron 2g — 5 units. But 0g raw saffron — can't produce. Source saffron urgently.
5. Kashmir Qahwa 150g — 8 units. Raw + box available. Pack this week.
BLOCKED (raw material at zero):
🔹 Apricot Oil — 0 kg raw. Finished 100ml at 13 units, 250ml at 0. Order pressing soon.
🔹 Himalayan Badri Cow Ghee — 0 kg raw. Order milk supply.
🔹 Mono-Floral Borage Honey — 0 kg raw. Source barrel.
🔹 Kashmir Saffron Mogra A+ — 0 g raw. Source Mogra threads.
🔹 100ml glass bottles — 0 in stock. Blocks Walnut / Almond / Apricot Oil 100ml production even if raw material was available.
Production
⚠️ DATA PENDING · Batch numbers and dates below are illustrative. Dheeraj will start entering real daily production via the Factory Entry app once the system goes live. Until then, treat these batches as sample UI only.
📭
No data yet
This section populates as data flows in via the entry apps.
Dispatches & Invoices · Live from Zoho
Dispatches & Invoices
Open sales orders
—
to dispatch
Open purchase orders
—
to receive
Awaiting dispatch value
—
pipeline
Awaiting receipt value
—
committed spend
Sales orders · dispatches pipeline
| SO # | Customer | Date | Shipment | Qty | Shipped | Total | Status |
|---|---|---|---|---|---|---|---|
| Loading from Zoho… | |||||||
Purchase orders · incoming shipments
| PO # | Vendor | Date | Delivery | Qty due | Received | Total | Status |
|---|---|---|---|---|---|---|---|
| Loading from Zoho… | |||||||
Store reports
📭
No data yet
This section populates as data flows in via the entry apps.
Blinkit
■ BLINKIT OVERVIEW
TOTAL SALES
—
Previous period —
Previous year —
UNITS SOLD
—
Previous period —
Previous year —
STORES COVERED
262
of 339 approved 77%
77 empty of 339
FILL RATE
—
10 SKUs flagged low !
Sellable 2,746 units
■ BLINKIT PERFORMANCE · PAID vs ORGANIC MIX —
—
Full monthly table below in Blinkit Ads · Spend · ROAS · TACoS.
Loading current-month status…
Portal snapshot · 13 Oct 2026
Live from Blinkit Seller Hub Snapshot
Active SKUs on Blinkit
12
10 flagged "Low Inventory"
Sellable stock (total)
2,746
Dark 2,254 · WH 168 · Transit 324
Live cities
45
of 200 checked (top metros all covered)
Darkstores holding stock
262
77 empty of 339 approved · 77%
📢 Blinkit Ads · Spend · ROAS · TACoS Loading…
Ad spend (latest)
—
—
Ad sales (latest)
—
—
Organic sales (latest)
—
—
ROAS (latest)
—
—
TACoS (latest)
—
Ad spend as % of total
| Month | Total sales | Ad spend | Ad sales | Organic sales | ROAS | TACoS | AOV |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Unsellable stock at Blinkit · needs recovery
| Reason | Units | Action |
|---|---|---|
| Lost at Blinkit | 448 | Raise reconciliation with Blinkit — money they owe |
| Near expiry | 400 | Rotate or discount — Ladakh Apricots 151, Kashmir Almonds 111 |
| Expired | 159 | Write off |
| Customer returned + damaged + recall-in-progress | — | Review per-SKU |
SKUs on Blinkit · stock, expansion, 30-day sales 12 SKUs
| SKU | Level | MRP | Darkstore | Warehouse | Incoming | Near-exp | Lost | Sales 30d | Health |
|---|---|---|---|---|---|---|---|---|---|
| Kashmir Qahwa Green Tea (Saffron Spice) | L3 | ₹650 | 29 | 0 | 492 | 2 | 53 | 2 | Low |
| Kashmir Saffron Mongra (Pure Threads) | L4 | ₹700 | 106 | 1 | 0 | 31 | 58 | 86 | Low |
| Cold Pressed Almond Oil | L3 | ₹1,155 | 114 | 0 | 469 | 16 | 13 | 14 | Low |
| Raw Monofloral Honey (Single Origin) | L3 | ₹750 | 128 | 8 | 0 | 18 | 1 | 21 | Low |
| Kashmir Zafrani Kehwa Green Tea (Saffron) | L3 | ₹650 | 158 | 2 | 357 | 1 | 144 | 19 | Low |
| Ladakh Apricots (Sun Dried) | L3 | ₹1,550 | 160 | 21 | 0 | 151 | 44 | 38 | Expiry risk |
| Chamomile Herbal Infusion (Himalayan) | L3 | ₹650 | 202 | 15 | 343 | 3 | 29 | 28 | Low |
| Wild Floral Honey (Raw Multi Flower) | L3 | ₹650 | 259 | 23 | 338 | 15 | 52 | 57 | OK |
| Cold Pressed Walnut Oil | L3 | ₹1,200 | 265 | 18 | 310 | 18 | 30 | 31 | Low |
| Cow Ghee (Himalayan Badri) | L3 | ₹1,800 | 265 | 1 | 0 | 11 | 3 | 7 | Low |
| Kashmir Almonds (Premium Mamra) | L4 | ₹1,950 | 266 | 28 | 431 | 111 | 2 | 52 | Expiry risk |
| Cold Pressed Apricot Oil | L3 | ₹1,200 | 302 | 51 | 94 | 23 | 19 | 11 | Low |
Coverage · live cities & darkstore fill rate 45 live cities
| City | Active SKUs | Darkstores w/ stock | Total darkstores | Fill rate |
|---|---|---|---|---|
| Bengaluru | 15 | 54 | 78 | 69% |
| Delhi | 15 | 39 | 45 | 87% |
| Hyderabad | 15 | 28 | 40 | 70% |
| HR-NCR (Gurgaon) | 15 | 21 | 22 | 95% |
| Chennai | 15 | 17 | 23 | 74% |
| Ahmedabad | 13 | 15 | 18 | 83% |
| Jaipur | 15 | 9 | 13 | 69% |
| Indore | 14 | 7 | 8 | 88% |
| Guwahati | 5 | 7 | 7 | 100% |
| Dehradun | 15 | 5 | 8 | 63% |
| Agra | 15 | 4 | 5 | 80% |
| Faridabad | 15 | 5 | 5 | 100% |
| Bhopal | 14 | 5 | 5 | 100% |
| Jalandhar | 15 | 2 | 5 | 40% |
| Bhubaneswar | 5 | 3 | 4 | 75% |
| Jamshedpur | 5 | 3 | 4 | 75% |
| Gorakhpur | 15 | 1 | 4 | 25% |
| Amritsar | 15 | 1 | 3 | 33% |
| Aligarh | 11 | 1 | 3 | 33% |
| Goa | 11 | 2 | 3 | 67% |
Legacy YTD view (from Sales_Blinkit sheet)
YTD Total
…
Loading from sheet
Peak month
…
Loading
This month
…
Loading
Growth
…
Loading
Blinkit monthly trajectory · Dec 2025 – Aug 2026 Real · from Upriver Tracker
Live from Sales_Blinkit_Monthly sheet. Refreshes on every dashboard load.
| Metric | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug (7d) |
|---|---|---|---|---|---|---|---|---|---|
| Total Sales (₹) | 99,810 | 1,39,435 | 2,68,065 | 2,47,880 | 5,39,390 | 11,28,705 | 9,09,195 | 10,09,540 | 2,60,715 |
| Total Units | 107 | 149 | 293 | 250 | 511 | 986 | 803 | 818 | 191 |
| Net Sales | 44,790 | 1,07,791 | 87,115 | 1,96,665 | 2,59,848 | 8,43,605 | 9,09,195 | 10,09,540 | 2,41,930 |
| Organic Sales | 84,365 | 83,065 | 2,11,605 | 1,60,740 | 3,81,115 | 9,60,475 | 6,80,100 | 6,76,085 | 2,25,115 |
| Direct Ad Sales | 15,445 | 56,370 | 56,460 | 87,140 | 1,58,275 | 1,68,230 | 2,29,095 | 3,33,455 | 35,600 |
| Total Ad Spend | 13,677 | 34,660 | 26,653 | 69,485 | 1,08,407 | 1,11,997 | 1,12,379 | 96,965 | 13,056 |
| TACOS | 13.7% | 24.9% | 9.9% | 28.0% | 20.1% | 9.9% | 12.4% | 9.6% | 5.0% |
| ACOS | 88.6% | 61.5% | 47.2% | 79.7% | 68.5% | 66.6% | 49.1% | 29.1% | 36.7% |
| ROAS | 1.13 | 1.63 | 2.12 | 1.25 | 1.46 | 1.50 | 2.04 | 3.44 | 2.73 |
| AOV | 933 | 936 | 915 | 992 | 1,056 | 1,145 | 1,132 | 1,234 | 1,365 |
📅 Daily sales · current month · SKU-wise Loading…
Aggregating from Sales_Blinkit raw entries…
Sales by product — Qty and Amount (₹) Table 1 · 15 products
Blinkit reports by product name (aggregated across pack sizes). Monthly columns + last 5 days on the right.
| Product | May | June | July MTD | 11 Jul | 12 Jul | 13 Jul | 14 Jul | 15 Jul | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qty | Amt | Qty | Amt | Qty | Amt | Qty | Amt | Qty | Amt | Qty | Amt | Qty | Amt | Qty | Amt | |
| Black Forest Honey | 25 | 27,500 | 46 | 50,600 | 26 | 28,600 | 1 | 1,100 | 4 | 4,400 | 1 | 1,100 | 2 | 2,200 | 2 | 2,200 |
| Cold Pressed Almond Oil | 43 | 49,710 | 11 | 12,705 | 9 | 10,395 | 0 | 0 | 0 | 0 | 1 | 1,155 | 0 | 0 | 0 | 0 |
| Cold Pressed Apricot Oil | 21 | 25,200 | 4 | 4,800 | 8 | 9,600 | 0 | 0 | 1 | 1,200 | 0 | 0 | 0 | 0 | 1 | 1,200 |
| Cold Pressed Walnut Oil | 23 | 24,200 | 28 | 33,600 | 32 | 38,400 | 2 | 2,400 | 5 | 6,000 | 2 | 2,400 | 4 | 4,800 | 1 | 1,200 |
| Cow Ghee (Himalayan Badri) | 34 | 59,800 | 12 | 21,200 | 5 | 8,600 | 1 | 1,800 | 1 | 1,400 | 0 | 0 | 0 | 0 | 0 | 0 |
| Himalayan Chamomile Herbal Infusion | 52 | 33,400 | 40 | 25,900 | 27 | 17,550 | 2 | 1,300 | 3 | 1,950 | 0 | 0 | 1 | 650 | 3 | 1,950 |
| Kashmir Almonds (Premium Mamra) | 161 | 304,350 | 116 | 226,200 | 61 | 118,300 | 6 | 11,700 | 2 | 3,900 | 5 | 9,750 | 3 | 5,850 | 4 | 7,800 |
| Kashmir Qahwa Green Tea (Saffron Spice) | 57 | 42,500 | 22 | 14,100 | 10 | 6,500 | 0 | 0 | 2 | 1,300 | 1 | 650 | 0 | 0 | 0 | 0 |
| Kashmir Saffron Mongra (Pure Threads) | 225 | 157,145 | 229 | 159,990 | 78 | 54,600 | 9 | 6,300 | 4 | 2,800 | 2 | 1,400 | 3 | 2,100 | 8 | 5,600 |
| Kashmir Walnuts | 90 | 161,750 | 81 | 143,400 | 48 | 86,400 | 6 | 10,800 | 3 | 5,400 | 5 | 9,000 | 2 | 3,600 | 2 | 3,600 |
| Kashmir Zafrani Kehwa Green Tea (Saffron) | 59 | 38,150 | 31 | 19,950 | 12 | 7,700 | 2 | 1,300 | 1 | 650 | 1 | 650 | 1 | 650 | 0 | 0 |
| Ladakh Apricots (Sun Dried) | 25 | 35,700 | 37 | 55,900 | 35 | 54,000 | 3 | 4,650 | 2 | 3,100 | 4 | 6,150 | 4 | 6,200 | 4 | 6,100 |
| Raw Monofloral Honey (Single Origin) | 49 | 36,750 | 17 | 12,750 | 6 | 4,500 | 0 | 0 | 0 | 0 | 1 | 750 | 0 | 0 | 0 | 0 |
| SIDR Honey | 71 | 99,400 | 59 | 82,600 | 35 | 49,000 | 4 | 5,600 | 2 | 2,800 | 4 | 5,600 | 0 | 0 | 3 | 4,200 |
| Multi-Floral Honey (Raw Multi Flower) | 51 | 33,150 | 70 | 45,500 | 24 | 15,600 | 1 | 650 | 2 | 1,300 | 1 | 650 | 0 | 0 | 0 | 0 |
| Grand Total | 986 | 1,128,705 | 803 | 909,195 | 416 | 509,745 | 37 | 47,600 | 32 | 36,200 | 28 | 39,255 | 20 | 26,050 | 28 | 33,850 |
Business metrics Table 2 · Organic vs Ads, efficiency ratios
All the KPIs Blinkit tracks. Hover any metric name for the definition.
| Metric | May | June | July MTD | 11 Jul | 12 Jul | 13 Jul | 14 Jul | 15 Jul |
|---|---|---|---|---|---|---|---|---|
| Net Sales | 843,605 | 909,195 | 509,745 | 47,600 | 36,200 | 39,255 | 26,050 | 33,850 |
| Net Orders | 673 | 803 | 416 | 37 | 32 | 28 | 20 | 28 |
| Total Sales | 1,128,705 | 909,195 | 509,745 | 47,600 | 36,200 | 39,255 | 26,050 | 33,850 |
| Total Units | 986 | 803 | 416 | 37 | 32 | 28 | 20 | 28 |
| Organic Sales | 960,475 | 680,100 | 366,390 | 36,400 | 29,750 | 25,155 | 18,500 | 28,850 |
| Organic Orders | 838 | 606 | 298 | 26 | 27 | 18 | 15 | 23 |
| Review Sales | 285,100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Review Orders | 313 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Ads Units | 148 | 197 | 118 | 11 | 5 | 10 | 5 | 5 |
| Direct Ad Sales | 168,230 | 229,095 | 143,355 | 11,200 | 6,450 | 14,100 | 7,550 | 5,000 |
| Total Ad Spend | 111,997 | 112,379 | 48,322 | 3,373 | 3,223 | 3,169 | 3,222 | 3,152 |
| TACOS | 9.9% | 12.4% | 9.5% | 7.1% | 8.9% | 8.1% | 12.4% | 9.3% |
| ACOS | 66.6% | 49.1% | 33.7% | 30.1% | 50.0% | 22.5% | 42.7% | 63.0% |
| Direct Sales ROAS | 1.50 | 2.04 | 2.97 | 3.32 | 2.00 | 4.45 | 2.34 | 1.59 |
| ROI | 7.53 | 8.09 | 10.55 | 14.11 | 11.23 | 12.39 | 8.09 | 10.74 |
| Ads Contribution | 14.9% | 25.2% | 28.1% | 23.5% | 17.8% | 35.9% | 29.0% | 14.8% |
| AOV | 1,145 | 1,132 | 1,225 | 1,286 | 1,131 | 1,402 | 1,303 | 1,209 |
🚨 Blinkit feeder warehouse inventory 6 SKUs OUT · Sales blocked
Stock we've shipped to Blinkit's 9 feeder warehouses, from where they replenish dark stores. When feeder = 0, dark stores can't restock, sales stop. Currently only 149 units total across 9 feeders — dangerously low.
| SKU | Faridabad | Hyderabad H3 | Jaipur J3 | Kolkata K6 | Mumbai M12 | Kundli | Lucknow L4 | Nagpur N1 | Noida N1 | TOTAL | Note |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SIDR Honey | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 🩸 | Was biggest SKU · 46 cities affected |
| Cold Pressed Apricot Oil | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 🩸 | Raw material also at 0 kg |
| Cold Pressed Walnut Oil | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 🩸 | Raw walnut oil only 4 kg |
| Himalayan Chamomile Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 🩸 | Factory has only 1 finished pack |
| Kashmir Zafrani Kehwa Green Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 🩸 | |
| Ladakh Apricots (Sun Dried) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 🩸 | Factory has 3 finished packs |
| Kashmir Walnuts | — | 3 | — | — | — | — | — | — | — | 3 | Change to 15 (Hyderabad) |
| Raw Monofloral Honey | — | — | — | — | 3 | — | — | — | — | 3 | |
| Kashmir Qahwa Green Tea | — | — | — | — | 4 | — | — | — | — | 4 | |
| Cold Pressed Almond Oil | — | — | — | — | 5 | — | — | — | — | 5 | |
| Black Forest Honey | — | — | — | 4 | — | 2 | — | — | — | 6 | Below 10-15 threshold |
| Cow Ghee (Himalayan Badri) | — | — | — | 2 | 4 | 2 | — | 2 | 2 | 12 | Factory raw ghee at 0 kg |
| Kashmir Almonds (Premium Mamra) | — | — | 8 | — | — | — | 4 | 3 | — | 15 | |
| Wild Floral Honey | 6 | — | — | 2 | — | 2 | 3 | 2 | 2 | 17 | |
| Kashmir Saffron Mongra | 10 | 8 | 15 | 5 | 8 | 5 | 12 | 13 | 8 | 84 | Best distributed · Note: "Increase to 20" |
| GRAND TOTAL | 16 | 11 | 23 | 13 | 24 | 11 | 19 | 20 | 12 | 149 | Total across 9 feeders |
🩸 Immediate crisis — SIDR Honey at zero across all 9 feeders. This was your biggest Blinkit SKU (46 cities · 348 dark-store instances). Every day at zero = lost sales in ~46 cities. Push emergency dispatch to feeders THIS WEEK. Even 5-10 units per feeder buys time while you scale production.
⚠️ 5 more SKUs at feeder-zero — Apricot Oil, Walnut Oil, Chamomile, Zafrani, Ladakh Apricots. Of these, factory has some finished stock for Chamomile (1) and Ladakh Apricots (3) but not enough. Rest need production runs — but Apricot Oil and Walnut Oil are blocked by zero raw material at factory too.
What's working July MTD
Ladakh Apricots — most consistent daily performer (35 units MTD, ~5/day). Zero drop-off from June (37).
ROAS climbed from 1.50 → 2.97 across May-July. Ad spend down 57% but delivering ~85% of June's ad-driven revenue.
AOV up 8% (₹1,132 → ₹1,225) — customers buying bigger baskets even as order count fell.
Concerns July MTD
Kashmir Almonds crashed: ₹3.04L (May) → ₹2.26L (June) → ₹1.18L (MTD). Losing your best SKU.
Kashmir Saffron down 66% vs June revenue (₹1.60L → ₹0.55L). Track next 3 days closely.
ACOS spiked to 63% on 15 Jul — worst since May avg. Ads that day burned ₹3,152 for ₹5,000 ad-driven revenue.
⚠ What this page doesn't track
Blinkit reports sales, not remaining shelf stock. To know how many units are still at Blinkit warehouses, you'd need their separate stock report. Also: no per-dark-store or per-city split in the standard report — one national number. If you get city-level data separately, we can add another table below.
📡 Live from sheet — loading Sales_Amazon…
Amazon
■ AMAZON PERFORMANCE
🚀 FY27 YTD · Sales at ₹3.48L, up 326% YoY
FY27 YTD sales (Apr–Aug 13)
₹3.48L
212 units · 492 orders
Vs same period FY26
+326%
FY26 was ₹81,752 same 4.5mo
Best month
₹1.22L
May 2026 · 73 units
Worst month
₹22k
Jun 2026 · collapse from May · investigate
| Month | Sales | Units | Vs Last Year | YoY % | Trajectory |
|---|---|---|---|---|---|
| Apr 2026 | ₹97,331 | 63 | ₹4,185 | +2,225% | |
| May 2026 | ₹1,21,900 | 73 | ₹15,280 | +697% | |
| Jun 2026 ⚠️ | ₹22,020 | 11 | ₹6,935 | +217% | |
| Jul 2026 | ₹56,310 | 38 | ₹29,737 | +89% | |
| Aug 2026 (to 8/13) | ₹50,229 | 27 | ₹25,615 | +96% | |
| FY27 YTD | ₹3,47,790 | 212 | ₹81,752 | +326% | — |
🔍 The June anomaly needs investigating. Sales dropped from ₹1.22L (May) to ₹22k (June) — 82% collapse. Possible causes: out-of-stock on top SKUs, listing suppression, ads paused, review bombing. Whatever it was — May recovery in July confirms it's fixable.
Top 12 ASINs by revenue · Trailing 30 days Business Report · Aug 13
Sessions, orders, and conversion rate per SKU. Watch the CVR column — anything under 2% on high-traffic listings signals a fixable listing problem.
| SKU | Product | Sessions | Units | Revenue | CVR | Flag |
|---|---|---|---|---|---|---|
| LDAP-500 | Ladakh Apricots 500g | 6,206 | 332 | ₹3,64,514 | 5.35% | Hero SKU |
| KSAL-500 | Kashmir Sweet Almonds 500g | 4,236 | 138 | ₹1,77,195 | 3.26% | — |
| LDAP-1000 | Ladakh Apricots 1kg | 3,543 | 81 | ₹1,70,999 | 2.29% | — |
| KSWL-500 | Kashmir Walnut Kernels 500g | 2,834 | 127 | ₹1,44,375 | 4.48% | — |
| KSAL-1000 | Kashmir Sweet Almonds 1kg | 4,636 | 51 | ₹1,30,400 | 1.10% | Listing broken · fix |
| KSWL-1000 | Kashmir Walnut Kernels 1kg | 807 | 30 | ₹62,605 | 3.72% | — |
| HBCG-500 | Himalayan Badri Cow Ghee 500ml | 523 | 25 | ₹28,837 | 4.78% | Fix ad targeting |
| ALOIL-100 | Cold Pressed Almond Oil 100ml | 383 | 18 | ₹15,702 | 4.70% | — |
| APOIL-100 | Cold Wood Pressed Apricot Oil 100ml | 167 | 8 | ₹7,200 | 4.79% | — |
| KHQH-200 | Kashmiri Saffron Qahwa 200g | 98 | 13 | ₹6,725 | 13.27% | Hidden gem · boost traffic |
| WLHN-500 | Wild Himalayan Honey 500g | 180 | 13 | ₹6,454 | 7.22% | — |
| ALOIL-250 | Cold Pressed Almond Oil 250ml | 205 | 3 | ₹6,300 | 1.46% | Low CVR |
| — | Top 12 subtotal | 23,818 | 839 | ₹11,21,306 | 3.52% | — |
💡 Two SKU-level fixes with high ROI:
1. Kashmir Almonds 1kg (KSAL-1000) — 4,636 sessions but only 1.10% CVR. Amazon is sending you traffic but visitors aren't buying. Likely a price mismatch vs competitors or bad main image. Fix the listing → unlock ~₹5-8k/month more revenue.
2. Kashmiri Saffron Qahwa (KHQH-200) — 13.27% CVR is exceptional but only 98 sessions. This product converts like crazy; needs more traffic via Sponsored Products. Budget ₹2-3k/month here should double revenue.
1. Kashmir Almonds 1kg (KSAL-1000) — 4,636 sessions but only 1.10% CVR. Amazon is sending you traffic but visitors aren't buying. Likely a price mismatch vs competitors or bad main image. Fix the listing → unlock ~₹5-8k/month more revenue.
2. Kashmiri Saffron Qahwa (KHQH-200) — 13.27% CVR is exceptional but only 98 sessions. This product converts like crazy; needs more traffic via Sponsored Products. Budget ₹2-3k/month here should double revenue.
📊 Amazon Sponsored Products · FY27 🟡 Weekly CSV refresh
Campaign-level spend, sales, orders, ACOS and ROAS for FY27 (Apr 1, 2026 onwards). Refreshes when you drop the latest Amazon Ads CSV.
Loading…
—
| Campaign | Impressions | Clicks | CTR | Spend | Sales | Orders | CVR | ACOS | ROAS | Verdict |
|---|---|---|---|---|---|---|---|---|---|---|
| Waiting for first Amazon Ads CSV upload… Once loaded, this card refreshes automatically. | ||||||||||
YTD Sales (Jan–Aug)
₹6.99L
488 units · 15,370 sessions
Peak month — January
₹2.33L
204 units · 33% of YTD
June collapse
₹22k
11 units all month · listing issue?
Zero-sale days
76 / 216
35% of days · Amazon is largely idle
Amazon monthly trajectory · Jan–Aug 2026 Real · from Sales & Orders report
Daily data aggregated to months. Sales, units, sessions and conversion.
| Month | Days | Sales (₹) | Units | Sessions | Conv % | Trend |
|---|---|---|---|---|---|---|
| Jan 2026 | 31 | 2,33,128 | 204 | 5,378 | 3.79% | Peak |
| Feb 2026 | 28 | 90,030 | 60 | 2,781 | 2.16% | ↓ 61% |
| Mar 2026 | 31 | 71,046 | 35 | 2,126 | 1.65% | ↓ 21% |
| Apr 2026 | 30 | 97,331 | 63 | 1,447 | 4.35% | ↑ 37% |
| May 2026 | 31 | 1,21,900 | 73 | 2,083 | 3.50% | ↑ 25% |
| Jun 2026 | 30 | 22,020 | 11 | 612 | 1.80% | ↓ 82% 🩸 |
| Jul 2026 | 31 | 56,310 | 38 | 878 | 4.33% | ↑ 156% (from crash) |
| Aug 2026 (4 days) | 4 | 7,550 | 4 | 65 | 6.15% | Early |
| YTD Total | 216 | 6,99,315 | 488 | 15,370 | 3.18% | — |
🩸 June crash needs investigation. ₹1.22L (May) → ₹22k (Jun) = 82% drop in one month. Sessions fell from 2,083 → 612 (71%). Something suppressed your listings — Buy Box loss, review issue, listing takedown, or ad campaigns paused. Look at what changed on 31 May → 1 Jun.
⚠️ Amazon is only ₹87k/month average. Blinkit does ₹9L+/month. Amazon has 76 zero-sale days (35%). Either it's a small channel by design, or you're leaving money on the table. Best day this year was Jan 23 (₹20,405, 18 units) — that day's pattern is worth replicating.
Sales by ASIN — Latest Amazon Detail Page Sales & Traffic report 18 ASINs · Real data
One row per ASIN. Sessions = unique visitors to your product page. Buy Box % = share of pageviews where you had the featured offer. Conversion = units ÷ sessions. Sorted by revenue.
| Product | SKU | Units | Sales (₹) | Sessions | Buy Box % | Conv % |
|---|---|---|---|---|---|---|
| Ladakh Apricots (Sun Dried) | LDAP-500 | 147 | 1,66,150 | 1,764 | 99.4% | 8.3% |
| Kashmir Sweet Almonds | KSAL-500 | 101 | 1,31,105 | 3,476 | 95.6% | 2.9% |
| Kashmir Sweet Almonds (1kg) | KSAL-1000 | 45 | 1,15,800 | 4,244 | 98.3% | 1.1% |
| Ladakh Apricots (1kg) | LDAP-1000 | 41 | 89,550 | 2,453 | 99.8% | 1.7% |
| Kashmir Walnut Kernels | KSWL-500 | 62 | 74,140 | 1,256 | 99.1% | 4.9% |
| Kashmir Walnut Kernels (1kg) | KSWL-1000 | 13 | 29,050 | 333 | 100.0% | 3.9% |
| Himalayan Badri Cow Ghee | HBCG-500 | 9 | 10,640 | 170 | 99.5% | 5.3% |
| Cold Pressed Sweet Apricot Oil | APOIL-100 | 6 | 5,400 | 76 | 98.9% | 7.9% |
| Wild Himalayan Multi-Floral Honey | WLHN-500 | 6 | 2,720 | 51 | 100.0% | 11.8% |
| Kashmiri Saffron Qahwa | KHQH-200 | 7 | 3,575 | 37 | 100.0% | 18.9% |
| Cold Pressed Sweet Almond Oil | ALOIL-100 | 2 | 1,732 | 218 | 100.0% | 0.9% |
| Cold Pressed Mustard Oil | BMOIL-500 | 1 | 408 | 51 | 98.2% | 2.0% |
| Himalayan Chamomile Tea | HCT-60 | 1 | 475 | 31 | 100.0% | 3.2% |
| Kashmiri Mongra Saffron (1g) | KHSFM-1G | 1 | 700 | 42 | 100.0% | 2.4% |
| Kashmiri Mongra Saffron (2g) | KHSFM-2G | 1 | 990 | 39 | 100.0% | 2.6% |
| Black Forest Honey | BFHN-500 | 1 | 1,000 | 12 | 100.0% | 8.3% |
| SIDR Honey | SDHN-500 | 1 | 1,120 | 43 | 100.0% | 2.3% |
| Kashmir Walnut Kernels (250g) | KSWL-250 | 1 | 900 | 10 | 88.2% | 10.0% |
| Grand Total · 18 ASINs | — | 446 | 6,35,455 | 14,306 | 98.0% | 3.12% |
Conversion red flags: ALOIL-100 (Almond Oil) is burning 218 sessions at 0.92% conversion — worst on the page. Something's off with the listing (price? images? reviews?). KSAL-1000 has 4,244 sessions but only 1.06% conversion — the 1kg Kashmir Almonds page is under-monetising heavy traffic. KSWL-250 has 88% Buy Box vs 99%+ everywhere else — check for a competing seller.
🚨 Amazon FBA warehouse inventory 2 SKUs at zero · 2 more low
Stock at Amazon's fulfillment warehouses. When quantity = 0, ASIN goes "out of stock" and Amazon suppresses your listing from search. From Inventory Report dated 5 Aug 2026.
| SKU · Product | ASIN | Price (₹) | FBA Qty | Status |
|---|---|---|---|---|
| CURGIFT-1 · Gift Hamper | B0FPBLXTT8 | 3,400 | 0 🩸 | OUT OF STOCK |
| KSWL-250 · Kashmir Walnuts 250g | B0GYJBL57L | 875 | 0 🩸 | OUT OF STOCK · Buy Box already at 88% |
| KSWL-1000 · Kashmir Walnuts 1kg | B0F41DL639 | 2,700 | 5 | CRITICAL LOW · ~1 week stock |
| KSAL-1000 · Kashmir Almonds 1kg | B0F69TGFLZ | 3,100 | 45 | LOW · 4,244 sessions/period draining fast |
| LDAP-1000 · Ladakh Apricots 1kg | B0F3Z9LFJ4 | 2,800 | 107 | Healthy |
| KHSFM-2G · Saffron 2g | B0F69YZ736 | 1,100 | 199 | Healthy |
| KHSFM-1G · Saffron 1g | B0F69Y25BY | 700 | 197 | Healthy |
| KHSFM-4G · Saffron 4g | B0FH35NCGX | 1,800 | 200 | Healthy |
| KHSFM-6G · Saffron 6g | B0FH37K1KM | 2,700 | 200 | Healthy |
| ALOIL-250 · Almond Oil 250ml | B0F4TRZGPW | 2,100 | 195 | Healthy |
| APOIL-250 · Apricot Oil 250ml | B0F4T4N2QQ | 2,250 | 200 | Healthy |
| BMOIL-500 · Mustard Oil 500ml | B0F4RRVRRT | 500 | 193 | Healthy |
| WLOIL-250 · Walnut Oil 250ml | B0F4SS8L85 | 2,250 | 200 | Healthy |
🩸 Immediate: 2 SKUs OUT. Gift Hamper (₹3,400 MRP) and Kashmir Walnuts 250g both at zero — Amazon suppressing these listings from search. Send FBA replenishment shipment today. Walnut 250g had 10 sessions this report anyway (low priority); Gift Hamper is a Q4 revenue leak.
⚠️ Watch: KSWL-1000 at 5 units, KSAL-1000 at 45. KSAL-1000 has 4,244 sessions per report period — even at 1% conversion, that burns 45 units in one period. Send restock within 3 days or you lose the biggest Almond ASIN.
Amazon rollup by product family Same 18 ASINs, aggregated across pack sizes
Roll-up so you can compare Amazon head-to-head with Blinkit's product-level view. Note some product families in the Blinkit range have zero Amazon sales this period.
| Product family | Units | Sales (₹) | Share |
|---|---|---|---|
| Ladakh Apricots (500g + 1kg) | 188 | 2,55,700 | 40.2% |
| Kashmir Almonds (500g + 1kg) | 146 | 2,46,905 | 38.9% |
| Kashmir Walnuts (250g + 500g + 1kg) | 76 | 1,04,090 | 16.4% |
| Cow Ghee (Himalayan Badri) | 9 | 10,640 | 1.7% |
| Cold Pressed Apricot Oil | 6 | 5,400 | 0.9% |
| Kashmir Qahwa Green Tea | 7 | 3,575 | 0.6% |
| Multi-Floral Honey | 6 | 2,720 | 0.4% |
| Cold Pressed Almond Oil | 2 | 1,732 | 0.3% |
| Kashmir Saffron Mongra (1g + 2g) | 2 | 1,690 | 0.3% |
| SIDR Honey | 1 | 1,120 | 0.2% |
| Black Forest Honey | 1 | 1,000 | 0.2% |
| Himalayan Chamomile Tea | 1 | 475 | 0.1% |
| Cold Pressed Mustard Oil | 1 | 408 | 0.1% |
| Cold Pressed Walnut Oil | 0 | 0 | 0.0% |
| Kashmir Zafrani Kehwa Green Tea | 0 | 0 | 0.0% |
| Raw Monofloral Honey | 0 | 0 | 0.0% |
| Grand Total | 446 | 6,35,455 | 100% |
What's working Latest report
Nuts are 95% of Amazon revenue. Ladakh Apricots + Kashmir Almonds + Kashmir Walnuts = ₹6.07L of ₹6.35L. Amazon is a dry-fruit channel.
Kashmir Qahwa converts at 18.9% — highest on the page. 37 sessions, 7 buyers. If you can drive traffic here, it monetises.
Buy Box near-perfect at 98% across the top 6 SKUs. No competing seller problem to fix.
Concerns Latest report
KSAL-1000 is your traffic sink — 4,244 sessions, only 45 units, 1.06% conv. Compare to KSAL-500 (2.9%). Something on the 1kg listing is losing buyers — probably price.
3 core SKUs did zero on Amazon this period: Walnut Oil, Zafrani Kehwa, Raw Monofloral Honey. Blinkit sells all three. Either the listings are dead or the ASINs aren't live.
ALOIL-100 burning traffic — 218 sessions for 2 units. 0.92% conv. Check the listing (price, hero image, reviews).
Amazon report loaded · What's missing
Loaded your Detail Page Sales & Traffic by ASIN report — 18 ASINs, ₹6.35L, 446 units. To complete Amazon tracking, still need: Sales & Orders report by date (for month-over-month trend), Advertising report (for ROAS/ACOS/TACOS), Returns report, and Settlement/Payment reports (to reconcile the ₹4.2L Amazon owes you).
📡 Live from sheet — loading Sales_Shopify…
Shopify D2C
📅 Today vs this month Live
Today's Shopify sales
—
— orders
This month so far
—
— orders
Daily avg (month)
—
this month's run-rate
Today vs daily avg
—
—
■ SHOPIFY OVERVIEW
TOTAL STORE SALES
—
Previous period —
Previous year —
TOTAL ADVERTISING COST
—
Previous period —
Previous year —
ORDERS
—
Previous period —
Previous year —
ROAS
—
Previous period —
Previous year —
■ WEBSITE PERFORMANCE
Direct vs Ad-attributed sales Last 90 days · Session-based attribution
Sales attributed to each channel based on the referrer source of the session that converted. "Social" is dominated by Meta Ads traffic; "Direct" is repeat customers + typed-URL + SMS/WhatsApp links.
AD-ATTRIBUTED (Social + Paid)
₹40,860
~48% of total · 3,174 sessions
DIRECT
₹30,590
~36% of total · 2,354 sessions
ORGANIC SEARCH
₹6,900
~8% of total · 533 sessions
UNKNOWN
₹6,620
~8% of total · 485 sessions
Note: Shopify's own order-level referrer tags are empty for this store, so attribution uses session-source × conversion-rate. For stricter attribution, add UTM parameters to all Meta campaign links.
SKU-wise sales · last 90 days Live from Shopify Analytics
Top products by net sales across the last 90 days. Kashmir Saffron continues to dominate the Shopify mix at ~40% of revenue.
| Product | Orders | Gross (₹) | Net (₹) | Share |
|---|---|---|---|---|
| Kashmir Saffron | 29 | 39,500 | 33,791 | |
| Raw Monofloral Sidr Honey | 7 | 16,700 | 14,391 | |
| Kashmir Walnut Kernels | 4 | 14,400 | 11,876 | |
| Kashmir Sweet Almond Kernels | 2 | 9,550 | 7,897 | |
| Himalayan Badri Cow Ghee | 2 | 5,120 | 4,365 | |
| Himalayan Chamomile Tea | 1 | 4,550 | 3,674 | |
| Raw Multifloral Honey | 2 | 1,950 | 1,667 | |
| Raw Multifloral Black Forest Honey | 1 | 2,000 | 1,615 | |
| Ladakh Apricots | 1 | 1,550 | 1,399 | |
| Kashmir Qahwa | 2 | 1,300 | 1,268 | |
| Raw Monofloral Borage Honey | 1 | 1,400 | 1,131 | |
| Cold Wood Pressed Sweet Almond Oil | 1 | 1,155 | 1,097 |
Daily sales · Last 50 orders Snapshot 14 Oct 2026
Order-level revenue grouped by day. Voided + refunded orders excluded. Pulled live from Shopify Admin API — snapshot of the 50 most recent orders.
Orders (period)
—
—
Revenue (period)
—
—
Last order
—
—
Active days (of last 30)
—
days with ≥1 order
| Date | Orders | Revenue (₹) | AOV (₹) | Status mix |
|---|
📊 Paid Ads → Website Performance 🟢 Auto-syncing every 6 hours
Meta + Google ad spend joined against Shopify D2C revenue by month. Meta pulls from Graph API, Google pulls from Ads Script. Blended ROAS = Shopify revenue ÷ total ad spend. CAC = total spend ÷ Shopify orders.
Loading…
—
| Month | Meta spend | Google spend | Total ad spend | Shopify orders | Shopify revenue | Blended ROAS | CAC |
|---|---|---|---|---|---|---|---|
| Loading live data from Google Sheet… | |||||||
🚚 Shipment status · Shiprocket Live from Shipments_Shiprocket_Live
Live shipment status for every Shopify order shipped via Shiprocket. Delivered% is the true fulfilment rate; RTO% is the biggest hidden cost driver (returns cost you shipping both ways + damaged stock). Re-sync anytime: export All Orders from Shiprocket → upload here (full replace).
Loading…
—
| Month | Total | Delivered | In-transit | RTO | Cancelled | Pending | Deliv % | RTO % | COD orders | COD delivered | COD RTO'd |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading live shipment data from Shiprocket… | |||||||||||
FY27 YTD (Apr–now)
—
loading…
Last 3 months
—
—
Current month
—
—
Lifetime revenue
—
—
Shopify monthly trend · last 12 months Live
Rolling 12 months from the live shopify_monthly endpoint. Bar shows revenue relative to the best month in the window.
| Month | Orders | Revenue (₹) | AOV (₹) | Bar |
|---|---|---|---|---|
| Loading live… | ||||
Top products · Lifetime 1,351 orders
| Product | Units | Revenue |
|---|---|---|
| Himalayan Badri Cow Ghee — 500 ml | 129 | 1,62,900 |
| Kashmir Sweet Almonds — 500g | 66 | 85,800 |
| Himalayan Badri Cow Ghee — 1 Ltr | 31 | 78,750 |
| Kashmir Sweet Almonds — 1kg | 14 | 38,140 |
| Cold Pressed Sweet Almond Oil — 100ml | 23 | 26,565 |
| Raw Multifloral Honey — 500g | 12 | 7,800 |
| Cold Pressed Mustard Oil — 500ml | 18 | 7,740 |
| Kashmir Zafrani Kehwa — 250g | 7 | 3,850 |
| Kashmir Qahwa — 200g | 6 | 3,500 |
Note: unit column is only populated for orders from Jan 2025 onwards — Shopify export doesn't backfill line items for older orders. Revenue is complete for all periods.
Top cities · Lifetime
| City | Orders | Revenue |
|---|---|---|
| Mumbai | 70 | 1,29,560 |
| Hyderabad | 42 | 70,989 |
| Ahmedabad | 32 | 61,918 |
| Bangalore | 37 | 55,831 |
| Ghaziabad | 19 | 42,666 |
| Gurgaon | 25 | 39,218 |
| North West Delhi | 30 | 36,571 |
| Patna | 20 | 36,232 |
| South West Delhi | 23 | 35,381 |
| Kolkata | 26 | 34,018 |
| Others (~250 cities) | ~1,027 | ~10.30L |
Payment methods · Lifetime
| Method | Orders | Share |
|---|---|---|
| 💵 Cash on Delivery | 1,081 | 80% |
| 💳 Easebuzz | 249 | 18% |
| 💳 PayU (Cards/UPI/NB) | 20 | 1% |
80% COD is unusual for premium goods. COD orders have higher cancellation/return rates and delay cash. If you revive Shopify, prepaid discount campaigns could shift this mix and improve cash conversion.
Order status distribution
| Status | Count | Share |
|---|---|---|
| Paid | 721 | 53% |
| Pending | 597 | 44% |
| Voided | 30 | 2% |
| Refunded | 3 | <1% |
44% "pending" is high — these are COD orders not yet delivered or paid. Some will fail. Historical pattern probably means ~15-20% will eventually void.
📡 Live from sheet — loading Sales_B2B…
B2B
■ B2B OVERVIEW
TOTAL SALES
—
Previous period —
Previous year —
ACTIVE ACCOUNTS
—
Kissansay · Lulu · Daulat Ram
Metamorphosis · Udhampur · Baba Ghulam
OPEN RECEIVABLES
—
Invoices open —
60+ days —
AVG ORDER VALUE
—
100kg+ bulk · 80% of MRP
Previous period —
B2B is different from other channels: orders are one-off (not daily), volumes are large — bulk in 100 kg multiples (walnuts, almonds, apricots drums; ghee 15 kg tins; honey 25/50/100 kg drums; tea 50/100 kg sacks). Corporate gifting is a smaller secondary segment (hampers). Pricing is bespoke — typically 20% off retail equivalent, so you net ~80%.
📭
No data yet
This section populates as data flows in via the entry apps.
Modern Trade
■ MODERN TRADE OVERVIEW
TOTAL SALES
—
Previous period —
Previous year —
ACTIVE STORES
—
MB · FS · PNC · AB
4 chains · Delhi NCR + Ahmedabad
OPEN RECEIVABLES
—
Invoices open —
60+ days —
AVG INVOICE
—
Previous period —
Chain-level dispatch
⚠️ DATA PENDING · All numbers on this page are placeholders. Modern Trade daily sales for the 12 office-entry stores + the 3 promoter-assisted stores have not been loaded yet. Only the store & promoter assignments and Zoho invoice-level MT figures (via Customer Ledger) are real. Do not rely on the KPIs or tables below for decisions until data is entered.
📭
No data yet
This section populates as data flows in via the entry apps.
Customer Ledger · Live from Zoho
Customer Ledger
Total invoiced
—
—
Unique customers
—
from Zoho Books
Outstanding balance
—
—
This month
—
—
Top customers · by revenue
| Customer | Invoices | Total | Outstanding | Last invoice | Status |
|---|---|---|---|---|---|
| Loading from Zoho… | |||||
Recent invoices
| Invoice # | Customer | Date | Due date | Total | Balance | Status |
|---|---|---|---|---|---|---|
| Loading from Zoho… | ||||||
Historical reference · May – Jul 2026 (static)
Full YTD from Zoho Books — 114 customers, ₹3.44Cr net revenue. Blinkit & Kissansay together = 77% of business. 44 J&K/Kashmir traders form a real distribution network worth ₹23.3L. D2C individuals surprisingly meaningful at ₹13.6L across 41 buyers.
Monthly customer breakdown · Zoho Books Real May–Jul 2026
Invoiced sales (net of GST) by customer, by month. Blinkit invoices to different GSTINs per warehouse state — collapsed here into one Blinkit line per month.
| Customer | May 2026 | Jun 2026 | Jul 2026 | 3-month total |
|---|---|---|---|---|
| Blinkit (all 7–12 GSTINs) | 28,60,000 | 0 | 5,35,143 | 33,95,143 |
| Kissansay Agtech Pvt Ltd | 0 | 8,11,020 | 0 | 8,11,020 |
| Landcraft Retail Pvt Ltd | 0 | 1,74,365 | 0 | 1,74,365 |
| New Modern Bazaar Dept Stores | 1,20,653 | 0 | 54,600 | 1,75,253 |
| Pick N Choose Bengaluru | 16,260 | 0 | 0 | 16,260 |
| The Jammu & Kashmir Bank Ltd | 4,762 | 0 | 0 | 4,762 |
| Hamiast Global Pvt Ltd | 4,270 | 0 | 0 | 4,270 |
| D2C small customers (7 total) | 0 | 0 | 9,355 | 9,355 |
| MONTH TOTAL | 30,05,945 | 9,85,385 | 5,99,098 | 45,90,428 |
Blinkit cadence is lumpy — that's how Blink Commerce settlements work. In May they invoiced ₹28.6L across 12 GSTINs (AP, Haryana, KA, MH, Punjab, RJ, Telangana, UP, WB), then nothing in June, then ₹5.35L in July across 7 GSTINs. Cash flow forecasting needs a 2-month buffer around Blinkit receipts.
Note: April 2026 Zoho file appears to be a duplicate of July (same rows). Ask your accountant to re-export April separately.
Total invoiced YTD (net)
₹3.44Cr
114 unique customers · ~222 invoices
Blinkit YTD
₹1.37Cr
15 state GSTINs · 51 invoices
Kissansay YTD
₹1.28Cr
21 invoices · single customer
Concentration risk
77%
Blinkit + Kissansay combined
Channel split · YTD Real · 114 customers
| Channel | Customers | Invoices | Revenue | Share |
|---|---|---|---|---|
| ⚡ Blinkit (15 state GSTINs) | 15 | 51 | ₹1,36,60,448 | 39.7% |
| 💼 Kissansay (B2B) | 1 | 21 | ₹1,27,67,718 | 37.1% |
| 💼 J&K/Kashmir Traders (B2B network) | 44 | 56 | ₹23,26,055 | 6.8% |
| 💼 Lulu (B2B) | 1 | 3 | ₹19,20,500 | 5.6% |
| 🛍️ D2C individuals | 41 | 49 | ₹13,61,191 | 4.0% |
| 🏬 MT Chains (AAP KA BAZAR, MB, Pick N Choose, Hamiast) | 5 | 27 | ₹8,90,523 | 2.6% |
| 💼 Corporate B2B (3 Pvt Ltd) | 3 | 7 | ₹7,79,048 | 2.3% |
| 🏬 Landcraft (MT) | 2 | 4 | ₹5,91,385 | 1.7% |
| 🏛️ Government (DC Office Udhampur) | 1 | 1 | ₹85,636 | 0.2% |
| 🏦 J&K Bank | 1 | 3 | ₹13,343 | <0.1% |
| TOTAL YTD | 114 | 222 | ₹3,43,95,845 | 100% |
Two customers = 75% of business. Kissansay (₹1.34Cr) + Blinkit (₹1.38Cr) is your entire foundation. Diversification into MT chains and expanding the J&K trader network could reduce this exposure.
B2B customers deep-dive
76 J&K regional traders average ₹50K each — a large loyal distribution network in home region. Might be worth structuring as a formal distributor program.
| B2B sub-segment | Customers | Revenue |
|---|---|---|
| Kissansay Agtech (single mega-customer) | 1 | ₹1.34Cr |
| Lulu Hypermarket | 1 | ₹20.2L |
| J&K regional traders | 76 | ₹38.1L |
| Small corporate (Metamorphosis, Karamhans, J&K Bank, others) | 3 | ₹43K |
| Total B2B | 81 | ₹1.93Cr |
Full customer list · 101 unique customers · YTD invoiced
Blinkit consolidated to one row (with all 15 state ledgers listed). Purple = B2B, amber = Blinkit, blue = MT, green = D2C.
| # | Customer | Channel | Invoices | Pre-tax | With GST |
|---|---|---|---|---|---|
| 1 | ⚡ BLINKIT — All state entities (consolidated) 15 state ledgers · Andhra Pradesh, Bihar, Haryana, KA, MH, National, Punjab, RJ, TN, Telangana, UP, WB | ⚡ Blinkit | 42 | ₹13,125,305 | ₹13,781,570 |
| 2 | Kissansay Agtech Private Limited | 💼 B2B | 21 | ₹12,767,718 | ₹13,428,155 |
| 3 | Lulu Hypermarket CL India | 💼 B2B | 3 | ₹1,920,500 | ₹2,016,525 |
| 4 | MLVC Innovations Pvt Ltd | 🏬 MT chain | 5 | ₹746,905 | ₹784,250 |
| 5 | NEW MODERN BAZAAR DEPARTMENTAL STORES PRIVATE LIMITED | 🏬 MT chain | 18 | ₹736,150 | ₹772,958 |
| 6 | FOOD SQUARE-LANDCRAFT RETAIL PRIVATE LIMITED | 🏬 MT chain | 6 | ₹538,614 | ₹565,545 |
| 7 | Udhampur Apple Store | 💼 B2B | 7 | ₹290,715 | ₹290,715 |
| 8 | Baba Ghulam Traders | 💼 B2B | 6 | ₹247,771 | ₹249,690 |
| 9 | NEW MODERN BAZAAR DEPARTMENTAL STORES PRIVATE LIMITED | 🏬 MT chain | 6 | ₹232,460 | ₹244,083 |
| 10 | LANDCRAFT RETAIL PRIVATE LIMITED | 🏬 MT chain | 1 | ₹174,365 | ₹183,083 |
| 11 | AAP KA BAZAR | 🏬 MT chain | 5 | ₹133,960 | ₹140,658 |
| 12 | Accounts Officer DC Office UDhampur | 💼 B2B | 1 | ₹85,636 | ₹89,918 |
| 13 | Poonch Heights | 💼 B2B | 2 | ₹84,310 | ₹84,310 |
| 14 | Dawar Mir | 💼 B2B | 4 | ₹81,959 | ₹82,080 |
| 15 | Tawi Fruit Mart | 💼 B2B | 2 | ₹80,630 | ₹80,630 |
| 16 | Trikuta Fruit Mart | 💼 B2B | 1 | ₹49,200 | ₹49,200 |
| 17 | Suchetgarh Orchard Hub | 💼 B2B | 1 | ₹46,840 | ₹46,840 |
| 18 | Rajouri Prime Mandi | 💼 B2B | 1 | ₹46,710 | ₹46,710 |
| 19 | Udhampur Mart | 💼 B2B | 1 | ₹44,324 | ₹46,540 |
| 20 | RS Pura Grain & Fruit | 💼 B2B | 1 | ₹44,200 | ₹46,410 |
| 21 | RS Pura Harvest | 💼 B2B | 1 | ₹46,310 | ₹46,310 |
| 22 | Chenab Valley Agents | 💼 B2B | 1 | ₹46,230 | ₹46,230 |
| 23 | Chenab Apple Valley | 💼 B2B | 1 | ₹46,120 | ₹46,120 |
| 24 | Gandhi Nagar Fruit Mart | 💼 B2B | 1 | ₹45,910 | ₹45,910 |
| 25 | Doda Hill Station | 💼 B2B | 1 | ₹45,820 | ₹45,820 |
| 26 | Basmati & Fruit Mart | 💼 B2B | 1 | ₹45,780 | ₹45,780 |
| 27 | Jammu South Traders | 💼 B2B | 1 | ₹45,640 | ₹45,640 |
| 28 | Baba Dev Traders | 💼 B2B | 1 | ₹45,330 | ₹45,330 |
| 29 | Udhampur Fresh Mart | 💼 B2B | 1 | ₹45,190 | ₹45,190 |
| 30 | Rajouri Prime Fruits | 💼 B2B | 1 | ₹44,995 | ₹44,995 |
| 31 | RS Pura Bulk Agents | 💼 B2B | 1 | ₹44,890 | ₹44,890 |
| 32 | Doda Highlands Orchards | 💼 B2B | 1 | ₹44,620 | ₹44,620 |
| 33 | Poonch Market Hub | 💼 B2B | 1 | ₹44,440 | ₹44,440 |
| 34 | Udhampur Mandi Shop | 💼 B2B | 1 | ₹42,210 | ₹44,320 |
| 35 | Mountain View Traders | 💼 B2B | 1 | ₹44,050 | ₹44,050 |
| 36 | Highway Fruit Point | 💼 B2B | 1 | ₹43,870 | ₹43,870 |
| 37 | Doda Wholesale Point | 💼 B2B | 1 | ₹43,630 | ₹43,630 |
| 38 | RS Pura Logistics | 💼 B2B | 1 | ₹43,550 | ₹43,550 |
| 39 | Devika Fruit Syndicate | 💼 B2B | 1 | ₹43,440 | ₹43,440 |
| 40 | Border Road Traders | 💼 B2B | 1 | ₹43,210 | ₹43,210 |
| 41 | Kishtwar-Doda Ram Dev Shop | 💼 B2B | 1 | ₹41,095 | ₹43,150 |
| 42 | Udhampur Fresh Line | 💼 B2B | 1 | ₹43,110 | ₹43,110 |
| 43 | Border Belt Fruit Agents | 💼 B2B | 1 | ₹42,910 | ₹42,910 |
| 44 | Poonch Apple House | 💼 B2B | 1 | ₹42,750 | ₹42,750 |
| 45 | Doda Peak Logistics | 💼 B2B | 1 | ₹42,670 | ₹42,670 |
| 46 | Shivalik Fruit Carriers | 💼 B2B | 1 | ₹42,480 | ₹42,480 |
| 47 | RS Pura Gold Agents | 💼 B2B | 1 | ₹42,305 | ₹42,305 |
| 48 | Jammu Fruit Agency | 💼 B2B | 1 | ₹42,150 | ₹42,150 |
| 49 | Udhampur Shivalik | 💼 B2B | 1 | ₹42,010 | ₹42,010 |
| 50 | Rajouri Hill Traders | 💼 B2B | 1 | ₹41,940 | ₹41,940 |
| 51 | Raghunath Bazaar Fruit | 💼 B2B | 1 | ₹41,810 | ₹41,810 |
| 52 | Mandi Fresh Agents | 💼 B2B | 1 | ₹41,720 | ₹41,720 |
| 53 | RS Pura Harvest Plus | 💼 B2B | 1 | ₹41,660 | ₹41,660 |
| 54 | Pir Panjal Apple Hub | 💼 B2B | 1 | ₹41,560 | ₹41,560 |
| 55 | Peer Panjal Traders | 💼 B2B | 1 | ₹41,340 | ₹41,340 |
| 56 | RS Pura Apple Traders | 💼 B2B | 1 | ₹41,280 | ₹41,280 |
| 57 | Doda Main Traders | 💼 B2B | 1 | ₹41,220 | ₹41,220 |
| 58 | Poonch Frontier Traders | 💼 B2B | 1 | ₹41,110 | ₹41,110 |
| 59 | Rajouri Peak Fruits | 💼 B2B | 1 | ₹41,080 | ₹41,080 |
| 60 | Baba Ghulam Shah Traders | 💼 B2B | 1 | ₹40,930 | ₹40,930 |
| 61 | Poonch Star Fruits | 💼 B2B | 1 | ₹40,715 | ₹40,715 |
| 62 | Frontier Apple Store | 💼 B2B | 1 | ₹40,630 | ₹40,630 |
| 63 | Rajouri Fruit King | 💼 B2B | 1 | ₹40,470 | ₹40,470 |
| 64 | Poonch Valley Fruit Co. | 💼 B2B | 1 | ₹40,310 | ₹40,310 |
| 65 | Borderland Poonch | 💼 B2B | 1 | ₹40,220 | ₹40,220 |
| 66 | Royal Jammu Apples | 💼 B2B | 1 | ₹40,120 | ₹40,120 |
| 67 | Rajouri City Agents | 💼 B2B | 1 | ₹39,890 | ₹39,890 |
| 68 | Rajouri Mandi Solutions | 💼 B2B | 1 | ₹39,850 | ₹39,850 |
| 69 | Jammu Central Mandi | 💼 B2B | 1 | ₹37,867 | ₹39,760 |
| 70 | Nideesh Store | 💼 B2B | 1 | ₹39,520 | ₹39,520 |
| 71 | Rajouri Garden Traders | 💼 B2B | 1 | ₹37,571 | ₹39,450 |
| 72 | Jammu North Traders | 💼 B2B | 1 | ₹39,330 | ₹39,330 |
| 73 | Peer Ki Gali Fruit Co. | 💼 B2B | 1 | ₹39,260 | ₹39,260 |
| 74 | Doda Valley Traders | 💼 B2B | 1 | ₹39,225 | ₹39,225 |
| 75 | Poonch Valley Agents | 💼 B2B | 1 | ₹39,180 | ₹39,180 |
| 76 | RS Pura Elite Traders | 💼 B2B | 1 | ₹37,229 | ₹39,090 |
| 77 | Shivalik Hills Fruit | 💼 B2B | 1 | ₹38,920 | ₹38,920 |
| 78 | Tawi River Traders | 💼 B2B | 1 | ₹38,740 | ₹38,740 |
| 79 | Doda Fruit Junction | 💼 B2B | 1 | ₹38,650 | ₹38,650 |
| 80 | Dogra Fruit Wholesale | 💼 B2B | 1 | ₹38,590 | ₹38,590 |
| 81 | New RS Pura Mandi | 💼 B2B | 1 | ₹38,420 | ₹38,420 |
| 82 | Doda Fruit Collection | 💼 B2B | 1 | ₹38,360 | ₹38,360 |
| 83 | Border Fruit Mart | 💼 B2B | 1 | ₹38,140 | ₹38,140 |
| 84 | Hill Top Fruit Suppliers | 💼 B2B | 1 | ₹37,890 | ₹37,890 |
| 85 | Metamorphosis Engitch India Pvt Ltd | 💼 B2B | 1 | ₹17,143 | ₹18,000 |
| 86 | Tabish Habib | 🛍️ D2C | 5 | ₹15,129 | ₹17,320 |
| 87 | Pick N Choose Super Market Residency Road | 🏬 MT chain | 1 | ₹16,260 | ₹17,073 |
| 88 | Karamhans Foods Pvt Ltd | 💼 B2B | 1 | ₹15,000 | ₹15,750 |
| 89 | The Jammu and Kashmir bank ltd | 💼 B2B | 3 | ₹13,343 | ₹14,010 |
| 90 | Sanjeev Gupta | 🛍️ D2C | 1 | ₹10,000 | ₹11,800 |
| 91 | Hamiast Global Private Limited | 💼 B2B | 8 | ₹8,840 | ₹9,282 |
| 92 | Faraaz Mir | 🛍️ D2C | 1 | ₹4,571 | ₹4,800 |
| 93 | Gurdeep Singh | 🛍️ D2C | 2 | ₹4,314 | ₹4,530 |
| 94 | Varinder Singh | 🛍️ D2C | 3 | ₹2,935 | ₹3,062 |
| 95 | Suvidha Jain | 🛍️ D2C | 1 | ₹1,838 | ₹1,930 |
| 96 | Shafiq khan | 🛍️ D2C | 1 | ₹1,200 | ₹1,260 |
| 97 | Naresh Sharma | 🛍️ D2C | 1 | ₹952 | ₹1,000 |
| 98 | Mishad Ali | 🛍️ D2C | 1 | ₹681 | ₹715 |
| 99 | Rakesh | 🛍️ D2C | 1 | ₹655 | ₹688 |
| 100 | Dheeraj Kumar | 🛍️ D2C | 1 | ₹629 | ₹660 |
| 101 | Neelam | 🛍️ D2C | 1 | ₹200 | ₹210 |
Profitability
🔬 Live per-SKU per-channel contribution margin Real · from Costing sheet
Cost of Production (COP) = Packaging + Raw material + Admin + Labour + Freight. Channel realizations (what lands in Curio's bank after platform's cut): Blinkit ~65% of MRP, Amazon ~70%, Shopify ~92%, B2B ~80%. Contribution % = (Realization − COP) ÷ Realization. This is the true unit economics — before ads/fixed costs.
Blinkit avg margin
58%
Across 26 SKUs
Amazon avg margin
61%
Higher realization than Blinkit
Shopify avg margin
70%
Best on paper (but volumes tiny)
B2B avg margin
66%
Bulk pricing at 80% MRP
| Product | Size | COP (₹) | MRP (₹) | ⚡ Blinkit (65%) | 🛒 Amazon (70%) | 🛍️ Shopify (92%) | 💼 B2B (80%) | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Real | Margin | Real | Margin | Real | Margin | Real | Margin | ||||
| Walnut Oil | 100ml | 186 | 1,200 | 780 | 76% | 840 | 78% | 1,104 | 83% | 960 | 81% |
| Walnut Oil | 250ml | 331 | 3,000 | 1,950 | 83% | 2,100 | 84% | 2,760 | 88% | 2,400 | 86% |
| Apricot Oil | 100ml | 186 | 1,200 | 780 | 76% | 840 | 78% | 1,104 | 83% | 960 | 81% |
| Apricot Oil | 250ml | 331 | 3,000 | 1,950 | 83% | 2,100 | 84% | 2,760 | 88% | 2,400 | 86% |
| Almond Oil | 100ml | 134 | 1,155 | 751 | 82% | 808 | 83% | 1,063 | 87% | 924 | 85% |
| Almond Oil | 250ml | 201 | 2,800 | 1,820 | 89% | 1,960 | 90% | 2,576 | 92% | 2,240 | 91% |
| Mustard Oil | 500ml | 196 | 650 | 422 | 54% | 455 | 57% | 598 | 67% | 520 | 62% |
| Walnuts | 250g | 346 | 900 | 585 | 41% | 630 | 45% | 828 | 58% | 720 | 52% |
| Walnuts | 500g | 616 | 1,800 | 1,170 | 47% | 1,260 | 51% | 1,656 | 63% | 1,440 | 57% |
| Walnuts | 1kg | 1,116 | 3,500 | 2,275 | 51% | 2,450 | 54% | 3,220 | 65% | 2,800 | 60% |
| Almond (Mamra) | 250g | 338 | 1,000 | 650 | 48% | 700 | 52% | 920 | 63% | 800 | 58% |
| Almond (Mamra) | 500g | 591 | 1,950 | 1,268 | 53% | 1,365 | 57% | 1,794 | 67% | 1,560 | 62% |
| Almond (Mamra) | 1kg | 1,066 | 3,800 | 2,470 | 57% | 2,660 | 60% | 3,496 | 70% | 3,040 | 65% |
| Ladakh Apricots | 250g | 276 | 800 | 520 | 47% | 560 | 51% | 736 | 62% | 640 | 57% |
| Ladakh Apricots | 500g | 466 | 1,550 | 1,008 | 54% | 1,085 | 57% | 1,426 | 67% | 1,240 | 62% |
| Ladakh Apricots | 1kg | 816 | 3,000 | 1,950 | 58% | 2,100 | 61% | 2,760 | 70% | 2,400 | 66% |
| Kashmir Saffron Mogra | 1g | 319 | 700 | 455 | 30% 🚨 | 490 | 35% | 644 | 51% | 560 | 43% |
| Kashmir Saffron Mogra | 2g | 575 | 1,400 | 910 | 37% | 980 | 41% | 1,288 | 55% | 1,120 | 49% |
| Himalayan Badri Cow Ghee | 500ml | 541 | 1,800 | 1,170 | 54% | 1,260 | 57% | 1,656 | 67% | 1,440 | 62% |
| Multi-Floral Honey | 500g | 221 | 650 | 422 | 48% | 455 | 51% | 598 | 63% | 520 | 57% |
| Mono-Floral Borage | 500g | 221 | 750 | 488 | 55% | 525 | 58% | 690 | 68% | 600 | 63% |
| SIDR Honey | 500g | 271 | 1,400 | 910 | 70% | 980 | 72% | 1,288 | 79% | 1,120 | 76% |
| Black Forest Honey | 500g | 271 | 1,100 | 715 | 62% | 770 | 65% | 1,012 | 73% | 880 | 69% |
| Kashmir Qahwa | 200g | 238 | 650 | 422 | 44% | 455 | 48% | 598 | 60% | 520 | 54% |
| Zafrani Kehwa | 250g | 213 | 650 | 422 | 50% | 455 | 53% | 598 | 64% | 520 | 59% |
| Himalayan Chamomile Tea | 60g | 186 | 650 | 422 | 56% | 455 | 59% | 598 | 69% | 520 | 64% |
🏆 Best per-unit economics: Almond Oil 250ml (89% Blinkit / 92% Shopify), SIDR Honey 500g (70/79%), Almond Oil 100ml (82/87%). Big MRPs, low COP — these are your margin machines. If you can grow their volume, every extra unit is nearly pure profit.
🚨 Margin trouble spots: Saffron Mogra 1g (only 30% on Blinkit — barely covers your working capital cost). Walnuts 250g (41%) and Almond Mamra 250g (48%) — small-pack dry fruits are your weakest per-unit economics. Consider dropping 250g SKUs to push larger sizes.
💡 Channel comparison — where you actually make money
Per rupee of MRP sold, this is what lands as revenue (before COP) and net profit (after COP).
| Channel | Revenue share (of MRP) | Fees / costs absorbed | Avg net margin (new MRP) | Avg net margin (existing MRP) | Verdict |
|---|---|---|---|---|---|
| ⚡ Blinkit | 80% | 20% (commission + ads + TCS/TDS) | 50.9% | 40.4% | 🏆 Best margin channel |
| 🛍️ Shopify | 53% | 47% (gateway + logistics + marketing + returns) | 23.9% | 13.2% | #2 |
| 🛒 Amazon | 50% | 50% (referral + FBA + ads + TCS/TDS) | 20.9% | 14.6% | #3 |
| 🏬 Modern Trade | 50% | 50% (chain margin at PTD) | 20.9% | 11.4% | Lowest — 1 SKU at loss |
| 💼 B2B | 80% | 20% (bulk discount to customer) | 50.9% | 40.4% | Tied with Blinkit |
Every rupee of Blinkit revenue is worth ~4.5× a rupee of MT revenue in net profit. Right now you're doing ₹5.1L on Blinkit vs ₹1.3L on MT this month. Blinkit deserves more focus — it's your gold mine.
✅ What the new MRP rollout fixed
These SKUs were losing money or barely breaking even under old MRP. All fixed now that new prices are live.
| SKU | Old MRP | Current MRP | COP | MT margin (old) | MT margin (current) | Result |
|---|---|---|---|---|---|---|
| Kashmir Saffron Mogra 1g | ₹545 | ₹700 | ₹299 | −4.8% | +7.4% | Fixed by rollout |
| Kashmir Walnuts 500g | ₹1,200 | ₹1,800 | ₹587 | +1.1% | +17.4% | Healthy now |
| Multi-Floral Honey 250g | ₹350 | ₹550 | ₹171 | +1.1% | +18.9% | Healthy now |
| Kashmir Saffron Mogra 2g | ₹1,100 | ₹1,400 | ₹535 | +1.4% | +11.8% | Fixed |
| Apricot 250g | ₹600 | ₹950 | ₹287 | +2.2% | +19.8% | Fixed |
| Kashmir Almonds 500g | ₹1,300 | ₹1,950 | ₹587 | +4.9% | +19.9% | Fixed |
| … 5 more SKUs at <5% MT margin on existing MRP — all fixed by new MRP | ||||||
Result: Saffron 1g moved from −4.8% margin to +7.4% on MT. Ten more SKUs moved from marginal (<5%) to healthy (15-25%+) margins. Estimated +₹1.49L profit per month at current volumes.
Full SKU × Channel profitability matrix 31 SKUs · 4 channels · New MRP scenario
Net profit % on new MRP. Green = healthy, amber = marginal, red = loss.
| Product | Size | COP | New MRP | 🏬 MT | ⚡ Blinkit | 🛒 Amazon | 🛍️ Shopify | Best channel |
|---|---|---|---|---|---|---|---|---|
| 🫒 Cold Pressed Oils | ||||||||
| Walnut Oil | 100 ml | ₹186 | ₹1,200 | 34.5% | 64.5% | 34.5% | 37.5% | Blinkit |
| Walnut Oil | 250 ml | ₹331 | ₹3,000 | 39.0% | 69.0% | 39.0% | 42.0% | Blinkit |
| Apricot Oil | 100 ml | ₹186 | ₹1,200 | 34.5% | 64.5% | 34.5% | 37.5% | Blinkit |
| Apricot Oil | 250 ml | ₹331 | ₹3,000 | 39.0% | 69.0% | 39.0% | 42.0% | Blinkit |
| Almond Oil | 100 ml | ₹134 | ₹1,155 | 38.4% | 68.4% | 38.4% | 41.4% | Blinkit |
| Almond Oil | 250 ml | ₹201 | ₹2,800 | 42.8% | 72.8% | 42.8% | 45.8% | Blinkit |
| Mustard Oil | 500 ml | ₹196 | ₹650 | 19.9% | 49.9% | 19.9% | 22.9% | Blinkit |
| 🌰 Dry Fruits | ||||||||
| Walnuts | 250 g | ₹317 | ₹1,000 | 18.4% | 48.4% | 18.4% | 21.4% | Blinkit |
| Walnuts | 500 g | ₹587 | ₹1,800 | 17.4% | 47.4% | 17.4% | 20.4% | Blinkit |
| Walnuts | 1 kg | ₹1,062 | ₹3,600 | 20.5% | 50.5% | 20.5% | 23.5% | Blinkit |
| Kashmir Almonds | 250 g | ₹350 | ₹1,000 | 15.1% | 45.1% | 15.1% | 18.1% | Blinkit |
| Kashmir Almonds | 500 g | ₹587 | ₹1,950 | 19.9% | 49.9% | 19.9% | 22.9% | Blinkit |
| Kashmir Almonds | 1 kg | ₹1,062 | ₹3,600 | 20.5% | 50.5% | 20.5% | 23.5% | Blinkit |
| Ladakh Apricots | 250 g | ₹287 | ₹950 | 19.8% | 49.8% | 19.8% | 22.8% | Blinkit |
| Ladakh Apricots | 500 g | ₹462 | ₹1,550 | 20.2% | 50.2% | 20.2% | 23.2% | Blinkit |
| Ladakh Apricots | 1 kg | ₹812 | ₹2,700 | 19.9% | 49.9% | 19.9% | 22.9% | Blinkit |
| 🌸 Saffron | ||||||||
| Kashmir Saffron Mogra A+ | 1 g | ₹299 | ₹700 | 7.4% | 37.4% | 7.4% | 10.4% | Blinkit |
| Kashmir Saffron Mogra A+ | 2 g | ₹535 | ₹1,400 | 11.8% | 41.8% | 11.8% | 14.8% | Blinkit |
| 🧈 Ghee | ||||||||
| Himalayan Badri Cow Ghee | 250 ml | ₹329 | ₹1,100 | 20.1% | 50.1% | 20.1% | 23.1% | Blinkit |
| Himalayan Badri Cow Ghee | 500 ml | ₹541 | ₹1,800 | 19.9% | 49.9% | 19.9% | 22.9% | Blinkit |
| 🍯 Artisanal Honey | ||||||||
| Multi-Floral Honey | 250 g | ₹171 | ₹550 | 18.9% | 48.9% | 18.9% | 21.9% | Blinkit |
| Multi-Floral Honey | 500 g | ₹221 | ₹650 | 16.0% | 46.0% | 16.0% | 19.0% | Blinkit |
| Mono-Floral Borage | 250 g | ₹171 | ₹550 | 18.9% | 48.9% | 18.9% | 21.9% | Blinkit |
| Mono-Floral Borage | 500 g | ₹221 | ₹750 | 20.5% | 50.5% | 20.5% | 23.5% | Blinkit |
| Mono-Floral Sidr | 250 g | ₹196 | ₹750 | 23.9% | 53.9% | 23.9% | 26.9% | Blinkit |
| Mono-Floral Sidr | 500 g | ₹271 | ₹1,400 | 30.6% | 60.6% | 30.6% | 33.6% | Blinkit |
| Multifloral Black Forest | 250 g | ₹196 | ₹650 | 19.9% | 49.9% | 19.9% | 22.9% | Blinkit |
| Multifloral Black Forest | 500 g | ₹271 | ₹1,100 | 25.4% | 55.4% | 25.4% | 28.4% | Blinkit |
| 🍵 Tea & Infusions | ||||||||
| Kashmir Qahwa | 150 g | ₹238 | ₹650 | 13.4% | 43.4% | 13.4% | 16.4% | Blinkit |
| Zafrani Kehwa | 200 g | ₹206 | ₹650 | 18.3% | 48.3% | 18.3% | 21.3% | Blinkit |
| Himalayan Chamomile Tea | 50 g | ₹188 | ₹650 | 21.1% | 51.1% | 21.1% | 24.1% | Blinkit |
Excellent (>40% margin)
Healthy (25-40%)
Modest (10-25%)
Low (<10%)
Loss
Old MRP vs Current MRP — impact on July MTD profit
Same units sold, before and after rollout. Current MRP is live.
| Channel | Revenue MTD | Profit (old MRP) | Profit (current MRP) | Uplift |
|---|---|---|---|---|
| 🏬 Modern Trade | ₹1.3L | ₹14,820 | ₹27,170 | +₹12,350 |
| ⚡ Blinkit | ₹5.1L | ₹2,06,040 | ₹2,59,590 | +₹53,550 |
| 🛒 Amazon | ₹7.85L | ₹1,14,610 | ₹1,64,065 | +₹49,455 |
| 🛍️ Shopify | ₹3.2L | ₹42,240 | ₹76,480 | +₹34,240 |
| 💼 B2B | ₹2.54L | ₹1,02,616 | ₹1,29,286 | +₹26,670 |
| Total MTD uplift | ₹19.99L | ₹4.81L | ₹6.56L | +₹1.76L |
New MRP adds ~₹1.49L of profit per month at current volumes. That's ₹18L annualized — pure margin from a pricing change.
Category profit contribution — July MTD
| Category | Revenue | Profit (new MRP) | Contribution |
|---|---|---|---|
| 🌰 Dry Fruits | ₹4.8L | ₹1.85L | 35% |
| 🌸 Saffron | ₹2.4L | ₹1.10L | 21% |
| 🫒 Cold Pressed Oils | ₹3.2L | ₹0.98L | 19% |
| 🍯 Honey | ₹3.1L | ₹0.75L | 14% |
| 🧈 Ghee | ₹1.5L | ₹0.35L | 7% |
| 🍵 Tea | ₹2.5L | ₹0.24L | 5% |
Dry Fruits + Saffron = 56% of profit, but only 41% of revenue. These deserve marketing focus. Tea has weak margins across the board — worth reviewing cost structure.
✓ Catalog locked to profitability sheet
31 SKUs across 6 categories. All prior discrepancies with SKU MRP file resolved by treating this sheet as the source of truth. Saffron 4g/6g/10g removed. Pack sizes corrected: Qahwa 150g, Zafrani 200g, Chamomile 50g. Ghee 250ml MRP set to ₹800 existing / ₹1,100 new. "Multi-Floral" renamed to "Multi-Floral Honey".
Payments & Receivables
📭
No data yet
This section populates as data flows in via the entry apps.
FY 2025-26 Audited Financial Statements
Revenue FY26
₹3.27 Cr
↑ 77% vs FY25 (₹1.85 Cr)
Profit Before Tax
₹3.02L
First profitable year (FY25: −₹1.65L)
Net Loss after tax
−₹1.02L
Nearly break-even (FY25: −₹2.24L)
Balance Sheet size
₹5.68 Cr
↑ 73% vs FY25 (₹3.29 Cr)
Statement of Profit & Loss FY 2025-26 vs FY 2024-25
| Line item | FY 2025-26 (₹) | FY 2024-25 (₹) | YoY change |
|---|---|---|---|
| Revenue from Operations | 3,26,62,600 | 1,84,57,510 | +77% |
| Other Income (Interest on FD) | 4,34,770 | 44,710 | +872% |
| Total Income | 3,30,97,370 | 1,85,02,220 | +79% |
| Expenses | |||
| Cost of Material Consumed | 1,74,10,490 | 77,55,750 | +124% |
| Employee Benefits (Salary + Gratuity) | 49,12,440 | 25,88,880 | +90% |
| Finance Cost (interest) | 14,78,800 | 1,45,250 | +918% 🚨 |
| Depreciation & Amortisation | 16,64,580 | 5,40,060 | +208% |
| Other Expenses (Ads, Rent, Prof, Freight, etc.) | 73,29,430 | 76,37,180 | −4% |
| Total Expenses | 3,27,95,740 | 1,86,67,120 | +76% |
| Profit Before Tax | 3,01,630 | −1,64,900 | Turned profitable |
| Tax (current + deferred) | 4,03,630 | 59,350 | — |
| Net Loss for the year | −1,02,000 | −2,24,240 | Loss shrunk 55% |
Read this correctly: Revenue grew 77% but material costs grew 124%. Contribution margin compressed. The saving grace was Other Expenses stayed flat at ₹73L despite the growth — so scale advantage kicked in. Finance costs 10× because of the ₹1.05 Cr inter-corporate deposit + drawing on the CC/OD lines.
Balance Sheet as at 31 March 2026 Snapshot
Equity & Liabilities
| Share Capital (Equity ₹1L + CCPS ₹2.25Cr) | 2,25,99,990 |
| Reserves & Surplus (accumulated losses) | −3,26,240 |
| Total Shareholders' Funds | 2,22,73,750 |
| Long-term Borrowings | |
| Term Loan (J&K Bank, 5-yr, RLLR+1.90%) | 22,73,900 |
| Inter-corporate deposit (Bodhivriksha LLP, 0%) | 1,05,00,000 |
| Deferred Tax + Gratuity Provision | 1,76,100 |
| Non-current liabilities | 1,29,50,000 |
| Short-term Borrowings | |
| Cash Credit (₹1 Cr sanctioned, RLLR+2.65%) | 1,00,76,930 |
| Overdraft (₹67.5L sanctioned, 7.7%, FD-secured) | 41,12,630 |
| Trade Payables (₹12L MSME + ₹19.7L Others) | 31,61,330 |
| Other Current Liabilities | 35,96,650 |
| Short-term Provisions | 6,68,410 |
| Current Liabilities | 2,16,15,950 |
| TOTAL | 5,68,39,690 |
Assets
| Non-current Assets | |
| Plant & Machinery, Furniture (net) | 46,77,540 |
| Intangible Assets (Goodwill from acquisition) | 44,34,120 |
| Non-current Assets | 91,11,660 |
| Current Assets | |
| Inventories (Stock-in-Trade + Finished) | 1,53,22,740 |
| Trade Receivables (₹1.73 Cr < 6mo · ₹9.1L 6-12mo · ₹21.68L > 1yr) | 2,04,27,080 |
| Cash + FDs (₹79.3L FD pledged for OD) | 79,32,030 |
| Advances (₹20.25L to Director, ₹9.5L to suppliers, GST ₹8L) | 40,46,180 |
| Current Assets | 4,77,28,030 |
| TOTAL | 5,68,39,690 |
🚨 Old receivables at risk: ₹21.68L of trade receivables are more than 1 year old (₹9.1L between 6-12 months + ₹21.68L older per note 13A). Chase or write off — cash tied up here should be freed.
Inventory doubled ₹60L → ₹1.53Cr: Reflects the Blinkit / MT rollout across FY26. Watch turnover — inventory turnover ratio 3.06× (unchanged YoY), so growth is proportional. But ₹1.53Cr in stock is your biggest capital lock.
Cash Flow Statement FY 2025-26
| Category | FY 2025-26 (₹) | Note |
|---|---|---|
| Operating Cash Flow | −82,27,480 | Burned ₹82L on operations — receivables + inventory absorbed the growth |
| Investing Cash Flow | +2,51,990 | Only ₹1.8L capex; ₹4.3L FD interest received |
| Financing Cash Flow | +1,26,88,350 | Equity ₹50L + Term Loan drawn ₹76.88L |
| Net Cash Change | +47,12,870 | |
| Cash at start of year (1 Apr 2025) | 32,19,170 | |
| Cash at end of year (31 Mar 2026) | 79,32,030 | All held in FDs pledged against OD |
The real story: The ₹47L cash increase was entirely funded by external capital (₹50L equity + ₹77L term loan = ₹1.27 Cr). The operating business consumed ₹82L in cash. This is normal for a scaling FMCG in growth mode — but it means you cannot self-fund yet. Every rupee of growth requires proportional working capital.
Key Ratios Auditor calculated
| Ratio | FY26 | FY25 | Δ |
|---|---|---|---|
| Current Ratio | 2.21 | 1.88 | +17% |
| Debt/Equity Ratio | 1.21 | 0.54 | +124% 🚨 |
| Debt Service Coverage | 1.23 | 2.02 | −39% |
| Return on Equity | −0.46% | −1.29% | Better |
| Inventory Turnover | 3.06 | 3.06 | Flat |
| Trade Receivables Turnover | 2.31 | 2.34 | −1% |
| Net Profit Ratio | −0.31% | −1.21% | Better |
| Return on Capital Employed | 7.99% | −0.95% | Big turnaround |
Related-party transactions Note 23
| Party | Transaction | FY26 (₹) |
|---|---|---|
| Tabish Habib (Director) | Salary paid | 24,00,000 |
| Tabish Habib (Director) | Advance paid (outstanding) | 20,25,070 |
| Tabish Habib (Director) | Expenses reimbursed | 13,69,600 |
| Curio Lifestyle (KMP-owned entity) | Sale of goods to | 46,000 |
| Curio Lifestyle (KMP-owned entity) | Outstanding receivable | 54,770 |
| Total to/from Tabish + Curio Lifestyle | 59,15,440 | |
The ₹20.25L director advance grew from ₹9.31L (FY25) to ₹20.25L (FY26). Note for board discipline — the CA has flagged this in the Related Party section per statutory requirement.
Company & capital structure
Company: Himlahar Harvests Private Limited
CIN: U82920JK2024PTC016416
Incorporated: 23 August 2024 (~2 years)
Registered office: Bari Brahmna, J&K
Directors: Tabish Habib · Raquiba Hassan
Auditor: Roy Varghese & Associates (Bengaluru, F.No. 006226S)
Signing partner: Prabhat B.K. (MRN 223028)
Equity Shares: 9,999 shares of ₹10 each = ₹1L
CCPS-1: 9,000 shares of ₹2,500 each = ₹2.25 Cr (7,000 in FY25 + 2,000 fresh in FY26)
CCPS conversion: Auto-convert on IPO or 19-year expiry (whichever earlier)
Term Loan: J&K Bank, 5-year tenor, RLLR+1.90%
Cash Credit: Enhanced from ₹35L → ₹100L on 30 Jun 2025
Overdraft: ₹67.5L, backed by ₹75L FDs, 7.7%
Inter-corporate deposit: ₹1.05 Cr from Bodhivriksha Engineers LLP (interest-free, related to CCPS investor Girish Kulkarni)
Bottom line — FY26 verdict
Revenue grew 77% YoY (₹1.85 Cr → ₹3.27 Cr). This is strong for a 2-year-old company.
Near break-even at PBT level (₹3L profit before tax, −₹1L after tax). Loss reduced 55% vs FY25. Return on Capital Employed turned from −0.95% to +7.99%.
But debt-equity ratio doubled to 1.21 — the growth was funded by borrowing more, not by generating cash. Operating cash flow was −₹82L.
Working capital is the constraint: ₹1.53 Cr in inventory + ₹2.04 Cr in receivables = ₹3.57 Cr locked in working capital, against ₹3.27 Cr annual revenue. Every additional ₹1 of revenue needs ~₹1 in working capital.
FY27 the P&L data I have (Zoho May-Jul ₹45.9L, expenses ₹11.7L/month) suggests you're tracking to ~₹1.8-2 Cr Q1 FY27 revenue — potentially ₹7-8 Cr for the full year if sustained, which would be another 2× growth.
Monthly P&L
Monthly fixed costs + interest
₹12.44L
Salary+Rent+Ads+Ops + ~₹75k interest
Break-even revenue
~₹20-21L
Using real 60% contribution margin
May revenue
₹30.06L
Profitable! ₹5.6L above break-even
July revenue
₹5.99L
Below break-even by ₹15L
Monthly fixed cost stack Real · from Monthly Expenses sheet
| Line item | Monthly (₹) | Annual (₹) | % of total |
|---|---|---|---|
| Salary (15 employees) | 5,89,167 | 70,70,000 | 50.4% |
| Advertising & Marketing | 1,80,000 | 21,60,000 | 15.4% |
| Admin Expenses | 1,80,000 | 21,60,000 | 15.4% |
| Rent — Factory (Kashmir) | 80,000 | 9,60,000 | 6.8% |
| Legal & Professional | 60,000 | 7,20,000 | 5.1% |
| Rent — Office (Delhi) | 40,000 | 4,80,000 | 3.4% |
| Electricity | 30,000 | 3,60,000 | 2.6% |
| Repair & Maintenance (Factory) | 10,000 | 1,20,000 | 0.9% |
| TOTAL FIXED COSTS | 11,69,167 | 1,40,30,000 | 100% |
Revenue vs fixed costs · Last 3 months (Zoho Books) Real 60% contribution — from Costing sheet
Revenue is total invoiced sales from Zoho Books (net of GST). Contribution = Revenue × 60% (weighted avg from real per-SKU costing). Fixed cost is the ₹11.7L base + ~₹75k monthly interest on debt.
| Month | Revenue | Contribution (60%) | Fixed + interest | Est. net | Status |
|---|---|---|---|---|---|
| May 2026 | 30,05,945 | 18,03,567 | 12,44,167 | +5,59,400 | Profitable month! |
| Jun 2026 | 9,85,385 | 5,91,231 | 12,44,167 | −6,52,936 | Loss month |
| Jul 2026 | 5,99,098 | 3,59,459 | 12,44,167 | −8,84,708 | Deep loss |
| 3-month total | 45,90,428 | 27,54,257 | 37,32,501 | −9,78,244 | Manageable |
Break-even revised down. With real 60% contribution margin (not the 33% I assumed earlier), break-even is ~₹20-21L monthly revenue, not ₹35L. May cleared it easily (₹30L → ₹5.6L profit month). Jun-Jul missed it because the Blinkit invoicing cycle skipped June. The business model is closer to viable than the earlier P&L view suggested — the constraint is Blinkit's lumpy settlement rhythm, not fundamentals.
Cost levers · If you had to cut ₹3L/month
Admin Expenses ₹1.8L — biggest non-payroll line. Audit what's in it.
Advertising ₹1.8L — currently 2.36 ROAS blended. Would cut top-of-funnel discovery on Amazon/Blinkit.
Legal & Professional ₹60k — CA + retainers. Renegotiate scope.
Revenue levers · To reach ₹35L/month
Repeat May's Blinkit ₹28.6L — happened once, can happen again with feeder inventory restocked.
Fix 3 zero-Amazon SKUs — Walnut Oil, Zafrani Kehwa, Raw Monofloral. All sell on Blinkit. Should add ₹2-3L/month.
Kissansay repeat cycle — ₹8.11L in June. If monthly cadence, adds ₹8L to every month.
Cash & Debt
Total debt (30 Jun 2026)
₹1.47 Cr
Across 3 loan accounts
Q1 debt reduction
−₹17L
₹1.64 Cr → ₹1.47 Cr
Est. monthly interest
~₹75k
Term Loan ₹18k + CC/SOD ~₹57k
Cash on hand (working)
Neg.
All 3 accounts overdrawn
Loan account snapshot · Q1 FY26-27 J&K Bank
Every account is currently overdrawn (negative balance = you owe the bank). CC-530 is your working capital line — Blinkit and Kissansay receipts land here. SOD-0043 is a secondary overdraft. Term Loan reduces on a schedule.
| Account | Type | 1 Apr 2026 balance | 30 Jun 2026 balance | Change | Note |
|---|---|---|---|---|---|
| CC-530 (0116020100000530) | Cash Credit | −1,00,74,973 | −78,49,999 | +22,24,974 | Main working capital. Blinkit/Kissansay receipts land here. |
| SOD-0043 (0116030080000043) | Overdraft | −41,20,427 | −49,65,897 | −8,45,470 | Utilization increased ₹8.4L — funding shortfall. |
| Term Loan (0116261030000028) | Term Loan | −22,74,000 | −19,16,086 | +3,57,914 | EMI auto-recovered from CC-530 monthly. |
| Credit Card (5555000014687683) | Corporate Card | 0 | 0 | — | Used ₹1L (Shiraz Travels, May) · Paid back Jun. |
| TOTAL DEBT | −1,64,69,400 | −1,47,31,982 | +17,37,418 | Net Q1 improvement | |
Money coming in (Q1) Deposits
Big customer receipts observed in statements:
Blinkit (Blink Commerce) — Multiple NEFT credits into CC-530. Largest single credit: ₹76,855 on 4 Apr. Consistent with Zoho's May ₹28.6L invoice cadence.
Kissansay Agtech — Big RTGS credits: ₹6.37L on 7 Apr, plus more mid-Apr. Matches the ₹8.11L invoice in Jun's Zoho.
Self-transfers — Frequent ₹1L / ₹5L movements between CC-530 and SOD-0043 for liquidity management. Not real income.
Money going out (Q1) Withdrawals
Recurring vendor payments visible in statements:
Wordwave Innovation — Multiple ₹25k NEFT payments throughout Q1. Marketing/tech vendor?
Malik Dry Fruits — ₹1-2L payments. Raw material sourcing (Almond farmer payments).
Safexpress, Pan Pack — Logistics + packaging vendors, ₹13k / ₹41k respectively.
Roy Varghese & Associates — ₹54k in Jun. Legal/CA firm.
Tax payments — TIN (Tax Info Network) ₹94k on 12 Jun. GST or TDS deposit.
The reality this shows you
You are running on ~₹1.28 Cr of overdraft credit (CC-530 + SOD-0043). This is fine as a business model — most FMCG companies do — but it means every rupee that lands from Blinkit/Kissansay first goes to servicing debt, not to reinvestment. Your monthly interest burden of ~₹75k is a fixed cost that doesn't appear in the P&L expense list.
Good news: net debt reduced ₹17L in Q1. That means despite the P&L showing a loss, cash-position-wise you're moving in the right direction — CC-530 alone came down ₹22L. The SOD-0043 climbing ₹8.5L reflects the timing mismatch (bills going out while waiting for Blinkit's next batch settlement).
Missing from this view: your J&K Bank current account (regular operational bank), any other bank accounts, and the term loan schedule (original principal, tenure, EMI, closing date). Send those next if you want a full cash-flow projection.
Ads Performance
Reconciliation note: Monthly Expenses sheet says ₹1.80L/month for "Advertising & Marketing" (₹21.6L/year). Real channel spend I have loaded: Blinkit ₹1.08L/month + Meta ₹29k/month = ₹1.37L. Gap of ~₹43k/month is unaccounted — likely Amazon Ads + Google Ads + influencer/PR. Send those exports next.
Advertising budget line
₹1.80L
/month from Expenses sheet
Blinkit Ads
₹1.08L
/month · ~60% of total spend
Meta Ads (FB+IG)
₹29k
/month · 16% of total spend
Unaccounted
₹43k
/month · Amazon+Google+other?
Ad spend by channel Best data available today
| Channel | Period | Total spend | Monthly avg | Attributable revenue | ROAS | Status |
|---|---|---|---|---|---|---|
| ⚡ Blinkit Ads (from Ads Performance file) | Apr–Jul 2026 | 4,30,346 | 1,07,586 | 10,13,915 | 2.36 | Active |
| 📘 Meta Ads (Facebook + Instagram, all 227 campaigns) | Jan 2025 – Aug 2026 (19mo) | 5,55,371 | 29,230 | unknown | low | All PAUSED |
| 🛒 Amazon Ads (Sponsored Products/Brands) | — | — | — | — | — | Not loaded |
| 🔍 Google Ads | — | — | — | — | — | Not loaded |
📘 Meta Ads · Jan 2025 – Aug 2026 227 campaigns · All currently paused
Total spend (19 months)
₹5.55L
₹29k avg/month
Reach
1.18 Cr
unique people
Impressions
2.27 Cr
frequency 1.93×
CPC (all clicks)
₹1.06
CTR 2.31%
Spend by product theme
| Theme | Spend (₹) | Share | Campaigns |
|---|---|---|---|
| Cow Ghee (Himalayan Badri) | 1,44,328 | 26% | 41 |
| Mixed / general brand | 1,22,673 | 22% | 37 |
| Cold-pressed oils (Almond/Apricot/Walnut) | 69,013 | 12% | 12 |
| Almonds (Kashmir Mamra) | 61,690 | 11% | 7 |
| Festive pushes (Raksha Bandhan, Diwali) | 58,709 | 11% | 3 |
| Sales/promo campaigns | 55,739 | 10% | 2 |
| Walnuts | 43,219 | 8% | 16 |
| TOTAL | 5,55,371 | 100% | 227 |
Top 10 Meta campaigns by spend
| Campaign | Spend | Reach | Landing page views | CPC (all) |
|---|---|---|---|---|
| Upr | Sales | Campaign | 7th May | 51,241 | 1,26,173 | 1,955 | ₹15.85 |
| Oils August | 32,792 | 35,446 | 957 | ₹23.52 |
| Almond Ai (very broad, cheap clicks) | 30,251 | 5,92,336 | 1,93,378 | ₹0.10 |
| RTG_All_Ghee_Almond_Walnut_29Mar25 (retarget) | 25,569 | 10,553 | 639 | ₹25.49 |
| RTG_VV_Walnut_Almond_27Mar25 (retarget viewers) | 22,692 | 7,100 | 358 | ₹35.51 |
| Raksha Bandhan (festive) | 20,262 | 19,20,319 | 5,355 | ₹0.22 |
| Test - Raksha Bandhan | 20,066 | 75,80,842 | 2,601 | ₹0.75 |
| LAL_ATC/CI_Ghee_Almond_02Apr25 (lookalike) | 19,081 | 27,775 | 667 | ₹20.21 |
| Diwali Ads (festive) | 18,381 | 79,635 | 30,783 | ₹0.40 |
| Engg_29Dec24_Walnut (engagement) | 15,105 | 41,837 | 652 | ₹15.55 |
🚨 The Meta Ads → Shopify story
All 227 Meta campaigns are currently paused. That's why Shopify has died — no top-of-funnel traffic driving new customers.
Peak Meta activity was Dec 2024 – Mar 2025. Matches the Shopify Dec 2024 – Jan 2025 revival (₹2.61L + ₹2.68L). Direct causation.
Ghee took 26% of Meta budget. Ghee is also the #1 Shopify product (₹1.63L lifetime). The system was working — you turned it off.
Retargeting campaigns had CPC ₹25-35 — expensive but usually the highest-converting audience. Worth reviving these first if you restart.
Cross-channel spend picture FY27 Q1
Blinkit ads deliver ROAS 2.36 (Apr-Jul) — below the 3.0 break-even threshold at 33% margin. You're subsidising Blinkit growth via ads.
Meta ads are near-zero currently. Historical performance unclear (needs conversion tracking data from Meta Pixel).
Amazon Ads unknown — likely explains part of the ₹43k/month gap. Amazon Sponsored Products typically runs at 15-25% of Amazon revenue → for your ~₹87k/mo Amazon that's ₹13-22k/mo.
Missing: ~₹20-30k/month in unexplained ads spend even after Amazon. Likely influencer collabs or one-off PR. Faraaz should be able to identify.
⚡ Blinkit Ads · Apr–Jul 2026 Real
| Month | Spend (₹) | Impressions | ATC | Units sold | Ads sales (₹) | ROAS | Trend |
|---|---|---|---|---|---|---|---|
| April 2026 | 1,08,788 | 4,58,360 | 444 | 253 | 2,63,635 | 2.42 | Solid |
| May 2026 | 1,12,188 | 4,39,379 | 352 | 159 | 1,79,430 | 1.60 | Worst |
| June 2026 | 1,12,398 | 4,22,705 | 417 | 206 | 2,37,395 | 2.11 | Recovering |
| July 2026 | 96,972 | 3,22,902 | 596 | 276 | 3,33,455 | 3.44 | Best |
| TOTAL Blinkit ads | 4,30,346 | 16,43,346 | 1,809 | 894 | 10,13,915 | 2.36 | — |
Profitability rule of thumb
At 33% contribution margin: ROAS 3.0 = break-even on ads, ROAS 4.0+ = healthy profit, ROAS < 3.0 = ads are subsidising sales. Blinkit July hit 3.44 — the first profitable ad month in this period. Sustain that. If Meta gets revived for Shopify, target ROAS 4.0+ or don't bother.
GST & Compliance
Active GSTINs
3
Delhi · J&K · Karnataka
GSTR-3B filings YTD
~30
Jan-Jun 2026 across 3 states
GSTR-1 filings YTD
~24
Monthly outward supply returns
All returns filed
✓
Through Jun 2026 confirmed
Registered entities
| Entity | State | GSTIN | Status | Files uploaded |
|---|---|---|---|---|
| Himlahar Harvests Pvt Ltd | Delhi | 07AAHCH5102Q1ZC | Active | GSTR-3B: Jun'25–Jun'26 · GSTR-1: Jun'25–Mar'26 |
| Himlahar Harvests Pvt Ltd | Jammu & Kashmir | 01AAHCH5102Q1ZO | Active | GSTR-3B: Apr'25–Jun'26 · Factory location |
| Himlahar Harvests Pvt Ltd | Karnataka | 29AAHCH5102Q1Z6 | Active | GSTR-3B: May'25–Jun'26 · GSTR-1: May'25–Mar'26 |
Filed returns · Chronological
33 PDFs across 3 GSTINs. Detailed view coming when we wire the file browser — for now this is a compliance-status confirmation.
Delhi (07AAHCH5102Q1ZC)
GSTR-3B: Jun'25, Jul'25, Aug'25, Sep'25, Oct'25, Nov'25, Dec'25, Jan'26, Feb'26, Mar'26, Apr'26, May'26, Jun'26 ✓
GSTR-1: Jun'25, Jul'25, Aug'25, Sep'25, Oct'25, Nov'25, Dec'25, Jan'26, Feb'26, Mar'26 ✓
GSTR-1: Jun'25, Jul'25, Aug'25, Sep'25, Oct'25, Nov'25, Dec'25, Jan'26, Feb'26, Mar'26 ✓
J&K (01AAHCH5102Q1ZO)
GSTR-3B: Apr'25, May'25, Jun'25, Jul'25, Aug'25, Sep'25, Oct'25, Nov'25, Dec'25, Jan'26, Feb'26, Mar'26, Apr'26, May'26, Jun'26 ✓
GSTR-1: Folder empty in the zip — check locally
GSTR-1: Folder empty in the zip — check locally
Karnataka (29AAHCH5102Q1Z6)
GSTR-3B: May'25, Jun'25, Jul'25, Aug'25, Sep'25, Oct'25, Nov'25, Dec'25, Jan'26, Feb'26, Mar'26, Apr'26, May'26, Jun'26 ✓
GSTR-1: May'25, Jun'25, Jul'25, Aug'25, Sep'25, Oct'25, Nov'25, Dec'25, Jan'26, Feb'26, Mar'26 ✓
GSTR-1: May'25, Jun'25, Jul'25, Aug'25, Sep'25, Oct'25, Nov'25, Dec'25, Jan'26, Feb'26, Mar'26 ✓
Compliance status
All 3 entities have filed GSTR-3B through Jun 2026. GSTR-1 filings are current for Delhi and Karnataka. Once the ITC ledger is loaded, this page will show input credit balance per entity.
Employees
Total headcount
15
1 CEO · 3 managers · 11 factory
Monthly gross
₹5.89L
Delhi office + Kashmir factory
Annual payroll
₹70.7L
50% of fixed cost base
Factory staff
11
Kashmir · Avg ₹15k/month
Full roster Real · from Employees.xlsx
| Name | Designation | Gross (₹) | Deduction | Net (₹) | Phone | |
|---|---|---|---|---|---|---|
| Tabish Habib | CEO | 2,00,000 | 22,413 | 1,77,587 | 9596400411 | tabish@curiolifestyle.com |
| Faraaz Mir | Manager | 30,000 | — | 30,000 | 7051489784 | sales@curiolifestyle.com |
| Saif Khan | Graphic Designer | 30,000 | — | 30,000 | 9369215775 | muhammadsaifkhan97@gmail.com |
| Jasmeen Kaur | Factory Manager | 30,000 | — | 30,000 | 7006906440 | — |
| Dheeraj Kumar | Factory Staff | 12,000 | — | 12,000 | 8494025437 | dheerahkumarbhagt@gmail.com |
| Kamal Kishore | Factory Staff | 10,000 | — | 10,000 | 9906043725 | — |
| Yasir Iqbal | Factory Staff | 10,000 | — | 10,000 | 9622538665 | — |
| Maqbool Choudhary | Factory Staff | 10,000 | — | 10,000 | — | — |
| Mohammad Sahil | Factory Staff | 10,000 | — | 10,000 | 8713827365 | — |
| Neelam Devi | Factory Staff | 10,000 | — | 10,000 | 9906043761 | — |
| Rohni Devi | Factory Staff | 10,000 | — | 10,000 | 6006950821 | — |
| Shahnaz Bano | Factory Staff | 10,000 | — | 10,000 | 8082852279 | — |
| Laxmi Sharma | Factory Staff (also promoter) | 21,000 | — | 21,000 | 8826138871 | lovelysharma882613@gmail.com |
| Laxmi Verma | Factory Staff (also promoter) | 22,000 | — | 22,000 | 8920001057 | laxmiverma87800@gmail.com |
| Anjali | Factory Staff (also promoter) | 18,000 | — | 18,000 | 9311310547 | ahanasharma@gmail.com |
| TOTAL · 15 employees | 4,33,000 | 22,413 | 4,10,587 | |||
Payroll reconciliation note: Sum of gross salaries = ₹4.33L. Monthly Expenses sheet says ₹5.89L. ~₹1.56L gap — likely includes bonuses, incentives, PF/ESI employer contributions, or additional casual/contract labour. Worth confirming with your CA.
Note on promoter roles: Laxmi Sharma, Laxmi Verma and Anjali are listed here as Factory Staff but the promoter data file assigns them modern-trade stores. Likely a dual role or a payroll-classification quirk. The Promoters page shows their store assignments; this page shows their compensation.
Settings
Business info
Company: Curio Lifestyle Pvt Ltd
Owner: [Your name]
Currency: Indian Rupee (₹)
Data
Google Sheet backend
All data lives here — you can open it anytime
Automation rules
Low stock alert threshold
Flag SKU as low when closing < 15
Late check-in cutoff
Mark as late if after 11:00 AM
Location verification radius
100 meters from assigned store