Cards and UPI

Tracking lounge visits and welcome vouchers on your card

A credit card benefits tracker for lounge visits and welcome vouchers: one sheet with the limit per period, used count and expiry date for each benefit.

Editorial illustration for Tracking lounge visits and welcome vouchers on your card

A card benefits tracker needs a row for each benefit and five columns: the benefit, the limit per period, how many you have used, how many remain and the date it renews or expires. Copy the limits from your own card terms, not from memory, and the sheet will tell you what is still unused before the period ends.

What goes in the benefits sheet?

BenefitLimit per periodPeriodUsedRemainingRenews or expires
Airport lounge visits (placeholder)4Quarter13End of quarter
Welcome voucher (placeholder)1Once0131 Jan
Partner offer (placeholder)2Year20End of year

Every number above is a placeholder to show the layout. Your card's limits, and which services count, are in its terms, and they can change. Write the date you last checked them in a Source column, so you know how old your information is.

Which formulas keep it tidy?

  • Remaining in E2: =MAX(0, B2-D2)
  • Days left in G2, if the expiry date is in F2: =F2-TODAY()
  • A reminder flag in H2: =IF(AND(E2>0, G2<=30), "Use soon", "")
  • Total visits used this year: =COUNTIFS($B$2:$B$200, "Lounge", $A$2:$A$200, ">="&$J$1), where a use log has dates in A and the benefit type in B

Should you also keep a use log?

Yes, a second tab is worth it. One row per use: date, benefit, place, number of guests if any, and any reference number. The count in the first tab then comes from the log, so it cannot drift. If you disagree with a bill or a deduction later, the log shows what you used and when.

What about guests, add-on cards and shared benefits?

Some benefits cover only the cardholder, some allow guests, and some count every visitor against the same limit. Do not guess. Add a Notes column and write what your terms say about guests and add-on cardholders, then record every visit with the number of people. If a family member uses the add-on card's benefit, log it under their name so the total does not surprise you.

How do you handle vouchers with an expiry date?

Treat a voucher as money that disappears on a date. Enter its value, its expiry and the place it works. Put the expiry on your calendar a few weeks before. A voucher you never use is a benefit you did not receive, so leave it out of any calculation of what the card is worth to you.

Why track the rupee value?

If you add a Value column, with what each used benefit would have cost you, you can add it up at year end. That figure goes into the yearly cost worksheet for the card, next to the fee, so you can judge whether the card earns its place. Use a realistic cash value for what you would actually have bought, not the voucher's face value.

A calendar reminder on the first of each month works better than good intentions. On that day, open the sheet and read only the rows with Remaining above zero and an end date inside the next two months. Those are the benefits you would otherwise forget, and the list is usually short.

Where does SpendixAI fit?

The sheet holds counts and dates. SpendixAI holds the spending that the card statements show, so you can see how much a card is used overall when you review the benefits. It does not keep benefit counts.

Setup in ten minutes

  1. Open your card's benefits page and list every benefit.
  2. Copy each limit and its period into the sheet.
  3. Add the use log tab and enter past uses you remember.
  4. Set the Use soon flag and check it at the start of each month.
SPENDIXAI JOURNAL

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

Explore your reports