Skip to main content
A summary of funding activity (counts and amounts) by transaction activity date or funds release date, including settlements, disputes, fees, adjustments, and returns, grouped by funds transfer. Use this report to understand the financial impact of daily sales, refunds, disputes, and associated fees, and to reconcile funds transfers to bank deposits.
FieldDescription
ACCEPTOR_ACH_RETURNS_AMOUNTTotal monetary amount of ACH returns from the acceptor.
ACCEPTOR_FUNDING_NET_AMOUNTAcceptor net funding amount, calculated as [Net sales + Net disputes + Passthrough fees + Partner fees amounts.]
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_PAYMENTS_AMOUNTThe total amount transferred to the acceptors’ bank accounts.
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.
ACH_RETURNS_AMOUNTTotal monetary amount of ACH returns
ACH_RETURNS_COUNTTotal number of ACH returns
CONVENIENCE_FEES_AMOUNTTotal amount of convenience fees charged to the customer.
CONVENIENCE_FEES_COUNTTotal number of convenience fees charged to the customer.
DISPUTES_COUNTThe total number of dispute debits and credits applied on your account. Calculated as [Dispute credits count + Dispute debits count]
DISPUTES_CREDIT_AMOUNTThe amount of financially impacting dispute events (e.g., representments) credited to your account.
DISPUTES_CREDIT_COUNTThe number of financially impacting dispute events (e.g., representments) credited to your account.
DISPUTES_DEBIT_AMOUNTThe amount of financially impacting dispute events (e.g., 1st chargebacks) debited from your account.
DISPUTES_DEBIT_COUNTThe number of financially impacting dispute events (e.g., 1st chargebacks) debited from your account.
DISPUTES_NET_AMOUNTThe net amount of financially impacting dispute events funded to our from your account. Calculated as [Dispute credits - Dispute debits].
FEE_AMOUNTThe total amount of fees.
FUNDED_DISPUTES_COUNTThe funding (aka, settlement) currency of the transaction, in ISO 4217 alpha currency code format.
FUNDING_CURRENCYThe funding amount of the transaction after deducting any applicable fees.
FUNDING_NET_AMOUNTThe amount transferred from Tesouro to the recipient’s bank.
FUNDS_RELEASE_DATEThe date the funded transaction amount is released.
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 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.
FUNDS_TRANSFER_PROFILE_IDA reusable identifier created and used internally by Tesouro, and assigned to the configuration of funding profiles specifying who and/or where the funds transfer is sent.
FUNDS_TRANSFER_PROFILE_NAMEA reusable, descriptive name specified by the transactor, labeling who and/or where the funds transfer is going. E.g., the name of a specific acceptor, a group of acceptors, a bank account, etc.
INTERCHANGE_FEES_AMOUNTThe 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.
INTERCHANGE_FEES_COUNTTotal number of interchange fees.
MISC_ADJUSTMENTS_AMOUNTThe net amount of miscellaneous adjustments. Calculated as [Miscellaneous credits - Miscellaneous debits].
MISC_CREDITS_AMOUNTThe total amount of miscellaneous credits.
MISC_CREDITS_COUNTThe total number of miscellaneous credits.
MISC_DEBITS_AMOUNTThe total amount of miscellaneous debits.
MISC_DEBITS_COUNTThe total number of miscellaneous debits.
NETWORK_FEES_AMOUNTTotal amount of network fees.
NETWORK_FEES_COUNTThe total number of network fees.
ORGANIZATION_IDA unique 36 character identifier created and used by Tesouro, and assigned to the organization holding the relationship with Tesouro.
PARTNER_FEES_AMOUNTThe amount of the partner fees.
PARTNER_FEES_COUNTThe number of partner fees.
PAYMENT_BRANDThe payment brand used, e.g., Visa, Mastercard, Discover, American Express, etc.
PROCESSING_NETWORKThe payment network that the transaction was processed on, which may be unaffiliated with the card brand.
PROCESSOR_FEES_AMOUNTThe amount of processor fees applicable to this transaction. Processor fees are set by and paid to Tesouro.
PROCESSOR_FEES_COUNTThe total number of individual processor fees
REFUNDS_COUNTThe total number of refunds.
REFUNDS_GROSS_AMOUNTThe total amount of refunds before any fees are deducted.
RESERVES_NET_AMOUNTThe net amount of reserves.
SALES_COUNTThe total number of funded sales. Calculated as captures + sales.
SALES_GROSS_AMOUNTThe total amount of captured sales before any fees are deducted.
SALES_NET_AMOUNTThe net total amount of captured sales after any fees are deducted.
SERVICE_FEES_AMOUNTTotal amount of service fees charged to the customers.
SERVICE_FEES_COUNTTotal number of service fees charged to the customers.
SURCHARGE_AMOUNTThe amount of surcharges charged to the customer.
SURCHARGE_COUNTThe amount of surcharges charged to the customer.
THIRD_PARTY_PAYMENT_AMOUNTThe total amount of any payments distributed to third parties.
TRANSACTION_ACTIVITY_DATEThe date Tesouro recognized the payment request based upon the acceptor cutoff. Formatted as YYY-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 removed from the SFTP location after 14 calendar days.

Report format

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