merge accts?

dmcneilly's Avatar

dmcneilly

27 Apr, 2016 05:26 PM

have just imported 98 individual accounts from Quicken (20 years) into MD. Now picking over and reconciling to get account balances to match. Obviously, lots of duplication. Have "Imported Bank Accounts" that were created from transactions from other accounts. Any way of merging the "imported" account with it's real counterpart? Thanks, am so looking forward to be off Quicken.

  1. Support Staff 1 Posted by Jenny on 28 Apr, 2016 09:57 AM

    Jenny's Avatar

    Hi,

    Regarding the duplicate transactions - are the dates the same on both sides of the transfer for these transactions? Some versions of Quicken support different dates on the other side of transfers. Unfortunately, Moneydance cannot match the two sides of a transfer in such a case.

    I may need you to clarify what you mean by "merging the 'imported' account with it's real counterpart". If you can provide more details about the accounts/transactions you'd like to amend/merge, and the outcome you'd like to see, then I will try to provide instructions.

    Jenny
    Infinite Kind Support

  2. 2 Posted by dmcneilly on 28 Apr, 2016 03:03 PM

    dmcneilly's Avatar

    The ‘imported’ accounts are the ones MD creates when it can’t match up a transaction. What I am now ending up doing is, deleting all the ‘imported’ credit and bank accounts. Deleting all transactions in all accounts, one by one, then reimporting transactions from my original files. Where MD has created an bank account instead of a liability or asset, I am doing as you suggested and creating the correct account and batch transferring, or importing, transactions into it.
     
    Someone else must have run into these import problems. I can’t be the only one that has twenty years of history in Quicken. I understand MD cannot cover every situation but this seems like a pretty basic one.
     
    Back to the grindstone. I did this professionally. I worked for nonprofits and for nearly every company, I either set them up with accounting software or, went through a major conversion to new software. Seems like nothing has changed in the ten years I’ve been retired.
     
    Thank you for your help.

  3. 3 Posted by dwg on 28 Apr, 2016 09:06 PM

    dwg's Avatar

    QIF files do not absolutely define account types.nor differentiate between accounts and categories hence why it can be problematic (the original expectation with QIF files is that the accounts & categories would already be present.

    One way of avoiding some of the problems is to import account information only on the first pass, then correct anything that has been incorrectly created, then performs the full import (do not change any names however they must appear exactly as they do in the QIF file or they will be recreated)

  4. 4 Posted by dmcneilly on 28 Apr, 2016 11:10 PM

    dmcneilly's Avatar

    Now, I am chasing my tail as it were. Started with the big accounts (6000+ entries), delete everything, re-import everything to get a current and correct balance. Move on to the next account. Eventually deleting transactions from some other account will affect and account already done. Discrepancies are getting less and less drastic but this is getting ridiculous. Missing all sorts of stuff in the portfolio. Having to go through fourteen years, item by item, comparing Q to MD.

  5. Support Staff 5 Posted by Jenny on 29 Apr, 2016 12:30 PM

    Jenny's Avatar

    Sorry to hear about your frustrations!

    Most customers are able to export their data from Quicken without any issues. That being said, the QIF file format was never really intended for transferring all data from Quicken to another program and as such it can contains inherent ambiguities that may need to be manually corrected post import. How much manual correcting needs to be done is hard to predict, as the Quicken export capabilities seem to vary with each version. Typically investment accounts fair worse that regular accounts in this matter.

    If there any features you feel would help you through this process, please advise and I can provide details of the necessary functions, or can create a suggestion ticket for the feature.

    Jenny
    Infinite Kind Support

  6. 6 Posted by dwg on 29 Apr, 2016 12:55 PM

    dwg's Avatar

    FWIW I migrated to MoneyDance some 4 years ago, with the version I was coming from I had to do it account by account - some 70 accounts in the end in order to get the entire history.

    Investment accounts were the main problem, partly because Moneydance does not have all the investment actions, partially due to the QIF filter in Moneydance ,and partially due to the fact that some investment actions are not transactions at all.

    The bottom line was that no matter what solution I went to a considerable amount of work was needed, only by staying with Quicken/Reckon could I avoid it. I felt that MoneyDance was the best solution at the time (though not perfect and not complete) and that it had the most promise for the future.

  7. 7 Posted by dmcneilly on 29 Apr, 2016 02:29 PM

    dmcneilly's Avatar

    Firstly, dwg, it's worth a lot to know someone has gone through this AND stayed with MD. I actually got through the portfolio yesterday and have correct, cost, current and cash. I don't really understand yet the difference between register and bank register but am just going to ignore the latter as it doesn't seem to impact balances.

    As I said above in post 4, now I am deleting transactions in accounts where the balance is wrong, and re-importing the activity, again. Problem is, of course, delete purchases with a credit account and it throws asset accounts off. Really don't see how this can end. If there were any way of seeing what other accounts change when I delete transactions that might help but other than printing the entire list of accounts with balances, I don't see any way of doing that.

  8. 8 Posted by dmcneilly on 29 Apr, 2016 02:43 PM

    dmcneilly's Avatar

    What will happen if I make account A 'inactive',then delete transactions in account B and it has splits that will affect account A?

  9. 9 Posted by dwg on 29 Apr, 2016 09:05 PM

    dwg's Avatar

    Having a bank register in MD was implemented to allow for those investment accounts that have the capability to be used like a bank account for example to allow for the writing of Cheques.

    It makes no difference if the account is inactive if you delete a transaction in one account that is a transfer to an inactive account the transaction is also removed from the inactive account.

    Often the reason for a wrong balance in an account is that no initial balance has been set, sometimes this come over in a QIF File as a transfer from a category or a hidden account in Quicken sometimes it doesn't, I would not expect you to have to delete legitimate transactions.

  10. 10 Posted by dmcneilly on 29 Apr, 2016 10:19 PM

    dmcneilly's Avatar

    Yes, I discovered the removal also happens. I am at a loss as to how to fix these accounts. I have now lost the correct cash balance in Portfolio.

    I am also at a loss as to how to change a view. In portfolio view, I have to have theMD window as wide as my screen allows because the Security Name column is so wide I cannot see the numbers columns. Is there something to turn on somewhere that allows resizing of columns?

  11. 11 Posted by Ben Spencer on 06 Jun, 2016 11:18 PM

    Ben Spencer's Avatar

    I am afraid it is not possible to manually resize the columns in the portfolio view of an investment account.

    Ben Spencer
    Infinite Kind Support

  12. System closed this discussion on 02 Oct, 2016 02:33 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