Day-Rate & Docket Reconciliation · Excel 365 · Australian edition

Did every rostered day get a signed docket, and did you bill it at the right rate?

For mining-services, plant hire, labour hire and civil contractors in Australia who bill a principal by the day or the hour against a purchase order.

A monthly reconciliation workbook for contractors who bill a principal by the day or the hour: roster, signed dockets, rate card and POs in one file. Record only. Not a payment claim.

day-rate-docket-reconciliation-v1.1.0-au-worked-example.xlsx Demo data
Dashboard with sample data for Aug 2026: an empty report month picker beside Showing Aug 2026, signed dockets at rate card 173,342.50, billed 120,935.00, billing differences -977.50, the ten checks, a Do this next line and two POs to watch.
  • Yellow cells: you type. Leave every other cell to the workbook.
  • Yellow: you type here
  • White: calculated, don't type here
  • Grey: lists and reference values
Open full-size image of the Dashboard sheet

01What it answers

Four questions, answered every month

  1. Which rostered days have no signed docket?

    The day check shows each roster line's days for the month: D, N or T where a docket matches, Gap where a rostered day has no docket, and Extra where a docket falls on a day nobody was rostered.

  2. What are the dockets worth at your rate card?

    Every docket is priced from a dated rate line: day or hourly basis, shift hours, extra hours, half days, standby, travel days, and mob and demob. Signed dockets are ready to bill; unsigned and disputed ones are priced but kept apart.

  3. Does what you billed match the signed dockets?

    Billed minus signed for every roster line, so a missed rate change or extra hours shows up before the principal finds it.

  4. Which POs are close to running out?

    Used to date against each PO's value, with a warning level you set (90% unless you change it). A PO over its value reads Over PO.

02Demonstration

See the actual workbook

day-rate-docket-reconciliation-v1.1.0-au-worked-example.xlsx Demo data
Dockets sheet with sample data: docket numbers starting EX-, dates in Jul 2026, resources, PO numbers, docket types, hours and sign-off, then the rule result, whether the docket is counted, and its charge in AUD excluding GST. The calculated columns in between are hidden in this picture.

Dockets. One row per docket. You type the number, date, resource, PO, type, hours and sign-off; the rest of the row finds the roster day and the rate line, and prices it.

03What's inside

Eight sheets, one job

Demo data

Start Here

Its Do this next line says where to go: Setup until every setting is valid, then the steps that are left.

Version, status, licence and support details on one printable page.

Demo data

Setup

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

Clearing the sample rows leaves these settings as they are.

Demo data

Dashboard

Report month at the top: pick a month, or leave it blank for the latest month with dockets.

Status in row 3 of every sheet: OK, CHECK (n) or SAMPLE.

Charts: PO value against used to date, and signed dockets against billed by resource.

Demo data

Roster

200 roster lines; the Guide shows how to add more.

Demo data

Dockets

1,000 docket rows; tested at 4,000 after following the Guide's steps.

Rows with a missing detail, an unknown resource or PO, a missing rate line or a duplicate read Review and are left out of the totals.

Demo data

Reconciliation

Nothing to type here. Totals use rows with Row status OK.

Demo data

Rates & POs

When a rate changes, add a line with the new date: each docket uses the latest line on or before its date.

Demo data

Guide

Read it in the workbook or print it.

Exactly what's in the download

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

FileWhat it isSize
xlsxday-rate-docket-reconciliation-v1.1.0-au-blank.xlsx The workbook for your own roster, dockets, rate card and POs 656 KB
xlsxday-rate-docket-reconciliation-v1.1.0-au-worked-example.xlsx The same workbook with a fictional month 679 KB
htmlSTART-HERE.html Open this first: every file and where to begin 10 KB
mdquick-start.md Setup steps and how to read the results 9 KB
mdmetric-dictionary.md Every field and calculation defined 19 KB
mdsupport-and-compatibility.md Where it's tested, and how to get help 8 KB
mdlicense.md Licence terms for both tiers 4 KB
mdrelease-notes-v1.1.0.md What is in this version 7 KB
mdmoney-back-guarantee.md The 30-day money-back guarantee 1 KB
txtMANIFEST-day-rate-docket-reconciliation-v1.1.0.sha256 Checksums to verify your download 1 KB

04Setup

Ready in about 15 minutes, plus your roster and dockets (estimate)

  1. Fill in Setup type your business name and the first month you will log; the rest have working defaults.

    About 1 minute.
  2. List your people, machines, POs and rate card on Rates & POs with the date each rate starts.

    About 10 minutes.
  3. Add your roster on Roster one line per person or machine, per PO, per month, with D, N or T on each rostered day.

    About 1 minute per line.
  4. Add your dockets on Dockets one row per docket, typed or pasted from your docket app.

    About 20 seconds per docket.
  5. Pick the report month and read the Dashboard the month is at the top (blank = latest). OK means the checks pass, and the key figures show what to chase.

    About 2 minutes.

Estimate: a first month with 8 roster lines and 120 dockets takes about an hour, most of it typing dockets. Pasting them from a docket app's export is quicker.

