Bills Tracker: Free Template and How to Set Reminders
A bills tracker is a list of every bill you pay, with its due date, usual amount and whether you have paid it this month. Use a free template in a notebook or spreadsheet, then add phone reminders a few days before each due date. An app helps once you have many bills, cards and loans to watch.
Key takeaways
- List every bill once: biller, due day, usual amount, how you pay and whether it is on autopay.
- Set two reminders per bill, one about 5 days before and one on the due date.
- Meralco asks customers to settle overdue bills within 48 hours of a disconnection notice.
- Track autopay bills too, so a wrong charge doesn't slip past you.
- An app saves time when your bills, card statements and loans fall on different days.
What bills should you track?
Track every payment that repeats, even the small ones. A missed ₱199 subscription won't hurt much, but missed rent or a late card payment will. Start by going through last month's GCash, Maya and bank history and listing everything that came back.
Most Filipino households have bills in these groups:
- Utilities: Meralco or your local electric cooperative, water (Maynilad, Manila Water or your water district), LPG.
- Internet and phone: home fiber, postpaid plans, prepaid loads you buy on a schedule.
- Housing: rent, association dues, amortization.
- Cards: each credit card's statement balance.
- Subscriptions: streaming, music, cloud storage, apps.
- Loans: SSS, Pag-IBIG, bank or app loans, installment plans, and personal utang.
- Family: padala, tuition, a sibling's allowance.
If subscriptions are the messy part, our subscription tracker guide shows how to find every one of them.
A free bills tracker template you can copy
Use one row per bill and one column per month. Fill in the first five columns once. Each month, tick the box or write the date you paid.
| Bill | Biller | Due day | Usual amount | How you pay | Autopay? | Nov | Dec |
|---|---|---|---|---|---|---|---|
| Electricity | Meralco | 12th | ₱3,200 | GCash | No | ||
| Water | Maynilad | 20th | ₱450 | Bank app | No | ||
| Internet | Fiber provider | 5th | ₱1,699 | Credit card | Yes | ||
| Rent | Landlord | 1st | ₱12,000 | Bank transfer | No | ||
| Credit card | BPI | 23rd | Statement balance | Bank app | No | ||
| Streaming | Your streaming app | 8th | ₱549 | Credit card | Yes | ||
| Loan | Pag-IBIG | 15th | ₱1,500 | Payroll deduction | Yes |
The amounts above are examples. Use the numbers on your own bills.
Add two cells at the bottom: the total of all bills, and the total still unpaid this month. The unpaid total is the number to check on payday.
How to set it up in Google Sheets or Excel
- Copy the column headings into row 1.
- Add one row per bill, sorted by due day so the next bill is always near the top.
- Use a checkbox in each month column, or type the date you paid.
- At the bottom, add a SUM of the usual amounts and a second SUM for the rows not yet ticked.
- Pin the sheet to your phone's home screen so it is one tap away.
Keep account numbers and passwords off this sheet. The tracker only needs to tell you what is due and when.
How do you set due-date reminders on your phone?
Set a repeating reminder for each bill, timed a few days before the due date. Both iPhone and Android can repeat a reminder every month for free, so you only set it up once.
On iPhone
Apple's Reminders guide covers the steps. In the Calendar app, tap the plus button, choose Reminder, enter the bill name, set the date, and pick a Repeat option. Your scheduled reminders then show up in the Calendar app next to your events.
If you set a due date without a time, the alert appears at 9:00 AM by default. In iOS 26.2 you can mark a reminder as Urgent, and Reminders sounds an alarm when it is due, even when your phone is on silent.
On Android
In Google Calendar, tap Create, then Event, and add the bill name. Under the time, tap "Does not repeat" and choose Monthly. Google's help page notes a limit of 730 occurrences per repeating event, which is more than 60 years of monthly bills.
When to set them
Set the first reminder about 5 days before the due date. That gives you time to wait for payday or move money from savings. Set the second on the due date itself. If you get paid on the 15th and 30th, line the reminders up with your sahod. Our kinsenas katapusan budget guide shows how to split bills across two paydays.
What happens if you pay Meralco late?
Late electric bills can lead to a disconnection notice, and Meralco says to settle all overdue bills within 48 hours of receiving one. Paying on time also matters for your bill deposit.
Meralco's Regulatory FAQs cover a current ERC moratorium. In an October 13, 2026 advisory, the ERC extended the suspension of disconnection for residential customers using 200 kWh or less in November or December 2026. That applies only if they settle unpaid May to July 2026 bills by November 26, 2026. Customers above 200 kWh get extended deadlines instead: November 26, 2026 for unpaid May to July bills and December 26, 2026 for August to October bills. They must pay current bills by their due dates.
Meralco also offers an early refund of the bill deposit to residential customers who paid on or before the due date for the past 2 years. A bills tracker is a simple way to keep that record clean. Put these dates on your tracker now if they apply to you.
How do you keep a bills tracker up to date?
Give it five minutes on each payday. A bills tracker only works if the "paid" column matches what left your account, so check it against your GCash, Maya or bank history while the payments are fresh.
A payday routine:
- Open the tracker and look at every bill due before your next payday.
- Set aside the money for those bills first, before any spending.
- Pay what you can now, and tick each one off with the date.
- Compare autopay charges with the usual amount. A jump in a fixed bill is worth a call to the biller.
- Add any new bill the day you sign up for it, and delete the ones you cancelled.
Once a year, go through the whole list. Prices change, plans renew and promos end, and the yearly check is when you catch them.
Is a bills tracker template or an app better?
A template is enough when you have fewer than about ten bills and you check it every week. An app is better when your bills, card statements and loans land on different days, because it reminds you without you opening a sheet.
| Template | App | |
|---|---|---|
| Cost | Free | Often free to start |
| Setup | You build the columns | Ready-made bill fields |
| Reminders | Separate phone reminders | Built in |
| Paid status | You tick it off | Marks paid or records the payment |
| Works offline on paper | Yes | No |
| Shows money left after bills | Only if you add a formula | Usually built in |
Credit cards need extra care because the due date and the statement date differ. Our guide to credit card due dates explains the gap and how to avoid interest.
How LAYA tracks bills and due dates
LAYA lets you schedule recurring bills next to your cash, e-wallets, bank accounts and cards. The Calendar puts every due date in one place: subscriptions, bills, loans, card statements and money you owe, with what is left to pay this month.
Recurring bills can record themselves on their due date, or you can turn that off for any bill and record it yourself. Budgets and goals show what is left after planned spending, so you see the gap before payday instead of after. LAYA runs on iPhone, iPad, Mac and Apple Watch. It doesn't connect to Meralco, your bank or GCash, so you still pay each bill through your usual channel.
Frequently asked questions
What should a bills tracker include?
List each bill with the biller, the due day, the usual amount, how you pay and whether it is on autopay. Add a column for each month so you can tick it off when paid. Keep account numbers in a safe place, separate from the sheet.
What is the best free bill tracker app?
It depends on your phone. Apple Reminders and Google Calendar are free and can repeat a reminder every month. LAYA is free to download on iPhone, iPad and Mac and puts every due date on one Calendar. A spreadsheet also works if you check it weekly.
How do I set a monthly bill reminder on my iPhone?
In the Calendar app, tap the plus button, choose Reminder, set the date and pick a Repeat option. In the Reminders app, tap the Info button to set the due date. If you set a date without a time, the alert appears at 9:00 AM by default.
How many days before the due date should I get a reminder?
Set two reminders: one about 5 days before and one on the due date. The early one gives you time to move money from savings or wait for payday.
What happens if I miss my Meralco due date?
Meralco says to settle all overdue bills within 48 hours of receiving a disconnection notice to avoid disconnection. Late bills can also cost you an early refund of your bill deposit, which Meralco ties to two years of on-time payments.
Should I put all my bills on autopay?
Autopay works well for fixed bills like internet, loans and subscriptions. It is riskier for bills that change each month, like electricity, if your account balance runs low. Keep autopay bills on your tracker anyway so you can check the charge.
Can LAYA remind me about bills?
Yes. You can schedule recurring bills in LAYA, and the Calendar shows every due date with what is left to pay this month. Recurring bills can record themselves on their due date, or you can turn that off for any bill.
Sources
- Meralco, Regulatory FAQs (ERC moratorium and disconnection notices)
- Apple Support, Use Reminders on your iPhone, iPad, or iPod touch
- Google Calendar Help, Create a recurring event
- App Store (Philippines), LAYA Finance
Last checked