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 |