Your request was successfully submitted.
Contact us

What do the fields of the 'extended CSV' export files mean?

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 cardtransfersubscription_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

You still have a question?

If you cannot find answer to your question in our FAQ, you can always contact us. We will answer to you shortly!