Import QIF Bank Statements
This module allows you to import the machine readable QIF Files in Odoo: they are parsed and stored in human readable format in Accounting Bank and Cash Bank Statements.
Important Note
Because of the QIF format limitation, we cannot ensure the same transactions aren't imported several times or handle multicurrency. Whenever possible, you should use a more appropriate file format like OFX.
The module was initiated as a backport of the new framework developed by Odoo for V9 at its early stage. As Odoo has relicensed this module as private inside its Odoo enterprise layer, now this one is maintained from the original AGPL code.
auto_awesome What this module does
AI-generated from the code · Odoo 19.0Lets you import QIF bank statement files (Quicken/QuickBooks format) into Odoo's bank and cash statement import wizard, so transactions are parsed and stored as statement lines.
This module adds QIF as an accepted file format in the standard bank statement import wizard. When you open the import screen and upload a file, the list of supported formats now includes "Quicken Interchange Format (.qif)".
- The module recognises a QIF file by checking that it starts with "!Type:".
- It reads the header to confirm the file is a Bank or Credit Card statement; otherwise it raises an error saying the file is not a bank statement or is not correctly formed.
- For each transaction it extracts the date, amount, check number (used as reference), payee and memo (used as the payment reference).
- The total of all amounts is used as the ending balance of the statement.
- After parsing, it tries to match each transaction to an existing contact by searching for a partner whose name contains the payment reference, and fills in the partner automatically when found.
It extends the account.journal model to advertise QIF as an available import format, and extends the account.statement.import wizard to parse QIF files and complete the statement values. The only screen change is the added format line in the existing import form. Note that the QIF format itself cannot guarantee that the same transactions are not imported twice, and it does not handle multiple currencies.
Depends on
Models and fields (2)
- account.journal · extends an existing model
- account.statement.import · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 19.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: 2 confirmed, 7 with no information of 9 versions.
Sources · Odoo 19.0
Confirmed on 2026-11-03 in branch 19.0 of OCA/bank-statement-import.
terminal Installation and usage
OCA documentation · Odoo 19.0Usage
Source · Odoo 19.0To use this module, you need to:
- Go to Invoicing / Accounting dashboard.
- Click on Import statement from any of the bank journals.
- Select a QIF file.
- Press Import.
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.