Clio Manage Client Reports

Have more questions? Submit a request

Reports in Clio Manage are designed to help your law firm track deliverables and get insights into all aspects of how the firm is performing. Client reports provide a comprehensive overview of client balances, bank account and matter transaction history, non-billable and billable work in progress, and trust account balances. See below for a summary of each client report in Clio Manage and what type of information the report offers.

Note: Every report in Clio is unique in the criteria it uses to calculate financial data. This means that comparing reports is not recommended. Additionally, not all reports are available for all Clio subscription plans. Learn more about reports available on your subscription plan and upgrading your plan here.
Tip: Learn more about generating reports, creating reports presets, and viewing a history of generated reports here.

Client activity report

The client activity report is designed to give firms a detailed breakdown of billed and unbilled time and expense activities across matters. This report does not include non-billable time. When generated, this report includes the following categories:

Date
This column shows the date that the activity was recorded. Multiple activities with the same date will appear in random order.
Activity type
This column shows whether the recorded activity is a time entry or expense entry.
Status
This column shows whether the activities are billed or unbilled. Activities are divided by billed and unbilled status, with billed activities appearing first with their subtotal, followed by unbilled activities.
User
This column lists the firm user who created the activity entry. 
Activity category
This column shows the activity category recorded when the activity was created. If no activity category was selected, this column will be blank.
Description
This column shows the description entered when the activity entry was created.
Quantity
This column shows the total number of hours or expenses for the listed activity.
Price
This column shows the selected rate of the listed activities.
Total
This total summarizes the total cost of the time and expense entries. This value may be different from the value under the Price column depending on the Quantity. For example, if the Quantity for an activity is listed as 0.50, the Price is $500, then the Total would be $250.
Billed total
This total is the summarized total cost of billed time and expense entries for the matter.
Matter total
This total is the summarized total cost of billed time and expense entries for each of a client's matters.
Billed total
This total is the summarized total cost of billed time and expense entries for all of a client's matters.

 

Client ledger report

The client ledger report is designed to give firms a detailed view of client trust and operating transactions. This report also shows payments, refunds, transfers, and balances. When generated, this report includes the following categories:

Date
This column shows the date that the transaction occurred in the account. Transactions include deposits, withdrawals, and transfers. Multiple transactions that occur on the same day will appear in random order.
Source/Recipient
This column shows the payment type and is gathered from the Source/Recipient field from when you are recording a new transaction.
Reference
This column shows data entered in the Reference field from when you recorded a new transaction.
Matter
This column shows the matter that is linked to the transaction. 
Funds out
This column lists withdrawals or payments from the account.
Funds in 
This column lists payments deposited into the account.
Balance
This column shows the amount of money left in the account after each listed transaction.
Closing balance
This lists the closing balance of the Funds out, Funds in, and Balance.
Client total
This lists the total balance of the Funds out, Funds in, and Balance for all of the client's matters. If you have transactions across multiple operating and trust accounts, you may see different balances.
Balance summary
This section will appear at the bottom of the report if you selected the option for Display bank account summary before running the report. This section shows the current balance of your accounts. If you sort results by a specific date range, this section will show an opening balance that summarizes the transactions prior to the selected date range and a closing balance that summarizes the account balance at the end of the date range.

 

Trust ledger report

The trust ledger report is designed to give firms a detailed breakdown of client and matter transactions and balances across all trust accounts. The report includes payments, refunds, transfers, and balances. You can use this report to submit to regulators. When generated, this report includes the following categories:

Date
This column shows the date that the transaction occurred in the account. Transactions include deposits, withdrawals, and transfers. Multiple transactions that occur on the same day will appear in random order.
Source/Recipient
This column shows the payment type and is gathered from the Source/Recipient field from when you are recording a new transaction. If you selected the option to Include opening balance before running the report, this section will first show the opening balance of each trust account, which is helpful if you choose to run the report in a specific date range.
Reference
This column shows data entered in the Reference field from when you recorded a new transaction.
Matter
This column shows the matter that is linked to the transaction. 
Funds out
This column lists withdrawals or payments from the account.
Funds in 
This column lists payments deposited into the account.
Balance
This column shows the amount of money left in the account after each listed transaction.
Closing balance
This lists the closing balance of the Funds out, Funds in, and Balance.
Client total
This lists the total balance of the Funds out, Funds in, and Balance for all of the client's matters. If you have transactions across multiple operating and trust accounts, you may see different balances.
Balance summary
This section will appear at the bottom of the report if you selected the option for Display bank account summary before running the report. This section shows the current balance of your accounts. If you sort results by a specific date range, this section will show an opening balance that summarizes the transactions prior to the selected date range and a closing balance that summarizes the account balance at the end of the date range.

 

