Subscription Tracker Template and the AI Prompt That Finds Your Recurring Charges

You can fill most of it in by pasting your statements into an AI assistant with the prompt below, then checking what it finds before you cancel anything.
Recurring charges are easy to miss. They land on different days and different cards, often under names that don’t match the service, and a yearly renewal may fall outside the months you’re looking at. A $2.99 storage plan or a trial that quietly turned paid doesn’t stand out on a statement full of groceries and gas.

You build this tracker with one prompt, and there’s no app to install. Paste in three months of transactions and the assistant sorts every repeating charge by yearly cost. It also points out price increases, trials that turned paid, services that overlap and anything it can’t identify. The decisions stay with you. Below is what a good answer contains and what to check before you trust it.

You’ll also get the template’s column layout to reuse, the privacy steps to take before you paste and the cancellation path for each kind of charge.

By the end, you’ll have a subscription tracker template you can reuse, plus a checked list of charges to keep, change, cancel or investigate.

What a subscription tracker template needs to show

A useful subscription tracker answers three things: what the charge is, what it costs over a full year and what you’ve decided to do about it. The yearly number matters most. A $12.99 monthly charge looks small until it reads $155.88 a year.

The prompt fills in the first four columns and the yearly cost. The rest depend on things only you know.

Get the free tracker by email: the Excel file, a Google Sheets copy link and a printable PDF. Both spreadsheet versions start blank and include a Cancellations tab. The annual-cost column calculates after you enter an amount and choose weekly, monthly, quarterly or yearly. Leave an unclear frequency unresolved until you can confirm it.

Prefer paper? The same email has the printable tracker and the cancellation follow-up sheet to record your request, confirmation and later statement check. A Google account is needed only to save a Google Sheets copy.

The prompt below stays free to copy without signing up.

The tracker and the prompt work on their own or together. Fill in the tracker by hand from your statements with no AI at all, let the prompt below draft the list for you, or do both: have the assistant find the repeating charges, then copy the ones you’ve checked into the tracker and log any cancellation on the follow-up sheet.

Three ways to run the prompt

• Nothing connected. Export your transactions, remove what the audit doesn’t need and paste them into an AI assistant with the prompt. Most of this post covers this way.
• A read-only connection. ChatGPT’s Finances feature can read linked accounts for some US users. Details are further down.
• An assistant that cancels for you. Not part of this recipe yet. You still do the cancelling, and this post shows where.

Before you paste anything

Pull the right number of months

Three months shows weekly and monthly repeats, and it’s the window this prompt is written for.

Annual renewals need a longer look. A yearly plan billed in March won’t appear in a June through August export. Search twelve months of statements, or your email, for “renewal” and “annual,” and add what you find by hand. If you’d rather paste twelve months, change “three months” in the prompt’s first line.

Include every account that pays for things: checking, each credit card and PayPal if you use it. The assistant only sees what you give it. Look for a download or export option on each transactions page. Paste a CSV as plain text: open the file in a text editor, select everything and copy it.

Remove what the audit doesn’t need

The audit needs the date, the description and the amount. Before you paste, delete full account numbers, your name, your address and anything else that identifies you. Replace an account column with a nickname like Checking or Card.

That’s Run Your Household’s advice, not an official rule. We couldn’t find agency guidance written for AI assistants. It does match how OpenAI built its own finance feature, which it says can’t see full account numbers. (OpenAI Finances announcement)

No worries if your export has extra columns you don’t recognize. Open it in a spreadsheet app, keep the date, the description and the amount, delete the rest and save it as a CSV again before you copy it.

Check the privacy settings first

ChatGPT: the training setting is the “Improve the model for everyone” toggle under Settings > Data controls. A Temporary Chat doesn’t appear in your history, doesn’t create memories and isn’t used for training, though OpenAI may keep it up to 30 days for safety. (OpenAI Data Controls FAQ)

Claude: the toggle is labeled “Help Improve our AI models” under Settings > Privacy. With it off, new chats aren’t used for training, though chats flagged for safety review may still be used for that work. (Anthropic Privacy Center) Incognito chats aren’t used for training even when the toggle is on. (Claude Help Center)

Labels change, so glance at the current settings before your first run.

The prompt that fills in your subscription tracker

Open a new chat, copy the prompt and paste your transactions on the line after “Transactions:”.

I'm pasting three months of transactions from my bank and credit card accounts below. Each account has a nickname like "Checking" or "Card." Please do a subscription audit that I can copy into my subscription tracker.

Before you start: if the data covers less than three months, or a column like date or amount is missing, tell me what's missing first, then do what you can with what's there.

1. Find every charge that repeats. Also include charges that look like a renewal even if they only show up once, since annual plans often do. Watch for services billed through Apple, Google Play, PayPal, or Amazon, where the statement may show the store's name instead of the service.

2. Make a table with these columns, in this order:
- Service: what it probably is. If you aren't sure, write "Unknown."
- Name on statement: copied exactly as it appears
- Amount: the most recent charge
- How often: weekly, monthly, every 3 months, yearly, or unclear
- Next charge: estimated from the last charge date and how often it repeats, or "unclear"
- Per year: weekly x 52, monthly x 12, every 3 months x 4, yearly x 1. Leave it blank if How often is unclear.
- Paid with: the nickname of the account it was charged to
- How to cancel: Apple, Google Play, PayPal, Amazon, or directly with the company, if the statement name makes that clear. Otherwise write "check."
- Decision: leave this blank. I'll fill it in.

3. Sort the table by Per year, highest first.

4. Put regular bills (rent, mortgage, phone, internet, insurance, utilities, loan payments) in a separate, shorter table with Service, Name on statement, Amount, and How often. They don't count toward the subscription total.

5. Under the tables, list anything that needs my attention: price increases (show the old amount, the new amount, and the dates), free trials that turned into paid charges, the same service charged on two accounts, two services that seem to do the same job, and any charge you can't identify.

6. Leave out one-time purchases, refunds, income, and transfers between my own accounts, such as credit card payments. Give me a short list of what you left out and why. If a charge might be a subscription but you aren't sure, put it in the table and flag it instead of leaving it out.

7. Never guess a company name. If you don't know what a charge is, say so.

8. Don't tell me what to cancel. For each subscription, give me one question to ask myself before I decide.

9. Finish with the total yearly cost of subscriptions only. Show the math one line per subscription. List any subscriptions you left out of the total because how often they charge is unclear.

Format the tables so they paste cleanly into a spreadsheet.

Transactions:

Why each line is there

Line 1 asks for renewals that show up once, because an annual plan may appear a single time in three months. Line 2 keeps the name exactly as the bank prints it, since that’s what you’ll search for later, and puts the assistant’s guess in a separate column.

Line 3 sorts by yearly cost so the largest charges are the first ones you look at. Line 4 separates recurring household bills from subscriptions, so rent, utilities and loan payments don’t inflate the subscription total.

Line 5 asks for the problems that are hardest to spot on a statement: price increases, trials that turned paid, duplicate charges, overlaps and unknown charges. Line 6 prevents transfers and refunds from distorting the result while keeping uncertain subscription-like charges visible for review.

Line 7 stops the assistant from inventing a company name, which could send you to cancel the wrong thing. Line 8 asks for a question instead of a recommendation because the assistant can’t see whether anyone in the house still uses a service. Line 9 asks for subscription-only math so you can check the total yourself.

What a good answer looks like

• Two tables: subscriptions sorted by yearly cost, and regular bills kept separate.
• Every name copied exactly as the bank prints it, with “Unknown” wherever the assistant can’t tell what a charge is.
• A list of flags: price increases with the old and new amounts, trials that turned paid, the same service on two accounts, overlapping services and charges it can’t identify.
• A short list of what it left out, such as refunds and card payments, and why.
• One question for each subscription instead of a recommendation to cancel.
• The yearly subscription total, with one line of math per subscription.

If the answer guesses company names or skips the left-out list, paste the prompt into a fresh chat and run it again.

What to double check before you trust the total

Check these before you count on the total.

1. Unknown charges inside the total. If the total includes charges the assistant couldn’t name, find out what they are before you count them.
2. “What it probably is” is a guess. A cryptic name can point to the wrong company, so match each row to a receipt or account page.
3. Weekly math assumes every week. A weekly charge times 52 counts every week of the year. If you skip or pause some weeks, use the real number.
4. Some overlaps are judgment calls. Two storage plans overlap. A meal kit and groceries is a question, not a duplicate.
5. Charges outside the window. Your twelve-month search covers what three months can’t.
6. Things counted as spending that aren’t. OpenAI’s help page for its own finance feature names transfers, card payments, reimbursements and duplicate pending transactions as error sources. (OpenAI Finances help) They’re worth checking with any assistant.
7. Shared descriptors. A charge labeled apple.com/bill can be an app, a subscription or media. Apple’s Report a Problem page shows which. (Apple Support)
8. The math it shows. Check a few lines with a phone calculator, even though the prompt asks the assistant to show its work.

Then pick three subscriptions, find each on the original export and confirm the amounts and dates match the table. If a row doesn’t match, tell the assistant in the same chat which row is off and ask it to check that charge against the transactions you pasted. When the two disagree, your export is the record.

If your accounts are already connected

