Skip to main content
An itemized list of ACH returns for a given activity date. Use this report to stay informed about unsuccessful ACH transfers.
FieldDescription
ACCEPTOR_IDThe unique, 36 character identifier created by Tesouro and assigned to the entity providing the goods or services to the customer, such as a Merchant, a Submerchant of a Payment Facilitator, a Seller within a Marketplace, or a Biller of a Consumer Bill Payment Service Provider (CBPS). Also referred to as the Merchant ID (MID), Outlet ID, or Customer number.
ACCEPTOR_NAMEA human readable description used to uniquely label the Acceptor. It is assigned during onboarding of the Acceptor and mapped to the Acceptor ID. Maximum of 255 characters. Other processors may refer to this as a Billing descriptor.
ACCEPTOR_REFERENCEA unique identifier created and managed by the entity holding the direct relationship with the Acceptor, and assigned to the Acceptor with a one-to-one mapping to Tesouro’s Acceptor ID. Other processors may refer to this as Location ID, Store ID, Club ID, etc.
ACCOUNT_NUMBER_ENDING_INThe last few numbers of the bank account used as a visual reference to the full account number.
ACCOUNT_OWNER_NAMEThe original bank account owner’s name.
ACCOUNT_OWNER_TYPEThe type of the bank account owner, either Consumer or Corporate/Business.
ACCOUNT_TYPEThe type of bank account, either Checking or Savings, specified on the original transaction.
ACTIVITY_DATEThe date the return was received by Tesouro.
AMOUNTThe amount of the return.
CURRENCYThe currency specified on the transaction request, in ISO 4217 alpha currency code format.
IDA unique, 36 character identifier created by Tesouro and assigned to the ACH return.
ORGANIZATION_IDThe unique 36 character identifier created by Tesouro, and used to identify the organization holding the relationship with Tesouro.
PAYMENT_IDA unique 36 character identifier created by Tesouro and assigned to a group of transactions in the same payment request cohort, e.g., a bank transfer sale and resulting ACH return.
REASONA user-friendly description of the ACH return code.
REASON_CODEA standard code used by the ACH operator or Receiving Depository Financial Institution (RDFI) to describe the reason an ACH payment was returned by the recipient’s bank. These codes make it easier for originating and receiving financial institutions to spot and communicate payment failures.
ROUTING_NUMBERThe unique nine-digit number identifying the bank.
TRACE_NUMBERA unique 15 digit reference number created by the bank and assigned to the return, which can be used to investigate and track missing transfers. i.e., It tells you where the money has been and helps locate it if it gets lost.
TRANSACTION_ACTIVITY_DATEThe date Tesouro recognized the original transaction. Formatted as YYY-MM-DD
TRANSACTION_AMOUNTThe amount of the transaction request sent to Tesouro.
TRANSACTION_CURRENCYThe currency specified on the transaction request, in ISO 4217 alpha currency code format.
TRANSACTION_DATE_TIMEThe date and time that Tesouro received the transaction request, in UTC. Formatted as 2024-03-27T02:40:00Z
TRANSACTION_IDThe unique 36 character identifier Tesouro assigned to the transaction that triggered the return
TRANSACTION_REFERENCEThe unique identifier assigned to the transaction by the acceptor (or partner) and included in original transaction request sent to Tesouro.
TRANSACTION_TRACE_NUMBERA unique 15 digit reference number created by the bank and given to the original ACH transfer.
TRANSACTION_TYPEThe type of transaction, either an ACH debit (sale) or ACH debit (refund).

Report availability

The report is generated daily by 10:00 AM ET, encrypted, and placed in the outbound directory of an SFTP location dedicated for your use. (This schedule can be configured to later cadences to suit your needs, e.g., a later time in the day, every other day, weekly, monthly, etc.) Reports expire and removed from the SFTP location after 14 calendar days.

Report format

  • CSV file, following the RFC 4180 standard
  • File name: ach_returns_{startdate:YYYYMMDD}-{endDate:YYYYMMDD}_{generationDate:YYYYMMDDThhmmss}.csv
  • Values are separated using commas.
  • Values containing commas are enclosed within double quotes.
  • Values containing double-quotes are escaped by two double quote preceding it.