The Client Realization Report provides a detailed breakdown of revenue by category, type, and billing method, comparing:
- Billed Revenue – How revenue was originally invoiced.
- Realized Revenue – What was actually earned based on work performed.
This report is particularly useful for analyzing fixed-fee revenue items, tracking revenue distribution, and assessing financial performance.
Key Features:
Revenue Breakdown – Displays revenue based on predefined categories (e.g., billable expenses) but does not factor in realization based on actual time worked.
Customizable Views – Filter by date range, group by fields, and run reports for deeper insights.
Billing-Triggered Data – Data appears only after time is billed and an invoice is created.
How to Access the Report:
- Navigate to View Reports in the black left-hand ribbon. (Note: Only users with the Reporting role can access this section.)
- Click Client Realization Report in the bottom left corner of the Analysis block.
- Select the Revenue tab.
- Choose your date range and group by fields, then click "Run Report" to generate the data.
This report helps firms track revenue trends, analyze profitability by service type, and optimize financial planning.
The Column calculations explained:
- Billable = hours worked and invoiced.
- Produced = hours * hourly rate of the service or hourly rate of the user. These rates are found in the customizations -> billable types section.
- Realized = includes realization plus any billable expense(billable item) unrelated to time worked. These items could be any sort of fixed amount fee(QBO host fee, extension filing fee, milage, or postage).
- Write-Up/Down = Realized - Produced
- Write-Up/Down % = (Realized - Produced / Produced) x 100
If you have cost-enable in the Admin > Settings > Users > Track Costs for Realization for User and Expenses
Column Calculation with Cost:
The Column calculations with Cost explained:
- Billable = hours worked and invoiced.
- Produced = hours * hourly rate of the service or hourly rate of the user. These rates are found in the customizations -> billable types section.
- Realized = includes realization plus any billable expense(billable item) unrelated to time worked. These items could be any sort of fixed amount fee(QBO host fee, extension filing fee, milage, or postage).
- Write-Up/Down = Realized - Produced
- Write-Up/Down % = (Realized - Produced / Produced) x 100
- Staff Cost = User cost under Admin > User > Edit > Cost section
- Expense = Internal Cost Items
- Net Realized = Realized - Produced - Expense
- Net Profit = Realized - Staff Cost - Expense