Fee Transaction Report

DocsLimited

Last updated: Aug 17th, 8:04pm

The Fee Transaction Report (FTR) provides a detailed, transaction-level breakdown of interchange fees, scheme fees, and PayPal fees for card-processed transactions.

Note: You can access this report if you use the IC++ pricing model for card processing.

The report is available daily by 12:00 PM in your leading timezone of the reporting window and delivered to your SFTP folder in the /ppreports/outgoingdirectory. Contact your account team to schedule the report generation and delivery to your SFTP folder.

For instructions on accessing SFTP reports, see Access SFTP reports.

Know before you begin

Format: The report is available only in comma-separated values (CSV) format.

Encoding: The report uses UTF-8 (8-bit UCS/Unicode Transformation Format) character encoding.

Note: Use column names while integrating with the report, ensuring your integration remains stable if PayPal adds new columns or attributes in future updates.

Report file name

The report file name uses the following naming convention:

ABC1--6ABKUHNC34696-FTR-FEE_TRANSACTIONAL_REPORT-202206-1-1-20220602000000.csv

For information on file name conventions, see glossary.

How to use the report

To identify the total IC++ fees for a specified merchant account:

Select all records with the same merchant account ID.

Review the following columns listed for each record:
- Related Record type - type of transaction accruing the fee
- Total interchange fees
- Total scheme fees
- Total PayPal fees

Note: There can be some monthly scheme fees that is charged to the merchant account on a monthly basis. These are fees that are not attributed to any individual transactions.

Download a sample report

Download the sample report in CSV format to view what's available in the Fee Transaction Report.

Report specification

The report contains three sections:

RH-Report header

RD-Report details

RF-Report footer

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

Position	Column name	Optional/Required	Data type	Description
1	RH	Required	Static 2 characters	Indicates to the merchant that this row of data contains report header data.
2	Report name	Required	Character varying (256)	Name of the report. It defaults to `FEE_TRANSACTIONAL_REPORT`, or displays a custom name.
3	Report status	Required	Success/Error	Report generation status
4	Report generated	Required	`YYYY-MM-DD`	Report generation date and time in the format `YYYY/MM/DD`, where: `YYYY` indicates the year in four-digits. `MM` indicates the month of the year in two-digits. `DD` indicates the day of the month in two-digits.
5	Hierarchy	Required	Character varying (256)	Encrypted account number of the partner, also called the payer ID.
6	Time zone	Required	Character varying (256)	Time zone of the report.

Report details

