Help
Set up the Safe-to-Spend Budget
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 or saving. After that, the weekly check takes about 1 minute.
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 your bills and regular savings to hand: the name, the amount, how often each one repeats and one due date for each. Your usual pay and your next payday help too, but they are optional.
- Sheet names and column labels below are quoted exactly as they appear in the version 1.1.0 file.
1. Download the ZIP file
- 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 214 KB) somewhere you will find it again, such as a "Weeksheet" folder in Documents.
2. Unzip it
- 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.
3. Open the worked example, then save your own copy of the blank file
- Open
safe-to-spend-budget-v1.1.0-worked-example.xlsxto see a filled-in Dashboard for a sample household. Every figure in it is fictional. - Open
safe-to-spend-budget-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. It is your clean copy if you ever need to start again.
The workbook has eight sheets: Start Here, Setup, Dashboard, This Week, Bills, Lists, Guide and Changelog. It opens on Start Here, which has nothing to type: its Do this next line says where to go.
4. Check your settings on Setup
About 2 minutes.
On Setup, the eight settings sit in one column. Each has a working default. Check the name and the currency, then add a payday if you have one:
| Setting | What to enter |
|---|---|
Name for this budget |
Shown in the Dashboard title, 1 to 40 characters |
Currency |
The one currency for every amount. Nothing is converted. Default USD |
Next payday |
Optional. Any one payday, past or future. Leave it blank to run the budget by calendar month |
Payday repeats |
Weekly, Every 2 weeks or Monthly. Default Every 2 weeks |
Usual pay per payday |
Optional. Your pay after tax. It is used only for the typical pay period on the Dashboard |
Warn me this many days ahead |
1 to 60, default 7. Sets Due soon |
Wait this many days before deciding |
0 to 365, default 7. For wait-list items with no wait of their own |
Theme |
Light or Dark, for Start Here and the Dashboard only |
Setup ends with a Setup complete line: Yes when every setting is valid (the optional ones 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. Type your balance on the This Week sheet
About 1 minute.
On This Week, type your balance in Balance in your spending account and the date it was on in Balance on (date). These are not settings: you type them again each week, so they stay on This Week.
6. Add your bills and savings on the Bills sheet
- One row per bill or regular saving. 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.
- 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 and Australian computers. - Optional columns: Kind (Bill or Savings), Notes and Ref. The Bills sheet holds up to 100 rows.
7. Set a weekly reminder, then read the Dashboard
- Set a weekly reminder in your phone's calendar to open the file. A spreadsheet can't send reminders itself.
- Check the status in row 3.
OKmeans every check passes.CHECK (n)names how many fail; the Checks block on the Dashboard says what to do. - Read Safe to spend: the amount left after the bills and savings still to come before your next payday.
8. The weekly check
- Open the file. The Safe to spend line and the dates update when it opens.
- On the This Week sheet, type your balance in Balance in your spending account and the date it was on in Balance on (date).
- Open the Dashboard and read Safe to spend, the per-day figure and Needs attention.
- Optional: add a purchase you are thinking about to the wait list, with its price and the days to wait. When the wait is over, the Dashboard shows whether it fits within safe to spend.
9. Clearing the worked example
- 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. Then do the same forMV_Clear_WaitListandMV_Clear_Balanceon the This Week sheet. 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. Your balance and its date stay on This Week.
| Setting | Was | Now |
|---|---|---|
Name for this budget |
Start Here B6 | Setup B7 |
Currency |
Start Here B18 | Setup B8 |
Next payday |
Start Here B19 | Setup B10 |
Payday repeats |
Start Here B20 | Setup B11 |
Usual pay per payday |
Start Here B21 | Setup B12 |
Warn me this many days ahead |
Start Here B22 | Setup B13 |
Wait this many days before deciding |
Start Here B23 | Setup B14 |
Theme |
Start Here B24 | Setup B15 |
To move your budget into the 1.1.0 file:
- Open your 1.0.0 file and the 1.1.0 file.
- 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. - Do the same for
MV_Clear_WaitList, and forMV_Clear_Balanceif you want your last balance too. - On Setup, type the name for this budget, your payday and any other setting you had changed.
Getting help
- The Guide sheet in the workbook explains every column, calculation and check.
- Support and compatibility lists where the file was tested and how to get help.
- We reply within 1 business day, Monday to Friday, Australian Eastern time. Include the version (1.1.0) and what you saw.