The Ultimate Churning Spreadsheet: What to Track and Why

Every churner starts with a spreadsheet. You open a new credit card, jot down the details in a Google Sheet, and for a while it works beautifully. Two cards become five. Five become twelve. You add a bank bonus column, a player column, a tab for closed accounts. And somewhere around month eight, you're staring at a 35-column monster with conditional formatting rules you don't remember writing.

Spreadsheets are a completely valid way to track churning. Thousands of people in the r/churning community run their entire operation out of Google Sheets. The key is knowing what to track, how to structure it, and when your spreadsheet is holding you back instead of helping you.

This guide covers what belongs in a credit card churning spreadsheet, the formulas that save time, and the honest moment when a spreadsheet stops being the right tool.

Essential Columns for a Churning Spreadsheet

These are the fields that every bonus tracking spreadsheet needs from day one. Skip any of these and you'll be retrofitting them later — which is always more painful than setting them up right.

Card / Account Name

The product name: "Sapphire Preferred," "Total Checking," "Platinum Card." Be consistent — if you abbreviate Chase Sapphire Preferred as "CSP" in one row and spell it out in another, filtering breaks. For bank bonuses, include the account type ("Chase Total Checking" rather than just "Chase") since you might have multiple accounts at the same institution.

Issuer / Bank

A separate column for the issuing bank: Chase, Amex, Citi, US Bank. When you need to answer "how many Chase cards do I have open?" you want to filter one column, not scan account names. This column is also essential for tracking issuer-specific rules like Chase's 5/24, Amex's once-per-lifetime language, or Citi's 48-month restriction.

Open Date

The date the account was opened or approved. This is the anchor for almost everything else: your bonus deadline, your 5/24 timeline, and your "safe to close" window all start here. Use YYYY-MM-DD format — it sorts correctly and avoids ambiguity.

Bonus Deadline

The date by which you must meet the bonus requirements. For credit cards, this is typically 90 days from the open date. For bank bonuses, it varies wildly — anywhere from 30 days to 12 months. Some people calculate this with a formula (more on that below); others enter it manually. Either way, this column is non-negotiable. Missing a bonus deadline is the single most expensive mistake in churning.

Bonus Amount and Type

These deserve separate columns. Bonus amount is the numerical value (60000, 300, 80000). Bonus type is points, cash, or miles — "60,000 points" and "$600 cash" are very different values depending on your redemption strategy. Optionally, add a third column for estimated cash value (e.g., Amex MR at 1.5 cents per point).

Minimum Spend Requirement and Current Spend

For credit cards, this is the core tracking loop. Spend requirement is the target ($4,000). Current spend is where you stand ($2,650). Yes, tracking current spend means manual updates — the part most people fall behind on — but even a rough estimate is better than guessing. For bank bonuses, these columns can track direct deposit amounts, debit transaction counts, or minimum balance requirements.

Status

This is where many churning spreadsheets are too vague. "Active" and "Done" aren't enough. A more useful set of statuses:

• Planned — You intend to apply but haven't yet
• Applied — Application submitted, awaiting decision
• Opened — Account is open, working on requirements
• Requirements Met — You've hit the spend or completed the requirements
• Bonus Received — The bonus has actually posted to your account
• Closed — Account closed
• Declined — Application was denied

The distinction between "Requirements Met" and "Bonus Received" matters more than you'd think. Banks don't always pay bonuses immediately after requirements are met, and you need to know which bonuses you're still waiting on.

Annual Fee and Fee Date

Track both the annual fee amount and when it hits. The fee date is usually the account anniversary, but some issuers charge a month before. Essential for planning downgrades and closures. Even for no-annual-fee cards, enter $0 — blank cells create ambiguity between "no fee" and "I forgot to fill this in."

Player

If you're tracking bonuses for more than one person, you need a player column. The community convention is P1 (Player 1) and P2 (Player 2), but use whatever labels make sense. This is also useful for filtering 5/24 count per person.

Notes

A catch-all for everything else: referral links, the specific direct deposit method you used ("Gusto, $500, 2/15"), recon call results, retention offer details. Don't skip this column. Six months from now, you won't remember which DD method triggered a bonus at a particular bank, and that information is gold for your next attempt.

Advanced Columns for Power Users

Once you've been at this for a while, you'll want more data points. These columns aren't essential for beginners, but they become valuable as your portfolio grows.

5/24 Count Calculation

Chase's 5/24 rule — you can't be approved for most Chase cards if you've opened 5+ personal credit cards in the last 24 months — is the single most important application rule in churning. You can calculate your count with a formula that checks open dates, but it gets complicated when factoring in business cards (which don't count) and authorized user cards. Many people maintain a running count manually.

Net Profit

A card with an 80,000-point bonus ($1,200 value) but a $695 annual fee is worth $505 in net profit in year one. Tracking bonus value - annual fee changes how you prioritize applications.

Application Velocity

How many cards you've opened in the last 6 months, 12 months, and 24 months. This matters because several issuers have velocity-based restrictions beyond 5/24:

• Amex: 2/90 rule (2 credit card approvals per 90 days)
• Chase: Unofficial velocity sensitivity
• Citi: 1/8 and 2/65 rules (application spacing)
• Capital One: Limits to 2 open cards for many applicants

A column for x/6 and x/12 counts helps you plan your application calendar.

Direct Deposit Method Tracking

