← All free prompts
Money · 15 min

Track Every Subscription With AI and a Free Spreadsheet

Find recurring payments in your transactions, price them in hours of work, and see what cutting would save. Check a full year for annual renewals. Free template for Excel and Google Sheets.

Use it whenOnce to set up, then every few months, or whenever a price goes up.
You'll needYour last 3 months of bank transactions (exported, account numbers removed) and the free spreadsheet below.

Set it up (10 minutes)

  1. Download the free Money Desk Lite spreadsheet. Excel: just open it. Google Sheets: upload it to Google Drive, open it, then File > Save as Google Sheets.
  2. On the Settings tab, add your real hourly rate (step 2 of the free 10-Minute Time Audit). Delete the yellow example rows on the Subscriptions tab.
  3. In your online bank, export the last 3 months of transactions (CSV or Excel). Delete the account and card number columns before you paste anything into an AI.

Download the free spreadsheet (.xlsx)

Then: the prompt

  1. Copy the prompt below.
  2. Paste it into a new chat in ChatGPT, Claude, Gemini or Copilot.
  3. Replace the [orange] parts with your details, then press Enter.
COPY-PASTE PROMPT
Here are my last 3 months of transactions, account numbers removed: [paste].
Find every recurring payment: subscriptions, memberships, apps, plans, insurance.
Give me tab-separated rows for my Subscriptions tab with four columns: Name, Category, Cost per payment, Billing (Monthly, Yearly, Quarterly or Weekly). No header row.
Then list anything that looks like a duplicate, a free trial that became paid, or a price rise. Mark guesses [CONFIRM].
Use only the transactions I give you. Never invent amounts. Don't ask for account numbers or passwords.
EXAMPLEThree months of transactions, pasted in with the account numbers removed.
WHAT YOU GETRows ready to paste into the Subscriptions tab, plus: "Three streaming services, two you could pause [CONFIRM]". The sheet then shows the yearly cost and the hours of your life they take.
Make it better. Type this next:

"Which three of these would I miss least? Price each one in hours of my life at [my real hourly rate]."

Check before you use it

Check the AI's list against your bank before you cancel anything.

Never paste account numbers, card numbers or passwords into an AI.

"Most people find money they forgot about. Some of them find hours."Vince Marlow

Go beyond subscriptions. Track every transaction against your spending plan with the full Money Desk, a dashboard and a monthly review, plus 17 worksheets in The Time Ledger.

Get The Time Ledger · $29 See what's inside
Free · Instant download

The 10-Minute Time Audit

Three numbers that change how you spend your week: your weeks, your real hourly rate, and your costs priced in hours.