Consolidated Settlement & Reconciliation
For reconciliation purposes, we provide an Electronic Payment Advice (EPA) file. The EPA file is delivered in CSV format and contains payment information for the relevant Settlement Period.
The EPA format consists of two main elements:
- Header: contains summary information for the EPA file.
- Transactions: contains transaction-level details, one line per transaction.
The Total Settlement Amount stated in the header is the amount transferred to the bank account. If the previous settlement balance is negative, it has already been deducted from this amount.
File format
- Fields are separated by a comma (
,). - The file has no column name row. The first line is always the header record, followed by the transaction records.
Amount format
All amount fields in the EPA file, in both the header and the transaction lines, are integers with two implied decimal places. The file contains no decimal separator and no thousands separator. To get the actual amount, divide the value by 100.
| Value in file | Amount |
|---|---|
| 2211 | 22.11 |
| -1635 | -16.35 |
| 50 | 0.50 |
| 0 | 0.00 |
Negative amounts are prefixed with a minus sign (-). Positive amounts have no sign. Fields in this format are marked as Amount in the tables below.
EPA Header
The header is the first line of an EPA file and always starts with "H" (for Header). It contains summed amounts and general information. Example:
H,EUR,330615,-1635,-133755,-36732,0,0,52815,52815,158493,2511,26220356565,20261125,NET,NL91ABNA0417164300
The table below describes the variables in the header and their format.
| Variable Name | Type | Validation |
|---|---|---|
| record_type | String (1) | Constant string "H" for Header. |
| payout_currency | String (3) | The settlement currency in ISO 4217, all caps. Example: "EUR" |
| total_sale_amount | Amount | The total sale amount. Example: 330615 for EUR 3306.15. Always positive, unless there are no sale records, then 0. |
| total_fee_amount | Amount | The total fee amount: service fees charged by Riverty, including dispute fees. Example: -1635 for EUR -16.35. Predominantly negative, but can be positive in rare cases (e.g. the EPA file contains more refunds than sales). If there are no fee records, 0. |
| total_refund_amount | Amount | The total refund amount, representing returns by the customer. Example: -133755 for EUR -1337.55. Always negative, unless there are no refund records, then 0. |
| total_other_amount | Amount | The total of all other transaction types (Chargeback, VATCLA, Adjustment). Example: -36732 for EUR -367.32. Can be positive or negative. If there are no records, 0. |
| total_holdback_amount | Amount | The total holdback amount, representing the amount that Riverty is holding back (rolling reserve). Reasons for a holdback are the merchant exceeding the advanced payment limit, covering future refunds, or other security reasons. Example: -15588 for EUR -155.88. Always negative, unless there are no holdback records, then 0. |
| total_release_amount | Amount | The total release amount, representing the amount that Riverty is releasing, which was previously held back due to the advanced payment limit. Example: 15588 for EUR 155.88. Always positive, unless there are no release records, then 0. |
| previous_settlement_balance | Amount | The closing balance of the previous settlement. Example: 17605 for EUR 176.05. Can be positive or negative. If negative, it is deducted from this payout and included in total_settlement_amount. |
| previous_payout | Amount | The total payout amount of the previous settlement. Example: 17605 for EUR 176.05. Can be positive or negative. A negative value means the merchant owed Riverty in the previous settlement; this amount is rolled over and deducted in the next Settlement Period. |
| total_settlement_amount | Amount | The total settlement amount that will be transferred to the merchant. Calculated as the sum of: total_sale_amount, total_fee_amount, total_refund_amount, total_other_amount, total_holdback_amount, total_release_amount, and previous_settlement_balance if it is negative. Example: if the sum of the totals is 158493 and previous_settlement_balance is -20000, total_settlement_amount is 138493 (EUR 1384.93). |
| number_of_records | Integer | The number of transaction records (lines starting with "D") in this EPA file. The header line is not counted. Example: 2511 |
| payment_reference | Integer | ID generated by Riverty. Example: 26220356565. The same ID is shown on the bank transfer, so the payment can be reconciled with the EPA file. |
| payout_date | YYYYMMDD | The date of the payout. Example: 20261125 |
| merchant_settlement_type | String | NET: Riverty fees are deducted from the payout. GROSS: The full amount is transferred to the merchant; fees are not deducted. |
| bank_account | String | The merchant's bank account in IBAN format, used for the payout. Example: NL91ABNA0417164300 |
EPA Transactions
The transaction lines follow directly below the header. Each line corresponds to one transaction. The number of transaction lines is given in number_of_records in the header. Example:
D,RTY1234567,SALE,20261125,9999,EUR,OFS400019761,88001188,ref_231435,ptr_5452432
Transaction records always start with "D" (for Detail). The table below describes the variables in the transaction records and their format.
| Variable Name | Type | Validation |
|---|---|---|
| record_type | String (1) | Constant string "D" for Detail. |
| shop_id | String | The Shop ID. Example: RTY1234567. The Shop ID is provided to the merchant during onboarding. |
| type | String | SALE: captured order REFUND: returned order FEE: service fees charged by Riverty. Fee reversals on refunds and chargebacks are also of type FEE, with a positive amount. HOLDBACK: amount held back by Riverty RELEASE: amount released by Riverty CHARGEBACK: disputes where the merchant is obliged to refund the customer (e.g. fraud or goods not delivered) VATCLA: VAT claim back. If an invoice is irrecoverable in debt collection, it is written off and its VAT is subtracted in the settlement. You will receive a separate document that can be used to recover the VAT from the tax authorities. ADJUSTMENT: other types not covered by any of the types listed above. |
| transaction_date | YYYYMMDD | Date of the transaction event. Example: 20261125 |
| amount | Amount | The transaction amount. Example: 29950 for EUR 299.50 |
| currency | String | ISO 4217, all caps. Example: "EUR" |
| order_no | String | Order number related to the transaction, submitted (mandatory) by the merchant during the authorization call. Example: OFS400019761 |
| transaction_no | String | Invoice number (captures) or credit note number (refunds). If not submitted by the merchant, generated by Riverty. Example: 88001188 |
| transaction_reference | String | For chargebacks, Riverty fills this field with the chargeback ID, on both the CHARGEBACK line and its fee reversal line. Example: D-0000-5499.CB001 For all other transactions: if a value is provided via the Checkout API, it is included in the EPA file. Otherwise, the field is left empty, represented as two consecutive commas. |
| parent_transaction_reference | String | For chargebacks, Riverty fills this field with the dispute ID, on both the CHARGEBACK line and its fee reversal line. Example: D-0000-5499 For all other transactions: if a value is provided via the Checkout API, it is included in the EPA file. Otherwise, the field is left empty; as it is the last field, the line then ends with a comma. |
Naming Structure / Convention
EPA{ShopID}.{payment_reference}.{CreationDate}_{CountryCode}.csv
Example: EPARTY123469676.22260509001.20261111_DE.csv
For consolidated settlements, the file body can contain transactions for more than one Shop ID. In that case, the Shop ID in the file name is the Shop ID assigned at settlement level.
Do you find this page helpful?