How to Calculate Your Real Credit Card Cashback (With Worked Examples)

Every cashback card ad leads with one number — "5% cashback," "2% on all spends." That number is almost never your effective rate once caps, exclusions, and fees are factored in. Here's how to actually calculate what you'll earn before you apply, using real math instead of the headline percentage.

For the mechanics behind why these caps exist in the first place, see how credit card cashback actually works. This post is just the arithmetic.

Step 1: find the real cap, not the rate

Almost every high cashback rate comes with a monthly or per-cycle cap. Take a card advertising "5% cashback on online spends, capped at ₹1,000/month." That cap means you earn 5% only on the first ₹20,000 of qualifying spend each cycle (since 5% of ₹20,000 = ₹1,000). Any online spending past ₹20,000 typically earns the card's base rate, often 1%.

Worked example: You spend ₹35,000 online in a month on this card.

• First ₹20,000 × 5% = ₹1,000 (hits the cap)
• Remaining ₹15,000 × 1% base rate = ₹150
• Total cashback = ₹1,150
• Effective rate = ₹1,150 ÷ ₹35,000 = 3.29%, not the advertised 5%

Step 2: subtract excluded categories from your spend base

Cashback categories usually exclude rent, wallet loads, fuel, insurance, government payments, and sometimes utility bills. If your ₹35,000 "online spend" included ₹8,000 in wallet top-ups, that ₹8,000 doesn't count toward the cashback calculation at all — it's not even eligible for the base rate in most cases.

Revised example: Same ₹35,000 spend, but ₹8,000 of it is wallet loads (excluded).

• Eligible spend = ₹27,000
• First ₹20,000 × 5% = ₹1,000 (cap hit)
• Remaining ₹7,000 × 1% = ₹70
• Total cashback = ₹1,070
• Effective rate on your total ₹35,000 spent = ₹1,070 ÷ ₹35,000 = 3.06%

This is the number that matters — cashback earned divided by everything you actually spent, not just the eligible portion.

Step 3: work out your annual net return after the fee

A card's real value is annual cashback earned minus its annual fee (after any waiver you actually qualify for).

Worked example: A card charges ₹999/year, waived if you spend ₹1,00,000 annually. You spend ₹4,20,000/year across categories, earning an average effective rate of 2.8% after caps and exclusions (using the method above, applied per category and summed).

• Annual cashback = ₹4,20,000 × 2.8% = ₹11,760
• You cleared the ₹1,00,000 spend threshold, so the ₹999 fee is waived
• Net annual benefit = ₹11,760

Now compare against a flat, uncapped 1.5% card with no annual fee at all: ₹4,20,000 × 1.5% = ₹6,300/year. The capped 5% card still wins here (₹11,760 vs ₹6,300), but the gap is much smaller than the "5% vs 1.5%" headline numbers suggest — and if your annual spend were lower, say ₹1,50,000, the capped card's advantage shrinks fast since most of that spend would fall outside the high-rate tier.

Step 4: check if it's points-based and apply the conversion rate

If the "cashback" is actually reward points (see the rewards vs cashback breakdown), add one more step: multiply points earned by the redemption value per point, not the marketing-stated value. A card offering "4 points per ₹100" sounds identical to 4% cashback only if each point redeems at ₹1. If redemption for cash/statement credit is actually ₹0.25/point (common), your real rate is 1%, not 4%. Always redeem-test with a small amount before assuming the conversion rate the brochure implies.

A quick formula to reuse

For any card and any month:

Effective cashback rate = Total cashback credited ÷ Total amount spent (including excluded categories)

Do this per statement cycle for 2-3 months before deciding if a card is genuinely good for your spending pattern, rather than trusting the number on the landing page. If you're comparing across multiple cashback cards, our best cashback credit cards guide lists actual cap and exclusion terms per card so you can run this calculation without hunting through T&Cs yourself. And if the card requires spend thresholds to waive its fee, check when paying an annual fee is worth it before committing to a spend pattern just to break even.

SBI Card's cashback variants and the Tata Neu Infinity Credit Card are both worth running through this formula rather than comparing headline rates directly — the cap structure differs enough between them that the "better" card depends entirely on your actual monthly spend, not the advertised percentage.