Marketplace case 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 supports case management processes by providing details about the cases that opened or closed on the platform within the reporting time frame. Cases include reversals (refunds initiated by PayPal), chargebacks, disputes, and dispute claims.

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.

A single file contains all cases.

Report file name

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

MCR-yyyymmdd.sequenceNumber.version.format
Field Information
MCR An abbreviation for Marketplace Case 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 150,000 record limit. If a day’s transactions exceed this record 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.

Row type Description
FH File header
SH Section header
CH Column header
SB Section body
SF Section footer
FF File footer

If a report is split into two or more files, because it exceeds 150,000 records, each file contains the file header and file footer rows.

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 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.

Section header data

Position Column name Data type Data description
1 Column Type Literal BNCode

Column header data

Position Column name Data type Data description
1 Column Type Literal The column type (CH).
2 Case ID Header Literal The case ID.
3 Case Type Header Literal The type of case.
4 Case Reason Header Literal The reason for the case.
5 Case Filing Date Header Literal The date on which the case was filed.
6 Case Status Header Literal The status of the case.
7 Disputed Amount Header Literal The disputed amount.
8 Disputed Currency Header Literal The currency of the dispute transaction.
9 Transaction ID Header Literal The transaction ID.
10 Custom Field Header Literal A field for custom data.
11 Transaction Date Header Literal The date of the transaction.
12 Final Case Outcome Header Literal The final outcome of the dispute.

Section body data

Position Column name Data type Data description
1 Column Type Literal The column type (CH).
2 Case ID Varchar; Max Length: 18 characters; Blanks: No The PayPal-generated ID for this case. It can be used to refer to a case when discussing it with PayPal service representatives. It could be in either of these formats: PP-000-111-222-333 or PP-D-99999.
3 Case Type String; Blanks: No Can be either Chargeback or Dispute.
4 Case Reason String; Blanks: No One of the following: Unauthorized, Non-receipt, Not as described, Defective or Incorrect Merchandise, Unwanted Merchandise, Billing Issues, Duplicate, Extended Warranty, Merchandise, Special, or Suspect Fraud.
5 Case Filing Date Date-time; Max Length: 25 characters; Blanks: No Date and time at which the case was filed, in the following format: YYYY/MM/DDHH:MM:SS offset where offset is the five-character signed offset from GMT. For example, +0800.
6 Case Status String; Blanks: No Can be either Resolved or Open.
7 Disputed Amount Money; Max Length: 26 characters; Blanks: No The amount of the dispute or chargeback.
8 Disputed Currency Three Character Currency Code; Max Length: 3 characters; Blanks: No Currency of the dispute or chargeback.
9 Transaction ID Varchar; Max Length: 24 characters; Blanks: No Transaction ID of the original transaction in which this dispute or chargeback was taken on.
10 Custom Field Varchar; Max Length: 256 characters; Blanks: Yes The custom field sent by the partner in the original transaction. Blank if the original transaction did not include the custom field.
11 Transaction Date Date-time; Max Length: 25 characters; Blanks: No Date and time of the original transaction, in the following format: YYYY/MM/DDHH:MM:SS offset where offset is the five-character signed offset from GMT. For example, +0800.
12 Final Case Outcome String; Blanks: Yes The outcome of the case. The value is one of the following: RESOLVED_BUYER_FAVOUR, RESOLVED_SELLER_FAVOUR, RESOLVED_WITH_PAYOUT, CANCELED_BY_BUYER. It is left blank if the dispute or chargeback is not resolved.
Position Column name Data type Data description
1 Column Type Literal The column type (SF).
Position Column name Data type Data description
1 Column Type Literal The column type (FF).