Shopping

A coupon code log: code, expiry, minimum cart and used or not

A coupon code tracker spreadsheet with columns for code, source, expiry and minimum order, a made-up list of eight coupons and a monthly clean-up rule.

Editorial illustration for A coupon code log: code, expiry, minimum cart and used or not

A coupon code tracker spreadsheet needs six columns: the code, where it came from, its expiry date, the minimum order value, the category it applies to, and a status that says Open, Used or Expired. Add one formula that flags coupons expiring within a week, and delete expired rows on the first of each month. That is enough to stop codes dying unseen in your SMS inbox.

Which columns should the sheet have?

  1. Code: type it exactly as received, because many are case-sensitive.
  2. Source: SMS, app wallet, email, bank offer, friend referral.
  3. Expiry: a proper date such as 20-Nov-2026, not text like "end of month".
  4. Minimum order: the smallest cart value that unlocks the discount, in rupees.
  5. Category: groceries, fashion, food, electronics, travel.
  6. Status: Open, Used or Expired.

A seventh column, Notes, is useful for conditions such as new users only, one use per account or valid on app only. If the terms are long, paste the key line rather than the whole text.

What does a made-up list look like?

These codes are invented. The dates assume you are filling the sheet in mid-November.

CodeSourceExpiryMinimum orderCategoryStatus
SAVE150SMS20-Nov₹999FashionOpen
FRESH50App wallet22-Nov₹499GroceriesOpen
DINE100Email30-Nov₹600FoodOpen
GADGET250Bank offer15-Dec₹2,500ElectronicsOpen
WELCOME75Friend referral10-Nov₹399GroceriesExpired
FESTIVE200SMS31-Dec₹1,499FashionOpen
TRAVEL300App wallet05-Jan₹3,000TravelOpen
BOOK40Email18-Nov₹299BooksUsed

Here, six of the eight rows are Open and two are finished. Only coupons with a real minimum are worth a thought: GADGET250 needs ₹2,500 of spend, so it matters only if you were going to buy something that size anyway.

How do you make the sheet warn you about expiry?

Put the expiry dates in column C and the status in column F. In a helper column G, enter this formula in G2 and copy it down:

  • =IF(F2="Used","Done",IF(C2<TODAY(),"Expired",IF(C2-TODAY()<=7,"Use this week","Open")))

Sort or filter column G so that Use this week sits at the top. If you want colour, add a conditional formatting rule on the whole row with the custom formula =$G2="Use this week" and pick an amber fill. The same formula works in Excel and Google Sheets.

When should you delete a coupon?

Adopt one rule: on the first day of each month, delete every row whose status is Expired or Used. If you would like a record of what you used, move those rows to a second tab called Archive instead of deleting them. Otherwise the sheet fills with dead rows and you stop trusting it.

Should coupons go into your expense tracker?

Not as expenses, since a coupon is not money you spent. What does belong in the tracker is the purchase itself, at the price you actually paid after the discount. If you add shopping by hand in SpendixAI, enter the amount that left your account and use the notes field to mention the code, so you can check later that the discount applied. When you import a statement, the debit already shows the discounted amount.

How often should you open the sheet?

  • Whenever a coupon arrives by SMS or email: add it at once, or it will be forgotten.
  • Before any online shop above a few hundred rupees: scan for an Open code in that category.
  • Every Sunday: look at the Use this week filter.
  • On the first of the month: clean up.
SPENDIXAI JOURNAL

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

Explore your reports