Loyalty Program ROI Calculator for Indian Restaurants

A loyalty program is a discount with extra steps. It pays only if the extra visits it buys are worth more than the rewards it gives away. Enter eight figures and this Excel tells you whether yours does, what visit frequency it would take, and how generous you could afford to be.

Break-even visit frequency, which is the number nobody works out before launching
Points, cashback and a flat discount compared at the same generosity
Whether your reward reduces the value you charge GST on, under section 15(3)

No spam. Instant download link to your email.

Petpooja presents

Loyalty Program ROI Calculator

For Indian Restaurants

Sheets · Excel calculator

Updated Sep 2026

What's Inside

Five sheets, and no benchmarks

Instructions

What each sheet does and the order to use them in, including why you should read the break-even line before the ROI line.

Loyalty ROI

Eight inputs in cream cells. Out come reward cost, incremental contribution, net gain per month and per year, and cost per incremental visit.

Inside sheet 2: the break-even block

Margin left after the reward, the visits per customer per month you need, the lift that implies against today, and the reward rate you could afford at that lift. If the reward outruns your margin it says so plainly.

Points vs Cashback

The same generosity under three structures, including the flat discount comparison most loyalty content leaves out because it is the awkward one.

GST on the Reward

Both limbs of section 15(3) quoted, and a table showing which way each kind of reward falls and what you have to do to keep it there.

Worked Example

The whole model filled in with illustrative figures, clearly labelled as illustrative, so you can see the shape of the answer before entering your own.

Run the program on the same system that bills the table

Petpooja POSS gives you three click billing, KOT generation and routing, and real-time restaurant reports, automated and paper free. Sheet 2 needs your real visit frequency before the program started, which is a number only your billing data has.

Explore Petpooja POSS

Why This Matters

Everyone Tells You To Run One. Nobody Tells You If It Pays

There is no shortage of advice on restaurant loyalty programs: what they are, which type suits which format, ideas to try, which software to buy, points against cashback. Almost none of it asks the only question that decides whether to launch one.

A loyalty program is a discount with extra steps. You give away a slice of margin in the hope that people come back more often. It pays if the contribution from the extra visits beats the rewards you hand out plus what the program costs to run. That is arithmetic, and it takes about five minutes once someone lays it out.

The number that matters is not the ROI. It is the break-even: how often each enrolled customer has to visit for the program to wash its face. Work that out first and the launch decision usually makes itself, because you can compare it against the visit frequency you already have. Our guide to loyalty programs for Indian owners covers how to design one. This is the sheet that tells you what it has to deliver.

There is a harder version of the same test. Subtract the reward from your contribution margin. If what is left is zero or negative, no amount of extra footfall can rescue the program, because every additional visit loses money too. The calculator checks that first and says so in plain words rather than returning a confident negative number.

The other half nobody covers is tax. Whether a reward reduces the value you charge GST on depends on which limb of section 15(3) it falls under, and that turns on how the reward reaches the customer rather than what you call it. A points balance redeemed at the till and shown on the bill is a discount recorded on the invoice. A rebate settled outside the billing system has to satisfy a much longer list, including the recipient reversing input tax credit, which a walk-in diner does not have.

None of this needs an industry benchmark, and the sheet contains none. The figures in circulation for redemption rates and visit lift in India come from companies selling loyalty software, so the calculator runs entirely on numbers you already hold.

Sample Preview

The eight inputs on sheet 2

Here's a preview of what you'll get inside:

Average bill per visit, excluding GST, taken from your billing report rather than from memory

Gross contribution margin, sales less food cost and other variable cost as a share of sales

Customers enrolled, only those actually enrolled, not your whole customer list

Visits per customer per month before and after, the pair that decides everything, and the one people guess at

Reward as a share of the bill, and the share actually redeemed, because unredeemed rewards cost you nothing until they are used

Running cost per month, software, messaging, printing and staff time

Out of those comes the net gain per month and per year, the cost of buying one extra visit, and the break-even visit frequency. Pair it with the free restaurant profit margin calculator if you do not know your contribution margin yet.

Key Stats

The three numbers the sheet actually turns on

Margin less reward

Your contribution margin minus the reward you actually pay out. If this is zero or below, the program can never pay, because every extra visit loses money as well. The sheet checks this before anything else.

Source: the model itself. Take the margin from your P&L statement

15(3)

The sub-section that decides whether a reward comes out of the value you charge GST on. Limb (a) covers a discount recorded on the invoice. Limb (b) covers post-supply discounts and carries conditions a consumer program rarely meets.

Source: CGST Act 2017, section 15

Industry benchmarks in this calculator. The redemption rate and visit-lift figures in circulation for India come from companies selling loyalty software, so the model uses only numbers you already have.

Editorial policy, stated on the Instructions sheet

Common Mistakes

