The Employee Work Done and Recoveries report is a multi-focus report that conveys time and invoice data for the period by employee.
The report includes a breakdown of Total Hours, Hours At Work, Billable Hours and Productivity on Total Hours, plus Productivity on Hours At Work and the Fee Value of time – for all employee timesheets for the selected period.
It also shows a breakdown of all Hours Invoiced by employee, and the Fees Invoiced and Payments Received – for all invoices with employee time for the selected period.
It’s often used in conjunction with the Assigned Time and Disbursements and Fees Earned reports.
How to generate the Employee Work Done and Recoveries Report
The Employee Work Done and Recoveries report can be accessed from the Management Analysis section in the reports page.
Go to Reports >> Performance Reports >>from the ‘Management Analysis’ section, click on ‘Employee Work Done and Recoveries’.
Select the required date range.
You can also optionally filter this report by Employee Office and EmployeeTeam, and choose to display values as charge or cost rates
Choose Print or Preview, and then select whether to view all employees or only current employees for the report period.
Understanding the data
Work Done vs Recoveries
The report compares the value of work recorded (timesheet entries) with the amount recovered through invoicing and payments. It helps you assess how much of each employee’s or project’s time has been billed, and how much income has been realised from that work.
- Work Done is the chargeable value of timesheet entries — calculated by multiplying the number of hours or units recorded by the applicable charge rate.
- Recoveries represent the portion of that work which has been invoiced and/or paid. This includes:
- The invoiced value allocated to timesheet lines (based on how much of each invoice relates to time-based work), and
- Any payments received, proportionally distributed across the timesheet lines based on their value.
Employee Work Done: Total Hours
Total Hours are the hours worked for the period for the named employee, these correlate to any report that includes timesheet entries and do not include any units relating to disbursements.
This is all hours including billable client work, non-billable work such as admin, and also includes time that is ‘not at work’ such as leave.
This is the baseline for productivity analysis.
Employee Work Done: Hours At Work
This is the portion of Total Hours that is classified as productive time (i.e. Hours At Work), excluding time logged to personal or leave time, productive time for the report period. At work hours can also include time in meetings, office administration and tendering for work.
Read more about how time can be measured as at work or not at work here.
Employee Work Done: Billable Hours
This is the portion of Total Hours that is classified as billable time (i.e. Chargeable time) for the report period. Also known as Productive or Recoverable time, it is work for any projects marked as ‘Billable’ in Abtrac.
This would typically exclude any leave, personal and administrative work.
Read more about how billable and non-billable jobs are set up here.
Employee Work Done: Productivity on Total Hours
Productivity on Total Hours shows the percentage of Total Hours spent on Billable work (Recoverable jobs)
Productivity on Total Hours % = (Billable Hours – Total Hours) x 100
A lower percentage here may indicate a high proportion of internal/administration or personal time.
Employee Work Done: Productivity on Hours At Work
This is a refined productivity measure showing how much of the Hours ‘At Work’ were spent on Billable work (Recoverable jobs).
Productivity on Hours At Work = (Billable Hours ÷ Hours At Work) × 100
This figure excludes time logged to jobs ‘not at work‘, making it a more focused view of billable efficiency.
Employee Work Done: Fee Value
This is the total value of all recoverable work logged by the employee, based on their charge or cost rate — whether or not it has been invoiced yet.
Fee Value = Total Hours x Charge/Cost rate
It represents the total potential revenue earned by the employee’s time entries during the reporting period.
Fee value is calculated based on the timesheet line charge or costs rates, and not the default rates from Administration > Employees > Employee details.
Read about variable charge rates for employees here
Employee Work Done: Hours Invoiced
These are the hours worked for the period, that have also been assigned to an invoice within the same date period.
To analyse the hours invoiced within the report period you will need to have an understanding of your company rules for WIP assigned dates.
Read about Hours Invoices – WIP Assigned dates here
You can see the Employee Hours worked from the Assigned Time and Disbursements report, by ensuring that both the Timesheet dates, Invoice dates and WIP Assigned dates all match the Employee Work Done and Recoveries report period.
Read more about the Assigned Time and Disbursements report here
Employee Recoveries: Fees Invoiced
Fees invoiced is the value of all employee work that was assigned to an invoice during the report period. The Fees invoice value is calculated using the Fee Contribution method for your subscription.
You can read more about Fee contributions here
Whilst other values in this report focus on employee work and timesheets within the report period, Fees invoiced shows the fee contribution amount (invoiced pro rata value) for all employee work assigned to all invoices for the report period, regardless of timesheet date.
This metric is linked to the report dates by when the work was set as billed/assigned to an invoice.
You can see the fees invoiced total from the Fees Earned by Employee Project and Invoice report, and also the Assigned Time and Disbursements report from the Invoice fee contribution column (looking at Ordinary time only).
Read more about the Fees Earned by Employee Project and Invoice report here.
Employee Recoveries: Payments Received
Payments Received refers to payments earned — this figure is the same as Fee Contribution Earned. Just like Fees Invoiced, the value comes from the fee contribution associated with the payment.
Only payments with a payment date that falls within the report period are included, regardless of when the related invoice was issued. If the payment was received during the selected date range, its fee contribution is included in the report.
Why do the invoiced totals in Employee Work done and Recoveries not match other invoicing reports?
This report might vary from other reports showing invoice totals because it only contains invoices to which employee time has been assigned.
It might also vary with other reports if disbursements have been invoiced at a different invoice value to the amount at which they were entered into the disbursement entry screens.
Abtrac KB# 2028