Convert a Qonto export to Excel
Beta This tool is in beta. It is tested on sample files, and details may still change. Review the result before relying on it.
Export your Qonto transactions as OFX and convert them to Excel or CSV for free. Klarbon reads the balance from the file. Reading OFX is in beta.
In short
Turn a bank statement file or a PDF statement into Excel, CSV, CAMT.053, MT940 or OFX. Klarbon reads a PDF statement into a draft; check the result before you use it. CSV and Excel free from bank files, otherwise 1 credit (€1.99).
To turn your Qonto transactions into Excel or CSV, export them from the Transactions section as an OFX file and drop it on Klarbon. Klarbon reads OFX in beta, takes the closing balance from the file and writes Excel or CSV at no charge. Qonto's full data CSV opens in beta too. Compare the result with your Qonto statement before you import it.
How do I export an OFX file from Qonto?
From Qonto's help page (checked on 21 November 2026, source), with an Admin, Manager or Accountant role:
- Open the Transactions section of your Qonto business account.
- Filter the transactions you need, for example by date, or keep them all.
- Export them and select OFX as the file format.
The OFX export holds executed transactions only. You can go back as far as the account's opening. Qonto's monthly statements are PDF. A Manager whose access covers one team exports only that team's transactions, which would make the derived opening balance wrong for the account, so export from an Admin or Accountant role.
What should I know about Qonto's files?
- OFX gives the closing balance. Klarbon reads the balance at the end of the period from the file and works the opening balance back from it, marked as derived on the preview.
- No published OFX layout. Qonto does not describe its OFX file, so Klarbon's test file for Qonto was written from the OFX specification, with French bank identifiers. Klarbon reads OFX 1.x and 2.x.
- The full data CSV, in beta. Klarbon reads Qonto's full data CSV by the columns in Qonto's own field table. It reads settled rows, leaves out the ones still processing and says how many. The file prints no balance, so Klarbon asks for the opening balance.
- Signs in the CSV. Qonto does not say how a debit is signed, so Klarbon reads Total amount (incl. VAT) as printed: a minus is money out. The preview shows each amount with its sign before any download.
- No account in the CSV. The CSV does not name your IBAN, so Klarbon does not offer CAMT.053 or MT940 from it. The OFX file names the account.
How do I convert it with Klarbon?
- Drop the OFX file on the box above.
- In the preview, check the signs, the dates and the balances against your Qonto statement.
- Choose Excel or CSV and download it.
What else should I know?
From either file, Excel and CSV are free; MT940 or CAMT.053 written from the OFX file cost one credit per started 500 transactions. Klarbon is not affiliated with Qonto. Klarbon reads a Qonto PDF statement into a draft, at one credit per started 10 pages for a download; compare it with the original before you import it.
Related
Frequently asked questions
Which export format should I choose at Qonto?
OFX. It states the account's balance, holds only executed transactions and is offered to every Qonto account; MT940 is offered to German and Dutch companies only. The full data CSV opens in beta too, but it prints no balance, so Klarbon asks for the opening balance.
Where does the opening balance come from?
The OFX file gives the account's balance at the end of the period. Klarbon works the opening balance back from it and the transactions, and marks it as derived. That cannot show a missing transaction, so compare the opening balance with your Qonto statement for the day before.
How does Klarbon read the signs in Qonto's CSV?
Qonto's field table names the columns but does not say how a debit is signed, so Klarbon reads Total amount (incl. VAT) as printed: a minus is money out, no sign is money in. In OFX the sign is part of the format. The preview shows every amount with its sign before you download anything.
Sources
- Qonto Help Centre, How can I export my transactions?, checked 21 November 2026 support-fr.qonto.com
- Qonto Help Centre, Where do I find my statements?, checked 21 November 2026 support-fr.qonto.com
- Qonto Help Centre, What do the fields of the full Export CSV format mean?, checked 21 November 2026 support-de.qonto.com
- Financial Data Exchange, OFX Banking Specification v2.3 financialdataexchange.org
Related
- Open any e-invoice. Check it. Convert it.
- Klarbon help centre
- Bank statement tools
- Convert OFX to CSV and Excel
- What is OFX?
- Convert a CAMT.053, MT940 or OFX bank statement to CSV
- Convert a CAMT.053, MT940 or OFX bank statement to Excel
- Why do my statement balances not match?
- Supported bank statement files
- Simple pricing for invoices and bank statements
- What happens to my files?
- E-invoicing in France: the 2026 and 2027 timetable
- Understanding Bank CSV export
- Understanding Excel workbook (XLSX)
- Convert a bank statement PDF to OFX
- Convert a Commerzbank CSV export to Excel