HiddenMost households have more recurring payments than they can name from memory. Rent, power, phone, insurance, a streaming service, a gym, a cloud plan, software that renewed last spring. The cost is not only the amounts. It is also the timing: some months hold three annual charges and others none. This guide shows how to put it all on one page, so that nothing surprises you.
Step 1: list everything once
Open your bank and card statements for the last three months and go through them line by line. Recurring payments appear again and again. For a yearly charge, look back twelve months, or check your email for renewal notices.
For each item write:
- Name and category, for example "Internet, home".
- Amount and how often it is charged: monthly, quarterly, half-yearly or yearly.
- Due day or renewal date.
- Autopay or by hand. This decides how much attention it needs.
- For subscriptions only: how often you use it. Be honest: never, rarely, sometimes or often.
Step 2: work out the real cost
A cost per month and per year makes different items comparable. Divide a yearly amount by 12 and a quarterly amount by 3, and multiply a monthly amount by 12 to see the year.
Here is a worked example with invented figures. Three monthly subscriptions cost EUR 9.99, EUR 14.00 and EUR 6.50. Together that is EUR 30.49 a month, or EUR 365.88 a year, if prices do not change. A fourth, a yearly plan of EUR 59.00, adds EUR 4.92 a month on average, bringing the monthly total to EUR 35.41 and the year to EUR 424.88. The numbers are small one by one. The year total is the number that makes people look again.
Step 3: see the year as a calendar
The monthly average hides the heavy months. Lay each charge in the month it is actually taken. Using the same invented household:
| Item | Amount | When charged |
|---|---|---|
| Rent (autopay) | EUR 800.00 | every month |
| Electricity | EUR 90.00 | every month |
| Internet | EUR 40.00 | every month |
| Three monthly subscriptions | EUR 30.49 | every month |
| Water | EUR 75.00 | January, April, July, October |
| Car insurance | EUR 480.00 | March and September |
| Yearly plan | EUR 59.00 | March |
The regular monthly total is 800 + 90 + 40 + 30.49 = EUR 960.49. May holds only that. April adds the water bill, which makes EUR 1,035.49. March adds the insurance and the yearly plan, which makes EUR 1,499.49. That is EUR 539.00 more than May. Seen only as an average of about EUR 1,000 a month, March would have been a surprise. Seen on a calendar, you know in January that March needs extra money, and you can put aside a little each month.
If a bill's due day does not exist in a month, for example the 31st in April, use the last day of the month. A good sheet does that for you.
Step 4: look 30 days ahead
Once a week, look at what is due in the next 30 days, earliest first, with the total. It takes a minute. It tells you how much money must be in the account, and which items you must pay by hand. A shorter window is fine if you are paid weekly. The point is to look at it on a schedule, not to wait until the bank reminds you.
Gollwitzer and Sheeran (2006) reviewed studies of "implementation intentions", plans of the form "when this happens, I will do that". They found that such plans helped people carry out their goals. The studies are not about bills, but the idea transfers well: write the rule in advance, for example "every Sunday I check the next 30 days", and do not rely on remembering.
Step 5: review what you rarely use
A subscription that you never or rarely use is a candidate for cancelling, and so is one that you use sometimes but that costs a lot. A tracker can flag them and show the yearly saving. For example, a gym membership at EUR 25.00 a month that you rarely use costs EUR 300.00 a year.
A flag is only a prompt. You decide. You may keep it for a reason that is not in the sheet, such as a free trial that is about to end or a service that your family uses. When you do cancel, check the contract: notice periods, minimum terms and refund rights differ by provider and by country. Do this before the renewal date, which is why the renewal date is in the list.
Autopay or by hand
Autopay is good for fixed, essential bills, because a missed payment may cost a fee or a service. It is risky for variable bills and for subscriptions that you may want to cancel, because the money leaves without a look. A common approach: autopay for rent, insurance and utilities, by hand or with an alert for anything else. Whatever you choose, keep a buffer in the account, and check the amounts on your statements, because prices change.
Keep the list true
A list is only useful while it is right. Update it when a price changes, when you add a service and when you cancel one. Check it against a statement every few months. Powell, Baker and Lawson (2008) reviewed research on spreadsheet errors and found that errors are common in spreadsheets in general. That is a reason to check your totals once, by hand, as in the example above.
When a price changes
Providers raise prices, and a list that is a year old is wrong. Once a quarter, compare each amount on your list with the last statement, and change the ones that moved. It is also a good time to ask whether a better offer exists, since a loyal customer can often pay more than a new one. Do this for the largest bills first, because a small change on a big bill is worth more than a large change on a small one.
Free trials
A free trial that converts into a paid plan is a common way for a subscription to slip in. When you start one, write the end date in the list as a subscription, with the cost it will have, and mark it as a cancel candidate until you decide. Check the terms: some trials need cancelling a day or more before the end. A line in the list is cheaper than a year of an unused plan.
Tool that fits
The Bill & Subscription Tracker (Excel, EUR 8, paid once) has a Bills table for up to 30 bills with amount, frequency (monthly, quarterly, half-yearly or yearly), due day and autopay yes or no, and a Subscriptions list for up to 25 items with renewal date and how often you use them. It works out the cost per month and per year, lays out the next 12 months in a calendar split into autopay and pay-by-hand, and lists everything due in the next 30 days, or a window you set, with the total to have ready. Subscriptions marked never or rarely used get a Cancel candidate flag, and the dashboard shows monthly and annual totals, spending by category and charts. Example data is included. It works in Excel 2016 and later, Google Sheets and LibreOffice, with no macros. It is a planning tool, not financial advice, and it does not pay or cancel anything. Check its amounts and dates against your own statements.
What to do next
The Bill & Subscription Tracker keeps up to 30 bills and 25 subscriptions, shows a 12-month calendar and the next 30 days, and flags subscriptions you rarely use. Excel file, €8 once; it also works in Google Sheets and LibreOffice.
Questions people ask
How do I turn a yearly or quarterly bill into a monthly cost?
Divide the amount by the number of months it covers. A yearly subscription of EUR 59.00 is about EUR 4.92 a month, and a quarterly bill of EUR 75.00 is EUR 25.00 a month. For cash planning, though, note the month in which it is actually charged, because that is when you need the money.
Does a tracker cancel subscriptions for me?
No. It lists them, shows the renewal date and the yearly cost, and can flag the ones you rarely use. You still have to cancel with the provider, and the notice period and your rights depend on the contract and on the law of your country.
What is the best way to avoid missing a due date?
Put every bill in one list with its due day, see the next 30 days each week, and use autopay for fixed bills where you can afford it. Keep a buffer in the account, because an autopay that fails can cost a fee. Check amounts on your statements, since prices change.
Sources
- Gollwitzer and Sheeran (2006), Implementation intentions and goal achievement: a meta-analysis of effects and processes, Advances in Experimental Social Psychology 38, 69-119
- Powell, Baker and Lawson (2008), A critical review of the literature on spreadsheet errors, Decision Support Systems 46(1), 128-138
- HiddenWay worked example: our own arithmetic, assumptions listed in the text
We checked each source on 17 October 2026. If a fact here is out of date, tell us at hello@hiddenway.info.