Shopping

Merchant offers on UPI apps: a tally of what you actually redeemed

Tally the UPI merchant offers you see against the ones you redeem and the saving each gave, to check whether browsing offers makes you spend extra.

Editorial illustration for Merchant offers on UPI apps: a tally of what you actually redeemed

To track UPI merchant offers you actually redeemed, keep a monthly tally with three numbers: offers seen, offers used, and the saving each gave, plus one honest column asking whether you would have bought the thing anyway. The tally answers a question that scrolling never will: are these offers saving you money, or are they finding you things to spend on?

What does the tally track?

  • Offers seen: a rough count of offers you noticed or opened this month.
  • Offers used: each one you redeemed, with the merchant and date.
  • Spend: what you paid at that merchant.
  • Saving: the discount or cashback that offer gave, once it was actually received.
  • Planned: yes if you already meant to buy it, no if the offer prompted the purchase.

Offers seen can be an estimate. The other four columns should be exact, because they are what the decision rests on.

A made-up month

Say you saw 14 offers in a month and used five. Here are the five.

OfferSpendSavingPlanned?
Food delivery₹450₹30No
Grocery₹1,500₹50Yes
Movie tickets₹700₹20Yes
Phone accessory₹1,299₹75No
Cafe₹520₹40No
Total₹4,469₹2153 of 5 prompted

What does the tally show?

Savings add up to ₹215 on ₹4,469 of spending. But three of the five purchases, the delivery, the accessory and the cafe, were not planned. Those three cost ₹450 + ₹1,299 + ₹520 = ₹2,269, and the offers on them saved ₹30 + ₹75 + ₹40 = ₹145. So in this invented month, the offers saved ₹145 while prompting ₹2,269 of spending you had not intended. The two planned purchases, grocery and movie, saved ₹70 on spending you would have done anyway, which is the genuine gain.

You used 5 of the 14 offers you saw. The other nine cost you nothing, and that is the best outcome of all.

Is browsing offers a spending habit?

Sometimes. If your unplanned column keeps growing while the saving column stays small, the pattern is clear: the app is a shop window. That is useful to see in numbers. It does not call for guilt, just a decision, such as opening the offers tab only when you already have a purchase in mind.

Counting offers seen takes almost no effort if you add a tick in the sheet each time you open the offers tab and notice one worth a second look. A rough count is fine. What you want is the ratio, here 5 used out of 14 seen, and whether it climbs on days when you are bored or hungry.

How do you count a saving honestly?

Count only what you received. A promised ₹75 that never arrived is zero. Count the saving against what you would have paid without the offer, not against an inflated list price. If you split a bill and the offer covered only part, enter only your share of the saving.

If an offer needed a bigger basket to qualify, count the extra items you added. A ₹50 saving that needed ₹400 of things you did not want is not a saving.

Where does the tally live?

A single tab with five columns is enough, and a formula such as =SUMIFS($C$2:$C$100,$D$2:$D$100,"No") gives your savings on unplanned purchases, and the same with the Spend column gives the unplanned spend. The purchases themselves already sit in your records. In SpendixAI, you can import your statements, then use the Report builder to filter the merchants you used offers on and see what you spent there in a month.

A simple end-of-month routine

  1. Count the offers you remember seeing and write the number down.
  2. List each offer you used, with spend and saving received.
  3. Mark each purchase as planned or unplanned.
  4. Compare unplanned spend with unplanned savings.
  5. Decide one rule for next month, and write it at the top of the tab.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports