Marketplaces case reconciliation report

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. This report is available if you onboard your sellers before payment.

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.BNCode.ReportingWindow.SequenceNumber.MajorVersion.MinorVersion.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.
`BNCode`	This code is the unique ID for the platform.
`ReportingWindow`	The window of time in which the report was generated.
`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.
`MajorVersion`	The major version of the report.
`MinorVersion`	The minor version of the report. It contains three characters and is right-justified.
`Format`	The report format is `CSV` (comma-separated 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: `Billing Issues` `Defective or Incorrect Merchandise` `Duplicate` `Extended Warranty` `Inquiry by PayPal` `Merchandise` `Non-receipt` `Not as described` `Special` `Suspect Fraud` `Unauthorized` `Unauthorized payment` `Unwanted Merchandise`
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`).