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
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 7 months ago