Cards and UPI

Tracking spend towards a card milestone benefit

Track spend towards a card milestone benefit with a running total since the period began, the amount remaining, days left and the weekly pace you need.

Editorial illustration for Tracking spend towards a card milestone benefit

To track spend towards a card milestone, keep a running total of the card's eligible spend since the benefit period began, subtract it from the target, and divide what is left by the weeks remaining. That gives you the weekly pace you need and shows early whether the milestone is within reach without extra spending.

What do you need from the card terms?

Write down four things from your card's own terms and put the date you read them next to them: the target amount, the start and end of the benefit period, which kinds of spend count toward it, and what the benefit is. Do not trust a number remembered from a sales call. If the benefit period runs from your card anniversary rather than the financial year, use that.

How do you set up the tracker?

Cell or columnWhat it holdsExample (hypothetical)
B1Target spend₹4,00,000
B2Period start1 June
B3Period end31 May
B4Spent so far₹2,45,000
B5Remaining spend₹1,55,000
B6Days left140

The formulas, with transactions in a separate range (dates in A, card in B, amount in C, an Eligible flag of Yes or No in D):

  • Spent so far in B4: =SUMIFS($C$2:$C$2000, $B$2:$B$2000, "Card A", $D$2:$D$2000, "Yes", $A$2:$A$2000, ">="&B2, $A$2:$A$2000, "<="&B3)
  • Remaining in B5: =MAX(0, B1-B4)
  • Days left in B6: =MAX(0, B3-TODAY())
  • Weekly pace needed: =IF(B6=0, 0, B5/(B6/7))
  • Progress: =B4/B1, formatted as a percentage

What does the pace look like in numbers?

With a target of ₹4,00,000 and ₹2,45,000 already spent, the remaining amount is 4,00,000 − 2,45,000 = ₹1,55,000. With 140 days left, that is 140 ÷ 7 = 20 weeks, so the pace needed is 1,55,000 ÷ 20 = ₹7,750 a week. Progress is 2,45,000 ÷ 4,00,000 = 61.25%.

Now compare with what you have actually spent per week. If your normal card spending is around ₹6,000 a week, you are short by about ₹1,750 a week, and you can decide calmly whether to move more regular bills to this card, or to let the milestone go.

Which spending counts, and which does not?

Mark each transaction Eligible or not, according to the card's terms. The typical trouble spots are spends that the card may treat differently, for example wallet loads, rent payments, fuel or government payments. The terms for your card are the only authority, so check them and write the answer in the sheet rather than assuming.

What if two cards chase different milestones?

Give each card its own copy of the block above, with its own target and period dates, since the periods rarely line up. Then list the weekly pace for each side by side. If one card needs ₹7,750 a week and the other needs ₹2,000, you can see which one deserves the next large purchase, and whether the household's total spending can support both at all.

When does the issuer's count update?

Statements post spend in cycles, and some purchases take days to appear. Your own running total may be ahead of the issuer's. Compare the two after each statement, and if they differ by more than a few transactions, find out which lines were left out.

Where can SpendixAI help?

Uploading each card statement with the card chosen as the account keeps every transaction tied to that card. You can then filter the period and total it, or download the rows as a CSV and paste them into the sheet above. Add recent swipes by hand while waiting for the next statement.

A monthly checkpoint

  1. Update spent so far after each statement or weekly.
  2. Check that the eligible flags are right.
  3. Read the weekly pace and compare it with your normal spending.
  4. Decide once a month, in writing, whether to push for the milestone.
SPENDIXAI JOURNAL

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

Explore your reports