Cards and UPI

An annual fee tracker for every card and membership you pay

An annual fee tracker for every card and membership you pay: a sheet with the fee, month it posts, waiver status and the rupee value of benefits you used.

Editorial illustration for An annual fee tracker for every card and membership you pay

An annual fee tracker is a single sheet with one row for each card or membership, showing the fee, the month it posts, whether it was waived and what you actually got back. Yearly fees are easy to forget because they arrive once, so the sheet's main job is to warn you a month ahead and to show whether each one earned its place.

Which payments belong in the tracker?

Credit cards are the obvious ones, but the same logic covers any yearly or renewing charge: a club or gym membership, a streaming or software plan billed once a year, a travel or lounge membership, a magazine subscription, a domain or cloud storage plan. If it renews once a year and you would not remember the date, it belongs here.

What columns does the sheet need?

  • A: Name of the card or membership.
  • B: Fee posted, in rupees, exactly as the statement shows it, including any tax line on the same charge.
  • C: Date the fee last posted.
  • D: Waived, with Yes or No.
  • E: Value of benefits used, in rupees, at the price you would really have paid.
  • F: Next fee date, calculated.
  • G: Net cost, calculated.

What does it look like with numbers?

Here are three invented rows.

NameFee posted (₹)WaivedBenefits used (₹)Net cost (₹)
Card A1,000No2,400-1,400
Card B500Yes00
Club membership4,000No1,5002,500

A negative net cost means the benefits you used outweighed the fee. Card A's fee was 1,000 and the benefits were worth 2,400, so the net is 1,000 − 2,400 = −₹1,400. Card B's fee was waived, so it costs nothing. The club membership cost 4,000 and delivered 1,500, a net cost of ₹2,500. Across all three, fees actually paid are 1,000 + 4,000 = ₹5,000, benefits used are ₹3,900, and the net is ₹1,100.

Which formulas keep it current?

  • Net cost in G2: =IF(D2="Yes", 0, B2-E2)
  • Next fee date in F2: =EDATE(C2, 12)
  • Days until the next fee in H2: =F2-TODAY()
  • Reminder in I2: =IF(AND(H2>=0, H2<=45), "Review now", "")
  • Fees actually paid: =SUMIFS($B$2:$B$50, $D$2:$D$50, "No")

EDATE works in Excel and in Google Sheets, and adds whole months to a date. Check the date your statement shows for the last fee, because the posting date may shift.

Keep a short Notes column too. Write who to contact, how you pay (card, auto-debit, app store), and whether renewal is automatic. A year from now, those three facts are what you will wish you had written down.

Why review a month before the fee posts?

A month's notice gives you time to ask for a waiver if the terms allow it, to ask whether a lower-cost variant exists, to use the remaining benefits, or to cancel in time if you decide to. Once the fee has posted, you are in a different conversation. Set the reminder on your calendar, not only in the sheet.

Can SpendixAI help find the fees?

After you import statements with the account chosen, you can search or filter the rows for fee lines and keep a custom category for annual fees, so one report shows them all together. The sheet adds what statements do not show: whether it was waived, and what you got back.

What do you do with the totals at year end?

Add up the net cost column and look at the largest numbers first. A fee that was paid and delivered little is a candidate for a call to ask about a waiver or a cheaper variant. A fee that was waived every year but only because of a spending push deserves the question in the next article about waiver targets: was the spending going to happen anyway? Keep the sheet's totals for each year in a small table, so you can see the direction over time rather than one snapshot.

Setting it up this week

  1. List every card and yearly membership you can think of.
  2. Look through the last twelve months of statements for fee lines.
  3. Enter the fee and posting date for each one.
  4. Add the value of benefits you used.
  5. Put a reminder on the calendar for each next fee date.
SPENDIXAI JOURNAL

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

Explore your reports