Blog

Compare two cards using your own spending, with a worksheet

A fill-in worksheet that turns twelve spending lines into yearly rewards for two cards, handling caps, fees and point values, with a worked example.

Nobody else can tell you which of two cards earns more for your household, because the answer depends on twelve or so numbers that only you have. This post gives you a worksheet you can fill in with a pencil or a spreadsheet. It takes about an hour the first time, mostly spent pulling a few months of statements, and about ten minutes after that.

The worksheet runs in six parts, and each part is followed by a worked example. The example household, the two cards and every number in it are invented. The rates and fees are illustrations, not terms of any real product, so replace them with the terms from the issuer's pages when you do your own.

Part A: build your spending list

Pull the last three months of statements from every card, bank account and payment app you use. Total each of the following lines for the three months and divide by three to get a monthly figure. Cash and debit spending counts too, if you would be willing to move it to a card.

Line Monthly spending
1. Groceries ___
2. Dining and takeout ___
3. Gas and charging ___
4. Streaming and subscriptions ___
5. Utilities and phone ___
6. Transit and rideshare ___
7. Online shopping ___
8. Medical and pharmacy ___
9. Travel (flights, hotels, rentals), averaged over 12 months ___
10. Insurance and other bills you can pay by card ___
11. Everything else ___
12. Spending abroad, averaged over 12 months ___
Total per month ___
Total per year (monthly total x 12) ___

Before you total anything, watch for five things that distort a spending list.

  • Annual and irregular bills. Insurance, car registration and holiday gifts land in single months. Add up twelve months of them and divide, so a quiet quarter does not understate your spending.
  • Reimbursed spending. If an employer pays you back for travel or supplies, the card still earned rewards on it, but the money was not yours. Keep it on its own line so you can decide how to treat it.
  • Transfers and payments. Paying a credit card bill, moving money to savings and paying a friend through an app are not spending. Leave them out, or the total will be inflated.
  • Shared accounts. If a partner or family member uses a card you plan to replace, include their spending, or decide which of you gets which card.
  • One-off purchases. A new appliance or a laptop is real spending in the month it occurs but will not repeat. Note it separately, because it can raise the yearly figure by hundreds of dollars and tilt the answer toward a card that suits that one purchase.

Two cautions. First, do not include things a card will not let you pay by card, such as most rent and many taxes, or things that carry a fee for card payment. Second, do not add spending you hope to do. The worksheet is for what you actually spend, and the temptation to inflate it is the main way people end up with a card that looks better than it is.

Worked example. Say the household spends these amounts a month.

Line Monthly
Groceries $550
Dining $250
Gas $160
Streaming and subscriptions $60
Utilities and phone $280
Transit and rideshare $90
Online shopping $200
Medical and pharmacy $70
Travel (averaged) $150
Insurance and other bills $190
Everything else $400
Abroad $0
Total $2,400

The yearly total is $2,400 × 12 = $28,800.

Part B: write down each card's rules

For each card, record the rule for each line: the rate, the cap and the fee. Use the issuer's page, not a review. A blank row for each card looks like this.

Line Card 1 rate and cap Card 2 rate and cap
Groceries ___ ___
Dining ___ ___
Gas ___ ___
Everything else ___ ___
Annual fee ___ ___
Foreign transaction fee ___ ___
Reward unit (cash or points) ___ ___

Two points about how rules are written. Issuers sometimes also limit rewards in other ways, such as excluding returns, gift cards or payments to certain kinds of merchants, so read the exclusions in the terms. An annual fee is charged whether or not you earn anything. A bonus category is a type of purchase that earns more than the base rate, and the issuer decides what counts, usually by the merchant's category code, which can differ from what you would guess. A flat-rate card pays the same rate on everything and has no categories to track. When a bonus category has a cap, note both the cap's amount and its period, whether a month, a quarter or a year, and what the rate drops to after the cap.

If your rewards come as cash back, they are already in dollars. If they come as something else, Part E covers the conversion.

Worked example. The two invented cards:

  • Card A (category card): 3% on groceries on up to $6,000 a year, then 1%; 2% on dining; 2% on gas; 1% on everything else; no annual fee.
  • Card B (flat-rate card): 2% on everything; no annual fee.

Part C: compute each card's yearly rewards, line by line

For each line, multiply the yearly spending by the rate. Where there is a cap, split the spending at the cap and apply two rates. Write the answer in a column for each card.

Worked example, Card A.

  • Groceries: $550 × 12 = $6,600 a year. The first $6,000 earns 3%: $180. The remaining $600 earns 1%: $6. Groceries total $186.
  • Dining: $250 × 12 = $3,000, at 2%: $60.
  • Gas: $160 × 12 = $1,920, at 2%: $38.40.
  • Everything else: the yearly total of $28,800 minus groceries $6,600, dining $3,000 and gas $1,920 leaves $17,280, at 1%: $172.80.
  • Card A total: $186 + $60 + $38.40 + $172.80 = $457.20.

Worked example, Card B. $28,800 × 2% = $576.00.

Card B leads by $118.80 in this household, even though Card A pays more on three of the lines. The reason is the 1% base rate: the household spends $17,280 in the "everything else" bucket, where Card A pays one point less per dollar than Card B. Several bonus categories can look like a good fit for a category card until you add up how much of the total falls outside them. The usual check is to compute the share of spending in the bonus categories. Here it is ($6,600 + $3,000 + $1,920) divided by $28,800, or 40 percent. A category card tends to beat a flat card when that share is large and the bonus rate is well above the flat rate.

