The 2020 Legal Trends Report is now available. Get the latest insights here.

How to Determine How Many Trust Transactions I've Moved to Operating via Invoice Payments

Objective:

  • Move money from Trust to Operating for bank accounts
  • Transfer funds to bank account
  • Trust total amount 
  • What funds from bill payments came from Trust
  • Trust Funds applied to invoices
  • Determine how much from Trust was applied to Invoices
  • How to determine how much to transfer from Trust to Operating
  • Reconcile Bank Accounts
  • Reconcile Trust and Operating Accounts
  • Report Bill Payments from Trust

Environment:

  • Clio Manage

Additional Information:

  • If there are currency symbols before the payments in the Report, excel will not be able to calculate the numbers. Use the Find and Replace feature by selecting Cntrl and F. Replace the currency symbols with nothing. For detailed instructions on how to use the Find and Replace feature, click here. 

Procedure:

  1. Select Reports 
  2. Select the Invoice Payment Report 
  3. Select the date range that you would like to see the payments for and fill in the other applicable fields 
  4. Select CSV for the Output format field 
  5. Open the Report in Excel 
  6. Highlight the data table 
  7. Click the Insert tab 
  8. Select Pivot Table 
  9. Select Ok 
  10. On the PivotTable Fields check the box next to Transaction and Debit 
  11. Drag the "Count of Transactions" from the Values box to the Rows box. You'll see a total of your Trust Payments on the excel spreadsheet. 

 

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality