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

This report is generated and placed on SFTP 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 Marketplaces Case Reconciliation Report for a single account follows this naming convention:

MCR-yyyymmdd.sequenceNumber.version.format
Field Information
MCR An abbreviation for Marketplaces 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).

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.
Section Header Data
1 Column Type Literal BNCode
Column Header Data
1 Column Type Literal The column type (CH).
2 Case ID Literal The case ID.
3 Case Type Literal The type of case.
4 Case Reason Literal The reason for the case.
5 Case Filing Date Literal The date on which the case was filed.
6 Case Status Literal The status of the case.
7 Disputed Amount Literal The disputed amount.
8 Disputed Currency Literal The currency of the dispute transaction.
9 Transaction ID Literal The transaction ID.
10 Invoice Number Literal The invoice number for the transaction.
11 Custom Field Literal A field for custom data.
12 Transaction Date Literal The date of the transaction.
13 Final Case Outcome Literal The final outcome of the dispute.
Section Body Data
1 Column Type Literal The column type (CH).
2 Case ID Varchar The PayPal-generated ID for the case in either of these formats: PP-000-111-222-333 or PP-D-99999.
3 Case Type String The case type. Can be either Chargeback or Dispute.
4 Case Reason String The reason for the case. Can be one of the following:
  • Unauthorized
  • Non-receipt
  • Not as described
  • Defective or Incorrect Merchandise
  • Unwanted Merchandise
  • Billing Issues
  • Duplicate
  • Extended Warranty
  • Merchandise
  • Special
  • Suspect Fraud
5 Case Filing 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.
6 Case Status String The status of the case. Can be either Resolved or Open.
7 Disputed Amount Money The disputed amount.
8 Disputed Currency Three character currency code The currency of the dispute transaction.
9 Transaction ID Varchar The transaction ID of the original transaction.
10 Invoice Number Varchar The invoice number for the transaction.
11 Custom Field Varchar A field for custom data.
12 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.
13 Final Case Outcome Literal The final outcome of the dispute. The value is one of the following:
  • RESOLVED_BUYER_FAVOUR
  • RESOLVED_SELLER_FAVOUR
  • RESOLVED_WITH_PAYOUT
  • CANCELED_BY_BUYER
Left blank if the dispute or chargeback is not resolved.
Section Footer Data
1 Column Type Literal The column type (SF).
File Footer Data
1 Column Type Literal The column type (FF).
Feedback