Skip to main content
A comprehensive and detailed list of each money movement event for the partner and its acceptors for a given funds release date or activity date, including: settlements, disputes, processing fees, and partner-collected fees. Use this report to reconcile partner and acceptor payments, get a detailed breakdown of a given funds release, and calculate acceptor profitability.
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.
ACCOUNT_NUMBER_PREFIXThe first few numbers of the bank or card account used as a visual reference to the full account number.
ACCOUNT_NUMBER_SUFFIXThe last few numbers of the bank or card account used as a visual reference to the full account number.
ACTIVITY_DATEThe date the allocation was applied
ALLOCATION_TYPEThe type of allocation, e.g., Interchange fee, network fee, processor fee, partner fee, partner settlement, acceptor settlement.
BILLABLE_EVENT_AMOUNTThe amount tied to the billable event and what is used to calculate the allocation when a fee rate multiplier is part of the fee rate.
BILLABLE_EVENT_CURRENCYThe currency of the billable event, formatted in ISO 4217 alphabetic code.
BILLABLE_EVENT_TYPEThe billable event that this allocation applies to, e.g., Authorization, Chargeback, AVS, Account updater, etc.
BILLING_EVENT_SOURCE_IDA reference to the ID of item that the fee applies to.
BILLING_EVENT_SOURCE_TYPEThe type of entity that the billing event source ID references, including, but not limited to: Transaction, Funds Transfer, Boarding Request, Acceptor, ACH Return, ACH Notice Of Change, Dispute.
CALCULATED_ALLOCATION_AMOUNTThe total allocation amount calculated as a percentage of the transaction amount (including taxes), a flat allocation, or a combination of both.
CONSUMER_TYPEThe type of account associated with the cardholder’s card, e.g., Consumer, Commercial, Government, etc., which has an impact on the interchange qualification. NOTE: This field will present a null, not applicable, or empty value if the fee is not tied to a specific transaction.
DESCRIPTIONA detailed description of the allocation.
FUNDING_CURRENCYThe currency of the funded allocation, 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_DESCRIPTORA 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_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.
NAMEThe name of the allocation.
ORDER_REFERENCEA unique identifier created by the acceptor and assigned to the order placed by the customer.
ORGANIZATION_IDThe unique 36 character identifier created by Tesouro, and used to identify 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.
PAYMENT_IDA 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, as would any related fees or disputes.
PAYMENT_PRODUCTThe product name according to the payment brand (e.g. World Elite Mastercard card), if applicable.
PERSPECTIVEThe perspective of the allocation, which can be either ‘Acceptor’ or ‘Partner’. This field is used to determine the perspective from which the allocation is reported.
PLANNED_FUNDS_RELEASE_DATEThe date the funding is expected to be released, but may not be confirmed.
PRESENTER_IDA unique, 36 character identifier created by Tesouro and assigned to the machine user or system entity that is credentialed to make API requests and present payments to Tesouro and the network.
PROCESSING_NETWORKThe payment network that the transaction was processed on, which may be unaffiliated with the card brand.
PRODUCT_PILLARThe Tesouro product pillar that this fee applies to, e.g., Transaction processing; Billing & Funding; Risk, Fraud, & Dispute management; Reporting; Boarding;
RATE_MULTIPLIERA component of the allocation 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
RATE_UNIT_AMOUNTA component of the allocation rate; the unit amount charged per item. e.g., $0.10
TRANSACTION_DATE_TIMEThe date and time that Tesouro received the transaction request, in UTC. Formatted as 2024-03-27T02:40:00Z
TRANSACTION_IDA unique 36 character identifier assigned by Tesouro for every transaction request received.
TRANSACTION_REFERENCEThe unique identifier assigned to the transaction by the acceptor (or partner) and included in original transaction request sent to Tesouro.

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:
    • allocation-details_by-funds-release-date_{startdate:YYYYMMDD}-{endDate:YYYYMMDD}_{generationDate:YYYYMMDDThhmmss}.csv
    • allocation_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.