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 accounts and matter transaction history, non-billable and billable work in progress, and client funds 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 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 funds and operating transactions. This report also shows payments, disbursements, 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 client funds 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.
Client account ledger report
The client account ledger report is designed to give firms a detailed breakdown of client and matter transactions and balances across all client fund accounts. The report includes payments, disbursements, 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 client funds 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 client funds 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.
Disbursement listing report
The disbursement payment report is designed to give firms a breakdown of disbursements and anticipated disbursement expenses. The report includes the invoice status of the expense and vendor bill status. When generated, this report includes the following categories.
- Date
- This column shows the date the expense was recorded. Multiple expenses recorded on the same day will appear in random order.
- Vendor
- This column is gathered from the Vendor field when you create a new disbursement expense entry. You can use this field to show the vendor who received the funds from one of your operating accounts.
- 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.
- Description
- This column shows the data entered in the Description field from when you recorded a new transaction.
- Type
- This column shows the expense type when you created a hard-cost expense or an anticipated disbursement. Anticipated disbursements are estimated expenses you want to bill to a client before you have paid the vendor
- Invoice status
- This column is gathered from the Invoice status field when you create a new expense. You can use this field to show the draft billed, unbilledable, future billable or non-billable status of the invoiced disbursement.
- Vendor bill status
- This column is gathered when you link a transaction with a disbursement to pay a vendor for a hard-cost expense. Once billed and paid, the Vendor bill status will update from unpaid to paid.
- Amount
- This column shows the data entered in the Amount field from when you recorded a new disbursement.
Client account management report
The client account management report is designed to give firms an overview of unbilled time and expense activities, client funds account balances, and minimum client funds thresholds. You can use this report to compare billable work against client 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 client funds
- This column shows the amount of funds currently in client funds for the client or matter.
- Minimum threshold
- This column lists the minimum threshold set for matter client funds. This amount can be changed by editing the matter and changing the number for Client funds balance notification under Billing preference.
- Amount below minimum
- This column shows the amount that a client funds balance has fallen below the minimum threshold set for the matter.
Client account listing report
The client account listing report is designed to give firms a quick summary of client funds 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 client funds account.
- Last activity date
- This column shows the most recent transaction in the client's client funds account.
- Client balance
- This column shows the current amount in client funds 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 client 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 client 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 client funds 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.