search

my-flow / paypalimporter

PayPal Importer is an extension for Moneydance that imports transactions from PayPal into Moneydance.
https://www.my-flow.com/paypalimporter/
Other
9 stars 3 forks source link

Issues importing multiple currencies #12

Open ghost opened 7 years ago

ghost commented 7 years ago

Hi there,

This is a pretty handy thing, thanks! I'm sick of Quicken so I was just testing Moneydance out and saw this extension and decided to give it a whirl too. I've only used Moneydance for minutes at this point so sorry if I'm wrong about anything but I just wanted to report what I've discovered and see if it's fixable or maybe I'm just doing something wrong and if you could point me in the right direction I'd be very greatful. This extension seems to actually work for importing some transactions but in my PayPal I have transactions from multiple currencies and it doesn't appear to handle them.

It seems to only handle transactions in the currency my PayPal account is set to (CAD), though maybe there's some other reason. It doesn't appear to matter if my Moneydance file is set to USD or CAD, it will still import only the CAD transactions, except when I import into the USD file it seems to add a weird exchange rate or something to each transaction with different values for each one such as 0.997792, 0.997699, 0.997366, etc. I'm not really sure what that's about but I have done no configuring of anything in Moneydance including exchange rates so maybe that's something to do with it. Either way, these transactions are CAD transactions in a USD Moneydance file so I guess it's just detecting that but I was just testing to see if it would import USD transactions from PayPal. Seems not.

So it doesn't look like it imports transactions that were in USD, or probably any other currency, I'm guessing other than what my PayPal account is set to. It also doesn't seem to recognize transfers from CAD to USD for a payment, for example if I didn't have enough USD to cover the cost and PayPal converted some of my money from CAD to USD automatically to cover the payment. This results in the balance of the account being wrong.

I've tried using the newest v6 version but it still seems to do the same thing.

Ideally I'd like to be able to specify which currency of transactions to import from PayPal into Moneydance since so far it looks like I have to have separate files for separate currencies in Moneydance. I'm not sure if there's a way around that or not but I guess it's better than not having multiple currencies. Still learning. Not sure if it will do the trick or not yet.

Thank you!

my-flow commented 7 years ago

@ty2u, could you have a look at issue #2 where a similar problem with multiple currencies was reported? Would the suggested solution there help you?

ghost commented 7 years ago

Hello,

Unfortunately that doesn't seem to work for me. I tried that a couple different ways but it always seems to download only the CAD transactions. I've tried creating new accounts for CAD and USD within a CAD file and I've tried creating them within a USD file.

It seems that the Primary Currency setting when creating a file might just be the default currency a new account is set to unless you change it and maybe doesn't have anything to do with the exchange rate thing, but I'm not too sure. Before I thought you couldn't change currencies of accounts but maybe that's only for existing accounts which were automatically created in the first step when importing only the accounts.

So it seems like I can create a new account and set it's currency to USD, but still it only imports the CAD transactions for some reason, no matter if I create it in a USD file or CAD file. It also doesn't seem to matter if I create a new CAD account and try importing there and then to the USD account, it still only gets the CAD transactions for some reason.