For bank bonuses, knowing which DD source you used at which bank is critical. Not all direct deposits are treated equally — a real payroll push might code as a DD while an ACH transfer from another bank might not. Add columns for DD source (employer payroll, Gusto, Venmo, etc.) and the date/amount. This builds your personal database of "what works where" over time.

Formulas That Save Time

A churning spreadsheet without formulas is just a list. Here are the formulas that save the most time in Google Sheets.

Days Until Bonus Deadline

If column B has your open date and the bonus window is 90 days:

=B2+90-TODAY()

This returns the number of days remaining. Negative numbers mean you've passed the deadline. Combine this with conditional formatting — red for under 14 days, yellow for under 30 — and you have a visual urgency indicator.

For bank bonuses where the deadline isn't a fixed offset, just reference the deadline column directly:

=C2-TODAY()

Spend Remaining

If column D is your spend requirement and column E is your current spend:

=D2-E2

Simple, but useful when paired with a "daily spend target" formula:

=IF(B2+90-TODAY()>0, (D2-E2)/(B2+90-TODAY()), 0)

This tells you how much you need to spend per day to hit the requirement on time. When that number jumps above $100/day, it's time to prepay some bills or make a large purchase you've been putting off.

Net Profit

If column F is your bonus amount (in dollars) and column G is the annual fee:

=F2-G2

For points-based bonuses, add a valuation multiplier. If you value Amex MR at 1.5 cents per point:

=(F2*0.015)-G2

Conditional Formatting for Urgent Deadlines

Not a formula, but the single most useful visual feature in a churning spreadsheet. In Google Sheets:

1. Select your "Days Until Deadline" column
2. Format > Conditional formatting
3. Add a rule: Less than 14 with a red background
4. Add a rule: Less than 30 with a yellow background
5. Add a rule: Less than 0 with a gray background and strikethrough

Overdue deadlines fade out, urgent ones scream at you, approaching ones give a heads-up. Takes 60 seconds to set up and prevents missed deadlines better than almost anything else.

Where Spreadsheets Break Down

Spreadsheets are great — until they're not. Here's where even a well-built churning spreadsheet starts working against you.

No Reminders

This is the biggest gap. Your spreadsheet doesn't tap you on the shoulder when a bonus deadline is 7 days away or an annual fee is about to hit. You have to remember to look at the sheet, and on busy weeks, you won't. You can mitigate this with Google Calendar events, but setting up a reminder for every deadline is its own maintenance burden — and if you forget to create one, the system fails silently.

Mobile Editing Is Painful

You're at the grocery store and you want to log a purchase toward your minimum spend. You open Google Sheets on your phone, wait for it to load, scroll right to find the spend column, scroll down to find the right card, tap the cell, edit the number, and hope you didn't fat-finger a digit. Wide spreadsheets on small screens are a fundamentally broken experience.

Manual Data Entry for Every Field

When you open a new Chase Sapphire Preferred, you already know the issuer, the typical bonus, the standard spend requirement, and the annual fee. But you're typing it all in by hand. There's no auto-complete, no database of known offers, and no way to prepopulate fields. Over 30+ accounts, the time and error rate both creep up.

No Visual Organization

A spreadsheet is rows and columns. There are no logos, no color-coded status indicators, no visual distinction between a credit card and a bank account beyond whatever you type in a "Type" column. For visual thinkers, this makes the sheet harder to scan quickly.

Hard to Share Across Devices

Google Sheets syncs, but the experience varies. Your desktop layout is incomprehensible on a tablet. If you're using Excel instead of Google Sheets, syncing becomes a real problem.

Gets Unwieldy at Scale

At 10 accounts, a spreadsheet is manageable. At 20, you're scrolling constantly. At 50+, you need multiple tabs, pivot tables, and cross-tab formulas. At that point, you're maintaining a small application, and you didn't sign up to be a developer.

When to Upgrade to a Dedicated Tracker

There's no magic number of accounts where a spreadsheet stops working. But there are signals:

• You've missed a deadline because you didn't check the sheet in time.
• You dread updating it — adding a new account feels like a chore, so you put it off.
• You can't quickly answer basic questions like "what's my 5/24 count?" or "which bonuses are still pending?" without scrolling and squinting.
• You're spending more time maintaining the spreadsheet than the spreadsheet is saving you.
• You and a partner are tracking separately because the shared sheet got too complicated.

When any of these happen, it's worth looking at a purpose-built tool. PointsDB was built for this transition — it tracks credit cards and bank bonuses in one place, calculates deadlines and 5/24 automatically, sends reminders before you miss anything, and works properly on your phone.

That said, if your spreadsheet is working, there's nothing wrong with keeping it. A well-maintained spreadsheet is better than a dedicated app you never open.

Conclusion

A churning spreadsheet is a perfectly good starting point. Build it with the right columns — account name, issuer, open date, deadline, bonus amount, spend requirement, status, annual fee, player, and notes — and you'll have a system that covers 90% of what you need. Add formulas for deadline countdowns and spend tracking, set up conditional formatting, and you have something genuinely functional.

The limitations — no reminders, clunky mobile experience, manual everything — are real, but they're livable if your portfolio is small and your memory is good. It's when the portfolio grows and the stakes get higher that those gaps start to cost real money.

Whatever you use, the most important thing is that you use something. A basic bonus tracking spreadsheet is infinitely better than no system at all, and a good system — whatever form it takes — pays for itself many times over.

---

Still love your spreadsheet? That's cool. But when you're ready to upgrade, PointsDB is free to start.