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.
Compare cash back after fees
Enter the same spending for two cards and see how category caps, activation and a welcome bonus change your annual rewards.
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
| Month | Groceries | Dining | Fuel and transport | Other purchases |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 |
Card A terms
Card A quarterly categories and activation
Card B terms
Card B quarterly categories and activation
Net cash back after fees
Card B ties Card A’s recurring value at a fee of $84.00.
| Card | On purchases | Annual fee | Welcome bonus earned | First year | Recurring |
|---|---|---|---|---|---|
| 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.
┄Card A━Card 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 | Bonus spend | Above cap | Cap remaining | Purchase rewards | Welcome | Cumulative |
|---|---|---|---|---|---|---|
| 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
- Start with a quarter boundary. Apply a typical spending row to all 12 months or edit monthly category amounts.
- Enter the base rate, total bonus category rate, annual fee and bonus spending cap for both cards.
- Open each card’s quarterly settings to choose which categories qualify and which quarters you expect to activate.
- Enter a welcome amount and qualifying spending window when the terms include one.
- 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
Credit Card Balance Transfer Calculator & Offer Comparison
Compare a credit card balance transfer with keeping your debt. Check the funded fee, credit limit, promotion end, monthly payoff targets and savings.
Credit Card Payoff Calculator
Compare minimum-only and planned credit card payoff timelines with APR, extra payments, new charges, and promotional APR windows.
Savings Rate from Income Calculator
Savings Rate from Income for the exact fields in this tool, with clear inputs and an immediate result for planning or comparison.
Percent Off & Stacked Discount Calculator
Calculate percent off, compare stacked coupons in either order, and see which offer costs less after shipping and sales tax.
