The Case Revenue Report in MyCase is an easy way to view what your cases have billed for a certain time period and then compare that to what your firm actually earned on those cases within the same time frame.
How to Track Your Case Revenue in MyCase
To access the Case Revenue Report, click the Reporting tab at the top of the screen. In the left-hand menu, click on 'Case Revenue Report'. To run the Case Revenue Report for the firm, simply click the blue Run Report button. You can filter the report by any date range and whether the case is closed, open or both.
Case Revenue Report Overview [VIDEO]
When creating a Case Revenue Report users have several options to choose from:
Select Date Range: Users can select any date range that they would like. The selected date range will be what is shown under the billed and collected sections. Billed entries are related to the date of the invoice. Collected amounts adhere to the date that the payment was made.
*Note: If no invoices or payments were made during the selected time frame, there will be no data to show.
Select Case Status: Users can elect to show all cases, only open cases or only closed cases.
Export Report: Users can export the report to both PDF or .CSV files.
The generated Case Revenue Report will show both billed and collected amounts during the time frame selected for each case at the firm.
Billed: Billed values are calculated using the invoices created within the provided date range. Income generated from requested funds are not included.
Collected: Collected values are calculated from the payment transactions (including refunds) made on invoices within the provided date range. It’s important to note that while a payment might be made within the date range, that payment might be for an invoice created outside of the date range.
Flat Fees: Sum of billed flat fees.
Hours: Sum of hours billed.
Time Entries: Sum of billed time entries.
Expenses: Sum of expenses.
Balances Forwarded: Sum of balance forwards.
Interest: Sum of billed interest.
Tax: Sum of billed tax.
Discounts: Sum of all discounts. Please note that any discounts will be shown as a negative collected amount, reducing the total amount collected by the firm.
Additions: Sum of additions. This includes additions made to specific invoice entries, (i.e. an addition on expenses and additions made to the invoice’s subtotal).
Totals will be shown in bold on the far right hand side of all columns in both sections.
When running the Case Revenue Report for a date range, the columns will be populated with entries based on the invoice date. For example, this report shows each amount below:
If an invoice is created and paid within the selected date range, collected amounts will show to right hand side of billed amounts.
How Are Collected amounts calculated?
Collect amounts are split evenly among categories based on the percentage of their billed amounts. In our example below, a collected amount of $1,000 during the same date range would appear like the following:
Since our total is $1,498.84 that means that our billed time entries are 59.045...% of the total billed. We take this percentage and apply that to the total collect amount for a collect total of $590.46.