QIF import fails for zero sum split

B Wooster bwooster47 at gmail.com
Sun Feb 2 12:17:05 EST 2014


Sure - here are the parts of the .QIF file that show a correct and failed
import:

This one correctly imports - The GnuCash Checking account has a single
$1200 entry no entries for 401K or Savings Quicken account transfers:

D7/31' 0
U1,200.00
T1,200.00
CX
PPay Check
LSalary
SSalary
EPaycheck (before tax)
$4,593.75
STax:Fed
$-1,250.50
STax:State
$-285.68
STax:Soc Sec
ESocial Security (FICA)
$-283.50
STax:Medicare
$-66.30
SMedical:Insurance
EDental, Health, LTD
$-34.59
S[401K at Work]
ETransfer to 401K
$-321.56
S[Company Stock]
ETransfer to Company Stock
$-183.75
S[Savings]/Bank1
ETransfer to Savings
$-967.87
^

This one fails to correctly import.
The GnuCash Checking account has a two Withdrawals for 270 and 1673.31, the
two account transfers in Quicken:

D4/30' 4
U0.00
T0.00
CX
PBonus
LSalary
SSalary
EPaycheck (before tax)
$3,000.00
STax:Fed
$-682.50
STax:Soc Sec
$-186.00
STax:State
$-144.69
STax:Medicare
$-43.50
S[401K at Work]
ETransfer to 401K
$-270.00
S[Savings]/Bank1
EXfer
$-1,673.31
^



On Sun, Feb 2, 2014 at 10:12 AM, John Ralls <jralls at ceridwen.us> wrote:

>
> On Feb 2, 2014, at 5:33 AM, B Wooster <bwooster47 at gmail.com> wrote:
>
> > I read some archived postings on this issue regarding Moneydance vs
> Quicken
> > imports, but that was a 2008 posting, and it seems to suggest that
> Quicken
> > should be fine.
> >
> > I'm totally new to GnuCash, just trying it out. Have over 20 years of
> > Quicken 2006 data, the QIF file is around 2.3M.
> >
> > Imported it all as a single QIF file, and all import info screens seemed
> to
> > do the right thing (except it could not import many of the investment
> > actions such as grant, exercise, etc).
> >
> > But the first key problem is that $0 Split Transactions in my checking
> > account were wrongly imported.
> > Non-$0 splits seem to be have been handled fine.
> > For each of the $0 splits, every transfer listed in the split was
> converted
> > to a
> > Withdrawal column item in my GnuCash Checking account.
> > One easy way for me to spot these was the "n" in the R column of the
> > checking account! All other lines have a "y" in there (reconciled), at
> > least for this Quicken 2006 account.
> >
> > Is this a known issue, and is there any workaround for a fix?
>
> I don't understand what you mean by "$0 split transaction". Could you give
> an example?
>
> Regards,
> John Ralls
>
>
>


More information about the gnucash-user mailing list