Bank Statement TXT/CSV/XLSX Import
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:
- Open Invoicing > Configuration > Accounting > Statement Sheet Mappings
- Create mapping(s) according to your online banking software statement format
Usage
To use this module, you need to:
- Get statement in TXT/CSV or XLSX from your online banking software
- 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
- Alexis de Lattre <[email protected]>
- Sebastien BEAU <[email protected]>
- Tecnativa (https://www.tecnativa.com)
- Vicent Cubells <[email protected]>
- Victor M.M. Torres <[email protected]>
- ForgeFlow (https://www.forgeflow.com)
- Jordi Ballester Alomar <[email protected]>
- Miquel Raïch Regué <[email protected]>
- CorporateHub
- Alexey Pelykh <[email protected]>
Maintainers
This module is maintained by the OCA.
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:
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.
Python dependencies
| Package | Version | Secured | ||
|---|---|---|---|---|
| xlrd | 1.2.0 | |||
| chardet | 3.0.4 | |||
| openupgradelib | 3.6.1 |
Available languages
| Language | % translated | ||
|---|---|---|---|
| Spanish / Español |
100%
|
||
| Spanish (AR) / Español (AR) |
73%
|
||
| Italian / Italiano |
73%
|
||
| Dutch / Nederlands |
43%
|
||
| Chinese (Simplified) / 简体中文 |
38%
|
||
| Portuguese / Português |
0%
|