Item profitability

What one plate of each dish leaves you on Dine-in, Swiggy and Zomato

The item profitability sheet consultants already keep, on one page: each dish's price on every channel, less what that channel costs, less the food — so you can see which dishes earn most where, and what the app price would have to be to match dine-in.

What it does
  • Profit per plate, on every channel

    Dine-in loses its food cost, a fixed share (rent, salaries, EMI) and a variable share (gas, power, packing). An app's price loses its commission, ads, discount and other charges to give the payout, then the same food cost — so all three read on one footing.

  • Each dish's own discount, from the orders

    Upload an app's order file and each order's discount is shared across its items by value. A dish's effective discount replaces the app's default, so a dish that is always on offer is costed as one.

  • The price to match dine-in

    For every dish, the Swiggy and Zomato price that would leave the same rupees per plate as dine-in.

  • Your menu, read off your file

    A menu file with item names and prices is read in, with the columns guessed and shown for you to correct. Dish names in the orders are matched to the menu even where the spelling differs.

  • Downloaded as the sheet you know

    Effective discount, profit per plate and the item ledger — one row a dish, with Dine-in, Swiggy and Zomato across the top.

How you use it

4 steps

  1. Set the costs once

    Dine-in's fixed and variable shares, and each app's commission, ads, default discount and other charges, as percentages of the price.

  2. Bring the menu

    Upload the menu file, or type each dish's prices and food cost in.

  3. Add an order file

    Optional: an app's orders, for each dish's real discount on that app.

  4. Read the ledger, and download

    See which channel each dish earns most on, and take the workbook to the owner. Nothing here changes any other page.

An example
A sample dish, at sample costs
Chicken BiryaniDine-inSwiggyZomato
Selling price₹220.00₹270.00₹265.00
Channel costs−₹55.00 · 25%−₹116.10 · 43%−₹108.65 · 41%
Food cost−₹85.00−₹85.00−₹85.00
Net profit per plate₹80.00 · 36.36%₹68.90 · 25.52%₹71.35 · 26.92%
Price to match dine-in—₹289.47₹279.66

Dine-in costs are fixed 15% and variable 10%. Swiggy: commission 25%, ads 5%, discount 10%, other 3%. Zomato: commission 22%, ads 6%, discount 10%, other 3%. Every percentage is of that channel's own price, and GST is not included.

Start with one brand and last month’s settlement file.

  • No partner-portal login needed
  • Your data is never sold or shared