Credit Card Cash Back Calculator & Rewards Comparison

Enter eligible spending by month and see how two cards reward the same purchases. The ledger shows spending at the higher rate and spending that falls above a cap. Compare first-year and recurring net cash back and see the annual fee at which the two cards tie.

Credit card rewards

Compare cash back after fees

Spending in both scenarios

Begin month 1 at the start of a bonus quarter. Enter eligible purchase amounts. Use the same annual pattern for the recurring comparison.

Edit individual months
Eligible purchase amounts in USD
MonthGroceriesDiningFuel and transportOther purchases
1
2
3
4
5
6
7
8
9
10
11
12

Card A terms

Card A quarterly categories and activation
Quarter 1
Quarter 2
Quarter 3
Quarter 4

Card B terms

Card B quarterly categories and activation
Quarter 1
Quarter 2
Quarter 3
Quarter 4

Net cash back after fees

First-year comparison
Card B ahead by $139.00
Recurring comparison
Card A ahead by $11.00
Annual spending
$15,600.00

Card B ties Card A’s recurring value at a fee of $84.00.

Both cards use the same purchase amounts
CardOn purchasesAnnual feeWelcome bonus earnedFirst yearRecurring
Card A$312.00$0.00$0.00$312.00$312.00
Card B$396.00$95.00$150.00$451.00$301.00

Card B reaches its welcome threshold in month 1.

Cumulative cash back
First-year cash back by monthCard A ends at $312.00. Card B ends at $451.00. Detailed values are available in the ledger.$0$451136912MonthNet cash back (USD)

Card ACard B

Monthly reward and cap ledger

$6,000.00 earns the bonus rate. $1,200.00 of otherwise eligible purchases fall above the cap.

Month-by-month rewards for card B
MonthBonus spendAbove capCap remainingPurchase rewardsWelcomeCumulative
1$600.00$0.00$900.00$37.00$150.00$92.00
2$600.00$0.00$300.00$37.00$0.00$129.00
3$300.00$300.00$0.00$25.00$0.00$154.00
4$600.00$0.00$900.00$37.00$0.00$191.00
5$600.00$0.00$300.00$37.00$0.00$228.00
6$300.00$300.00$0.00$25.00$0.00$253.00
7$600.00$0.00$900.00$37.00$0.00$290.00
8$600.00$0.00$300.00$37.00$0.00$327.00
9$300.00$300.00$0.00$25.00$0.00$352.00
10$600.00$0.00$900.00$37.00$0.00$389.00
11$600.00$0.00$300.00$37.00$0.00$426.00
12$300.00$300.00$0.00$25.00$0.00$451.00

Show selectable CSV

How to use this calculator

  1. Start with a quarter boundary. Apply a typical spending row to all 12 months or edit monthly category amounts.
  2. Enter the base rate, total bonus category rate, annual fee and bonus spending cap for both cards.
  3. Open each card’s quarterly settings to choose which categories qualify and which quarters you expect to activate.
  4. Enter a welcome amount and qualifying spending window when the terms include one.
  5. Compare the first-year and recurring totals, follow the chart, and export the cap and reward ledger to CSV.

The Formula

The mathematical logic powering this calculation is:

For a month, add all entered eligible purchases and total the purchases in that quarter’s selected categories. The higher rate applies only if that quarter is activated. Bonus spend is the smaller of active category spend and the remaining cap, or all active category spend if uncapped. Earned cash back = all entered spending × base rate + bonus spend × (total bonus rate − base rate). The calculation rounds the combined reward to cents once per month. Above-cap purchases still earn the base rate.
The per-quarter cap resets at months 1, 4, 7 and 10. An annual cap has one limit across the 12 months. Start the worksheet at the beginning of a quarter. All entered purchases are assumed to count for base rewards and any welcome threshold. The model awards a single welcome amount in the first modeled month that cumulative eligible spending reaches the threshold, provided the month lies within the entered window. The annual fee is applied once in month 1.
First-year net = purchase rewards + welcome amount earned − annual fee. Recurring net = purchase rewards − annual fee, applying the entered purchase pattern and terms again. For a recurring tie, Card B’s annual fee equals Card B purchase rewards minus Card A recurring net. Quotes with a negative tie fee leave Card A ahead at a zero fee for Card B.
Each monthly spending category accepts $0 to $100,000. Cap, fee and welcome amounts accept $0 to $1 million. Rates accept 0% to 20%. Amounts and rates accept two decimal places, and the welcome window accepts 1 to 12 months. Values are cash-back amounts in USD. Merchant coding, rewards posting, statement credits apart from the entered bonus, points redemption, payment interest, refunds and product eligibility are outside the comparison.

Worked Example

If you input:

  • Eligible monthly spending: $600 groceries, $300 dining, $150 fuel and transport, $250 other
  • Card A terms: 2% on all purchases, $0 annual fee
  • Card B terms: 1% base, 5% total on groceries with a $1,500 cap each active quarter, $95 annual fee
  • Card B welcome bonus: $150 after $1,000 of spending in the first 3 months

Result:

On $15,600 of annual purchases, Card A earns $312. Card B earns $396 on purchases and qualifies for the example welcome bonus in month 1. After the $95 fee, Card B nets $451 in year one and $301 on the same spending without the welcome bonus. Card B’s fee would need to be $84 to tie Card A’s recurring value.

Frequently Asked Questions

Do I enter the total bonus rate or just the added reward?

Enter the total rate on qualifying purchases. With a 1% base and a 5% total rate, the worksheet applies 4% extra to the bonus-eligible portion below the cap.

What happens when I reach a category cap?

The eligible portion above the cap earns the base rate. An entered quarterly cap resets every three months. An entered annual cap applies once to the 12-month plan.

How do I model a missed activation or rotating categories?

Select the eligible categories separately for each quarter. Turn off activation for a quarter with no bonus access. Spending then earns the base rate for that quarter.

Can a welcome bonus change which card earns more?

Yes. Compare first-year results, which include a qualified welcome offer, and recurring results, which use the same spending with purchase rewards and the annual fee.

Why might my statement show a different amount?

Issuers may round or award rewards per purchase, classify merchants differently, post charges across cap periods, or exclude specific purchases. This comparison uses monthly totals and the eligibility assumptions you enter.

Is the example a card I can apply for?

The example terms are hypothetical. Use current issuer documents for rates, category rules, activation and fees.

Similar Calculators