Partner fee report

Docs

Last updated: Aug 15th, 7:24am

This report provides a detailed view of the transactions affecting the partner fee account and helps with reconciliation and management of revenue through partner fees.

This report is generated and placed on SFTP by 12:00 PM daily in the leading time zone of the reporting window.

The actual amounts in this report are multiplied by 100 to represent the amounts as cents. For instance, a $10 entry appears as 1000 on the report.

Report file name

The file name of the Partner Fee Report for a single account follows this naming convention:

PF.yyyymmdd.BNCode.ReportingWindow.SequenceNumber.MajorVersion.MinorVersion.Format
Field Information
PF An abbreviation for Partner Fee 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 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.
6 BN Code Varchar Unique ID for the platform.
Section Header Data
1 Column Type Literal SH
Section Body Data
1 Column Type Literal The column type (CH).
2 Transaction Type Varchar The type of transaction. One of:
  • Payment
  • Refund
  • Dispute Initiated
  • Dispute
  • Chargeback Initiated
  • Chargeback
  • Disbursement
  • Partner Bank Transfer
3 Account Number Varchar Seller's PayPal encrypted account number.
4 PayPal Reference ID String Original PayPal transaction ID to which this event is related.
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 Custom Field Varchar A field for custom data.
7 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.
8 Transaction Currency Three character currency code The currency of the transaction.
9 Buyer Amount Money Amount of funds transferred to or from a customer. Funds that are transfered to the customer have a dash (-) prefix.
10 Partner Fee Money Partner fees associated with the transaction. Funds moving out of the partner fee account have a dash (-) prefix.
11 Bank Transaction Amount Money Funds transferred to the seller's bank account.
12 Transaction Status String Denotes the status of the transaction. `S`- Success, `P` - Pending
Section Footer Data
1 Column Type Literal The column type (SF).
File Footer Data
1 Column Type Literal The column type (FF).

We use cookies to improve your experience on our site. May we use marketing cookies to show you personalized ads? Manage all cookies