Position	Column Name	Optional/Required	Data Type	Description
1	RD	Required	Static 2 characters	Indicates that this row contains the main details of the report.
2	Record ID	Required	Character varying (256)	Unique identifier for the transaction.
3	Related record ID	Optional	Character varying (256)	Indicates the transaction ID of the immediate parent.
4	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.
5	Record type	Required	Character varying (256)	Transaction type, such as Fees. For more information, see glossary.
6	Record subtype	Optional	Character varying (256)	Transaction subtype. For more information, see glossary.
7	Related record type	Optional	Character varying (256)	Record type of the original transaction that contributes to the fee transaction.
8	Related record subtype	Optional	Character varying (256)	Record subtype of the original transaction that contributes to the fee transaction.
9	Merchant account ID	Required	Character varying (256)	Encrypted account number of the merchant.
10	Partner identifier	Optional	Character varying (256)	Channel partner who initiates the transaction. Partner identifiers are created when merchants authorize channel partners to initiate transactions.
11	Invoice ID	Optional	Character varying (256)	Transaction order ID 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)	Payment method used to process the transaction. For more details, see glossary.
15	Payment instrument subtype	Optional	Character varying (256)	Specific tendor under the payment method that processes the transaction. For more details, see glossary.
16	Created at	Required	`YYYY-MM-DD HH:MM:SS offset`	Date and time when the transaction is initiated, in the format `YYYY/MM/DD HH:MM:SS offset`, where: `YYYY` indicates the year in four-digits. `MM` indicates the month of the year in two-digits. `DD` indicates the day of the month in two-digits. `HH` indicates the hour in 24-hour notation. `MM` indicates the minutes. `SS` indicates the seconds. `offset` indicates the five-character signed offset from GMT. For example, +0800.
17	Record currency	Required	Character varying (3)	Transaction currency. For possible values, see PayPal Supported Currencies.
18	Gross amount	Required	Numeric (23, 2)	Total transaction amount before fee deduction.
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)	Net disbursed amount, which is the gross amount minus total fees billed.
21	Transfer ID	Optional	Character varying (256)	Unique identifier passed during funds withdrawal to either BANK or Hyperwallet (HW) or any external instrument that appears against the transaction in the bank statement or HW statement of the merchant. In the Disbursement Report, Transfer ID allows the merchant to reference all the transactions that contributes to a particular withdrawal.
22	External payout instrument	Optional	Character varying (256)	External account or payment method where the payout amount is sent. Example: Bank, HW for Hyperwallet.
23	Related record gross amount	Required	Numeric (23, 2)	Total original transaction amount (for example, sale, refund, or payout) that is linked to the fee transaction.
24	Variable fee rate	Optional	Numeric (23, 4)	PayPal fee rates, represented in percentage. For example, 2.49% = .0249.
25	Fixed fees	Optional	Numeric (23, 2)	Fixed PayPal fees.
26	PayPal fees	Optional	Numeric (23, 2)	Total PayPal fees applicable for each transaction.
27	FX variable rate	Optional	Numeric (23, 2)	PayPal’s markup rate for FX Optimizer enabled currency conversion transactions.
28	FX fixed fees	Optional	Numeric (23, 2)	PayPal’s markup amount for FX Optimizer enabled currency conversion transactions.
29	Fees description	Optional	Character varying (256)	Name of the interchange program classification.
30	Interchange rate	Optional	Numeric (23, 4)	Interchange rate applied to this transaction.
31	Interchange fixed fees	Optional	Numeric (23, 5)	Interchange fixed fee applied to this transaction.
32	Interchange fees	Optional	Numeric (23, 5)	Total interchange fee charged by the issuer.
33	Scheme fees	Optional	Numeric (23, 5)	Total scheme fees applied to this transaction.
34	Total passthrough fees	Optional	Numeric (23, 5)	Total passthrough fees applied to this transaction. It is the sum of total interchange fees and total scheme fees.
35	Fees count	Optional	Numeric (23, 5)	Total number of transactions subject to aggregated fees, such as gateway fees.
36	Total fees gross billed	Optional	Numeric (23, 5)	Total fee applied to this transaction. This fee is billed monthly to the merchant.
37	Invoicing currency	Optional	Character varying (256)	Currency associated with the invoice account that issues the invoice. For possible values, see PayPal Supported Currencies.
38	Total fees gross billed in Invoice currency	Optional	Numeric (23, 5)	Converted amount in the invoice account's primary currency, rounded to five decimal places.
39	Gross billing month	Optional	`MM-YY`	Month when the gross billing amount reflects in the monthly invoice.
40	Network name	Optional	Character varying (256)	Network responsible for processing transactions, specific to low-cost processing networks.
41	Cross border transaction	Optional	One-character flag	This field indicates whether the transaction is cross-border. Y - Cross-border transaction. N – Non cross-border transaction.
42	Case ID	Optional	Character varying (256)	Dispute ID, if the transaction is linked to a dispute.
43	Store ID	Optional	Character varying (256)	ID of the store where the buyer initiates the transaction.
44	Reader ID	Optional	Character varying (256)	Terminal ID in the store where the buyer initiates the transaction.
45	Payment channel	Optional	Character varying (256)	Indicates if the transaction is online or offline.
46	Reason code	Optional	Character varying (256)	Reason for transaction decline. For card transactions, it specifies processor decline code. For bank transactions, it specifies bank decline code. For more information, see processor decline codes. For information on SEPA Direct Debit (SDD) declines, see guidance on reason codes.
47	Payout item ID	Optional	Character varying (256)	Payout transaction identifier.
48	Memo	Optional	Character varying (256)	Custom information that the user provides when calling the API to initiate a transaction.

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)	Current file number, included in the report file name.
3	Total records	Required	Numeric (23, 2)	Total number of transactions listed in the report detail section of a specific file. This field appears in the report only if transaction details are present.
4	Total files	Required	Numeric (23, 2)	Total number of files generated for the report.