Help
Set up the Bills & Renewals Tracker
Part of Weeksheet by Metricvalley, our line of household spreadsheets. See the product page.
This guide covers version 1.1.0, the version you download today. Estimate: setup takes about 5 minutes, plus about 1 minute per bill. After that, the weekly check takes about 2 minutes.
Before you start
- You need Excel 365 on a desktop or laptop computer. Excel 365 for Windows is where this version was tested. Other apps are listed on the compatibility page.
- Have a list of your bills, subscriptions and renewals: the name, the amount, how often each one repeats and one due date for each. A recent bank or card statement helps.
- Sheet names and column labels below are quoted exactly as they appear in the version 1.1.0 file.
Yellow cells: you type. Leave every other cell to the workbook.
1. Download the ZIP file
About 2 minutes.
- After payment, Payhip shows a download link on the confirmation page and sends the same link by email.
- Click the link and save the ZIP file (about 359 KB) somewhere you will find it again, such as a "Weeksheet" folder in Documents.
Can't find the email? Search your inbox and spam folder for "Payhip". If it isn't there, email [email protected] with the address you used at checkout and we'll resend the link.
2. Unzip it
About 1 minute.
Excel can open a file from inside a ZIP, but it opens a temporary read-only copy, and your changes may be lost. Extract the files first.
- Windows: right-click the ZIP file, choose Extract All, then Extract.
- Mac: double-click the ZIP file. The files appear in a new folder beside it.
You now have ten files:
| File | What it is |
|---|---|
bills-renewals-tracker-v1.1.0-blank.xlsx |
The workbook for your own bills |
bills-renewals-tracker-v1.1.0-worked-example.xlsx |
The same workbook with a sample household's bills |
START-HERE.html |
Which file to open first, and every file with its checksum |
quick-start.md |
Setup, the weekly check and reading the Dashboard |
metric-dictionary.md |
Every column and calculation defined |
support-and-compatibility.md |
Where it's tested, and how to get help |
license.md |
The personal-use license |
release-notes-v1.1.0.md |
What is in this version |
money-back-guarantee.md |
The 30-day money-back guarantee |
MANIFEST-bills-renewals-tracker-v1.1.0.sha256 |
SHA-256 checksums, so you can check every file arrived intact |
START-HERE.html opens in any browser. The .md files open in any text editor, such as Notepad or TextEdit.
3. Open the worked example, then save your own copy of the blank file
About 2 minutes.
- Open
bills-renewals-tracker-v1.1.0-worked-example.xlsxto see a filled-in Dashboard for a sample household. Every bill in it is fictional, and the status readsSAMPLEuntil the sample rows are cleared. - Open
bills-renewals-tracker-v1.1.0-blank.xlsx. Excel may show a yellow Protected View bar that says the file came from the internet. This is normal for any downloaded file. Click Enable Editing. The file has no macros, so you will not see a macro or content warning. - Choose File > Save As and save a copy with your own name in the file name. Keep the format as Excel Workbook (.xlsx).
- Keep the original download untouched in its folder. It is your clean copy if you ever need to start again.
The workbook has seven sheets: Start Here, Setup, Dashboard, Bills, Lists, Guide and Changelog. It opens on Start Here, which has nothing to type: its Do this next line says where to go. The Guide sheet explains every column, calculation and check, so you can work without this page.
Every sheet is protected without a password, so a formula can't be overwritten by accident. You never need to unprotect a sheet to enter data. If you want to change the workbook itself: Review > Unprotect Sheet.
4. Check your settings on Setup
About 1 minute.
On Setup, the six settings sit in one column. Each has a working default, so you can leave them as they are and check only the name and the currency:
| Setting | What to enter |
|---|---|
Name for this tracker |
Shown in the Dashboard title, 1 to 40 characters |
Currency |
The one currency for every amount. Nothing is converted |
Warn me this many days ahead |
1 to 60, default 7. Sets Due soon, Autopay soon and the window when there is no payday |
Next payday |
Optional. Any one payday, past or future |
Payday repeats |
Weekly, Every 2 weeks or Monthly |
Theme |
Light or Dark, for Start Here and the Dashboard only |
Optional: type your next payday and how often you're paid. The Dashboard then totals To pay by: every payment due up to the day before your next payday, overdue ones included. Without a payday, To pay by covers the next 7 days; change Warn me this many days ahead to use a different number.
Setup ends with a Setup complete line: Yes when every setting is valid (Next payday may stay blank), or the first setting to fix. Start Here's Do this next line follows it. It never changes the status in row 3.
5. Add your bills on the Bills sheet
About 1 minute per row.
- One row per bill, subscription or renewal. Four columns are needed: Bill, Amount, How often and Due date.
- How often is a list: Weekly, Every 2 weeks, Monthly, Every 3 months, Every 6 months, Yearly, Every 2 years or Once. A bill paid twice a month needs two rows, one for each date.
- Due date can be any one due date of the series, past or future. Type it with the month as a word, for example
4 Mar 2026, which Excel reads the same way on US, UK and Australian settings. - Optional columns: Paid on (the date you last paid it), Autopay (Yes if it is paid automatically), Category, Plan (Keep, Review, Cancel or Ended) and Notes.
The tracker works out Next due, Days left and a Status in words: Overdue, Due today, Due soon, Autopay soon or Upcoming.
6. Set a weekly reminder, then read the Dashboard
About 2 minutes.
A workbook can't remind you, and its dates move only when it recalculates. Set a repeating reminder in your phone's calendar, for example every Sunday evening, that says: open the bills file.
Then open the Dashboard:
- Check the status in row 3.
OKmeans every check passes.CHECK (n)names how many fail; the Checks block says what to do. A row with a problem is marked Check row and left out of the totals until it's fixed. - Read Do this next: one line with the single most useful next step.
- Read Needs attention: what is overdue, what to pay and what autopays in the next few days, renewals and one-off dates in the next 30 days, and rows marked Cancel or Review.
7. The weekly check
About 2 minutes.
- Open the file. Dates and statuses update when it opens.
- On the Bills sheet, type the date you paid each bill in Paid on. Ctrl+; types today's date.
- Open the Dashboard and read Do this next and Needs attention.
Skipped a week? Nothing resets. An unpaid bill stays Overdue, with its oldest unpaid due date, until you type the date you paid it. Autopay rows move on by themselves.
Paying late or early. A payment counts for the latest due date on or before the day you paid, plus a short window (10 days for a monthly bill). After you type Paid on, check Counted for next to it. If it shows the wrong due date, type the due date the payment was for instead.
8. Clearing the worked example
Only if you want to reuse that file:
- Save a copy of the worked example under a new name first.
- Click the Name Box, the box left of the formula bar that shows the cell address.
- Choose
MV_Clear_Billsand press Delete. Your settings on Setup stay as they are. - Check row 3: the status changes from SAMPLE to OK.
Today stays at 19 Oct 2026 in the worked example. To follow your computer clock instead, unprotect the Lists sheet, type =TODAY() in the cell next to Today and protect the sheet again.
If you use version 1.0.0: where Setup went
Version 1.1.0 is a free update, delivered through Payhip. The settings that were on Start Here are now on the Setup sheet, with the same names, so every formula works as before and your rows paste straight in.
| Setting | Was | Now |
|---|---|---|
Name for this tracker |
Start Here B6 | Setup B7 |
Currency |
Start Here B18 | Setup B8 |
Warn me this many days ahead |
Start Here B19 | Setup B10 |
Next payday |
Start Here B20 | Setup B11 |
Payday repeats |
Start Here B21 | Setup B12 |
Theme |
Start Here B22 | Setup B13 |
To move your list into the 1.1.0 file:
- Open your 1.0.0 file and the 1.1.0 file.
- If you changed the categories: on the Lists sheet of the 1.0.0 file, type
G6:G25in the Name Box and press Ctrl+C; on the Lists sheet of the 1.1.0 file, typeG6:G25in the Name Box, then choose Home > Paste > Paste Values. - In the 1.0.0 file, choose
MV_Clear_Billsin the Name Box and press Ctrl+C. - In the 1.1.0 file, choose
MV_Clear_Billsin the Name Box, then choose Home > Paste > Paste Values. - On Setup, type the name for this tracker and any setting you had changed, such as the currency or your payday.
Getting help
Email [email protected]. Support replies within 1 business day (Monday to Friday, Australian Eastern time). Include the version (1.1.0, on Start Here), your Excel version, the sheet and row, and what you saw. Send made-up or redacted details only, never account numbers.
The Google Sheets edition is free for every buyer when it ships, delivered through your Payhip download link. Don't import the .xlsx files into Google Sheets.