Payouts Reconciliation Report

Important: PayPal for Marketplaces is a limited-release solution at this time. It is available to select partners for approved use cases. For more information, reach out to your PayPal account manager.

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

This report is generated and placed on SFTP by 12:00 PM daily in the leading time zone of the reporting window.

Report file name

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

PYT-yyyymmdd.sequenceNumber.version.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.
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.
version The version of the report. It contains three characters, and is right-justified.
format The report format is CSV (comma-separated values) or TAB (tab-delimited values).

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, along with 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
Position Column name Data type Description
File Header Data
1 Column Type Literal The column type (FH).
2 Report Generation Date Date-time The date and time at which 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. For example, +0800.
3 Reporting Window Varchar, single character, one of: A, H, R, X. The window of time in which 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 for which to include transactions in the report, in the following format: YYYY/MM/DDHH:MM:SS offset, where offset is the five-character signed offset from GMT. For example, +0800.
5 Report Period End Date Date-time The final date and time for which to include transactions in the report, in the following format: YYYY/MM/DDHH:MM:SS offset, where offset is the five-character signed offset from GMT. For example, +0800.
6 BN Code Varchar Unique ID for the platform.
Section Header Data
1 Column Type Literal SH
Section Body Data
1 Column Type Literal The column type (CH).
2 Transaction Type Varchar The type of transaction. One of:
  • Payment. Forward money movement between buyer and seller for a given order.
  • Refund. Reverse money movement between seller and buyer. Refunds can be initiated by either the partner or PayPal.
  • Dispute. A dispute case has been created or closed.
  • Chargeback. A Chargeback case has been created or closed.
  • Disbursement. Incoming payment funds have been disbursed to the merchant.
3 Account Number Varchar Merchant's PayPal encrypted account number.
4 PayPal Reference ID String Original PayPal transaction ID to which this event is related.
5 PayPal Transaction ID Varchar PayPal transaction ID of the transaction.
6 Custom Field Varchar A field for custom data.
7 Transaction Date Date-time Date and time at which the case was filed in the following format is the five-character signed offset from GMT. For example, +0800.
8 Transaction Currency Three character currency code The currency of the transaction.
9 Buyer Amount Money Amount of funds transferred to or from a customer. Funds that are transferred to the customer have a dash (-) prefix.
10 Partner Fee Money Partner fees associated with the transaction. Funds moving out of the partner fee account have a dash (-) prefix.
11 PP Fees Money PayPal fees associated with the transaction. Funds moving out of the PayPal fee account have a dash (-) prefix.
12 CB Fee Money Chargeback fee associated with the transaction. Funds moving out of the loss account have a dash (-) prefix.
13 Transaction Status String Shows the current status of the transaction which is either S for success or P for pending.
Section Footer Data
1 Column Type Literal The column type (SF).
File Footer Data
1 Column Type Literal The column type (FF).
Feedback