Weeksheet by Metricvalley Spreadsheets for household money and admin, built for a short weekly check.

Weeksheet by Metricvalley · Excel 365

What needs paying before payday?

For anyone who pays a household's bills and wants one list to check once a week, at a computer.

Every bill, subscription and renewal in one list. Type each one once; the tracker works out the next due date, flags what is overdue or due soon, and adds up what to pay by your next payday.

bills-renewals-tracker-v1.1.0-worked-example.xlsx Demo data
Dashboard of the Bills & Renewals Tracker with sample bills: Do this next, today and the next payday with a note to set the payday on Setup, the To pay by total, Needs attention and the next payments with their due dates and statuses.
  • Yellow cells: you type. Leave every other cell to the workbook.
Open full-size image of the Dashboard sheet

01How it works

Built for a short weekly check

  • One place to start. Start Here says what to do next. The settings on Setup already have working defaults.
  • Four columns to fill for each bill. Bill, Amount, How often and Due date. In a weekly check you type one date for each bill you paid; autopay rows need nothing.
  • Do this next. One line on the Dashboard with the single most useful next step.
  • Needs attention. What is overdue, what to pay and what autopays in the next 7 days, renewals in the next 30 days, and what you marked to cancel.
  • Statuses in words. Overdue, Due soon, Autopay soon: never color alone.
  • Skipped a week? Nothing resets. An unpaid bill stays Overdue until you mark it paid.

02What it answers

Three questions, answered each time you open it

  1. What do I need to pay before payday?

    To pay by: every payment due up to the day before your next payday, overdue ones included. Without a payday, the next 7 days; you can change the number of days.

  2. When is each bill next due?

    You type any one due date and how often the bill repeats. The tracker works out the next due date and the days left, and keeps month ends right (31 Jan, 28 Feb, 31 Mar).

  3. What do my bills cost a month and a year?

    Per month and per year for every bill and every category, and the saving per month if the bills you marked Cancel end.

03What's inside

Seven sheets, one job

bills-renewals-tracker-v1.1.0-worked-example.xlsx Demo data
Bills sheet with sample rows: each bill's amount, how often it repeats, due date, paid-on date, next due date, days left and a status in words.

Bills. One row per bill, subscription or renewal. Four columns to fill: Bill, Amount, How often and Due date.

Demo data

Dashboard

Do this next, the To pay by total, Needs attention, the next 8 payments, the checks and the cost by category.

Needs attention counts what is overdue, what to pay and what autopays in the next 7 days, renewals in the next 30 days, and the rows marked Cancel or Review.

Demo data

Bills

One row per bill, subscription or renewal. Four columns to fill: Bill, Amount, How often and Due date.

Paid on, Autopay, Category, Plan and Notes are optional.

Up to 200 bills.

Demo data

Start Here

What to do next, three setup steps and a map of the sheets. Nothing to type here.

Its Do this next line says Setup until every setting is valid, then the Dashboard.

Demo data

Setup

Six settings with working defaults: name, currency, warning days, payday, how often you're paid and theme. It ends with a Setup complete line. Payday is optional; with it, To pay by runs to the day before your next payday.

Change a setting at any time: the Bills sheet and the Dashboard use it straight away.

Clearing the sample rows leaves these settings as they are.

Demo data

Guide

Every column, calculation and check explained, including what to do when you pay late or early.

Read it in the workbook or print it.

  • Lists: The dropdown values. You can change the categories.
  • Changelog: What changed in each version.

Exactly what's in the download

One ZIP file (about 359 KB), delivered by Payhip straight after payment.

FileWhat it isSize
xlsxbills-renewals-tracker-v1.1.0-blank.xlsx The workbook for your own bills 194 KB
xlsxbills-renewals-tracker-v1.1.0-worked-example.xlsx The same workbook with a sample household's bills 199 KB
htmlSTART-HERE.html Which file to open first, and every file with its checksum 9 KB
mdquick-start.md Setup, the weekly check and reading the Dashboard 6 KB
mdmetric-dictionary.md Every column and calculation defined 9 KB
mdsupport-and-compatibility.md Where it's tested, and how to get help 4 KB
mdlicense.md The personal-use license 2 KB
mdrelease-notes-v1.1.0.md What is in this version 4 KB
mdmoney-back-guarantee.md The 30-day money-back guarantee 1 KB
txtMANIFEST-bills-renewals-tracker-v1.1.0.sha256 Checksums to verify your download 1 KB

04Setup

Ready in about 5 minutes, plus about 1 minute per bill (estimate)

  1. On Setup, check the name and the currency: you can also add your next payday, and the Dashboard then totals what to pay before it.

    About 1 minute.
  2. Add each bill, subscription and renewal on the Bills sheet: its name, amount, how often and one due date.

    About 1 minute per row.
  3. Set a weekly reminder in your phone's calendar to open this file: then type the dates you paid and read the Dashboard.

    About 2 minutes.

The weekly check

  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.

Estimate: about 2 minutes in all. Autopay rows move on by themselves.

Read the setup guide

05Worked example

A sample household's bills

Fictional example

