Combined Report
Every docket line and material receipt on one project for a date range, in one Excel file with four sheets: Combined Detail, Summary by Supervisor, Summary by Cost Code and Summary by Date. The layout matches the Combined 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 and receipts in the file |
|---|---|
| Master Admin, Org Manager, Project Admin | Every docket and material receipt on the project. |
| Supervisor, Senior Supervisor | Dockets and receipts 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 in their activity hours, plus dockets with no cost-coded hours. |
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 › Combined Report.
- Pick From and To. The range starts on the first of this month.
- Optionally narrow it with Supervisors.
- Check the About N rows line. It is a close estimate; the file can be a few rows longer or shorter.
- 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> Combined Report <From> - <To>.xlsx, for example Riverside Road Upgrade Combined Report 1 July 2026 - 31 July 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. |
| Supervisors | Keeps dockets and receipts where a picked person is the supervisor or an additional supervisor. Leave it empty for all. |
A docket found through an additional supervisor is still listed under its own supervisor in Summary by Supervisor.
The four row kinds
| Type | What it is |
|---|---|
| Work Item | A priced line on a docket, including its prestart line. |
| Attachment | A line added from the catalogue, or an attachment migrated from Core. |
| Docket | A docket with no lines: one row with its hours and its total. |
| MR | One line of a material receipt. |
Every docket row comes first, in the order the dockets were created. Receipts come after, in the same order. Inside a docket: work items, then attachments, in the order the lines were added.
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 material line on a labour or plant docket is one row with no activity.
- A docket that has never been priced keeps its row with a blank Amount.
- Each material receipt line gives one row, with the charged quantity (a minimum top-up is included, never a second row). A receipt with no lines gives one row with its total.
Combined Detail
| Column | What it shows |
|---|---|
| Type | Work Item, Attachment, Docket or MR. |
| Project | The project name. |
| Docket Date | The shift day, dd/mm/yyyy. |
| Docket Number | The docket number. With the person and date when your organisation shows them (Docket Numbers). On a receipt, the supplier’s delivery docket number (a receipt migrated from Core shows its docket number). |
| Docket Type | Labour, Dry Hire Plant, Wet Hire Plant, Plant Operator - Wet or Dry Hire, Subcontractor, or Material Receipt. |
| Supervisor | The docket’s supervisor. |
| Additional Supervisors | The docket’s additional supervisors. |
| Resource Name | The priced resource. On a Docket row, the first worker, otherwise the machine. |
| Rate Source Data | Purchase Orders, Schedule of Rates or Internal Rate Cards: the source that priced the row. |
| Supplier | The line’s supplier, otherwise the docket’s. |
| PO/Contract Number, PO/Contract Line Number, PO/Contract Line Description | The purchase order or contract, its line number and text. Without a PO line: the line’s description and rate tier. |
| Subcontractor Upload ID | Always blank. |
| Internal Rate Card Description | The rate card line, when an internal rate card priced the row. |
| Billing Unit, Billing Rate, Unit Qty, Amount | The unit (HR, DAY, EA, M3, TN …) and rate, and this row’s quantity and amount. |
| Start Time, Finish Time | The shift clock, hh:mm am. |
| Break Time, Break Duration | Start of the unpaid break, and its minutes, e.g. 30 Mins. |
| Shift Qty | The docket’s net hours, e.g. 8.00. |
| Prestart Duration | The priced prestart’s minutes, e.g. 15 Mins. |
| Prestart PO/Contract Number, Line Number, Line Description | The purchase order line the prestart was priced against. |
| Activity Description, Activity Cost Code, Activity Sub Code, Activity Program Code | The activity the row is charged to. A Docket row or a receipt with no lines shows the docket’s only activity, else its cost code. |
| Tagged Issue | The issue number, e.g. 9824-0002. |
| Docket Note | The docket’s notes. |
| Submitted By, 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. A docket migrated from Core shows its diary’s. |
| Upload to ERP | Yes once the docket has been sent to your ERP. |
| Docket Unique ID | The docket’s Lacroo id. |
The summary sheets
Summary by Supervisor
One row per supervisor, in the order they first appear: Total Rows, Work Items, Attachments, Dockets, Material Receipts, Total Amount and Avg Shift Qty. Avg Shift Qty is the average Shift Qty of that supervisor’s dockets (each docket counted once). 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 five counts, Total Unit Qty and Total Amount. Total Unit 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 five counts, Total Unit Qty and Total Amount.
What is not included
Day works. Use the Day Works report for day works totals.
Differences from Core
- All supervisors means no filter: dockets with any supervisor, or none, are included.
- Every docket and receipt appears once.
- Prestart lines carry their money, and the prestart PO columns are filled.
- Rate Source Data comes from the price list that priced the row.
- Tagged Issue, Activity Program Code and Docket Note are filled.
- Docket rows show their activity or cost code.
- Submitted, approved and checked come from the docket.
- Shift Qty is never negative.
- Supervisors are grouped by person, not by name.
- Avg Shift Qty counts each docket once.
- Dates are exact days, with no time-zone shift.
- A receipt’s Billing Rate is a number.
- Docket Unique ID is the Lacroo docket id.
- File names keep letters with accents.
Dockets migrated from Core
Additional supervisors on migrated dockets print once they are loaded into Lacroo. Until then that column is blank on those dockets.
See also
- Labour & Plant Dockets Report: labour and plant lines only, with day works.
- CSV Export: the Docket Workbench’s line-level CSV feed.
- Reports: running reports, emails, history and file retention.