Trust management report

The trust management report is designed to give firms an overview of unbilled time and expense activities, trust account balances, and minimum trust thresholds. You can use this report to compare billable work against trust fund holdings. When generated, this report includes the following categories:

Client
This column lists the name of each client
Matter
This column lists the matters for each client.
Unbilled amount
This column shows the amount of unbilled time and expense entries for each matter.
Amount in trust
This column shows the amount of funds currently in trust for the client or matter. 
Minimum threshold
This column lists the minimum threshold set for matter trust funds. This amount can be changed by editing the matter and changing the number for Trust balance notification under Billing preference.
Amount below minimum
This column shows the amount that a trust balance has fallen below the minimum threshold set for the matter.

 

Trust listing report

The trust listing report is designed to give firms a quick summary of client trust fund balances across all client accounts. This report includes an opening and closing balance summary. When generated, this report includes the following categories:

Account name
This column shows the name of the trust account.
Last activity date
This column shows the most recent transaction in the client's trust account.
Client balance
This column shows the current amount in trust for the client. This balance may be different from the amount shown in the matter's Dashboard if you generate the report for a specific date range. This means that if a client had trust funds in the account before that selected date range and payments were made during the date range, the report will only pull in transactions, which will result in a negative balance.
Unlinked
This section will appear at the bottom of the report if you selected the option for Include balances not associated with a client before running the report. It shows trust funds that are not linked to a specific client. 
Balance summary
This section will appear at the bottom of the report if you selected the option for Display bank account summary before running the report. This section shows the current balance of your accounts. If you sort results by a specific date range, this section will show an opening balance that summarizes the transactions prior to the selected date range and a closing balance that summarizes the account balance at the end of the date range.

 

Work in progress report

The work in progress report is designed to give firms a detailed view of unbilled time and expense activities for matters. This report only shows activities on bills in draft, bills pending approval, and activities not on any bills. It will not show activities on any approved or paid bills. When generated, this report includes the following categories:

Date
This column shows the date that the activity was recorded. Multiple activities with the same date will appear in random order.
User
This column lists the firm user assigned on the activity entry.
Description
This column shows the activity category selected when the activity was created. If no activity category was selected, this column will be blank.
Note
This column shows the description entered when the activity entry was created. 
Quantity
This column shows the total number of hours or expenses.
Price
This column shows the selected rate of the listed activities.
Total
This total summarizes the total cost of the time and expense entries. This value may be different from the value under the Price column depending on the Quantity. For example, if the Quantity for an activity is listed as 0.50, the Price is $500, then the Total would be $250
Matter total
This total is the summarized total cost of unbilled time and expense entries for each of the client's matters.
Client total
This total is the summarized total cost of unbilled time and expense entries for all of the client's matters.

 

Bank account activity report

The bank account activity report is designed to give firms a detailed view of funds in and funds out across all firm bank accounts. This report also includes the account balance. When generated, this report includes the following categories:

Date
This column shows the date that the transaction occurred in the account. Transactions include deposits, withdrawals, and transfers. Multiple transactions that occur on the same day will appear in random order.
Source/Recipient
This column shows the payment type and is gathered from the Source/Recipient field from when you are recording a new transaction. If you selected the option to Include opening balance before running the report, this section will first show the opening balance of each trust account, which is helpful if you choose to run the report in a specific date range.
Client
This column lists the client associated with the transaction.
Matter
This column shows the matter that is linked to the transaction. 
Description
This column shows the information entered into the Description field when a payment was recorded. 
Funds out
This column lists withdrawals or payments from the account.
Funds in 
This column lists payments deposited into the account.
Balance
This column shows the amount of money left in the account after each listed transaction.
Closing balance
This lists the closing balance of the Funds out, Funds in, and Balance.
Balance summary
This section will appear at the bottom of the report if you selected the option for Display bank account summary before running the report. This section shows the current balance of your accounts. If you sort results by a specific date range, this section will show an opening balance that summarizes the transactions prior to the selected date range and a closing balance that summarizes the account balance at the end of the date range.

 

Need more help?

Was this article helpful?
0 out of 0 found this helpful