QIF Import: rounding problems?

[Derek Atkins]

Can you file a bug report on this?  If you can supply a sample
QIF that exhibits the bug that would be even better.

Thanks,

-derek

Derek Brader <brader at ieee.org> writes:

> 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
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available