Imported MS Money accounts, but moneydance mixes the currencies in some of the accounts

Tom's Avatar

Tom

18 Jun, 2015 05:14 PM

Hello

I imported 40 accounts with 20 years of transactions from msmoney into moneydance.

When it was completed some of the accounts (original was CHF target is CHF) many of the transactions it says the amount deposited was another currency (GBP) and has converted the amount using an exchange rate.

example CHF 6400 paid in but an exchange rate 0.4 applied so the result deposited is CHF 3000

Result : Many of the 40 accounts are balanced incorrectly

Can this be fixed easily. It has been a long afternoon importing and creating all these accounts and I really want to use moneydance going forward.

screenshot attached.

Thanks
Tom

  1. 1 Posted by Ben Spencer on 18 Jun, 2015 05:21 PM

    Ben Spencer's Avatar

    I am afraid thee is no easy fix for this. The QIF file format does not contain any currency information. QIF files don't specify the currency of accounts or the exchange rates on transfers between accounts.

    Typically with multi-currency imports you need to create the accounts in MD before importing into them to ensure the currencies on the accounts in MD are correct before the import. Even so you will still have to manually correct exchange rates on all of your transfers post import and delete duplicates caused by the import process. With so many accounts and so much transaction history it may not be worth the effort to transfer your existing data.

    Ben Spencer
    Infinite Kind Support

  2. System closed this discussion on 19 Mar, 2016 04:57 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac