<div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div><div><div>Hi all<br><br>Also noticed something else while trying to migrate my Quicken3 data to KMM, that I thought to share too.<br><br></div><div>I'm sorry this is long...The upshot here is - I think the application of FX rates should be
restricted only to the parts of a split that really cross currency
boundaries.<br>(i.e. I think splits for bank charges for card purchases that always stay in the bank account currency, should
not even be editable (or visible?) in the register entry of the
destination cash account.)<br><br></div><div>The longer version (a couple of days already gone for me!):<br></div><div><br></div>In quicken3 I can record a (foreign currency) cash withdrawal (from a bank account in my home country/currency) made abroad (eg using an ATM while on holiday), the following happens:<br><br></div><div>My bank statement includes one part that has an FX rate (on the cash I drew out) and other parts (the charges, in home currency) that have no FX rate.<br></div><div><br></div>I can make a split entry in the bank-account register, which includes one split that is a transfer into a cash account I have already setup (in the foreign currency in question).<br><br></div>Then in my case there are actually <b>two</b> other split-elements:<br></div>- one is a standard debit card charge (just for the audacity of travelling abroad and using the bank's card !), and<br></div>- one is a foreign-currency-amount-related charge, eg might be a percentage of the transferred amount with an upper limit etc.<br><br></div>So in quicken these two charges stay in my home currency and no fx rate is applied (nor needed).<br>An FX rate is only needed for the split element representing the amount of foreign cash I drew out of the hole in the wall.<br></div>Quicken effectively asks for this fx rate (actually: asks exactly how much the transferred amount becomes in the destination currency) when the transaction is committed into the bank account register.<br><br></div>I find this sensible.<br><br>Then recently I was surprised by two things in KMM, after trying to import these accounts from Quicken3.<br><br></div><b>First</b>, in KMM (you can right click the bank register entry and '<b>go to</b>' the cash account register, where..) surprisingly in the destination cash account register you can see <b>all three</b> split entries. Even though the two card-related charges are administrative charges 'back at home'.<br><br></div><b>Secondly</b>, the FX rate used/applied to the amount pulled out of the wall, to calculate one of the split elements, is <b>also applied</b> to the other two elements as well.<br><br></div>Now I find this problematic because when I import this transfer over into KMM there is no FX rate stored in the record, so KMM is using some default FX rate.<br></div>Then when I try to find these FX-impacted transfers and <b>correct the FX rate</b> manually, my new rate is applied not only to the money pulled out of the wall, but also affects the charges applied in the home currency too.<br>That then breaks the total of the transaction and I'm stuck in a fiddly recursive 'newton-raphson style' manual iteration loop that gets quickly tedious.<br><br></div>Anyhooo if someone has familiarity with this area and wants to get in touch I'd be glad to get any helpful feedback.<br><br>Kindest regards<br>Faz<br><div><br><div><div><div><div><div><div><div><div><div><div><div><div><div><div><br><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 28, 2014 at 8:10 AM, Thomas Baumgart <span dir="ltr"><<a href="mailto:thb@net-bembel.de" target="_blank">thb@net-bembel.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
some information about Quicken import I received as PM and might be<br>
interesting for others as well.<br>
<br>
Regards<br>
<br>
Thomas<br>
<br>
---------- Forwarded Message ----------<br>
<br>
Subject: importing Quicken3 into KMyMoney 4.7.1<br>
Date: Wednesday 26 November 2014, 00:48:33<br>
From: Faz<br>
To: <a href="mailto:ipwizard@users.sourceforge.net">ipwizard@users.sourceforge.net</a><br>
<div><div class="h5"><br>
Hi Thomas<br>
<br>
Been trying to import a couple decades of "Quicken3 for Windows" QIF<br>
exported data into KMyMoney v4.7.1<br>
<br>
Your help doc on<br>
<a href="http://kmymoney2.sourceforge.net/online-manual/details.impexp.qifimp.html" target="_blank">http://kmymoney2.sourceforge.net/online-manual/details.impexp.qifimp.html</a><br>
is very useful.<br>
<br>
You might be surprised how many people stayed with Quicken3 - it basically<br>
did what I needed so I never upgraded.<br>
<br>
Here's a tip that may be worth adding on that page:<br>
<br>
Quicken3 spits out ^^ on a record separator line but KMyMoney is expecting<br>
a single ^ .<br>
<br>
I just use a Textpad regexp search / replace on the QIF file like this:<br>
<br>
Search for: ^^^$<br>
Replace with: ^<br>
<br>
You could stick with awk as in the existing filter example. I guess it<br>
would be a one liner like this:<br>
<br>
/^^^$/ { print "^" }<br>
<br>
(Not sure if the carets in the search expression need escaping though - I<br>
don't have a linux box to try it with - sorry!)<br>
<br>
In anycase I'll see how far I get and maybe I'll have more experience to<br>
share with you on importing Quicken3 into KMyMoney 4.7.1!<br>
<br>
The double ^^ issue was a major hurdle before I could get any progress with<br>
imports.<br>
<br>
Best wishes<br>
Fazl<br>
</div></div>-----------------------------------------<br>
<span class="">--<br>
<br>
Regards<br>
<br>
Thomas Baumgart<br>
<br>
GPG-FP: E55E D592 F45F 116B 8429 4F99 9C59 DB40 B75D D3BA<br>
-------------------------------------------------------------<br>
</span>What is mind? No matter. What is matter? Never mind.<br>
(Punch, 1855)<br>
-------------------------------------------------------------<br>
</blockquote></div><br></div>