Bank statement base import

account_statement_base_import
REPOSITORY
REPOSITORYOCA/account-reconcile
GIT
GIThttps://github.com/OCA/account-reconcile.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/account-reconcile/tree/8.0/account_statement_base_import
VERSION
VERSION 1.2
CATEGORY
CATEGORYFinance
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Camptocamp
MAINTAINERS
MAINTAINERSCamptocamp
COMMITTERS
COMMITTERSStéphane Bidoul, Pedro M. Baeza, Stéphane Bidoul (ACSONE)
WEBSITE
WEBSITEhttp://www.camptocamp.com
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:11:26
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-reconcile:
    - account_statement_ext
    - account_statement_base_completion
odoo/odoo:
    - account
    - base_setup
    - base
    - web_kanban
    - web
    - product
    - decimal_precision
    - mail
    - report
    - analytic
    - board
    - edi
    - email_template
    - report_webkit
    - account_voucher
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
 This module brings basic methods and fields on bank statement to deal with
 the importation of different bank and offices. A generic abstract method is
 defined and an example that gives you a basic way of importing bank statement
 through a standard file is provided.

 This module improves the bank statement and allows you to import your bank
 transactions with a standard .csv or .xls file (you'll find it in the 'data'
 folder). It respects the profile (provided by the accouhnt_statement_ext
 module) to pass the entries. That means, you'll have to choose a file format
 for each profile.
 In order to achieve this it uses the `xlrd` Python module which you will need
 to install separately in your environment.

 This module can handle a commission taken by the payment office and has the
 following format:

 * __ref__: the SO number, INV number or any matching ref found. It'll be used
   as reference in the generated entries and will be useful for reconciliation
   process
 * __date__: date of the payment
 * __amount__: amount paid in the currency of the journal used in the
   importation profile
 * __label__: the comunication given by the payment office, used as
   communication in the generated entries.

 The goal is here to populate the statement lines of a bank statement with the
 infos that the bank or office give you. Fell free to inherit from this module
 to add your own format. Then, if you need to complete data from there, add
 your own account_statement_*_completion module and implement the needed rules.

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
bank_statement_view_form account_bank_statement.bank_statement.view_form account.bank.statement xpath Inherits account_statement_base_completion.bank_statement_view_form
statement_importer_view credit.statement.import.config.view credit.statement.import form New
statement_importer_view_form account.statement.profile.view account.statement.profile field Inherits account_statement_ext.statement_importer_view_form
Models touched (2)

New fields (0)

No new fields.

Public methods (5)
  • multi_statement_import(self, cr, uid, ids, profile_id, file_stream, ftype='csv', context=None)
    Create multiple bank statements from values given by the parser for the given profile. :param int/long profile_id: ID of the profile used to import the file :param filebuffer file_stream: binary of the providen file :param char: ftype represent the file exstension (csv by default) :return: list: list of ids of the created account.bank.statemênt
  • prepare_statement_lines_vals(self, cr, uid, parser_vals, statement_id, context)
    Hook to build the values of a line from the parser returned values. At least it fullfill the statement_id. Overide it to add your own completion if needed. :param dict of vals from parser for account.bank.statement.line (called by parser.get_st_line_vals) :param int/long statement_id: ID of the concerned account.bank.statement :return: dict of vals that will be passed to create method of statement line.
  • prepare_statement_vals(self, cr, uid, profile_id, result_row_list, parser, context=None)
    Hook to build the values of the statement from the parser and the profile.
  • prepare_statetement_lines_vals(self, *args, **kwargs)
  • write_logs_after_import(self, cr, uid, ids, statement_id, num_lines, context)
    Write the log in the logger :param int/long statement_id: ID of the concerned account.bank.statement :param int/long num_lines: Number of line that have been parsed :return: True

New fields (0)

No new fields.

Public methods (3)
  • default_get(self, cr, uid, fields, context=None)
  • import_statement(self, cr, uid, req_id, context=None)
    This Function import credit card agency statement
  • onchange_profile_id(self, cr, uid, ids, profile_id, context=None)
REPOSITORY
REPOSITORYOCA/account-reconcile
GIT
GIThttps://github.com/OCA/account-reconcile.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/account-reconcile/tree/7.0/account_statement_base_import
VERSION
VERSION 1.2
CATEGORY
CATEGORYFinance
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Camptocamp
MAINTAINERS
MAINTAINERSCamptocamp
COMMITTERS
COMMITTERSYannick Vaucher, Guewen Baconnier, Alexandre Fayolle, Matthieu Dietrich, Joel Grand-Guillaume, Leonardo Pistone, Virgil Dupras, Pedro M. Baeza, Laurent Mignon (Acsone), unknown, Guewen Baconnier @ Camptocamp, florian-dacosta, Sebastien Beau, Launchpad Translations on behalf of banking-addons-team, Rudolf Schnapka, Florian da Costa, ecino
WEBSITE
WEBSITEhttp://www.camptocamp.com
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:07:16
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-reconcile:
    - account_statement_ext
    - account_statement_base_completion
