Payouts Reconciliation Report

DocsCurrentLast updated: October 18th 2021, @ 3:21:59 pm


This report provides a detailed view of the activity on your platform and helps with reconciliation of end-to-end money flow and transactions.

Download a sample report

To review what's available in this report, download a sample in CSV format. This sample may vary from your actual report depending on your settings.

Know before you begin

  • You must be an approved partner to use this report.
  • This report is generated and placed on SFTP 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.
  • The actual amounts in this report are multiplied by 100 to represent the amounts as cents. For instance, a $10 entry appears as 1000 on the report.
  • Read the report data by column header name instead of column index to maintain backward compatibility.

Report file name

The file name of the Payouts Reconciliation Report for a single account follows this naming convention:

PYT.yyyymmdd.ReportIdentifier.ReportingWindow.SequenceNumber.MajorVersion.MinorVersion.Format
FieldInformation
PYTAn abbreviation for Payouts Reconciliation report.
yyyymmddThe date for the data in the report. It represents the latest, or ending date, of the data.
ReportIdentifierThis is the unique value to identify the report, such as the BN code or organization name.
ReportingWindowThe window of time when the report was generated.
SequenceNumberThe 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 one file.
MajorVersionThe major version of the report.
MinorVersionThe minor version of the report.
formatThe report format is CSV (comma-separated values).

Report format

Each row of the report consists of a two-letter row type, followed by the details specific to that row type. The following table lists the valid row types and the sections that describe the data for that row type.

CodeDescription
FHFile header
SHSection header
CHColumn header
SBSection body
SFSection footer
FFFile footer

File header data

Position Column name Data type Description
1 Column Type Literal The column type (FH).
2 Report Generation Date Date-time The date and time when the report file was generated, in the following format: YYYY/MM/DDHH:MM:SS offset, where offset is the five-character signed offset from GMT, such as +0800.
3 Reporting Window One of the following varchar single characters: A, H, R, X. The window of time when the report was generated, as follows:
  • 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 the following format: YYYY/MM/DDHH:MM:SS offset, where offset is the five-character signed offset from GMT, such as +0800.
5 Report Period End Date Date-time The final date and time of transactions to include in the report, in the following format: YYYY/MM/DDHH:MM:SS offset, where offset is the five-character signed offset from GMT, such as +0800.
6 Partner Account Number Varchar The partner's PayPal encrypted account number.
7 ReportIdentifier Varchar This unique value identifies the report, such as the BN code or organization name.

Section header data

Position Column name Data type Description
1 Column Type Literal SH

Section body data

Position Column name Data type Description
1 Column Type Literal The column type (CH).
2 TRANSACTION_TYPE Varchar One of the following types of transaction:
  • PAYMENT. This type applies to money movement between a buyer and a seller for an order.
  • AUTH This type applies to auth and auth void transactions.
  • BONUS. Bonus type transactions.
  • CHARGEBACKThis type applies to chargeback fee and chargeback fee reversal transactions.
  • CORRECTION
  • CURRENCY_CONVERSION
  • DEPOSIT
  • DISBURSEMENT
  • DISPUTE
  • HOLD
  • HOLD_RELEASE
  • INCENTIVES
  • OTHERS
  • RECOUP: This type applies to recoups from bank or loss accounts.
  • REFUND
  • REVERSAL
  • WITHDRAWAL
  • PAYABLE: Funds payable are funds provided by PayPal that need to be paid back.
  • RECEIVABLE: Funds receivable are funds provided by PayPal that are being paid back.
  • TRANSFER: Transfers are funds transferred either from or to a PayPal account and another payable account
  • ACH_REVERSAL
  • PAYOUT_REFUNDRefund against a past payout transaction.
  • PAYOUT_REVERSALReversal of a Payout transaction
