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

Procedure:

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.