Getting started

A reward points ledger that warns you before batches expire

Build a credit card reward points expiry tracker with one row per earning batch, days left, a warning flag and a rupee value for the item you want.

Editorial illustration for A reward points ledger that warns you before batches expire

Track credit card reward points as batches, not as one balance. Each row holds the points earned, the expiry date shown by the issuer and the days left, and a formula flags the batch that expires first, so you spend the oldest points before newer ones.

Why one balance hides the problem

A balance of 9,700 points looks healthy. If 3,000 of them expire next month, it is not. The issuer's rewards page may list expiry by batch or by date, and the way it works differs from one card to another, so copy what your own page says rather than assuming.

How do I set up the ledger?

  1. Columns: Card, Earned on, Points, Expires on, Days left, Status, Value in rupees.
  2. Fill one row per batch from the rewards page or statement.
  3. Days left in E2: =D2-TODAY().
  4. Status in F2: =IF(E2<0,"Expired",IF(E2<=60,"Use soon","OK")). The 60 is your own choice of warning window.
  5. Value in G2: =C2*$J$1, where J1 holds what a point is worth for the thing you plan to redeem.

Sort by Expires on, earliest first, so the row at the top is the one to act on.

A worked example with invented batches

Say today is 15 November 2026 and a point is worth ₹0.25 for the voucher you want. This value is invented; your catalogue or redemption page sets the real one.

BatchPointsExpires onDays leftValue (₹)
A3,00031 Dec 202646750
B5,50028 Feb 20271051,375
C1,20031 Jul 2027258300
Total9,700--2,425

Check: 3,000 + 5,500 + 1,200 = 9,700 points. Values: 3,000 × 0.25 = 750; 5,500 × 0.25 = 1,375; 1,200 × 0.25 = 300; total 2,425. Days from 15 November to 31 December is 15 + 31 = 46.

Batch A is the urgent one: use it by the end of December, ideally earlier, in case redemptions take time to process.

What should I do with expiring points?

  • Look at the redemption options and compare the value per point, not just the headline.
  • Check whether you pay a fee or minimum to redeem, and whether delivery takes days.
  • Do not spend money you would not otherwise spend just to use up points; the point of the ledger is to avoid waste, not to create purchases.

How often should I update it?

Once a month, on the day the statement arrives. Add the new points batch, remove redeemed ones, and look at the sorted list. Two minutes, and nothing sneaks up on you.

Where does spend tracking come in?

The ledger is about points, so it lives in a sheet or a notes app. If you also want the card's spending organised by month and category, a tracker that imports statements can do that, and the monthly review gives you a natural moment to update the ledger.

What about points that move between programmes?

Some issuers let you convert points into airline or hotel programmes, which have their own expiry rules. Give each programme its own block of rows, with the transfer date and the rule written beside it. Check the conversion ratio and any fee before you convert, because a move cannot usually be undone. Never convert just to avoid a lapse without reading the terms of the receiving programme.

Checklist

  • One row per batch with the issuer's date.
  • Warning window chosen.
  • Sorted by expiry.
  • Monthly update on statement day.
SPENDIXAI JOURNAL

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

Explore your reports