3 TRANSACTION_SUBTYPE Varchar One of the following subtypes of transaction:
  • VOID This subtype applies to auth void transactions.
  • FEE This subtype applies to chargeback transactions.
  • REVERSAL This subtype applies to chargeback, fees, and withdrawal transactions.
  • REFUND This subtype applies to fees refund transactions.
  • PARTNER_FEE This subtype applies to fee transactions.
  • PAYMENT_FEE This subtype applies to fee transactions.
  • MASSPAY This subtype applies to payment transactions.
  • BANK This subtype applies to withdrawal transactions.
  • LOSS_ACCOUNT This subtype applies to recoup transactions.
  • DEPOSIT When the transaction type is CORRECTION, the value DEPOSIT or WITHDRAWAL will be populated for the transaction subtype depending on whether the amount is deposited or withdrawn from the partner's financial account.
  • WITHDRAWAL When the transaction type is CORRECTION, the value DEPOSIT or WITHDRAWAL will be populated for the transaction subtype depending on whether the amount is deposited or withdrawn from the partner's financial account.
  • FROM This subtype refers to the currency funds were converted from.
  • TO This subtype refers to the currency funds were converted to.
  • FOREIGN_WITHDRAWAL. Indicates foreign withdrawal fees, applicable for transaction type FEES.
  • BONUS. This subtype applies to bonus transactions.
  • TRANSACTIONAL_RESERVE: This subtype is applicable for any funds that are placed on Reserve hold for a specific transaction.
  • TRANSACTIONAL_RESERVE_RELEASE: This subtype is applicable for any funds that are released from Reserve hold for a specific transaction.
  • ACCOUNT_RESERVE: This subtype is applicable for any funds that are reserved from the Merchant account. These reserves are not tied to any individual transactions.
  • ACCOUNT_RESERVE_RELEASE: This subtype is applicable for any funds that are released from reserve to the Merchant account. These reserves are not tied to any individual transactions.
4 SELLER_ACCOUNT_ID Varchar The seller's encrypted PayPal account number.
5 PAYPAL_REFERENCE_ID String The original PayPal transaction ID this event is related to.
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 the following format: YYYY/MM/DD HH:MM:SS offset. YYYY is the four-digit year.MM is two-digit month of the year.DD is the two-digit day of the month. HH is the hour in 24-hour notation. MM is minutes. SS is seconds. offset is the five-character signed offset from GMT, such as +0800.
10 INTEGRATION_IDENTIFIER Varchar The partner's button source code.
11 PAYMENT_INSTRUMENT_TYPE Varchar A high-level classification of the type of financial instrument that was used to fund a payment, such as the following:
  • PAYPAL
  • CREDIT_CARD
  • DEBIT_CARD
  • Direct Debit
  • VENMO
  • Apple Pay
  • Google Pay
  • Network Token
  • Pay Upon Invoice
  • Supported APMs
12 PAYMENT_INSTRUMENT_SUBTYPE Varchar One of the following detailed classifications of the financial instrument used to fund a payment:
  • AMEX: AMEX card transaction
  • CARTE_BANCAIRE: CARTE_BANCAIRE card transaction
  • CETELEM: CETELEM card transaction
  • COFIDIS: COFIDIS card transaction
  • COFINOGA: COFINOGA card transaction
  • CHINA_UNION_PAY: CHINA_UNION_PAY card transaction
  • DELTA: DELTA card transaction
  • DISCOVER: DISCOVER card transaction
  • ELECTRON: ELECTRON card transaction
  • ELO: ELO card transaction
  • HIPER: HIPER card transaction
  • HIPERCARD: HIPERCARD card transaction
  • JCB: JCB card transaction
  • MAESTRO: MAESTRO card transaction
  • MASTER_CARD: MASTER_CARD card transaction
  • SOLO: SOLO card transaction
  • STAR: STAR card transaction
  • SWITCH: SWITCH card transaction
  • VISA: VISA card transaction
For Wallets and Network token, Payment Source Subtype would show details of card type and card brand used to fund the transaction.
For example:
  • CREDIT_CARD-VISA
  • DEBIT_CARD-MASTER_CARD
13 CHECKOUT_CHANNEL Varchar Used to distinguish online and offline payments.
  • POS_PPH A payment made using a PayPal Here device.
  • ONLINE_PAYMENT A payment made on an online platform.
14 DELAYED_DISBURSEMENT One-character flag The following codes indicate the disbursement type:
  • Y Delayed disbursement
  • N Instant disbursement
15 TRANSACTION_AMOUNT Money The amount of the transaction.
16 TRANSACTION_CURRENCY Three-character currency code The currency of the transaction.
17 TRANSACTION_DEBIT_CREDIT_CODE Varchar The following codes indicate whether the money was credited or debited:
  • CR Credit
  • DR Debit
