fundingAchReturns

An itemized list of financially impacting ACH returns occurring on the pertinent funds release dates. Use this report to track ACH return-related money-movements.

Operation

query FundingAchReturns($input: FundingAchReturnInput!) {
  fundingAchReturns(input: $input) {
    items {
      acceptor {
        businessName
        fundingAchReturns
        id
        name
        reference
      }
      accountNumberEndingIn
      accountOwnerName
      accountOwnerType
      accountType
      activityDate
      amount
      currency
      fundingAmount
      fundingCurrency
      fundsReleaseDate
      fundsTransferDescriptor
      fundsTransferId
      id
      organization {
        businessName
        capabilities
        fundingAchReturns
        id
        legalName
        name
        phoneNumber
      }
      paymentId
      perspective
      reason
      reasonCode
      routingNumber
      traceNumber
      transactionActivityDate
      transactionAmount
      transactionDateTime
      transactionId
      transactionReference
      transactionTraceNumber
      transactionType
    }
    pageInfo {
      hasNextPage
      hasPreviousPage
    }
  }
}

Response

{
  "data": {
    "fundingAchReturns": {
      "items": [
        {
          "acceptor": {
            "allocations": "example",
            "authorizationSummaries": "example",
            "billingDescriptor": "CLACKSWORTH KEYBOARDS",
            "businessName": "Clacksworth Keyboards",
            "fees": "example",
            "feeSummaries": "example",
            "fundingAchReturns": "example",
            "fundingDisputeEvents": "example",
            "fundingSummaries": "example",
            "fundingTransactions": "example",
            "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
            "name": "Ben Torres",
            "paymentTransactions": "example",
            "paymentTransactionSummaries": "example",
            "reference": "example"
          },
          "accountNumberEndingIn": "example",
          "accountOwnerName": "example",
          "accountOwnerType": "CONSUMER",
          "accountType": "CHECKING",
          "activityDate": "2026-01-15",
          "amount": 0,
          "currency": "example",
          "fundingAmount": 0,
          "fundingCurrency": "example",
          "fundsReleaseDate": "2026-01-15",
          "fundsTransferDescriptor": "example",
          "fundsTransferId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
          "id": "c9a1e2d3-4b5f-6789-0abc-def123456789",
          "organization": {
            "acceptorApplicationCounts": [
              "example"
            ],
            "acceptors": "example",
            "achNotificationsOfChange": "example",
            "achReturns": "example",
            "allocations": "example",
            "allowedMerchantCategories": [
              "example"
            ],
            "authorizationSummaries": "example",
            "businessAddress": "example",
            "businessName": "Clacksworth Keyboards",
            "capabilities": [
              "ACQUIRING"
            ],
            "fees": "example",
            "feeSummaries": "example",
            "fundingAchReturns": "example",
            "fundingDisbursementReturns": "example",
            "fundingDisputeEvents": "example",
            "fundingSummaries": "example",
            "fundingTransactions": "example",
            "id": "d8b2f3e4-5c6a-7890-1bcd-ef2345678901",
            "legalName": "example",
            "name": "Ben Torres",
            "paymentTransactions": "example",
            "paymentTransactionSummaries": "example",
            "phoneNumber": "example",
            "reportAvailability": [
              "example"
            ],
            "settings": "example"
          },
          "paymentId": "e7c3a4b5-6d7e-8901-2cde-f34567890123",
          "perspective": "PARTNER",
          "reason": "example",
          "reasonCode": "R01",
          "routingNumber": "example",
          "traceNumber": "example",
          "transactionActivityDate": "2026-01-15",
          "transactionAmount": 0,
          "transactionDateTime": "2026-01-15T14:30:00Z",
          "transactionId": "b6d4e5f6-7a8b-9012-3def-456789012345",
          "transactionReference": "example",
          "transactionTraceNumber": "example",
          "transactionType": "AUTHORIZATION"
        }
      ],
      "pageInfo": {
        "hasNextPage": true,
        "hasPreviousPage": true
      }
    }
  }
}

