Funding Reject Report by ACH Return Date

The Funding Reject Report by ACH Return Date is an Dynamic Payout report containing data about rejected funding instructions and/or funding failures. Worldpay produces the report daily, Monday through Friday, and only applies to Payment Facilitators using the Dynamic Payout solution.

Filename Syntax

The syntax of the report filename is:

SubMerchantIBFundingReject_${organizationId}_${TargetDay}

where

organizationId is the of the parent merchant organization
targetDay is the date to which the data applies

Report Structure

The table below provides information about the fields included in the report. The report fields are in the order presented in the table.

Prior to October, 2020, opening this report in a spreadsheet application could truncate leading zeros in both the Routing Number and Account Number fields. To prevent the truncation, we now prepend the values with an apostrophe (‘). The addition of this character also increased the max size of the Routing and Account Number fields by 1.

Field Name	Data Type	Max Size	Description
Return Date	Date (mm/dd/yyyy)	10	The date the issuing bank processed the funding instruction.
Original Date	Date (mm/dd/yyyy)	10	The original date of the transaction (i.e., Batch post date).
Attempted Funds Transfer Date	Date (mm/dd/yyyy)	10	The date that Bank attempted to settled funds to your Sub-merchant's bank.
Merchant Name	Alphanumeric	50	The name of the Sub-merchant for which the funding instruction failed.
Sub Merchant Business Name	Alphanumeric	50	The business name of the Sub-merchant for which the funding instruction failed.
Funding Sub Merchant ID	Alphanumeric	32	The identifier for the Sub-merchant (usually the assigned Merchant Id).
Funds Transfer Request ID	Alphanumeric	36	The Payment Facilitator assigned identifier associated with the funds transfer instruction.
Vantiv Payment ID	Numeric (with preceding apostrophe)	20	The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction.
Txn Type	Alphanumeric	6	The type of transaction. Possible values are: FIPC - Funding Instruction PayFac Credit FIPD - Funding Instruction PayFac Debit FIRC - Funding Instruction reserve Credit FIRD - Funding Instruction Reserve Debit FISC - Funding Instruction Sub-merchant Credit FISD - Funding Instruction Sub-merchant Debit FIVC - Funding Instruction Vendor Credit FIVD - Funding Instruction Vendor Debit FICC - Funding Instruction Physical Check Credit FICD - Funding Instruction Physical Check Debit
Funds Transfer Amount	Signed Decimal (17,2)	17	The dollar amount of the failed funds transfer.
Reason Code	Alphanumeric	3	The response code indicating the reason for the funds transfer failure. For additional information see Sections A-8 and A-9 of the Worldpay eComm cnpAPI Reference Guide.
Reason Message	Alphanumeric	80	The message describing the reason for the funds transfer failure. For additional information see Sections A-8 and A-9 of the Worldpay eComm cnpAPI Reference Guide.
Routing Number	Number (with preceding apostrophe)	10	The routing number of the Sub-merchant account.
Account Number	Number (with preceding apostrophe)	18	The account number of the Sub-merchant account.
Account Name	Alphanumeric	22	The name of the Sub-merchant bank account.