QIF Import code for Multiple Currency Accounts
Derek Atkins
warlord at MIT.EDU
Fri Jul 13 13:17:23 EDT 2007
Hi,
The QIF importer doesn't support multi-currency.. I don't even know
what a QIF multi-currency transaction LOOKS like! So, I'm afraid that
it just wont work for the forseeable future.
A couple of suggestions:
1) Import it account-by-account and then manually adjust the
exchange rates
2) Start from scratch.
3) I can't think of a #3.
Sorry to be the bearer of bad news.
-derek
"Agni Dasa" <info at uc3.com> writes:
> Hi GnuCash Developers,
>
> I just installed the latest version of GnuCash 2.1.5 for Windows and tried
> importing my Quicken 2002 Premier Home & Busness QIF file that includes
> multiple currency accounts. The QIF import wizard reported that GnuCash
> does not currently handle multiple currency QIF file imports and that this
> limitation should be removed soon. Does anyone have any idea about how
> soon multiple currency QIF imports will be available?
>
> I really depend on that feature so I can switch over to GnuCash which as far
> as I have seen is the best accounting software available for accounting
> newbies like myself. I'm sure that there may be hundreds or maybe even
> thousands who are also waiting for this feature so they can switch over to
> GnuCash but when they see that it's not available they just move on without
> trying to contact the development team. So I'm asking on behalf of all those
> who chose to remain silent.
>
> I already emailed Bill Gribble who is listed in the credit list of GnuCash as the
> original developer of the QIF import but he responded at follows:
>
>> No, I'm sorry; I haven't worked on GnuCash in several years, and I don't
>> follow its development. You might try a request to the gnucash-devel
>> mailing list to see who is currently maintaining the QIF import code.
>>
>> Since the import process is something that you will only have to do one
>> time, you might try to export each account to a separate QIF file, each
>> file having only one currency, so the job of the QIF importer is
>> simpler. I don't use Quicken so I don't know exactly how to do that,
>> but I believe it is possible.
>
> I tried his suggestion to export each account into a separate QIF files each
> having only one currency but after I imported them into GnuCash and
> imported the foreign currency account separately and specified the currency
> of that account the resulting numbers in GnuCash were not what they were
> supposed be maybe because of transfers between the foreign currency
> account and the other accounts.
>
> Anyway, please let us know who is currently maintaining the QIF import code
> and how soon multiple currency QIF imports will be available. Thanks and we
> are looking forward to hearing from you soon.
>
> Regards,
> Agni Dasa
>
>
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
>
--
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
More information about the gnucash-devel
mailing list