Marketplace Case Reconciliation report

This report supports case management by providing details about cases that opened or closed on your platform during the reporting period. Cases include PayPal-initiated reversals, chargebacks, disputes, and dispute claims.

To see what's in this report, download a sample in CSV format. This sample may vary from your actual report, depending on your settings.

Report file name

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

MCR.<yyyymmdd>.<ReportIdentifier>.<ReportingWindow>.<SequenceNumber>.<MajorVersion>.<MinorVersion>.<Format>

Field, Description
Field	Description
`MCR`	The report type. In this case, it is `MCR` for Marketplaces Case Reconciliation.
`yyyymmdd`	The date for the data in the report. It represents the latest, or ending date, of the data.
`ReportIdentifier`	The unique value that identifies the report, such as the BN code or organization name.
`ReportingWindow`	The time window in which the report was generated: - `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
`SequenceNumber`	The sequence number of the report file. The sequence number begins with `0` and continues until all parts of the report are recorded in files. The sequence number is always present in the report file name even if there is only 1 file.
`MajorVersion`	The major version of the report. This number increments when there are significant changes to the report.
`MinorVersion`	The minor version of the report. The minor version number increments with any change to the report. If there are no changes, it is `0`.
`Format`	The report format is `CSV` (comma-separated values).

Before you begin

We improve reports on an ongoing basis, which could include adding attributes. Use column names when you integrate with these reports, so that your integrations do not break when we add new columns.

Before using this report, review the following requirements and considerations:

You must be an approved partner to use this report.
This report is available if you onboard your sellers before payment.
PayPal generates the report and places it on the Secure FTP Server (SFTP) by 9:00 AM daily in the leading time zone of the reporting window.
A single file contains all cases.
Amounts in this report are in cents (multiplied by 100). For example, a $10 entry is 1000 in the report.

Report format

Each row of the report consists of a 2-letter row type, followed by the details that are specific to that row type. The following table lists the valid row types and the sections that describe the data for that row type.

Code, Description
Code	Description
`FH`	File header
`SH`	Section header
`CH`	Column header
`SB`	Section body
`SF`	Section footer
`FF`	File footer

File header data

The file header contains the following report metadata and configuration information.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (file header, `FH`).
2	`Report Generation Date`	`Date-time`	The date and time at which the report file was generated, in the format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the five-character signed offset from GMT, for example `+0800`.
3	`Reporting Window`	`Varchar`	The window of time in which the report was generated: `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 this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-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 this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
6	`Partner Account Number`	`Varchar`	The partner's PayPal encrypted account number.
7	`Report Identifier`	`Varchar`	The unique value that identifies the report, such as the BN code or organization name.

Section header data

The section header identifies the start of a new data section within the report.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (section header, `SH`)

Section body data

The section body contains the detailed case information and transaction data.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (section body, `SB`)
2	`CASE_ID`	`String`	The PayPal-generated ID for the case, in either of these formats: `PP-000-111-222-333` or `PP-D-99999`
3	`CASE_TYPE`	`Literal`	The case type. One of `CHARGEBACK`, `DISPUTE`, or `CHARGEBACK - RDR`. `RDR` refers to Rapid Dispute Resolution, a Visa service that automates pre-dispute resolution, often through automatic refunds.
4	`CASE_REASON`	`String`	The reason for the case: `Charge not recognized`, `Credit not processed`, `Duplicate payment`, `Inquiry - ACHReturn`, `Item not received`, `Item not received - ACHReversal`, `Merchandise`, `Merchandise - ACHReversal`, `Not as described`, `Other`, `Processing error`, `Recurring payment cancelled`, `Unauthorized`, `Unauthorized - ACHReversal`, or `Unauthorized - ATO`.
5	`CASE_FILING_DATE`	`Date-time`	The date and time at which the case was filed, in this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
6	`CASE_STATUS`	`String`	The status of the case: `Being Reviewed By PayPal`, `Open`, `Requiring your action`, `Resolved`, `Waiting For Additional Information`, `Waiting for Buyer's Response`, or `Waiting For Seller's Response`.
7	`PAYPAL_REFERENCE_ID`	`String`	The original parent transaction ID.
8	`INVOICE_NUMBER`	`String`	The invoice number for the transaction.
9	`CUSTOM_FIELD`	`String`	A field for custom data.
10	`CASE_AMOUNT`	`Money`	The disputed amount.
11	`CASE_CURRENCY`	Three-character currency code	The currency of the disputed amount.
12	`RESPONSE_DUE_DATE`	`Date-time`	The date and time by which the merchant is expected to respond for this case, in this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
13	`CASE_TRANSACTION_ID`	`String`	The parent transaction ID.
14	`CASE_REFUND_AMOUNT`	`Money`	The amount refunded to the buyer.
15	`CASE_REFUND_CURRENCY`	Three-character currency code	The currency of the refunded amount.
16	`CASE_UPDATE_DATE`	`Date-time`	The date and time at which the case was last updated, in this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
17	`FINAL_CASE_OUTCOME`	`Literal`	The final outcome of the dispute: `RESOLVED_BUYER_FAVOUR`, `RESOLVED_SELLER_FAVOUR`, `RESOLVED_WITH_REFUND`, or `CANCELED_BY_BUYER`. If the dispute or chargeback is not yet resolved, this field is blank.
18	`PROCESSOR_REASON_CODE`	`String`	The dispute reason code returned by the card network. This value is not normalized. Use `CASE_REASON` for the normalized dispute reason.
19	`BUYER_NOTES`	`String`	The buyer's reason or notes explaining why they filed the chargeback.

Section footer data

The section footer marks the end of a data section.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (section footer, `SF`)

File footer data

The file footer indicates the end of the report file.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (file footer, `FF`)

To see what's in this report, download a sample in CSV format. This sample may vary from your actual report, depending on your settings.

Report file name

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

MCR.<yyyymmdd>.<ReportIdentifier>.<ReportingWindow>.<SequenceNumber>.<MajorVersion>.<MinorVersion>.<Format>

Field, Description
Field	Description
`MCR`	The report type. In this case, it is `MCR` for Marketplaces Case Reconciliation.
`yyyymmdd`	The date for the data in the report. It represents the latest, or ending date, of the data.
`ReportIdentifier`	The unique value that identifies the report, such as the BN code or organization name.
`ReportingWindow`	The time window in which the report was generated: - `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
`SequenceNumber`	The sequence number of the report file. The sequence number begins with `0` and continues until all parts of the report are recorded in files. The sequence number is always present in the report file name even if there is only 1 file.
`MajorVersion`	The major version of the report. This number increments when there are significant changes to the report.
`MinorVersion`	The minor version of the report. The minor version number increments with any change to the report. If there are no changes, it is `0`.
`Format`	The report format is `CSV` (comma-separated values).

Before you begin

We improve reports on an ongoing basis, which could include adding attributes. Use column names when you integrate with these reports, so that your integrations do not break when we add new columns.

Before using this report, review the following requirements and considerations:

You must be an approved partner to use this report.
This report is available if you onboard your sellers before payment.
PayPal generates the report and places it on the Secure FTP Server (SFTP) by 9:00 AM daily in the leading time zone of the reporting window.
A single file contains all cases.
Amounts in this report are in cents (multiplied by 100). For example, a $10 entry is 1000 in the report.

Report format

Code, Description
Code	Description
`FH`	File header
`SH`	Section header
`CH`	Column header
`SB`	Section body
`SF`	Section footer
`FF`	File footer

File header data

The file header contains the following report metadata and configuration information.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (file header, `FH`).
2	`Report Generation Date`	`Date-time`	The date and time at which the report file was generated, in the format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the five-character signed offset from GMT, for example `+0800`.
3	`Reporting Window`	`Varchar`	The window of time in which the report was generated: `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 this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-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 this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
6	`Partner Account Number`	`Varchar`	The partner's PayPal encrypted account number.
7	`Report Identifier`	`Varchar`	The unique value that identifies the report, such as the BN code or organization name.

