Short answer: Keep one row per application with the date, issuer, personal or business, status, bonus, minimum spend, spend so far and deadline. Formulas then show spend remaining and days left, a COUNTIFS gives your rolling 24-month personal card count, and a MINIFS tells you when the oldest card drops out of the window.
The formulas below assume this layout. Extra columns (issuer, rewards program, annual fee, fee date, bonus posted) can go after column J.
I: Spend remaining: =MAX(0,F2-G2)J: Days left: =H2-TODAY()Many offers give you about 3 months to hit the minimum spend, but terms vary, so always use the date in your own offer. If the window is 3 months from the date in A2, put =EDATE(A2,3) in H2. Then add a conditional format rule with the custom formula =AND($I2>0,$J2<=14) and a red fill, which flags any card that still needs spend and has two weeks or less.
Some issuers are widely reported to limit approvals by how many personal cards you opened in the last 24 months (the community calls this x/24, for example 5/24). Issuers do not publish all of their rules, so treat the limit as a number you set yourself. Using the layout above:
Cards in window: =COUNTIFS(A:A,">="&EDATE(TODAY(),-24),C:C,"Personal",D:D,"Approved")Slots left (limit in cell M1): =M1-[cards in window]Next drop-off date: =EDATE(MINIFS(A:A,A:A,">="&EDATE(TODAY(),-24),C:C,"Personal",D:D,"Approved"),24)Add a small table with one row per issuer: last application date (=MAXIFS on the log), applications in the last 12 months (COUNTIFS with EDATE(TODAY(),-12)), and a cooldown in days you enter yourself. Next eligible = last application + cooldown, and OK to apply = IF(TODAY()>=next eligible,"OK","Wait").
Keep a balances tab with each program and your own cents-per-point estimate. Bonus value in dollars = Bonus points x cents per point / 100. Summing that across approved cards gives you what churning actually earned you this year, which helps when you weigh annual fees.
Yes. You can build the core of one with the formulas on this page. The ready-made template below adds a deadline-sorted dashboard, issuer rule cells, a points balance tab and the x/24 counter, and works in Google Sheets and Excel.
No spreadsheet should hard-code them, because issuers change rules and do not publish all of them. Keep every rule as a cell you can edit when new data points appear.
Each application usually adds a hard inquiry and a new account lowers your average account age, which can lower your score for a while. Paying in full every month matters far more. This is general information, not financial advice.
Contact: m0f@mail.grokbot.com | Machine-readable: llms.txt, llms-full.txt, tools.json, openapi.json | Source: GitHub