TL;DR:
List every bill once with its due date and amount, then let a calendar remind you a few days early.
Autopay helps, but it needs a balance check and a glance at each amount, because it pays whatever the bill says.
At work, get approval before paying, so the person who pays is not the only person who checked.
Missed bills rarely come from not having the money. They come from a due date you forgot, an email that went unread, or a bill that arrives on an odd schedule. A one-time setup of a bill calendar removes most of that luck.
When to set this up
Do it now if you have ever paid a late fee, if bills arrive in different places, or if you manage payments for a household, a small business or a team. The setup takes an hour. After that, upkeep is a few minutes a month.
Collect every bill in one list
Go through your last two or three months of bank and card statements and your email, and write down every recurring payment. For each, record these fields:
What it is and who it is paid to.
The due date each month (not the date it is sent to you).
The usual amount, and whether it is fixed or varies.
How you pay it: by hand, by transfer or by autopay.
Where the bill arrives: an email address, a paper letter or an account page.
Annual and quarterly bills are the ones people forget, such as insurance or a yearly subscription. Add them to the list too, with the month they fall in.
Turn the list into a calendar
Create a repeating event for each bill: In whatever calendar you use, make an event on the due date and set it to repeat monthly (or yearly for annual ones). Put the name and expected amount in the title.
Add a reminder before the due date: Set a notification about five days before. That gives you time to check the amount, make sure the money is there, and pay without rushing.
Pay on the reminder day, not the due date: Bank transfers and card payments can take a day or more to land. Paying a few days early removes the risk that a processing delay makes you late.
Mark it as done: Tick the event off, or add a note with the date paid. A bill with no record of payment is a bill you will wonder about later.
Worked example: a bill calendar
Say you have five monthly bills, with due dates and amounts invented for the example. In a spreadsheet, column A is the bill, B the due day of the month, C the amount, D the reminder day and E the payment status.
Bill | Due day | Amount | Remind on day | Paid? |
|---|---|---|---|---|
Electricity | 12 | 64.00 | 7 | |
Internet | 18 | 45.00 | 13 | |
Phone | 22 | 30.00 | 17 | |
Card payment | 25 | 120.00 | 20 | |
Insurance | 28 | 55.00 | 23 |
The reminder day is the due day minus five, and column D uses =B2-5. Check each one: 12 − 5 = 7, 18 − 5 = 13, 22 − 5 = 17, 25 − 5 = 20 and 28 − 5 = 23. The monthly total is =SUM(C2:C6), which is 64 + 45 + 30 + 120 + 55 = 314.
That total is the number to compare against your balance. If you know 314 leaves the account over the month, you can see before the 7th whether the money is going to be there. If the due dates are real calendar dates in your sheet, use =B2-5 with a date in B2 and format column D as a date. A bill due on the 3rd would otherwise produce a reminder day of −2, which does not mean anything; in that case use dates, which roll back into the previous month correctly.
To spot anything unpaid, use a formula such as =IF(E2="","to pay","done") in a status column and filter for to pay at the start of each week.
A caution about autopay
Autopay is good for fixed, reliable bills, and it prevents forgetting. But it pays whatever amount arrives, whether or not it is right. It also fails if the account does not have enough money, and some providers charge a fee when that happens. A few habits make it safe:
Keep the calendar reminder even for autopay bills, and glance at the amount before it leaves.
Check the balance a few days before the larger autopay dates.
Review the list of autopays every few months and cancel those you no longer use.
When a card is replaced or expires, update it, since a payment may fail without anyone noticing.
Approvals before paying, especially at work
If you pay bills for a business or team, a second person should confirm a bill before money moves: that the work or goods were received, the amount is right, and the account details match those on file. Scam invoices often use an urgent tone and new bank details. If details change, confirm them using a phone number you already had, not one printed on the new message. See vendor payment approvals for a simple two-step process.
Mistakes to avoid
Relying on memory for any bill. Memory is the failure point.
Setting the reminder for the due date itself, when it is too late to act.
Paying from a bill link in an unexpected email. Go to the provider's own site or app instead.
Forgetting the yearly bills that sit on a different schedule.
Letting overdue items pile up. Pay the oldest first, or contact the provider if you cannot.
Doing it faster
Set the whole year in one session, because repeating events do the work. DuckyHelper can talk you through a calendar setup while you do it, but it's built not to enter card numbers or passwords for you, and anything that sends money stays your call.
Frequently asked questions
What if I cannot pay a bill on time?
Contact the provider before the due date, explain, and ask what options exist. Many providers prefer to hear early. If it is a serious money problem, a qualified adviser can help with your specific situation.
Should every bill be on autopay?
Not necessarily. Fixed bills suit it well. Bills that vary a lot, or that you want to check, are often better paid by hand on the reminder day.
Get started