Section header data

The section header identifies the start of a new data section within the report.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (section header, `SH`)

Section body data

The section body contains the detailed case information and transaction data.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (section body, `SB`)
2	`CASE_ID`	`String`	The PayPal-generated ID for the case, in either of these formats: `PP-000-111-222-333` or `PP-D-99999`
3	`CASE_TYPE`	`Literal`	The case type. One of `CHARGEBACK`, `DISPUTE`, or `CHARGEBACK - RDR`. `RDR` refers to Rapid Dispute Resolution, a Visa service that automates pre-dispute resolution, often through automatic refunds.
4	`CASE_REASON`	`String`	The reason for the case: `Charge not recognized`, `Credit not processed`, `Duplicate payment`, `Inquiry - ACHReturn`, `Item not received`, `Item not received - ACHReversal`, `Merchandise`, `Merchandise - ACHReversal`, `Not as described`, `Other`, `Processing error`, `Recurring payment cancelled`, `Unauthorized`, `Unauthorized - ACHReversal`, or `Unauthorized - ATO`.
5	`CASE_FILING_DATE`	`Date-time`	The date and time at which the case was filed, in this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
6	`CASE_STATUS`	`String`	The status of the case: `Being Reviewed By PayPal`, `Open`, `Requiring your action`, `Resolved`, `Waiting For Additional Information`, `Waiting for Buyer's Response`, or `Waiting For Seller's Response`.
7	`PAYPAL_REFERENCE_ID`	`String`	The original parent transaction ID.
8	`INVOICE_NUMBER`	`String`	The invoice number for the transaction.
9	`CUSTOM_FIELD`	`String`	A field for custom data.
10	`CASE_AMOUNT`	`Money`	The disputed amount.
11	`CASE_CURRENCY`	Three-character currency code	The currency of the disputed amount.
12	`RESPONSE_DUE_DATE`	`Date-time`	The date and time by which the merchant is expected to respond for this case, in this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
13	`CASE_TRANSACTION_ID`	`String`	The parent transaction ID.
14	`CASE_REFUND_AMOUNT`	`Money`	The amount refunded to the buyer.
15	`CASE_REFUND_CURRENCY`	Three-character currency code	The currency of the refunded amount.
16	`CASE_UPDATE_DATE`	`Date-time`	The date and time at which the case was last updated, in this format: `YYYY/MM/DD HH:MM:SS offset`. `offset` is the 5-character signed offset from GMT, for example `+0800`.
17	`FINAL_CASE_OUTCOME`	`Literal`	The final outcome of the dispute: `RESOLVED_BUYER_FAVOUR`, `RESOLVED_SELLER_FAVOUR`, `RESOLVED_WITH_REFUND`, or `CANCELED_BY_BUYER`. If the dispute or chargeback is not yet resolved, this field is blank.
18	`PROCESSOR_REASON_CODE`	`String`	The dispute reason code returned by the card network. This value is not normalized. Use `CASE_REASON` for the normalized dispute reason.
19	`BUYER_NOTES`	`String`	The buyer's reason or notes explaining why they filed the chargeback.

Section footer data

The section footer marks the end of a data section.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (section footer, `SF`)

File footer data

The file footer indicates the end of the report file.

Position, Column name, Data type, Description
Position	Column name	Data type	Description
1	`Column Type`	`Literal`	The column type (file footer, `FF`)

Marketplace Case Reconciliation report

Report file name

Before you begin

Report format

File header data

Section header data

Section body data

Section footer data

File footer data

On this page

On this page

On this page

Marketplace Case Reconciliation report

Report file name

Before you begin

Report format

File header data

Section header data

Section body data

Section footer data

File footer data

On this page

On this page

Marketplace Case Reconciliation report

On this page

On this page

On this page

If you accept cookies, we’ll use them to improve and customize your experience and enable our partners to show you personalized PayPal ads when you visit other sites. Manage cookies and learn more

Marketplace Case Reconciliation report

On this page

On this page