Quicken Interchange Format
Filename extension
Developed by	Intuit

Hello, why cant I import a quicken file.Qif or QFX with check numbers and payments into my quicken file? When importing it creates a new file account? I want it to enter a present account? Accountant's Assistant: A combination of financial issues and software stuff sounds like a recipe for needing our Expert. You are in the right place. In Quicken, click File. Click File Import. At the QIF Import window: Locate the payroll.qif file you saved. Select from the Quicken account to import into drop down. Check Transactions, Special Handling for transfers and Account List. Click Accept All. Quicken 2004 and earlier: In Quicken.

Quicken Interchange Format (QIF) is an open specification for reading and writing financial data to media (i.e. files).

Background[edit]

Although still widely used, QIF is a format 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.^{[citation needed]} Most personal money management software, such as Microsoft Money, GnuCash and Quicken's low end products (e.g. Quicken Personal and Quicken Personal Plus),^[1] can read QIF files to import information. Intuit'sQuicken used to be able to import QIF, too, but with its 2006 version it dropped that support^[2] for several important account types, including checking, savings, and credit card accounts.^[3] The Australian version of Quicken still allows the importing of QIF files for these account types. However, unlike the American version, it is not possible to export data to QIF or any other file type for any account type. The QIF format does not allow a user to mark the currency in which a transaction was completed. In some cases this may cause problems for users who do use multiple currencies when they export or import into another software package.^{[citation needed]}

Quicken's proposed replacement for the QIF format has been the proprietary Quicken Web Connect (QFX) format.It is commonly supported by financial institutions to supply downloadable information to account holders, especially by banks that support integration of Money or Quicken with their online banking. Not everybody, however, was, or is, happy with this replacement. Some banks dislike it because Quicken (Intuit) charges licensing fees to use QFX. Other banks pass the fees on by charging customers for downloading QFX files. Because Microsoft Money imports either QIF or OFX format files, and Microsoft does not charge banks any licensing fees to use OFX for Money, banks do not normally charge for downloading QIF and OFX files. (QIF and OFX are open formats, free for anyone to use.)

Data format[edit]

A QIF file typically has the following structure:

Each record ends with a ^ (caret). All the data in the file is stored in ASCII strings, and the file could be edited in any text editor.

simple example

Header line[edit]

The first line in the file must be a header line, to identify the type of data contained. Valid values for accounts are:

Code	Description
!Type:Cash	Cash Flow: Cash Account
!Type:Bank	Cash Flow: Checking & Savings Account
!Type:CCard	Cash Flow: Credit Card Account
!Type:Invst	Investing: Investment Account
!Type:Oth A	Property & Debt: Asset
!Type:Oth L	Property & Debt: Liability
!Type:Invoice	Invoice (Quicken for Business only)

There are also values for QIF files of internal Quicken information: Adobe acrobat pro 2017 key generator.

Code	Description
!Account NAccount Name TAccount Type DAccount Description	Account list or which account follows
!Type:Cat NCategory Name DCategory description	Category list
!Type:Class	Class list
!Type:Memorized	Memorized transaction list

A header line is not followed by a separator line; it is immediately followed by the first field of a detail item.

Detail items[edit]

The Detail section consists of several Detail Items, each on a separate line. Each line begins with a single character identifying code in the first column, followed by the literal data for that field. The detail item is terminated by a separator line. The fields can be in any order (except that within split transactions, the category, amount, and memo must be adjacent). If a single transaction block contains several detail items with same code, the last row is used for import.

Standard detail item

Code	Description	Used In	Example
D	Date. Leading zeroes on month and day can be skipped. Year can be either 4 digits or 2 digits or '6 (=2006).	All	D25 December 2006
T	Amount of the item. For payments, a leading minus sign is required. For deposits, either no sign or a leading plus sign is accepted. Do not include currency symbols ($, £, ¥, etc.). Comma separators between thousands are allowed.	All	T-1,234.50
U	Seems identical to T field (amount of item.) Both T and U are present in QIF files exported from Quicken 2015.	All	U-1,234.50
M	Memo—any text you want to record about the item.	All	Mgasoline for my car
C	Cleared status. Values are blank (unreconciled/not cleared), '*' or 'c' (cleared) and 'X' or 'R' (reconciled).	All	CR
N	Number of the check. Can also be 'Deposit', 'Transfer', 'Print', 'ATM', 'EFT'.	Banking, Splits	N1001
P	Payee. Or a description for deposits, transfers, etc.	Banking, Investment	PStandard Oil, Inc.
A	Address of Payee. Up to 5 address lines are allowed. A 6th address line is a message that prints on the check. 1st line is normally the same as the Payee line—the name of the Payee.	Banking, Splits	A101 Main St.
L	Category or Transfer and (optionally) Class. The literal values are those defined in the Quicken Category list. SubCategories can be indicated by a colon (':') followed by the subcategory literal. If the Quicken file uses Classes, this can be indicated by a slash ('/') followed by the class literal. For Investments, MiscIncX or MiscExpX actions, Category/class or transfer/class. (40 characters maximum)	Banking, Splits	LFuel:car
F	Flag this transaction as a reimbursable business expense.	Banking	F???
S	Split category. Same format as L (Categorization) field. (40 characters maximum)	Splits	Sgas from Esso
E	Split memo—any text to go with this split item.	Splits	Ework trips
$	Amount for this split of the item. Same format as T field.	Splits	$1,000.50
%	Percent. Optional—used if splits are done by percentage.	Splits	%50
N	Investment Action (Buy, Sell, etc.).	Investment	NBuy
Y	Security name.	Investment	YIDS Federal Income
I	Price.	Investment	I5.125
Q	Quantity of shares (or split ratio, if Action is StkSplit).	Investment	Q4,896.201
O	Commission cost (generally found in stock trades)	Investment	O14.95
$	Amount transferred, if cash is moved between accounts	Investment	$25,000.00
B	Budgeted amount - may be repeated many times for monthly budgets.	Categories	B85.00
X	Extended data for Quicken Business. Followe

Importing .qif File Into Quicken Deluxe 2018