Relevés bancaires

L’intégration de vos extraits bancaires dans la Comptabilité Odoo vous permet de suivre les mouvements de trésorerie et de les rapprocher des écritures enregistrées dans la comptabilité.

We recommend you use bank synchronization for more efficiency. Please read the related documentation: Bank Synchronization: Automatic Import.

However, if you don’t want to use bank synchronization or if your bank is not a supported institution, you still have other options:

  1. Importez les relevés bancaires fournis par votre banque

  2. Enregistrez vos relevés bancaires manuellement

Importation de relevés bancaires

Odoo accepte de nombreux formats de fichiers pour importer des relevés bancaires :

  • Format SEPA recommandé (CAMT.053)

  • Valeurs séparées par des virgules (.CSV)

  • Open Financial Exchange (.OFX)

  • Quicken Interchange Format (.QIF)

  • Belgium: Coded Statement of Account (.CODA)

To import them, go to Accounting ‣ Overview ‣ Bank, click on Import Statements, or on the three dots, and then on Import Statement.

Import a bank statement file in Odoo Accounting

Next, select the file you want to import and click on Import.

Odoo opens an import widget to help you set the Formatting Options and map the different columns you want to import.

Register bank statements manually in Odoo Accounting

Note

Quicken Interchange Format (.QIF) is an older file format that is no longer supported since 2005. If possible, prefer OFX files over QIF.

Enregistrez vos relevés bancaires manuellement

Si nécessaire, vous pouvez également enregistrer vos relevés bancaires manuellement.

To do so, go to Accounting ‣ Overview ‣ Bank, click on Create Statements, or on the three dots, and then on New Statement.

Add a new line for each transaction written on the original bank statement.

To ease the reconciliation process, make sure to fill out the Partner field. You can also write the payments’ references in the Label field.

Register bank statements manually in Odoo Accounting

Note

The Ending Balance and the Computed Balance should have the same amount. If it is not the case, make sure that there is no mistake in the transactions’ amounts.