Use this report to create a list of all of the Echeck
(ACH) transactions in your ReceivablesPro account
that were Returned for non-sufficient funds (R01 Return Code).
NOTE: You can re-try all of these transactions
again to attempt to collect without obtaining additional authorizations.
NOTE: The Daily Returned ACH Report standard
report contains basic information about all types of returned ACH transactions
based on return date. You can use this custom reporting option to look
only at ACH transactions returned for non-sufficient funds, to report
based on enter date or settle date, and to include fields that the standard
report does not.
To create a returned
ACH transaction report, follow the steps for Creating Custom Reports described
above, and use the following filters:
Check both the Transactions and the Customers checkboxes in the Include in Report section.
Set the Date Range filters to “all,” select a rolling date range, or enter a custom Start date and End date. Then set Report on to “Enter date.”
In the Payment Options section, check only the E-Check box in the Type section.
In the Payment Options section, check only Returned NSF in the Status section.
Suggested fields to add to the report:
Transaction.Transaction ID
Transaction.Transaction Date
Transaction.Return Date
Transaction.Status
Transaction.Reason Description
Transaction.Payment Type
Transaction.Amount
Transaction.Masked Account Number
Transaction.Estimated SettleDate
Transaction.Actual Settlement Date
Transaction.Invoice Number
Transaction.Schedule Id
Customer.Customer ID
Customer.Account Number
Customer.Company
Customer.First Name
Customer.Last Name
Customer.Billing City
Customer.Billing State
Customer.Phone 1
Customer.Email