Bank Statement TXT/CSV/XLSX Import

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

Technical Name:
account_statement_import_sheet_file
License:
Author:
ForgeFlow, CorporateHub
https://odoo-community.org/web/image/product.template/715300/image_1920?unique=2fb39cd
  • Odoo Version

Terms and Conditions 

Bank Statement TXT/CSV/XLSX Import

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

This module allows you to import 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 to smash 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.

This is a preview of the recently viewed products by the user.
Once the user has seen at least one product this snippet will be visible.

Recently viewed Products