If you have an Account Holder, Admin, Manager or Accountant role, the 'History' section allows you to export your transactions (or those of your team if you are a Manager).
This can be very helpful when you need to analyse your financial data in an external spreadsheet or through a third-party analytical software in preparation for your accounting.
You'll also find in History that you can easily filter transactions by payment method, a range of date, amount, custom labels, status, VAT, etc.
When exporting your transactions, you can choose to download all your transactions or only a filtered view. Additionally, you can export the corresponding attachments as well.
👆 Good to know:
These actions are not available for users with Employee role.
If you have a Manager role, you can export transactions for your team only.
Each receipt has an attachment number that does not necessarily correspond to the number of the related transaction.
For example, receipts n°1, n°2, and n°3 can be attached to transaction n°1.
You can also select the type of separator you'd like to use in the export file (only for CSF format).
Exporting your data
To finalize your 'export', just select a file format corresponding to your needs. There are three types of formats available :
Full export in CSV format (compatible with Excel): include all information related to the transaction
Basic accounting data in CSV format (compatible with Excel): only includes date, description and amount. This format is commonly used in accounting software and SaaS solutions. (Compatible with Quickbooks)
Export in XLS format: this file includes date, amount and VAT amount. These information are commonly used by accounting softwares.
Basic accounting data in QIF format: this format is commonly used by accounting solutions such as Xero, Cegid or Sage.
Basic accounting export in OFX format: this format is used by accounting tools such as Quadratus, Isacompta, Xero or Cador. Do note: you will need to set up Qonto as a bank account within those tools prior to importing the OFX file, or the import could fail.
For exports in QIF and OFX format, if you have several sub-accounts, it is necessary to select the relevant account.
Also, there is no time limit on how far you can go back in your transaction history when exporting your transactions from your Qonto account. Please note that you can download up to 10,000 transactions.
Tip: instead of manually exporting and importing your transaction data, you can try one of our app integrations which will keep your information synced between Qonto and your preferred third-party tool. The list of available integrations can be found here.
💡If you have set up Strong Customer Authentication on your account, you will receive a confirmation request on your associated phone.