OdooWiki OCA HUB

Journal Entry transactionID import

account_move_transactionid_import folder_open OCA/account-reconcile open_in_new
Finance License: AGPL-3

This module extends the functionality of account_move_base_import, in order to add both importation and auto-completion for the "transaction_ref" field added in base_transaction_id.

auto_awesome What this module does

AI-generated from the code · Odoo 12.0

Import bank statement files that contain a transaction ID and let Odoo automatically find the matching sales order or invoice to fill in the partner and account on each statement line.

This module adds a new bank statement import format and two automatic matching rules based on a transaction ID.

When importing a bank statement file, you can now choose the format "Generic .csv/.xls based on SO transaction ID" on the journal. The file must contain columns for transaction ID, label, date, amount and commission amount. Each imported line is created with the transaction ID stored in the reference field.

Two new completion rules are available for bank statement lines: - Match Sales Order using transaction ID: looks for a sales order whose transaction ID equals the line reference, then fills in the customer and its receivable account. - Match Invoice using transaction ID: looks for a customer invoice with that transaction ID, then fills in the commercial partner and the invoice account.

If more than one partner or invoice matches the same transaction ID, the import stops with an error message saying the line was matched by more than one partner or invoice.

The module works together with the bank statement import and transaction ID modules. It touches account.journal, account.move.completion.rule, sale.order and account.invoice.

Models and fields (2)
  • account.journal · extends an existing modelimport_type
  • account.move.completion.rule · extends an existing modelfunction_to_call

Text generated by AI (DeepSeek) from reading the Odoo 12.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 12.0

Confirmed on 2026-11-03 in branch 12.0 of OCA/account-reconcile.

terminal Installation and usage

No verified information

Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.

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.