Payouts Reconciliation Report

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

On this page

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.

Section 1: 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
Field Information
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 This is the unique value to identify the report, such as the BN code or organization name.
ReportingWindow The window of time when the report was generated.
SequenceNumber The sequence number of the report file. It is two characters, right-justified, and zero-filled. 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.
MajorVersion The major version of the report.
MinorVersion The minor version of the report.
format The report format is CSV (comma-separated values).

Section 2: 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.

Code Description
FH File header
SH Section header
CH Column header
SB Section body
SF Section footer
FF File 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
  • CHARGEBACKThis type applies to chargeback fee and chargeback fee reversal transactions.
  • CORRECTION
  • CURRENCY_CONVERSION
  • DEPOSIT
  • DISBURSEMENT
  • DISPUTE
  • FEES This type applies to partner fee, payment fee, and fee reversal transactions.
  • HOLD
  • HOLD_RELEASE
  • INCENTIVES
  • OTHERS
  • RECOUP: This type applies to recoups from bank or loss accounts.
  • REFUND
  • REVERSAL
  • WITHDRAWAL
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.
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:
12 PAYMENT_INSTRUMENT_SUBTYPE Varchar One of the following detailed classifications of the financial instrument used to fund a payment:
  • AMEX: AMEX card transaction
  • CB_NATIONALE: CB_NATIONALE 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
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 CHARGEBACK_FEE Money The chargeback fee associated with the transaction. A dash (-) prefix indicates the chargeback fee is reversed.
30 CHARGEBACK_FEE_CURRENCY Three-character currency code The currency of the CHARGEBACK_FEE.
31 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.
32 HOLD_AMOUNT_CURRENCY Three-character currency code The currency of the HOLD_AMOUNT.
33 RECOUP_AMOUNT Money The amount recouped from the recoup account. Funds moving out of the recoup account have a dash (-) prefix.
34 RECOUP_AMOUNT_CURRENCY Three-character currency code The currency of the RECOUP_AMOUNT.
35 RECOUP_ACCOUNT_ID Varchar The encrypted PayPal account number of the recoup account.
36 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.
37 EXTERNAL_TRANSFER_AMOUNT_CURRENCY Three-character currency code The currency of the EXTERNAL_TRANSFER_AMOUNT.
38 COUNTERPARTY_ACCOUNT_ID Varchar The encrypted PayPal account number of the counter party involved in a transaction.
39 SETTLEMENT_REFERENCE_ID Varchar The bank reference ID for the bank transfer transaction.
40 TRANSACTION_STATUS Varchar The current status of the 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).