ChatGPT’s Finances feature connects bank and card accounts through Plaid. OpenAI lists finding subscriptions and recurring bills as a use, with a Subscriptions view showing amounts, how often each charges and the next charge date. It’s available in the US on Plus and Pro plans, on web, iOS and Android. (OpenAI Finances help; OpenAI announcement)

It’s read-only. OpenAI says it can’t move money, pay bills or change account settings. Its accuracy depends on which accounts are connected and synced, and you can ask it which transactions it included. Temporary Chats don’t access connected accounts. After you disconnect, OpenAI says synced data is deleted within 30 days. The help page changes often, so check it before connecting anything.

If you use an assistant without a verified read-only connection, paste or upload a redacted export instead.

How to cancel what you decide to cut

The prompt doesn’t cancel anything, so this part is yours. Go by how the charge is billed, not by the app’s name.

Apple subscriptions

On an iPhone or iPad, go to Settings > [your name] > Subscriptions, choose the subscription and tap Cancel Subscription, or cancel at account.apple.com. Cancel a trial at least 24 hours before it ends. Subscriptions billed through a carrier or another company are cancelled with that provider. (Apple Support)

Google Play subscriptions

Open your Google Play subscriptions, choose the subscription and select Cancel subscription. Uninstalling the app doesn’t cancel it. Access continues to the end of the paid period. (Google Play Help)

Directly with the company

For anything billed straight to your card or bank, cancel through the company’s account page or customer service. Keep the confirmation.

Bank account autopay

The CFPB’s steps: tell the company you’re revoking permission for automatic payments, tell your bank or credit union you’ve revoked it, then follow up in writing with both. The CFPB page links to sample letters you can adapt. Your bank may suggest a stop payment order, which usually costs a fee. Cancelling the payment doesn’t cancel what you owe or the contract. (CFPB) For a stop payment, the federal rule says to notify the bank at least three business days before the scheduled transfer. (Regulation E, 12 CFR 1005.10(c))

Credit card charges that keep coming

Cancel with the merchant first. If charges continue, contact your card issuer. To dispute a charge, contact the issuer right away and send a written billing-error notice within 60 days after the charge appeared on your statement. (CFPB)

Track the cancellation through confirmation

Choosing Cancel records a decision. Use the Cancellations tab to follow through. Copy the service and paying-account nickname from the tracker so you can match the right charge later.

1. Record the request. Enter when you requested cancellation and the billing provider or account page you used.
2. Save the confirmation. Keep the email or screenshot privately. Enter a short reference, the date confirmation arrived and the effective end date. A request without confirmation stays open.
3. Set a statement check. Use the next expected charge date from the tracker or account page. Choose a check date after that charge would appear and after the effective end date, including the relevant renewal for an annual plan.
4. Check what happened. Enter the date you actually checked and choose No further charge, Charged again or Unclear. The sheet only shows Closed after check when the confirmation fields and a later statement check are complete. It relies on the dates and result you enter.

If another charge appears, verify it against the confirmation and follow up with the billing provider. Keep your records. The FTC’s subscription guidance also recommends saving cancellation records and watching later statements. Don’t count the old annual cost as savings just because you selected Cancel; a refund, partial period or final charge can change what actually stopped.

Turn the tracker into a habit

A tracker built once goes stale. Two small moves keep it current.

First, put renewal and trial end dates next to the household’s other due dates. If you keep a bill calendar, add them there, with the card that pays for each, so a yearly charge has money waiting before it lands.

If you use the free household budget template, add the subscriptions you’re keeping to its Bills & Savings tab and give its Subscriptions category a plan that covers them.

Second, rerun the prompt on a schedule. Run Your Household’s default is once a quarter with the newest three months. Put the old table beside the new one and look first at anything new, anything pricier and anything you meant to cancel.

A 2023 National Bureau of Economic Research working paper used payment-card data for 10 subscription services. When a subscriber’s card was replaced and staying subscribed took action, cancellations jumped. The monthly drop in retention was about four times larger in those months. The authors read that as inattention: some people keep paying for services they’d drop if something made them look. (Einav, Klopack and Mahoney, NBER Working Paper 31547) A quarterly rerun gives you that same moment to look, on a date you choose.

Start your subscription tracker template with one prompt, check it against your statements, then decide what stays.

Export the last three months from every account that pays for things, strip out the account numbers and run the prompt today. If that feels like too much for one sitting, start with the card that carries most of your subscriptions and add the other accounts before you count on the total.

Related posts: Bill Calendar Template: Map Every Bill to a Payday and How to Negotiate Your Internet Bill: An AI Agent Got AT&T From $125 to $90

---

Educational notice: This article provides general educational information, not individualized financial or legal advice. Cancellation steps, fees and consumer protections vary by company, account and state. AI assistants can make mistakes, so check every result against your own statements.