On this page
No Headings
Last updated: June 30, 2026
The Pricing Transaction report helps you reconcile transaction costs and analyze pricing trends across your platform. It provides a detailed breakdown of costs by type, including PayPal fees, processing costs, interchange, and assessment fees.
Before using this report, review these important requirements and considerations:
1000 in the report.We improve reports on an ongoing basis, which could include adding attributes. Read the report data by column header name instead of by column index, and use column names when you integrate with these reports, so that your integrations do not break when we add new columns.
The file name of the Pricing Transaction report for a single account follows this naming convention:
PRICING_TXN.<yyyymm>.<PartnerIdentifier>.<ReportingWindow>.<SequenceNumber>.<MajorVersion>.<MinorVersion>.<Format>| Field | Description |
|---|---|
PRICING_TXN | An abbreviation for Pricing Transaction report |
yyyymm | The month for the data in the report |
PartnerIdentifier | The partner's button source code or organization name |
ReportingWindow | The time window in which the report was generated: - A: America/New York to America/Los Angeles - H: America/Los Angeles to Asia/Hong Kong - R: Asia/Hong Kong to Europe/London - X: Europe/London to America/New York |
SequenceNumber | The sequence number of the report file. The sequence number begins with 0 and continues until all parts of the report are recorded in files. The sequence number is always present in the report filename, even if there is only 1 file. |
MajorVersion | The major version of the report. This number increments when there are significant changes to the report. |
MinorVersion | The minor version of the report. This number increments with any change to the report. If there are no changes, it is 0. |
Format | The report format is CSV (comma-separated values). |
Each row of the report consists of a 2-letter row type, followed by the details for that row type. The following table lists the valid row types and the sections that describe the data for that row type.
| Code | Description |
|---|---|
FH | File header |
SH | Section header |
CH | Column header |
SB | Section body |
SF | Section footer |
FF | File footer |
The file header contains report metadata and configuration information.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (file header, FH) |
| 2 | Report Generation Date | Date-time | The date and time when the report file was generated, in this format: YYYY/MM/DD HH:MM:SS offset. offset is the 5-character signed offset from GMT, for example +0800. |
| 3 | Reporting Window | Varchar | The time window in which the report was generated: - A: America/New York to America/Los Angeles - H: America/Los Angeles to Asia/Hong Kong - R: Asia/Hong Kong to Europe/London - X: Europe/London to America/New York |
| 4 | Report Period Start Date | Date-time | The beginning date and time of transactions to include in the report, in this format: YYYY/MM/DD HH:MM:SS offset. offset is the 5-character signed offset from GMT, for example +0800. |
| 5 | Report Period End Date | Date-time | The final date and time of transactions to include in the report, in this format: YYYY/MM/DD HH:MM:SS offset. offset is the 5-character signed offset from GMT, for example +0800. |
The section header identifies the start of a new data section within the report.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (section header, SH) |
The section body contains 1 row per transaction, and it includes detailed cost and pricing information for each transaction.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (section body, SB) |
| 2 | TRANSACTION_TYPE | Varchar | The type of transaction: ACH_REVERSAL, AUTH, BONUS, CHARGEBACK, CORRECTION, CURRENCY_CONVERSION, DEPOSIT, DISBURSEMENT, DISPUTE, FEES, HOLD, HOLD_RELEASE, INCENTIVES, OTHERS, PAYABLE, PAYMENT, PAYOUT_REFUND, PAYOUT_REVERSAL, RECEIVABLE, RECOUP, REFUND, REVERSAL, SETTLEMENT_CONSOLIDATION, TRANSFER, or WITHDRAWAL |
| 3 | TRANSACTION_SUBTYPE | Varchar | The subtype of the transaction: BANK, BONUS, FEE, FOREIGN_WITHDRAWAL, FROM, LOSS_ACCOUNT, MASSPAY, PARTNER_FEE, PAYMENT_FEE, REFUND, REVERSAL, TO, or VOID |
| 4 | PRICING_FEE_TYPE | Varchar | The fee type, based on the transaction and direction of money movement: SALE, REFUND, CHARGEBACK, or CURRENCY_CONVERSION |
| 5 | SELLER_ACCOUNT_ID | Varchar | The merchant's encrypted PayPal account number |
| 6 | PAYPAL_REFERENCE_ID | String | The original PayPal transaction ID that this event references |
| 7 | PAYPAL_TRANSACTION_ID | Varchar | The PayPal transaction ID |
| 8 | INVOICE_ID | Varchar | The invoice ID of the transaction |
| 9 | CUSTOM_FIELD | Varchar | A field for custom data |
| 10 | TRANSACTION_DATE | Date-time | The date and time the transaction was initiated, in this format: YYYY/MM/DD HH:MM:SS offset. offset is the 5-character signed offset from GMT, for example +0800. |
| 11 | INTEGRATION_IDENTIFIER | Varchar | The partner's button source code or organization name |
| 12 | PAYMENT_INSTRUMENT_TYPE | Varchar | A high-level classification of the financial instrument used to fund the payment, such as PAYPAL, CREDIT_CARD, DEBIT_CARD, Direct Debit, VENMO, Apple Pay, Google Pay, Network Token, or a supported APM |
| 13 | PAYMENT_INSTRUMENT_SUBTYPE | Varchar | A detailed classification of the financial instrument used to fund the payment: AMEX, CARTE_BANCAIRE, CETELEM, COFIDIS, COFINOGA, CHINA_UNION_PAY, DELTA, DINERS, DISCOVER, ELECTRON, ELO, HIPER, HIPERCARD, JCB, MAESTRO, MASTER_CARD, RUPAY, SOLO, STAR, SWITCH, or VISA For wallets and network tokens, this field shows the card type and brand that funded the transaction, for example CREDIT_CARD-VISA or DEBIT_CARD-MASTER_CARD. |
| 14 | TRANSACTION_AMOUNT | Money | The amount of the transaction |
| 15 | TRANSACTION_CURRENCY | 3-character currency code | The 3-character currency code for TRANSACTION_AMOUNT (for example, USD). |
| 16 | TRANSACTION_DEBIT_CREDIT_CODE | Varchar | Indicates whether money was credited or debited: CR (credit) or DR (debit) |
| 17 | PRICING_MODEL | Varchar | Indicates whether there is a revenue share on the transaction or if fees are gross billed through invoices: GROSS_BILLING or REVSHARE |
| 18 | PP_FEES_BASE_PERCENTAGE | Varchar | The percentage of the transaction amount that was charged as PayPal base fees |
| 19 | PP_FEES_BASE_FIXED_AMOUNT | Money | The fixed-fee component of the PayPal base fees |
| 20 | PP_FEES_XB_PERCENTAGE | Varchar | The percentage of the transaction amount that was charged as PayPal cross-border fees |
| 21 | PP_FEES_XB_FIXED_AMOUNT | Money | The fixed-fee component of the PayPal cross-border fees |
| 22 | PP_FEES | Money | The total PayPal fees for the transaction |
| 23 | PROCESSING_COST_BASE_PERCENTAGE | Varchar | The percentage of the transaction amount that was charged as the PayPal base markup |
| 24 | PROCESSING_COST_BASE_FIXED_AMOUNT | Money | The fixed-fee component of the PayPal base markup |
| 25 | PROCESSING_COST_XB_PERCENTAGE | Varchar | The percentage of the transaction amount that was charged as the PayPal cross-border markup |
| 26 | PROCESSING_COST_XB_FIXED_AMOUNT | Money | The fixed-fee component of the PayPal cross-border markup |
| 27 | PROCESSING_COST | Money | The total PayPal markup for the transaction |
| 28 | INTERCHANGE_PROGRAM | Varchar | The interchange program name that applies to the transaction |
| 29 | INTERCHANGE_COST_PERCENTAGE | Varchar | The percentage of the transaction amount that was charged as interchange cost |
| 30 | INTERCHANGE_COST_FIXED_AMOUNT | Money | The fixed-fee component of interchange cost |
| 31 | INTERCHANGE_COST | Money | The total interchange cost for the transaction |
| 32 | PP_FX_MARKUP | Number | The PayPal markup rate for FX Optimizer-enabled currency conversion transactions |
| 33 | PP_FX_MARKUP_AMOUNT | Money | The PayPal markup amount for FX Optimizer-enabled currency conversion transactions |
| 34 | PARTNER_FX_MARKUP | Number | The partner's markup rate for FX Optimizer-enabled currency conversion transactions |
| 35 | PARTNER_FX_MARKUP_AMOUNT | Money | The partner's markup amount for FX Optimizer-enabled currency conversion transactions |
| 36 | INVOICE_FX_AMT_IN_TXN_CURRENCY | Money | The calculated invoice amount in the transaction currency for an FX Optimizer-enabled currency conversion transaction. If the invoice account's primary currency differs, see INVOICE_FX_AMT_IN_INVOICE_CURRENCY for the amount converted to the invoice account's currency. |
| 37 | INVOICE_FX_AMT_IN_INVOICE_CURRENCY | Money | The converted invoice amount in the invoice account's primary currency |
| 38 | INVOICE_CURRENCY | 3-character currency code | The 3-character currency code for the invoice account currency (for example, USD) |
| 39 | PAYOUT_FX_AMT_IN_TXN_CURRENCY | Money | The calculated revenue share payout amount in the transaction currency for an FX Optimizer-enabled currency conversion transaction. If the payout account's primary currency differs, see PAYOUT_FX_AMT_IN_PAYOUT_CURRENCY for the amount converted to the payout account's currency. |
| 40 | PAYOUT_FX_AMT_IN_PAYOUT_CURRENCY | Money | The converted revenue share payout amount in the payout account's primary currency |
| 41 | PAYOUT_CURRENCY | 3-character currency code | The 3-character currency code for the payout account currency (for example, USD) |
| 42 | ASSESSMENT_COST | Money | The total scheme or assessment fees charged by the card network for the transaction |
| 43 | NETWORK_NAME | Varchar | The PIN-less debit network name: VISA, AMEX, DISCOVER, MASTER_CARD, or CARTE_BANCAIRE |
| 44 | FASTLANE_CHECKOUT_TRANSACTION | Y/N | Indicates whether the transaction used Fastlane accelerated checkout |
The section footer marks the end of a data section.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (section footer, SF) |
The file footer indicates the end of a report file.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (file footer, FF) |