This article may be out of date!
Visit the New Knowledge Center

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


  • 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


  • 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.
  • More information on Invoice Payments Report 


  1. Select Reports 
  2. Under the Billing category select the Invoice payments 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 boxes 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