To track a fee waiver target, keep a running total of the spend that counts, subtract it from the target in your card's terms, and divide the rest by the weeks left before the cut-off. The cut-off matters: spend must usually be posted by a date, not just swiped. So plan to finish a few days early.
What do you need from the card terms?
Copy these into the sheet, with the date you read them: the spend target, the period it is measured over, the date the period closes, which spend counts and whether the waiver is automatic or on request. Where the terms are unclear, ask the issuer in writing and save the reply. This article quotes no targets, because each card differs and they change.
How do you find the period?
Many cards measure the waiver period from the date the last fee was charged, or from the card anniversary, and not from January or April. Check your statement for the previous fee line and count a year from there. If your sheet measures a calendar year while the card measures from another date, the totals will never agree.
What does the pace look like?
Say a target is ₹2,00,000, the period closes in 84 days and ₹1,12,000 has counted so far. Remaining spend is 2,00,000 − 1,12,000 = ₹88,000. Weeks left are 84 ÷ 7 = 12, so the weekly pace is 88,000 ÷ 12 = about ₹7,333. If you finish three days before the cut-off to allow for posting, there are 81 days, or about 11.6 weeks, and the pace becomes roughly ₹7,600 a week.
- Remaining: =MAX(0, B1-B2), with the target in B1 and spend so far in B2
- Days left to your safe date: =B3-TODAY()-3, with the period close date in B3 and 3 spare days
- Weekly pace: =IF(B5<=0, 0, B4/(B5/7)), with remaining in B4 and days left in B5
Do not forget that spending posted after the cut-off will not count, however early you swiped. For card purchases, the date that matters is the billing or posting date, which can be a few days after the swipe. Note both dates for large purchases near the end of the period.
Should you move spending or add spending?
Moving is fine: using this card for bills and purchases you were making anyway. Adding is a cost. If the fee is ₹1,000 and reaching the target would need you to spend ₹20,000 more than you planned, the fee is not what you are really paying. Compare the fee with the weekly pace and with what you normally spend, and decide in writing.
| Question | Your answer |
|---|---|
| Will normal spending reach the target on its own? | Compare weekly average with the pace needed |
| How much would have to move from other cards? | Remaining spend minus expected normal spend |
| Is anything large coming, such as insurance or fees? | Add it to the expected total |
| Is the fee worth it if the waiver is missed? | Use the yearly cost worksheet |
What can quietly lower the total?
- Refunds and reversals reduce the counted spend.
- Spend categories your terms exclude, which may include some bill payments, wallet loads or fuel.
- Purchases that post after the cut-off.
- Instalment conversions, which may be treated differently.
Where does SpendixAI fit?
Importing each card statement with the card as the account lets you total the card's spending for the waiver period, and a CSV download hands the rows to your sheet. Add recent swipes by hand between statements. Remember that statement totals are the figures the issuer will use.
A weekly line to write
Each week write one line: spent so far, remaining, days left, pace needed. If the pace needed keeps rising, you will see it early.
- Spent so far matches the latest statement plus recent swipes.
- Remaining is the target minus eligible spend only.
- Days left counts to your safe date, not the last day.
- The decision, whether to move spending, is written beside the pace.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


