- All fields of the CSV are enclosed in double quotes
". - Fields are separated by a semicolon
;. - Line breaks are Windows-style
CR/LF. - A line break is also included on the last line.
Content template A - suited for platform partners
| Data Point | Description / Comment |
|---|---|
| REPORT_DATE required | Date of settlement report generation. |
| PAYMENT_DATE required | Date of payout. |
| PAYMENT_MONTH required | Month of payout. |
| AMOUNT required | Amount of claim, deducted refund amount, applicable Ratepay fee or Ratepay chargeback. |
| CURRENCY required | Currency of the amount as per ISO 4217. |
| RATEPAY_PAYMENT_REFERENCE required | Ratepay payment reference as shown in buyer communication and returned with accepted authorization request. |
| RATEPAY_PARTNER_INVOICE_ID | Identifier of the monthly invoice Ratepay provides to the partner. |
| RATEPAY_PAYOUT_ID required | Payment reference, as included in the bank transfer reference of the payout. |
| RECORD_DESCRIPTION required | Description of the report entry. |
| RECORD_TYPE required | Identifier of the report entry. |
| AUTHORIZATION_REQUEST_DATE required | Date of the initial authorization request. |
| OPERATION_DATE required | Date of respective operation that lead to this report entry Payment API. |
| RATEPAY_TRANSACTION_ID required | Ratepay transaction identifier as per response to an authorization request. |
| BUYER_TYPE | Buyer type identifier (B2B or B2C). |
| PAYMENT_METHOD required | The respective Ratepay payment method used for the transaction. |
| PARTNER_TRANSACTION_ID required | Partner transaction identifier as per authorization request. |
| PARTNER_SHOP_ID | The shop identifier submitted by the partner in the authorization request. |
| RATEPAY_RESOURCE_TYPE | Describes the Ratepay API resource where additional information about the settlement entry can be requested using the RATEPAY_RESOURCE_ID. |
| RATEPAY_RESOURCE_ID | The key of the originating resource mentioned in RATEPAY_RESOURCE_TYPE. |
| PARTNER_OPERATION_ID | Identifier of the operation as transmitted by the partner in the request Payment API. Will be empty if not transmitted by the partner or if the operation was initiated by Ratepay (e.g. dispute process). |
| Field | Allowed values |
|---|---|
| RECORD_TYPE | ACCOUNTS_RECEIVABLE DISAGIO TRANSACTION_FEE MISCELLANEOUS CHARGEBACK |
| RECORD_DESCRIPTION | Factoring purchase price Return purchase price Cancellation purchase price Goodwill buyer refund Disagio Transaction fee VAT 19% factoring Chargeback |
| BUYER_TYPE | B2C B2B |
| PAYMENT_METHOD | Open Invoice Bank Transfer Open Invoice Direct Debit Installment Bank Transfer Installment Direct Debit Prepayment |
| RATEPAY_RESOURCE_TYPE | ratepay_capture_id ratepay_refund_id ratepay_dispute_id ratepay_cancellation_id |