Funding transactions report

An itemized list of transactions that are in the process of being funded or were released for funding, filtered by transaction activity date or the funds release date. Use this report to reconcile your payments back to your orders.

Field	Description
`ACCEPTOR_ID`	The 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_NAME`	A 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_REFERENCE`	A 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_IN`	The last few numbers of the bank account used as a visual reference to the full account number.
`ACCOUNT_NUMBER_FIRST_SIX`	The leading digits of the cardholder’s payment card.
`ACCOUNT_NUMBER_LAST_FOUR`	The last four digits of the cardholder’s payment card.
`ACCOUNT_OWNER_NAME`	The name of the bank account owner, as provided by the NACHA report. Applicable only to ACH bank transfers.
`ACCOUNT_OWNER_TYPE`	The type of the bank account owner, as provided by the NACHA report. Applicable only to ACH bank transfers.
`ACCOUNT_TYPE`	The type of the bank account, e.g., Checking or Savings. Applicable only to ACH bank transfers.
`ACQUIRER_REFERENCE_NUMBER`	The Acquirer Reference Number (ARN), is a unique 23 digit number created by Tesouro, and assigned to a transaction and provided to the acquiring and issuing banks for their purpose of being able to trace the transaction through the full process until it is funded to the bank.
`ACQUIRER_TOKEN`	The acquirer token on file for the payment method, if the payment method has been used before and the transactor is subscribed to Tesouro’s tokenization services. Otherwise, this field’s value will be null.
`APPROVED_AMOUNT`	The transaction amount approved for processing.
`AVS_RESPONSE`	The Address Verification Service (AVS) result provided by the payment brand that verifies the entered address information matches the address information on file with the issuing bank.
`BUSINESS_APPLICATION_ID`	The business application identifier (BAI) is a value provided by Visa to identify the type of transfer that is being performed. Applicable only to acceptors participating in Visa’s Consumer Bill Payment Service program.
`CAPTURE_ON_APPROVAL`	Indicates that the authorization will be automatically captured if approved.
`CARDHOLDER_FIRST_NAME`	The first name of the individual associated with this payment method’s billing address.
`CARDHOLDER_LAST_NAME`	The last name of the individual associated with this payment method’s billing address.
`CARD_EXPIRATION`	The two-digit month and four-digit year of the card’s expiration date. e.g., MMYYYY
`CASHBACK_AMOUNT`	The amount of cash back requested by the cardholder.
`CONSUMER_TYPE`	The type of account associated with the cardholder’s card, e.g., Consumer, Commercial, Government, etc., which has an impact on the interchange qualification.
`CONVENIENCE_FEES_AMOUNT`	Total amount of convenience fees charged to the customer.
`CONVEYED_STATUS`	Identifies those transactions that are or will be conveyed to another acquirer
`CUSTOMER_REFERENCE`	A unique identifier created by the acceptor or organization and assigned to the customer who placed the order.
`CUSTOMER_STATEMENT_MEMO`	Information that appears on the bank account owner’s bank statement and describes the transaction. Applicable only to ACH bank transfers.
`DISCOUNT_AMOUNT`	The total discount amount applied to the transaction.
`DUTY_AMOUNT`	Total charges for any import or export duties included in the order.
`ENTRY_MODE`	The means by which the payment details are captured, e.g., Card swipe, contactless “tap”, chip entry, keyed, etc.
`FUNDING_CURRENCY`	The funding (aka, settlement) currency of the transaction, in ISO 4217 alpha currency code format.
`FUNDING_GROSS_AMOUNT`	The funding amount of the transaction before any applicable fees are deducted.
`FUNDING_NET_AMOUNT`	The funding amount of the transaction after deducting any applicable fees.
`FUNDS_RELEASE_DATE`	The date the funded transaction amount is released.
`FUNDS_TRANSFER_DESCRIPTOR`	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.
`FUNDS_TRANSFER_ID`	A unique identifier created by Tesouro and assigned to the transfer of money to a bank account for this dispute, that identifies a cohort of funded transactions making up the transfer.
`GRATUITY_AMOUNT`	The amount of gratuity added to the transaction.
`INTERCHANGE_FEES_AMOUNT`	The amount of interchange fees applicable to the transaction. Interchange fees are set by the card networks, and paid to the bank that issued the card used for the transaction.
`ISSUING_BANK_COUNTRY`	The ISO 3166-1 three-letter country code associated with the issuing bank.
`ISSUING_BANK_NAME`	The name of the bank that issued the card
`IS_PARTNER_FEE_ADJUSTED`	Indicates if the partner fee was adjusted at the transaction level to override a set value configured within the acceptor profile.
`LINE_ITEM_DETAILS`	A list of items including description, commodity code, product code, product SKU, unit price and quantity, total line item amount, and tax and discount amounts applicable to the transaction.
`LOCAL_TAX`	The total amount of local tax for this payment transaction request. Local tax is imposed by municipal, city, or regional governments and may include sales tax, service tax, or other location-based levies applicable to the transaction.
`MERCHANT_CATEGORY`	Unique ISO four digit values used to classify merchants and their transactions into specific categories based on the type of business, trade or services supplied.
`NAME_VERIFICATION`	The result of the name verification service, which checks if the cardholder name submitted with the transaction matches what is on record with the issuer.
`NATIONAL_TAX`	The total amount of national tax for this payment transaction request. National tax is a government-imposed tax at the federal or country level, such as Goods and Services Tax (GST), or federal sales tax.
`NETWORK_APPROVAL_CODE`	A six-digit code returned from the network on APPROVED authorizations, and displayed on the customer’s receipt. If the authorization declined, this field will be blank.
`NETWORK_AVS_RESPONSE`	The response code sent from the network detailing the address verification service (AVS) result.
`NETWORK_FEES_AMOUNT`	Total amount of network fees.
`NETWORK_RESPONSE_CODE`	A response code provided by the card network indicating whether the transaction was approved or declined.
`NETWORK_RESPONSE_MESSAGE`	A human readable description of the authorization response code. e.g., Insufficient funds.
`ORDER_REFERENCE`	A unique identifier created by the acceptor and assigned to the order placed by the customer.
`ORGANIZATION_ID`	A unique 36 character identifier created and used by Tesouro, and assigned to the organization holding the relationship with Tesouro.
`PARTNER_FEES_AMOUNT`	The amount of the partner fees.
`PAYMENT_BRAND`	The payment brand used, e.g., Visa, Mastercard, Discover, American Express, etc.
`PAYMENT_CHANNEL`	The card-present or card-not-present channel from which the customer makes a payment, e.g., In-store using a physical card terminal, online, or over the phone or through mail order.
`PAYMENT_FUNDING_SOURCE`	The source of the customer’s funds , e.g., credit, debit, pre-paid, cash. NOTE: This field will present a null, not applicable, or empty value if the fee is not tied to a specific transaction.
`PAYMENT_ID`	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.
`PAYMENT_METHOD_TYPE`	The type of payment method used by the customer to submit the transaction, e.g., Card, Bank transfer, etc.
`PAYMENT_PRODUCT`	The product name according to the payment brand (e.g. World Elite Mastercard card), if applicable.
`PROCESSING_NETWORK`	The payment network that the transaction was processed on, which may be unaffiliated with the card brand.
`PROCESSOR_FEES_AMOUNT`	The amount of processor fees applicable to this transaction. Processor fees are set by and paid to Tesouro.
`PROCESSOR_RESPONSE_CODE`	A response code provided Tesouro indicating whether the transaction was approved or declined.
`PROCESSOR_RESPONSE_MESSAGE`	A human readable description of the authorization response code. e.g., Insufficient funds.
`RESPONSE_TYPE`	The type of response, e.g., APPROVAL, SOFT_DECLINE, HARD_DECLINE, REJECT
`ROUTING_NUMBER`	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).
`SECURITY_CODE_NETWORK_RESPONSE`	The response code sent from the network detailing the card security code verification results.
`SECURITY_CODE_NORMALIZED_RESPONSE`	The card security code verification result, normalized and described by Tesouro.
`SERVICE_FEES_AMOUNT`	Total amount of service fees charged to the customer..
`SHIPPING_AMOUNT`	The amount charged for shipping the goods.
`SHIP_FROM_ADDRESS_01`	The address from where the line item was sent.
`SHIP_FROM_ADDRESS_02`	The address from where the line item was sent.
`SHIP_FROM_ADDRESS_03`	The address from where the line item was sent.
`SHIP_FROM_CITY`	The city from where the line item was sent.
`SHIP_FROM_COUNTRY`	The country from where the line item was sent.
`SHIP_FROM_POSTAL_CODE`	The postal code from where the line item was sent.
`SHIP_FROM_STATE_OR_PROVINCE`	The state or province from where the line item was sent.
`SHIP_TO_ADDRESS_01`	The street address for where the purchased goods are to be sent.
`SHIP_TO_ADDRESS_02`	The street address for where the purchased goods are to be sent.
`SHIP_TO_ADDRESS_03`	The street address for where the purchased goods are to be sent.
`SHIP_TO_CITY`	The city for where the purchased goods are to be sent.
`SHIP_TO_COUNTRY`	The country for where the purchased goods are to be sent.
`SHIP_TO_DETAILS_INDICATOR`	An indicator reporting if the customer’s shipping information was submitted with the payment.
`SHIP_TO_POSTAL_CODE`	The amount charged for shipping the goods.
`SHIP_TO_STATE_OR_PROVINCE`	The amount of surcharges charged to the customer.
`SUBTOTAL_AMOUNT`	The sum of all item costs in the transaction before applying any additional charges such as taxes, or fees
`SURCHARGE_AMOUNT`	The amount of surcharges charged to the customer.
`TAX_IDENTIFICATION_NUMBER`	A unique identifier created by the national government and assigned to acceptor at the time this transaction was submitted.
`TOTAL_TAX`	The total amount of all taxes for this payment transaction request. Must be present if either local or national tax are present.
`TRACE_NUMBER`	A unique 15 digit reference number created by the bank and given to the original ACH transfer.
`TRANSACTION_ACTIVITY_DATE`	The date Tesouro recognized the payment request based upon the acceptor cutoff. Formatted as YYY-MM-DD
`TRANSACTION_AMOUNT`	The amount of the transaction request sent to Tesouro.
`TRANSACTION_CURRENCY`	The currency specified on the transaction request, in ISO 4217 alpha currency code format.
`TRANSACTION_ID`	A unique 36 character identifier assigned by Tesouro for every transaction request received.
`TRANSACTION_REFERENCE`	A unique identifier created by the Presenter (or Acceptor) and assigned to the transaction request passed to Tesouro to manage idempotency.
`TRANSACTION_TS_UTC`	The date and time that Tesouro received the transaction, in UTC. Formatted as YYYY-MM-DDTHH:MM::SSZ
`TRANSACTION_TYPE`	The type of transaction, e.g., Authorization, Refund authorization, or Incremental authorization.
`TRANSFER_EFFECTIVE_DATE`	The date that Tesouro requests the funds to be transferred from (or to) the bank account owner’s bank account. Applicable only to ACH bank transfers. Formatted as YYYY-MM-DD

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 are removed from the SFTP location after 14 calendar days.

Report format

CSV file, following the RFC 4180 standard
File name:
- funding-transactions_by-funds-release-date_{startdate:YYYYMMDD}-{endDate:YYYYMMDD}_{generationDate:YYYYMMDDThhmmss}.csv
- funding-transactions_by-activity-date_{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.

Getting started

Report catalog

Report specs

Funding transactions report

Report availability

Report format

​Report availability

​Report format

Report availability

Report format