Cards and UPI

Tracking capped reward categories so you don’t overspend

Track a card reward category cap with a tracker showing spend so far, remaining room and a warning, so you switch cards once the cap is reached.

Editorial illustration for Tracking capped reward categories so you don’t overspend

If a card limits the rewards you can earn in a category each month, you only need to track three numbers: what you have spent in that category on that card this period, the spend at which the cap is reached, and what is left. When the remaining amount hits zero, put that category on another card or payment method until the period resets.

What should you read in the card terms first?

Check whether the cap is on the rewards or on the spend, the length of the period (a month, a statement cycle or a quarter), and which merchants count in the category. Write all three in the first row of your sheet, copied from the card's own terms, and note the date you checked. Caps and category lists can change.

How do you work out the spend that hits the cap?

If the cap is on rewards, divide it by the reward rate. Say a card gives 5% cashback on dining up to ₹1,000 a month. That is a hypothetical rate. The spend that fills the cap is 1,000 ÷ 0.05 = ₹20,000.

Now say you have spent ₹13,600 on dining with that card so far this month. You have earned 13,600 × 0.05 = ₹680. Remaining cashback room is 1,000 − 680 = ₹320, which is 6,400 of spend, since 320 ÷ 0.05 = ₹6,400. Beyond ₹20,000, further dining spend earns nothing extra from that category.

What does the tracker look like in a sheet?

Card and categoryCap on spend (₹)Spent so far (₹)Remaining (₹)Status
Card A, dining20,00013,6006,400Near cap
Card A, groceries10,00010,0000Capped
Card B, fuel4,0001,5002,500OK

Be strict about what counts as dining or groceries. A food-delivery order, a restaurant bill and a supermarket top-up may be classed differently by the card, so give each a clear category label in your own records and compare it with how the statement reports the merchant. If the card does not give rewards on a merchant you thought qualified, move it out of the tracked category and note why.

In the sheet, with dates in column A, card in B, category in C and amount in D, and the period start in G1, the spent-so-far cell for Card A dining is:

  • =SUMIFS($D$2:$D$500, $B$2:$B$500, "Card A", $C$2:$C$500, "Dining", $A$2:$A$500, ">="&$G$1)
  • Remaining: =B2-C2, with the cap on spend in B2 and spent so far in C2
  • Status: =IF(D2<=0, "Capped", IF(C2/B2>=0.8, "Near cap", "OK"))

Read the status column daily during the last week of the period, when the spend is usually largest, and at the moment you consider a big purchase in the category. If a ₹8,000 dinner booking would take you from ₹13,600 to ₹21,600 against a ₹20,000 cap, you know in advance that ₹1,600 of it earns nothing extra, and you can split the payment with another card.

What do you do when you reach the cap?

  1. Switch that category to a different card or to UPI or cash, whichever is better for you.
  2. Write the switch date in the sheet so the next month starts clean.
  3. On the period start date, reset the date in G1 and the tracker returns to zero.
  4. If you share the card with family, tell them too, since their swipes count against the same cap.

How can SpendixAI help?

Uploading each card statement with its account selected lets you filter by card and category in the Report builder for the period you care about. For a card category you check every week, a sheet is faster. Between statements, add recent swipes by hand so the total stays current.

Before the month starts

  • The cap, the period and the category list copied from the card's terms.
  • The period start date entered in the sheet.
  • The spend at which the cap is reached, worked out and written down.
  • A plan for where the category goes after the cap.
SPENDIXAI JOURNAL

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

Explore your reports