[Kmymoney] Import from MoneyDance

[aga]

On Thu, 03 Nov 2011 09:26:45 -0500
Shane Rice <shane2peru at gmail.com> wrote:

> Right, I did try that.  I created a Soles cash account with the
> currency set as PEN, however when I import, because the account is
> tied to another account (via transfers) it imports it as US $.  I
> pull money from the ATM, and enter it as a 'transfer' from bank
> account to Cash Soles account with the transfer rate.  Example, if I
> pull $5 from the bank it get's converted to PEN in Moneydance, and
> shows 13.5 PEN.  So when that get's imported, it shows both as US$
> and really makes a mess of things.  I appreciate the help!
> 
> Shane

As I understand it, you are importing two interlinked accounts.  It may
be irrelevant, but are you importing both accounts in the same file?
If so, it may be that coming across the same transaction twice is
causing the problem, so try one at a time and see if that helps or
makes clearer where things go wrong.

A suggestion on wikipedia for dealing with such transfers, although not
involving different currencies, is to edit the file.

"When editing the QIF file, check for any transaction Category (the
field starting with 'L') for an account name contained in brackets,
such as [Checking Account]. The brackets reference another quicken
account, and if left in place will post a transaction in that account
in addition to the account being imported to, with potentially
troublesome results. Avoid this by removing the text including the
brackets and replacing with another category if desired. The only
exception to this is an opening balance transaction, identified by
'Opening Balance' in the 'P' field (POpening Balance). In this case,
the brackets need to be left in place, and the account name between the
brackets must exactly match the account name in the 'N' field."

Allan


> 
> On 11/03/2011 09:22 AM, Thomas Baumgart wrote:
> > Hi,
> >
> > on Thursday 03 November 2011 15:12:25 Shane Rice wrote:
> >
> >> I'm finally switching over.  I have a few questions.  1.  I wasn't
> >> able to figure out a way to import my data from MoneyDance.  I
> >> work with 2 different currencies all the time.  My primary
> >> currency is the US Dollar, and should be my base.  However I work
> >> daily with PEN (Pervian Nuevo Sole).  That is why importing was so
> >> difficult.  Does anyone know of a way to import multiple
> >> currencies?  I also can export to qif individually.  So every
> >> account can be exported.  So I exported all the US Dollar
> >> accounts, then I can export the PEN account (a cash account)
> >> however I can't import the PEN into KmyMoney.  Any ideas???  Every
> >> time it imports it imports as $, not PEN.
> > What happens if you create the cash account before you import to it
> > and select PEN to be the currency it is denominated in? Since QIF
> > does not transport any currency information it  should import the
> > data w/o problem.  Make sure to have a conversion rate entered into
> > KMyMoney which covers the past. Otherwise, the categories go a bit
> > crazy.  YMMV
> >
> > -- 
> > ___________________
> > Serving the King,
> > Shane D. Rice
> > www.Rices2Peru.com <http://www.rices2peru.com>
> > www.ReinaValeraGomez.com <http://www.reinavaleragomez.com>
> > Romans 12:1-2