Automatic bills/invcoices/receipts/payments from bank statement

by
Odoo

20.20

v 17.0 Third Party 1
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Lines of code 536
Technical Name bank_auto_create_accounting_transactions
LicenseOPL-1
Websitehttps://www.partnerguesthouse.com
Versions 17.0 13.0 16.0 15.0 14.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Lines of code 536
Technical Name bank_auto_create_accounting_transactions
LicenseOPL-1
Websitehttps://www.partnerguesthouse.com
Versions 17.0 13.0 16.0 15.0 14.0

Auto-Create Bills / Invoices / Payments from Bank Statement

Automate the creation of accounting journal entries such as invoices, bills, and payments from bank statement lines. With user-defined flexible mapping rules, the module ensures accurate and efficient generation of vendor bills, customer invoices and income/expense payments matching bank statement lines. This simplifies the accounting process, reduces the risk of errors, and saves time for the user. Our module is designed to integrate seamlessly with Odoo's accounting system, providing a streamlined solution for businesses looking to optimize and automate their accounting workflow.


Create Flexible Mapping Rules

  • Separate rules for income and outcome bank statement lines
  • Match bank statement lines using filter domain with domain creation visual wizard
  • Set income/expense journal
  • Set customer/vendor
  • Set income move type to auto-create: Customer Invoice, Sales Receipt or Vendor Credit Note
  • Set expense move type to auto-create: Vendor Bill, Purchase Receipt or Customer Credit Note
  • Set product/service to use in journal entries
  • Set analytic account and tags
  • Set income/expense account if needed to override the default ones

Automatic Actions

  • Choose one or all of the following actions in each mapping rule
  • Auto-create journal entry set in mapping rule (Bill, Invoice, Receipt, Credit Note etc.)
  • Auto-post created journal entry
  • Auto-create income/outcome payment
  • Auto-post created payment and apply to created journal entry (if it was created)

Bank Statement Views

  • Button "Auto create transactions" to launch the matching and auto-create process
  • Button "Reset auto created links" if you need to re-start the matching for previously matched statement lines
  • Link/button to see all auto-created journal entries directly from bank statement
  • Link/button to see all auto-created payments

Other Features

  • Invoice / Bill - direct link to the bank statement which it was auto-created from
  • Payment - link to the bank statement and mapping rule which was applied

Documentation and screenshots

Creating mapping rules

  • Install "Automatic bills/invcoices/receipts/payments from bank statement" module
  • Go to Invoicing/Accounting module => Configuration menu => Accounting submenu => Bank Statement Line Mapping Rules
  • Click Create to add new rule


Processing bank statement

  • Open bank statement
  • Click on "Auto create transactions"
  • This will launch the process of mapping and creating transactions (journal entries and payments) corresponding to mapping rules
  • If you need to re-start the process - click on "Reset auto created links" and then click on "Auto create transactions" again

Any Questions?


Please contact us for any questions, support or customization/enhancement requests of this module.

Email us at

odoo@partnerguesthouse.com

Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.