How to Track Credit Card Applications
The difference between a churner who earns $10,000 a year in bonuses and one who loses bonuses to missed deadlines comes down to one thing: a tracker. Here is the exact system experienced churners use — the fields that matter, the deadlines that cost you money, and a template you can copy in five minutes.
Why a Tracker Matters
Every active churner has a story about the bonus that got away. A $750 sign-up bonus with a 90-day spend deadline, forgotten for three weeks too long. A Chase Sapphire Reserve downgrade window that closed before they remembered to call. A second application to a card they were already barred from by the Amex lifetime rule.
Every one of those mistakes is preventable with 20 minutes of setup. A tracker is not optional once you hold more than three or four rewards cards — it is the difference between systematic churning and expensive guesswork.
What a Good Tracker Prevents
- •Missed minimum spend. Bonuses forfeited because you did not hit the required spending by the deadline.
- •Forgotten annual fees. A card auto-charges $550 and you discover it two weeks later when you scan your statement.
- •Ineligible applications. Applying for a bonus you cannot earn because of the Amex lifetime rule, Citi 48-month rule, or Chase 48-month Sapphire rule.
- •5/24 mistakes. Applying for a Chase card while you are over 5/24 and eating an auto-denial plus a hard pull.
- •Non-posting bonuses. The bonus never credited and you did not notice until 90 days later when it was harder to dispute.
The 14 Fields to Track
A tracker with too few fields misses deadlines. A tracker with too many fields is never updated. These 14 columns cover every decision you will make — applying, spending, downgrading, and canceling — without extra clutter.
| Field | Why It Matters |
|---|---|
| Card name | Keeps issuer-specific rules visible at a glance. |
| Issuer | Needed for velocity rule counting (Chase 5/24, Citi 1/8, etc.). |
| Application date | Anchors all downstream deadlines and hard-pull timelines. |
| Approval date | Some minimum spends run from approval, not application. |
| Credit limit | Needed for utilization calculations and reallocation requests. |
| Bonus amount | Lets you reconcile the posted bonus against what was advertised. |
| Min spend required | The dollar target to hit before the deadline. |
| Min spend deadline | Typically 3 months from approval; missing by $1 forfeits the entire bonus. |
| Spend to date | Updated weekly so you know how much runway is left. |
| Bonus posted date | Proves the bonus actually credited — not always automatic. |
| Annual fee amount | Drives the keep/downgrade/cancel decision at month 11. |
| Next annual fee date | Flag 30-60 days ahead to decide on retention or downgrade. |
| Status | Active, downgraded, product-changed, closed, or pending. |
| Notes | Referral code used, retention offers, hard pull bureau, popup warnings. |
Spreadsheet Template Layout
Build the tracker as two sheets inside one Google Sheets workbook: a Cards sheet with one row per card and a Summary sheet with computed totals. A third sheet called 5/24 Count is optional but valuable if you are actively working Chase cards.
Minimum Spend Countdown Formula
Add a column called Days Left that auto-calculates remaining days. In the first row, use:
=IF(J2="", DAYS(I2, TODAY()), "Met")Where column I is the deadline and column J is the bonus-posted date. Apply conditional formatting: red if under 14 days, yellow if under 30 days, green otherwise. The sheet now visibly warns you before a deadline hits.
Annual Fee Warning Formula
In a column called AF Alert, flag cards whose fee is due within 60 days:
=IF(DAYS(M2, TODAY()) <= 60, "Decide soon", "")Every Sunday, any row that shows "Decide soon" is your cue to call the issuer for a retention offer or queue a downgrade. Our cancel vs downgrade timing guide covers exactly what to say.
Keep the workbook simple enough to update from your phone during a retention call. Complex dashboards get abandoned within weeks; a clean two-sheet layout gets used for years.
The Five Deadlines That Cost You Money
Every churning loss traces back to one of five missed deadlines. Set each as a flagged column in your tracker and review weekly.
1. Minimum Spend Deadline
Most cards give 3 months from account opening. A few give 6 months (Ink Business cards), and premium cards sometimes give 6 months on larger spends. If you only learn one deadline, learn this one — a missed minimum forfeits the entire bonus. See our minimum spend guide for 10 practical ways to hit the target without overspending.
2. Bonus Posting Window
Bonuses post within 6-8 weeks of meeting minimum spend for most issuers. If 10 weeks pass and nothing has posted, call the issuer. Some bonuses get coded incorrectly and only a phone call fixes them. Track the post date so you have evidence.
3. Annual Fee Window
Fees typically post on the statement that includes your account anniversary. You have roughly 30 days after the fee hits to call for a refund, retention offer, or downgrade. Flag 60 days ahead in the tracker so you are never caught off guard.
4. 48-Month Sapphire Cooldown
Chase Sapphire bonuses can only be earned if 48 months have passed since your last Sapphire bonus. Track the posting date of your last Sapphire bonus so you know exactly when you are eligible again. Our Chase Sapphire churning guide covers the 48-month rule in depth.
5. Citi 48-Month Family Rule
Citi enforces a 48-month cooldown across its card families. If you earned a ThankYou Premier bonus, you cannot earn another Premier bonus (or the equivalent Strata Premier) for four years. Track bonus post dates for every Citi card so you never re-apply too early.
Building a Chase 5/24 Counter
Every churner who wants Chase cards needs a live 5/24 count. The rule counts all personal credit cards opened across all issuers in the past 24 months — business cards from Chase, Amex, Citi, and Barclays do not count. Our full breakdown is in the Chase 5/24 rule guide.
5/24 Formula
Add a column called Counts Toward 5/24 that is TRUE for personal cards from any issuer and for Capital One and Discover business cards (both report to personal bureaus). Then build the counter on the Summary sheet:
=COUNTIFS(Cards!F:F, TRUE, Cards!C:C, ">=" & EDATE(TODAY(), -24))Where column F is the "Counts" flag and column C is the application date. The counter updates every time you load the sheet. If it shows 5 or more, pause Chase applications until older cards roll off.
Include authorized user accounts in the raw tracker even if you plan to argue them off during reconsideration. Chase's algorithm initially counts them, and you want a realistic picture of what the underwriter sees.
Tracking Issuer-Specific Rules
Each major issuer has velocity and eligibility rules that a generic tracker will miss. Build dedicated columns for the rules that apply to the cards you actually churn. Our full application rules by bank guide covers every rule in detail.
| Issuer | Rule to Track | Column Needed |
|---|---|---|
| Chase | 5/24 count, 48-month Sapphire cooldown, 24-month Ink rule | Counts toward 5/24? (TRUE/FALSE) |
| Amex | Lifetime language per card, popup warnings, 5-card personal limit | Amex card family, popup seen? |
| Citi | 48-month family cooldown, 1/8 rule, 2/65 rule | Citi family, days since last Citi app |
| Capital One | 2-card lifetime limit, 6-month velocity window | Capital One card count |
| Bank of America | 2/3/4 rule, 24-month bonus cooldown | BoA apps per rolling 2/12/24 months |
| Barclays | 6/24 informal rule, 24-month bonus cooldown | Barclays app count past 24 months |
Spreadsheet vs App: What to Use
There are three common approaches. The right choice depends on how many cards you hold and how much customization you want.
| Tool | Strength | Weakness | Best For |
|---|---|---|---|
| Google Sheets | Free, fully customizable, mobile editable, shareable with spouse | Manual entry required | Almost everyone |
| Travel Freely | Free, visual 5/24 tracker, automated issuer rules | Less flexible fields, ad-supported | New churners who want guardrails |
| AwardWallet | Auto-tracks award balances across 700+ programs | Paid for full features, not churning-specific | Heavy travel redeemers |
| Notion / Airtable | Rich views, relational data, automations possible | Overkill for fewer than 15 cards | Power users with 20+ active cards |
Most experienced churners start with Google Sheets and never leave. The combination of free, flexible, and accessible on any device is hard to beat. Apps shine for specific jobs (Travel Freely for visual 5/24, AwardWallet for miles balances) but rarely replace the main tracker.
A Weekly Review Checklist
A 15-minute Sunday review is what separates organized churners from accidental ones. Walk down this list every week — it catches 95% of issues before they cost you money.
Sunday Review (15 Minutes)
- 1.Update spend-to-date for any card in its minimum spend window. Red-flag anything under 30 days left.
- 2.Check for posted bonuses on cards where spend was recently completed.
- 3.Review the annual-fee alert column. Call retention or start a downgrade path for anything flagged.
- 4.Refresh the 5/24 counter and note which cards will roll off in the next 3 months.
- 5.Scan for any cards that should be eligible again after a 24- or 48-month cooldown.
- 6.Plan the next application slot: which card, which issuer, and whether you are under any applicable velocity limits.
New churners often skip the weekly review and rely on memory. That works for the first two cards. By card five or six it stops working, and the first missed bonus is always expensive. A calendar reminder for the review is cheaper than one lost $750 bonus.
Frequently Asked Questions
Do I really need a spreadsheet to track credit card applications?
If you hold more than three or four rewards cards, yes. Without a tracker you will miss minimum spend deadlines, forget which cards are about to hit annual fees, lose track of your 5/24 count, and occasionally re-apply for a card you are ineligible for. A single missed bonus can be worth $500 to $1,500. A spreadsheet that takes 30 minutes to set up protects every future bonus you earn.
What information should I track for each credit card?
At minimum track: application date, approval date, card name, credit limit, sign-up bonus amount, minimum spend required, minimum spend deadline, bonus posted date, annual fee, next annual fee due date, and current status (active, downgraded, closed). Advanced trackers also log hard pull bureau, referral source, retention offers received, and product change history.
How do I track my Chase 5/24 status?
Your 5/24 count is the number of personal credit cards you have opened across all issuers in the past 24 months. Track each new personal card with its exact opening date, then count how many fall inside the rolling 24-month window from today. Business cards from Chase, Amex, Citi, and Barclays do not count. Authorized user accounts technically count on your credit report but Chase usually ignores them if you explain it during reconsideration.
When should I check my credit card tracker?
Weekly at minimum. A 15-minute Sunday review catches upcoming minimum spend deadlines, approaching annual fees, and bonuses that should have posted but have not. Monthly reviews are not enough — a card with a 90-day spend requirement can slip past if you only check every 30 days, especially if you pushed the biggest purchases to the end.
What is the best free credit card tracking tool?
A Google Sheet is the best free option because it is free, editable on mobile, shareable with a spouse, and easy to customize. Paid apps like Travel Freely (free with ads) and AwardWallet track automatically but have fewer churning-specific fields. For serious churners with 20+ cards, a custom spreadsheet beats any app because you can build issuer-specific rule reminders.
How do I know when my sign-up bonus has posted?
Most issuers post bonuses within 6-8 weeks after you meet the minimum spend. Chase and Capital One typically post within 1-2 statement cycles. Amex posts bonuses 8-12 weeks after the qualifying purchase. Log in to your account monthly and look for the bonus as a line-item credit in your rewards or points balance. If it has been more than 10 weeks after meeting spend, call the issuer — bonuses occasionally fail to trigger.
Should I track authorized user cards?
Yes, especially if they count toward Chase 5/24 (they do, on your credit report). Track the opening date, whether you are the primary or AU, and any rewards you earn. If you are made an AU on someone else's card and then apply for a Chase card, the AU account will show up on your report and may affect your 5/24 count — though reconsideration reps will usually remove it from the count if you explain.
Related Guides
Chase 5/24 Rule Explained
The exact rules for counting 5/24 and which cards are subject to it.
Application Rules by Bank
Every issuer's velocity and lifetime rules in one place.
How to Meet Minimum Spend
10 practical ways to hit a spend requirement without overspending.
When to Cancel or Downgrade
Timing for the annual-fee decision and what to say to retention.
How Sign-Up Bonuses Work
The mechanics of qualifying for and receiving a welcome bonus.
Maximize Approval Odds
Application spacing, reconsideration lines, and how to get approved.
Find Your Next Card
Once your tracker is set up, the next step is picking the right next card to apply for. Browse these data-driven lists.
Start Tracking Your Next Card
A tracker is only useful once you have a card in it. Browse current sign-up bonuses and add your next application to the sheet before you click apply.
Browse All Credit Cards