QIF Import: rounding problems?

Derek Brader brader at ieee.org
Thu Nov 9 21:29:06 EST 2006


Hi All,

I'm running into a problem when importing a QIF file from one of my 
investment companies (Fidelity).  The file contains a bunch of purchases 
of various commodities (mutual funds, mostly).  The accounts match up 
just fine for the most part and everything is happy except that many 
transactions are not properly balanced and end up with a small split to 
"Imbalance-USD".

I believe the problem is that Gnucash is calculating the debit amount 
from the share price and number of shares rather than using the debit 
value supplied directly.  Since Fidelity rounds off the share price to 
the nearest cent, this can cause problems.

Here's an example QIF transaction and the resulting GnuCash transaction:

QIF:

!Type:Invst
D10/02/2006
NBuy
YACCOUNT NAME
I10.75000        <- share price
Q2.949           <- number of shares
U31.71           <- debit (credit?) value
T31.71           <- credit (debit?) value
MContribution
^

Resulting GnuCash Transaction:

                      |   Shares   |  Price    |   Debit   |  Credit
---------------------+------------+-----------+-----------+----------
Assets:ACCOUNT NAME  |   2.949    | 10.7494   |   31.70   |
Imbalance-USD        |            |           |    0.01   |
Assets:Src Account   |            |           |           |  31.71


I tried figuring out a work-around involving modifying the QIF file, but 
nothing I tried worked.  Any ideas on work-arounds?  Should I file a bug 
report, or is this the desired behavior?

Thanks much,

~derek


More information about the gnucash-user mailing list