odoo/odoo:
    - account
    - base_setup
    - base
    - web_kanban
    - web
    - product
    - process
    - decimal_precision
    - mail
    - analytic
    - board
    - edi
    - email_template
    - report_webkit
    - account_voucher
    - account_report_company
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
 This module brings basic methods and fields on bank statement to deal with
 the importation of different bank and offices. A generic abstract method is
 defined and an example that gives you a basic way of importing bank statement
 through a standard file is provided.

 This module improves the bank statement and allows you to import your bank
 transactions with a standard .csv or .xls file (you'll find it in the 'data'
 folder). It respects the profile (provided by the accouhnt_statement_ext
 module) to pass the entries. That means, you'll have to choose a file format
 for each profile.
 In order to achieve this it uses the `xlrd` Python module which you will need
 to install separately in your environment.

 This module can handle a commission taken by the payment office and has the
 following format:

 * __ref__: the SO number, INV number or any matching ref found. It'll be used
   as reference in the generated entries and will be useful for reconciliation
   process
 * __date__: date of the payment
 * __amount__: amount paid in the currency of the journal used in the
   importation profile
 * __label__: the comunication given by the payment office, used as
   communication in the generated entries.

 The goal is here to populate the statement lines of a bank statement with the
 infos that the bank or office give you. Fell free to inherit from this module
 to add your own format. Then, if you need to complete data from there, add
 your own account_statement_*_completion module and implement the needed rules.

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
bank_statement_view_form account_bank_statement.bank_statement.view_form account.bank.statement xpath Inherits account_statement_base_completion.bank_statement_view_form
statement_importer_view credit.statement.import.config.view credit.statement.import form New
statement_importer_view_form account.statement.profile.view account.statement.profile field Inherits account_statement_ext.statement_importer_view_form
Models touched (2)

New fields (0)

No new fields.

Public methods (5)
  • multi_statement_import(self, cr, uid, ids, profile_id, file_stream, ftype='csv', context=None)
    Create multiple bank statements from values given by the parser for the given profile. :param int/long profile_id: ID of the profile used to import the file :param filebuffer file_stream: binary of the providen file :param char: ftype represent the file exstension (csv by default) :return: list: list of ids of the created account.bank.statemênt
  • prepare_statement_lines_vals(self, cr, uid, parser_vals, statement_id, context)
    Hook to build the values of a line from the parser returned values. At least it fullfill the statement_id. Overide it to add your own completion if needed. :param dict of vals from parser for account.bank.statement.line (called by parser.get_st_line_vals) :param int/long statement_id: ID of the concerned account.bank.statement :return: dict of vals that will be passed to create method of statement line.
  • prepare_statement_vals(self, cr, uid, profile_id, result_row_list, parser, context=None)
    Hook to build the values of the statement from the parser and the profile.
  • prepare_statetement_lines_vals(self, *args, **kwargs)
  • write_logs_after_import(self, cr, uid, ids, statement_id, num_lines, context)
    Write the log in the logger :param int/long statement_id: ID of the concerned account.bank.statement :param int/long num_lines: Number of line that have been parsed :return: True

New fields (0)

No new fields.

Public methods (3)
  • default_get(self, cr, uid, fields, context=None)
  • import_statement(self, cr, uid, req_id, context=None)
    This Function import credit card agency statement
  • onchange_profile_id(self, cr, uid, ids, profile_id, context=None)
REPOSITORY
REPOSITORYOCA/account-reconcile
GIT
GIThttps://github.com/OCA/account-reconcile.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/account-reconcile/tree/6.1/account_statement_base_import
VERSION
VERSION 1.0
CATEGORY
CATEGORYFinance
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Camptocamp
MAINTAINERS
MAINTAINERSCamptocamp
COMMITTERS
COMMITTERSBenoit Guillot, Alexandre Fayolle, Joël Grand-Guillaume, Pedro M. Baeza, unknown, Alexandre Fayolle @ camptocamp, Guewen Baconnier @ Camptocamp, Launchpad Translations on behalf of banking-addons-team
WEBSITE
WEBSITEhttp://www.camptocamp.com
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:04:07
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-reconcile:
    - account_statement_ext
    - account_statement_base_completion
odoo/odoo:
    - account
    - base_setup
    - base
    - product
    - process
    - decimal_precision
    - analytic
    - board
    - edi
    - email_template
    - mail
    - base_tools
    - report_webkit
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
 This module brings basic methods and fields on bank statement to deal with
 the importation of different bank and offices. A generic abstract method is defined and an
 example that gives you a basic way of importing bank statement through a standard file is provided.

 This module improves the bank statement and allows you to import your bank transactions with
 a standard .csv or .xls file (you'll find it in the 'data' folder). It respects the profile
 (provided by the accouhnt_statement_ext module) to pass the entries. That means,
 you'll have to choose a file format for each profile.

 This module can handle a commission taken by the payment office and has the following format:

 * ref :               the SO number, INV number or any matching ref found. It'll be used as reference
                       in the generated entries and will be useful for reconciliation process
 * date :              date of the payment
 * amount :            amount paid in the currency of the journal used in the importation profile
 * commission_amount : amount of the comission for each line
 * label :             the comunication given by the payment office, used as communication in the
                       generated entries.

 The goal is here to populate the statement lines of a bank statement with the infos that the
 bank or office give you. Fell free to inherit from this module to add your own format.Then,
 if you need to complete data from there, add your own account_statement_*_completion module and implement
 the needed rules.

Code Analysis

Views touched (3)
XML IDNameModelTypeStatus
bank_statement_view_form account_bank_statement.bank_statement.view_form account.bank.statement data Inherits account_statement_base_completion.bank_statement_view_form
statement_importer_view credit.statement.import.config.view credit.statement.import form New
statement_importer_view_form account.statement.profile.view account.statement.profile field Inherits account_statement_ext.statement_importer_view_form
Models touched (0)

No models found for this module.