Crew & Client Reports

Crew & Client Reports

NexusRMS provides detailed reporting for both crew performance and client activity, helping you understand workforce efficiency and client value at a glance.

Crew Reports

Access crew reports from Analytics > Crew Reports. All crew data is pulled from verified time clock entries with GPS confirmation.

Hours Worked

• Total Hours — aggregate hours across all crew members for the selected period
• By Crew Member — individual breakdown showing regular hours, overtime hours, and total
• By Project — hours allocated to each project, useful for cost tracking
• Overtime Breakdown — hours exceeding the configured weekly threshold, with overtime cost impact calculated against each crew member’s rate

Overtime Analysis

The overtime analysis report highlights crew members who have exceeded their standard hours threshold. It includes:

• Total overtime hours per crew member
• Overtime cost impact (calculated from the crew member’s overtime rate)
• Trend comparison against the previous period
• Projects contributing most to overtime

Scheduling Efficiency

Compare planned versus actual hours to measure scheduling accuracy:

• Planned Hours — total hours scheduled across all assignments
• Actual Hours — total hours logged via the time clock
• Efficiency Percentage — ratio of actual to planned (closer to 100% is better)
• Variance — difference between planned and actual, flagged when exceeding 10%

Certification Compliance

Track crew qualification status across your organisation:

• Expiring Soon — certifications due to expire within 30 days
• Expired — certifications that have already lapsed
• Renewal Rates — percentage of certifications renewed on time
• Crew members with expired certifications are blocked from booking until renewed

Performance Ratings

Average ratings are calculated across five dimensions:

1. Punctuality — based on time clock check-in data versus scheduled start
2. Quality — rated by project managers post-event
3. Communication — responsiveness and clarity
4. Teamwork — collaboration and reliability
5. Overall — weighted average of all dimensions

Time Clock & GPS Verification

All time entries are captured via the GPS-verified time clock. Each entry records the crew member’s location at check-in and check-out, ensuring accurate on-site attendance. Entries flagged as outside the project geofence are highlighted for review.

Timesheet Export

Export crew timesheets in PDF, Excel (XLSX), or CSV format. Exports include crew member name, project, date, check-in time, check-out time, total hours, overtime hours, and GPS verification status.

Client Reports

Access client reports from Analytics > Client Reports or from the Analytics tab on any individual client record.

Client Analytics Tab

Each client’s detail page includes an Analytics tab displaying four key metrics:

Metric	Description
Total Revenue	Cumulative revenue from this client, with growth percentage versus the previous period
Total Projects	Number of projects, with a count of currently active projects
Average Project Value	Mean value across all completed and active projects
Health Score	Dynamic score with colour coding: green (80–100), orange (60–79), red (below 60)

A Revenue Over Time bar chart is displayed below the metrics, showing monthly revenue for the selected date range.

Client Ranking & Trends

• Revenue Per Client — ranked table with trend arrows (up, down, stable)
• Client Retention Rate — percentage of clients with repeat bookings within the last 12 months
• Booking Frequency — average number of bookings per client per quarter
• Client Lifetime Value — projected total revenue based on historical booking patterns and retention rate
• Top Clients — ranked by total revenue, filterable by date range

Using Client Reports

Client health scores help you prioritise relationship management. Focus on clients scoring below 60 (red) to identify at-risk accounts. Clients with declining booking frequency or shrinking average project value may benefit from proactive outreach.