On this page
No Headings
Last updated: July 14, 2026
This report provides a detailed view of activity on your financial account. It includes all transactions and links each entry to its original transaction.
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.
Before using this report, review the following requirements and considerations:
1000 in the report.The file name of the Financial Detail Report for a single account follows this naming convention:
<FINANCIAL_DETAIL>.<yyyymmdd>.<ReportIdentifier>.<ReportingWindow>.<SequenceNumber>.<MajorVersion>.<MinorVersion>.<Format>| Field | Description |
|---|---|
FINANCIAL_DETAIL | The report type. For this report, the value is FINANCIAL_DETAIL. |
yyyymmdd | The date for the data in the report. It represents the latest, or ending date, of the data. |
ReportFileName | The report file name that you specify in your preferences. |
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. It is 2 characters, right-justified, and zero-filled. 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). |
Each row of the report consists of a 2-letter row type, followed by the details for that row type. The following table lists the valid row types and the sections that describe the data for that row type.
| Code | Description |
|---|---|
FH | File header |
SH | Section header |
CH | Column header |
SB | Section body |
SF | Section footer |
FF | File footer |
The file header contains metadata about the report file, including generation timestamp and account information.
| 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 5-character signed offset from GMT, for example +0800. |
| 3 | Reporting Window | Varchar | 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 |
| 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 | Financial Account Number | Varchar | The partner's financial encrypted account number |
The section header contains the following column.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (section header, SH) |
The section body section contains transaction-level information for each transaction that affects your balance.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (section body, SB) |
| 2 | TRANSACTION_TYPE | Varchar | The type of transaction: PAYMENT, CORRECTION, CURRENCY_CONVERSION, DEPOSIT, DISBURSEMENT, FEES, HOLD, HOLD_RELEASE, OTHER, RECOUP, REFUND, REVERSAL, WITHDRAWAL, PAYABLE, RECEIVABLE, TRANSFER, SETTLEMENT_CONSOLIDATION, ACH_REVERSAL, BONUS, PAYOUT_REFUND, or PAYOUT_REVERSAL |
| 3 | TRANSACTION_SUBTYPE | Varchar | The subtype of the transaction: FEE, REVERSAL, PARTNER_FEE, PAYMENT_FEE, MASS_PAY, BANK, LOSS_ACCOUNT, DEPOSIT, WITHDRAWAL, FROM, TO, FOREIGN_WITHDRAWAL, or BONUS. When the transaction type is CORRECTION, the TRANSACTION_SUBTYPE is either DEPOSIT or WITHDRAWAL, depending on the direction of the funds. |
| 4 | COUNTERPARTY_ACCOUNT_ID | Varchar | Encrypted PayPal account number for the counterparty in the transaction |
| 5 | COUNTERPARTY_TRANSACTION_TYPE | Varchar | The transaction type that contributed to the actual transaction. This can be any valid TRANSACTION_TYPE value. For example, if TRANSACTION_TYPE is FEES, and TRANSACTION_SUBTYPE is PARTNER_FEE, the COUNTERPARTY_TRANSACTION_TYPE can be PAYMENT or REFUND. |
| 6 | COUNTERPARTY_TRANSACTION_SUBTYPE | Varchar | The subtype of the transaction that contributed to the actual transaction. It can be any valid TRANSACTION_SUBTYPE value. |
| 7 | PAYPAL_REFERENCE_ID | String | Original PayPal transaction ID to which this event refers |
| 8 | PAYPAL_TRANSACTION_ID | Varchar | PayPal transaction ID |
| 9 | INVOICE_ID | Varchar | Invoice ID of the transaction |
| 10 | CUSTOM_FIELD | Varchar | A field for custom data |
| 11 | TRANSACTION_DATE | Date-time | The date and time when the transaction was initiated, in this format: YYYY/MM/DD HH:MM:SS offset. offset is the 5-character signed offset from GMT, for example +0800. |
| 12 | INTEGRATION_IDENTIFIER | Varchar | For multi-tenancy partners, this identifier is the organization name. For partners who onboard before payment, this identifier is the button source code. |
| 13 | PP_FEES | Money | PayPal fees that are associated with the transaction. Funds that are moving out of the PayPal fee account have a dash (-) prefix. |
| 14 | PP_FEES_PERCENTAGE | Varchar | Percentage of the transaction amount that was charged as a fee. Total PayPal fees include PP_FEES_PERCENTAGE and PP_FEES_FIXED_AMOUNT. |
| 15 | PP_FEES_FIXED_AMOUNT | Money | Fixed PayPal fee amount of PayPal fees. Total PayPal fees include PP_FEES_PERCENTAGE and PP_FEES_FIXED_AMOUNT. |
| 16 | PP_FEES_CURRENCY | 3-character currency code | The currency of the PayPal fee |
| 17 | BASE_FX_RATE | Varchar | Base rate that PayPal sets to fall within the buy and sell wholesale currency market rates that are published by a reputable, independent publisher on the conversion day |
| 18 | MARKUP_FX_RATE | Varchar | Markup fee percentage for the currency exchange |
| 19 | NET_FX_RATE | Varchar | The Company Base Rate plus or minus the Markup FX Rate currency conversion spread |
| 20 | TRANSACTION_CURRENCY | 3-character currency code | The currency of the transaction |
| 21 | TRANSACTION_AMOUNT | Money | The transaction amount |
| 22 | DECLINE_CODE | Varchar | Indicates the reason for decline, when available. Processor decline codes apply to credit card transactions; bank decline codes apply to bank transactions. |
| 23 | SETTLEMENT_REFERENCE_ID | Varchar | The bank reference ID for the bank transfer transaction |
The section footer contains the following column.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (section footer, SF) |
The file footer contains the following column.
| Position | Column name | Data type | Description |
|---|---|---|---|
| 1 | Column Type | Literal | The column type (file footer, FF) |