The Subscription Audit Worksheet: Find the $200 a Month You Forgot You Were Spending

What the worksheet actually is

A single sheet of paper with one row per subscription and four columns: the service name, the monthly cost, the billing date, and whether you used it in the last thirty days. Nothing else. No annual cost, no renewal date, no notes about what you watched on that service in 2023.

The worksheet exists for one job: to answer the question "what am I paying for every month" when the bank statement shows fifteen charges and you can only name six. Everything else - the annual cost, the renewal date, the cancellation policy - belongs in the service's account settings. The worksheet is the list, not the cancellation button.

Why the bank statement is not enough

A bank statement shows the charges. It does not show the pattern. You see "$14.99" and you know it is streaming, but which streaming? You see "$9.99" and you know it is an app, but which app? The statement is a list of charges; the worksheet is a list of services, and the difference is that you can make decisions about services but not about charges.

The second failure mode is that the statement shows the past, not the future. A charge that landed yesterday is already spent; the decision to cancel it would have been more useful thirty days ago, before the charge hit. The worksheet is the tool for making the decision before the charge, not after it.

The third failure mode is that the statement does not ask the question that matters: did you use it? A charge for a service you did not use in the last thirty days is a charge for a service you are paying for but not getting value from. The worksheet has a column for that question, and the answer is the decision.

The one-hour audit

Open the bank app and go to the last three months of transactions. Not just this month - three months, because some subscriptions bill quarterly and will not show up in a single month's statement. Write every recurring charge on the worksheet: the service name in column one, the monthly cost in column two (divide quarterly charges by three, annual charges by twelve), the billing date in column three.

Now open your email and search for the word "subscription" or "renewal" or "your plan." Every match is a subscription that bills through a different payment method - a PayPal auto-pay, a credit card you do not use for daily spending, a service that bills annually and did not show up in the three-month window. Add each one to the list.

For each row, answer the question in column four: did you use this service in the last thirty days? Not "did you mean to use it" or "do you plan to use it next month." Did you use it in the last thirty days? If the answer is no, the subscription is a candidate for cancellation.

The cancellation decision

A subscription that costs money and provides no value in the last thirty days is not automatically a bad subscription. Some services are worth paying for even if you do not use them every month - cloud storage for the photos you took last year, insurance for the trip you are taking next quarter, a service you use seasonally.

The question is not "did I use it" but "is the cost justified by the value." If the answer is yes, keep the subscription. If the answer is no, cancel it before the next billing cycle. The worksheet makes the cost visible; the decision makes the cost intentional.

The subscriptions that survive the audit are the ones you are paying for on purpose. The ones that do not survive are the ones you were paying for by default. The difference is the money you save every month.

Where the worksheet lives

On paper, in the same folder as the monthly budget worksheet. Not in a file on your desktop, because a desktop file is a list you will not open. Not in a note on your phone, because a phone is lost more often than a house.

The paper worksheet is updated in ink. When you add a subscription, add a row. When you cancel a subscription, cross it out and write the date. When the cost changes, cross out the old cost and write the new one beside it. The worksheet is a living document, not a snapshot.

The worksheet is updated once a month, on the same day as the monthly budget worksheet. The two worksheets are the same ritual: thirty minutes of visible planning replaces thirty hours of invisible worrying.

What the worksheet does not do

It does not cancel the subscriptions. You cancel the subscriptions. The worksheet makes the list visible.

It does not enforce discipline. The worksheet shows the cost; you make the choice to reduce it.

It does not replace the bank statement. The bank statement shows the charges. The worksheet shows the services.

It does one job: it makes the full list of subscriptions visible, and visibility is the mechanism that turns "where did the money go" into "I know what I am paying for and why."