Account Bank Statement Import TXT XLSX

Import TXT/CSV or XLSX files as Bank Statements in Odoo

Technical Name:
account_bank_statement_import_txt_xlsx
License:
Author:
ForgeFlow, CorporateHub
  • Odoo Version

Account Bank Statement Import TXT/CSV/XLSX

Beta License: AGPL-3 OCA/bank-statement-import Translate me on Weblate Try me on Runbot

This module allows you to import the any TXT/CSV or XLSX file in Odoo as bank statements.

Table of contents

Configuration

To create TXT/CSV/XLSX statement sheet columns mapping:

  1. Open Invoicing > Configuration > Accounting > Statement Sheet Mappings
  2. Create mapping(s) according to your online banking software statement format

Usage

To use this module, you need to:

  1. Get statement in TXT/CSV or XLSX from your online banking software
  2. Go to Odoo and and import the statement file, selecting corresponding format

Changelog

12.0.2.0.0

  • [BREAKING] New mapping, please review mappings after upgrade.
  • [BREAKING] Different bank accounts have to be used per each currency.
  • [ADD] Support for both Statement and Activity reports.
  • [ADD] Separate fee and currency exchange parsing.

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • ForgeFlow
  • CorporateHub

Contributors

Maintainers

This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainer:

alexey-pelykh

This module is part of the OCA/bank-statement-import project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.