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:

PPR-yyyymmdd.sequenceNumber.version.format
Field Information
PPR 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 01 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.

The report groups transactions by the Merchant Account Number field.

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
  • Refund
  • Dispute Initiated
  • Dispute
  • Chargeback Initiated
  • Chargeback
  • Disbursement
  • Partner Bank Transfer
3 Merchant Account Number Varchar Merchant's PayPal encrypted account number.
4 Other Recipient Varchar Encrypted account number for secondary account.
5 PayPal Reference ID String Original PayPal transaction ID to which this event is related.
6 PayPal Transaction ID Varchar PayPal transaction ID of the transaction.
7 Custom Field Varchar A field for custom data.
8 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.
9 Buyer Transaction Amount Money Amount of funds transferred to or from a customer. Funds that are transfered to the customer have a dash (-) prefix.
10 Transaction Currency Three character currency code The currency of the transaction.
11 Partner Fee Money Partner fees associated with the transaction. Funds moving out of the partner fee account have a dash (-) prefix.
12 PP Fees Money PayPal fees associated with the transaction. Funds moving out of the PayPal fee account have a dash (-) prefix.
13 CB Fee Money Chargeback fee associated with the transaction. Funds moving out of the loss account have a dash (-) prefix.
14 Held Amount Money Funds moving into or out of the general ledger account. Funds moving out of the account have a dash (-) prefix .
15 Disbursed Amount Money The funds that are disbursed into the settlement general ledge account.
16 Overage Amount Money Funds moving into or out of the loss account. Funds moving out of the loss account have a dash (-) prefix.
17 Bank Transaction Amount Money Funds transferred to the seller's bank account.
Section Footer Data
1 Column Type Literal The column type (SF).
File Footer Data
1 Column Type Literal The column type (FF).
Feedback

Have feedback?

Let us know.