Purpose
To evaluate the profitability of each client relationship breaking down the results by client name and team member. The report combines utilization, billing, adjustments, costs, and margins to provide a holistic of client-level financial performance.
Visualization Type | Pivot Table |
Liveboard | Billing Realization/Client Profitability |
Tab | By Client |
Function | Clients |
Filters | Excludes Archived Clients |
Need-to-Know Glossary of Terms
Client Name - Customer name, if a display name exists, that will be the primary search term. If there is no display name, first and last name will be displayed.
Line Item Billed Amount - This is the amount billed for the line item shown on the far right column of the invoice.
Time Entry Hours - This is a measure of Time Entry Hours that have been billed.
Time Entry Cost of Labor - Duration of time multiplied by user salary.
Time Entry Billable - This is the amount the time entry could be billed based on the current service/user rate. If the time entry has already been billed, this rate gets locked in place based on what the rates were on the invoice date.
Time Entry User Name - The name of the team member who logged the time associated with the line item.
Client is Archived - True if client is archived, false if it is not.
Realization % Formula - Calculated by taking the sum of the Line Item Billed Amount and dividing it by the sum of the Time Entry Billable Amount.
safe_divide(sum(Line Item Billed Amount), sum(Time Entry Billable))
Adjustment Formula - Calculated by taking the sum of the Time Entry Billable Amount and subtracting it form the sum of the Line Item Billed Amount.
sum(Line Item Billed Amount), sum(Time Entry Billable Amount)
Original Rate Formula - Calculated by taking the sum of the Time Entry Billable Amount and dividng it by the sum of the Time Entry Hours.
safe_divide(sum(Time Entry Billable), sum(time Entry Hours))
Actual Rate Formula - Calculated by taking the sum of the Line Item Billed Amount and dividing it by the sum of the Time Entry Hours.
save_divide(sum(Line Item Billed Amount), sum(Time Entry Hours))
Net Profit Margin (%) Formula - Calculated by taking the sum of the Profit Margin and dividing it by the sum of the Billed Amount.
safe_divide(sum(Profit Margin), sum(Billed Amount))
Profit Margin Formula - Calculated by taking the sum of the Time Entry Cost of Labor and subtracting it from the sum of the Line Item Billed Amount.
group_aggregate(sum(Line Item Billed Amount), query_groups(), query_filters()))
group_aggregate(sum(Time Entry Cost of Labor), query_groups(), query_filters)))
Report Structure Overview
Invoice is Archived Filter - Filtering to exclude invoices that have been archived.
Rows - Client Name.
Expanded Row Level 2 - Time Entry User Name.
Column - Realization %
Column - Billed Hours
Column - Billable Amount
Column - Billed Amount
Column - Adjustment
Column - Original Rate
Column - Actual Rate
Column - Cost of Labor
Column - Profit Margin
Column - Net Profit Margin %
Tips & Tricks: Prefer to see the full number amounts versus the abbreviated unit?
Navigate to the Configure panel on the right hand side.
Scroll down to the Values section and select one of the data points, for example, Billable Amount.
Select option None under the Unit drop-down menu.
Primary Use Case Scenario
Firm Leadership reviews this report quarterly to assess whether clients are profitable after factoring in labor costs and adjustments. It also allows for comparison of original rate versus actual rate to see if discounts, write-downs, or inefficiencies are impacting revenue.
Actionable Insights
Easily identify which clients generate strong margins and which ones erode firm profitability and provides data to support client pruning, repricing, or renegotiation.