A gift card balance tracker needs only a few columns: who issued it, what it was worth, what is left, when it expires, and a reminder that fires before the date. The sheet below does that in eight columns with two formulas, and it works in Excel and Google Sheets.
The columns to set up
Put these headings in row 1 of a new sheet, from A to H.
| Column | Heading | What goes in it |
|---|---|---|
| A | Issuer | The brand or shop that issued the card or voucher |
| B | Received on | The date you got it, plus who gave it if that helps |
| C | Original value | The face value in rupees |
| D | Balance | What is left now |
| E | Expiry date | The date printed on the card, voucher or message |
| F | Used on | A short note: what you bought and when |
| G | Days left | A formula |
| H | Reminder | A formula |
Format column E as a date, and keep the dates in one style such as 25-12-2026 so the formulas can read them.
The two formulas
In G2, work out the days left until expiry:
- =E2-TODAY()
Format G as a plain number, not a date. If it shows a date, change the format. In H2, turn that number into a plain word:
- =IF(D2<=0,"Used up",IF(G2<0,"Expired",IF(G2<=30,"Use soon","OK")))
Read it from the inside out: a zero balance says Used up, a negative day count says Expired, anything within 30 days says Use soon, and the rest say OK. Change 30 to 45 or 60 if you want earlier warnings. Copy both formulas down the rows.
To see the total you still have in live vouchers, use SUMIFS:
- =SUMIFS($D$2:$D$200,$G$2:$G$200,">=0")
It adds the balances only where the days left are zero or more, so expired cards do not inflate the total.
How do you keep the balance honest?
Update column D each time you use the card, and write the use in column F. Say a ₹2,000 voucher buys a ₹1,350 item: the new balance is 2,000 − 1,350 = ₹650, and F reads something like Ordered on 12 Dec, ₹1,350. If you use it twice, add the second use after the first, do not overwrite it.
Which vouchers are easy to forget?
- Ones received at festivals or weddings and tucked in a drawer
- Employer reward vouchers that arrive by email
- Cards with a small leftover such as ₹43 that never feels worth using
- Vouchers received as refunds or goodwill, which often carry a shorter expiry
Check the terms printed on each one, because validity, partial use and balance rules differ by issuer and are not something a template can know.
Should the sheet record the purchase or only the balance?
Keep them apart. When you buy a card for yourself, the purchase is a real expense on that day and belongs in your normal records, usually in the category of whatever you will use it on. When you receive a card as a gift, there is no expense for you at all, and the tracker only protects a value you were given. Using the card later is then a spend you did not pay for out of pocket, so many people note it in the sheet rather than their expense list.
Vouchers bought at a discount are a good case for the original value column. If a ₹1,000 voucher cost you ₹900, write 1,000 in column C and keep the ₹900 in the used-on notes, so the saving is visible when you review.
Add a monthly review
- Sort the sheet by column G, smallest first.
- Look at every Use soon row and decide what to buy or whether to gift it on.
- Remove rows that say Used up or Expired after you have checked them.
- Keep a note of any card that expired with money on it, so next time you act sooner.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


