Labour & Plant Dockets Report

Every labour and plant docket line on one project for a date range, in one Excel file with four sheets: Dockets Detail, Summary by Supervisor, Summary by Cost Code and Summary by Date. The layout matches the Plant & Labour Docket Report from Lacroo Core, so existing spreadsheets and pivot tables keep working.

Who can run it

Anyone whose role has dockets View pricing. By default that is Master Admin, Org Manager, Project Admin, Engineer, Supervisor and Senior Supervisor.

What the file contains depends on your role:

Role	Dockets in the file
Master Admin, Org Manager, Project Admin	Every labour and plant docket on the project.
Supervisor, Senior Supervisor	Dockets where you are the supervisor or an additional supervisor.
Engineer	The whole project while Export whole project is on in your role (the default). With it off: dockets carrying one of your assigned cost codes, plus dockets with no cost code.

A report only ever contains the dockets you can open in Lacroo. See Reports for how files, emails and history work.

How to run it

Open Reports › Dockets › Labour & Plant Dockets.
Pick From and To. The range starts on today.
Optionally narrow it with Suppliers, Supervisors and Diary Status.
Check the About N rows line and the first 100 rows shown under the filters. A line shared across activities adds rows, so the file can be a little longer.
Click Generate.

You get a “Report ready for download!” email with a Download Report button, and the report appears in Recent reports. Files are kept for 90 days. When a run fails or its file expires, Run Again makes a fresh copy with today’s data.

The file

An Excel file named <Project> Dockets Export <From> - <To>.xlsx, for example Riverside Road Upgrade Dockets Export 30 Jan 2026 - 27 Feb 2026.xlsx. Months are short (Sept, June, July). Characters a file name cannot hold are left out.

Filters

Filter	What it does
From / To	The docket date, both days included. Up to two years.
Suppliers	Keeps rows whose supplier you picked. Each row uses its line’s own supplier, otherwise the docket’s. Internal dockets (no supplier) drop out when you pick a supplier.
Supervisors	Keeps dockets where a picked person is the supervisor or an additional supervisor.
Diary Status	Draft, Submitted or Approved (reviewed or confirmed). A docket with no diary uses its own step.

Leaving a filter empty means all.

The four sheets

Dockets Detail

One row per docket line (see How a line becomes rows), sorted by docket date, then the order dockets were created, then work items, prestarts and attachments.

Column	What it shows
Type	`WORK ITEM`, `PRESTART` or `ATTACHMENT`. A line added from the catalogue is an attachment.
Docket Date	The shift day, `dd/mm/yyyy`.
Docket Number	The docket number, or `NA`. With the person and date when your organisation shows them (Docket Numbers).
Docket Type	Labour, Dry Hire Plant, Wet Hire Plant, Plant Operator - Wet or Dry Hire, or Subcontractor.
Supplier	The line’s supplier, otherwise the docket’s. Blank for internal dockets.
Resource Name	The machine, otherwise the first worker, otherwise the priced resource.
Start Time, Finish Time	The shift clock, `hh:mm am`.
Break Time	Start of the unpaid break.
Break Duration	Unpaid break minutes, e.g. `30 Mins`.
Rates Data Source	Purchase Orders, Schedule of Rates or Internal Rate Cards: the source that priced the line.
PO Line Number	The purchase order line the row was priced against.
PO/Contract Number	The purchase order or contract number.
Work Description	The line’s description, otherwise its PO line text and rate tier.
Unit, Rate, Qty, Amount	The line’s unit and rate, and this row’s quantity and amount.
Daywork Description, Daywork Qty, Daywork Unit, Daywork Rate, Daywork Amount	The docket’s day works, repeated on each of its rows.
Activity Description, Activity Cost Code, Activity Sub Code, Activity Program Code	The activity the row is charged to. Rows with no activity show the docket’s only activity, otherwise the docket’s cost code.
Tagged Issue	The issue number, e.g. `9824-0002`.
Docket Note	The docket’s notes, line breaks kept.
Submitted By	The docket’s supervisor.
Additional Supervisors	The docket’s additional supervisors.
Submitted When, Approved By, Approved On, Checked By, Checked On	Who submitted, reviewed and confirmed the docket, and when, in the project’s time zone. `NA` when not done yet.
Docket Status	`Open` for a draft, otherwise `Close`.
Docket Unique ID	The docket’s Lacroo id.
GRN Pushed	`YES` once the docket has been sent to your ERP.

Summary by Supervisor

One row per supervisor, in the order they first appear: Total Rows, Work Items, Prestarts, Attachments and Total Amount. Two people with the same name stay on separate rows. Dockets with no supervisor are grouped under (No Supervisor).

Summary by Cost Code

One row per cost code, in the order they first appear, with the first activity description, the four counts, Total Qty and Total Amount. Total Qty adds quantities across units, as Core did. Rows with no cost code are grouped under (No Cost Code).

Summary by Date

One row per docket date, oldest first, with the four counts, Total Qty and Total Amount.

How a line becomes rows

Each docket line gives one row.
A line shared across several activities gives one row per activity. Those rows add up to the line, to the cent; any rounding cent goes on the last row of the line.
The rows of a docket add up to the docket’s total, to the cent.
A line migrated from Core keeps its single row and its Core activity.
A docket with no lines gives one row, typed WORK ITEM, with its hours as Qty and its total as Amount.
A docket that has never been priced keeps its row with a blank Amount. A priced docket that came to $0.00 shows 0.

Day works are shown on every row of the docket and are in no total. Use the Day Works report for day works totals.

Differences from Core

Suppliers and Diary Status filters work.
Docket-only rows show an activity and cost code.
Prestart rows show their real PO line and number.
Attachments show the rate source that priced them.
Each line is counted once.
Each docket shows its own approvals.
Supervisors are grouped by person, not by name.
Rows are sorted.
Dates are exact days, with no time-zone shift.
A blank amount means not priced; 0 means priced at $0.00.
Docket Unique ID is the Lacroo docket id.
Units use Lacroo’s words (hour, day, ea).

Dockets migrated from Core

Day works and additional supervisors on migrated dockets print once they are loaded into Lacroo. Until then those columns are blank on those dockets.