Part D: subtract costs

Now subtract fees that your behavior triggers.

  1. The annual fee, from Part B.
  2. The foreign transaction fee, applied to your spending abroad. If the card charges a percentage on foreign purchases, multiply it by line 12.
  3. The cost of a missed or late payment, if you think it could happen. This is not a number to include every year, but if you have missed a payment in the past two years, consider how the penalty terms on each card would have treated you.

Net rewards for each card is the Part C total minus the Part D costs.

Worked example. Both cards have no annual fee and the household spends nothing abroad, so there is nothing to subtract. Net rewards stay at $457.20 for Card A and $576.00 for Card B.

Part E: convert points to dollars honestly

If a card pays points, convert them. Rewards that arrive as cash or statement credit are already in dollars. Points or miles need a value per point. The cents per point figure is the number of cents each point returns when you redeem it. Cash back redemptions are typically worth about one cent per point, and higher values require redeeming for travel or through transfers, where the value depends on the route and on what you would have paid otherwise. Published valuations differ by publisher and method, so treat them as estimates.

Run the worksheet twice for a points card: once at one cent and once at a value you have actually achieved or have good reason to expect. If the card wins at one cent, it wins either way. If it wins only at a higher value, the decision depends on a redemption habit you need to have.

Worked example variant. Say a third card, Card C, pays 2 points per dollar on everything and has no fee. On $28,800, that is 57,600 points. At one cent each the value is $576, equal to Card B. At 1.25 cents it is $720, which is 57,600 × $0.0125. The extra $144 appears only if you can redeem at 1.25 cents consistently. If you plan to take cash, Card C is no better than Card B and may be more complicated.

Part F: add one-time items, then stress test

Add any one-time welcome offer as a separate line and note its minimum spending requirement against your monthly spending. For this example the household's spending is $2,400 a month, or $7,200 in three months, so a minimum of a few thousand dollars would not require any change in habits.

Then test the result against three changes in your life.

  1. Spending drops by 20 percent. Does the ranking change? For a card with an annual fee, a lower spending level makes the fee weigh more.
  2. A category grows. Suppose groceries rise from $550 to $900 a month. Card A's grocery line is already capped at $6,000, so the extra spending earns only 1% on Card A and 2% on Card B. A cap makes a category card weaker as the category grows, which is the opposite of what people expect.
  3. You carry a balance one month. Rewards stop mattering if the interest costs more than they earn. If a balance is likely, compare the APRs, and see how much a month's interest costs by hand with work out one month of card interest by hand with average daily balance.

Worked example, test 2. With groceries at $900 a month, the yearly grocery spending is $10,800. On Card A the first $6,000 earns 3%, or $180, and the remaining $4,800 earns 1%, or $48, for $228. On Card B, $10,800 at 2% is $216. So at this level of grocery spending Card A's grocery line beats Card B's grocery line by only $12, and the household's yearly total has risen to $33,000. Card A earns $228 + $60 + $38.40 + $172.80 = $499.20 in all, while Card B earns $33,000 × 2% = $660.00. The growing category did not close the gap.

Reading the result

Put the final numbers side by side.

Card A Card B Card C at 1 cent
Yearly rewards $457.20 $576.00 $576.00
Annual fee $0 $0 $0
Net $457.20 $576.00 $576.00

Three rules of thumb follow from this method, not as rules for every household but as patterns that tend to repeat.

  • The gap between your best bonus rate and the base rate matters less than the share of your spending in the bonus categories. A 3% rate on a small share of spending is worth less than a 2% rate on everything.
  • Caps push the winner toward flat cards as the category grows. See at what monthly spending does a bonus-category card beat a flat-rate card? for a closer look at where the tipping point sits.
  • Annual fees need to be earned back from the difference, not from the total. If a card with a fee beats a no-fee card by less than the fee, it loses.

When two cards come out within a few dollars, the numbers are telling you the choice is not worth agonizing over. Decide on simplicity, on whether you will track categories and on how the issuer treats you. The cash back comparison calculator on this site does the arithmetic in Parts C and D if you give it your buckets, and how to compare two credit cards step by step before applying covers the questions the worksheet does not, such as fees triggered by behavior and approval odds. A category match is only as good as the merchant code behind the purchase, so also read Why did my grocery run miss the grocery bonus? How merchant codes decide before relying on a grocery line.

Keeping the worksheet useful

Redo it once a year, or when something changes: a new job, a new child, a move, a card's terms or your spending pattern. Keep the filled-in worksheet next to your card notes, with the date. A year later you will be able to see whether your estimate of the rewards matched what actually posted, which is the best check on the method. Compare your estimate with the total rewards on your year-end summary or statements. If the real figure is lower by more than ten percent, find out why: a category that did not code the way you expected, a cap you hit, or spending you forgot to move.

Key takeaways

  • The answer to "which card earns more" is a function of twelve or so numbers that only you have. Pull three months of statements, average them and annualize.
  • Apply caps by splitting spending at the cap. In the example, Card A earned $186 on $6,600 of groceries because only the first $6,000 earned 3%.
  • Check the share of your spending that sits in bonus categories. Here it was 40 percent, and the flat 2% card earned $118.80 more than the category card.
  • Convert points at one cent first. If a card wins only at a higher value, the win depends on a redemption habit.
  • Stress test the result: lower spending, a growing category and a month with a balance can each change the ranking.

Terms used in this article

Related tools

Latest on this topic