# Payouts Reconciliation report (/platforms/reports/partner-merchant-reconciliation/payouts-reconciliation) 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](/reports/PYT_Report_ppdevdocs.csv) in CSV format. This sample may vary from your actual report, depending on your settings. ## Before you begin [#before-you-begin] Before using this report, review these important requirements and considerations: * Ensure you are an approved partner to use this report. * This report is generated and placed on the SFTP server by 9:00 AM daily in the leading time zone of the reporting window. * This report includes alternative payment methods (APMs). See the list of [supported APMs](/platforms/checkout/apm/). * Amounts in this report are in cents (multiplied by 100). For example, a $10 entry is `1000` in the report. > **Warning:** 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. ## Report file name [#report-file-name] The file name of the Payouts Reconciliation report for a single account follows this naming convention: ``` PYT....... ``` | 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). | ## Report format [#report-format] 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](#file-header-data) | | `SH` | [Section header](#section-header-data) | | `CH` | [Column header](#column-header-data) | | `SB` | [Section body](#section-body-data) | | `SF` | [Section footer](#section-footer-data) | | `FF` | [File footer](#file-footer-data) | ### File header data [#file-header-data] 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 | ### Section header data [#section-header-data] 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`) | ### Section body data [#section-body-data] 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](/platforms/checkout/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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/codes/currency) 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](/api/nvp-soap/errors/) 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](/api/codes/currency) 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. | ### Section footer data [#section-footer-data] 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`) | ### File footer data [#file-footer-data] The file footer indicates the end of the report file. | Position | Column name | Data type | Description | | -------- | ------------- | --------- | ---------------------- | | 1 | `Column Type` | `Literal` | The column type (`FF`) |