05Worked example

August at a fictional plant and labour hire business

Fictional example

A fictional contractor bills two POs with three people and three machines: one PO at a Queensland pit, one on a Western Australian haul road. In August 2026 its signed dockets come to A$173,342.50 at the rate card, excluding GST. Two rostered days have no docket, and two dockets fall on days nobody was rostered. The excavator's rate went up on 16 August, but it was billed at the old rate, so its billing is A$790.00 below its signed dockets. One PO is at 91.6% of its value, and the other is over it.

Billed against signed dockets, Aug 2026 (fictional, AUD excl. GST)
Signed dockets on billed lines121,912.50
Billed120,935.00
Billing differences−977.50
PO EX-PO-7781, all months (fictional, AUD excl. GST)
PO value90,000.00
Used to date94,255.00
Remaining−4,255.00

The contractor, its principals, sites and people are fictional. These are the figures in the worked-example workbook, not a customer result.

06Fit

Is it right for you?

Good fit

  • Mining-services, plant hire, labour hire and civil contractors in Australia
  • Businesses that bill a principal by the day or the hour against a purchase order
  • Office managers and bookkeepers who match rosters and signed dockets each week or month
  • Anyone who wants each figure in a file they can check line by line

Not a fit

  • You need a payment claim or payment schedule. This workbook is a record for checking and never requests payment.
  • You need payroll, award interpretation or labour hire pay checks. The rates here are your charge-out rates.
  • You need safety records: pre-starts, inspections, defects or maintenance. Keep those in your site's own system.
  • You want dockets or rosters to arrive automatically from a docket app or rostering software. You type or paste them.
  • You need several people editing at once with permissions or change history.

Known limitations

  1. Amounts are in AUD, excluding GST. The workbook does not calculate GST, fuel tax credits or any other tax.
  2. Every rate is typed and dated by you. There are no award rates, and rates are not checked against your contract.
  3. Night shifts use the same rates as day shifts. If your rate card has night rates, set up a separate rate class.
  4. Travel, standby, half-day, extra-hour and PO-date rules follow the Guide. Contract terms that differ need your judgement.
  5. Tested in Excel 365 for Windows desktop. Excel for Mac, Excel for the web and Google Sheets are not yet tested.
  6. Excel mobile and the Google Sheets mobile apps are for viewing only, not data entry.
  7. Capacity is 1,000 dockets, 200 roster lines, 100 resources, 50 POs and 300 rate lines; the Guide shows how to add more.

07Tested on

Where it has been tested

Each release is tested against written checks, and the results are listed here and on the compatibility page. "Not yet tested" means exactly that: it may work, but we haven't confirmed it.

Latest test run

41/42 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 cases cover

  • 55 of 55 test scenarios pass, from the worked example as shipped to copies with one change each: 175,083 calculated values checked against an independent calculation in Excel 365 for Windows, 0 mismatches
  • Each of the ten checks forced to fail, the sample data cleared, a three-docket setup entered, the Dark theme, and printing on A4 and Letter
  • 900 and 1,000 dockets, and 4,000 after following the Guide's steps to add rows
  • The 1.0.0 worked example entered into the 1.1.0 blank file gave the same figures: 4,343 values compared, 0 mismatches
  • Google Sheets, Excel for Mac and Excel for the web are not yet tested
Environment Status Checks Version and build Last tested Notes
Excel 365, Windows desktop Tested with notes 41/42 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, the checks, validation, protection, clearing, theme, printing on A4 and Letter, and capacity. Run by hand in the Excel interface: Excel's Accessibility Checker, the Tab order on each input sheet and filtering on the protected Dockets sheet (sorting is blocked there). Not run: 1 check that needs the Excel interface, a system setting or a person.
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 native 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 for every buyer of 1.0.0, delivered through Payhip. Start Here says what to do next, your settings are on a new Setup sheet, and you pick the report month at the top of the Dashboard.

  • Settings moved from Start Here to a new Setup sheet; names unchanged.
  • The report month moved to the top of the Dashboard, beside the figures it changes.
  • Start Here now has a Do this next line and a map of the sheets, and nothing to type.
  • The Dashboard has its own Do this next line.
  • Setup ends with a Setup complete line.
  • The workbook has eight sheets: Start Here, Setup, Dashboard, Roster, Dockets, Reconciliation, Rates & POs and Guide.
  • Excel 365, Windows desktop: Tested with notes, 41 of 42 checks passed, 1 not yet run, workbook 1.1.0, Excel 16.0.20527.20112 on Windows Server 2025 Standard 10.0.26100, tested Nov 3, 2026. Run by hand in the Excel interface: Excel's Accessibility Checker, the Tab order on each input sheet and filtering on the protected Dockets sheet (sorting is blocked there). Excel for Mac, Excel for the web and Google Sheets: not yet tested.

