Purpose
To measure realization rates (the percentage of billable hours or amounts that are actually billed to clients) for each service item on a year-to-date basis. This provides insight into the efficiency and profitability of services delivered.
Visualization Type | Pivot Table |
Liveboard | Service Item Analysis |
Tab | This Year, Last Year |
Function | Billing |
| Includes |
Need-to-know Glossary of Terms
Service Item Name - Refers to the designation used to identify the specific service billed to the client.
Time Entry Hours - This is a measure of Time Entry Hours that have been billed.
Time Entry Billed Amount - This is the amount that has actually been billed from the time entry.
Invoice Date - The date listed on the invoice as Invoice Date.
Line Item Assignee - The name of the team member who logged the time associated with the line item.
Service Item Billed Amount formula - - Calculated by finding the sum of Time Entry Billed Amount.
group_aggregate ( sum ( Time Entry Billed Amount ) , query_groups ( ) , query_filters ( ) )Service Item Hours formula - Calculated by finding the sum of Time Entry Hours.
group_aggregate ( sum ( Time Entry Hours ) , query_groups ( ) , query_filters ( ) )Service Item Billed Rate formula - Calculated by taking the Service Item Billed Amount and dividing it by the Service Item Hours.
Service Item Billed Amount / Service Item HoursService Item Time Entry Billable Amount formula - Calculated by taking the sum of the Time Entry Billable Amounts.
group_aggregate ( sum ( Time Entry Billable Amount ) , query_groups ( ) , query_filters ( ) )Service Item Billable Rate formula - Calculated by taking the Service Item Time Entry Billable Amount and dividing it by the Service Item Hours.
Service Item Time Entry Billable Amount / Service Item HoursService Item Rate Adjustment formula - Calculated by taking the Service Item Billed Rate and subtracting the Service Item Billable Rate.
Service Item Billed Rate - Service Item Billable RateRealization % formula - Calculated by taking the Service Item Billed Rate and dividing it by the Service Item Billable Rate.
Service Item Billed Rate / Service Item Billable Rate
Report Structure Overview
Invoice Date - Filtered for invoices dated this year
Rows - Service Item Name
Expanded Row Level 2 - Line Item Assignee
Column - Service Item Hours
Column - Service Item Time Entry Billable Amount
Column - Service Item Billable Rate
Column - Service Item Billed Amount
Column - Service Item Billed Rate
Column - Service Item Rate Adjustment
Column - Realization %
Suggested Modifications
Prefer to see the full number amounts versus the abbreviated unit?
1. Navigate to the Configure panel on the right hand side.
2. Scroll down to the Values section and select one of the data points, for example, Billable Amount.
3. Select the option None under the Unit drop-down menu.
Primary Use Case Scenario
A Managing Partner reviews this report quarterly to compare realization across different service lines to see which services are most profitable and be able to evaluate whether certain service items have systematically lower realization.
Actionable Insights
dentification of underperforming service lines where low realization may be due to scope creep, inefficient processes, or underpricing.