Report this item to Etsy

Bill and Subscription Tracker Spreadsheet, Monthly Bill Calendar with Paydays, Excel & Google Sheets

NowPrice:$4.50

Original Price: $6.00

Loading

25% off

•

Sale ends on November 9

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by MeayStudio
  • Digital download
  • Digital file type(s): 2 Files

Every bill, subscription and payday in one place: see what is due, what is paid, and what you will have left on any day of the month. A bill and subscription tracker spreadsheet for Excel and Google Sheets, set to 2027 and reusable for any year.

Works in Excel 2016 and newer (Windows and Mac) and Google Sheets. Instant download, no macros, no app or subscription.

━━━━━━━━━━━━━━━━━━
WHY THIS ONE IS DIFFERENT
━━━━━━━━━━━━━━━━━━
We read the reviews of other bill trackers and fixed what buyers ran into:

✔ "I couldn't add income for paydays." Add your paychecks (weekly, every 2 weeks, twice a month...). They show on the calendar, and you see income minus bills for the month.
✔ "I wish it had a running balance." Type your balance on the 1st and every day of the calendar shows the balance at the end of that day, plus your lowest balance of the month.
✔ "My bills come every 28 or 30 days, not on a fixed date." 11 ways to repeat: weekly, every 2 or 4 weeks, every N days, monthly, twice a month, every 2, 3 or 6 months, yearly and one-time.
✔ "I had to uncheck every payment to change a bill." Payments live in their own log. Change a bill's amount or date any time; what you already paid stays as it was.
✔ "It only showed two weeks ahead." Pick any month of the year; every due date is worked out for you.
✔ "It wouldn't open in Excel." This is a real .xlsx, tested in Excel 2016+ and Google Sheets against a separate model. Both work.

━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE
━━━━━━━━━━━━━━━━━━
• DASHBOARD: due this month, paid so far, left to pay and overdue bills. Coming up next with autopay and days left. All bills per month, subscriptions per month and per year, subscriptions sorted by cost, free trials ending in the next 30 days, what cancelling would save you, cost by category with a chart, and logged payments by month.
• CALENDAR: pick a month. Paydays and bills sit on their dates, ✓ marks what is paid, past-due bills turn red, and each day shows the balance at the end of the day.
• BILLS: up to 100 bills and subscriptions. Name, type, category, amount, frequency, first due date, end date, autopay, pay from, status (Active, Cancel planned, Cancelled, Paused), trial end date and notes. Per month, per year, next due date, days left and a flag (Due today, Due soon, Overdue, Trial ends soon) fill in.
• PAYMENTS: log up to 600 payments. Autopay bills count as paid on their due date by themselves.
• SETUP: year, week start (Sunday or Monday), "due soon" window, 12 categories, pay-from accounts, up to 5 income sources and 4 color themes.

━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━
1. SETUP: the year and your paydays.
2. BILLS: one row per bill or subscription: amount, how often, first due date. Mark autopay ones "Yes".
3. When you pay a bill, add a row on PAYMENTS. The calendar and dashboard update by themselves.

Per month = what a bill costs in an average month (a weekly bill of 260 is about 1,130 a month).

━━━━━━━━━━━━━━━━━━
WHAT YOU GET
━━━━━━━━━━━━━━━━━━
• Bill_and_Subscription_Tracker_BLANK.xlsx: ready for your bills, set to 2027
• Bill_and_Subscription_Tracker_SAMPLE.xlsx: a family's January with 24 bills and subscriptions (fictional), so you can see how everything works. In the sample, today is fixed to Jan 20, 2027.
• Start page with a short guide inside the file

━━━━━━━━━━━━━━━━━━
GOOD TO KNOW
━━━━━━━━━━━━━━━━━━
• Google Sheets: upload the .xlsx file to Google Drive and open it with Google Sheets.
• Any year: change the year on SETUP and every page follows.
• Any currency: amounts are plain numbers.
• A due date on the 31st falls on the last day of shorter months.
• Every page you type on is unlocked. The dashboard and the start page are protected without a password, only so formulas are not deleted by accident.
• This is a digital file. Nothing will be shipped.
• Personal use. Please do not share or resell the file.

Questions? Send us a message on Etsy, we reply quickly.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 26, 2026