Aged WIP Report

Modified on Thu, 14 Sep, 2023 at 11:46 PM

The Aged WIP report provides a breakdown and summary options to view aged work in progress. The report displays values for fees and expenses (disbursements) that have yet to be billed. This is useful to see the amounts that can or will be billed in the future. The aged WIP report offers various filters and layout options to display the information that is most pertinent to your needs. This report shows the value of unbilled fees and expenses by a client, matter, matter type, responsible lawyer, and/or bill type.


Note: The report only shows the current unbilled WIP as at today's date. As an example, if I were to run the report on 5th August for the date ending 31st July - any WIP that has been billed between the 31st and the 5th will no longer show in the report. The best option for historical WIP reporting is to run the report at the end of every month to keep as a comparable.



Accessing the Aged WIP Report

The Aged WIP Report is located at Reports > Billing Reports > Aged WIP Report.


Filters


There are Basic options to quickly display report information. There are also Advanced options for more granular filters and layout options.


Basic

FilterDescription
Date range

This will set the range that the time/fee entries were created on.

For example, if you wanted to see the fee entries that were created in July but not yet billed you would enter 1 July in the first box and 31 July in the second


TimekeeperAllows you to narrow down the report to show a specific timekeeper or leave at default to show all timekeepers.
CurrencySelect the currency you wish to see the results for.


Layout options

Show matter summary - The report will include all the matters that have WIP entered within the date range that is still unbilled and will detail how much in fees and expenses are owed for each.

Show client summary - The report will include all the clients that have WIP entered within the date range that is still unbilled and will detail how much in fees and expenses are owed for each. 

Show firm summary - The report will include a section that will show all fees and expenses entered within the date range that are still unbilled.

Show timekeeper summary -The report will include all timekeepers that have WIP entered within the date range that is still unbilled.


Advanced

FilterDescription
Client

Only WIP for a matter where the nominated contact is the client will show in the report. 

You can add more than one contact to include WIP for matters where either of the contacts is the client.


Responsible lawyer

Only WIP for a matter where the nominated contact is the responsible lawyer will show in the report. 

You can add more than one contact to include WIP for matters where either of the contacts is the responsible lawyer.


Matter type

Only WIP for matters of the nominated type will show in the report.

You can add more than one matter type at once.


Matter

Only WIP for the nominated matters will show in the report. 

You can add more than one matter to include WIP from any of the matters.


Billing arrangement

Only WIP entered against matters that are set to the nominated Billing arrangement will be included in the report. 

You can select more than one type.


Bill behavior

Only WIP entered with the nominated Billing arrangement will be included in the report. 

You can select more than one behavior.


Include inactive/closed mattersWhen switched on, any matter that is inactive or closed but has unbilled WIP on it will be included in the report.
Inculde entries confirmed as non-billableWhen switched on, any time/fee entries that have been entered as non-billable will still be included in the report. 


Layout options

Show matter type summary - When switched on, the report will include a section that will show the WIP broken down by what type of matter it is associated with. 

Show responsible lawyer summary - When switched on, the report will include a section that will show the WIP broken down by the responsible lawyer for the matter it is associated with.

Show bill type summary - When switched on, the report will include a section that will show the WIP broken down by the Billing arrangement type for the matter it is assigned to.



Note: It is not possible to change the date groups of the report. These date groups are preset and cannot be adjusted.


Output




OptionDescription
On screen (HTML) 
This option displays the report results on your current screen
PDFThis option launches a print dialog from a PDF version of the report. To download as PDF, select Save as PDF in the Print > Destination dropdown on the print dialog screen.
MS Excel 
This option downloads an xlsx, MS Excel, file to your computer. This is a great option to perform further calculations in a spreadsheet format.
Save XLSX file to a matter 

After you have selected to run the report in MS Excel you can choose to save the XLSX file directly to a matter.

Save PDF file to a matter

After you have selected to run the report in PDF you can choose to save the PDF directly to a matter.








Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article