Skip to main content
A summary of interchange, network fee, and processor fee counts and amounts, grouped by acceptor and fee type, for the given fee activity date or funds release date. Use this report to understand the costs of your Merchant Services account.
FieldDescription
ACCEPTOR_IDA 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_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.
BILLABLE_EVENT_AMOUNTThe amount tied to the billable event and what is used to calculate the Fee when a fee rate multiplier is part of the fee rate.
BILLABLE_EVENT_TYPEThe billable event that this fee applies to, e.g., Authorization, Chargeback, AVS, Account updater, etc.
FEE_ACTIVITY_DATEThe date the fee was applied
FEE_AMOUNTThe total amount of fees calculated.
FEE_COUNTThe number of fees
FEE_DESCRIPTIONA detailed description of the fee or program
FEE_NAMEThe name of the fee, interchange or wholesale program
FEE_PROFILE_IDA unique identifier created by Tesouro and assigned to each fee allocation
FEE_RATE_MULTIPLIERA component of the fee rate; the decimal used to multiply against the transaction amount to determine a “percent” cost. Expressed as a decimal, e.g., a 2.5% multiplier will be expressed as 0.025
FEE_RATE_UNIT_AMOUNTA component of the fee rate; the unit amount charged per item. e.g., $0.10
FEE_TYPEThe type of fee, e.g., Interchange, Network, Processor, etc.
FUNDING_CURRENCYThe currency of the funded transaction, formatted in ISO 4217 alphabetic code.
FUNDS_RELEASE_DATEThe date that Tesouro releases the funds from its bank account to the recipient’s bank account.
FUNDS_TRANSFER_IDA unique identifier created and used by Tesouro, and assigned to the transfer of money to a bank account, to identify a cohort of funded transactions making up the transfer.
MERCHANT_CATEGORYUnique ISO four digit values used to classify merchants and their transactions into specific categories based on the type of business, trade or services supplied. NOTE: This field will present a null, not applicable, or empty value if the fee is not tied to a specific transaction.
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. NOTE: This field will present a null, not applicable, or empty value if the fee is not tied to a specific transaction.
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.
PAYMENT_PRODUCTThe product name according to the payment brand (e.g. World Elite Mastercard card), if applicable. 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. NOTE: This field will present a null, not applicable, or empty value if the fee is not tied to a specific transaction.
PRODUCT_PILLARThe Tesouro product pillar that this fee applies to, e.g., Transaction processing; Billing & Funding; Risk, Fraud, & Dispute management; Reporting; Boarding;

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:
    • fee-summaries_by-funds-release-date_{startdate:YYYYMMDD}-{endDate:YYYYMMDD}_{generationDate:YYYYMMDDThhmmss}.csv
    • fee-summaries_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.