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

Field name

What data does this field contain?

status

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

transaction_reference

The unique reference of your transaction.

value_date_utc

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

value_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.

counterpart_name

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

transaction_method

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

transaction_initiator

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

activity

The category assigned to the transaction

comment

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

note

The internal note attached to the transaction.

amount

The amount of the transaction

amount_currency

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

local_amount

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.

local_amount_currency

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

vat_amount

The amount of VAT, in EUR

vat_country

The country of VAT. This is a legacy field that will soon be removed.

attachments

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

Did this answer your question?