Credit Card Tracker Spreadsheet β€” cover

Credit Card Tracker Spreadsheet, Utilization, Due Dates, Annual Fees and Rewards, Google Sheets Excel

Sale price  $4.99 Regular price $9.98
Skip to product information
Credit Card Tracker Spreadsheet β€” cover

Credit Card Tracker Spreadsheet, Utilization, Due Dates, Annual Fees and Rewards, Google Sheets Excel

Sale price  $4.99 Regular price $9.98

CREDIT CARD TRACKER SPREADSHEET FOR GOOGLE SHEETS AND EXCEL
Log every card once, update each statement, and utilization, due dates, and status work themselves out β€” Paid, Due soon, Late, or Upcoming, card by card and overall.

πŸ“Š WHAT IT DOES
βœ“ Cards: one row per card β€” nickname, issuer, credit limit, APR, statement day, due day, annual fee and the month it posts, and your rewards rate. Up to 8 cards.
βœ“ Monthly Log: one row per card, per statement β€” balance and payment. Due date, utilization, and status fill in on their own.
βœ“ Dashboard: every card's limit, balance, utilization, and status in one table, plus total annual fees and how many cards are due soon or late.
βœ“ Dashboard: a chart of utilization by card, and a chart of your overall utilization over the last 12 closed months.
βœ“ Start here: type your name (optional) and open Cards β€” every number after that comes from what you log.

πŸ“‚ WHAT'S INSIDE: 4 TABS AND 2 CHARTS
βœ“ Start here: a one-cell start, then straight to Cards
βœ“ Cards: up to 8 cards, four cards, and the full list
βœ“ Monthly Log: four cards, and every statement you've logged
βœ“ Dashboard: four cards, the card-by-card table, and two charts

πŸ“ HOW IT WORKS
1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Cards, add each card β€” limit, APR, statement day, due day, and annual fee.
3. Every month, add a row on Monthly Log with the statement balance and what you paid.
4. Open Dashboard any time for utilization, due dates, and status at a glance.

πŸ“₯ WHAT YOU GET
βœ“ Google Sheets version (the link is in the PDF)
βœ“ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
βœ“ A filled example to look around, and a blank copy for your own cards
βœ“ A PDF guide with screenshots, the links and the first steps
βœ“ A video guide for this planner (the link is in the PDF)

πŸ’» GOOD TO KNOW
βœ“ Works with a free Google account. No app, no ads, no subscription.
βœ“ Statement day and due day are just the day of the month β€” the sheet works out which calendar month each one falls in.
βœ“ Utilization is balance divided by limit, card by card and combined β€” under 10%, 10-30%, and over 30% are colored so you can see it at a glance.
βœ“ Rewards rate is a label you set per card β€” it's yours to fill in, not a built-in rewards calculator.
βœ“ Type only in the lighter input cells. Formulas are protected: Google Sheets warns you before you change one, and Excel keeps them locked.
βœ“ Best on a computer for setup. The Google Sheets app works for a quick check on your phone.
βœ“ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets. Links between tabs work in Google Sheets.
βœ“ English only. Not made for Apple Numbers.
βœ“ Free updates for life.

This is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.

You may also like