Dayworks Report
Every docket on one project for a date range, one row per docket, with its day works, shift times, hours, photos and diary sign-offs. The file is a CSV with the same 31 columns as the Dayworks Report from Lacroo Core, so existing spreadsheets keep working.
Who can run it
Anyone whose role has dockets Export CSV. By default that is Master Admin, Org Manager, Project Admin and Engineer.
What the file contains depends on your role:
| Role | Dockets in the file |
|---|---|
| Master Admin, Org Manager, Project Admin | Every docket on the project. |
| 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 in their activity hours, plus dockets with no cost-coded hours. |
| Supervisor, Senior Supervisor | Only when an admin switches Export CSV on for the role. Then: the dockets where you are the supervisor or an additional supervisor. |
Day Works Rate and Day Works Amount need dockets View pricing. Without it those two cells are blank; every other column is filled.
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 › Dayworks Report Export.
- Pick Diary Date From and Diary Date To. The range starts on the first of this month and ends today.
- Optionally narrow it with the filters below.
- Check the row count and the first 100 rows in the preview. Photo links are not shown in the preview; they are in the file. With Diary Supervisors, Docket Type or Docket Status set, the count reads Up to and the file can have fewer rows. The preview can show fewer rows too.
- Click Export Daywork Report.
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.
Filters
An empty filter means all.
| Filter | What it does |
|---|---|
| Diary Date From / Diary Date To | The docket’s day, both days included. Up to two years. |
| Diary Supervisors | Keeps a docket when a picked person is the supervisor of any diary the docket is in. A docket in no diary is matched on its own supervisor. Additional supervisors are not matched. |
| Diary Status | The diary’s current status: Draft, Submitted or Approved (reviewed or confirmed). A docket in no diary uses its own stage; a docket submitted by the crew but not yet by its supervisor is Draft. |
| Docket Type | Matches the label in the Docket Type column. |
| Docket Status | Open is a draft docket. Close is any docket submitted by the crew or later. |
The 31 columns
One row per docket, in date order, then in the order the dockets were created. A docket with no day works still has its row, with a Day Works Amount of 0.00.
| Column | What it shows |
|---|---|
| Docket Date | The shift day, dd/mm/yy. |
| Docket Number | The docket number. With the person and date when your organisation shows them (Docket Numbers). |
| Docket Type | Labour, Plant Operator - Wet or Dry Hire, Wet Hire Plant, Dry Hire Plant or Subcontractor, from the docket’s type and its plant item’s hire type. The same labels as the other docket reports. |
| Supplier | The docket’s supplier. INTERNAL when the project’s own company supplied it. |
| Resource Name A | The docket’s people, in the order they were added. With no people, the machine. |
| Resource Name B | The machine, when the docket also has people. |
| Activity Description, Activity Cost Code, Activity Sub Code, Activity Program Code | The docket’s activities, each value once, in the project’s activity order. A docket with no activity shows its own cost code and description. |
| Tagged Issue | The issue number. |
| Start Time, Finish Time | The shift’s clock times, e.g. 6:30 am. |
| Break Time | When the first break started. |
| Break Duration | All breaks, paid and unpaid, e.g. 30 Mins. 0 with no break. |
| Docket Unit Qty | The docket’s net hours, otherwise its meter reading. |
| Docket Note | The docket’s notes. |
| Docket Photos | A link to each finished photo on the docket and on its crews, in the order taken. Marked-up photos link to the marked-up copy. |
| Day Works Description, Day Works Unit | Each value once. A subcontractor docket rolls all its crews’ day works into its one row. |
| Day Works Qty | The total quantity, when every entry uses the same unit. Blank while an entry is waiting for its quantity. |
| Day Works Rate | The rate, when every entry shares one. |
| Day Works Amount | The total, to the cent. 0.00 with no day works. |
| Submitted By, Submitted When | Who submitted the diary and when. When the person is not recorded, the diary’s supervisor. A docket in no diary shows its own supervisor and no time. |
| Approved By, Approved On | The diary’s first office approval (reviewed). |
| Checked By, Checked On | The diary’s final approval (confirmed). |
| Docket Status | Open or Close. |
| Docket Unique ID | The docket’s Lacroo id. |
Submitted, Approved and Checked
All six sign-off cells come from one diary: the diary the docket belongs to, or, for a subcontractor docket reached through several diaries, the first one it was added to. The times are in the project’s time zone, e.g. 03:43 PM 2026-05-04.
The file
A CSV named <Project> - Dayworks Report (<Mmm d, yyyy> to <Mmm d, yyyy>).csv, for example Riverside Road Upgrade - Dayworks Report (Aug 1, 2026 to Aug 31, 2026).csv. Every value is in quotes, and it opens in Excel with accented names intact. A value Excel would run as a formula, such as =SUM(A1), is written so Excel shows it as text.
Differences from Core
- The row count covers this project only and applies only the dates and Diary Status.
- An emptied filter means all.
- Diary Status is the diary’s current status.
- The three sign-off times show real minutes.
- Checked On comes from the same diary as Checked By.
- Submitted By names the person who submitted the diary when that is recorded.
- Diary Supervisors covers every diary a docket is in.
- Every run ends with a status and an email.
- The file ends in
.csv, with standard CSV quoting and accented names intact. - Docket Photos has no stray leading
,. - Times use the project’s time zone.
- A range that ends before it starts is refused.
- Rows are in date order, then creation order.
- One label for plant operator dockets.
- Subcontractor dockets’ crew day works are included.
- Diary Date To starts on today.
- Downloads need you to be signed in.
- A range with no dockets says so plainly.
- Docket Type labels on dockets created in Lacroo Pro follow the same table as the other docket reports.
Dockets migrated from Core
- Docket Unique ID is the Lacroo id, not the Core one.
- Core’s own Docket Type label, Docket Unit Qty and Break Duration text are kept.
- A migrated docket with no day works entered in Lacroo shows Core’s day works.
- Supplier is the company’s name in Lacroo (
INTERNALwhere the supplier was the project’s own company). - Resource Name B shows the docket’s second resource.
See also
- Day Works: the Day Works workbench view and its export.
- Labour & Plant Dockets Report: labour and plant lines, with money split by activity.
- Reports: running reports, emails, history and file retention.