How to get Client Balances as of a certain date in Clio
Overview: This article will walk you through the steps in Clio to generate a report giving you Client balances as of a selected date of your choosing.
Step 1: Log in to your Clio Account. On the Dashboard page select Reports on the left side.
Step 2: On the Reports page under Client Reports, select Trust Listing Report.
Step 3: On the Trust Listing Report Select All Clients. Under Date Range select CUSTOM. Under Output Format select how you want the data displayed. On the Web, in Excel as a CSV file or as a PDF.
Note: The FROM date will need to be a date that is prior to any activity in your trust account or in Clio. This will allow it to pull from the beginning of your account and capture all data. The To date will be the date you want the balances from.
Step 4: Select Generate Report at the bottom of the page.
Note: If you do not want to see clients with a zero balance on the report you can simply uncheck Show Clients with zero balances under Select Client. You also have ability to select specific clients by selecting Specific Client at the top and searching for their name.