This guide covers version 1.1.0, the version you download today, in the Australian edition. Estimate: setup takes about 15 minutes, plus about 1 minute per roster line and about 20 seconds per docket. A first month with 8 roster lines and 120 dockets takes about an hour, most of it typing dockets.

Record only. Not a payment claim. Not a payment schedule. The workbook checks your own roster, dockets, rate card and POs and shows where they disagree. It never requests payment. Make each claim through your accounting software and the process your contract sets.

Before you start

  • You need Excel 365 on a Windows desktop computer. That is where this version was tested. Other apps are listed on the compatibility page.
  • Have your PO numbers with their values and dates, the rate card for each PO with the date each rate starts, the month's roster, and the signed dockets.
  • 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 651 KB) somewhere you will find it again, such as a "Metricvalley" 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
day-rate-docket-reconciliation-v1.1.0-au-blank.xlsx The workbook for your own roster, dockets, rate card and POs
day-rate-docket-reconciliation-v1.1.0-au-worked-example.xlsx The same workbook with a fictional month
START-HERE.html Open this first: every file and where to begin
quick-start.md Setup steps and how to read the results
metric-dictionary.md Every field and calculation defined
support-and-compatibility.md Where it's tested, and how to get help
license.md Licence terms for both tiers
release-notes-v1.1.0.md What is in this version
money-back-guarantee.md The 30-day money-back guarantee
MANIFEST-day-rate-docket-reconciliation-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 day-rate-docket-reconciliation-v1.1.0-au-worked-example.xlsx to see August 2026 for a fictional plant and labour hire business with two POs, one in Queensland and one in Western Australia. Docket numbers, PO numbers and notes that start EX- are fictional, and the status reads SAMPLE until the sample rows are cleared.
  2. Open day-rate-docket-reconciliation-v1.1.0-au-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 business 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 eight sheets: Start Here, Setup, Dashboard, Roster, Dockets, Reconciliation, Rates & POs and Guide. It opens on Start Here, which has nothing to type: its Do this next line says where to go. The Guide sheet explains every input, calculation, rule 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. Fill in Setup

About 1 minute.

On Setup, your settings run down one column, in the order Tab moves through them. Each has a working default.

  1. Type your business name. It appears in the Start Here and Dashboard titles.
  2. Type the first month you will log, as its first day: 1 Jul 2026. The month dropdowns list 60 months from there.
  3. Optional: the PO warning level (90% unless you change it) and the Billing difference to ignore (1.00 AUD, for rounding).
  4. Optional: the Theme, Light or Dark, for Start Here and the Dashboard.

Setup ends with a Setup complete line. It feeds the Do this next line on Start Here, and it never changes the status in row 3.

The report month is not a setting. You pick it at the top of the Dashboard each time you read it (step 8).

Type dates with the month in words, such as 14 Aug 2026. Excel reads that form the same way on Australian, UK and US settings, and a docket dated after today is flagged, which catches most swapped days and months.

5. List your people, machines, POs and rate card on Rates & POs

About 10 minutes.

  1. Resources: one row per person or machine, its type (Person or Machine) and its rate class, typed exactly as on the rate card, for example Fitter.
  2. POs: each PO number once, with the principal, the site, the PO value and the PO start and end dates. Leave the value blank for a PO with no limit. If the PO was charged before this file starts, type that amount in Used before this file.
  3. Rate card: one line per PO and rate class, with the date the rates start, the charge basis (Per day or Per hour), the worked rate and hours in a shift, then the extra hour, half-day, standby, travel and mob or demob rates that apply. When a rate changes, add a line with the new date and keep the old one: each docket uses the latest line on or before its date.

Every rate is one you type and date: what you charge the principal under your contract or PO. The workbook holds no award rates and makes no pay or tax calculation.

6. Add the roster on Roster

About 1 minute per line.

  1. One line per person or machine, per PO, per month. A person on two POs in a month has two lines.
  2. Mark each rostered day D (day shift), N (night shift) or T (travel day). Leave other days blank.
  3. When you have billed the month, type the Amount billed for the line and your billing reference. Leave it blank until then.

7. Add the dockets on Dockets

