Skip to main content

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

Project description

Odoo Community Association

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

File details

Details for the file odoo_addon_account_statement_import_sheet_file-18.0.1.0.1.3-py3-none-any.whl.

File metadata

File hashes

Hashes for odoo_addon_account_statement_import_sheet_file-18.0.1.0.1.3-py3-none-any.whl
Algorithm Hash digest
SHA256 1c5bc331c5898ed2dcd7aca85e1312852a883162b089b23d184f7eb4f9768ad0
MD5 e6b5c2dea0adef48d0ced99578ee8b18
BLAKE2b-256 2529655a5141d1cedb77b14527a34bc2e5c761856ad6add87f70968c528fc7cf

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page