DIGITALKARTAI.SHOP MenuMargin OS Recipe costing · menu pricing · margin control ONE DISH · ₹899 MENU PRICE · 21% COMMISSION Menu price + GST 5% + packaging ₹978.95 Commission 21% on the gross −₹205.58 GST on that commission (18%) −₹37.00 Payment gateway 1.84% −₹18.01 You receive ₹718.36 Food cost + packaging −₹469.11 CONTRIBUTION ₹249.25 · 27.7% MENU ENGINEERING STAR popular + profitable Truffle cake PLOWHORSE popular, thin margin Paneer wrap PUZZLE margin, few orders — DOG neither Garlic bread EXCEL + GOOGLE SHEETS · 7 SHEETS · 0 MACROS · INDIA EDITION 2026
Digitalaikart Original · Excel + Google Sheets System

MenuMargin OS — Recipe Costing & Menu Pricing System

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.

7
Sheets, one file
50
Dishes costed
200
Ingredient rows
0
Macros

One-time ₹249 ₹1,499 · instant download

Get MenuMargin OS — ₹249 →

Why Food Cost % Lies to You

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 Margin Stack, Worked on One Dish

The example cake in the file, line by line

LineWorkingAmount
Menu price (ex-GST)what the customer sees₹899.00
GST 5%899 × 5%₹44.95
Packaging charged to the customeryour box, billed at cost₹35.00
Gross order value899 + 44.95 + 35₹978.95
Commission 21%charged on the gross, before discounts−₹205.58
GST on that commission205.58 × 18%, not recoverable at 5% no-ITC−₹37.00
Payment gateway978.95 × 1.84%−₹18.01
You receive₹718.36
Food cost, wastage includedten ingredients−₹434.11
Packaging cost−₹35.00
Contributionwhat 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.

What Is Inside the Workbook

Seven sheets, each doing one job

Start Here

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.

Settings

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.

Ingredients

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.

Recipe Lines

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.

Dishes

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.

Menu Engineering

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.

Break-Even

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.

Built to be audited

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.

Built to print

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.

Menu Engineering, in One Picture

Popularity against contribution — the four classes and what each one means

Star

Sold often and earns well. Protect the recipe, protect the price, never cut it in a discount campaign.

Plowhorse

Sold often, thin margin. Raise the price 5–8%, trim one costly ingredient, or renegotiate the packaging.

Puzzle

Good margin, few orders. Reposition it on the menu, rename it, photograph it better, push it in the first three slots.

Dog

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.

What You Get for ₹249

One ZIP, four files, nothing to subscribe to

The workbook

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.

The start-here guide

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 and licence

README.txt for the file list, requirements and troubleshooting. LICENSE.txt — one business, unlimited devices, no resale or redistribution. Nine plain clauses.

No lock-in

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.

Tested before it shipped

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.

Honest about limits

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.

Who It Is For

If you sell food and something takes a cut before you do, this is your sheet

🍰

Home bakers

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.

☕

Cafés and QSRs

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.

🛵

Cloud and dark kitchens

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.

🍱

Tiffin and meal-prep services

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.

🧁

Bakeries adding a delivery line

Retail counter pricing and delivery pricing are different businesses. Cost the same pastry both ways and decide which channel deserves the effort.

📊

Consultants and CA firms

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.

How It Works

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.

File Format & Compatibility

Plain .xlsx, no lock-in, no macros

Format

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.

Works in

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.

No macros, no add-ins

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.

Units and format

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.

Data stays with you

Nothing is uploaded anywhere. No account, no cloud sync, no analytics. Your supplier prices and menu margins live in your own file.

What it is not

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.

Licence

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.

Get Instant Access

One-time payment · Lifetime access · No subscription

What happens after you pay

  • You land on a thank-you page with a download button
  • The ZIP downloads immediately — no account, no email to wait for
  • Unzip it and open the .xlsx
  • Read Start Here, then follow the six steps
  • Your first dish is costed inside fifteen minutes

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.

Buy With Confidence

A working file, tested before it shipped

Formulas checked twice

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.

Fixed or replaced

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 fake reviews

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.

Frequently Asked Questions

Is this an ebook or a working file?

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.

Do I need to know Excel formulas?

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.

How does it handle Swiggy and Zomato commission?

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.

Which GST rate should I enter?

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.

Does it work in Google Sheets?

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.

How many dishes can I cost?

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.

I deleted the example rows and a dish shows food cost ₹0. What broke?

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.

Does it handle dine-in and delivery pricing separately?

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.

Will it tell me what to do about a bad dish?

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.

How do I get the files after payment?

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.

Is it a subscription?

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.

Can I get a refund?

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.

Pairs Well With

Other Digitalaikart products that sit alongside your numbers

CashFlow Compass — 13-Week Cash Flow & Runway Planner

Once the menu earns a contribution, the next question is when the money arrives. Thirteen weekly closing balances, with platform settlement lags built in.

StockSense — Stock, Margin & Reorder System

The other half of ingredient control: what you have, what is expiring, and when to reorder, with SKU-level margin.

GST Invoice Generator Pro

Tax invoices and quotations offline, with the CGST/SGST split by place of supply — for the catering and bulk-order side of the business.

Browse all Digitalaikart products →

Know What Every Dish Earns

One-time ₹249 · Excel + Google Sheets · Workbook, guide, readme & licence included.

Get MenuMargin OS →