What do the fields of the 'full Export (CSV format)' mean?

  • Updated

Your extended CSV is pretty extensive. Here are the fields you'll find inside, and how they can be useful to you at the time of export.

Field name

What data does this field contain?

Status

The status of your transaction. It can include the values processing or settled.

Transaction ID

The unique reference of your transaction.

Operation date (UTC)

The date and time at which the payment took place, according to the UTC timezone.

Operation date (local)

The date and time at which the payment took place, according to your user's timezone, defined in your settings.

Settlement date (UTC)

The date at which the transaction impacted your account's settled balance, according to the UTC timezone. This field is empty for processing transactions.

Settlement date (local)

The date at which the transaction impacted your account's settled balance, according to your user's timezone, defined in your settings. This field is empty for processing transactions.

Counterparty name

The name of the counterpart. For a card payment, it is the merchant's name.

Payment method

The payment method used to perform the transaction. It can be a card, transfer, subscription_fees, direct_debit or check.

Initiator

The initiator of the transaction. That's the cardholder of the card used for the payment, or the person who initiated or requested the transfer. This is empty for incoming transfers and direct debits.

Category

The category assigned to the transaction.

Reference

The reference of an outgoing or incoming transfer. This field is empty for other transaction methods.

Note

The internal note attached to the transaction.

Total amount (incl. VAT)

The amount of the transaction.

Currency

The currency of the amount. Qonto only offers EUR payment accounts, so this value is always EUR.

Total amount (incl. VAT) (local)

The amount of the transaction in the original currency the payment was made. For a payment in EUR the value is the same as amount.

Currency (local)

The original currency in which the payment was made. (e.g: USD)

Total VAT amount

The amount of VAT, in EUR

Attachment

The names of the files attached to the transaction, so you can easily find them in your attachments export.

Custom_label_1

The name of this field varies depending on the custom label you defined. It is empty unless you specified a label on that transaction.

Custom_label_2

Same thing as custom_label_1

Custom_label_3

Same thing as custom_label_2