Jelly Belly

Jelly Belly

Analytics Dashboard
Data: -- Last synced: --
Overview
·
Individual Grouped
Total revenue
--
Net revenue
--
Orders
--
Average order
--
Discount
--
Gross revenue
--
Taxes
--
Items sold
--
Charges collected
--
Avg selling price
--
Items per order
--
Cancelled orders
--
Cancelled loss
--
Voided orders
--
Voided loss
--

Revenue trend

Payment methods

Revenue by brand

Outlet revenue

Top restaurants

Top items

Average order value

Sales by day of week

Peak hours

Avg Kitchen Prep (KPT) -- KOT fired → order ready
Median KPT (P50) -- Half of orders are faster
On-time (≤10 min) -- Orders ready within target
Avg Dispatch Wait -- Ready → picked up
Slowest Kitchen -- --
Fastest Kitchen -- --

KPT Trend

KPT Distribution

KPT by Branch — slowest first

On-time % by Branch — worst first

KPT by Brand

KPT by Platform

KPT by Hour of Day

KPT by Day of Week

Aggregator settlement reconciled against Rista POS & food cost — exactly what each platform deducts (commission, fees, taxes) and your real contribution.
Platform
View
Of the orders placed in this window, how much has settled vs is still owed.
GMV (Orders Placed)--Order value placed this period
Effective Take-rate--All Swiggy deductions ÷ GMV
Commission--Swiggy commission ÷ GMV
Net Payout (to bank)--Settled orders, after all deductions
Yet to be Settled--Orders placed, not yet paid out
Food Cost--COGS ÷ net revenue (Rista)
Contribution Margin--Net payout − food cost, ÷ settled GMV

Where the money goes (per ₹100 GMV)

Payout breakup — all line items

Take-rate by outlet

Contribution & take-rate trend

Reconciliation — POS vs settled (by payout period)

Customer complaints across every Swiggy & Zomato outlet — issue, customer history, order items, resolution, and the photos customers attached.
✦ Reading every complaint…
Open--Unresolved / awaiting action
Closed--Resolved / dismissed / expired
Verified--Platform-verified genuine
With Photos--Complaints with attached images
Total--Swiggy & Zomato
Refund Exposure--Amount in question (refunds)
Avg Rating--Store rating (from reviews feed)

Complaints by outlet

Top issue reasons

Loading…
Select a complaint to see details, order items, and photos.
Total Revenue -- Bill rounded amount (what you receive)
Gross Revenue -- Menu subtotal before taxes & charges
Est. Commission -- ~27% of Swiggy + Zomato revenue
Food Cost % -- Material + supplies as % of total revenue
Gross Margin % -- After food cost, commission & GST

Profit & Loss Waterfall

Total revenue flowing through each cost to net profit

Channel Revenue

Gross vs bill amount by platform — gap shows aggregator cut

Food Cost vs Margin

Raw material cost % vs margin % per channel

Margin Trend

Monthly food cost % and gross margin % over time

Branch P&L

Per-branch breakdown — revenue, costs, commission & net margin

Commission & Settlements

Actual data from Zomato & Swiggy settlement Excel reports via Gmail
Net Order Value -- Total value of delivered orders
Service Fee -- Commission charged by platforms
Avg Commission % -- Service fee as % of commissionable value
Net Payout -- Amount received after all deductions

Payout Breakdown

Net order value flowing through deductions to net payout

Commission % Trend

Deduction Split

Where your money goes — commission, taxes, ads, hyperpure

By Restaurant

Settlement breakdown per restaurant ID on Zomato

Settlement Reports

All downloaded settlement Excel files with parsed data

Bank Statement & Reconciliation

HDFC bank deposits matched against commission settlement payouts
Platform Payout -- From commission Excel
Bank Received -- Platform deposits in bank
EMI Deducted -- Deducted at escrow
PhonePe (Store) -- Direct store payments
Net Flow -- All deposits minus withdrawals

Deposit Trend

EMI Reconciliation

Reconciliation

Bank deposits vs commission settlement payouts by date & platform

Bank Transactions

Inventory Intelligence

Stock health, revenue drivers & menu optimization
Active Menu -- Items in stock
Utilization -- % with sales
Dead Stock -- Items never sold
Fast Movers -- Selling >10/day

Revenue Drivers

Items selling 3+ per day that drive the majority of revenue

Item Velocity

Top 15 items by daily sales rate

Category Revenue

Branch Efficiency

Items selling vs dead stock per branch

Dead Stock

Items available but never sold at active branches

Availability Matrix

Green = selling, Yellow = not selling, Red = out of stock, Gray = not carried

All Items

Wastage Intelligence

Daily signals, branch benchmarks & audit reconciliation
Est. Wastage -- Based on audit history
Food Cost % -- Target: < 35%
Material Consumed -- Recipe deductions
Active Alerts -- Items flagged

Branch Food Cost Ranking

Food cost % per branch — bars past the 35% target line need attention

Category Consumption

Food Cost % Trend

Daily food cost percentage with 35% target line

Consumption Anomalies

Items with >30% deviation from 7-day average consumption

Stock Days Alert

Perishable items with 3+ days of stock — spoilage risk

Over-Ordering

Items where transfer in exceeds consumption for 3+ days

Stock Movement

Transfer in, recipe consumed, voided & audit per item

Procurement

GRN purchases, suppliers, wastage & food-cost bridge — enterprise (Central Warehouse); wastage/variance are per-branch
Total POs -- Purchase orders
Total GRNs -- Goods received
GRN Spend -- Total procurement
Suppliers -- Active suppliers

