Rounding and trimming

Trimming in the Fee-Per-_ Files

The fee-per-* files will represent fees with greater precision (ex: discount rates) than in the rounded aggregate file and in the clearing statement for representative purposes. To simplify presentation, PPRO trims digits after the fourth decimal place in the fee-per-* files. There is no rounding in the fee-per-* files.

This means that, for example, a transaction of 1.03 EUR billed a fee of 0.74% would be rendered as a fee of 0.0076 EUR in the fee-per-transaction file. See the sample file below:

Rounding in the Aggregate File

For the aggregate file, the volumes of all transactions based on a combination of merchant, scheme, currency, and EVENT_TYPE are summed before multiplying the summed value against the %-based fee (ex: DISCOUNT_RATE). This amount is then rounded to the nearest cent using a normal rounding mechanism: up from .005, down from .004 (regardless of whether the values are positive or negative). Non-%-based fees are simply multiplied against the count of transactions and then summed; no rounding of these fees is necessary.

The above data would then appear in the aggregated file as per the following example: