Cards and UPI

Reward points expiry: how to keep track before they lapse

Reward points expiry is easier to handle with a dated list: record each batch, sort by expiry, check monthly, then redeem or let go on purpose.

Editorial illustration for Reward points expiry: how to keep track before they lapse

Points that vanish quietly are usually points nobody was looking at. The fix is an expiry list sorted by date, with a ten-minute check once a month and a rule you decide in advance: redeem it, or let it go on purpose. This article builds that list without assuming any card's policy, because policies differ and change.

Do your points expire at all?

Some programmes never expire points while the account is active, some expire them after a period, and some treat each batch differently. Do not rely on memory or on what a friend's card does. Open your own card's reward terms or app and find the date the points expire, as that card states it. If you cannot find it, ask the issuer in writing and keep the answer.

How do you build an expiry list?

List every batch of points that carries its own expiry date. If your programme shows one date for the whole balance, you need only one row.

BatchPointsExpiry dateDays leftPlan
Festive offer bonus2,50030 Nov18Redeem for a household item
Regular points, October1,10031 Jan80Check in December
Welcome bonus3,00030 Apr169Hold; review in February

The dates and numbers are examples only. Write the expiry date exactly as your card shows it, and write the source, such as statement or app, in a notes column so you can verify later.

Which formulas keep it up to date?

  • Days left in D2, with the expiry date in C2: =C2-TODAY()
  • A flag in E2: =IF(D2<=30, "Act now", IF(D2<=90, "Plan", "Fine"))
  • Sorted by soonest expiry (Excel 365, Excel 2021 or Google Sheets): =SORT(A2:E50, 3, TRUE)

The 30 and 90 are your own thresholds; change them to suit how long a redemption takes you. A redemption can take days to arrive, so leave slack.

Those example rows assume today is 12 November. The Days left column is recalculated each time you open the file, which is why it uses TODAY() rather than a typed number.

What is a good monthly check?

  1. Open the list and the card app on the same day each month, for example the day after the statement.
  2. Update points balances and add any new batch with its expiry date.
  3. Look at everything flagged Act now or Plan.
  4. For each, choose: redeem, hold or let go. Write the choice and the date in the Plan column.
  5. Re-sort by expiry date.

Should you redeem just because points are about to expire?

Not automatically. A redemption at a poor value to save points from lapsing can cost more than the points were worth. Ask a plain question: is there something I would buy anyway at about this price? If yes, redeem. If no, letting go is a legitimate choice, and writing down that you chose it ends the guilt. Buying something you do not need to avoid losing points is a way of spending money.

What if you have several cards?

Add a Card column and keep one tab per card, or one long list with the card name in the first column and a filter. Sort the combined list by expiry date, so the batch that lapses first is at the top regardless of which card it sits on. Cards that share a programme may pool points, so check whether you are listing the same points twice.

Where does the rest of the card record live?

The points list works best in a sheet. SpendixAI is for the rupee side: statements imported with the card as the account, and spending by category. If you already review rows after each import, the monthly points check fits into the same sitting.

Before you close the file

  • Every batch has an expiry date copied from the card's own terms.
  • The list is sorted with the earliest date at the top.
  • Every flagged row has a decision and a date.
  • The balance matches the card app.
SPENDIXAI JOURNAL

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

Explore your reports