Search

How do I export my entries in CSV / XLSX format?

  • Updated
The CSV and Excel (XLSX) formats allow you to export your accounting entries from the Qonto Accounting Hub to your accounting software. These formats are compatible with many software programs, including Sage 100 (via CSV). Depending on your needs, you can choose whether or not to include attachments (PDF) in your export file.
Before generating your file, please refer to the article How can I manually export my accounting entries? to select the correct menu in the Qonto Accounting Hub.
 

How do I choose the correct export format?

In the dropdown list of the export menu, select the format that suits your accounting software and your needs:
  • CSV (.csv): entries file only, in CSV format
  • CSV with documents (.zip): ZIP archive containing the CSV entries file and the associated PDF attachments
  • Excel (.xlsx): entries file only, in Excel format
  • Excel with documents (.zip): ZIP archive containing the Excel entries file and the associated PDF attachments
If your accounting software requires supporting documents along with the entries, prioritize the "with documents" options. Otherwise, the simple format (CSV or Excel) is sufficient.
 

What columns are available in the export file?

The exported file contains the following columns, in this order (these columns may vary depending on the exported journal):
  1. Journal code
  2. Accounting date
  3. General account number
  4. Auxiliary account number (third party)
  5. Document number
  6. Invoice number
  7. Entry description
  8. Debit amount in original currency
  9. Credit amount in original currency
  10. Type: A (analytical) or G (general)
  11. Due date
  12. Payment method (label)
  13. Payment code: VIR / PRE / LCR / CB / CHQ / CSH
  14. General account label
  15. Auxiliary account label
  16. Debit amount in EUR
  17. Credit amount in EUR
  18. Amount in original currency (always positive)
  19. Accounting currency
  20. Currency conversion rate
  21. Attachment file name
  22. Public URL of the attachment
  23. Transaction type (example: supplier_invoice)
  24. Export batch creation date
  25. Entry ACK code (unique QONTO entry identifier)
  26. Auxiliary account if present, otherwise general account