Account Bank Statement Line Reconciliation

OCA Financial Reports

Technical Name:
account_bank_statement_line_reconciliation
Version:
10.0
License:
Author:
Camptocamp
https://odoo-community.org/web/image/product.template/4681/image_1920?unique=604a871
  • Odoo Version

Terms and Conditions 

Account Bank Statement Line Reconciliation

The wizard provides the ability to specify bank statement line when it needed. The only users from security group "Settings" can use it.

Usage

This module is for you if you work with Odoo enterprise and you messed up the bank reconcile report.

The bank reconciliation report is accessible from the hyperlink 'Difference' which appears on bank journals cards when the GL balance differs from the bank statement balance.

There are only 2 situation handled from field filter (from bank reconcile view) but there are more in real life:

1 - Blue lines appear if account_move_lines have these values:

statement_id = false
AND payment_id = true
AND account_id = current bank

-> This means that if you post a payment journal entry manually (meaning that you do not use the register payment button) the payment_id will not be populated then the payment_id will not be populated. When this happens, your entry won't match: you are stuck and you need this module to prevent this situation.

Same issue in case of migration of payment entries with no payment_id

2 - If 1st request is not applicable then Odoo will look up for account_move_lines with:

reconcile_id = false
account_id = flagged as 'Allow reconciliation" = true
excluding the line in the move with the bank account.

-> This means that if you have created entries on a reconciliable account but you never reconcile it (ie: a cut-off entry or a correction) this line will appear forever in the list of possible matches -> so you may need this module to clean it up.

To use this module, you need to:

  1. Go to Accounting > Adviser > Journal Entries
  2. Select one or more Journal Entry items
  3. Press 'Action > Bank reconcile report change'
  4. Select required value in 'New value' field. Leave empty if you want to set empty value.
  5. Press 'Set value'

By doing this, you will create/delete the link between Journal entry and bank statement lines hence you will make corrections on the bank reconcile report which would be impossible to do through the Odoo interface.

Try me on Runbot

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 smash it by providing detailed and welcomed feedback.

Credits

Images

  • Odoo Community Association: Icon.

Contributors

  • Camptocamp SA

Maintainer

Odoo Community Association

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.

To contribute to this module, please visit https://odoo-community.org.

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