.png){kind=spacer}
Fee Billed. Credited, Collected & Written-Off
Scope and Purpose
The purpose of this report is to provide visibility of the docket to collected cycle.
The scope of the report extends beyond providing measures for the lawyer or paralegal as working member (timekeeper) or role holder at the client or matter level, to other client, matter, or member level reporting dimensions.
Net fees billed are measured in context of worked value and billed value – allocated when executed by working member or in total when executed by role holder or without a member grouping; showing billing variances and fees credited.
As it is possible to allocate fees billed to someone that did not work them, this report includes both measures when executed by working member.
Highlights
The report has as the lowest level of detail the matter; therefore it will automatically summarize to the lowest reporting grouping dimension selected.
Executed using the working member as a reporting attribute the report will include shared as well as allocated fee billed measures. Executed by team or shared role holder, the report will split the variance and the fees credited into two separate measures as well as a total one.
These allocated measures are calculated in context of the allocation formulae applied during the invoice preparation process as well as any manual fee allocation modifications made to the native fee allocation value for the invoice any time thereafter.
Allocation schemes (formulas) are firm created and defined. Each firm has the potential for an unlimited number of allocation schemes, each comprised of one or more allocation rules which include non-timekeeper attributes. As a result, the working member bearing the allocated-to measure is not necessarily always the timekeeper that earned the credit work at standard rates. summarize to the lowest group level selected in the “details” tab.
When executed by matter without the selection of a client, the name columns will show the client and matter, but there will not be a client subtotal.
Fee Billed. Credited, Collected & Written Off Report
Access
From the main menu select “Reports – Management – Allocated Shared Fees Billed, Credited, Collected, Written-off – Fee Billed, Collected and Written-Off”.
The Preselect Tab
Select the date range for the reporting period.
The Details Tab
Keep the default grouping dimensions needed to support the level of granularity required for the report output, and un-select all others. If the report will include the member reporting dimension, consider whether the report is to be executed by role holder - for example the matter originating member; or by allocated-to (working) member, or other.
The classification TAB offers the possibility to group members by main classification and/or reporting classification or filter for a specific classification to limit results to the one reporting dimension.
Team Role Holder:
Executed by role holder at the client or matter level, the measures represent the total for the source object (Invoice, credit note, receipt or write-off) attributed to the client or the matter, depending on role level selected.
Shareable Role Holder:
Executed by role shareable holder at the client or matter level, the measures are calculated by multiplying the percentage attributed to the shared role holders in client or matter properties with the total for the source object (Invoice, credit note, receipt or write-off) attributed to the client or the matter.
Working Member:
Executed by working member, the shared measures are calculated as a pro-rata reflection of value-worked, and the allocated measures are based reflect the allocation formulae applied and any manual allocation overrides.
Use of Matter Without Client:
When executed by matter without the selection of a client, the name columns will show the client and matter, but there will not be a client subtotal.
The Additional Tab
The Additional Tab does not offer any additional reporting opportunities.
On “Run Report” the Page Breaks & Sort Order form is launched.
The Page Breaks & Sort Order form
Users can add a page break for a grouping dimension used, reset the page numbers after each break, and/or change the sort order presentation of grouping dimensions from numeric by code (123) to alphabetic (ABC) and/or from ascending (asc.) to descending (desc.).
Some reports offer the ability for users to change the perspective of the report by reordering the groups. For example, instead of executing the report by industry by Area of Practice by client, the order could be modified to by Industry, by Client, By AOP. This option is available when the value on the last column s open to modification.
Press OK to generate the report.
Measures
Definitions
Value Worked:
The original value of the unbilled hours worked included in the invoice - hours billed multiplied by the applicable rate based on entry date.
When Executed by Working Member
Shared – Total Variance and Credited:
The sum of efficiency gains (write-ups), efficiency losses (write-downs), client discounts or premiums and fees credited - net of invoice and credit note cancellations; shared on a pro-rata basis on value worked included in the invoice. The measure is calculated using the invoice, credit note and/or cancellation date respectively.
Shared – Net Fee Billed:
Fees Billed, net of efficiency gains (write-ups), efficiency losses (write-downs), client discounts or premiums and fees credited - net of invoice and credit note cancellations; shared on a pro-rata basis on value worked included in the invoice. The measure is calculated using the invoice, credit note and/or cancellation date respectively.
Allocated Fees Billed:
Fees Billed, net of efficiency gains (write-ups), efficiency losses (write-downs), client discounts or premiums and fees credited - net of invoice and credit note cancellations; allocated by the allocation formula and/or manual allocation modifications. The measure is calculated using the invoice, credit note and/or cancellation date respectively.
Final Allocation Gain/Loss:
The sum of efficiency gains (write-ups), efficiency losses (write-downs), client discounts or premiums and fees credited - net of invoice and credit note cancellations; allocated by the allocation formula and/or manual allocation modifications. The measure is calculated using the invoice, credit note and/or cancellation date respectively.
Fees Collected:
Receipts net of deposit-cancellations allocated in consideration of the final allocation applied to the related invoice at the time the receipt is posted and/or subsequent manual allocation modifications to the receipt. The measure is calculated using the deposit and/or deposit cancellation date respectively.
Fees Written-Off:
Fees written-off net of AR write-off and/or deposit cancellations allocated in consideration of the final allocation applied to the related invoice at the time the AR Write-off is posted and/or subsequent manual allocation modifications to the receipt. The measure is calculated using the AR write-off or AR write-off cancellation date respectively.
Working members without value worked can have final allocation fee measures, however they will not have shared fee billed values. Also, the total allocated fee measure for the organization may not equal the total shared fee measure as fees for no-time invoices are considered in the allocated value but excluded from the shared fees one.
When Executed by Team and Shared Role Holder
Value Worked:
The original value of the unbilled hours worked included in the invoice - hours billed multiplied by the applicable rate based on entry date.
Fees – Variance and Credited:
The sum of efficiency gains (write-ups), efficiency losses (write-downs), client discounts or premiums and fees credited - net of invoice and credit note cancellations. The measure is calculated using the invoice, credit note and/or cancellation date respectively.
Fees – Net Fee Billed:
Fees Billed, net of efficiency gains (write-ups), efficiency losses (write-downs), client discounts or premiums and fees credited - net of invoice and credit note cancellations. The measure is calculated using the invoice, credit note and/or cancellation date respectively.
Fees – Variance:
The sum of efficiency gains (write-ups), efficiency losses (write-downs), and client discounts or premiums - net of invoice cancellations. The measure is calculated using the invoice and/or cancellation date respectively.
Fees –Credited:
Fees credited - net of credit note cancellations. The measure is calculated using the credit note and/or cancellation date respectively.
Fees - Collected:
Receipts net of deposit-cancellations. The measure is calculated using the deposit and/or deposit cancellation date respectively.
Fees – Written-Off:
Fees written-off net of AR write-off and/or deposit cancellations. The measure is calculated using the AR write-off or AR write-off cancellation date respectively.
Points to Consider:
Fees Credited: Measures resulting from credit notes. They reduce net fees billed.
Credit work cannot be transferred. The value of time worked included in an invoice, cannot be allocated or transferred to someone else.
Working members includes timekeepers and allocated-to members. The working member includes members with billed time (timekeepers) with final fee allocation or not, as well as allocated-to members that have final fee allocation without any time worked.
Allocated-to members are members that have allocated-to values because of the allocation schema used, or manual fee allocation modifications applied (take from one member to give to another), therefore he or she may not have value worked nor a shared fee billed value.
Allocated values are applied to the allocated-to member based on the attributes of the allocation schema applied.
Report Outputs:
Reports by matter can be executed without the client group. In this case the client-matter number will be presented together separated by a hyphen followed by the matter name.
Summary by Working Member
For Working Member, Detailed by Matter
Summary by Member Role Holder and Detailed by Client
