Fee Allocation Report

 

Overview

The Fee Allocation Report displays payments and their timekeeper allocations from a specified date range. This is useful to see the value of work completed by each fee earner. The report includes filters and summaries by various criteria to offer the best information for your reporting needs.

Fee allocation is initially reflected in the bill on the 'Fee Allocation' tab.

When a payment is received, the fee allocation amount is attributed to the designated fee earner(s). The fee allocation figures on the report reflect the allocations from bill-payment client receipts.

 

Accessing The Fee Allocation Report

The Fee Allocation Report is located in Reports > Billing Reports.

Report Configuration Options

The Fee Allocation Report has Basic and Advanced configuration options to control and filter the display of information on the report. 

Basic filters

Period

Provides options for a range of dates. This will control which items are used in the report figures. The only payments that will be considered on the report are payments dated between the first and second selected dates. There are multiple default options for date ranges which can be selected in the Period dropdown. Custom period Uses the date picker fields to define the start and end dates of the included report items. Month to date From the beginning of the current month to today's date. Last month From the first to last day of the previous month. This calendar year From January 1st to December 31st of the current year. This calendar year to date From January 1st to the current date. Last calendar year From January 1st to December 31st of the previous year. Last calendar year to date From January 1st of the previous year to the current month and day of last year. This financial year From the financial year start date for your system to one year after. This financial year to date From the financial start date for your system to the current date. Last financial year From the financial start date for your system for last year one year after. Last financial year to date From the financial start date for your system for last year to the current month and day of the year on which that financial year ends. Everything to date Everything in the system to the current date. Everything Everything, including future-dated items, in your system.

 

Advanced Tab

The filters will filter down the results of the report. The filters chosen will mean that any result that does not meet those filters will be excluded. 

The filters will combine. For example, if you filter by the Matter Type 'DUI' and Allocated to 'Brian Jones', only matters that are DUI matters that are assigned to Brian will show. 

Responsible lawyer	Filters report to only show information for matters where the selected user is the responsible lawyer. Multiple responsible lawyers can be selected.
Client	Filters report to only show information for matters where the selected contact is the client. Multiple clients can be selected.
Matter	Filters the report to only display information from the selected matter(s).
Matter type	Filters report to only show information for matters of the selected type(s).
Invoice Number(s)	Allows a specific invoice to be designated for report information. Only information from the selected invoice will be included in the report results.
Allocated to	Allows a specific allocation recipient to be designated for report information. Only information from the selected allocation recipient will be included in the report results.

Layout options

The Layout options set how the report will display the informaiton within it. 

Show detail	Controls the display of specific payment and allocation details. Without the 'Show detail' toggle set to 'On,' only summary tables can be displayed.
Show matter type summary	When this option is selected, a table is displayed that sums fees, expenses, and totals per matter type.
Show responsible lawyer summary	When this option is selected, a table is displayed that sums fees, expenses, and totals per responsible lawyer.
Show allocated to summary	When this option is selected, a table is displayed that sums fees, expenses, and totals per fee credit lawyer.   NOTE 'Fee credit lawyer' is the term for the user to which a payment or portion of a payment is allocated. They may also be referred to as the timekeeper or allocation recipient.
Show client summary	When this option is selected, a table is displayed that sums fees, expenses, and totals per client.
Group by detail	Effects the source of the detail tables. This option allows the detail tables can be grouped by the following: Allocated to A table is displayed for each fee earner. Payment date A table is displayed for each date in the designated Period. Payment (default) A table is displayed for each deposit. Matter A table is displayed for each matter. Matter type A table is displayed for each matter type. Responsible lawyer A table is displayed for each responsible lawyer.

Producing the Fee Allocation Report

On Screen (HTML)	Displays the report on the current screen.
PDF	Downloads the report in PDF format.
MS Excel	Downloads the report is xlsx format.

 

Understanding the Output of the Fee Allocation Report

Output Options (On Screen Only) and Header Information 

Reload	This button will re-generate the report. This can be useful if changes are being made while viewing the report to see the difference between before and after the changes.
Print	This will launch your browser's print dialogue. The behavior and display of the dialogue are dependent upon your browser and workstation settings.
Excel	Downloads the report in xlsx format.
PDF	Downloads the report in PDF format.
Show settings button	Displays the configuration options for the report. Once displayed, the configuration options can be hidden by selecting the Hide settings button.
Period	Displays the 'Period' date range, selected in the configuration options, for information displayed on the report.
Group detail by	Displays the 'Group detail by' option selected in the configuration options.
Layout options	Displays which layout options have been selected in the configuration options.
Generated stamp	Displays the name of the user who generated the report, as well as the date and time the report was generated.
Additional header information	Additional filter information will be displayed in the header when the options are selected. This information can include: Responsible lawyer  Client                     Matter                          Matter Type            Allocated to

 

 

Column Definitions

Detail Tables

NOTE

The information displayed in the detail table is dependent upon the Group detail by configuration option. You can skip ahead to a particular 'group by' by using the links below.

• Group detail by - Payment (default)
• Group detail by - Allocated to
• Group detail by - Payment date
• Group detail by - Matter
• Group detail by - Matter type
• Group detail by - Responsible lawyer

 

Group detail by - Payment (default)

When grouped by Payment, each table reflects the information attributed to a single payment.

Header	The title denotes the 'Deposit' transaction type, as well as the receipt number.
Payment date	The payment date reflects the date the payment was received as entered on the client receipt. NOTE This is not the date the payment was entered into the system.
Payment method	The payment method as entered on the client receipt.
Payment reference	The payment reference as entered on the client receipt.
Matter ID/Name	The matter ID and matter name for the associated table row information.
Client	The name of the client participant on the matter in the table row.
Matter Type	The type of matter for the matter listed on the same table row.
Responsible Lawyer	The name of the responsible lawyer party for the associated matter.
Inv No.	The number of the invoice associated with the table row information.
Fee Credit Lawyer	The names of any participants to whom fees have been allocated.
Fees	The value of fees received for the specified fee credit lawyer for the given deposit.
Exp.	The value of expenses received for the specified fee credit lawyer for the given deposit.
Total (column)	The sum value of fees and expenses allocated from the associated deposit to the specified fee credit lawyer.
Totals (row)	Sum of Fees, Expenses, and Total columns.

Group detail by - Allocated to

When grouped by Allocated to, each table reflects information attributed to a single fee earner. 

Header	The title denotes the fee credit lawyer by name.
Matter ID/Name	The matter ID and matter name for the associated table row information.
Client	The name of the client participant on the matter in the table row.
Matter Type	The type of matter for the matter listed on the same table row.
Responsible Lawyer	The name of the responsible lawyer party for the associated matter.
Payment	Denotes the transaction as a deposit and provides the receipt number.
Payment Date	The payment date reflects the date the payment was received as entered on the client receipt. NOTE This is not the date the payment was entered into the system.
Inv No.	The number of the invoice associated with the table row information.
Fees	The value of fees allocated to the specified fee credit lawyer for the associated deposit.
Exp.	The value of expenses allocated to the specified fee credit lawyer for the associated deposit.
Total (column)	The sum value of fees and expenses allocated from the associated deposit to the specified fee credit lawyer.
Totals (row)	Sum of Fees, Expenses, and Total columns.

Group detail by - Payment date

When grouped by Payment date, each table reflects information for deposits from a single date. 

Header	The title denotes the date for the table information.
Matter ID/Name	The matter ID and matter name for the associated table row information.
Client	The name of the client participant on the matter in the table row.
Matter Type	The type of matter for the matter listed on the same table row.
Responsible Lawyer	The name of the responsible lawyer party for the associated matter.
Payment	Denotes the transaction as a deposit and provides the receipt number.
Inv No.	The number of the invoice associated with the table row information.
Fee Credit Lawyer	The names of any participants to whom fees have been allocated.
Fees	The value of fees received for the specified fee credit lawyer for the given deposit.
Exp.	The value of expenses received for the specified fee credit lawyer for the given deposit.
Total (column)	The sum value of fees and expenses allocated from the associated deposit to the specified fee credit lawyer.
Totals (row)	Sum of Fees, Expenses, and Total columns.

Group detail by - Matter

When grouped by Matter, each table reflects information attributed to a single matter. 

Header	The title denotes the name of the matter and matter ID in 'Matter Name (Matter ID)' format.
Matter type	The type of matter for the matter listed on the same table row.
Responsible lawyer	The name of the responsible lawyer party for the associated matter.
Client	The name of the client participant on the matter in the table row.
Payment	Denotes the transaction as a deposit and provides the receipt number.
Payment Date	The payment date reflects the date the payment was received as entered on the client receipt. NOTE This is not the date the payment was entered into the system.
Inv No.	The number of the invoice associated with the table row information.
Fee Credit Layer	The names of any participants to whom fees have been allocated.
Fees	The value of fees received for the specified fee credit lawyer for the given deposit.
Exp.	The value of expenses received for the specified fee credit lawyer for the given deposit.
Total (column)	The sum value of fees and expenses allocated from the associated deposit to the specified fee credit lawyer.
Totals (row)	Sum of Fees, Expenses, and Total columns.