18 PENDING_DISBURSEMENT_AMOUNT Money The amount yet to be disbursed.
19 PENDING_DISBURSEMENT_AMOUNT_CURRENCY Three-character currency code The currency of the amount yet to be disbursed.
20 SELLER_AMOUNT Money The amount of funds transferred to or from a customer. Funds moving out of the seller account have a dash (-) prefix.
21 SELLER_AMOUNT_CURRENCY Three-character currency code The currency of the seller amount.
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 Three-character currency code The currency of the partner fee.
24 PARTNER_FEE_ACCOUNT_ID Varchar The partner fee encrypted account number in PayPal.
25 PP_FEES Money Any PayPal fees associated with the transaction. Funds moving out of the PayPal fee account have a dash (-) prefix.
26 PP_FEES_CURRENCY Three-character currency code The currency of the PayPal fee.
27 PP_FEES_PERCENTAGE varchar The percentage of the transaction amount charged as 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 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 Total cross-border fee amount associated with the transaction. Total cross-border fees include PP_FEES_XB_PERCENTAGE and PP_FEES_XB_FIXED_AMOUNT.
32 CHARGEBACK_FEE Money The chargeback fee associated with the transaction. A dash (-) prefix indicates the chargeback fee is reversed.
33 CHARGEBACK_FEE_CURRENCY Three-character currency code The currency of the CHARGEBACK_FEE.
34 HOLD_AMOUNT Money The amount put on hold or released from hold. A dash (-) prefix indicates the funds that were put on hold are being released.
35 HOLD_AMOUNT_CURRENCY Three-character currency code The currency of the HOLD_AMOUNT.
36 RECOUP_AMOUNT Money The amount recouped from the recoup account. Funds moving out of the recoup account have a dash (-) prefix.
37 RECOUP_AMOUNT_CURRENCY Three-character currency code The currency of the RECOUP_AMOUNT.
38 RECOUP_ACCOUNT_ID Varchar The encrypted PayPal account number of the recoup account.
39 PAYABLE_AMOUNT Money The amount moving in and out of the partner's payable general ledger account. Funds moving out of the payable account have a dash (-) prefix.
40 PAYABLE_AMOUNT_CURRENCY Three-character currency code The currency of the PAYABLE_AMOUNT.
41 PAYABLE_ACCOUNT_ID Varchar The encrypted PayPal account number of 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 Three-character currency code The currency of the EXTERNAL_TRANSFER_AMOUNT.
44 COUNTERPARTY_ACCOUNT_ID Varchar The encrypted PayPal account number of the counter party involved in a transaction.
45 SETTLEMENT_REFERENCE_ID Varchar The bank reference ID for the bank transfer transaction.
46 STORE_ID Varchar ID of the store where point of sale happened.
47 TRANSACTION_STATUS Varchar The current status of the PAYMENT transaction. This status can be one of the following:
  • PENDING
  • SUCCESS
  • DECLINED
48 DECLINE_CODE Varchar This code indicates the reason of decline, when available. For credit card transactions, the code is a processor decline code. For bank transactions, the code is a bank decline code. For more information, see processor decline codes.
49 PAYOUT_REFERENCE_ID Varchar Indicates transaction ID of the counterparty for a payout transaction.
50 BASE_FX_RATE Number This is the base rate for FX Optimizer enabled currency conversion at the time of transaction.
51 TOTAL_FX_MARKUP Number This total markup includes the markup charged by the partner and PayPal as part of FX Optimizer enabled currency conversion.
52 NET_FX_RATE Number This is the net rate for FX Optimizer enabled currency conversion at the time of transaction includes Base & total markup.
53 REQUESTED_FX_ID Varchar This is rate requested by the user at the time of the transaction for FX Optimizer enabled currency conversion.
54 APPLIED_FX_ID Varchar This is the rate that is 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 transaction. If REQUESTED_FX_ID has expired, a new rate is applied at the time of transaction.
55 PAYOUT_ITEM_ID Varchar The ID of the payout item.
56 MEMO Varchar Custom information sent by user while calling Api to place transaction.
Position Column name Data type Description
1 Column Type Literal The column type (SF).
Position Column name Data type Description
1 Column Type Literal The column type (FF).