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.

  1. After payment, Payhip shows a download link on the confirmation page and sends the same link by email.
  2. 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.

  1. Open bills-renewals-tracker-v1.1.0-worked-example.xlsx to see a filled-in Dashboard for a sample household. Every bill in it is fictional, and the status reads SAMPLE until the sample rows are cleared.
  2. 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.
  3. Choose File > Save As and save a copy with your own name in the file name. Keep the format as Excel Workbook (.xlsx).
  4. 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.

  1. One row per bill, subscription or renewal. Four columns are needed: Bill, Amount, How often and Due date.
  2. 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.
  3. 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.
  4. 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:

  1. Check the status in row 3. OK means 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.
  2. Read Do this next: one line with the single most useful next step.
  3. 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.

  1. Open the file. Dates and statuses update when it opens.
  2. On the Bills sheet, type the date you paid each bill in Paid on. Ctrl+; types today's date.
  3. 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:

  1. Save a copy of the worked example under a new name first.
  2. Click the Name Box, the box left of the formula bar that shows the cell address.
  3. Choose MV_Clear_Bills and press Delete. Your settings on Setup stay as they are.
  4. 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:

  1. Open your 1.0.0 file and the 1.1.0 file.
  2. If you changed the categories: on the Lists sheet of the 1.0.0 file, type G6:G25 in the Name Box and press Ctrl+C; on the Lists sheet of the 1.1.0 file, type G6:G25 in the Name Box, then choose Home > Paste > Paste Values.
  3. In the 1.0.0 file, choose MV_Clear_Bills in the Name Box and press Ctrl+C.
  4. In the 1.1.0 file, choose MV_Clear_Bills in the Name Box, then choose Home > Paste > Paste Values.
  5. 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.