Group detail by - Matter type

When grouped by Matter Type, each table reflects information attributed to a single matter type. 

Header	The title denotes the Matter Type for the table information.
Matter ID/Name	The matter ID and matter name for the associated table row information.
Client	The name of the client participant on the matter in the table row.
Responsible Lawyer	The name of the responsible lawyer party for the associated matter.
Payment	Denotes the transaction as a deposit and provides the receipt number.
Payment Date	The payment date reflects the date the payment was received as entered on the client receipt. NOTE This is not the date the payment was entered into the system.
Inv No.	The number of the invoice associated with the table row information.
Fee Credit Lawyer	The names of any participants to whom fees have been allocated.
Fees	The value of fees received for the specified fee credit lawyer for the given deposit.
Exp.	The value of expenses received for the specified fee credit lawyer for the given deposit.
Total (column)	The sum value of fees and expenses allocated from the associated deposit to the specified fee credit lawyer.
Totals (row)	Sum of Fees, Expenses, and Total columns.

Group detail by - Responsible lawyer

When grouped by Responsible lawyer, each table reflects information from invoices associated with matters where the table header party is the responsible lawyer.

Header	The title denotes the name of the responsible lawyer to whom the table information is attributed.
Matter ID/Name	The matter ID and matter name for the associated table row information.
Client	The name of the client participant on the matter in the table row.
Matter Type	The type of matter for the matter listed on the same table row.
Payment	Denotes the transaction as a deposit and provides the receipt number.
Payment Date	The payment date reflects the date the payment was received as entered on the client receipt. NOTE This is not the date the payment was entered into the system.
Inv No.	The number of the invoice associated with the table row information.
Fee Credit Lawyer	The names of any participants to whom fees have been allocated.
Fees	The value of fees received for the specified fee credit lawyer for the given deposit.
Exp.	The value of expenses received for the specified fee credit lawyer for the given deposit.
Total (column)	The sum value of fees and expenses allocated from the associated deposit to the specified fee credit lawyer.
Totals (row)	Sum of Fees, Expenses, and Total columns.

 

Matter type summary table

Displays a row for each matter type where matters of that type have received payments for invoices to create allocations.

Matter Type	Each item in the Matter Type column is the name of a matter type to which fees and/or expenses have been allocated. The subsequent columns are associated with the matter type in this column.
Fees	The value of fees from invoices attributed to matters of the associated matter type.
Exp.	The value of expenses from invoices attributed to matters of the associated matter type.
Total (column)	The sum total value of paid fees and expenses for the given matter type.
Totals (row)	Sum of Fees, Expenses, and Total columns.

 

Responsible lawyer summary table

Displays a row for each responsible lawyer from matters in which payments have been collected to create fee allocations.

Responsible Lawyer	Denotes the name of the responsible lawyer associated with matters/invoices for which payments have been received.
Fees	The value of fees from invoices attributed to matters where the party specified in the first column is the responsible lawyer.
Exp.	The value of expenses from invoices attributed to matters where the party specified in the first column is the responsible lawyer.
Total (column)	The sum total value of fees from invoices attributed to matters where the party specified in the first column is the responsible lawyer.
Totals (row)	Sum of Fees, Expenses, and Total columns.

 

Allocated to summary table

Displays a row for each fee credit lawyer to which fees have been allocated.

Fee Credit Lawyer	Denotes the name of the party to whom fees have been allocated.
Fees	The value of fees where the specified fee credit lawyer was the allocation recipient.
Exp.	The value of expenses where the specified fee credit lawyer was the allocation recipient.
Total (column)	The sum total value of fees and expenses where the specified fee credit lawyer was the allocation recipient.
Totals (row)	Sum of Fees, Expenses, and Total columns.

 

Client summary table

Displays a row for each client party on matters in which payments have been collected to create fee allocations.

Client	Denotes the name of the client for the table row data.
Fees	The value of fees where the specified client was the billed party.
Exp.	The value of expenses where the specified client was the billed party.
Total (column)	The sum total value of fees and expenses where the specified client was the billed party.
Totals (row)	Sum of Fees, Expenses, and Total columns.