Quicken Interchange Format
From Wikipedia, the free encyclopedia
Quicken Interchange Format (QIF) is an open specification for reading and writing financial data to media (i.e. files). A QIF file typically has the following structure:
!Type:type identifier string
[single character line code]Literal String Data
...
^
[single character line code]Literal String Data
...
^
Each record is ended with a ^ (caret). All the data in the file is stored in ASCII strings, and the file could be edited in any text editor (such as vi in Unix or Notepad in Microsoft Windows).
QIF is older than Open Financial Exchange (OFX). The inability to reconcile imported transactions against the current account information is one of the primary shortcomings of QIF. It is commonly supported by financial institutions to supply downloadable information to account holders. Most personal money management software (Microsoft Money, Intuit's Quicken versions earlier than 2006) can read QIF files to import information. However, Quicken has dropped support of QIF for online banking accounts as of version 2006 [1]. However, as of release R4, Quicken 2006 still supports importing and exporting transactions in QIF format for asset, liability, cash, small business payable, and invoice accounts [2]. Banks that support integrated online banking (i.e. as part of Money or Quicken) usually use OFX instead of QIF.
[edit] External links
- Official Specification
- Specification
- How to parse online bank QIF with sed
- Python script to convert QIF to RDF. Look for def extract(path). Script provided by SWAP.
- GnuCash QIF format notes
