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. |
operation_date_utc | The date and time at which the payment took placet, 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. |
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 |