About 20 seconds per docket.

  1. One row per docket: the docket number, the date, the resource, the PO number, the docket type (Worked, Standby, Travel, Mob or demob, or Down time), the hours for Worked and Standby, and the sign-off (Signed, Not signed or Disputed).
  2. To copy dockets from your docket app's export, paste them as values (Home > Paste > Paste Values) into the yellow columns, in the order shown.
  3. The white columns find the roster day and the rate line and price each docket. A row with a missing detail, an unknown resource or PO, a missing rate line or a duplicate reads Review, stays visible and is left out of the totals until you fix it. Its check columns name the problem.

Hours are billing quantities only. They are refused above 24, and the workbook never checks them against fatigue or hours-of-work limits.

8. Read the Dashboard and the Reconciliation

About 2 minutes.

  1. At the top of the Dashboard (cell B4), pick the report month, or leave it blank to show the latest month that has dockets. Cell D4 shows the month in use. The line under it repeats the PO warning level and the billing difference to ignore from Setup, so a print carries them.
  2. Check the status in row 3. OK means every check passes. CHECK (n) names how many fail; the Checks block says what to do. SAMPLE means sample rows remain.
  3. Read the six key figures for the report month: signed dockets at your rate card, not signed or disputed, billed, billing differences on billed lines, rostered days with no docket, and dockets with no roster day.
  4. Do this next, under the checks, gives one step for the file as it stands: a setting to finish, the first check to fix, the sample rows to clear, the lists or rows to add, or the first resource to follow up and why.
  5. POs to watch lists the POs at or over your warning level. Resources to follow up lists anyone with a gap, an extra docket, an unsigned or disputed docket, or a billing difference.
  6. On Reconciliation, the Day check shows each roster line's days: Gap where a rostered day has no docket, Extra where a docket falls on a day nobody was rostered.

Gaps, extra dockets and billing differences are results to follow up, not data problems, so they never change the status.

9. Each month

  1. Keep adding roster lines and dockets in the same file. The report month at the top of the Dashboard picks the month it shows, and the PO table keeps every month in the file.
  2. When the file is full, or at the start of a new financial year, save a new copy, clear the roster and dockets, and type each PO's charges so far in Used before this file. Keep the old copy as your record.

10. 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_Dockets and press Delete.
  4. Do the same for MV_Clear_Roster, MV_Clear_RateCard, MV_Clear_POs and MV_Clear_Resources. The Dashboard status then reads OK and every figure is blank. Your settings on Setup are kept.

If you use version 1.0.0: where Setup went

Version 1.0.0 kept your business name and the settings on Start Here. From version 1.1.0 they are on the new Setup sheet, and you pick the report month at the top of the Dashboard. Every name, table and column is the same, so every formula works as before and your rows paste straight in. Version 1.1.0 is a free update, delivered through Payhip.

  • Business name (MV_BusinessName): was Start Here B18, now Setup B7.
  • First month in month lists (MV_FirstMonth): was Start Here B19, now Setup B8.
  • PO warning level (MV_POWarn): was Start Here B22, now Setup B10.
  • Billing difference to ignore (MV_BillTolerance): was Start Here B23, now Setup B11.
  • Theme (MV_Theme): was Start Here B24, now Setup B12.
  • Report month (MV_ReportMonthInput): was Start Here B20, now Dashboard B4. The month shown (MV_ReportMonth) was B21, now Dashboard D4.
  • Workbook status: was Start Here B25. It is in row 3 of every sheet, as before.

To move your data into the 1.1.0 file:

  1. Open your 1.0.0 file and the 1.1.0 blank file.
  2. In the 1.0.0 file, choose MV_Clear_Resources in the Name Box and press Ctrl+C. In the 1.1.0 file, choose MV_Clear_Resources in the Name Box, then Home > Paste > Paste Values.
  3. Do the same for MV_Clear_POs, MV_Clear_RateCard, MV_Clear_Roster and MV_Clear_Dockets.
  4. On Setup, type your business name and any setting you had changed: first month, PO warning level, billing difference to ignore and theme.
  5. On the Dashboard, pick the report month if you had one set. Row 3 of every sheet then reads the same status as your 1.0.0 file.

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 demo or redacted data only, never real dockets or client records.

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.