Which files does Odoo import?
According to the Odoo documentation (Odoo 19.0), checked on 21 November 2026:
| File | Odoo 19 | Odoo 18 | Mapping |
|---|---|---|---|
| CAMT.053 | yes | yes | automatic |
| CSV | yes | yes | map the columns, then test |
| Excel (XLSX) | yes | not listed | map the columns, then test |
| OFX | yes | yes | automatic |
| QIF | yes | yes | automatic |
| CODA (Belgium) | yes | yes | automatic |
| MT940 | not listed | not listed | |
| not listed | not listed | a PDF can be attached to a statement, which imports nothing |
The documentation describes Odoo Accounting. If the bank journal has no Import file option in your database, ask whoever runs your Odoo which import options it includes.
Which file should I make with Klarbon?
| You have | Make | Cost on the site |
|---|---|---|
| MT940 | CAMT.053 | one credit per started 500 transactions |
| CAMT.053, OFX or CODA that Odoo already reads | nothing: import it directly | |
| A file Odoo does not list, such as Norma 43 or CFONB 120 | CAMT.053, or Excel to map | Excel and CSV free |
| Any supported file, to check it first | convert a bank statement to Excel or convert a bank statement to CSV | free |
CAMT.053 needs no column mapping and carries the opening and closing balances. Klarbon writes camt.053.001.02. Reading statement files is in beta. Klarbon reads a PDF statement or scan too: you see every row before paying, a download from it costs one credit per started 10 pages, and what Klarbon reads from a PDF is a draft to compare with the original.
How do I prepare the file?
- Drop the statement file on this page, or use convert MT940 to CAMT.053.
- Check the preview: period, number of transactions and the balance check. A statement whose opening balance plus transactions does not give the closing balance cannot be downloaded. See the balance check.
- Choose Odoo as your accounting software, and Klarbon suggests CAMT.053. Choose Excel or CSV instead if you prefer to map the columns yourself.
- Download the file.
How do I import it into Odoo?
According to the Odoo 19 documentation:
- Go to the Accounting Dashboard, click the ellipsis icon on the Bank journal and choose Import file. You can also drop the file on the bank journal.
- Select the file and upload it.
- For CSV or XLSX, set the formatting options and map the columns to Odoo's fields, click Test, then Import. Klarbon's CSV uses a semicolon as separator, a decimal comma and dates as DD/MM/YYYY.
Before the first import, create an opening transaction with the account balance on the start date, as the documentation advises, so the ending balances in Odoo match the bank's.
How do I avoid duplicates?
Do not import a period that bank synchronisation has already brought in. Odoo can list potential duplicates from the bank journal's Actions menu, Find Duplicate Transactions, by amount, date and account number. Klarbon has not tested an import into every Odoo version and edition, so compare the number of transactions and the balance after your first import.
Does Klarbon work with Odoo?
No. Klarbon has no integration or partnership with Odoo. It makes a file; you import it. Klarbon creates no archive of the statement or its transactions. A PDF is read for your request only, and the reading may take place outside the EU. See what happens to my files.
Next
Frequently asked questions
Which bank statement files does Odoo import?
Odoo 19's documentation lists CAMT.053, CSV, Excel (XLSX), OFX and QIF, and CODA for Belgium. Odoo 18's lists the same without XLSX. MT940 is not on either list.
How do I import an MT940 file into Odoo?
Odoo's documentation does not list MT940. Turn the MT940 file into CAMT.053 with Klarbon after the balance check, then import the CAMT.053 file on the bank journal. Test one short statement first.
Do I have to map columns?
Only for CSV and XLSX. Odoo asks for the formatting options and the column mapping, then lets you run a test before the import. CAMT.053, OFX, QIF and CODA are mapped automatically.
Why does the balance in Odoo differ from my bank's?
Odoo asks for an opening transaction with the account balance on the date you start importing. Without it, the ending balances in Odoo do not match the bank's.
Is Klarbon an Odoo app or partner?
No. Klarbon has no integration or partnership with Odoo. It makes a file; you import it on the bank journal.
Sources
Related
- Open any e-invoice. Check it. Convert it.
- Klarbon help centre
- Convert a CAMT.053, MT940 or OFX bank statement to Excel
- Convert a CAMT.053, MT940 or OFX bank statement to CSV
- Convert a bank statement PDF to CAMT.053
- Convert a bank statement PDF to MT940
- Why do my statement balances not match?
- Import bank statements into DATEV
- Import bank statements into Lexware Office
- Import bank statements into sevdesk
- Import bank statements into Moneybird
- Import bank statements into e-Boekhouden.nl