Payout Details Report
For each transaction included in the specified payout, this report provides order, payment, and fee information. It is helpful for a transaction-level reconciliation of your deposits from BlueSnap. If you need more information about a particular transaction, you can cross-reference the Transaction Details report, which is linked to the Payout Details report by the Payment ID and Invoice ID parameters.
Notes
- The Custom Field columns that display in this report are optional.
- The report columns listed below with an asterisk (*) can be used to filter the results when you run the report.
- All reports show currency values in US format (i.e., 123,456.00) regardless of the currency being displayed.
- The Disbursement Amount values are presented in the currency the payout is calculated in, while the Disbursement Currency values refer to the currency the funds will be received in (your set payout currency). If the payout is not like-for-like and we use a third party to convert the payout funds, these two currencies will not match.
Report Columns
| Column Names | Description |
|---|---|
| 3DS Authentication | If the transaction was successfully authenticated using 3D Secure, the value is Yes. Otherwise, the value is No. |
| Amount Paid to Vendor/Affiliate | Any amounts owed to Affiliates or Vendors from the transaction. |
| Auth Invoice ID | A unique value assigned by BlueSnap to each Auth transaction. |
| Authorized On | The date the transaction was authorized. |
| BIN Business Category | Indicates whether the card was a consumer card or a corporate card. |
| BIN Country | The country where the payment card was issued. |
| BlueSnap Processing Fees | BlueSnap processing fees assessed on the transaction. |
| Captured On | The date the transaction was captured. |
| Card Category | Applies to credit and debit card payments only (e.g. Classic, Gold, Platinum, Business). |
| Company Name | The shopper's company name. |
| Contract ID* | A unique value assigned to each contract created in the BlueSnap product catalog. |
| Contract Name | The contract purchased by the shopper. Applicable for merchants using the BlueSnap contract catalog. |
| Cross Border | Indicates that the shopper was in a different country than the merchant. |
| Disbursement Currency | 3-digit code of the currency of the bank account where you will receive proceeds from the transaction. |
| Failover | If the transaction was initially declined and then was ultimately successful as a result of BlueSnap's failover functionality, then the value is Yes. Otherwise, the value is No. |
| Gross Payout Amount | The transaction amount converted to the Payout Currency. |
| Invoice ID* | A unique value assigned by BlueSnap to each captured sale, refund, or chargeback. |
| Merchant Transaction ID* | A unique value sent by the merchant with a transaction request. |
| Meta‑<The MetaData Key> | Displays new report columns when metadata keys are used; for example, if the metadata keys are Name, City, and Country, each of those keys will display as a column. The values in each row will be taken from the metadata values sent with each transaction, which correspond to the relevant key, such as Name=Dan. |
| Multiple Vendor Data | Applies to Marketplaces and Affiliates only. Value is a comma-separated string of all vendor IDs and names associated with the transaction. For example: “1111111 (vendor1) , 2222222 (vendor2)”. |
| Original Invoice ID | Applies to recurring charges, refunds, and chargebacks. For recurring charges, the value provided is the invoice ID for the first charge of the subscription. For refunds and chargebacks, the value is the Invoice ID for the sale being refunded or disputed. |
| Paid Directly by 3rd party | Any amounts that will be paid to you by a 3rd party for the transaction (e.g. PayPal). |
| Payment ID* | A unique value assigned by BlueSnap to each payout. |
| Payment Method | Electronic Check, PayPal, Credit Card (for example, Visa Credit) |
| Payment Subtype | Subtypes of "Online banking" payment type. |
| Payment Type | Credit Card, PayPal, Electronic Check, etc. |
| Payout Currency* | Payout Currency will be the same as the Disbursement currency unless the disbursement is an exotic currency. When disbursements are in an exotic currency, the Payout currency will be USD. |
| Payout Planned Date | The date a payment is expected to be initiated according to your payout schedule. If the Planned Date falls on a weekend or bank holiday, the payment will be initiated on the next business day. |
| Payout Transfer Date | Date when a payment took place. |
| PayPal Processing Fees | Applies to PayPal transactions only. Any fees charged by PayPal for the transaction. |
| Product ID* | A unique value assigned to each product created in the BlueSnap product catalog. |
| Product Name | The product purchased by the shopper. Applicable for merchants using the BlueSnap product catalog. |
| Quantity | The product quantity purchased by the shopper. |
| Region** | Region where deposit is processed (**only available for merchants on regional payout). |
| Regulated Issuer | Y or N; Specifies if the BIN is regulated. |
| Shopper First Name | The shopper's first name. |
| Shopper ID | A unique value assigned by BlueSnap to each shopper. |
| Shopper Last Name | The shopper's last name. |
| Total Disbursement | The currency of the funds deposited in your account by BlueSnap. Gross Payout Amount - Amount Paid to Vendor/Affiliate - Paid Directly by Third Party - BlueSnap Processing Fees. |
| Transaction Amount | The amount charged to the shopper. |
| Transaction Currency | 3-digit code of the currency charged to a shopper. |
| Transaction Type | Charge, Chargeback, Chargeback Win, RDR Reversal, Refund, or Second Chargeback |
| Tax/VAT Remitted by BlueSnap | This is the portion of your Gross amount, which BlueSnap will retain and remit to the relevant authorities. |
| VAT/Tax | The amount of any VAT or Tax included in the Gross Payout Amount. |
| VAT on Processing Fees | Total amount of VAT on processing fees. |
| Vendor/Affiliate ID* | Applies to Marketplaces and Affiliates only. A unique value assigned by BlueSnap to each marketplace vendor or affiliate. A value in this column means one vendor or affiliate is associated with the transaction. If this is empty and Vendor/Affiliate Name states MULTIPLE VENDORS, then the transaction includes 2 or more vendors. Refer to Multiple Vendor Data for the CSV of all vendors associated with the transaction. |
| Vendor/Affiliate Name* | Applies to Marketplaces and Affiliates only. The name of the vendor or affiliate associated with a specific transaction. If the transaction includes 2 or more vendors, the value is MULTIPLE VENDORS. Refer to Multiple Vendor Data for the CSV of all vendors associated with the transaction. |
Parameter Names
- From date
- Invoice ID
- Merchant Transaction ID
- Payout Currency
- Payment ID
- Period
- Region** (only available for merchants on regional payout)
- To date
- Vendor/Affiliate
Updated about 2 months ago