This is a different job from tracking digital subscriptions. Streaming, software, and cloud storage are recurring services; rent and utilities are household bills. You can keep both lists. Mixing them in one sheet usually makes both harder to read.
List every bill once
Start with a year of statements or your online accounts, not only the bills that arrived this week. Typical rows include rent or a mortgage payment; electricity, gas, water, and heating; home or contents insurance, and health or vehicle insurance if you pay a premium; phone and internet, if you treat them as household utilities rather than as app-like subscriptions; council or municipal charges, licence fees, or condominium fees where they apply; and any other regular household payment with a due date you would regret missing.
For each bill, write the payee, the amount, the frequency, and how you know the due date. For a monthly bill, the due day (the 1st, the 15th, the last day of the month) is often enough. For weekly, quarterly, or yearly bills, you also need an anchor date — a recent due date you can count from.
Do not store full account numbers, passwords, or PINs. A payee name and, if you need a reminder, the last four digits are enough.
Give every amount a monthly and yearly equivalent
A yearly insurance premium and a monthly electricity bill are easier to compare when both have a monthly equivalent and a yearly equivalent:
- Weekly × 52 for a year, or × 52 ÷ 12 for a month
- Monthly is already monthly; × 12 for a year
- Quarterly × 4 for a year, or ÷ 3 for a month
- Yearly is already yearly; ÷ 12 for a month
These are comparison figures, not a prediction of your bank balance. Amounts change; confirm them with the provider when a reminder fires.
Use a month calendar, not only a list
A list sorted by next due date is useful. A month calendar is better for the question “what lands this month?” Put the calendar on a Monday-start or Sunday-start grid, whichever you already use, and show the amount due on each day. If two bills share a day, both should appear.
When you choose the month you are looking at — or leave it as the current month — you can see whether the first week is unusually heavy, or whether a yearly premium is about to sit next to the rent. That is the usual reason people miss a payment: two large items in the same week, one of them infrequent enough to forget.
Record what you paid
A due date without a last-paid date will haunt you. After you pay, write the date and, if you want a history, a line in a payment log: payee, amount, date, and method. If a monthly bill’s last-paid date is older than the last full period, treat it as overdue until you check. The calendar should not mark a bill paid only because the due day has passed.
If a provider lets you change the due day, note the new day and the first month it applies. If you pay in advance, the last-paid date still matters so the next period does not look overdue.
Build a simple weekly habit
Once a week, open the calendar and the overdue list. Pay or schedule what is due in the next few days, and update last-paid when the payment has actually gone. A short alert window — seven days is a reasonable default — is usually enough for household bills, because you already know the payees and the amounts.
This habit is ordinary administration. It is not financial advice, and a calendar does not connect to your bank or send a payment for you. Confirm amounts and dates with each provider, especially after a move or a tariff change.
Year ahead, lightly
A year-ahead view that places yearly and quarterly bills in the months they fall due helps with the awkward months — often the month a yearly insurance premium lands. It is an estimate, not a cash-flow plan. If your income varies, you still decide separately how to set money aside.
Household bills and digital subscriptions complement each other. The calendar is for rent, utilities, and premiums; a subscription renewal list is for recurring digital services. Keep them next to each other, not mixed into one undifferentiated sheet.
A workbook if you want the dates calculated
The Wellkept Household Bills Calendar is an Excel & Google Sheets workbook for this job: a bill list, a Monday-start month calendar, a payment log, and a year-ahead sheet, with monthly and yearly equivalents and an overdue flag when last-paid is missing or too old. English is the main edition; German is included in the same download, along with the .xlsx files and one-click “Make a copy” Google Sheets links. It is an organizational template, not a paycheck budget and not a substitute for the Subscription & Renewal Tracker. It does not connect to your bank or make a payment.
View the Household Bills Calendar