Query

Arguments

input · FundingAchReturnInput! · required

Show child attributes

paging · PagingInput! · required

See PagingInput

where · FundingAchReturnsFilterInput! · required

Show child attributes

acceptorId · GuidFilterInput

See GuidFilterInput

activityDate · DateRangeFilterInput

See DateRangeFilterInput

fundsReleaseDate · DateRangeFilterInput

See DateRangeFilterInput

fundsTransferId · GuidFilterInput

See GuidFilterInput

perspective · EnumFilterInputOfPerspectiveInput

See EnumFilterInputOfPerspectiveInput

Return type

FundingAchReturnOutputCollection

items · [FundingAchReturnOutput!]! · required

Show child attributes

acceptor · Acceptor! · required

See Acceptor

accountNumberEndingIn · String

The last few numbers of the bank account used as a visual reference to the full account numer.

accountOwnerName · String

The name of the bank account owner, as provided by the NACHA report.

accountOwnerType · AccountOwnerType

The type of the bank account owner, as provided by the NACHA report.

See AccountOwnerType

accountType · BankAccountType

The type of the bank account, e.g., Checking or Savings.

See BankAccountType

activityDate · Date! · required

The date Tesouro received the ach return.

amount · Decimal! · required

The amount of the ach return.

currency · String! · required

The currency specified on the ach return.

fundingAmount · Decimal

The funded amount of the ACH return.

fundingCurrency · String

The currency associated with the ACH return funding amount.

fundsReleaseDate · Date

The date the debited or credited funds for the ACH return were released.

fundsTransferDescriptor · String

A value created by Tesouro and sent with the funds transfer to the recipient’s bank for display on the bank statement. It includes information on who sent the money and the purpose of the payment. The recipient can use this value to help with bank and transaction reconciliation.

fundsTransferId · UUID

A unique identifier created by Tesouro and assigned to the transfer of money to a bank account for this ach return, that identifies a cohort of funded transactions making up the transfer.

id · UUID! · required

A unique identifier created by Tesouro and assigned to the ACH return resulting in the credit or debit.

organization · Organization! · required

See Organization

paymentId · UUID

A unique 36 character identifier created by Tesouro and assigned to a group of transactions in the same payment request cohort. e.g., An authorization request, incremental authorization request, and the final capture would have the same paymentID.

perspective · Perspective

The perspective of the money movement, which can be either ‘Acceptor’ or ‘Partner’. This field is used to determine the financial perspective from which the ACH return is reported.

See Perspective

reason · String! · required

Description of return reason.

reasonCode · AchReturnCode! · required

Nacha Return Codes and associated ISO Status Reason Codes for returns and reversals from the External Code List.

See AchReturnCode

routingNumber · String! · required

A unique nine-digit number that identifies a bank and is used for electronic transactions. It’s also known as an ABA routing number, or routing transit number (RTN).

traceNumber · String! · required

A unique 15 digit reference number created by the bank and used to investigate and research ACH transfers and returns.

transactionActivityDate · Date

The date Tesouro recognized the original ACH payment request, based upon the acceptor cutoff. Formatted as YYYY-MM-DD

transactionAmount · Decimal! · required

The transaction amount submitted with the original ach request.

transactionDateTime · DateTime! · required

The date and time that Tesouro received the original ach transaction, in UTC. Formatted as 2024-03-27T02:40:00Z

transactionId · UUID! · required

A unique identifier assigned by Tesouro to the original ach transaction.

transactionReference · String

A unique identifier from original ach transaction created by the entity holding the direct relationship with the Acceptor. Tesouro uses this identifier to manage idempotency.

transactionTraceNumber · String! · required

A number that a bank can you to investigate and research an ach transaction.

transactionType · TransactionType! · required

The type of original ach transaction, e.g., Sale or Refund.

See TransactionType

pageInfo · PageInfo! · required

Show child attributes

