Skip to content

Import bank statements into Odoo

Odoo imports CAMT.053, CSV, XLSX, OFX, QIF and CODA statements. Turn MT940 or another bank file into CAMT.053, or into a free Excel or CSV file to map.

No file to hand? Try a sample statement

Odoo imports bank statements from CAMT.053, CSV, Excel (XLSX), OFX and QIF files, and from CODA for Belgium, according to its documentation for Odoo 19. MT940 is not on the list. Klarbon turns an MT940 or another supported statement into CAMT.053 after checking the balances, or into an Excel or CSV file to map, which is free. Test one short statement before importing a year.

On this page 10

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
PDF 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?

  1. Drop the statement file on this page, or use convert MT940 to CAMT.053.
  2. 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.
  3. Choose Odoo as your accounting software, and Klarbon suggests CAMT.053. Choose Excel or CSV instead if you prefer to map the columns yourself.
  4. Download the file.

How do I import it into Odoo?

According to the Odoo 19 documentation:

  1. 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.
  2. Select the file and upload it.
  3. 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

Updated 21 November 2026

Klarbon, https://klarbon.app/odoo-bank-statement-import