Import OFX Bank Statement by ACCTID
Adds an OFX ACCTID field to bank accounts and makes the OFX import engine match statements by this value, falling back to Account Number only when the field is empty. Fixes mismatches when the \ in the file differs from the usual account number saved in Odoo.
auto_awesome What this module does
AI-generated from the code · Odoo 18.0Adds an OFX ACCTID field to bank accounts and uses it to match imported OFX bank statements to the correct journal, falling back to the account number when empty.
This module helps you import OFX bank statements into the right bank journal even when the account identifier inside the OFX file differs from the account number stored in Odoo.
On each bank account (the res.partner.bank record), a new field "OFX ACCTID" appears on the bank account form, right after the bank field. You can store there the technical account identifier exactly as it appears in the OFX file. A second read-only field, "Sanitized OFX ACCTID", is automatically computed from it by removing formatting characters, so comparisons are reliable.
When you import an OFX statement, the import engine first looks for a bank journal whose bank account has a sanitized OFX ACCTID matching the account identifier found in the file. If a match is found, the import uses that journal's account number. If the journal you selected manually does not match the one found in the file, an error message asks you to use the proper journal or the generic import button on the Accounting Dashboard. If no OFX ACCTID is set, the standard behaviour based on the account number is used.
This mainly touches bank accounts and the bank statement import wizard, and it is useful when the ACCTID in the file is not the same as the usual account number saved in Odoo.
Depends on
Models and fields (1)
- res.partner.bank · extends an existing modelacctid (OFX ACCTID), sanitized_acctid (Sanitized OFX ACCTID)
Text generated by AI (DeepSeek) from reading the Odoo 18.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-03Confirmation status: 4 confirmed, 5 with no information of 9 versions.
Sources · Odoo 14.0
Confirmed on 2026-11-03 in branch 14.0 of OCA/bank-statement-import.
terminal Installation and usage
OCA documentation · Odoo 18.0Usage
Source · Odoo 18.0- Go to Contacts → Configuration → Bank Accounts.
- Fill OFX ACCTID exactly as it appears in your OFX files.
- Import statements normally—the mapping now uses this field first.
No verified information in OCA: Installation, Configuration.
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.
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.