Transaction report

An itemized list of transaction requests received on the given transaction activity date. Includes authorizations, captures, refunds, card verifications, bank transfer sales, and bank account validations. Use this report to reconcile received transactions against your internal record of submitted transactions.

Field	Description
`ACCEPTOR_ID`	A 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). Historically, processors have called this identifier the Merchant ID (or 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.
`ADVICE`	When a transaction request is declined, Tesouro will provide advice on what can be done to remedy, and/or prevent this type of response from occurring in the future.
`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.
`BILLING_DESCRIPTOR`	The billing descriptor name that appears on the customer’s statement.
`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.
`DECLINE_TYPE`	The type of decline, as determined by Tesouro, either soft decline or hard decline.
`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_FUNDED`	Indicates if the funding amount has been released, if applicable. Defined as having a funds transfer ID and funds transfer release date.
`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.
`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 response code.
`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 postal code for where the purchased goods are to be sent.
`SHIP_TO_STATE_OR_PROVINCE`	The state for where the purchased goods are to be sent.
`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 number that identifies an Automated Clearing House (ACH) transaction. It’s used by the bank to track the transaction and resolve issues. Applicable only to ACH bank transfers.
`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_PROCESSING_DECISION`	Tesouro’s decision to approve or decline, or accept or reject the transaction request. Note, this is different than the Authorization response returned from the payment network.
`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, Capture, Refund, Reversal, Incremental authorization, Authentication.
`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
`VALIDATION_SCORE`	A risk score between 0-1000 indicating the likelihood of fraud for a bank account. The lower the score, the more likely the risk of fraud. Applicable to bank account validations only.

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: transaction_{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

Transaction report

Report availability

Report format

​Report availability

​Report format

Report availability

Report format