Getting started

A price log for subscriptions when the monthly fee goes up

Build a simple price log that catches subscription price hikes in dollars, shows the yearly impact, and tells you which plans to downgrade or drop.

Editorial illustration for A price log for subscriptions when the monthly fee goes up

The way to catch a subscription price increase is to keep a price log: one row per subscription with the amount you were charged last time and the amount this time, plus a column that flags any difference. The log takes ten minutes to build, and after that each statement is a quick scan. This article uses dollars and made-up figures; the method works in any currency.

What goes in the price log?

ColumnExample entryPurpose
ServiceVideo streamingWhat it is
Billing cycleMonthlyMonthly or yearly
Previous charge$15.49Last statement
Latest charge$17.99This statement
Change$2.50Latest minus previous
Yearly effect$30.00Change times 12 for a monthly plan
Renewal dateThe 14thSo you can act before it hits

How do I calculate the change automatically?

In a spreadsheet, with previous charge in D and latest in E, put =E2-D2 in the Change column and =IF(E2>D2,"UP","") in a flag column. For the percentage rise, use =IF(D2=0,"",(E2-D2)/D2). With the figures above, $2.50 divided by $15.49 is about 16.1 percent, and the yearly effect is $2.50 times 12, which is $30.00. Format the percentage column as Percent so it reads 16.1% rather than 0.161.

Where do I get the numbers from?

  • Your card or bank statement is the source of truth, because it shows what was actually charged, including tax.
  • Renewal emails often announce an increase ahead of time. Search your inbox for the word price near the service name.
  • The service's own account page lists the current plan price. Compare it with the statement.
  • For yearly plans, log the renewal date a month ahead so the increase does not surprise you.

What if the price stayed the same but the total changed?

Sales tax or a currency fee can move a charge without the plan price changing. If you see $17.99 become $18.47, check whether it is a tax line before assuming a hike. Record the difference as its own note instead of folding it into the plan price.

A quick audit with all the arithmetic

Say five services cost $17.99 plus $11.99 plus $9.99 plus $6.99 plus $4.99, a monthly total of $51.95, and $623.40 over twelve months. Two rise by $1.00 and $2.00. The new monthly total is $54.95, and the yearly total is $659.40, a $36.00 increase. That figure is what you weigh against how often you actually use each one.

When a sheet becomes tedious

With ten or more recurring payments, copying amounts every month gets old. SpendixAI is aimed at India and INR, so it fits rupee statements rather than US banks, but its approach may be a useful comparison: it can flag same-amount charges to one merchant within two days, and its Pro plan has bills tracking. For a dollar life, the log above does the job and costs nothing.

Set a calendar habit

  • Review the log on the same day as your card statement arrives.
  • Set a reminder for annual plans two weeks before renewal.
  • Keep an Unused column, and drop anything with two empty months in a row.

What if a plan has several tiers?

Record the tier name beside the service, because a price rise sometimes lands on one tier and leaves another untouched. If your plan went from $15.49 to $17.99 and the plan below it costs $11.99, the gap between tiers is now $6.00 instead of $3.50 a month, which is $72.00 a year. Whether the extra features are worth that gap is a better question than whether the hike is annoying, and it is one you can answer with your own usage notes.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports