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.
Begin client funds reconciliation in Clio
Beginning your client funds account reconciliation in Clio Manage depends on whether this is your very first reconciliation in Clio or a subsequent reconciliation. Open the accordion tabs below to learn more about how to begin reconciling your client funds accounts for the first time and how to reconcile your client funds accounts if you have already completed your first reconciliation in Clio.
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.
- Go to Accounts.
- Select the client funds account that you want to reconcile.
- Click Reconcile account.
- Enter the beginning and end dates and balances for both.
-
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 to begin all subsequent reconciliations. Once this is done, you can start matching transactions to reconcile the account.
- Go to Accounts.
- Select the client funds account that you want to reconcile.
- Click Reconcile account.
- Enter the ending balance and ending date from your most recent bank statement.
- Click Begin reconciliation.
- See Match transactions to reconcile client funds account to begin matching transactions.
Match transactions to reconcile client funds accounts
If your beginning balances in Clio match with your most recent bank account statement, you can begin reconciling the account. When reconciling a client funds account, you will need to match transactions recorded in Clio against the transactions on your bank account statement. As the transactions are matched, Clio displays the difference between the ledger and the bank account at the top of the screen. You can only finish reconciliation when the difference is €0.
Tip: You can save and continue your reconciliation at any time or delete it entirely to start over. Click Save for later in the top right to save the reconciliation or click the down arrow next to this button and select Delete to delete it. To continue the saved reconciliation, go to Accounts > Reconciliation and select the uncompleted reconciliation.
- Click Match on a line item if the transaction matches your bank account statement.
- Repeat step 1 for each listed transaction.
- Click Finish when the difference is €0.
- If the difference is not €0, cross-reference transactions in your bank account statement and the listed transactions. Then either click Disburse funds to return funds to client(s) or New transaction to add funds for the appropriate client(s).
- Click Finish when the difference is €0.
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 window will automatically appear after you click Begin reconciliation and the balances do not match.
- Click Next to go through the information.
- Select Mark uncleared transactions to begin comparing your bank account statement to the previous reconciliation period.
- Look for potentially uncleared transactions from the previous month. Uncheck transactions that are not on the statement.
- 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 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.
Note: Completed reconciliations are locked to protect the integrity of your client account. If you need to make a correction to a previously reconciled period, such as editing or deleting a transaction, click Void in the Reconciliations table.
- Go to Accounts > Reconciliations.
- Click View report next to the reconciliation.
- Go through the three tabs to view detailed reconciliation reports.