'I want to see originator for all clients' Report Key

The Originator Report is used to show payments made to the firm based on the originator of Clients. The report displays all of the originators the firm has and all of the Clients associated with the originator that have Matters with Invoices. This report allows the user to track payments received and adjustments made towards an Invoice. 

The user will be able to see the total amounts of each Invoice the Client is associated with. Each Invoice is split up into costs and fees which their amounts can be tracked as well in the report. When payments or adjustments* are credited towards the Invoice, they will be added to the paid to costs and paid to fee values in the report. All payments or adjustments* will be applied to costs until the paid to costs matches the Invoice costs for the Invoice. The rest of the payments or adjustments* credited to the Invoice will be added to the paid to fees until the paid to fees matches the invoice fees for the Invoice. The Invoice is considered paid when the paid to costs and paid to fees for the Invoice totaled match.

All payments received or adjustments made will be added to the total of the payments in the report. Any previous payments or adjustments made will be shown in the previous payment column but only when the payment was received before the filtered date range selected.

*NOTE: The user must include the filter payment setting ‘Include credit adjustments as payments’ if they wish to include credit adjustments in this report. By default, credit adjustments do not show as payment until this filter is selected. The ‘Include payments towards debit adjustments’ will allow the user to track what payments have been made towards debit adjustments. 

Report Summary Totals

  • Invoice Amount: This value is calculated based on the amount of costs and fees added together that make up the total amount of the Invoice. This field reflects the filtered data.
  • Invoice Costs: This value is calculated based on the amount of costs attached to all Invoices shown in the filtered data. All expenses added towards an Invoice will make up this cost value.
  • Invoice Fees: This value is calculated based on the amount of costs attached to all Invoices shown in the filtered data below. All time and fee related activities added towards an Invoice will make up this fee value. 
  • Paid to Costs: This value reflects how much money has been received (or adjusted) toward the Invoice that has been split into costs. Income received toward an Invoice will be credited towards all costs first. Once all costs have been paid, the rest of the incoming payment(s) will be credited to the Invoice as fees. This field reflects the filtered data.
  • Paid to Fees: This value reflects how much money has been received (or adjusted) toward the Invoice that has been split into fees. Once all costs have been paid the remaining incoming payment(s) will be credited to the Invoice as fees. This field reflects the filtered data.
  • Payments: This value reflects the total amount of payments (or adjustments) that have been received and credited toward an Invoice. If the user wishes to include credit adjustments as payments, there is a toggle that can be enabled in the filters for this report. The user can also include payments toward debit adjustments that have been added to an operating account that contains the Invoice.
  • Previous Payments: This value reflects the total amount of payments (or adjustments) that have been received and credited toward an operating account before the date period filtered. If the user wishes to include credit adjustments as payments there is a toggle that can be enabled in the filters for this report. The user can also include payments toward debit adjustments that have been added to an operating account.

Report Filters

  • Start Date & End Date: This filter allows users to specify the date range in which they want to see Invoices. If a payment was made outside of this time range, it will be included in the 'previous payment' calculations. 
  • Originator: This filter allows users to filter the report by one specific originator. 
  • Client: This filter allows users to filter the report by one specific Client. This filter is not usable if an originator has been filtered.

Payment Settings:

  1. Include credit adjustments as payments:

If this filter is toggled on, credit adjustments that are applied to Invoices will be included as payments. If this filter is toggled off, credit adjustments will not be calculated as collected payments. 

  1. Include payments towards debit adjustments:

If this filter is toggled on, debit adjustments will be calculated into the Invoice amount. This will also include payments made toward debit adjustments. Without this toggle turned on, debit adjustment amounts will not be reflected in any of the report amounts. 

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

Report Columns

  • Originator: Originator for the Client. If no originator exists, the Invoice will be grouped into the 'None' category.
  • Invoice: Invoice number. This will only be visible when the report is expanded to the individual Client level. 
  • Invoice Amount: This column displays the invoiced processed amount. This column amount is not affected by any trust transfers, credit adjustments, or payments. 
  • Invoice Fees: This column displays the total amount of fees on the Invoice.
  • Invoice Costs: This column displays the total amount of costs on the Invoice. Debit adjustments are considered costs.
  • Previous Payments: The sum of payments received before the time period selected.
  • Payments: Total amount of payments made. This includes payments towards both costs and fees. This number will fluctuate depending on the filters set. Users can choose to include payments towards debit adjustments or exclude them. 
  • Paid to Fees: Total amount of payments and adjustments made toward fees. Fees will be paid after all costs have been paid in full. 
  • Paid to Costs: Total amount of payments and adjustments made toward costs. Costs will be paid in full before any payments are allocated towards fees.