Fee per transaction file description
The -fee-per-transaction.csv file includes a detail-level report of all fees incurred on payments across all boarded merchants within a given settlement period. This will be delivered every day that settlement has been made along with the other 7 describing that settlement period. Percentage-based fees calculated in this file are provided as indicative values, with final rounding taking place in the calculations for the aggregate file.
The naming convention will be:
<merchant number>-<frequency>-<year>-<ongoing number>-<suffix>.csv
Example: 1-999-W-2016-07-fee-per-transaction.csv
The file will contain the following data:
| Column | Description | Type |
|---|---|---|
MERCHANT_TX_ID | An optional merchant-provided identifier for the transaction[a-zA-Z0-9.,-_]{1,40} | string |
TX_ID | A PPRO-provided identifier for the transaction | numeric |
PAYMENT_REFERENCE | Public identifier of the transaction | string |
EVENT_TYPE | See EVENT_TYPE below | string |
EVENT_TIMESTAMP | ISO_8601 UTC timestamp (format YYYY-MM-DDThh:mm:ssZ) of the event | string |
MERCHANT_ID | Contract ID identifying each unique merchant as provided by PPRO upon onboarding | string |
PAYMENT_METHOD | Name of the payment method (e.g. “SEPA Direct Debit”)[a-zA-Z0-9]{1,40} | string |
FEE_TYPE | See FEE_TYPEs below | string |
AMOUNT | Amount of the fee | numeric |
CURRENCY | 3-digit ISO currency code describing the amount | string |
COUNTRY | 2-digit ISO country code describing the origin of the payment | string |
EVENT_TYPE Descriptions
| EVENT_TYPE | Description |
|---|---|
INITIALIZED | A transaction which was initialized and billed as such |
SUCCEEDED | A transaction in a technical successful state |
FEE_TYPE Descriptions
| FEE_TYPE | Description |
|---|---|
ACQUIRING_FEE | This is a per-transaction fee (not a %) for processing a transaction |
DISCOUNT_FEE | Per-transaction % that is debited from the ultimate settlement |
PROCESSING_FEE | Additional per-transaction (not a %) fee |
SUCCEEDED_FEE | A fee charged when a transaction moves from any state to a SUCCEEDED state (not a % of transaction value) |
Note on rounding of DISCOUNT_FEE amounts
Values in the AGGREGATE_AMOUNT column of DISCOUNT_FEE are calculated with a precision of 100th of the (minor) currency unit. E.g. for EUR, the precision is 100th of a cent - the 3rd and 4th digit after the comma. For the Japanese Yen the precision is 100th of a yen - the 1st and 2nd digit after the comma. Digits during calculation beyond the precision are discarded, effectively leading to rounding down.
Examples:
- The
DISCOUNT_FEEof an aggregate with a total volume of 9.99 EUR and aDISCOUNT_FEE-Percentage of 1.111% is 0.1109. The calculation steps done are:round_down(9.99 * 1.111%, 4)round_down(0.1109889, 4)0.1109
- The
DISCOUNT_FEEof an aggregate with a total volume of 999 YEN and aDISCOUNT_FEE-Percentage of 1.111% is 0.1109. The calculation steps done areround_down(999 * 1.111%, 4)round_down(11.09889, 4)11.09
Note
See your PPRO contract for information about the applicability of each fee type. Reach out to your account manager for more details.
Important
When files are delivered in the SFTP, they will be zipped in a gzip format (*.gz). Please ensure that your system can extract gz files before processing.
Updated 5 months ago