QIF import file construction....

[Allan]

I have about 2000 transactions from QuickBooks in a csv like 
format/general journal report I am trying to convert to QIF format for 
import into GC.

I'm searching for converters, etc. to do this. Or just what the QIF 
format would be at least. Or, idk, advice to give up? lol

I'm not seeing how to handle transactions with lots of splits, which are 
not unusual. Is all this QIF import just for importing a bank statement 
or some such simple case?

ie. from my CSV file, here's a paycheck with splits for all the payroll 
taxes, deductions, etc:

"Trans #","Type","Date","Num","Name","Memo","Account","Debit","Credit"
"1951","Paycheck","9/1/2012","1074","Allan Anderson",,"1002 · TCF 
Bank","",1556.00
,,,,"Allan Anderson",,"6010 · Shareholder Wages",2000.00,""
,,,,"Allan Anderson",,"7015 · Automobile Expense","",""
,,,,"Allan Anderson",,"2130 · Federal Withholding","",201.00
,,,,"Allan Anderson",,"6040 · Employer FICA Expense",124.00,""
,,,,"Allan Anderson",,"2105 · Company FICA","",124.00
,,,,"Allan Anderson",,"2110 · Employee FICA","",124.00
,,,,"Allan Anderson",,"6040 · Employer FICA Expense",29.00,""
,,,,"Allan Anderson",,"2115 · Company Medicare","",29.00
,,,,"Allan Anderson",,"2120 · Employee Medicare","",29.00
,,,,"Allan Anderson",,"6050 · FUTA Expense",0.00,""
,,,,"Allan Anderson",,"2160 · FUTA Payable",0.00,""
,,,,"Allan Anderson",,"2140 · State Withholding MN","",90.00
,,,,,,,2153.00,2153.00

As for the destination QIF, From this: 
https://github.com/Gnucash/gnucash/blob/master/src/import-export/qif-imp/file-format.txt 

I see:
Non-investment transaction format
---------------------------------
Letter Definition
D Date
T Amount
U Transaction amount (higher possible value than T)
C Cleared status
N Number (check or reference number)
P Payee/description
M Memo
A Address (up to 5 lines; 6th line is an optional message)
L Category (category/class or transfer/class)

S Category in split (category/class or transfer/class)
E Memo in split
$ Dollar amount of split
% Percentage of split if percentages are used
F Reimbursable business expense flag
X Small Business extensions
^ End of entry

Note that S,E and $ lines are repeated as needed for splits.



So it seems this would convert to something like this, except, nothing 
happens when I import it. There are no matching accounts (QIF to GC 
accounts), no changes to any account balances:

!Account
MPaycheck
D9/1/2012
N1074
PAllan Anderson
NTCF
T1556.00
U2153.00
SShareholder Wages
EAllan Anderson
$-2000.00
SFederal Withholding
EAllan Anderson
$201.00
SEmployer FICA Expense
EAllan Anderson
$-124.00
SCompany FICA
EAllan Anderson
$124.00
SEmployee FICA
EAllan Anderson
$124.00
SEmployer FICA Expense
EAllan Anderson
$-29.00
SCompany Medicare
EAllan Anderson
$29.00
SEmployee Medicare
EAllan Anderson
$29.00
SState Withholding MN
EAllan Anderson
$90.00
^