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

  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 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

  1. Open safe-to-spend-budget-v1.1.0-worked-example.xlsx to see a filled-in Dashboard for a sample household. Every figure in it is fictional.
  2. 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.
  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. 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

  1. One row per bill or regular saving. 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.
  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 and Australian computers.
  4. 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

  1. Set a weekly reminder in your phone's calendar to open the file. A spreadsheet can't send reminders itself.
  2. Check the status in row 3. OK means every check passes. CHECK (n) names how many fail; the Checks block on the Dashboard says what to do.
  3. Read Safe to spend: the amount left after the bills and savings still to come before your next payday.

8. The weekly check

  1. Open the file. The Safe to spend line and the dates update when it opens.
  2. On the This Week sheet, type your balance in Balance in your spending account and the date it was on in Balance on (date).
  3. Open the Dashboard and read Safe to spend, the per-day figure and Needs attention.
  4. 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

  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. Then do the same for MV_Clear_WaitList and MV_Clear_Balance on the This Week sheet. 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. 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:

  1. Open your 1.0.0 file and the 1.1.0 file.
  2. In the 1.0.0 file, choose MV_Clear_Bills in the Name Box and press Ctrl+C.
  3. In the 1.1.0 file, choose MV_Clear_Bills in the Name Box, then choose Home > Paste > Paste Values.
  4. Do the same for MV_Clear_WaitList, and for MV_Clear_Balance if you want your last balance too.
  5. 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.