Skip to Main Content
Riverty Docs
riverty logo Docs

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.

Download sample file

Do you find this page helpful?