₹6,250 of rewards sounds good until the fees come off. In the made-up April to March year below, ₹6,250 turns into ₹4,890 after fees, which is a very different feeling from the headline. To find your real total, go through each source once, add up what was actually received, then subtract the fees and any extra spending that came with it.
Where do you look for cashback?
- Credit card statements: statement credits and cashback lines.
- UPI app reward history: scratch cards and offers credited.
- Wallet balances: cashback paid into a wallet, noting how much you have spent from it.
- Shopping apps: coins or points, counted only when you redeemed them.
- Referral bonuses from any of these, listed separately.
Use the April to March financial year if you plan to compare with tax records, and the calendar year if not. Either works as long as you say which one the total covers.
A made-up financial year
| Source | Received in the year | Cost attached |
|---|---|---|
| Card statement credits | ₹3,600 | Annual fee ₹1,000 |
| UPI app rewards | ₹1,150 | None noted |
| Wallet cashback | ₹720 | Convenience fees ₹360 |
| Shopping app coins redeemed | ₹480 | None noted |
| Referral bonuses | ₹300 | None noted |
| Total | ₹6,250 | ₹1,360 |
Net rewards = ₹6,250 − ₹1,360 = ₹4,890. If the spending that carried these rewards was ₹2,10,000, that is about ₹2.33 for every ₹100 spent, shown here as an invented example and not as a typical rate.
Read the table by source as well as in total. The card brought in ₹3,600 and its annual fee was ₹1,000, so it netted ₹2,600 by itself. Wallet cashback of ₹720 less ₹360 of fees netted just ₹360. Splitting it this way shows which arrangement is carrying the rest.
What should you subtract?
Anything you paid because of the reward arrangement: an annual or joining fee on a card, a convenience fee charged by an app on bill payments, a wallet loading charge, or a late fee from a bill you only paid late chasing an offer. Do not subtract your ordinary spending, because you would have spent it anyway. Do count extra spending that an offer pushed you into, but be honest about which purchases those were.
How do you do the yearly pass?
- Collect twelve months of statements for each card and each wallet.
- Search each for credit lines marked cashback, reward or points redemption.
- Enter each one in a sheet with the date, source and amount.
- Total by source with =SUMIFS($C$2:$C$300,$B$2:$B$300,"Card") and similar for each source.
- Add the fees from the same statements and subtract them.
- Compare the net with the spending that generated it.
What about points you have not used yet?
Leave them out of the total. A balance of points is a promise, not money, and it may expire or be worth less than shown. When you redeem them, enter the rupee value you actually received. If you want a figure for unredeemed points, keep it in a separate cell labelled 'not counted'.
How does a tracker help?
The credit lines are already scattered across your statements. If you have been importing them into SpendixAI, a custom Cashback category and the Report builder can total that category by month or year, and a CSV download of the result gives you a clean list to check against the wallet figures. Anything credited outside a statement, like scratch cards, is added by hand.
What is the number for?
It is a figure for your own decisions, such as whether a card's annual fee is earning its place. If the fee is larger than the rewards, the card cost you money. If it is smaller, it paid for itself. Whether to keep or change a card depends on more than rewards, so weigh the figure against your repayment habits and your needs.
Next step
Do the pass once, save the sheet as 'rewards, year ending March', and next year start from the same layout. You will know by April whether the effort was worth it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