Inputs affected: Yes. The settings moved from Start Here to Setup, and the report month to the top of the Dashboard; 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 license for your business.

  • Workbook: 8 sheets, no macros, no external connections; tested in Excel 365 for Windows desktop. Amounts in AUD, excluding GST. The Google Sheets edition is free for every buyer when it ships.
  • Updates: 1.x updates are free and are delivered through Payhip.
  • Licence: Single-business, for one business and all its staff. Agency/Team is store-wide: the tracker's US$99 Agency/Team licence, or the bundle's US$129 Agency/Team tier, covers this workbook too, for up to 5 client businesses.
  • Support: Email support; we reply within 1 business day (Monday to Friday, Australian Eastern time).
  • Guide: a Guide sheet inside the workbook, plus a setup guide on this site.
  • Google Sheets: the Google Sheets edition is included free for every buyer when it ships.

09License

License

Two licenses. Both let you edit the workbook, keep backups and share the reports it produces. Neither lets you pass the editable file to another business. Tracking your own clients is exactly what Single-business is for. You need Agency/Team only if you keep a working copy for another business's own figures.

Single-business

included at US$49

For one business or sole trader, and everyone who works in it: staff and contractors.

Allowed
Edit and extend the workbook, keep backups, share reports and results with your team, clients, advisers and board.
Not allowed
Using it for a second business, giving an editable copy to a client or anyone outside the business, reselling or posting it online.
Buy for US$49

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

Agency/Team

Store-wide

For an agency and up to 5 client businesses it manages, and everyone who works in the agency. Store-wide: it covers every Metricvalley business template your business owns.

Agency/Team is store-wide: the Client Profitability Tracker's US$99 Agency/Team licence, or the Agency Operating Bundle's US$129 Agency/Team tier, covers every Metricvalley business template your business owns, including this workbook, for up to 5 client businesses. This workbook has no Agency/Team price of its own.

Allowed
Everything in Single-business, plus separate working copies for up to 5 client businesses you manage, as long as you keep the file and send them the results.
Not allowed
Giving clients or anyone outside your agency an editable copy, reselling, or including it in a product, course or template library.
See Agency/Team on the tracker page

The full terms are in the download and shown before checkout. Nothing in them limits rights you have under consumer law. Read the full license terms.

10Guarantee

30-day money-back guarantee

If the workbook isn't right for your business, 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

Is it a payment claim?

No. Record only. Not a payment claim. Not a payment schedule. The workbook checks your own records and never requests payment, and every printed page says so. Make each claim through your accounting software and the process your contract sets. Whether a security of payment Act applies to your work is for you to decide; get advice if you're unsure.

How is each docket priced?

From the rate line for its PO and rate class with the latest Rates from date on or before the docket date. Worked, Per day: one day at the worked rate, plus hours over the shift at the extra hour rate, or the half-day rate for a short shift. Worked, Per hour: hours times the rate, with at least the hours in a shift. Standby, travel and mob or demob have their own rates, travel only on a day rostered T. Down time is never charged.

Does it check award rates, pay or tax?

No. Every rate is one you type and date: what you charge the principal under your contract or PO. There are no award tables, no pay or labour hire pay checks, and no fuel tax credit, GST or other tax calculations. Amounts are in AUD, excluding GST.

Can I paste dockets from my docket app?

Yes. Paste them as values (Home > Paste > Paste Values) into the yellow columns of Dockets, in the column order shown: docket number, date, resource, PO number, docket type, hours, sign-off and notes. Pasted rows are checked like typed ones: a row with an unknown resource, text in Hours or a value not on a list reads Review, and a Dashboard check names the problem.

Does it keep safety or fatigue records?

No. There are no pre-start, inspection, defect, hazard or maintenance fields. Hours are billing quantities only: they are refused above 24 and never checked against fatigue or hours-of-work limits. Keep those records in your site's own system.

Can I keep copies for other businesses?

Only with Agency/Team, which is store-wide: the Client Profitability Tracker's US$99 Agency/Team licence, or the Agency Operating Bundle's US$129 Agency/Team tier, covers every Metricvalley business template your business owns, including this one, for up to 5 client businesses. This workbook has no Agency/Team price of its own. An editable copy never goes to a principal or another business.

Does it work on a Mac?

Excel 365 for Mac is not yet tested, and neither is Excel for the web. The files are standard .xlsx workbooks with no macros, but only Excel 365 for Windows desktop has passed the checks so far. If you try it on a Mac, check the status in row 3 of each sheet after you enter data.

Is the Google Sheets edition included?

Yes. The Google Sheets edition is included free for all buyers when it ships. It is built from the same specification, with the same sheets and checks. When it is ready, you get its Make a copy link through Payhip. Until then, use the Excel file: importing the .xlsx into Google Sheets is not supported.

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 licence terms and a checksum manifest.

I bought version 1.0.0. What changed in 1.1.0?

Version 1.1.0 is a free update, delivered through Payhip. Your settings moved from Start Here to a new Setup sheet, and you now pick the report month at the top of the Dashboard. Every name, table and column is the same, so your data pastes straight in. The setup guide lists where each setting went.

More answers in the setup guide and the help center.

Day-Rate & Docket Reconciliation · US$4930-day money-back guarantee. No questions asked.

Buy for US$49