This guide covers version 1.1.0, the version you download today. Estimate: setup takes about 5 minutes, plus about 1 minute per item. 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 the documents and deadlines to track: what each one is, its next due or expiry date and whether it repeats. Do not type full ID numbers; the file has a reference column for a short note.
  • 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 222 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 paperwork-deadlines-tracker-v1.1.0-worked-example.xlsx to see a filled-in Dashboard for a sample household. Every item in it is fictional.
  2. Open paperwork-deadlines-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. It is your clean copy if you ever need to start again.

The workbook has seven sheets: Start Here, Setup, Dashboard, Paperwork, 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

On Setup, check the name for this tracker and the two day settings. Each has a working default, so you can leave them as they are to start with.

  1. Name for this tracker is shown in the Dashboard title, 1 to 40 characters.
  2. Look ahead this many days (90 by default, 7 to 365) sets how far ahead the Dashboard lists items.
  3. Start this many days before (30 by default, 0 to 365) sets the start-by date for every item that leaves Start (days before) blank.
  4. Theme is Light or Dark, for Start Here and the Dashboard only.

Setup ends with a Setup complete line: Yes when every setting is filled in and valid, 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 each document or deadline on the Paperwork sheet

  1. One row per document or deadline. Two columns are needed: Item and Due date.
  2. Repeats is a list: Once, Every month, Every 3 months, Every 6 months, Every year, or every 2, 3, 4, 5 or 10 years. Leave it blank for Once.
  3. Due date is the next due or expiry date. 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: Start (days before), which overrides the default on Setup; Who; Kept where; Notes; Category; and Ref, a short reference of up to 20 characters (never a full ID number).

6. 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 Do this next: one line with the single most useful next step.

7. The weekly check

  1. Open the file. Statuses update when it opens.
  2. On the Paperwork sheet, type the date you finished an item in Done on. Ctrl+; types today's date.
  3. Open the Dashboard and read Do this next and Needs attention.

8. 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_Paperwork 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
Look ahead this many days Start Here B18 Setup B9
Start this many days before Start Here B19 Setup B10
Theme Start Here B20 Setup B11

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 D6:D25 in the Name Box and press Ctrl+C; on the Lists sheet of the 1.1.0 file, type D6:D25 in the Name Box, then choose Home > Paste > Paste Values.
  3. In the 1.0.0 file, choose MV_Clear_Paperwork in the Name Box and press Ctrl+C.
  4. In the 1.1.0 file, choose MV_Clear_Paperwork 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.

Getting help

  • The Guide sheet in the workbook explains every column, status and check.
  • Support and compatibility lists where the file was tested and how to get help.
  • Check each deadline with the office or provider that sets it. The file shows the dates you type; it does not check them.
  • We reply within 1 business day, Monday to Friday, Australian Eastern time. Include the version (1.1.0) and what you saw.