The following rules apply to the structure of QIF files:

1. Each transaction must end with a ^ symbol.
2. Each item in the transaction must appear on a separate line.
3. When Quicken exports an account register, it adds one of the following lines at the beginning of the file to identify the type of account:

!Type:Bank	!Type:Invst
!Type:Cash	!Type:Oth A

!Type:CCard	!Type:Oth L

You can add a line that forces Quicken to import all transfers, regardless of whether Ignore Transfers is selected when the file is imported.  Add this line immediately after one of the lines above that begins the file:

!Option:AllXfr

Copyright © 1994 Intuit

---->
Use these letters to identify specific items in an investment account transaction.  Each line in the transaction must begin with one of these letters:

Letter	What it means

D	Date (optional)
N	Action
Y	Security
I	Price
Q	Quantity (# of shares or split ratio)
C	Cleared status
P	1st line text for transfers/reminders
M	Memo
O	Commission
L	Account for transfer
$	Amount transferred

^	End of entry

If an item is omitted from the transaction in the QIF file, Quicken treats it as a blank item.

Copyright © 1994 Intuit

---->
Use these letters to identify specific items in a noninvestment account transaction.  Each line in the transaction must begin with one of these letters:

Letter	What it means

D	Date
T	Amount
C	Cleared status
N	Number (check or reference)
P	Payee/description
M	Memo
A	Address (up to 5 lines; 6th line is an optional message)
L	Category (category/transfer/class)
S	Category in split (category/transfer/class)
E	Memo in split
$	Dollar amount of split

^	End of entry

Repeat the S, E, and $ lines as many times as necessary for additional items in a split.  If an item is omitted from the transaction in the QIF file, Quicken treats it as a blank item.

Copyright © 1994 Intuit

---->
The following example shows two transactions that were exported from a Quicken bank account to a QIF file.

Line in file			What the line means

!Type:Bank			Header line
D6/12/93			Date of 1st transaction
T-1,000.00			Amount of 1st transaction
N*****				Check number
PFranks Plumbing		Payee
AFranks Plumbing		Address (1st line)
A2567 Fresno Street		Address (2nd line)
ASanta Barbara, CA 90111	Address (3rd line)
LHome Maint			Category/Transfer/Class
^				Ends 1st transaction
D6/15/93			Date (2nd transaction)
T-75.46				Amount (2nd transaction)
CX				Status in Cleared column
N256				Number
PWalts Drugs			Payee
LSupplies			Category/class
SSupplies			First category in split
EOffice supplies		First memo in split
$-36.00				First amount in split
SGarden				Second memo in split
$-39.46				Second amount in split
^				Ends 2nd transaction


Copyright © 1994 Intuit