GnuCash Unable to Import Mutliple Currencies

[Tom Balazs]

Derek Atkins wrote:
> You will need to get the accounts in different currencies exported into
> different QIF files.  Unfortunately that is the only way.  QIF does not
> have any way to specify a currency, so there's really nothing we can do.

Is there anyone who would write a script which would take the QIF file I
export out of GnuCash Android and split it into two QIF files according to
each account's currency?

I imagine that such a script would be useful to anyone who needs to import
a QIF with "multiple currencies". I write "multiple currencies" because
technically a QIF doesn't have currencies. However there are work-arounds
(e.g. name accounts "#Yen#_Checking", "#Yen#_Saving", "#USD#_Checking",
"#USD#_Saving", etc.). Then the script to splits the QIF file according to
the "#" tags I put in the account names. The result being two or more QIFs,
which can then be imported separately into GnuCash Desktop.

On Sep 16, 2014 5:52 PM, "Derek Atkins" <warlord at mit.edu> wrote:

> Hi,
>
> Tom Balazs <tom123online at gmail.com> writes:
>
> >>From my research and from correspondence with Ngewi Fet
> > https://github.com/codinguser/gnucash-android/issues/216
> > it seems to me that anyone who has a GnuCash Desktop with multiple
> > currencies and later needs to import a QIF file with multiple currencies
> > will run into problems
> > This would include ANY QIF exported out of ANY application (Android
> phone,
> > IPhone, Macintosh, etc.)
> >
> > Please read below and tell me if I understand this correctly.
> >
> > Ngewi  wrote:
> >> QIF file has no place to record currency. When importing to GnuCash,
> > GnuCash
> >> lets you choose what currency they are in, and all transactions and
> > accounts in
> >> the QIF file would be treated as they are in that currency. If they
> don't
> > match
> >> the corresponding account currency in GnuCash, there may be a problem.
> >
> > This is a problem. If I have created all my accounts correctly on GnuCash
> > Desktop and imported all them correctly to GnuCash Android. I will then
> > have:
> >
> > 1. GnuCash Desktop
> > 1.A. Checking Account 1 (Currency A)
> > 1.B. Checking Account 2 (Currency B)
> >
> > 2. GnuCash Android
> > 2.A. Checking Account 1 (Currency A)
> > 2.B. Checking Account 2 (Currency B)
> >
> > Up to here everything is working fine.
> > But when I export out of GnuCash Android and then attempt to import all
> > that to GnuCash Desktop, then GnuCash Desktop forces me to choose one
> (and
> > ONLY one) currency for all the transactions I'm importing. So, if I
> choose
> > "Currency A" for all transactions then GnuCash desktop forces
> > GnuCash Android: 2.B. Checking Account 2 (Currency B)
> > into becoming "Currency A". And when it tries to put those transactions
> > into the correct place in GnuCash Desktop, there is a conflict.
> >
> > Please help me to resolve this problem.
>
> You will need to get the accounts in different currencies exported into
> different QIF files.  Unfortunately that is the only way.  QIF does not
> have any way to specify a currency, so there's really nothing we can do.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        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
>