Billing Realization Summary

This date range filter Instructs the report to focus solely on relevant activities within the specified date range. 

NOTE: The date range filter is dynamic, adjusting according to the type of transaction being analysed (including professional fees, invoices, adjustments, and receipts). 

The option allows users to filter results based on Billing Categories.

NOTE:

Results will be limited to matters assigned to any of the selected Billing Categories. Refer to this article on how to create and assign a Billing Category. 

Consists of three filters: 

1. Include Inactive Staff: 
   Yes: Include inactive Staff members in the 'Staff' list for selection. 
   No: Exclude inactive Staff members in the 'Staff' list for selection. 
   
   
2.  Attribute Work To:
   Staff: Refers to the staff member who performs the actual work as a fee earner. This applies when the staff member’s name is assigned to the entry within the professional fee window. 
   Staff Responsible: Refers to the 'Person Responsible' for the matter
   Staff Acting:  Refers to the 'Person Acting' on the matter.
   Originating Attorney: Refers to the Person 'Originating Attorney' on the matter.

3. Staff list for selection

   NOTE: When you change the selection for Include Inactive Staff (from Yes to No or vice versa), the Staff drop-down list will be updated accordingly.

NOTE:

The Attribute Work To and Staff filters collaborate to narrow down results associated with the selected staff member(s). The interaction between the two filters is as follows: 

• If you attribute work to 'Staff Responsible', 'Staff Acting', or 'Originating Attorney' and select Staff A from the 'Staff' drop-down list, the report will consider transactions created only on matters where Staff A assumes the selected role. 
• If you attribute work to 'Staff' and select Staff A from the 'Staff' drop-down list, the report will consider only transactions attributed to Staff A in Staff A's capacity as a fee earner (Staff).

Display figures inclusive or exclusive of tax.

The total number of Hours attributed to the staff member.

• Based on Time/Activity entries dated within the specified period that are attributed to the staff member. 

The total amount of billable professional fees attributed to the staff member for the specified period.

NOTE:

• This field includes all billable/billed professional fees dated within the specified period and excludes any entry that has been set to 'Not-Billable' as of today. 
• The amount is based on the original entry amount and may differ from the subsequently billed amount.

Displays the total amount of professional fees on Final invoices attributed to the staff member, prior to any adjustments. 

Displays the total amount of professional fees on Draft invoices attributed to the staff member, prior to any adjustments. 

Displays the aggregate amount of of ‘Final Billed’ and ‘Draft Billed’ for the staff member. 

NOTE:

'Final Billed', 'Draft Billed', and 'Total Billed': 

• The three fields only consider professional fees billed on invoices (Final or Draft) that are dated within the specified period.
  • Based on the transaction date of the relevant invoice. 
• Their amounts are based on the the relevant entry's billed amount, not the original amount. 

Adjustments made within the specified period to to professional fees billed. This typically results from invoice adjustments but can occur due to fee reallocations. 

• Only adjustments within the specified period will be captured by the report, based on the transaction date of an adjustment. 
• This field is only relevant to Final invoices. 
• Fee reallocations will only impact this field when the ‘Attribute Work to’ option is set to ‘Staff’ (fee earner). Otherwise, the report adopts a matter-oriented approach, where reallocating fees from one staff member to another results in no net change.

This indicator helps to assess the staff member's performance in converting work performed into billable amounts. It is calculated using the following formula: 

Percentage Invoice Realized=(Total Billed+Adjustments​) / Total Amount ×100

Reflects the total amount of payments received allocated to the professional fees that are attributed to the staff member for the specified period. 

NOTE: The report only includes payments received dated within the specified period.