hasNextPage · Boolean! · required

hasPreviousPage · Boolean! · required

Operation

query FundingAchReturns($input: FundingAchReturnInput!) {
  fundingAchReturns(input: $input) {
    items {
      acceptor {
        businessName
        fundingAchReturns
        id
        name
        reference
      }
      accountNumberEndingIn
      accountOwnerName
      accountOwnerType
      accountType
      activityDate
      amount
      currency
      fundingAmount
      fundingCurrency
      fundsReleaseDate
      fundsTransferDescriptor
      fundsTransferId
      id
      organization {
        businessName
        capabilities
        fundingAchReturns
        id
        legalName
        name
        phoneNumber
      }
      paymentId
      perspective
      reason
      reasonCode
      routingNumber
      traceNumber
      transactionActivityDate
      transactionAmount
      transactionDateTime
      transactionId
      transactionReference
      transactionTraceNumber
      transactionType
    }
    pageInfo {
      hasNextPage
      hasPreviousPage
    }
  }
}

Response

{
  "data": {
    "fundingAchReturns": {
      "items": [
        {
          "acceptor": {
            "allocations": "example",
            "authorizationSummaries": "example",
            "billingDescriptor": "CLACKSWORTH KEYBOARDS",
            "businessName": "Clacksworth Keyboards",
            "fees": "example",
            "feeSummaries": "example",
            "fundingAchReturns": "example",
            "fundingDisputeEvents": "example",
            "fundingSummaries": "example",
            "fundingTransactions": "example",
            "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
            "name": "Ben Torres",
            "paymentTransactions": "example",
            "paymentTransactionSummaries": "example",
            "reference": "example"
          },
          "accountNumberEndingIn": "example",
          "accountOwnerName": "example",
          "accountOwnerType": "CONSUMER",
          "accountType": "CHECKING",
          "activityDate": "2026-01-15",
          "amount": 0,
          "currency": "example",
          "fundingAmount": 0,
          "fundingCurrency": "example",
          "fundsReleaseDate": "2026-01-15",
          "fundsTransferDescriptor": "example",
          "fundsTransferId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
          "id": "c9a1e2d3-4b5f-6789-0abc-def123456789",
          "organization": {
            "acceptorApplicationCounts": [
              "example"
            ],
            "acceptors": "example",
            "achNotificationsOfChange": "example",
            "achReturns": "example",
            "allocations": "example",
            "allowedMerchantCategories": [
              "example"
            ],
            "authorizationSummaries": "example",
            "businessAddress": "example",
            "businessName": "Clacksworth Keyboards",
            "capabilities": [
              "ACQUIRING"
            ],
            "fees": "example",
            "feeSummaries": "example",
            "fundingAchReturns": "example",
            "fundingDisbursementReturns": "example",
            "fundingDisputeEvents": "example",
            "fundingSummaries": "example",
            "fundingTransactions": "example",
            "id": "d8b2f3e4-5c6a-7890-1bcd-ef2345678901",
            "legalName": "example",
            "name": "Ben Torres",
            "paymentTransactions": "example",
            "paymentTransactionSummaries": "example",
            "phoneNumber": "example",
            "reportAvailability": [
              "example"
            ],
            "settings": "example"
          },
          "paymentId": "e7c3a4b5-6d7e-8901-2cde-f34567890123",
          "perspective": "PARTNER",
          "reason": "example",
          "reasonCode": "R01",
          "routingNumber": "example",
          "traceNumber": "example",
          "transactionActivityDate": "2026-01-15",
          "transactionAmount": 0,
          "transactionDateTime": "2026-01-15T14:30:00Z",
          "transactionId": "b6d4e5f6-7a8b-9012-3def-456789012345",
          "transactionReference": "example",
          "transactionTraceNumber": "example",
          "transactionType": "AUTHORIZATION"
        }
      ],
      "pageInfo": {
        "hasNextPage": true,
        "hasPreviousPage": true
      }
    }
  }
}