Fee Recovery Report

In this article:

• Brief Description  
• Use Cases 
• Finding and Using the Report
• Available Filters
• Report Output
• Additional Notes

Brief Description  

This report shows a summary of actual, billable, billed hours, and amounts group by matter or participant with date and assigned-to filters.

Use Cases 

This report is used to determine the fees recovered (invoiced) against expected recovery over a set period – showing any  discrepancies between users billing rates and what was billed. It is not a record of time entry for the period – it only shows recovery on invoices for the period.  

Finding and Using the Report

• In Actionstep, go to Reports > Matter Reports > Time Billing.

Then, refer to these articles for help generating and saving reports for future use:

• Reporting Overview
• Generating a Report
• Saving a Report Configuration

Available Filters

• Invoiced From / To: Choose the date range for the hours billed.   
• Draft Invoices: Choose how invoices that have not yet been approved will be shown in the billed or the unbilled figures.   
• View By Participant / Matter Name: Toggle this option to on to show the information by matter or by participant.   
• Hide/Show Columns: Click this to include (or exclude) the different columns in the table. There are two lists—one for viewing Participants and one for viewing Matters (or Actions).   

Report Output

• Actual Hours: Shows the actual hours attributed to tasks picked up in the invoicing*, entered either through the timesheet or in tasks. (*This is the invoice period, not the time entry period.)   
• Billable Hours: Shows the portion of invoiced hours entered as billable. This may vary from the actual time as these are separate fields for entry. It is quite common to have a different value here.   
• Amount Billed: Shows the value invoiced in relation to the task. (This will recognize value adjustments on the invoice.) 
• Expected Recovery: Shows the actual hours multiplied by the participant rate on the rate sheet. 
  NOTE:  If the participant has no defined rate sheet, this figure will be distorted. If the matter has a rate sheet override on this rate sheet, it will pick that up in the expected recovery. 
• Write Off: Shows the expected recovery less billable hours multiplied by the task rate. So, if the time had been invoiced at $0.00 it would show as a write off.
• Variance: Shows the expected recovery less the amount invoiced. For example, if a user enters more billable time than their actual hours, the variance will be a negative value.    
• Recovery %: Shows the invoiced amount / expected recovery.   
• Unbilled Hours: Shows the billable hours remaining to be invoiced from the period. This is not an "as at" calculation. If you are running this report at a date past the period and have subsequently invoiced the hours entered in the period, they will not be included.   
• Unbilled Dollars: Shows the unbilled hours multiplied by expected recovery rate. 

Additional Notes

If a user never uses any rate other than the expected task rate, and if they never charge more hours than worked, you would typically not see any variances where the report is run after billing.