Filter Options - ACH Payment Reports
This table describes the fields and options that are possible filters for the ACH Payment reports.
- Accounts
Limits the report to one or more bank accounts
Select at least one account. You can select All Accounts to include all of the listed accounts or select multiple items using the SHIFT and CTRL keys.
- ACH Company IDs
Defines one or more ACH Company IDs to be included in the report
At least one ID must be selected. You can select All IDs to include in the report all of the listed IDs or use the CRTL and SHIFT keys to select multiple IDs.
- Date Type
Defines the date as one of the following:
- Create Date
- Effective Date
- Scheduled Send Date
- Date Range
Defines the range of transaction dates to be included in the report
You can define the date range in two ways:
- Absolute Date – Specifies calendar dates as From and To dates
- Relative Date – Defines the From and To dates according to how the dates fall relative to a specific measurement, such as the current month
- Amounts
Limits the ACH report to amounts within the specified range of values
You can independently specify batch and transaction amounts, as follows:
- Batch Amount – Limits the report to payments where the total batch amount is a certain value or is within a specified range of values.
- Transaction Amount – Limits the report to payments where individual transaction amounts in the batch are a certain value or are within the specified range of values.
For each of the amounts specified, you must select one of the following as the Amount Type:
- Credits Only
- Debits Only
- Both
- Payment Amount Range
Limits the ACH report to payment amounts within the specified range of values
- Payment Amount Type
You must select one of these payment amount types:
- Credits Only
- Debits Only
- Both
- Recipient Amount Range
Limits the ACH report to recipient amounts within the specified range of values
- Recipient Amount Type
You must select one of these recipient amount types:
- Credits Only
- Debits Only
- Both
- Recipient Name
Limits the report an individual recipient or to a group of recipients whose names have a common pattern
The asterisk (*) wildcard character can be used to locate groups of names with similar characteristics. For example, "Smi*" would locate all recipients where the name begins with those letters, including Smith, Smithers, Smithson, and so on. You can use the asterisk at either the beginning or the end of the search string.
Note: Applies only to detail reports.- Recipient ID
Limits the report to an individual recipient ID, or a range of IDs
As with the Recipient Name field, the asterisk (*) wildcard character can be used with the Recipient ID field.
Note: Applies only to detail reports.- Status
Limits the report to a single transaction status
If no status is selected, all statuses are included.
- Credit/Debit
Limits the report to credits or debits
For most payment types, only one option is valid. For the Pay a Business payment type, Credit is the only appropriate option. If an invalid option is selected, the system displays an error message.
- CR/DR/Mixed
Limits the report to credits, debits, or mixed
For some payment types, only certain options are valid. For example, CTX payments, Credits is the only appropriate option. If a user selects an option that isn't valid for the payment type, the system displays an error message.
Note: For CCD, PPD, and IAT payments, a SAM setting determines which options are valid.- Payment Type
Limits the report to the selected payment types
You can select multiple types using the CRTL and SHIFT keys.
- Confidential Batch
Limits the report to ACH batches marked as confidential
Select Yes to limit the report to confidential batches; otherwise, all batches are included.
- Detail Sort
Defines the sort order for the detail section of the report
If you do not specify a sort order, the report detail is sorted first according to the Create Date, and then by Payment Type (alphabetic - ascending).
Note: This option applies only to the ACH Payment Detail and ACH Payment Template Detail reports.- Recipient Sort
Defines the sort order for the recipient information
If you do not specify a sort order, the recipients will be sorted Recipient Name (alphabetic - ascending).
Note: This option applies only to the ACH Payment Detail and ACH Payment Template Detail reports.