The worked example holds 16 fictional bills, subscriptions and renewals: rent, utilities, insurance, a dog walker paid weekly, two streaming services, a gym membership and more. Together they cost US$2,679.68 a month, or US$32,156.16 a year. Two rows are marked Cancel, the gym and the second streaming service; ending them would save US$50.99 a month. The sample bills are dated from Oct 19, 2026 and the worked example's Today is fixed at that date, so its Dashboard reads the same on any day. The blank file follows your computer clock.

Per month by category (fictional sample household)
HousingUS$1,650.00
Loans & credit cardsUS$330.50
Other (dog walker, domain name)US$261.00
UtilitiesUS$143.98
Phone & internetUS$115.00
InsuranceUS$95.05
MembershipsUS$39.00
Subscriptions & appsUS$27.48
Car & transportUS$17.67
Bills per monthUS$2,679.68

The household and its bills are fictional. These are the figures in the worked-example workbook, not a customer result.

06Fit

Is it right for you?

Good fit

  • Anyone who pays a household's bills, subscriptions and renewals
  • People who want one list to check once a week, at a computer
  • Households with autopay bills and bills paid by hand, weekly to every 2 years
  • Anyone who wants the totals in a file they can check line by line

Not for

  • You want bills paid for you, or reminders sent to your phone. This file can't send reminders or move money.
  • You want payments imported from your bank. Nothing here connects to a bank or an app.
  • You need a full budget with income, spending and savings goals.
  • You pay bills in more than one currency and want one total. Each file holds one currency.
  • You want to add bills on a phone. Use a computer; phone apps are for viewing only.

Known limitations

  1. It remembers the last payment of each bill only. If you pay two periods at once, see Paying late or early in the Guide.
  2. A bill paid twice a month needs two rows, one for each date.
  3. Dates and statuses move when the file recalculates. Open the file to see today's list.
  4. Tested in Excel 365 for Windows desktop. Excel for Mac, Excel for the web and the Google Sheets edition are not yet tested.
  5. Capacity is 200 bills. The Guide shows how to add rows.

07Tested on

Where it has been tested

Weeksheet workbooks go through the same written checks as every Metricvalley template, and the compatibility page lists the results. "Not yet tested" means exactly that: it may work, but we haven't confirmed it.

Latest test run

38/39 checks passed, 1 not yet run
Excel 365, Windows desktop
  • Workbook version1.1.0
  • Last testedNov 3, 2026
  • Excel 365, Mac desktopNot yet tested
  • Excel for the webNot yet tested
  • Google Sheets (native edition)Not yet tested
  • Excel mobile (iOS, Android)Not supported

What the checks cover

  • The worked example, and 18 hand-worked bills (month ends, a leap day, weekly, every 2 weeks, autopay, one-off and ended), checked against an independent calculation
  • Paydays weekly, every 2 weeks and monthly, with the To pay by total counting every missed payment
  • Every kind of bad row, pasted settings, an empty file, clearing the sample rows and the dark theme
  • 200 bills, the Guide's steps to add rows, 5,000 rows, and print on Letter and A4
  • 5,444 values checked against an independent calculation in Excel 365 for Windows, 0 mismatches
  • The 1.0.0 worked example's rows, categories and settings entered into the 1.1.0 blank file gave the same figures: 302 values compared, 0 mismatches
Environment Status Checks Version and build Last tested Notes
Excel 365, Windows desktop Tested with notes 38/39 passed, 1 not yet run Workbook 1.1.0 · Excel 16.0.20527.20112 · Windows Server 2025 Standard 10.0.26100 Nov 3, 2026 Automated runs on temporary copies: every calculated value against an independent calculation, paydays, checks, validation, protection, clearing, theme, print on Letter and A4, and capacity. The Accessibility Checker check, the Tab order check and the filter and sort check were run by hand in the Excel window on Nov 3, 2026. Not run: 1 check that needs the Excel interface, a system setting or a person. Not applicable, so not counted: 3.11 (plausibility warnings, because every input rule here is a hard limit); 3.17 (the exchange-rate check, because each file holds one currency); 3.27 (charts, because the Dashboard has none).
Excel 365, Mac desktop Not yet tested — — — Not yet tested.
Excel for the web Not yet tested — — — Not yet tested.
Google Sheets (native edition) Not yet tested — — — Not yet tested. The Google Sheets edition is free for every buyer when it ships.
Excel mobile (iOS, Android) Not supported — — — Viewing only; not tested for data entry.
Google Sheets mobile apps Not supported — — — Viewing only; not tested for data entry.
Google Sheets (importing the .xlsx) Not supported — — — Use the Google Sheets edition when it ships.
LibreOffice Calc Not yet tested — — — —
Apple Numbers Not yet tested — — — —

What changed in 1.1.0

Nov 3, 2026

