Skip to main content

OCA Financial Reports

Project description

License: AGPL-3

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.

Project details


Download files

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

Files for odoo10-addon-account-bank-statement-line-reconciliation, version 10.0.1.0.0.99.dev4
Filename, size File type Python version Upload date Hashes
Filename, size odoo10_addon_account_bank_statement_line_reconciliation-10.0.1.0.0.99.dev4-py2-none-any.whl (23.4 kB) File type Wheel Python version py2 Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page