Rocket Matter Knowledge Base Reports'I want to see the allocation for all payments received during a time period' Report Key

'I want to see the allocation for all payments received during a time period' Report Key

This report will only display invoices that have payments attached. If an invoice and its activities are unpaid, it will not appear in the results set. Upon making a payment within the filter criteria, the invoices will appear.

Costs will always be paid off first. If an invoice was processed with $100 in costs and $100 in fees, and a $100 was made; the costs will be paid off before any funds are allocated towards fees. Once all costs have been paid off, payments will be allocated evenly across fees. This allocation amount is weighted by activity amount, meaning a larger activity will receive more of the payment. 

Summary Totals

Total Payments: This value represents the total amount of payments collected towards invoices that meet the filter criteria. This amount will factor in trust transfers, credit adjustments, and payments made directly to an invoice. Payments made to operating when a negative matter ledger balance exists will be applied to the invoice and thus will be factored into this calculation.

Filters

Start Date & End Date: This filter will scope the report to payments received between the given date range. This report is based around the payment date and disregards the invoice processed date. 

Billing User: This filter will scope the report to the billing user per activity. This allows users to see exactly how much activity an individual collected per invoice. 

Client: This column displays the client's name in which the payments and corresponding activities belong to. 

Group By Attorney: By default, this filter will separate each invoice by the activity’s billing user. The second option allows users to break apart payments by primary attorney. If the invoice was processed without a primary attorney, the activities are grouped into a “No Primary Attorney” category. The third option allows users to break apart payments by the originator. If no originator was assigned to the client, the activities are grouped into a “No Originator” category. 

Currency: This filter will limit the results to the client’s invoices that have the specified currency set.

Report Columns

Billing User, Primary Attorney, Originator: This column displays the selected grouping filter. Depending on the option selected, this column will group the result set accordingly. 

Invoice Date: This column displays the date the invoice was processed.

Invoice Amount: This column displays the invoiced processed amount. This column amount is not affected by any trust transfers, credit adjustments, or payments. 

Client: This column displays the client's name in which the matter belongs to. 

Matter: The matter name.

Originator: This column displays the originator for the matter. If no originator was assigned to the client, the field will display “No Originator”.

Primary Attorney: This column displays the primary attorney for the matter. If no originator was assigned to the matter, the field will display “No Primary Attorney”.

Type: This column displays the activity type. 

Description: This column displays the billing description. 

Billing Date: This column displays the activity’s billing date. This date can be different than the invoice date.

Units: This column displays the billing units for the activity. If the activity was a flat fee or expense (does not contain billing units), the field will be blank. 

Rate: This column displays the effective billing rate for the activity. This column will reflect custom rates set at the client level or within the activity modal.

Activity Amount: This column displays the total activity amount. 

Payments: This column displays two aggregate totals. The first being payments per grouping (billing user, primary attorney, originator) and the second being payments per invoice. This column also displays the payment allocation for each individual activity.

Percentage: This column displays the allocation percentage per activity. This column will never show aggregate totals per invoice or grouping.