Cards and UPI

How to work out the effective reward rate on your own card spending

Effective reward rate on a credit card: points earned times what you really get per point, less fees, divided by your spend, with a worked example.

Editorial illustration for How to work out the effective reward rate on your own card spending

Your effective reward rate is the rupee value of the rewards you earned, minus what the card cost you in fees, divided by what you spent. It is almost always lower than the advertised rate, because you rarely redeem at the best value and the card usually has a fee. Here is how to calculate your own, using a year of your statements.

What are the four numbers you need?

  1. Total spend on the card over the period, excluding anything that earned no points if you want a strict figure.
  2. Points earned over the same period, from your statements.
  3. Value per point, from your own redemptions, in rupees.
  4. Fees and taxes the card cost you in that period, as shown on the statements.

The value per point should come from what you actually received. If you have never redeemed, you do not yet have a real number, and any rate you compute is a guess.

What does the calculation look like?

Say a card carried ₹3,60,000 of spend in a year. It earned 7,200 points. From earlier redemptions, you got ₹2,400 of value from 6,000 points, which is ₹0.40 per point. The fee and tax together came to ₹1,180.

StepWorkingResult
Value of points earned7,200 × 0.40₹2,880
Net value after the fee2,880 − 1,180₹1,700
Gross rate2,880 ÷ 3,60,0000.80%
Effective rate1,700 ÷ 3,60,0000.47%

In words: for every ₹100 you swiped, the card gave back about 47 paise after its own cost. As a formula, with spend in B1, points in B2, value per point in B3 and fees in B4, the cell is =(B2*B3-B4)/B1, formatted as a percentage.

How sensitive is the result to the value per point?

The value per point moves the answer more than anything else, so test a few values.

Value per pointValue earnedAfter the feeEffective rate
₹0.25₹1,800₹6200.17%
₹0.40₹2,880₹1,7000.47%
₹0.50₹3,600₹2,4200.67%

Read the first row as a cautious case, the second as your actual redemptions, the third as the case where you always redeem well. The same card and the same spending give an answer from 0.17% to 0.67%, so any rate quoted without a value per point is incomplete.

Where do you get the value per point?

Take each redemption you have made, find the cash price of what you received, and divide by the points used. A redemption of 4,000 points for something priced at ₹1,200 is 1,200 ÷ 4,000 = ₹0.30 per point. Average several redemptions rather than relying on one, and weight them by points: total rupee value divided by total points redeemed. Statement credit, vouchers and travel bookings can all give different values, so keep them separate if you use more than one route.

What should you leave out, and what should you keep?

  • Leave out spend you made only to collect points. Count only what you would have spent anyway.
  • Keep fees, add-on card fees and any charges that came only from holding the card.
  • Leave out welcome bonuses from the yearly rate, or show them separately, since they come once.
  • Value unredeemed points at what you realistically expect to get, not the highest figure.

How can SpendixAI help with the inputs?

The hardest input is total spend. With statements uploaded and the card chosen as the account, you can use the reports and the CSV download to total a card's spending for the period, then paste that figure into the formula. The points and the redemption values still come from your own card statements.

Next steps

  1. Gather twelve months of statements for one card.
  2. Fill the four numbers and compute the rate.
  3. Repeat with a second value per point to see the range.
  4. Write the result with the date, so you can compare it next year.
SPENDIXAI JOURNAL

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

Explore your reports