The fair way to compare two cards is to apply each one's reward rules and fees to your own last six months of spending, then see which comes out ahead. List your spending by category, write each card's reward rate and annual fee from its own terms, and calculate. Advertised headline rates tell you little until they meet your actual categories.
What do I need before I start?
- Six months of statements, or your tracker's totals, grouped by category.
- The reward terms of each card: which categories earn, at what rate, and any monthly or yearly caps and exclusions.
- Each card's annual or joining fee, and any fee waiver condition.
- What a reward point or cashback rupee is worth to you, as stated in the card's own terms. If the value depends on how you redeem, use the lowest option you would really use.
No cards or rates are named here. Read the current terms from the issuer's own documents, since rates and caps change.
How do I run the numbers? A worked example
Everything below is invented. Say your six-month spend is ₹60,000 on groceries, ₹30,000 on fuel and ₹90,000 on online shopping, with nothing else going on the card. Card X pays a made-up 2 percent on online shopping and 1 percent elsewhere. Card Y pays a made-up 1.5 percent on everything. Card X has a ₹1,000 annual fee and Card Y has none.
| Category | Spend (₹) | Card X rate | Card X reward (₹) | Card Y rate | Card Y reward (₹) |
|---|---|---|---|---|---|
| Groceries | 60,000 | 1% | 600 | 1.5% | 900 |
| Fuel | 30,000 | 1% | 300 | 1.5% | 450 |
| Online shopping | 90,000 | 2% | 1,800 | 1.5% | 1,350 |
| Total | 1,80,000 | - | 2,700 | - | 2,700 |
Over six months, both give ₹2,700. Card X has a yearly fee of ₹1,000, so for six months, take half, ₹500. Card X nets ₹2,700 minus ₹500, which is ₹2,200, against Card Y's ₹2,700. On these numbers, Card Y wins. If online shopping were ₹1,50,000 instead of ₹90,000, Card X's online reward would be ₹3,000 and the picture would change. That is why you use your own spending.
Which hidden costs should I include?
- Extra charges on certain payments, such as fuel, wallet loads, rent or utility bills, if the card's terms list any.
- Caps on how much reward you can earn in a month or year.
- Categories excluded from rewards, often named in the fine print.
- The fee on foreign-currency spends, if you use the card abroad or on foreign sites.
- Interest, if you ever carry a balance. Interest can wipe out rewards in a single month.
How do I do it in a spreadsheet?
Put the categories in column A and spend in column B. Put each card's rate in columns C and E. Then in D2 type =B2*C2, copy it down, and total with =SUM(D2:D10). Subtract the prorated fee, for six months =annual fee/2, to get the net figure. Repeat for the second card, and compare the two nets. This works in Excel and Google Sheets.
How does a tracker supply the spending?
The hard part is getting six months of spending by category. If you have imported your statements into SpendixAI, the report builder can filter and group by category and by account, and you can download the result as CSV for your comparison sheet. A hand-built summary works as well.
Before you decide
- Check that the terms you used are the current ones.
- Run a second case where your spending changes, such as a month with a big trip.
- Count the fee, interest and any limit.
- Remember that closing or opening a card has its own effects, so ask your issuer or a professional if unsure.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

