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