Collections Report II

Report Overview

The Collections II report reflects payments collected toward each invoice and the users and their billable amounts per payment (payments must be applied to invoices to show up on the report). This enhanced collection report accounts for multi-matter invoices, breaks out late fees, and utilizes invoice discounts.

This report was built to help firms determine pay for attorneys but can have many more applications. Typically, attorneys are paid based on labor, not expenses, when a client has paid their invoice (vs when a client has been invoiced).  This report collects the data entered in Bill4Time (invoice totals, users, discounts, fees, payments, etc.) and calculates the percentage paid on the invoice belonging to a particular B4T user.  These calculations are only present in the report and do not appear anywhere else in B4T. 

Filter Options

Filter Date by:

Payment Date: This runs the report based on the day the payment was made. 

Payment Applied Date: This runs the report based on the day the payment was applied.

 In this example running a report by payment date with date filters March 18, 2024, through 03/28/2024 no results would appear, because the date of the payment is 03/14/2024.  However, with the same dates selected and “Payment applied date” enabled, the report will show the calculations for the payment below because the payment applied day is 03/25/2024.

Include Expenses: When this button is enabled, any expenses on the invoices included in the report will be reflected in the attributable amount for each user.  Enabling expenses reflects these as payable to users. 

Jake had a $75 expense on invoice 64378. By enabling “Include Expenses” his attributable amount is $603.85.  If Expenses are not included his attributable amount is $528.85.

Include Late Fees: When this button is enabled, any late fees on  invoices included in the report will reflect in the attributable amount for each user.  Enabling late fees reflects these as payable to users.

Include Credit Adjustments: When this button is enabled, any credit adjustments applied to the invoices included in the report will reflect in the attributable amount for each user.  Enabling credit adjustments will affect the user attributable amount.

Payments Apply to: Designates the order you would like the payments to be applied in to in the calculation of the report.  Collections II offers two options on payment application order.

Expenses and Late Fees First: The report will be calculated based on the payment of expenses and late fees before labor, distributed proportionally. For instance, if there are $10 in late fees, $90 in expenses, and $100 in labor, and a payment of $10 is made, $1 will be allocated to late fees, $9 to expenses, and none to labor

Labor, Expenses and Late Fees Evenly: The report will calculate by evenly distributing payment between labor, expenses and late fees, distributed proportionally. For example, if there are $10 in late fees, $90 in expenses, and $100 in labor, and a payment of $10 is made, $4.50 would be allocated to expenses and $5 to labor.

Show Summary Only: Enabling this only shows the totals lines of the report.