On this page
No Headings
Last updated: July 10, 2026
This report provides a detailed view of the activity on your platform and helps you with the reconciliation of end-to-end money flow and transactions.
To see what's in this report, download a sample in CSV format. This sample may vary from your actual report, depending on your settings.
Before using this report, review these important requirements and considerations:
1000 in the report.The file name of the Payouts Reconciliation report for a single account follows this naming convention:
PYT.<yyyymmdd>.<ReportIdentifier>.<ReportingWindow>.<SequenceNumber>.<MajorVersion>.<MinorVersion>.<Format>| Field | Description |
|---|---|
PYT | An abbreviation for Payouts Reconciliation report |
yyyymmdd | The date for the data in the report. It represents the latest, or ending date, of the data. |
ReportIdentifier | A unique value that identifies the report, such as the BN 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 file name, 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. The minor version 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 metadata about the report file, including generation timestamp, reporting period, and partner account 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. |
| 6 | Partner Account Number | Varchar | The partner's encrypted PayPal account number |
| 7 | ReportIdentifier | Varchar | A unique value that identifies the report, such as the BN code or organization name |
The section header identifies the start of a new data section in the report.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (column header, CH) |
The section body contains comprehensive transaction details for payouts reconciliation, including transaction types, amounts, fees, and settlement information.
| 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, ADD_MONEY, AUTH, BONUS, CHARGEBACK, CORRECTION, CURRENCY_CONVERSION, DEPOSIT, DISBURSEMENT, DISPUTE, FEE, FAILED_DISBURSEMENT, HOLD, HOLD_RELEASE, INCENTIVES, OTHERS, PAYABLE, PAYMENT, PAYOUT_REFUND, PAYOUT_REVERSAL, RECEIVABLE, REFUND, RECOUP, REVERSAL, TRANSFER, WITHDRAWAL, or WITHDRAW_MONEY |
| 3 | TRANSACTION_SUBTYPE | Varchar | The subtype of the transaction: ACCOUNT_RESERVE, ACCOUNT_RESERVE_RELEASE, BANK, BANK_DEPOSIT, BANK_REVERSAL, BONUS, CREATED, DEPOSIT, DISBURSED, DISPUTE_HOLD, DISPUTE_HOLD_RELEASE, DISPUTE_REFUND, FAILED, FEE, FOREIGN_WITHDRAWAL, FROM, LOSS_ACCOUNT, MASSPAY, PARTNER_FEE, PAYMENT_FEE, PENDING, REFUND, REVERSED, REVERSAL, TO, TRANSACTIONAL_RESERVE, TRANSACTIONAL_RESERVE_RELEASE, VOID, or WITHDRAWAL When the transaction type is CORRECTION, the TRANSACTION_SUBTYPE is either DEPOSIT or WITHDRAWAL, depending on the direction of the funds. |
| 4 | SELLER_ACCOUNT_ID | Varchar | The seller's encrypted PayPal account number |
| 5 | PAYPAL_REFERENCE_ID | String | The original PayPal transaction ID that this event references |
| 6 | PAYPAL_TRANSACTION_ID | Varchar | The PayPal transaction ID |
| 7 | INVOICE_ID | Varchar | The invoice ID of the transaction |
| 8 | CUSTOM_FIELD | Varchar | A field for custom data |
| 9 | 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. |
| 10 | INTEGRATION_IDENTIFIER | Varchar | The partner's button source code |
| 11 | 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, Pay Upon Invoice, or a supported APM |
| 12 | 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, DISCOVER, ELECTRON, ELO, HIPER, HIPERCARD, JCB, MAESTRO, MASTER_CARD, 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. |
| 13 | CHECKOUT_CHANNEL | Varchar | Distinguishes online from offline payments: POS (point of sale) or ONLINE_PAYMENT |
| 14 | DELAYED_DISBURSEMENT | 1-character flag | The disbursement type: Y (delayed) or N (instant) |
| 15 | TRANSACTION_AMOUNT | Money | The amount of the transaction |
| 16 | TRANSACTION_CURRENCY | 3-character currency code | The 3-character currency code for TRANSACTION_AMOUNT (for example, USD) |
| 17 | TRANSACTION_DEBIT_CREDIT_CODE | Varchar | Indicates whether money was credited or debited: CR (credit) or DR (debit) |
| 18 | PENDING_DISBURSEMENT_AMOUNT | Money | The amount that is not yet disbursed |
| 19 | PENDING_DISBURSEMENT_AMOUNT_CURRENCY | 3-character currency code | The 3-character currency code for PENDING_DISBURSEMENT_AMOUNT (for example, USD) |
| 20 | SELLER_AMOUNT | Money | The amount of funds that were transferred to or from a customer. Funds moving out of the seller account have a dash (-) prefix. |
| 21 | SELLER_AMOUNT_CURRENCY | 3-character currency code | The 3-character currency code for SELLER_AMOUNT (for example, USD) |
| 22 | PARTNER_FEE | Money | Partner fees associated with the transaction. Funds moving out of the partner fee account have a dash (-) prefix. |
| 23 | PARTNER_FEE_CURRENCY | 3-character currency code | The 3-character currency code for PARTNER_FEE (for example, USD) |
| 24 | PARTNER_FEE_ACCOUNT_ID | Varchar | The encrypted PayPal account number for partner fees |
| 25 | PP_FEES | Money | PayPal fees that are associated with the transaction. Funds that are moving out of the PayPal fee account have a dash (-) prefix. |
| 26 | PP_FEES_CURRENCY | 3-character currency code | The 3-character currency code for PP_FEES (for example, USD) |
| 27 | PP_FEES_PERCENTAGE | Varchar | The percentage of the transaction amount that was charged as a fee. Total PayPal fees include PP_FEES_PERCENTAGE and PP_FEES_FIXED_AMOUNT. |
| 28 | PP_FEES_FIXED_AMOUNT | Money | The fixed PayPal fee amount component of PP_FEES |
| 29 | PP_FEES_XB_PERCENTAGE | Varchar | The percentage of the transaction amount that was charged as cross-border fees. Total cross-border fees include PP_FEES_XB_PERCENTAGE and PP_FEES_XB_FIXED_AMOUNT. |
| 30 | PP_FEES_XB_FIXED_AMOUNT | Money | The fixed cross-border fee amount component of PP_FEES_XB_TOTAL_AMOUNT |
| 31 | PP_FEES_XB_TOTAL_AMOUNT | Money | The total cross-border fee amount associated with the transaction |
| 32 | CHARGEBACK_FEE | Money | The chargeback fee that is associated with the transaction. A dash (-) prefix indicates that the chargeback fee was reversed. |
| 33 | CHARGEBACK_FEE_CURRENCY | 3-character currency code | The 3-character currency code for CHARGEBACK_FEE (for example, USD) |
| 34 | HOLD_AMOUNT | Money | The amount that is put on hold or released from hold. A dash (-) prefix indicates that the funds that were put on hold are being released. |
| 35 | HOLD_AMOUNT_CURRENCY | 3-character currency code | The 3-character currency code for HOLD_AMOUNT (for example, USD) |
| 36 | RECOUP_AMOUNT | Money | The amount that was recouped from the recoup account. Funds moving out of the recoup account have a dash (-) prefix. |
| 37 | RECOUP_AMOUNT_CURRENCY | 3-character currency code | The 3-character currency code for RECOUP_AMOUNT (for example, USD) |
| 38 | RECOUP_ACCOUNT_ID | Varchar | The encrypted PayPal account number for the recoup account |
| 39 | PAYABLE_AMOUNT | Money | The amount moving in and out of the partner's payable general ledger account. Funds that are moving out of the payable account have a dash (-) prefix. |
| 40 | PAYABLE_AMOUNT_CURRENCY | 3-character currency code | The 3-character currency code for PAYABLE_AMOUNT (for example, USD) |
| 41 | PAYABLE_ACCOUNT_ID | Varchar | The encrypted PayPal account number for the partner's payable general ledger |
| 42 | EXTERNAL_TRANSFER_AMOUNT | Money | The amount credited to or debited from an external entity, such as a bank. Funds debited from an external entity have a dash (-) prefix. |
| 43 | EXTERNAL_TRANSFER_AMOUNT_CURRENCY | 3-character currency code | The 3-character currency code for EXTERNAL_TRANSFER_AMOUNT (for example, USD) |
| 44 | COUNTERPARTY_ACCOUNT_ID | Varchar | The encrypted PayPal account number of the counterparty that is involved in the transaction |
| 45 | SETTLEMENT_REFERENCE_ID | Varchar | The bank reference ID for the bank transfer transaction |
| 46 | STORE_ID | Varchar | The ID of the store where the POS (point of sale) transaction occurred |
| 47 | TRANSACTION_STATUS | Varchar | The current status of the PAYMENT transaction: PENDING, SUCCESS, or DECLINED |
| 48 | DECLINE_CODE | Varchar | Indicates the reason for decline, when available. Processor decline codes apply to credit card transactions. Bank decline codes apply to bank transactions. |
| 49 | PAYOUT_REFERENCE_ID | Varchar | The transaction ID of the counterparty for a payout transaction |
| 50 | BASE_FX_RATE | Number | The base rate for FX Optimizer-enabled currency conversion at the time of the transaction |
| 51 | TOTAL_FX_MARKUP | Number | The total markup that is charged by the partner and PayPal as part of FX Optimizer-enabled currency conversion |
| 52 | NET_FX_RATE | Number | The net rate for FX Optimizer-enabled currency conversion at the time of the transaction, including the BASE_FX_RATE and TOTAL_FX_MARKUP |
| 53 | REQUESTED_FX_ID | Varchar | The rate requested by the user at the time of the transaction for FX Optimizer-enabled currency conversion |
| 54 | APPLIED_FX_ID | Varchar | The rate applied at the time of currency conversion. This rate can be the same as REQUESTED_FX_ID if REQUESTED_FX_ID has not expired at the time of the transaction. If REQUESTED_FX_ID has expired, PayPal applies a new rate at the time of the transaction. |
| 55 | PAYOUT_ITEM_ID | Varchar | The ID of the payout item |
| 56 | MEMO | Varchar | Custom information sent by the user when calling the API to place a transaction |
| 57 | PAYOUT_AMOUNT | Money | The total payout amount expected to be disbursed to the user's payout instrument |
| 58 | PAYOUT_SETTLEMENT_CURRENCY | 3-character currency code | The 3-character currency code of the payout amount that is expected to be disbursed to the user's payout instrument |
| 59 | PAYOUT_ID | Varchar | A unique identifier that links all transactions that contribute to a particular payout, including all events in the payout lifecycle |
| 60 | SETTLEMENT_SOFT_DESCRIPTOR | Varchar | A unique identifier that is sent as part of the settlement to a bank transaction. You can use this with SETTLEMENT_REFERENCE_ID to trace the deposit in the bank statement. |
| 61 | SETTLEMENT_INSTRUMENT_TYPE | Varchar | The type of external entity where the external transfer amount was credited to or debited from, such as BANK |
| 62 | SETTLEMENT_INSTRUMENT_SUB_TYPE | Varchar | The sub-type of the external entity where the external transfer amount was credited to or debited from |
| 63 | WITHDRAWAL_TYPE | Varchar | The withdrawal type, which you can use to differentiate on-demand from automated withdrawals. Merchant Initiated indicates on-demand payouts or withdrawals. |
The section footer marks the end of a data section in the report.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (SF) |
The file footer indicates the end of the report file.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (FF) |