Blog
Is a rotating-category card worth it? Run a full year of numbers
A four-quarter worksheet that sets planned bonus-category spending against the cap and a flat card, counting the rest of your spending so effort counts.
Whether a rotating-category card beats a flat-rate card is not a question about the card. It is a question about your calendar. The bonus is large, the cap is small, the bonus category list is chosen by the issuer and the benefit in any quarter depends on how much you happen to spend in those categories. The way to answer it for yourself is to lay four quarters side by side, enter what you really expect to spend, and add up the difference.
This post is a worksheet. It gives the inputs, the steps and the arithmetic, then runs it for three invented years: one where the categories match a household's life, one where they barely do and one where they match every quarter. Every rate, cap and amount below is an illustration and not a real card's term. The current terms for any real card are in its agreement and on its profile page.
The two cards
Card R is a card with rotating categories. It pays 5% cash back on up to $1,500 of spending in each quarter's categories, 1% on spending above that cap in the categories and 1% on everything else. There is no annual fee. The bonus requires activation each quarter.
Card F is a flat-rate card paying 2% on every purchase, with no annual fee.
What goes on the worksheet
Gather five inputs.
- Q1 to Q4 planned category spending (S). For each quarter, the amount you expect to spend in that quarter's categories. Count only things you would buy anyway, in about the quantities you would buy. Enter the figure as a plan, not a hope. The most honest source is last year's statements: for each past quarter, what did you spend at merchants that would have counted? If the categories for a coming quarter are not announced yet, use last year's spending with a haircut for uncertainty.
- The cap (C) per quarter. In the example, $1,500.
- The bonus rate (B) and the flat rate (F). Here 5% and 2%.
- Other annual spending (O). What you spend on everything outside the categories, in a year. Needed only if you plan to use Card R as your only card.
- Any annual fee. Zero here, but enter it if the card has one.
The steps
- For each quarter, find the qualifying spending. That is the smaller of S and C.
- Multiply qualifying spending by the gap, B minus F. This is the gain for the quarter if you use Card R only for the category spending and put everything else, including any spending above the cap, on Card F. With B = 5% and F = 2%, the gap is 3 percentage points.
- Add the four quarters. This is the annual gain of the two-card plan, before the annual fee and before any missed activations.
- Subtract the fee, if any.
- Apply a miss allowance. For each quarter you suspect you might forget to activate or track, remove that quarter's gain, or enter a smaller one.
- If Card R would be your only card, add the single-card penalty. Everything outside the bonus pays 1% on Card R instead of 2% on Card F. Subtract (F - 1%) x (O + spending above the cap).
- Compare the result to your own effort threshold.
Example 1: a year where the categories fit
Say the household expects to spend this much in the categories each quarter: $700, $1,500, $2,200 and $400. Other annual spending is $12,000.
| Quarter | Planned category spending (S) | Qualifying (up to $1,500) | Above the cap | Gain over Card F (3% of qualifying) |
|---|---|---|---|---|
| First | $700 | $700 | $0 | $21.00 |
| Second | $1,500 | $1,500 | $0 | $45.00 |
| Third | $2,200 | $1,500 | $700 | $45.00 |
| Fourth | $400 | $400 | $0 | $12.00 |
| Year | $4,800 | $4,100 | $700 | $123.00 |
Check the qualifying total: 700 + 1,500 + 1,500 + 400 = 4,100, and $4,100 x 3% = $123.00. The $700 above the cap in the third quarter goes on Card F at 2%.
The two-card plan gains $123.00 a year over using Card F for everything.
The missed-activation case. Suppose the household forgets to activate in the second quarter, the one that would have paid $45. The gain falls to $123.00 - $45.00 = $78.00. A single forgotten step removes more than a third of the year ($45 / $123 = 36.6%).
The single-card case. Now suppose the household uses Card R for everything.
- Gain on the category spending: $123.00.
- Penalty on the $700 above the cap, which earns 1% on Card R and would have earned 2% on Card F: $700 x 1% = -$7.00.
- Penalty on the $12,000 of other spending: $12,000 x 1% = -$120.00.
- Net: $123.00 - $7.00 - $120.00 = -$4.00.
The household would be $4 behind a flat card. The one-card plan gives away the whole gain because 1% on everything outside the categories is a big cost at $12,000 a year. The break-even is where the gain equals the penalty: ($123 - $7) / 1% = $11,600 of other spending. Above $11,600 a year, the one-card plan loses money in this example, and below it, it wins.
Example 2: a year where the categories barely fit
Same cards, a different household. It expects to spend $200, $300, $0 and $400 in the categories across the four quarters.
| Quarter | Planned category spending (S) | Qualifying | Gain over Card F |
|---|---|---|---|
| First | $200 | $200 | $6.00 |
| Second | $300 | $300 | $9.00 |
| Third | $0 | $0 | $0.00 |
| Fourth | $400 | $400 | $12.00 |
| Year | $900 | $900 | $27.00 |
The two-card plan gains $27 a year, about $6.75 a quarter and less than a dollar a week. If each quarter's activation, tracking and card-switching takes ten minutes, that is 40 minutes a year, and $27 for 40 minutes is about $40 an hour ($27 / (40/60) = $40.50). Whether that is worth it is a personal call. Missing one activation costs a third or more of the year's total.
Example 3: a year where the categories fit every quarter
A household that spends at least the cap in every quarter hits the maximum.
- Qualifying each quarter: $1,500.
- Gain per quarter: $1,500 x 3% = $45.00.
- Year: 4 x $45.00 = $180.00.
That is the ceiling for Card R in this example, since the cap limits the 5% to $6,000 a year ($1,500 x 4). No household can earn more than $180 a year over Card F from the category bonus alone, however much it spends. The ceiling is worth knowing before you buy anything to chase it. spending more to earn more: how chasing cash back costs you money explains why spending extra to reach a cap rarely pays.
Example 4: filling in S from last year's receipts
The hard input is S, because the categories for next year are not known. One workable method is to build a table of last year's spending by merchant type and then test it against more than one possible lineup of categories.
Say a household's statements show this spending by merchant type, by quarter:
| Merchant type | First | Second | Third | Fourth |
|---|---|---|---|---|
| Gas stations | $300 | $420 | $480 | $330 |
| Home improvement stores | $150 | $900 | $350 | $120 |
| Online retail | $400 | $350 | $700 | $1,300 |
| Restaurants | $600 | $600 | $650 | $700 |
Now try a lineup, invented for the example, where each quarter's two categories are: first, gas and restaurants; second, home improvement and gas; third, restaurants and online retail; fourth, online retail and gas.
- First: $300 + $600 = $900.
- Second: $900 + $420 = $1,320.
- Third: $650 + $700 = $1,350.
- Fourth: $1,300 + $330 = $1,630, which exceeds the $1,500 cap, so $1,500 qualifies.
- Qualifying total: $900 + $1,320 + $1,350 + $1,500 = $5,070.
- Gain: $5,070 x 3% = $152.10.
Now try a worse lineup for the same household: first, home improvement only; second, online retail only; third, gas only; fourth, home improvement only. The matching spending is $150 + $350 + $480 + $120 = $1,100, and the gain is $1,100 x 3% = $33.00.
The same household, spending the same amounts, earns anywhere from $33 to $152 depending on which categories the issuer picks. The middle of the two, $92.55 ($33.00 + $152.10, divided by 2), is not a prediction. It is a reminder that this worksheet's output has a wide range, and the honest way to present it to yourself is as a range. Some people plan on the low case and treat anything above it as a bonus. Others use last year's actual lineup as a reference point, knowing the next one will differ. Issuers publish lineups on their own schedules, and the card's profile links to where. planning a year of rotating categories quarter by quarter takes the next step: deciding which purchases can wait for a matching quarter.
Reading the results together
Put the four examples next to each other, and measure each against the same ten minutes a quarter, or 40 minutes a year.
| Example | Annual gain over the flat card | Per hour of effort (40 minutes a year) |
|---|---|---|
| 1: categories fit | $123.00 | about $185 |
| 2: categories barely fit | $27.00 | about $40 |
| 3: categories fit every quarter | $180.00 | $270 |
| 4, good lineup | $152.10 | about $228 |
| 4, poor lineup | $33.00 | about $50 |
The hourly figures are the annual gain divided by two-thirds of an hour, rounded: $123.00 / 0.667 is $184.5, $27.00 / 0.667 is $40.5, $180.00 / 0.667 is $270, $152.10 / 0.667 is $228.2 and $33.00 / 0.667 is $49.5.
Three readings are worth drawing.
- The spread within one household is as large as the spread between households. Example 4 gave one household anything from $33 to $152. A decision based on one lineup is a decision based on luck. If the plan only works in a good year, it is a gamble that pays a modest amount when it wins and costs ten minutes a quarter when it loses.
- The gain is capped and the penalty is not. The ceiling is $180 in these examples, but a single-card plan can lose that much or more through the 1% on everything else. A household with $20,000 of other annual spending, run entirely on Card R, would give up $200 a year ($20,000 x 1%) against Card F before the category gain is counted. The ceiling on the upside does not bound the downside of using the wrong plan.
- Small results are fragile. A year that earns $27 loses a third of it ($9) if the second quarter's activation is forgotten, and loses all of it if the card ends up used for the wrong purchases. A year that earns $150 can absorb a mistake. Put a floor under your own threshold: some people want $100 a year to justify any added routine, and some are content with less. Neither is wrong, and the worksheet does not tell you where to set it.
What changes the answer
Four inputs move the result, and each has a clear direction.
The flat card's rate. If Card F paid 1.5%, the gap would be 3.5 points and the example-1 gain would be $4,100 x 3.5% = $143.50. If Card F paid 2.5%, the gap would be 2.5 points and the gain $4,100 x 2.5% = $102.50. A better flat card shrinks the case for rotation.
The cap. With a $1,000 cap in example 1, qualifying spending is $700 + $1,000 + $1,000 + $400 = $3,100, and the gain is $3,100 x 3% = $93.00. With a $2,000 cap it is $700 + $1,500 + $2,000 + $400 = $4,600, and the gain is $138.00.
The categories. If a quarter's categories are ones you rarely use, that quarter's gain is near zero. A card with fixed categories or with a category you choose yourself may be a better match for a household like the one in example 2. at what monthly spending does a bonus-category card beat a flat-rate card? finds the break-even spending directly.
Your reliability. The gain is only the gain if you activate and track. If you think you will miss one quarter in four, multiply the gain by 0.75.
What the worksheet leaves out
- Value of time. The worksheet counts minutes at the end. Everyone's number is different, and some people find a quarterly routine easy and others find it a constant low-grade chore. The figure that matters is the second one.
- A second card's risk. Two cards mean two payments, two balances to pay in full and a second chance for a mistake. A missed payment on either card costs a late fee and potentially interest, at the Federal Reserve's reported average of 22.36 percent for accounts assessed interest in the third quarter of 2026, which exceeds any bonus quickly on a carried balance.
- Spending you would not otherwise do. The worksheet asks for planned spending. If the bonus changes what you buy, the benefit is partly an illusion. A rule of thumb: if a purchase is not something you would make at the price you would pay without the bonus, take it out of S.
- Welcome offers and other card features. Those are outside this comparison, and they are one-time or card-specific. A welcome bonus argues for opening a card. It does not change what the card pays in a normal year, which is the subject of this worksheet.
Your own worksheet
Copy this table, fill in the right-hand columns and add them up.
| Line | Example 1 | Your numbers |
|---|---|---|
| Bonus rate B | 5% | |
| Flat rate F | 2% | |
| Cap per quarter C | $1,500 | |
| Q1 planned category spending | $700 | |
| Q2 planned category spending | $1,500 | |
| Q3 planned category spending | $2,200 | |
| Q4 planned category spending | $400 | |
| Qualifying total (sum of the smaller of S and C) | $4,100 | |
| Gain (qualifying x (B - F)) | $123.00 | |
| Annual fee | $0 | |
| Miss allowance | $0 | |
| Two-card result | $123.00 | |
| Single-card penalty ((F - 1%) x (O + above cap)) | $127.00 | |
| Single-card result | -$4.00 |
The cash back comparison calculator and the card combination rewards optimizer can run the arithmetic with your own inputs. how rotating bonus categories work, from activation to quarterly caps explains the quarter's steps if you are new to the activation and cap mechanics, and planning a year of rotating categories quarter by quarter shows how to map your spending onto the quarters.
Key takeaways
- The answer depends on your planned spending in each quarter's categories, capped at the cap, times the gap between the bonus rate and the flat rate. In the example, $4,100 of qualifying spending times 3 points is $123 a year.
- The ceiling is the cap times the gap times four quarters: $180 a year in the example, whatever you spend.
- As a one-card plan, the same year lost $4 against the flat card because 1% on $12,000 of other spending cancels the gain. Rotation works as a second card for category spending, not as a replacement for the flat card.
- One forgotten activation removed $45 of $123 in the example, so the plan only pays if you will follow it every quarter.
- Compare the result to your effort and to the interest risk of a second card. A year where the categories barely fit paid $27, about $40 an hour at ten minutes a quarter.