Purpose
To evaluate the profitability of each service item (e.g., Tax Prep, Audit, Bookkeeping) broken down further by team member contributions. This helps leadership see not just how much revenue each service generates, but whether it is profitable after adjustments and labor costs.
Visualization Type | Pivot Table |
Liveboard | Billing Realization/Client Profitability |
Tab | By Service |
Function | Realization/Profitability |
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.
Service Item Name - Refers to the designation used to identify the specific service billed to the client.
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 - Service Item 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 %
Did You Know? This report includes the following conditional formatting rules:
Primary Use Case Scenario
Firm Leadership reviews this report during quarterly performance reviews to assess the financial performance of each service line and compare realization % and actual vs. original rates to see where discounts or write-offs erode profitability.
Actionable Insights
Leadership can use this report for strategic decision making when considering whether to reprice, restructure, or expand/contract certain service offerings.