[Kmymoney] Import from MoneyDance

Thu Nov 3 20:56:35 UTC 2011

Ok, sorry, I'm not very good at this mail list stuff, never really used 
them.  I'm used to Forums. :)  As a follow up, with the new version, it 
imported 10x better.  I still had some cleanup work, but actually only a 
little.  I also couldn't change the Account from one currency to 
another.  I opened the .kmy file with a text editor, found the right 
account, and changed it from USD to PEN, and all worked great!  They 
were re-imported as PEN currency, so I didn't have to worry about the 
exchange rate! :)  Some fanangling, but in the end all worked great, I'm 
happy as a lark.  Case closed, everything solved.

@Allan indeed those were duplicated, but it was pretty easy to remove 
them in my 'checking' account, because they were the only things NOT 
reconciled :).  So I filtered things that weren't marked, and deleted up 
to the recent date, and hand picked through them.  Really pleased!

Shane

On 11/03/2011 02:23 PM, kmymoney-request at kde.org wrote:
> Send KMyMoney mailing list submissions to
> 	kmymoney at kde.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://mail.kde.org/mailman/listinfo/kmymoney
> or, via email, send a message with subject or body 'help' to
> 	kmymoney-request at kde.org
>
> You can reach the person managing the list at
> 	kmymoney-owner at kde.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of KMyMoney digest..."
>
>
> Today's Topics:
>
>     1. Re: Import from MoneyDance (aga)
>     2. Re: Import from MoneyDance (Shane Rice)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 3 Nov 2011 17:58:36 +0000
> From: aga<agander93 at gmail.com>
> To: kmymoney at kde.org
> Subject: Re: [Kmymoney] Import from MoneyDance
> Message-ID:<20111103175836.1062d27e at giga>
> Content-Type: text/plain; charset=US-ASCII
>
> 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
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 03 Nov 2011 14:23:13 -0500
> From: Shane Rice<shane2peru at gmail.com>
> To: Thomas Baumgart<thb at net-bembel.de>
> Cc: kmymoney at kde.org
> Subject: Re: [Kmymoney] Import from MoneyDance
> Message-ID:<4EB2EA21.3010001 at gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
>
> Ok, upgraded KmyMoney to 4.6, and now everything imports much better.
> Still have to tinker with it to get it correct, but seems using the
> older version didn't import as nicely.  So this seems to be working
> better now!  Thanks!!!
>
> Shane
>
> 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
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:<http://mail.kde.org/pipermail/kmymoney/attachments/20111103/16976f32/attachment.html>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: PERUFlag.gif
> Type: image/gif
> Size: 20802 bytes
> Desc: not available
> URL:<http://mail.kde.org/pipermail/kmymoney/attachments/20111103/16976f32/attachment.gif>
>
> ------------------------------
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>
>
> End of KMyMoney Digest, Vol 16, Issue 3
> ***************************************
> -- 
> ___________________
> Serving the King,
> Shane D. Rice
> www.Rices2Peru.com <http://www.rices2peru.com>
> www.ReinaValeraGomez.com <http://www.reinavaleragomez.com>
> Romans 12:1-2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20111103/b90c15c5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PERUFlag.gif
Type: image/gif
Size: 20802 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20111103/b90c15c5/attachment-0001.gif>