Cards and UPI

Gift card and voucher balance tracker so they don’t expire

A simple gift card balance tracker for Excel or Google Sheets, with columns for issuer, value, balance and expiry, plus formulas that flag vouchers to use soon.

Editorial illustration for Gift card and voucher balance tracker so they don’t expire

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.

ColumnHeadingWhat goes in it
AIssuerThe brand or shop that issued the card or voucher
BReceived onThe date you got it, plus who gave it if that helps
COriginal valueThe face value in rupees
DBalanceWhat is left now
EExpiry dateThe date printed on the card, voucher or message
FUsed onA short note: what you bought and when
GDays leftA formula
HReminderA 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

  1. Sort the sheet by column G, smallest first.
  2. Look at every Use soon row and decide what to buy or whether to gift it on.
  3. Remove rows that say Used up or Expired after you have checked them.
  4. Keep a note of any card that expired with money on it, so next time you act sooner.
SPENDIXAI JOURNAL

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

Explore your reports