Price your menu from the pack you bought — not from the café down the road
A ₹899 dish on a delivery app is not a ₹899 dish. The platform takes commission on the gross including GST and packaging, charges GST on that commission, the gateway takes its cut, and only then do your ingredients get paid. Most menus are priced before any of that happens, which is why a busy kitchen can close the month with nothing. This workbook costs every recipe from the pack price you actually paid — with wastage, trim and yield — then subtracts commission, GST on commission, gateway fee and packaging to show the contribution each dish leaves behind. Seven sheets: ingredient costing, recipe lines, dish margin stack, menu engineering, break-even, settings and a start-here page. Four example dishes are pre-filled so you can watch the maths work before you trust it with your own numbers. Macro-free, offline, opens in Google Sheets.
One-time ₹249 ₹1,499 · instant download
A dish at 32% food cost can still leave you 6%
The usual test of a menu is food cost percentage: ingredient cost divided by selling price. Keep it under a third and the dish is "fine". That test was written for a dine-in restaurant where the customer pays at the counter and walks home. It falls apart the moment an order arrives through an app, because the platform is paid out of the same bill before you are.
Neither Swiggy nor Zomato publishes a commission rate card. The only range either platform has put on the record is Swiggy's 10–24% to the Competition Commission of India, and Zomato has said publicly that its all-in take is capped at 30%. Commission is charged on the gross order value — which includes the GST and the packaging charge — and 18% GST is then charged on the commission itself. At the 5% no-ITC rate that a standalone café or cloud kitchen must use, none of that is recoverable. Add a payment gateway fee of about 1.84% and the platform is taking roughly a quarter to a third of the bill before a single ingredient is bought.
So the only number worth managing is contribution: what lands in your account after the platform, the tax on the platform, the gateway and the packaging, minus what the food cost. That is what pays rent, salaries and you. MenuMargin OS computes it per dish, in the same row, and then tells you which dishes are carrying the menu and which are quietly costing you money.
The example cake in the file, line by line
| Line | Working | Amount |
|---|---|---|
| Menu price (ex-GST) | what the customer sees | ₹899.00 |
| GST 5% | 899 × 5% | ₹44.95 |
| Packaging charged to the customer | your box, billed at cost | ₹35.00 |
| Gross order value | 899 + 44.95 + 35 | ₹978.95 |
| Commission 21% | charged on the gross, before discounts | −₹205.58 |
| GST on that commission | 205.58 × 18%, not recoverable at 5% no-ITC | −₹37.00 |
| Payment gateway | 978.95 × 1.84% | −₹18.01 |
| You receive | ₹718.36 | |
| Food cost, wastage included | ten ingredients | −₹434.11 |
| Packaging cost | −₹35.00 | |
| Contribution | what pays rent, staff and you | ₹249.25 · 27.7% |
Every figure above is calculated by the workbook, not typed. Change the butter price by ₹10 a pack and all of it moves.
Look at the shape of it. ₹899 of menu price becomes ₹718 in hand before you buy anything, and the ingredient cost is high because the recipe is generous — 200 g butter, 150 g cream, 150 g couverture. The workbook does not tell you to cheapen the cake. It tells you that at ₹899 this cake is a Star, that at ₹650 it would be a Plowhorse, and that at ₹1,447 the food cost would fall to your 30% target. The decision stays yours; the arithmetic stops being a guess.
Seven sheets, each doing one job
The colour key, the six-step set-up order, the money maths in four lines, and the sources behind the GST and commission defaults. Read it once, in five minutes, and the rest of the file explains itself.
GST on food, aggregator commission, GST on commission, gateway fee, packaging per order, target food cost, default wastage. Every other sheet reads from these seven cells, so one edit re-prices the whole menu. A worked ₹300 example sits underneath so you can see the deduction chain once.
Two hundred rows: pack size, pack price, wastage and trim. The sheet returns cost per gram, millilitre or piece, and cost per usable unit — so coriander at 25% trim costs ₹0.24 a usable gram, not the ₹0.18 on the bill. Unit dropdowns, supplier and last-updated columns.
Four hundred rows: dish code, ingredient code, quantity. The ingredient name and unit cost are looked up automatically, and the line cost is calculated. Use the same dish code on every line of a dish and the Dishes sheet totals them with a SUMIF.
Fifty dishes with the full stack in one row: batch cost, cost per portion, packaging, menu price, GST, commission, gross order value, commission ₹, GST on commission, gateway, what you receive, contribution ₹, food cost %, contribution %, the price needed to hit your target food cost, and a Healthy / Watch / Rework verdict.
Enter last month's units sold and each dish is classed Star, Plowhorse, Puzzle or Dog using the standard 70% rule against the menu average — with a one-line instruction for what to do about each class. Monthly revenue, food cost, packaging and commission totals roll up underneath.
Seven fixed-cost lines, then orders per month, orders per day, operating profit and margin of safety — pulled from your own menu rather than typed in. This is the sheet that tells you whether the problem is the menu or the volume.
No macros, no password protection, no hidden steps. Every formula is a standard SUMIF, AVERAGEIF, COUNTIF, VLOOKUP or IFERROR that you can read, trace and change. Nothing is locked.
Every sheet is set to A4 landscape with fit-to-width, so the Dishes sheet prints on one page you can pin in the kitchen, and the Break-Even sheet prints for a lender or a partner.
Popularity against contribution — the four classes and what each one means
Sold often and earns well. Protect the recipe, protect the price, never cut it in a discount campaign.
Sold often, thin margin. Raise the price 5–8%, trim one costly ingredient, or renegotiate the packaging.
Good margin, few orders. Reposition it on the menu, rename it, photograph it better, push it in the first three slots.
Neither. Rebuild the recipe cheaper or take it off the menu — every dog on the list dilutes the kitchen's speed.
A dish counts as popular when its share of orders is at least 70% of an even share — with four dishes that is 17.5% — and profitable when its contribution per order beats the menu average. Both thresholds are the industry-standard version of the test, computed live from your own sales, not from a benchmark someone else published.
One ZIP, four files, nothing to subscribe to
MenuMargin-OS-India-2026.xlsx — seven sheets, 200 ingredient rows, 400 recipe lines, 50 dishes, four example dishes and 23 example ingredients tagged EXAMPLE so you can see it working, then delete them.
START-HERE.html — opens in any browser and prints to PDF. The 15-minute set-up in order, the margin stack worked line by line, the sources behind every tax and commission default, Google Sheets steps, three ways to use it in your first week, and an FAQ that covers the mistakes people actually make.
README.txt for the file list, requirements and troubleshooting. LICENSE.txt — one business, unlimited devices, no resale or redistribution. Nine plain clauses.
No subscription, no account, no expiry, no telemetry. The file is yours on any device, in Excel or Google Sheets, for as long as you run the kitchen.
Every formula was recalculated on the example data and again on a fully blank template: zero errors, zero #DIV/0!, and blank cells stay blank instead of showing a wall of zeros.
It does not file GST returns, reconcile platform settlements line by line, or produce invoices. It prices a menu and tells you which dishes earn their place. Separate Digitalaikart tools do the rest.
If you sell food and something takes a cut before you do, this is your sheet
You quote a cake price from a competitor's Instagram. This costs the butter, cream and couverture you actually bought, adds the box, and shows what the app leaves you on a ₹899 cake.
Dine-in prices carried straight onto a delivery menu lose money at 21% commission. Set commission to 0% on the dine-in rows and 21% on the delivery rows, and price both properly.
No walk-in channel to fall back on, and packaging on every order. The workbook treats packaging as a real cost line, not a footnote, because at 400 orders a month it is ₹4,800.
Weekly subscription menus with a fixed per-meal price. Batch costing with portions-per-batch tells you what each of the 40 boxes costs before the delivery run.
Retail counter pricing and delivery pricing are different businesses. Cost the same pastry both ways and decide which channel deserves the effort.
A structured costing file you can fill from a client's purchase bills in an hour and hand back as a printed menu review. One licence per client business.
Fifteen minutes to set up, five minutes whenever a price changes
The set-up order. Settings first — your commission, GST, gateway and packaging. Then Ingredients, one row per pack you buy, with the pack size in grams or millilitres and the wastage percentage. Then Recipe Lines, one row per ingredient per dish. Then Dishes: portions per batch, packaging, menu price. Then Menu Engineering with last month's units sold, and Break-Even with your fixed costs. The guide walks each step with the example numbers still in place.
What is calculated. Cost per usable gram carries the wastage. Batch cost is a SUMIF over the recipe lines for that dish code. Cost per portion divides by portions per batch. Gross order value is menu price plus GST plus packaging. Commission, GST on commission and gateway are deducted to give what you receive; food cost and packaging are then deducted to give contribution. Food cost % is measured against the menu price excluding GST, as is contribution %.
The five-minute job afterwards. Butter moves ₹50 a pack, or your platform renegotiates to 23%. Change one cell and every dish that touches it re-prices, the verdicts update, the menu ranking shifts and the break-even point moves. That is an afternoon in a spreadsheet built from scratch, and five seconds here.
Plain .xlsx, no lock-in, no macros
One ZIP containing a single .xlsx workbook (Office Open XML), a printable HTML guide, a readme and a licence. Unzips with the built-in tools on Windows, macOS, Linux, Android and iOS.
Microsoft Excel 2016 or later, Microsoft 365, Excel for Mac, LibreOffice Calc 7 and later, WPS Office, and Google Sheets. Every function used behaves identically in all five.
Standard formulas only — SUMIF, AVERAGEIF, COUNTIF, VLOOKUP, IFERROR, ROUND. No security warning, nothing to enable, and the file passes a corporate mail filter that blocks .xlsm.
Rupees with the ₹ symbol in every money column, percentages to one decimal, quantities in grams, millilitres or pieces. All sheets print A4 landscape, fit to width.
Nothing is uploaded anywhere. No account, no cloud sync, no analytics. Your supplier prices and menu margins live in your own file.
Not accounting software, not a GST filing tool and not an invoicing app. The tax and commission figures are planning defaults from published sources as at November 2026, not tax advice — your contract, settlement statement and CA decide the real numbers.
One purchase, one business, forever
Your purchase covers use inside one business that you own or work for, on any number of that business's devices, for as long as you like, with no renewal. You may edit every cell, run it for every outlet of that same business as a separate copy, and print or export the output for a partner, a lender or your accountant. You may not resell, redistribute or republish the workbook, post it on a file-sharing site or template marketplace, or include it in a paid course or client deliverable — consultants and CAs using it with clients need one licence per client business. Full terms are in LICENSE.txt inside the ZIP.
One-time payment · Lifetime access · No subscription
Secure payment by Razorpay · UPI, cards, netbanking and wallets · download starts immediately
Questions before buying? WhatsApp +91 96826 00301 or email lonefaisal977@gmail.com. We answer, and we will tell you honestly if this is the wrong tool for your kitchen.
A working file, tested before it shipped
Recalculated end to end on the example data and again on a blank template. Zero formula errors, and blank rows stay blank rather than showing zeros.
If a file will not open, or a formula misbehaves on your machine, write to us with what you see and it will be fixed and re-sent, or refunded. Seven days, no argument.
No testimonials on this page, because we would rather you judged the maths above. Every figure in the worked example is produced by the file you are buying.
A working file. The ZIP contains one macro-free .xlsx workbook with seven sheets, a printable start-here guide, a readme and a licence. You open it in Excel, LibreOffice, WPS Office or Google Sheets and type your own pack prices and menu prices.
No. You type into the cream cells only: settings, ingredient pack prices, recipe quantities, menu prices, units sold and fixed costs. Every cost per gram, contribution, food cost percentage, dish class and break-even figure is already calculated.
Commission is a percentage you enter per dish, from your own contract. It is charged on the gross order value — menu price plus GST plus packaging — with 18% GST on that commission and the payment gateway fee deducted. The workbook then shows what you actually receive and what contribution is left after food and packaging cost. It does not guess a rate for you, because neither platform publishes one.
5% for a standalone restaurant, café, bakery, takeaway or cloud kitchen under SAC 9963, without input tax credit. The 18%-with-ITC option applies only to a restaurant inside a specified premises — a hotel where a room was supplied above ₹7,500 a night in the previous year. A standalone outlet cannot declare itself one.
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File > Save as Google Sheets. Every function used — SUMIF, AVERAGEIF, COUNTIF, VLOOKUP, IFERROR — behaves the same. No macros and no add-ins, so nothing is stripped on import.
Fifty dishes, 200 ingredients and 400 recipe lines out of the box. The guide explains how to extend the lookup ranges if your menu is bigger.
Nothing. That dish's code on the Recipe Lines sheet does not match the code on the Dishes sheet, or it has no recipe lines yet. A trailing space is the usual culprit. "Not found" in the ingredient column means that ingredient code is not on the Ingredients sheet.
Yes. Commission and GST are per-dish columns that default to your Settings values, so you can set commission to 0% on dine-in rows and your contract rate on delivery rows, and compare the same dish both ways in one file.
It classes the dish and gives one line of direction: protect a Star, raise the price on a Plowhorse, reposition a Puzzle, rebuild or drop a Dog. It also tells you the price that would hit your target food cost. It does not decide for you, and it is not financial advice.
After a successful payment on Razorpay you land on a thank-you page with a download button. Click it and the ZIP is yours immediately. No account, no email to wait for.
No. One payment of ₹249, no renewal, no expiry, no per-user fee. You keep the workbook and can run it for as many years as you like.
Digital products are non-refundable once downloaded. But if a file arrives corrupted, will not open, or a formula is broken, email lonefaisal977@gmail.com within 7 days and it will be fixed or refunded.
Other Digitalaikart products that sit alongside your numbers
Once the menu earns a contribution, the next question is when the money arrives. Thirteen weekly closing balances, with platform settlement lags built in.
The other half of ingredient control: what you have, what is expiring, and when to reorder, with SKU-level margin.
Tax invoices and quotations offline, with the CGST/SGST split by place of supply — for the catering and bulk-order side of the business.
One-time ₹249 · Excel + Google Sheets · Workbook, guide, readme & licence included.
Get MenuMargin OS →