Skip to content

CSV

This documentation describes the structure and logic behind the CSV exports generated.

Export options

There are currently two locations where you can export payments in CSV format from:

  • Statements: This will include all payments, refunds and chargebacks that are included in the statement.
    • This is the recommended option.
  • Payments page: On the payments page you can select individual payments, or a date range and download all payments in that range.
    • This is useful for a quick overview of the payments, but there is a limit on the number of payments that can be exported.

Report structure

The following options are available for the CSV export:

  • Change which columns are included in the export.
  • Change the column name.
  • An example payment is included, so you are able to see what the data will look like.

Base export structure

Column Nr Name Description
1 PaymentID Unique identifier for the payment.
2 OrderTime Timestamp when the order was placed.
3 Amount Payment amount.
4 Currency Currency of the payment.
5 Country Country code of the payment origin.
6 OrderID Unique identifier for the order.
7 Reference Reference for the payment.
8 Description Description of the payment.
9 Checkout Reference Reference for the checkout.
10 Checkout Description Description for the checkout.
11 LastStatusRequest Timestamp of the last status request.
12 LastPaymentStatus Current status of the payment (e.g., OK, OPEN, ERR).
13 LastPaymentStatusCode Code representing the payment status.(e.g., COMPLETED, Settled S123456)
14 ProviderTransactionID Identifier for the transaction from the payment provider.
15 PaymentTime Timestamp when the payment was completed.
16 CustomerAccountNumber Account number of the customer (if available).
17 CustomerName Name of the customer (if available).
18 MerchantDescription Name of the merchant the order was made too.
19 MerchantID Unique identifier for the merchant.
20 PaymentMethodDescription Description of the payment method used (e.g., iDEAL, Credit Card).
21 PaymentMethodCode Code representing the payment method (e.g., IDEAL, CREDITCARD).
22 Issuer Issuing bank or institution for the payment.