The Billability per employee report shows how much billable value each employee logs, how that compares to the productivity target, and what remains as the bottom-line result. Billability varies per employee — especially when internal work is also carried out. This report helps you maintain a healthy balance.
What to manage
Use this report to manage billability and productivity per employee:
Balance of billable and internal — see at a glance who logs a high billable value and who is mostly occupied with internal work.
Senior on junior work — if a senior employee is doing a lot of junior work, you'll see this reflected in a lower billable value than expected.
Target per employee — if an employee has a productivity target, you can immediately see whether it is being met.
Value and percentage — an employee can be 100% billable and still miss the revenue target (due to a lot of junior work). Displaying percentages gives you a handle on this.
You can click through to an employee to view totals and trends per employee.
Report structure
At the top is the filter bar; below it is a totals block (Total), the Billable hours trend chart, the Total billable chart, the Result on billable hours chart, and the Detail view (the table).
Billable hours trend
This chart shows the billable value per week (excl. corrections) as a bar, with the productivity target (value) as a trend line alongside it. This lets you see how billability develops over time relative to the target. Use the toggle at the top right to switch between euros (€) and percentage (%).
Total billable
This chart compares the billable value (excl. corrections) per employee against the productivity target (value). If an employee is below the target, you can see this immediately. Here too, use the toggle at the top right to switch between € and %.
Result on billable hours
This chart shows the result on billable hours per employee: the billable value minus the cost price of the direct hours. This shows who generates margin at the bottom line and whose cost price eats into the billable value.
Detail view
The table shows the figures per employee. Use Columns to choose which columns are visible, and use Export to download the data.
Table columns
KPIs
KPI | Explanation |
Billable hours | The number of billable hours logged in the period. |
Scheduled hours | The scheduled hours in the period, minus logged leave. |
Billability | Billable hours divided by available hours, as a percentage. |
Billable | The billable value in euros. |
Cost price of direct hours | The cost price of the direct (billable) hours. |
Result | Billable value minus the cost price of the direct hours. |
Result (percentage) | The result as a percentage of the billable value. |
Dimensions
Employee
Filters
The filter bar at the top defines the scope of the report. Use Add filter to add extra filters; use Reset filters to clear everything. Status defaults to active (active employees only).
Dimensions
Period
Team
Manager
Employee
Status
Save view
Once you have set the filters and columns to your preference, save the view using Save view. In addition to the default view, you can quickly switch to your saved views.
How the values are calculated
Billability
Billability indicates what portion of the available hours were logged as billable:
Number of billable hours logged in the period
──────────────────────────────────── × 100%
Scheduled hours − leave
Example: if someone has a 40-hour weekly schedule and logs 8 billable hours, their billability is (8 / 40) = 0.20 × 100% = 20%.
The total equals this main formula; for the trend, the calculation is done per week/month so you can see how the percentages develop over time.
Productivity
Productivity looks at direct hours (hours logged on a billable project):
Direct hours (logged on a billable project)
──────────────────────────────────── × 100%
Scheduled hours − logged leave hours
If productivity and billability diverge, this is usually due to hours logged against a client that were subsequently corrected, or hours on a non-billable hour type within a time and expenses service.
Example: if someone has a 40-hour schedule and logs 32 hours on a client — those are 32 direct and 32 billable hours. If 8 hours are subsequently written off, 32 direct and 24 billable hours remain: 80% productive and 60% billable.
Productivity target (value)
The target value is determined by the productivity target set on the employee's schedule:
The number of hours an employee is expected to work according to their schedule in the period × the selling rate on the employee's schedule × the productivity target in %.
Already-registered leave hours are not included in this calculation.