Transaction Log Advanced Filters: Account Level (Reference)

Introduction

Admins can filter transactions using a variety of parameters to gain a more comprehensive view of transactions on the account level. There are three options for filtering transactions:

• All Transactions
• Payments Only
• Charges Only

Show Advanced Options	Description
1. Type	All Transactions: Displays every transaction on the account. Charges Only: Displays only the transactions that are charges. Payments Only: Displays only the transactions that are payments.
2. Dates	Specific Date Range: Select a date range to display transactions within that period. The system default displays the past five years, which can be reviewed and changed in the settings.
3. All Dates	Displays all transactions on the account, both past and future.
4. Use Payment Date	Select Payment Date or Deposit Date. The deposit date will only show transactions that have been deposited.
5. Amount	Select from the filter options: Only Positive: Displays transactions with positive amounts. Only Negative (Reversals): Displays transactions with negative amounts, typically reversals. Only Zero: Displays only transactions with a zero amount. Custom Range: Allows a specific range between two amounts.
Charge Types/Payment Types	If filtering for Charges Only, a dropdown will appear for Charge Types If filtering for Payments Only, under the Amount dropdown, two additional dropdowns will appear. One for Charge Types and one for Payment Types. This allows for even more detailed filtering.
6. Status	Select the transaction status: Either Open or Closed: Displays all transactions within a date range. Only Open: Shows charges or payments that have not been allocated. Only Closed: Displays transactions where charges have been allocated to payments.
Public	If filtering by Charges Only or Payments Only, a dropdown will appear under Status to allow differentiation between inside account and public payments.
Invoice #	If filtering by Charges Only, a field will appear under Public allow for a search between two specific invoice numbers.
Receipt #	If filtering by Payments Only, a field will appear under Public allow for a search between two specific receipt numbers.
7. Note Contains	Filter Notes by specific words or phrases.
Check Number Starts With	If filtering by Payments Only, a field under Note Contains will appear to allow any part of a check number to be included in the search criteria.
8. Imported	Select: Imported or Unimported: Displays all transactions whether or not they have been synced with the external financial software. Only Unimported: Displays all transactions that have not been synced with the external financial software. Only Imported: Displays all transactions that have been synced with the external financial software.
9. Printed	Select: Printed or Unprinted: Displays all transactions whether or not they statements have been printed. Only Printed: Displays all transactions where statements have been printed for the transactions. Only Not Printed: Displays all transactions where statements have not been printed for the transactions.
Scheduled	If filtering by Payments Only, a dropdown will allow selection of: Either Scheduled of Regular Payments Only Scheduled Payments Only Regular Payments (not scheduled)
Dedicated	If filtering by Payments Only, a dropdown will allow selection of: Either Dedicated of Not Dedicated Payments Only Dedicated Payments Only Regular Payments (not dedicated)
Paid By Other	If filtering by Payments Only, a dropdown will allow selection of: Either Paid by Another Account or Not Only With Paid by Another Account Only Not Paid by Another Account

Show Advanced Options	Description
1. Show Tax Deductible Amount	When checked, includes a column in the transactions list for Tax Deductible amount.
2. Always Show Allocations	When checked, includes a row in the transactions list for the charge that the payment has been allocated to.
3. Clear Filter	Clears all filters and outputs.
4. Print This View	Prints the filtered list of transactions.
5. Export This View	Exports the filtered list of transactions to Excel. The file will be located in the downloads folder.
6. Mail Merge View	Do not use.
7. Filter	Produces a custom list of transactions based on the filters and outputs selected.

 

Related Resources

• Transaction Log: Account Level (Reference)