# Fees report (/reports/fees-reports)
The fees report provides a transaction-level breakdown of interchange fees, scheme fees, and PayPal fees that are associated with card-processed transactions.
> **Note:** The fees report is only available if you are using the IC++ pricing model for processing card transactions.
The fees report is created on the 6th day of each month and is available by no later than 12:00PM daily in the leading time zone of the reporting window.
You can access the fees report through the PayPal merchant portal or over SFTP. The report is available on the secure FTP Server in the `/ppreports/outgoingdirectory`.
See [Access SFTP reports](/reports/access/) for instructions.
You can also find the summary of these fees in your monthly statement report under [Fees Summary](/reports/monthly-custom-statements/#pdf-report-format).
Download the [sample fees report](/reports/fee-sample-report.csv).
## Prerequisites [#prerequisites]
* The fees report is only available in comma-separated values (CSV) format.
* The fees report uses UTF-8 (8-bit UCS/Unicode Transformation Format) character encoding.
> **Note:** PayPal can enhance these reports and add additional attributes to the reports in the future. Use column names when integrating with these reports, so that your integrations don't break when new columns are added to the reports.
## Report file name [#report-file-name]
The naming convention of the fees report filename is as follows:
`ABC1--6ABKUHNC34696-FTR-FEE_TRANSACTIONAL_REPORT-202206-1-1-20220602000000.csv`
See the [terminology](/reports/reference/terminology) page for more details about file name conventions.
## How to use the Report [#how-to-use-the-report]
To identify the total IC++ fees for a specific merchant account:
1. Select all records with the same merchant account ID
2. Iterate through the records and consume at least the following columns:
* Related Record type – type of transaction accruing the fee
* Total interchange fees
* Total scheme fees
* PayPal total fees
> **Note:** Some monthly scheme fees are not attributed to any individual transaction, and are not present in the fees report. Use the monthly statement to get the total monthly scheme fee components.
## Report Specification [#report-specification]
The report contains three sections:
1. RH - Report Header
2. RD - Report Details
3. RF – Report Footer
For the fees report, the section implementation is as follows:
| **CSV Code** | **Section** | **Description** | **Configurable** |
| ------------ | -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------- |
| RH | Report Header | You should have the following fields in the Fee Transactional Report:Report name: Name of the report. The default name is `FEE_TRANSACTIONAL_REPORT`. If the name is customized, the report name shows the custom name or the standard default name.Report status: `Success` or `Error`.Report generated: The date the report was generated.Hierarchy: Encrypted PayPal account number.Timezone: Time zone of the report | No |
| RD | Report Details | For the fee transactional report:
A transaction-level breakdown of the interchange fees, scheme fees and the PayPal fees associated with their card-processing transactions. | No |
| RF | Report Footer | This section includes the following information:File number: The current file number, which is part of the file naming convention.Total records: The number of transactions included in the detail section in a specific file. This field is shown in the report only if there are transactional details.Total files: The number of files generated for the report. | No |
## Report Header [#report-header]
| **Position** | **Column name** | **Optional/Required** | **Data type** | **Description** |
| ------------ | ---------------- | --------------------- | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 1 | RD | Required | Static 2 characters | Indicates to the merchant that this row of data contains report body data. |
| 2 | Report name | Required | Character varying (256) | Name of the report. The default is`FEE_TRANSACTIONAL_`
`REPORT.`If customized, the report uses that custom name, otherwise the default. |
| 3 | Report status | Required | Success / Error | Report generation status. |
| 4 | Report generated | Required | YYYY-MM-DD | The date and time when the report file was generated, in the following format: YYYY/MM/DD whereYYYY is the four-digit year.MM is the two-digit month of the year.DD is the two-digit day of the month. |
| 5 | Hierarchy | Required | Character varying (256) | Encrypted account number of the merchant, also called the payer ID. |
| 6 | Time zone | Required | Character varying (256) | The time zone of the report. |
## Report Details [#report-details]
| **Position** | **Column name** | **Optional/Required** | **Data type** | **Description** |
| ------------ | -------------------------- | --------------------- | ----------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 1 | RH | Required | Static 2 characters | Indicates that this row of data contains report body data. |
| 2 | Merchant account ID | Required | character varying (256) | Encrypted account number of the merchant. |
| 3 | Record ID | Required | character varying (256) | Unique identifier for this transaction. |
| 4 | Related record ID | Optional | character varying (256) | Indicates the immediate parent transaction ID. |
| 5 | Original record ID | Optional | character varying (256) | Unique ID of a previous transaction referenced by this transaction. For example, refund transactions also contain the ID of the original sale transaction. |
| 6 | Record type | Required | character varying (256) | Specifies the transaction type, such as `Fees`. |
| 7 | Record subtype | Optional | character varying (256) | Specifies the transaction's subtype, such as:
`Total Fees`: Total monthly fees charged by PayPal.`Chargeback Fees`: Fees for chargeback processing.`Dispute Fees`: Fees for disputes requiring PayPal's resolution.`Bank Return Fees`: Recovery of fees charged by the bank for returns due to insufficient funds, high risk, unauthorized transactions, or other reasons.`Transactional Fees`: Fees charged on transactions.`Scheme Fees`: Fees charged by card networks (schemes) and processed by PayPal. Types include: `Authorization`: Standard fee for authorizing a transaction.`Authorization Misuse`: Fee for improper authorization attempts.`Monthly`: Recurring monthly scheme fee.`FPA Fees`: Fees for the [Fraud Protection Advanced](/platforms/checkout/advanced/customize/fraud-protection/fraud-protection-advanced/) feature.`Account Updater Fees`: Fees for automatically updating expired or compromised cards on file.`Authorization Fees`: Fees for authorization events. Statuses include: `Created`: Fee applied when an authorization request is initiated.`Success`: Fee applied upon successful authorization.`Decline/Denied`: Fee applied for declined or denied authorizations.`Capture Fees`: Fees for capture events. Statuses include: `Success`: Fee applied upon successful capture of funds.`Decline/Declined`: Fee applied for declined or denied captures.`Charge Fees`: Fees for successful charges.`Refund Fees`: Fees for successful refunds. |
| 8 | Related record type | Optional | character varying (256) | Record Type of the Original transaction which is contributing to this transaction. |
| 9 | Related record subtype | Optional | character varying (256) | Record subtype of the Original transaction which is contributing to this transaction. |
| 10 | Partner identifier | Optional | character varying (256) | The channel partner who initiated the transaction. The partner identifier is created when the merchant has authorized a channel partner to initiate transactions. |
| 11 | Invoice ID | Optional | character varying (256) | The order ID of the transaction passed by the merchant. |
| 12 | Original invoice ID | Optional | character varying (256) | Order ID of the original sale transaction. |
| 13 | Custom field | Optional | character varying (256) | Custom field |
| 14 | Payment instrument type | Optional | character varying (256) | The method of payment used to process the transaction. For more details, see [Terminology](/reports/reference/terminology/#payment-instrument-type-and-subtype). |
| 15 | Payment instrument subtype | Optional | character varying (256) | The specific tender used to process the transaction. For more details, see [Terminology](/reports/reference/terminology/#payment-instrument-type-and-subtype). |
| 16 | Created at | Required | YYYY-MM-DD HH:MM:SS | Date and time the transaction was initiated, in the following format: YYYY/MM/DD HH:MM:SS offset. Where:`YYYY` is the four-digit year.`MM` is two-digit month of the year.`DD` is the two-digit day of the month.`HH` is the hour in 24-hour notation.`MM` is minutes.`SS` is seconds.offset is the five-character signed offset from GMT. For example, +0800 |
| 17 | Record currency | Required | character varying (3) | Currency of the transaction. See [PayPal Supported Currencies](/reports/reference/supported-currencies/) for possible values. |
| 18 | Gross amount | Required | numeric (23, 2) | Total amount of the transaction before deducting fees. |
| 19 | Total fees net billed | Optional | numeric (23, 2) | Total PayPal fees deducted as part of the transaction. |
| 20 | Net amount | Required | numeric (23, 2) | The net disbursed amount, which is the gross amount minus total fees billed. |
| 21 | Transfer ID | Optional | character varying (256) | Unique identifier passed at the time of withdrawal of funds to either BANK or HW or any external instrument that appears against the transaction in the bank statement / HW statement of the merchant. In the Disbursement Report, this enables the merchant to reference all the transactions that contributed to a particular Withdrawal. |
| 22 | Variable fee rate | Optional | numeric (23, 4) | PayPal fee rates, represented in percentage. For example, 2.49% = .0249 |
| 23 | Fixed fees | Optional | numeric (23, 2) | Fixed PayPal fees. |
| 24 | PayPal fees | Optional | numeric (23,2) | Total PayPal fees applicable for each transaction. |
| 25 | Fees description | Optional | character varying (256) | Name of the interchange program classification. |
| 26 | Interchange rate | Optional | numeric (23, 4) | Interchange rate applied to this transaction. |
| 27 | Interchange fixed fees | Optional | numeric (23,5) | Interchange fixed fee applied to this transaction. |
| 28 | Interchange fees | Optional | numeric (23,5) | Total interchange fee charged by the issuer. |
| 29 | Scheme fees | Optional | numeric (23,5) | Total scheme fees applied to this transaction. |
| 30 | Total passthrough fees | Optional | numeric (23,5) | Total passthrough fees applied to this transaction. The sum of total interchange fees and total scheme fees. |
| 31 | Total fees gross billed | Optional | numeric (23,5) | Total fee applied to this transaction. This fee is billed monthly to the merchant. |
| 32 | Store ID | Optional | numeric (23,2) | ID of the store where the transaction was initiated. |
| 33 | Reader ID | Optional | numeric (23,2) | Terminal ID in the store where the transaction was initiated. |
| 34 | Payment tracking ID | Optional | numeric (23,2) | The tracking ID specified by partners to obtain information about a payment or to request a refund. This value is not unique and can be blank. |
## Report Footer [#report-footer]
| **Position** | **Column name** | **Optional/Required** | **Data type** | **Description** |
| ------------ | --------------- | --------------------- | ------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 1 | RF | Required | Static 2 characters | Indicates that this row of data contains report footer data. |
| 2 | File number | Required | numeric (23, 2) | The current file number, which is part of the file naming convention. |
| 3 | Total records | Required | numeric (23, 2) | Total records: The number of transactions included in the detail section in a specific file. This field is shown in the report only if there are transactional details. |
| 4 | Total files | Required | numeric (23, 2) | The number of files generated for the report. |