Payouts reconciliation report

Important: PayPal for Marketplaces is available to select partners for approved use cases. For more information, reach out to your PayPal account manager or contact us.

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

PayPal generates this report and puts it on PayPal's website and the secure FTP server by 12:00 PM daily in the leading time zone of the reporting window.

Report file name

The file name of the Payouts Reconcilliation 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).

Retention

The report is available via PayPal's website and the secure FTP server for 45 days after its delivery to the server.

Versioning

In the future, this report may be available in multiple versions. To take advantage of new versions, you can receive two versions of the same report concurrently (or non-consecutive versions of the same report) for testing and integration purposes. Contact your account manager for information on new or deprecated versions of the report, to enable access to different versions, and to request any changes in report distribution.

File record limit

A report file has a 150K file size limit. If a day’s transactions exceed this file size limit, PayPal splits the report across multiple files.

Report structure

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

File header (FH) 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 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 (SH) data

Position Column name Data type Description
1 Column Type Literal “SH”

Section body (SB) data

Body data is in one row with data separated by the column delimiter.

Before any rows of body data in the report, a column header row lists the name of each of the fields in each body data row, in the form: CHcolumn-name (except for the column type field). The following table lists the columns.

Position Column name Data type Description
1 Column Type Literal The column type (CH).
2 Transaction Type Varchar; Max Length: 24 characters; Blanks: No The type of transaction, one of: Payment, Refund, Dispute Initiated, Dispute, Chargeback Initiated, Chargeback, Disbursement, or 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 Varchar; Max length: 17 characters Original PayPal transaction ID to which this event is related.
6 PayPal Transaction ID Varchar Max length: 17 characters PayPal transaction ID of this transaction.
7 Custom Field Varchar; Max length: 256 characters; Blanks: Yes Custom field passed by the merchant.
8 Transaction Date Date-time The date on which the transaction was completed.
9 Buyer Transaction Amount Money; Max Length: 26 characters; Blanks: No Amount of funds transferred to or from a customer. Funds that are transferred to the customer have a dash (-) prefix .
10 Transaction Currency Three Character Currency Code; Max Length: 3 characters; Blanks: No The currency of the transaction.
11 Partner Fee Money; Max Length: 26 characters; Blanks: No Partner fees associated with the transaction. Funds moving out of the partner fee account have a dash (-) prefix .
12 PP Fees Money; Max Length: 26 characters; Blanks: No PayPal fees associated with the transaction. Funds moving out of the PayPal fee account have a dash (-) prefix .
13 CB Fee Money; Max Length: 26 characters; Blanks: No Chargeback fee associated with the transaction. Funds moving out of the loss account have a dash (-) prefix .
14 Held Amount Money; Max Length: 26 characters; Blanks: No Funds moving into or out of the general ledger account. Funds moving out of the account have a dash (-) prefix .
15 Disbursed Amount Money; Max Length: 26 characters; Blanks: No The funds that are disbursed into the settlement general ledger account.
16 Overage Amount Money; Max Length: 26 characters; Blanks: No Funds moving into or out of the loss account. Funds moving out of the account have a dash (-) prefix .
17 Bank Transaction Amount Money; Max Length: 26 characters; Blanks: No Funds transferred to the merchant’s bank account.

Section footer data is in one row with data separated by the column delimiter.

Position Column name Data type Description
1 Column Type Literal The column type (SF).

File footer data is in one row with data separated by the column delimiter.

Position Column name Data type Description
1 Column Type Literal The column type (FF).