Quicken Interchange Format import filter (*.qif)

Quicken Interchange Format import filter (*.qif)

It allows Banana Accounting to read and convert data from QIF (Quicken Interchange Format) files into Banana’s internal accounting structure (Transactions table, Accounts, Categories).

The script:

  • Parses QIF records (such as date, amount, payee, memo, category)
  • Transforms them into Banana-compatible transaction rows
  • Handles different QIF types (Bank, Cash, Credit Card, etc.)
  • Ensures correct formatting for dates and amounts

In short, it enables importing bank or financial transaction data exported in QIF format into Banana Accounting.

How to Export Data in QIF Format

QIF is an older financial exchange format originally used by Quicken.

Exporting from Financial Software

If your software supports QIF export:

  1. Open your accounting or banking software

  2. Go to Export or Data Export

  3. Select:

    • Format: QIF (Quicken Interchange Format)

    • Account type: Bank / Cash / Credit Card

  4. Choose date range

  5. Save the .qif file

Exporting from Online Banking

Some banks still allow QIF export:

  1. Log in to your online banking portal

  2. Open the transaction history

  3. Choose Download / Export

  4. Select format:

    • QIF (if available)

    • Otherwise: CSV (you would need conversion)

Many banks today provide CSV or OFX instead of QIF.

Basic QIF Structure Example

A QIF file looks like this:

 
!Type:Bank
D03/01/2026
T-125.50
PPayment to Vendor
MInvoice 4587
LExpenses:Office
^
lorenzo
URL Stable release
http://www.banana.ch/accounting/files/banana8/filters/ch.banana.filter.import.qif.js
Short Description
Import filter (*.qif)
Country
Universal
Publisher
Banana.ch
Extension type
Import