Rates report
- Aimee Jay
- James Barnsley
- Tessa Power (Unlicensed)
How to download and understand the data in Tātou Rates Report.
Download instructions
Login to the Office app
Select
Reportsfrom the top menuUnder “Report Type”, select
Rates Report.Choose the date range to search between.
Export the report and open in Excel or import to Google Drive.
Report breakdown
Data pulls directly from the job, the Rates Report then calculates total cost, total hours and average hourly rate ($NZD) of the crew.
Job ID | Supervisor | Client | Blocks | Task | Rate Type | Unit Rate $ | Total cost | Avg hourly rate $ | Total hours | Total units | Comments |
|---|---|---|---|---|---|---|---|---|---|---|---|
12345 | Samantha Smith | Ants Nest | AN-SER-B1 | Shoot thinning | Contract | 0.05 | 233.85 | 19.4875 | 12 | 4677 | Example job: Crew with Supervisor |
12346 | Jon Jones | Ants Nest | AN-SER-B1, AN-SER-B3 | Bud rubbing | Hourly | 17.7 | 354 | 17.7 | 20 | 5236 | Example job: Crew |
12347 | Cassie McDonal | Ants Nest | AN-JEFF-BA | Post digging out | Hourly | 22 | 176 | - | 8 | 0 | Example job: Machinery Operator (+ Crew Task) |
Sum of all timesheet costs | Average hourly rate across all crew timesheets | Sum of all timesheet hours | *Ideally Crew Task + Crew Role* |
Rates are currently only calculated using $NZD.
Report uses
Compare unit rates across a task: is everyone charging a fair rate?
Compare unit rates across a task and client: are all their blocks being charged the same rate?
Review average hourly rates: are employees earning enough?
Compare average hourly rate across a task: are those on Contract earning more or less than those on Hourly?
Data excludes holiday pay, paid rest breaks and top-ups.
Comments
Your feedback is important, what do you use the report to check? What changes would you like to see? e.g. Task speed: Total units ÷ Total crew hours = Compare plants per hour across crews completing the same task.
Related articles