A card fee-waiver tracker compares what you have spent on a card this card-year with the spend your own card terms ask for, and tells you the monthly pace needed to reach it. You take the condition from your card's terms or your bank's current communication, not from a blog, because conditions differ and change. The sheet then does the arithmetic.
Which numbers must you copy from your own terms?
- The annual fee amount, and whether GST is added on top of it
- The spend needed for a waiver or reversal, if your card offers one
- The date the card year starts, which may be the month you got the card rather than April
- What kinds of spend count; many cards list exclusions, so read the fine print on yours
- When the fee is billed and when a waiver is applied, according to your terms
If you cannot find a figure, leave that cell blank and ask your bank through its usual customer channel. A tracker built on a guessed figure is worse than none.
How do you work out the monthly target?
Use made-up numbers to see the method. Say your terms ask for ₹1,50,000 of eligible spend in the card year, and your own records show ₹78,400 of eligible spend after five months. Remaining spend needed is ₹1,50,000 − ₹78,400 = ₹71,600. With seven months left, the pace is ₹71,600 ÷ 7 ≈ ₹10,229 a month.
| Cell | Meaning | Example value |
|---|---|---|
| B1 | Spend needed for waiver | 150000 |
| B2 | Eligible spend so far | 78400 |
| B3 | Months left in the card year | 7 |
| B4 | Still to spend | =B1-B2 gives 71600 |
| B5 | Monthly pace | =ROUNDUP(B4/B3,0) gives 10229 |
Compare B5 with what you already spend on the card in a normal month. If your ordinary use already clears it, you need to do nothing. If it is far above, the honest conclusion may be to accept the fee or review the card.
Should you spend more just to hit the target?
Only on things you were going to buy anyway. If the fee is, say, ₹999 and you would need to bring forward ₹20,000 of purchases or buy something unneeded, the waiver saves less than the impulse costs. Moving a planned insurance premium or a school fee to the card, if the merchant accepts it and your terms count it, is different from inventing spending.
Setting up the sheet
- Add a tab for each card, with the card-year start date in the first row.
- Log each statement's eligible spend in a monthly row, leaving out items your terms exclude.
- Keep a running total using =SUM($C$4:C4) copied down.
- Add a status cell: =IF(B2>=B1,"Target reached","Keep going").
- Set a calendar reminder for the month before the card-year ends to review progress.
If you hold more than one card, keep a separate tab for each. Spending on a card whose terms you are not trying to meet does not help the one you are tracking, and mixing them makes the monthly pace meaningless. Write the card's name and the last four digits of its number in the tab title so you do not confuse two cards from the same bank.
What about doing it in an app?
If you import each card's statement into SpendixAI with the right account selected first, every transaction keeps its card, so you can filter one card's spending for the year and compare it with your sheet's target. The tool does not know your card's waiver rules, so the eligible-spend decision stays with you.
When to review the card instead
If you repeatedly miss the target, list what the card gives you in a year, such as points you actually redeem, against the fee. If the answer is clear, you can decide whether to keep it, ask the bank for a different variant or close it, after reading the closing terms.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


