OdooWiki OCA HUB

Reconcile entries from pseudo bank statements

account_bank_statement_clearing_account folder_open OCA/bank-statement-import open_in_new
Banking addons License: AGPL-3

This is a technical modules that you can use to improve the processing of statement files from payment providers. These statements usually consist of lines that to be reconciled by customer debts, offset by lines that are to be reconciled by the imbursements from the payment provider, corrected for customer credits and the costs of the payment provider. Typically, the balance of such a statement is zero. Effectively, the counterpart of each statement line is made on a clearing account and you should keep track of the balance of the clearing account to see if the payment provider still owes you money. You can keep track of the account by reconciling each entry on it.

That is where this module comes in. When importing such a statement, this module reconciles all the counterparts on the clearing account with one another. Reconciliation is executed when validating the statement. When reopening the statement, the reconcilation is undone.

Known issues This module does not come with its own tests because it depends on a statement filter being installed. Instead, it is tested in account_bank_statement_import_adyen

auto_awesome What this module does

AI-generated from the code · Odoo 13.0

Automatically reconciles the clearing account entries created by pseudo bank statements when you confirm a statement, and undoes that reconciliation when you reopen it.

This module helps when you import statement files from payment providers. Such statements usually balance to zero, and their counterpart entries all land on a clearing account. Keeping that account tidy normally means reconciling those entries by hand.

With this module, Odoo does it for you:

  • When you confirm a bank statement, the clearing account entries belonging to that statement are reconciled automatically, provided the statement qualifies.
  • When you set the statement back to draft (reopen), that reconciliation is removed again.

A statement qualifies only if the journal's default debit and credit accounts are the same account and that account is marked as reconcilable, every statement line has a counterpart line on that account for the full amount, and the sum of those counterpart lines is zero. If any of these conditions is not met, nothing is reconciled.

It also refuses to act if the lines are already partly reconciled, and it only removes a reconciliation when the lines are still fully reconciled with each other.

The module extends the existing bank statement screen (account.bank.statement) and works through the standard Confirm and Reopen buttons, so no new menus or screens are added.

Depends on

account

Required by other modules

Models and fields (1)
  • account.bank.statement · extends an existing model

Text generated by AI (DeepSeek) from reading the Odoo 13.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 13.0

Confirmed on 2026-11-03 in branch 13.0 of OCA/bank-statement-import.

terminal Installation and usage

OCA documentation · Odoo 13.0

In order to enable the reconcilation of the counterparts of zero-balance statement files from payment providers, you need to make sure that the journal that is used for these statements have the same default debit account as their default credit account, and this account is configured for reconciliation.

After installing this module, any statement where the sum of all debit and credit lines match, and where the default journal account is reconcilable, will reconcile all posted moved when the statement is confirmed.

No verified information in OCA: Installation.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.