Belgium - Import bank CODA statements

account_coda
REPOSITORY
REPOSITORYodoo/odoo
GIT
GIThttps://github.com/odoo/odoo.git
GIT FOLDER
GIT FOLDERhttps://github.com/odoo/odoo/tree/6.1/account_coda
VERSION
VERSION 2.1
CATEGORY
CATEGORYAccounting & Finance
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSNoviat
MAINTAINERS
MAINTAINERSNoviat
COMMITTERS
COMMITTERSRaphael Collet, Rucha (Open ERP), Stephane Wirtel, Fabien Pinckaers, Antony Lesuisse, Olivier Dony, Vo Minh Thu, Launchpad Translations on behalf of openerp, Quentin (OpenERP), vro, niv-openerp, Xavier Morel, Carlos Vásquez, Els Van Vossel, Israel Fermin Montilla, Rifakat Haradwala (Open ERP), Hardik Ansodariy (OpenERP), rch-openerp
WEBSITE
WEBSITE
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-05 23:41:35
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - account_voucher
    - account
    - base_setup
    - base
    - product
    - process
    - decimal_precision
    - analytic
    - board
    - edi
    - email_template
    - mail
    - base_tools
    - base_iban
    - l10n_be_invoice_bba
    - account_bank_statement_extensions
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
    Module to import CODA bank statements.

    Supported are CODA flat files in V2 format from Belgian bank accounts.
    - CODA v1 support.
    - CODA v2.2 support.
    - Foreign Currency support.
    - Support for all data record types (0, 1, 2, 3, 4, 8, 9).
    - Parsing & logging of all Transaction Codes and Structured Format Communications.
    - Automatic Financial Journal assignment via CODA configuration parameters.
    - Support for multiple Journals per Bank Account Number.
    - Support for multiple statements from different bank accounts in a single CODA file.
    - Support for 'parsing only' CODA Bank Accounts (defined as type='info' in the CODA Bank Account configuration records).
    - Multi-language CODA parsing, parsing configuration data provided for EN, NL, FR.

    The machine readable CODA Files are parsed and stored in human readable format in CODA Bank Statements.
    Also Bank Statements are generated containing a subset of the CODA information (only those transaction lines
    that are required for the creation of the Financial Accounting records).
    The CODA Bank Statement is a 'read-only' object, hence remaining a reliable representation of the original CODA file
    whereas the Bank Statement will get modified as required by accounting business processes.

    CODA Bank Accounts configured as type 'Info' will only generate CODA Bank Statements.

    A removal of one object in the CODA processing results in the removal of the associated objects.
    The removal of a CODA File containing multiple Bank Statements will also remove those associated
    statements.

    The following reconciliation logic has been implemented in the CODA processing:
    1) The Company's Bank Account Number of the CODA statement is compared against the Bank Account Number field
       of the Company's CODA Bank Account configuration records (whereby bank accounts defined in type='info' configuration records are ignored).
       If this is the case an 'internal transfer' transaction is generated using the 'Internal Transfer Account' field of the CODA File Import wizard.
    2) As a second step the 'Structured Communication' field of the CODA transaction line is matched against
       the reference field of in- and outgoing invoices (supported : Belgian Structured Communication Type).
    3) When the previous step doesn't find a match, the transaction counterparty is located via the
       Bank Account Number configured on the OpenERP Customer and Supplier records.
    4) In case the previous steps are not successful, the transaction is generated by using the 'Default Account
       for Unrecognized Movement' field of the CODA File Import wizard in order to allow further manual processing.

    In stead of a manual adjustment of the generated Bank Statements, you can also re-import the CODA
    after updating the OpenERP database with the information that was missing to allow automatic reconciliation.

    Remark on CODA V1 support:
    In some cases a transaction code, transaction category or structured communication code has been given a new or clearer description in CODA V2.
    The description provided by the CODA configuration tables is based upon the CODA V2.2 specifications.
    If required, you can manually adjust the descriptions via the CODA configuration menu.

    

Code Analysis

Views touched (22)
XML IDNameModelTypeStatus
account_coda_import_result_view Import CODA File account.coda.import form New
account_coda_import_view Import CODA File account.coda.import form New
view_account_coda_comm_type_form account.coda.comm.type.form account.coda.comm.type form New
view_account_coda_comm_type_tree account.coda.comm.type.tree account.coda.comm.type tree New
view_account_coda_filter account.coda.search account.coda search New
view_account_coda_form account.coda.form account.coda form New
view_account_coda_trans_category_form account.coda.trans.category.form account.coda.trans.category form New
view_account_coda_trans_category_tree account.coda.trans.category.tree account.coda.trans.category tree New
view_account_coda_trans_code_form account.coda.trans.code.form account.coda.trans.code form New
view_account_coda_trans_code_tree account.coda.trans.code.tree account.coda.trans.code tree New
view_account_coda_trans_type_form account.coda.trans.type.form account.coda.trans.type form New
view_account_coda_trans_type_tree account.coda.trans.type.tree account.coda.trans.type tree New
view_account_coda_tree account.coda.tree account.coda tree New
view_coda_bank_account_form coda.bank.account.form coda.bank.account form New
view_coda_bank_account_list coda.bank.account.list coda.bank.account tree New
view_coda_bank_account_search coda.bank.account.search coda.bank.account form New
view_coda_bank_statement_form coda.bank.statement.form coda.bank.statement form New
view_coda_bank_statement_line_filter coda.bank.statement.line.filter coda.bank.statement.line search New
view_coda_bank_statement_line_form coda.bank.statement.line.form coda.bank.statement.line form New
view_coda_bank_statement_line_list coda.bank.statement.line.list coda.bank.statement.line tree New
view_coda_bank_statement_list coda.bank.statement.list coda.bank.statement tree New
view_coda_bank_statement_search coda.bank.statement.search coda.bank.statement search New
Models touched (0)

No models found for this module.