Import QIF Bank Statements

account_bank_statement_import_qif folder_open OCA/bank-statement-import open_in_new

Accounting License: AGPL-3

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 13.0

Lets you import bank statements saved in Quicken Interchange Format (.qif) files into Odoo Accounting, where they are turned into bank statement lines.

This module adds QIF as an accepted file format when importing bank statements. In the bank statement import screen, the list of supported formats now includes "Quicken Interchange Format (.qif)", so you can upload a .qif file and Odoo will read it.

When a QIF file is uploaded, the module checks that it really is a QIF file (it must start with "!Type:"). It then reads the file line by line and builds bank statement lines with the transaction date, amount, reference (for example a check number), and a name built from the payee and memo fields. The statement's ending balance is set from the total of the imported amounts.

If the file is not a bank or credit card QIF file, or cannot be read, Odoo shows an error message instead of importing it.

After import, the module tries to match each statement line to an existing contact by searching for a contact whose name contains the payee/memo text, and fills in that contact on the line when one is found.

It works together with the standard bank statement import feature and the accounting journals, and does not add new menus of its own.

Depends on

account_bank_statement_import

Models and fields (2)

account.journal · extends an existing model
account.bank.statement.import · 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

Usage

Source · Odoo 13.0

To 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.

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.