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 is the value of all time-based worked payments recorded during the report period.
When an invoice includes both timesheet fees and disbursements, Abtrac calculates how much of the payment applies to time-based work using the following method:
Step 1: Calculate the Net Fee Value
This is the portion of the invoice related only to timesheet entries
Value of timesheets within an invoice (Net Fee Value)
Net Fee Value =Invoice Amount − Disbursement Value
Only timesheet lines are considered part of the Net Fee Value — disbursements (like travel costs or consultant charges) are excluded.
Step 2: Distribute the Net Fee Payment Proportionally
The Net Fee Value is then distributed across timesheet lines in proportion to their individual value compared to the total timesheet work on the invoice.
Each timesheet line’s share is calculated using:
Employee Payments Received = (This line’s timesheet value / Total timesheet value) × Net Fee Value
If the invoice total is $10,000 and $2,000 of that is disbursements:
- The Net Fee Value is $8,000
- A timesheet line worth $2,000 would receive:
($2,000 ÷ $8,000) × $8,000 = $2,000
This calculation is unique to this report and ensures each timesheet line (e.g. staff time) gets its fair share of any payments received.
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