Skip to main content
A summary of transaction counts and amounts by transaction activity date. Use this report to reconcile received transactions against your internal record of submitted transactions.
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.
CONVEYED_STATUSIdentifies those transactions that are or will be conveyed to another acquirer
ORGANIZATION_IDA unique 36 character identifier created and used by Tesouro, and assigned to the organization holding the relationship with Tesouro.
PAYMENT_BRANDThe payment brand used, e.g., Visa, Mastercard, Discover, American Express, etc.
PAYMENT_FUNDING_SOURCEThe 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.
PROCESSING_NETWORKThe payment network that the transaction was processed on, which may be unaffiliated with the card brand.
TRANSACTION_ACTIVITY_DATEThe date Tesouro recognized the payment request based upon the acceptor cutoff. Formatted as YYY-MM-DD
TRANSACTION_AMOUNTThe amount of the transaction request sent to Tesouro.
TRANSACTION_COUNTThe total quantity of transactions.
TRANSACTION_CURRENCYThe currency specified on the transaction request, in ISO 4217 alpha currency code format.
TRANSACTION_PROCESSING_DECISIONTesouro’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_TYPEThe type of transaction, e.g., Authorization, Refund authorization, or Incremental authorization.

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: transaction_summaries_{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.