Every expensive churning mistake is a forgotten date wearing a costume: the missed spend deadline, the 5/24 count remembered wrong, the fee with no reminder. The spreadsheet takes 20 minutes to build and 2 minutes a month to maintain. Copy the rule dates in from the issuer rules tracker.
Every expensive churning mistake is a forgotten date wearing a costume. The missed minimum spend was a deadline nobody wrote down. The wasted application was a 5/24 count remembered wrong. The $695 surprise was an annual fee with no reminder attached.
A tracking spreadsheet is the unglamorous half of credit card churning, and the half that decides the profit. It takes 20 minutes to build, 2 minutes a month to maintain, and it converts every issuer rule from a memory problem into a formula.
The 4 dates that run everything
-
Approval dateRuns your 5/24 count and issuer velocity clocks.
-
Minimum spend deadlineApproval date plus the offer window, minus a safety week.
-
Bonus posting dateStarts the Citi AAdvantage and Capital One 48 month clocks and Amex history.
-
Annual fee dateTriggers the retention call, the downgrade, and the refund window.
Issuer rules are all clocks, and clocks need start times. The approval date runs your 5/24 count and every velocity rule. The spend deadline is approval plus the offer window. The bonus posting date starts the Citi-style 48 month clocks. The fee date schedules the retention call and the refund window behind it.
Capture those 4 on the day they happen and your future self inherits a complete, queryable history of your churning career. Skip them and you reconstruct it later from credit reports, statements, and guesswork. Reconstruction is how mistakes happen.
The columns, one by one
Advertisement
| Column | Why it earns its place |
|---|---|
| Card and issuer | The key for everything; include the exact product name, since families matter |
| Player | You or your partner, for 2-player households |
| Personal or business | Decides what counts toward 5/24 |
| Approval date | 5/24 math, velocity rules, the 12 month downgrade rule |
| Bonus offer and minimum spend | What you signed up for, in writing, with the offer screenshot linked |
| Spend deadline and progress | The date that forfeits real money when missed; track progress weekly during a window |
| Bonus posted date | Starts 48 month clocks and the Amex lifetime record |
| Annual fee and fee date | Schedules retention, downgrade, and refund decisions |
| Credit line | Utilization planning, and reallocation calls before new applications |
| Status and exit date | Open, downgraded to what, or closed when |
| Retention history | What was offered and taken each year; agents see their version, you should see yours |
Resist adding 30 more columns on day 1. A sheet that takes effort to update stops getting updated, and a stale tracker is worse than none because you trust it.
3 formulas worth stealing
Live 5/24 count. COUNTIFS over type equals personal and approval date within 24 months. Put it in a header cell in large type. Next to it, a sorted list of the dates each current slot expires, which is your Chase application calendar.
Next deadline. MIN over open spend deadlines, with conditional formatting that turns the cell amber inside 30 days and red inside 14. This single cell replaces most of the anxiety in churning.
Fee radar. The next 90 days of annual fees, filtered from the fee date column. Each entry is a retention call to schedule, with the script in the retention guide.
Google Sheets handles all of it; so does Excel. The flowchart community shares free templates with these formulas prebuilt, and any of them beats starting from blank.
Spreadsheet against apps
Travel Freely, AwardWallet, and similar apps track cards and fire reminders automatically, and for people who will never maintain a sheet they are the right call. The trade-offs that keep the spreadsheet in the picture:
- Apps key on application dates and balances. The bonus posting date, the one that runs 48 month clocks, usually needs manual care anyway.
- Retention offer history, reconsideration notes, and offer screenshots have no app home.
- 2-player setups and business cards get awkward inside accounts built around one person’s wallet.
The pragmatic answer is both: an app for reminders, the sheet as the system of record. The sheet also never sells, shuts down, or changes its data model.
The maintenance habit
4 trigger events, 30 seconds each: approval, bonus posting, fee posting, exit. Tie the update to the event, not to a schedule, and the sheet stays current without willpower.
Add a monthly 5 minute review: check the deadline cell, check the fee radar, check the 5/24 expiry list, and glance at spend progress on any open window. That review, plus the flowchart logic for choosing the next card, is the entire operating system of a churning career. The score effects of all this activity have their own guide in does churning hurt your credit score.
The 20 minute build, walked through
Open a blank Google Sheet and build left to right; the order below matches how you will actually use it.
Columns A through D are identity: player, card name exactly as the issuer writes it, issuer, personal or business. Columns E through H are the application: approval date, credit line, bonus offer in points, minimum spend in dollars. Columns I and J are the live window: spend deadline, computed as approval date plus the offer window minus 7 days of buffer, and a progress cell you update weekly while a window runs. Columns K through N are the long clocks: bonus posted date, annual fee amount, fee month, and status.
Then the 3 header formulas. The 5/24 cell: COUNTIFS over type equals personal and approval date greater than EDATE(TODAY(),-24). The next-deadline cell: MINIFS over deadlines where status is open and progress is short of requirement. The fee radar: a FILTER of cards whose fee month falls within 90 days of today. Conditional formatting turns deadlines amber at 30 days and red at 14, and the sheet is done.
Populate it from your credit report rather than memory, the same report walk from the 5/24 guide, so closed cards and authorized user accounts make it in. First-time builders consistently find a surprise: a forgotten store card inside the 24 month window, or a fee renewal closer than they thought. The surprise is the proof the sheet was needed.
Where apps quietly fail you
The app comparison above is friendly, so here is the unfriendly specific list, because each failure has cost real users real money.
Apps key reminders to statement dates and application dates, but the 48 month clocks at Citi and Capital One run from bonus posting, a date apps do not capture; users who trusted the app reapplied a month early and burned the application. Authorized user accounts sync into some apps as if they were your own, silently inflating the card count a 5/24 decision depends on. Business cards sit outside several apps’ models entirely, so the very accounts doing your stealth earning go untracked. And when an aggregator loses a bank connection, it stops updating without saying so loudly, which is how a missed annual fee survives 3 reminder systems.
None of this argues against apps; the reminders alone justify them. It argues for the system of record being yours: the sheet holds the truth, the app pings your phone, and a 5 minute monthly review reconciles the 2.
The monthly review, scripted
First Sunday of the month, 5 minutes, 4 checks. One: the next-deadline cell, and if a spend window is live, the progress number against the issuer’s own tracker, not your receipts. Two: the fee radar, and any fee inside 60 days gets a retention call scheduled. Three: the 5/24 list, noting the next slot to free and what the flowchart logic says to do with it. Four: a scan of the status column for anything mid-transition, a downgrade requested but unverified, a bonus met but unposted.
That cadence catches problems at the cheap stage: an unposted bonus at week 3 is a phone call, the same discovery at month 6 is a lost dispute. The review is also where the hobby’s planning happens naturally; with the dates in front of you, the next application chooses itself.
Quick reference
The minimum viable tracker: 1 row per card, 14 columns, 3 formulas, built in 20 minutes. The 4 trigger events that update it: approval, bonus posting, fee posting, exit. The monthly review: deadline cell, fee radar, 5/24 expiry list, status column, 5 minutes on the first Sunday. The annual payoff: zero missed deadlines, zero surprise fees, and every issuer clock answerable in seconds.
If you build nothing else from this site, build this. Every other guide here, the issuer rules, the retention calls, the referral loop, the 48 month clocks, assumes a system of record exists, and every expensive story in the hobby’s forums starts with someone who kept it in their head. The sheet is boring on purpose; boring is what reliability looks like at month 30, when 3 windows overlap and the answer to what do I do next is sitting in cell B2.
This move has its place in the first churning year sequence.
Related guides
- 5 moves for your first churning year, in order
- Positioning flights: when the extra hop is worth it
- Credit card referral bonuses: the 2-player loop and the 1099 that follows it
FAQ
What should a credit card churning spreadsheet track?
One row per card with: card name, issuer, personal or business, approval date, credit line, bonus and its minimum spend, the spend deadline, the date the bonus posted, annual fee amount and date, and a status column for open, downgraded, or closed. Everything else is optional.
How do I calculate my 5/24 status from the spreadsheet?
Count rows where the account is personal and the approval date falls within the past 24 months. In sheet terms, a COUNTIFS across the type and date columns. Sort by approval date and the same column tells you the exact month each slot frees up.
Is a spreadsheet better than an app like Travel Freely or AwardWallet?
Apps automate reminders and balance tracking, and they are genuinely good at it. The spreadsheet wins on the issuer-rule details apps generalize: bonus posting dates for 48 month clocks, retention offer history, player 2 accounts. Many churners run both.
When should I update the spreadsheet?
At 4 moments: the day you are approved, the day the bonus posts, the day an annual fee posts, and the day you downgrade or close. Each event takes 30 seconds to log and each one is a date a future decision depends on.
Should couples share one churning spreadsheet?
Yes, one file with a player column. 2-player churning doubles the accounts and the dates, and referral bonuses between players add cross-references no memory holds. A shared sheet is the only sane way to run it.
Last reviewed October 2026. We verify every rule, ratio, and figure against issuer terms and current reporting, and date each one. See our editorial standards for how we research and correct guides.
We re-check these guides as issuer rules and award charts change. 2 ways to follow along, no account needed.