How to use Apportionment (CI Detailed) Report

The “Apportionment (CI Detailed) Report” is based on information in a customer invoice in the accounting module. It provides insights into the fees apportioned for each invoice. You can filter the apportionment report by either “Invoice Date” or “Last Payment Date”. This report only filters for reports that are either awaiting payment or fully paid. Any credit notes applied will also be reflected.

To get the report to show apportioned fees for fully collected invoices paid across a specific period:

1. Select the From Date and To Date
2. Select “Payment Date” for the Date Filter
3. Select “Paid” for the Invoice Status
4. You may leave the remaining filters blank unless if you would like to further refine the result.

To get the report to show apportioned fees regardless of collection status:

1. Select the From Date and To Date
2. Select “Invoice Date” for the Date Filter
3. Select “All” for the Invoice Status
4. You may leave the remaining filters blank unless if you would like to further refine the result.

To get the report to show apportioned fees for fully collected invoices:

1. Select the From Date and To Date
2. Select “Invoice Date” for the Date Filter
3. Select “Paid” for the Invoice Status
4. You may leave the remaining filters blank unless if you would like to further refine the result.

Columns in the report	What does it mean?
Date of Invoice	Date of the customer invoice
Case File No.	Case reference number
Client Name	Name of the client
Case Type	Case type
Case Facts	Description of the case entered in the field "Facts" from the case.
PIC Name	Name of the Partner-in-Charge
MIC Name	Name of the Manager-in-Charge
Invoice Number	Customer invoice number
Status	Status of the customer invoice
Invoice Currency	Currency of the customer invoice
Final Payment Date	Date of the last payment made to the customer invoice
Professional Fees Amount in Invoice	Summation of the professional fees of the customer invoice
User	Name of the user / fee earner
Original Amount of Professional Fees	Summation of professional fees in the customer invoice that is contributed by this user.  This is only shown if you add timesheets to the billing request.
Adjustment Amount	This figure shows the mark up or mark down of fees attributed to this user.  Calculation: final apportioned amount - original amount of professional fees.
Final Apportioned Amount	This shows the final amount attributed to this user.
% of Professional Fees	This calculates the user contribution for the billing request based on the final apportioned amount. Calculation: final apportioned amount / professional fees amount in invoice.
Credit Note Apportioned Amount	This shows the amount attributed to the user in a credit note.
Net Apportioned Amount	This shows the fin+al apportioned amount attributed to the user.  Calculation: Final apportioned amount - credit note apportioned amount.