A free update: the settings move to a new Setup sheet, and Start Here says what to do next.

  • Settings moved from Start Here to a new Setup sheet, with the same names.
  • Start Here has a Do this next line and a map of the sheets, and nothing to type; Setup ends with a Setup complete line.
  • Free for every buyer of 1.0.0, delivered through Payhip. Every column, table and name is the same, so your bills paste straight in.
  • Excel 365, Windows desktop: Tested with notes, 38 of 39 checks passed, 1 not yet run, workbook 1.1.0, Excel 16.0.20527.20112, tested Nov 3, 2026. Not applicable, so not counted: 3.11 (plausibility warnings, because every input rule here is a hard limit); 3.17 (the exchange-rate check, because each file holds one currency); 3.27 (charts, because the Dashboard has none). Excel for Mac, Excel for the web and Google Sheets: not yet tested.

Inputs affected: Yes. The settings moved from Start Here to Setup; every name, table and column is the same, so your rows paste straight in.

08What you get

What you get

Each purchase includes the files above, updates, email support and a personal-use license.

  • Workbook: 7 sheets, no macros, no scripts, no connections; it sends nothing anywhere. Tested in Excel 365 for Windows desktop.
  • Google Sheets: The Google Sheets edition is free for every buyer when it ships, delivered through Payhip.
  • Updates: 1.x updates are free and are delivered through Payhip.
  • License: Personal use: you and the people you live with, for your own household's bills.
  • Support: Email support; we reply within 1 business day (Monday to Friday, Australian Eastern time).

The workbooks collect nothing and send nothing. What you type stays in your copy.

09License

License

Personal use: you and the people you live with, for your own household's bills, subscriptions and renewals. You may edit the workbook and keep copies; you may not resell it, share an editable copy outside your household or use it to run a business.

Personal use

included at US$12

You and the people you live with, for your own household's money and admin. One purchase covers one household.

Allowed
Edit and extend the workbook, keep as many copies as your household needs, and share your own figures as a printout or PDF.
Not allowed
Running a business with it or tracking bills for clients or other households, giving an editable copy to anyone outside your household, reselling it or posting it online.
Buy for US$12

30-day money-back guarantee. No questions asked.

Business use? Email [email protected] and ask us first. The license page shows these terms before you buy, and the full text is in your download. Nothing in them limits rights you have under consumer law. Read the license page.

10Guarantee

30-day money-back guarantee

If the workbook isn't right for you, email [email protected] within 30 days of purchase with your order number. You'll get a full refund to your original payment method. No questions asked and no forms to fill in; we only ask that you delete your copies. This guarantee is in addition to your rights under the Australian Consumer Law and any other consumer law that applies to you.

11FAQ

Questions before you buy

Can it remind me when a bill is due?

No. A spreadsheet can't send reminders, and its dates move only when it recalculates. Setup step 3 asks you to set a weekly reminder in your phone's calendar to open the file.

What if I skip a week?

Nothing resets. An unpaid bill stays Overdue, with its oldest unpaid due date, until you type the date you paid it, and To pay by counts every missed payment. Autopay rows move on by themselves.

How does it work out the next due date?

From any one due date and how often the bill repeats: weekly, every 2 weeks, monthly, every 3 or 6 months, yearly, every 2 years or once. Monthly dates keep their day of the month, or the last day of a shorter month.

What if I pay a little early or late?

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), so both work. Counted for, next to Paid on, shows which due date it was counted for, and you can type that due date instead if it's wrong.

Does it connect to my bank?

No. You type each bill once and the date you pay it. Nothing connects to a bank or an app, and the file sends nothing anywhere.

Can I use it on my phone?

For viewing only. Add and update bills at a computer: Excel mobile and the Google Sheets mobile apps aren't supported for data entry.

Can I use it for a business?

No. The license is for personal use: you and the people you live with, for your own household's bills. Email [email protected] to ask about business use first.

Is the Google Sheets edition included?

Yes. The Google Sheets edition is free for every buyer when it ships, delivered through Payhip, under the same license. Until then, use the Excel file: importing the .xlsx into Google Sheets is not supported.

Is it financial advice?

No. The tracker lists the bills and dates you type and adds them up. It is an organizer, not financial advice, and it doesn't promise any saving or result.

What happens after I pay?

Checkout is handled by Payhip. You get a download link on the confirmation page and by email: one ZIP file with a blank workbook, a filled-in example workbook and eight short files, including START-HERE.html, the license terms and a checksum manifest.

I bought version 1.0.0. What changed in 1.1.0?

It is a free update, delivered through Payhip. The settings moved from Start Here to a new Setup sheet, and Start Here now says what to do next and maps the sheets. Names, tables and columns are the same, so your bills paste straight in. The setup guide lists where each setting went.

Does it work on a Mac?

It hasn't been tested in Excel for Mac yet, so we don't say it works there. The current version is tested in Excel 365 for Windows desktop, and it uses no macros. The compatibility page lists every environment and its status. If you buy it for a Mac and it doesn't work as described, the 30-day money-back guarantee gives you a full refund.

More answers in the setup guide and the help center.

12Weeksheet

More from Weeksheet by Metricvalley

More Weeksheet workbooks for household money and admin are in progress. None has a release date yet, and each goes on sale only after it passes our release checks in desktop Excel. About Weeksheet.

Bills & Renewals Tracker

US$12
Buy for US$12

30-day money-back guarantee. No questions asked.

Bills & Renewals Tracker · US$1230-day money-back guarantee. No questions asked.

Buy for US$12