Cards and UPI

Credit card reward points about to expire: a simple expiry tracker

Track credit card reward points and their expiry dates with a small sheet, an alert formula and a rupee example so points are redeemed before they lapse.

Editorial illustration for Credit card reward points about to expire: a simple expiry tracker

The forum question: how do I stop my credit card reward points expiring without my noticing? Keep a small sheet with one row per card, the points balance, the date you checked it, the earliest expiry you can find, and a formula that flags rows when the date is near. Then add a calendar reminder on the first of each month to refresh the balances.

Why points expire unnoticed

Points are not money in an account you see every day. They sit in a rewards section of the issuer's app or statement, and the expiry rules are set by each programme. Some expire points in batches by the month they were earned; some have no expiry at all. Your own card terms and rewards page are the only source for that, so check them rather than assuming.

Build the tracker

Make six columns: Card, Points, Value per point (₹), Expiry date, Status, Value (₹). Use one row per card and add a second row if a card has two batches expiring on different dates.

  1. Open each card's rewards page and note the points balance and the nearest expiry date.
  2. Enter the expiry date in column D as a real date, not text. Points go in B and the value per point in C.
  3. In column F, work out the rupee value with =B2*C2.
  4. In column E, show a status with =IF(D2<TODAY(),"Expired",IF(D2-TODAY()<=45,"Redeem soon","OK")). This works in Excel and Google Sheets.
  5. Sort by expiry date so the earliest one is always on top.
  6. Set a monthly calendar reminder to refresh the balances.

A worked example with invented figures

CardPointsValue per point (₹)Value (₹)Expiry
Card A12,4000.253,10031 Dec
Card B5,8000.201,16015 Feb
Card C9000.2522530 Jun

The value per point here is only an assumption; each catalogue or voucher option values points differently, so read your own. Totals: 12,400 x 0.25 = ₹3,100, 5,800 x 0.20 = ₹1,160 and 900 x 0.25 = ₹225, so about ₹4,485 of rewards in all. If today is 20 November, Card A's 31 December expiry is 41 days away, so the formula above says Redeem soon.

What should you do when a row turns amber?

  • Open the redemption options and compare what the points buy. A statement credit, a voucher and a catalogue item may each value a point differently.
  • Do not redeem into something you would not otherwise buy just because the clock is ticking.
  • If a partial redemption keeps part of the balance, check whether the expiry date applies to what remains.
  • Note the redemption in the sheet so the balance is updated.

Where does spending data help?

Points come from spending, so knowing which card you used for what is useful. In SpendixAI each imported transaction keeps its card account, so you can filter one card's spending and total it. That helps you decide which card to use for planned purchases. It does not read your points balance, because the app records transactions, not reward programmes; the sheet above stays your points ledger.

Which cards deserve a yearly review?

  • A card you no longer use may still hold points. Check them before the card lapses.
  • Before closing any card, read its terms to see what happens to unredeemed points.
  • Two cards with small balances may be worth combining in your habits, so one card builds points faster.
  • If your issuer changes the programme, update the value per point in your sheet the same day.

An honest limit

The tracker is only as good as the last time you checked. Programmes change rules, and the displayed expiry may not be the whole story. Treat the sheet as a prompt to look at the rewards page, not as proof of what you have.

SPENDIXAI JOURNAL

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

Explore your reports