This report is only available to firms on Aiwyn Practice.
What the employee performance report contains.
Tracks individual and firm-wide productivity — realization, utilization, target attainment, billing effective rate, and billable versus non-billable hours — with breakdowns by employee, office, service line, and client.
Report defaults
| Setting | Value |
|---|---|
| Default view period | Current calendar year |
| Default filters | Date: Current Calendar Year; Created by Aiwyn: Yes |
Hours on this report include both time entries and operational entries, in both Draft and Submitted status. Each KPI responds to its own date basis when you apply the date filter — the table below states the basis for every tile.
Tabs
| Tab | What it shows |
|---|---|
| Performance KPIs and Charts | Firm-wide KPI tiles and trend charts |
| Employee Insights | Performance, target attainment, and profitability by employee |
| Office Insights | Performance, target attainment, and profitability by office |
| Service Line Insights | Performance, target attainment, and profitability by service line |
| Client Insights | Performance, target attainment, and profitability by client |
Performance KPIs and Charts
KPI tiles
| KPI | Definition | Date basis (what the date filter applies to) |
|---|---|---|
| Realization Rate |
Percentage of billed time that is revenue after WIP adjustments | Invoice transaction date |
| Utilization | Percentage of total hours spent on billable work: billable hours ÷ total hours × 100, where total hours includes both time entries and operational entries | WIP logged date and operational timesheet entry date |
| Target Attainment |
Percentage of workable hours spent on billable work: billable hours ÷ workable hours × 100. Workable hours assume a 40-hour, 5-day week and are not adjusted for part-time schedules, PTO, or holidays. See the note below | Week start date (Monday) |
| Billing Effective Rate |
Average dollars earned per billable hour, weighted by hours logged | Invoice transaction date |
| Billable Hours |
Total logged billable hours | WIP logged date |
| Non-Billable Hours |
Total logged non-billable hours, including both time entries and operational entries | WIP logged date |
| Draft Hours | Total logged hours in Draft status, including both time entries and operational entries | WIP logged date |
| Submitted Hours |
Total logged hours in Submitted status, including both time entries and operational entries | WIP logged date |
Target Attainment is calculated weekly. The date filter includes whole weeks whose Monday start date falls within the selected range. Each employee has 40 workable hours for every week in which they logged time, including the current partial week. The calculation is not prorated for part-time schedules or adjusted for PTO or holidays, so part-time employees may appear to have lower attainment than their schedules warrant.
For an accurate result, set Created by Aiwyn to Yes only. With No, the result is 0 or blank. Selecting both Yes and No, or clearing the filter, overstates the result because non-Aiwyn billable hours are counted without additional workable hours.
Charts
| Chart | Type | What it shows |
|---|---|---|
| Earning Efficiency | Line | Pricing versus capture efficiency — "Are we earning enough per billed hour?" The Realization Rate line shows how much of standard billable value converts to revenue; the Effective Billing Rate line shows the dollar value of each billed hour. Based on the invoice transaction date |
| Time Allocation and Target Attainment |
Bar | Weekly time allocation and target attainment — "Are we putting enough hours on revenue-producing work, or do we have capacity?" Based on the WIP logged date; workable hours assume a 40-hour, 5-day week |
| Weekly Hours by Employee | Bar | Weekly hours for the year to date. Filter by employee to see one person's weekly hours |
Insights tabs
Each Insights tab has three tables. The Performance tables are based on the WIP logged date, Target Attainment uses the Monday week start date, and Profitability is based on the invoice transaction date. All three include both active and inactive records.
| Tab | Tables |
|---|---|
| Employee Insights | Performance by Employee (KPIs by employee); Target Attainment by Employee; Profitability by Employee |
| Office Insights | Performance by Employee Office (KPIs by office); Target Attainment by Office; Profitability by Employee Office |
| Service Line Insights | Performance by Service Line (KPIs by service line); Target Attainment by Service Line; Profitability by Service Line |
| Client Insights | Performance by Client (KPIs by client); Target Attainment by Client; Profitability by Client |
Table columns and default sort
| Table | Columns, in order | Default sort |
|---|---|---|
| Performance by Employee |
Employee; Employee Role; Employee Office; Billable Hours; Non-Billable Hours; Total Submitted Hours; Utilization; Operational Entry Hours; Total Time Off Hours; Total Hours; Time Entry Hours; Total Draft Hours; Total Draft Time Entry Hours; Billed Gross (NP); Billed Net (NP); Total WIP Adjustments; Employee Status; Firm | None |
| Target Attainment by Employee | Employee; Employee Role; Employee Status; Employee Office; Target Attainment; Firm | Target Attainment, descending |
| Profitability by Employee | Employee; Employee Role; Employee Status; Employee Office; Realization Rate; Billing Effective Rate; Firm | Realization Rate, descending |
| Performance by Employee Office | Employee Office; Utilization; Billed Gross (NP); Billed Net (NP); Total WIP Adjustments; Billable Hours; Non-Billable Hours; Time Entry Hours; Operational Entry Hours; Total Time Off Hours; Total Draft Time Entry Hours; Total Draft Hours; Total Submitted Hours; Total Hours; Firm | Utilization, descending |
| Target Attainment by Employee Office | Employee Office; Target Attainment; Firm | Target Attainment, descending |
| Profitability by Employee Office | Employee Office; Realization Rate; Billing Effective Rate; Firm | Realization Rate, descending |
| Performance by Service Line | Service Line; Utilization; Billed Gross (NP); Billed Net (NP); Total WIP Adjustments; Billable Hours; Non-Billable Hours; Time Entry Hours; Operational Entry Hours; Total Time Off Hours; Total Draft Time Entry Hours; Total Draft Hours; Total Submitted Hours; Total Hours; Firm | Utilization, descending |
| Target Attainment by Service Line | Service Line; Target Attainment; Firm | Target Attainment, descending |
| Profitability by Service Line | Service Line; Realization Rate; Billing Effective Rate; Firm | Realization Rate, descending |
| Performance by Client | Client; Client Number; Client Group; Client Status; Partner; Billing Manager; Partner Office; Utilization; Billed Gross (NP); Billed Net (NP); Total WIP Adjustments; Billable Hours; Non-Billable Hours; Total Draft Time Entry Hours; Time Entry Hours; Operational Entry Hours; Total Time Off Hours; Total Draft Hours; Total Submitted Hours; Total Hours; Firm | Utilization, descending |
| Target Attainment by Client | Client; Client Number; Client Group; Client Status; Client Partner; Billing Manager; Partner Office; Target Attainment; Firm | Target Attainment, descending |
| Profitability by Client | Client; Client Group; Client Status; Client Number; Billing Manager; Partner; Realization Rate; Billing Effective Rate; Firm | Realization Rate, descending |
Available filters
Date, Created by Aiwyn, Client, Client Number, Client Group, Client Status, Employee, Employee Role, Employee Status, Employee Office, Client Partner, Project Partner, Client Manager, Project Manager, Service Line, Entry Type, Entry Status, Billable, Code, Code Status, Firm.
Related
- Report reference
- Aiwyn KPI glossary
- Billing performance report reference
- Profitability report reference
- Who uses the employee performance report and what for