Spreadsheets

Card rewards vs annual fee: a one-tab worth-it sheet

A one-tab sheet that compares the rewards you actually earned from logged spend against your credit card's annual fee, with a clear net-benefit cell.

Editorial illustration for Card rewards vs annual fee: a one-tab worth-it sheet

To judge whether a credit card is worth its annual fee, list your real yearly spend by category, enter the reward rate you actually get on each, multiply, and subtract the fee. The result is your net benefit. If it is small or negative, the card costs you more than it returns, whatever the brochure said.

What should the one-tab sheet contain?

ColumnHeadingWhat you enter
ACategoryGroceries, Fuel, Online shopping, Dining, Other
BYearly spend on this card (₹)From twelve months of statements
CEffective reward rateAs a percentage, after you convert points to rupees
DMonthly cap (₹)Reward cap per month, if the card has one
ERewards earned (₹)=MIN(B2, D2*12)*C2, or =B2*C2 when there is no cap

The reward rate is your own entry. Read the card's current terms, work out what one point is worth when you redeem it, and write the effective rate in column C. Do not copy a headline figure from an advertisement.

What does a worked example look like?

All figures here are made up. Say the annual fee is ₹1,500 and the logged yearly spend is as follows.

CategorySpend (₹)RateRewards (₹)
Groceries60,0002%1,200
Fuel24,0000%0
Online shopping48,0005%2,400
Dining30,0001%300
Other90,0001%900

Total spend is ₹2,52,000 and total rewards are ₹4,800. Net benefit in the final cell: =SUM(E2:E6)-AnnualFee, which gives ₹4,800 minus ₹1,500, or ₹3,300. The break-even spend at a flat 1 percent would be ₹1,50,000 a year, because ₹1,500 divided by 0.01 is ₹1,50,000.

Reward terms can change during the year, so write the date of the terms you used in a cell beside the table and refresh the rates at least once a year. Also add a column for spend you would have made on a different card anyway; the useful comparison is rewards on that spend, not on purchases you made only because a reward was on offer.

What costs should I subtract besides the fee?

  • Interest on any balance you carried. One month of interest can wipe out a year of rewards.
  • Late payment charges, over-limit charges and cash advance fees printed on the statement.
  • Foreign currency mark-up lines, if you spent abroad.
  • Purchases you made only to chase a reward, which you would otherwise have skipped.

Make each a separate cell labelled Other costs and subtract them in the net-benefit formula. Use the amounts shown on your statement and do not estimate them.

Is the card worth keeping, then?

The sheet answers only a money question. A card might also give you lounge access, insurance or a billing cycle that helps with cash flow, and you must decide what those are worth to you, if anything. Enter a rupee value for them on a separate line, and be strict: count only what you really used last year.

Where do I get twelve months of category spend?

From your card statements, one per month. Paste the rows into a tab and tag each with a category, or if the work is tedious, import the statements into SpendixAI, pick the card as the account, and use its category reports and CSV download as the source for column B. Either way, base the sheet on what you spent, not on what you expect to spend.

A year-end routine

  1. Update the twelve months of spend and the reward rates.
  2. Enter the fee and any other costs from the statement.
  3. Read the net-benefit cell.
  4. If it is below the value of your time, compare your options by running the same sheet on another card's published terms.

Keep last year's version of the sheet. Putting two years side by side shows whether your spending pattern has drifted away from the categories the card rewards, which is often the real reason a card stops being worth its fee.

SPENDIXAI JOURNAL

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

Explore your reports