Top Suppliers

Category Spend

Spend Trend

Top Items by Cost

Most purchased items across all procurement documents

Recent Documents

Food-Cost Bridge

Monthly GRN purchases vs consumed COGS (P&L food-cost source) vs revenue — enterprise-wide

Wastage & Shrinkage

Value written off via shrinkage docs, by branch & reason

Stock-Count Variance

Audit book-vs-physical variance value, by branch (negative = shortfall)

Outlets

Revenue across physical locations — all brands combined per kitchen
Outlets -- Named clusters + others
Total Revenue -- All outlets combined
Top Outlet -- --
Avg Revenue / Outlet -- Across named outlets

Outlet Growth Trajectory

Monthly stacked revenue by outlet with month-over-month growth line

Outlet Revenue Ranking

All physical outlets sorted by total revenue

Brand Mix per Outlet

How each brand contributes to each outlet's revenue

Outlet Details

Click a row to see branch codes rolled up into that outlet

Store Locations

Active outlets & planned expansion across Hyderabad
Active Planned

Manage Locations

Demand Forecast

Seven days ahead by brand, then by restaurant — measured, not assumed
7-Day Units
--
 
Accuracy · Brand
--wMAPE
 
At 7 Days Out
--wMAPE
The prep-cycle horizon
Series Forecast
--
 
Brands
--
 

Next 7 Days by Brand

Forecast per day · % is vs the same weekday last week · click a brand for its restaurants

Items

Next seven days, split by each item’s share of the last 28 days

Brand × Restaurant

Seven-day forecast per cell, with its 80% range — scaled so the parts sum to the brand

Placeholder

This becomes a raw-material forecast. Prep and procurement are decided in ingredients — kg of chicken, count of rumali — not in menu items. Waiting on a bill of materials linking items to ingredients; until then this shows the cell forecast it will be built from.

Accuracy

Populates from tomorrow, as each forecast day is scored against what actually happened

Raw Material Pricing

What we pay, to whom, and how it has moved — from goods actually received

Pricing Agent

Checks every item against every vendor that supplied it, scored on shared delivery periods so a cheap month is never mistaken for a cheap vendor — and shows what it rejected

Biggest Price Moves

Ranked by what the move costs at today’s volume, not by percentage — a 90% jump on a small line matters less than a 12% jump on a large one

Same Item, Different Vendor

Only items bought from more than one supplier in this window. Gap is an upper bound on the opportunity, not a banked saving — capacity and quality are not in this table

Billed Above Agreed

GRN price over its own purchase order

Not Priced

Shown rather than silently dropped

Cost of Goods Sold

What the food and packaging actually cost, from the recipe cost Rista stamps on every sold line — per menu item and per restaurant, against the equal window before

Cost Rate Over Time

Total COGS against ingredients only — the gap is packaging, which the P&L food-cost figure leaves out

By Restaurant

Cost rate on net revenue, so it reconciles with the P&L. Ranked by revenue; the change column is percentage points against the previous window

By Menu Item

Ranked by what the rate move cost this window in rupees, not by percentage — a big seller drifting two points outweighs a small one doubling

No Recipe Attached

Items selling with no recipe in Rista, so their cost reads as zero and no margin on this page can see them. Ranked by money at stake — this list is the fix

Discount Patterns

Where giveaway runs above its own norm, on which channel — and since when

By Platform

Each platform against its own prior period — never against another, because aggregator menu prices are marked up before the discount is applied

Likely Campaigns

The same item, on one channel, stepping up at several restaurants on the same day. Rista records the discount and not the promotion behind it — the campaign is inferred, never named, and who funded it is not knowable from this data

By Item

Each item against its own prior norm on the same channel, ranked by rupees of excess giveaway

By Restaurant & Channel

Never compared across channels — aggregator prices are marked up before the discount, so 23% there is not 23% off dine-in

Out of Stock

Live sold-out items, repeat offenders & the alerts going out to the branch groups

Biggest Money at Risk

Items out now, ranked by the revenue they normally earn per day

Cross-Branch Signal

Out here, still selling there — the transferable wins

Recurring & Chronic

Items that keep going out, or have been out for days

Out Right Now --  
Branches Affected --  
Avg Time Open --  
Hours Lost --  
Alerts Sent 24h --  

Out Right Now

Longest outage first — red past 24h, amber past 8h

Repeat Offenders

Items that go out most often in this window

By Store

Follows the Group by dimension you pick elsewhere

New Outages per Day

Is it getting better or worse

Recent Alerts

What agent-jelly actually sent to the branch WhatsApp groups

Sales Report

Gross, net, discounts & orders by store and brand — honours the date & branch filters above

Store Groupings

Pick stores on the left, add them to a group — then filter or report by it

Stores

Select a grouping

Change History

Grouping edits

Active List

Which restaurants are still trading — this list governs every tab

Restaurants

Turn a restaurant off when it closes, and set the date it stopped trading

Change History

Who changed what

Reconciliation Settings

Every line text Swiggy and Zomato have actually sent, and which bucket each rupee lands in

Review queue

Unclassified first, sorted by rupees. A mapping edit moves money between rows — it can never change the total.

Drift

New texts, vanished texts, and probable renames paired on magnitude inside one document. Deterministic — no model.

Tie-out & disclosure

This page previews the new ledger; the P&L page still reads the old mart