7 Loyalty Program Mistakes Restaurants Make

Setting the reward richer than the margin

If the reward you actually pay out is larger than your contribution margin, every visit the program buys loses money. Work the margin out first with the food cost calculator if you do not have it to hand. More footfall makes it worse, not better, and no forecast can fix it.

Never working out the break-even lift

The useful question is not what the program might return. It is what visit frequency it has to produce, compared with the frequency you have today. That comparison is usually the whole decision.

Counting rewards as free because nobody redeems them

Unredeemed points are a liability you have already promised. Redemption tends to arrive in clusters, so budget the cost at a redemption rate you would survive rather than the one you have seen so far.

Rewarding customers who were coming anyway

Most enrolled customers are your regulars, which means a large share of the reward buys behaviour you already had. The calculator handles this by charging rewards against all post-program revenue, not just the incremental part.

Never comparing it against a flat discount

A flat discount is simpler, its cost is known in advance, and it needs no software. A loyalty program only beats it if the returning behaviour is real, and the points against cashback question sits inside the same trade-off, so the comparison belongs in the decision.

Settling the reward outside the billing system

A reward that lands as a discount on an invoice sits in the straightforward limb of section 15(3). One settled separately has to meet conditions written with registered buyers in mind, including reversal of input tax credit.

Guessing the before figure

Visit frequency before the program is the input everything else rests on, and it is the one owners estimate from memory. It is in your billing data. Take it from there.

Comparison

Points on the bill against a flat discount

Question	Points on the bill	Flat discount every visit
Do they have to come back to get value	Yes, which is the point of it	No, taken on the same visit
Cost if they never return	Nothing	The discount already given, every time
Cost certainty in advance	Depends on redemption, so budget the worst case	Known exactly
Needs software	Yes, and a way to identify the customer	No
Rewards people who were coming anyway	Partly, and the sheet charges for it	Entirely
Reduces the value you charge GST on	Yes, where shown on the invoice it is redeemed against	Yes, it is a discount at the time of supply
The trap	A large unredeemed balance redeemed at once	You pay for loyalty you already had

Swipe the table sideways to see the full comparison.

These are the two ends of the range. Sheet 3 of the calculator adds cashback as the third structure, which sits between them.

Find out what your program has to deliver

Download the free Excel and get the break-even visit frequency in five minutes.

FAQ

Frequently asked questions

How do I know if my loyalty program is actually profitable?

Compare the contribution from the extra visits against the rewards you pay out plus the cost of running the program. The calculator does that, but it leads with a more useful figure: the visit frequency per enrolled customer that would make the program break even. Set that against the frequency you have today and the answer is usually obvious. Start by subtracting the reward you actually pay from your contribution margin, because if that is zero or below the program cannot pay at any volume. A loyalty program is a discount with extra steps, and it has to earn the discount back.

What redemption rate should I assume?

Your own, once you have one. This calculator deliberately contains no benchmark. The redemption figures in circulation for Indian restaurants come from companies selling loyalty software, and we do not build on numbers like that. Until you have your own data, run the sheet at a redemption rate you could survive rather than the one you hope for, and remember that unredeemed rewards are a promise you have already made. Redemption often arrives in clusters rather than evenly.

Does a loyalty discount reduce the GST I charge?

It depends on how the reward reaches the customer. Section 15(3) of the CGST Act allows a discount to come out of the taxable value in two situations. The first covers a discount given before or at the time of supply and duly recorded in the invoice, which is what a points balance redeemed at the till looks like. The second covers discounts after the supply, and requires a credit note under section 34, an agreement made at or before the supply, a link to specific invoices, and the recipient to reverse input tax credit. A walk-in diner has no input tax credit to reverse, so that route rarely fits a consumer program. Sheet 4 sets both out with the wording. Confirm your own position with your chartered accountant.

Is a loyalty program better than just giving a discount?

Only if the returning behaviour is real. A flat discount costs you less to run, its cost is known in advance, and it needs no software, but you pay it on every visit including the ones you were always going to get. A points program costs you nothing when someone never comes back. Sheet 3 compares them at the same level of generosity, and sheet 2 tells you how much extra visiting the program has to produce to be worth the extra machinery. A membership program is a third structure with different economics again.

Where do I get my visit frequency figure?

From billing data, not from memory. Visits per enrolled customer per month before the program is the input every other output rests on, and it is the one owners reliably overestimate. If your billing system identifies repeat customers, the figure is already there. If it does not, you can approximate it for a sample of known regulars over a couple of months, but treat the result as a range rather than a point. Our piece on customer retention explains why the measurement matters more than the tactic.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.

Real-time restaurant reports, automated and paper free

Petpooja POSS gives you three click billing, KOT generation and routing, and real-time restaurant reports, automated and paper free.

Book a Free Demo Call: +91-9104369797