Client Funds Reconciliation in Clio

Client funds account reconciliation is an essential part of working with client funds. With client funds reconciliation in Clio Manage, you can verify that your client funds ledger in Clio matches your bank account statement, view a history of reconciliation reports for historical and audit purposes, and maintain compliance in your specific jurisdictions.

Note: Only administrators can reconcile client accounts in Clio. Additionally, client reconciliation is only available on Clio's current plans. If you are on one of Clio's legacy plans and want to upgrade, contact Clio's support or sales team.

Reconcile a client funds account

The process for reconciling a client fund account looks different depending on whether this is your first reconciliation for the account or a subsequent reconciliation. Open the accordion sections below to learn how do the first reconciliation or subsequent reconciliations for a client funds account. Before starting the reconciliation, you will need a copy of the client funds account’s most recent bank statement.

First reconciliation in Clio

If you are reconciling client funds accounts for the first time in Clio Manage, you will need a copy of your firm’s most recent bank account statement. You will need to enter the beginning and ending balance in the date range specified in your most recent bank account statement and previous reconciliation schedule.

Note: Your previous reconciliation schedule is most likely the start and end of the previous month.
  1. Go to Accounts.
  2. Click on the name of client funds account that you want to reconcile to open a view of the account.
  3. Click Reconcile account.
  4. Enter the beginning and end dates and balances in Clio Manage as per your bank statement.
  5. Click Begin reconciliation.
    • If your beginning balances in Clio match with your most recent bank account statement, you can begin reconciling the account. Learn more about how to reconcile the account in the section below on Match transactions to reconcile client funds account.
    • If the beginning balances do not match, you will need to first look for any potentially uncleared transactions from the previous month before you can begin reconciling the account. Learn more about how to review uncleared transactions in the section below on Review uncleared transactions
Subsequent reconciliations in Clio

After completing your first client funds account reconciliation in Clio, you will only need to enter the ending balance and ending date from your most recent bank statement for all future reconciliations. Once this is done, you can start matching transactions to reconcile the account.

  1. Go to Accounts.
  2. Select the client funds account that you want to reconcile.
  3. Click Reconcile account.
  4. Enter the ending balance and ending date from your most recent bank statement.
  5. Click Begin reconciliation.
  6. See Match transactions to reconcile client funds account to begin matching transactions.

 

Match transactions to reconcile client funds accounts

After following the steps to start the reconciliation, if your beginning balance in Clio matches with your most recent bank account statement, you can begin reconciling the account. When reconciling a trust account, you will need to match transactions recorded in Clio Manage (in the trust ledger) against the transactions on your bank account statement. As the transactions are matched, Clio displays the difference between the ledger and the bank account. You can only complete a reconciliation when the difference is €0.

Tip: From the reconciliation page, you can save your reconciliation at any time by clicking Save for later in the top right. To continue a previously saved reconciliation, go to Accounts, select the relevant account, then click Continue reconciliation. From the reconciliation page, you can also delete an in-progress reconciliation if you need to start over by clicking the down arrow next to Save for later, then click Delete. If you entered incorrect start and end date and balance information, click Edit to correct your information.

  1. Click Match for each line item if a corresponding transaction appears in your bank account statement.
    • When you have done this for every transaction, the difference between your bank statement ending balance and the Clio account (ledger) balance should be 0.
    • If the difference is not 0, find and correct the discrepancy using the relevant option to record transactions in your Clio account ledger.
        • Disburse funds: Click Disburse funds this option to add an entry in your Clio (ledger) account for a transaction in your bank statement that disbursed funds to the client(s).
        • New transaction: Click New transactions to record client or matter funds added, or to record an entry for interest earned or bank fees on the bank account.

          Note: This option should not be used to conceal unresolved or unexplained differences, but rather to account for temporary banking anomalies. Ensure you add relevant details to the transaction description to explain the correction.

  2. Click Finish when the difference is 0.
    • If there are any uncleared transactions that you did not include in your reconciliation, a modal with a list of these transactions will appear.
Note: If your reconciliation does not show a difference of €0, it is possible that your ledger reflects more transactions or a higher balance than what is actually on your firm's bank account statement, or your bank account statement reflects more transactions or a higher balance than what is in Clio. The former can happen if a client deposit was accounted for in Clio but has not yet cleared the bank. Banks normally require 7-10 business days to clear a transaction. The latter is typically caused by human error (missed entry or wrong amount) when entering a transaction in Clio. Consult with your bookkeeper or accountant if you need assistance with reconciling your client funds account

 

Review uncleared transactions

If your beginning balances in Clio do not match with your most recent bank account statement, you will need to look for any potentially uncleared transactions from the previous month before you can begin reconciling the account. This modal will appear after you click Begin reconciliation if your beginning balances do not match.

  1. Click Next to go through the information.
  2. Select Mark uncleared transactions to begin comparing your bank account statement to the previous reconciliation period.
  3. Look for potentially uncleared transactions from the previous month. Uncheck transactions that are not on the statement.
  4. Once the balances match, click Finish to start matching transactions to reconcile your account. Learn more about how to do this in the section above on Match transactions to reconcile client funds accounts.

 

View completed reconciliation reports

Once a client funds account reconciliation is completed, you can view reconciliation reports in Clio Manage for each time period. Each reconciliation’s report can be accessed within Clio for 10 years and includes the reconciliation summary, client ledger details, and transaction details.

  1. Go to Accounts.
  2. Click the relevant client funds account name.
  3. Select the Reconciliations subtab.
  4. Click View report for the relevant reconciliation.

You can use the three tabs to view the reconciliation summary, transaction details, and/or client ledger details. Click Export to download a PDF file of the report to use outside of Clio Manage.

 

Void reconciliation

Note: Completed reconciliations are locked to protect the integrity of your client funds account. If you need to make a correction to a previously reconciled period, such as editing or deleting a transaction, you will have to void the reconciliation and then redo it.

Each new reconciliation for a bank account uses information from the previous reconciliation—specifically the end date and end balance for the previous reconciliation is used to inform the start date and start balance of the new reconciliation. For this reason you will be unable to void a reconciliation for a particular bank account if there are newer reconciliations (completed or in progress). If you do need to void a reconciliation for a particular time period, you will first need to void all reconciliations for more recent time periods.

  1. Go to Accounts.
  2. Click the relevant client funds account name.
  3. Select the Reconciliations subtab.
  4. Click the down arrow next to View Report for the relevant reconciliation.
  5. Select Void Reconciliation.

 

Delete in-progress reconciliation

You can delete in-progress reconciliations by opening the in-progress reconciliation, then deleting it.

  1. Go to Accounts.
  2. Click the relevant client funds account name.
  3. Select the Reconciliations subtab.
  4. Click the down arrow next to Continue for the relevant reconciliation.
  5. Select Delete Reconciliation.

An alternative way to delete an in-progress reconciliation is to delete it from the list of all in-progress and completed reconciliations for an account.

  1. Go to Accounts.
  2. Click the relevant client funds account name.
  3. Click Continue Reconciliation.
  4. Click the down arrow next to Save for later.
  5. Click Delete.

 

Need more help?

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