Throughly cheesed off with Moneydance 2010
I've just bought the new Moneydance 2010 because I thought I would actually be getting a program that worked. I'd previously been using Moneydance v3 and though it about time I catch up. What a disappointment.
All I want to be able to do is import my multiple accounts and the transactions contained within them into a new file and I can't. I've tried every which way I can think off, but every time I export to qif from my old MD accounts, and then import into the new version I am confronted with the same problem: all the transactions go into one account! What use is that!
Do I really have to reenter all of my information to get the transactions into the right accounts? What is the point in having an import/export feature unless its going to keep the data in the same original accounts. I am so annoyed. I've spent so much time playing around with MD and trying to get it to do simple things; maintaining account integrity, keeping the chart of accounts etc. I'm regretting wasting my money on such a product.
Maybe its me just being stupid, but I've checked your help pages and it all seems to confirm that when you have multiple accounts in MD you can't export them in qif without losing their integrity. A very serious weakness.
Please, if there is anyway to makes this work then please contact me. I am at a loss as to what to do and am currently facing having to rebuild the accounts transactions again. I think I would have been better not wasting my money.
Julia
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
1 Posted by Noname on 09 Feb, 2010 12:30 AM
Not sure I understand exactly, but is there a particular reason that you want to export and make new files? It is my understanding that you should be able to open your old files in the new MD2010 without any problem. If you really just want to open your current files in 2010 then you should be able to just select the .md file under Open file. Once it's opened in 2010 you can rename it and save it if that is what you'd like to do. If this isn't what your intent is, please post again.
2 Posted by Julia on 09 Feb, 2010 12:42 AM
You are correct - that is what I want to do...but...
When I was using v3 there was no archive function so I created separate db for each year. The down side of that was that I lost the Chart of Accounts structure and had to re-create it all the time. I have previously tried to ask for a solution to this but was told that the best thing to do was just archive the previous years...
This brought me back around to upgrading, which I did, only to find that if I wanted to get all of my files in 'one' place, thereby retaining the chart of accounts structure, all transactions where merged into one account.
I just don't understand why the qif export has to merge all the data? It renders it a useless and clunky feature.
So I'm now left with a piece of software that is no improvement to what I was using, but I'm slightly poorer for the experience. All I wanted was to get everything sorted and working well.
3 Posted by Noname on 09 Feb, 2010 12:56 AM
I see what you're grappling with but I'm afraid that I don't have the knowledge needed to help you with this. Hopefully someone from MD Support will look in and offer some solutions. Sorry I couldn't help.
4 Posted by Randy on 09 Feb, 2010 01:14 AM
If by Moneydance v3, you mean MD2008, then yes MD2010 can directly open those files.
If you open one of them, does your chart of accounts show up?
If so, you could open one of them and import qif files from the others into that one, and preserve your chart of accounts.
When you import, the correct choice should be "from another program", even though the "other" program is another version of Moneydance. The other choice is for importing qif files that you download from a bank.
5 Posted by Julia on 09 Feb, 2010 11:57 AM
Hi Randy,
The version I was using was the 2003 version. If I open up the 2008 file then the Chart of Accounts are correct, however I wasn't able to copy over that format for the 2009 one so would have to do it manually: a tedious task.
I know that I can open any of the files with MD2010 - the problem lies in trying to get them to all work properly as one! I've already tried on several attempts to import the qif for the 2008 and 2009 files into one new MD2010 file and every time it loses the account integrity, lumping all transactions into one account when there are six different accounts.
So, the 2008 file has the correct Chart of Accounts but when I try to import the transactions they go to one account only. Is there a way of importing data without losing the accounts structure? If not, why not?
My added frustration is that I lost the contents of my harddrive and have had to rebuild my account twice now - so I think that is probably why I am doubly frustrated.
Thank you for your help.
6 Posted by Angie Rauscher on 10 Feb, 2010 12:36 AM
Julia,
When you are importing your QIF, are you making sure to select the "From Another Program" option as the file source? This may resolve the issue. If it does not, please do let me know, and include your OS, the build of Moneydance 2010 you are using, and the version of Java you are running. You can find out your version by going to the Help Menu and choosing the About Moneydance option.
I apologize for the inconvenience and frustration this has caused you,
Angie Rauscher
Moneydance Support
7 Posted by Julia Gear-Evan... on 10 Feb, 2010 09:01 AM
Hi Angie,
I have been using the "from another programme" option but its still been putting all transactions into the one account. Is this happening because its importing qif's from the 2003 version?
I'm using Mac OS5.8, Java 12.5 and Moneydance 2010 vBeta which is what I was directed to download when I bought the upgrade.
Really hope you can help sort this out for me as I don't fancy manually rebuilding everything again.
Yours hopefully,
Julia
________________________________
From: Angie Rauscher <[email blocked]>
To: [email blocked]
Sent: Wed, 10 February, 2010 0:36:18
Subject: Re: Throughly cheesed off with Moneydance 2010 [Problems]
8 Posted by Julia on 10 Feb, 2010 01:46 PM
Just checked and I'm actually using Moneydance 2010r2(735)...
9 Posted by Ben Spencer on 10 Feb, 2010 03:18 PM
Hi Julie
It sounds like there might be a problem with your qif files would you be willing to email one of them to me.
[email blocked]
I will have one of the developers take a look at the file and diagnose the problem.
Sincerely
Ben Spencer
10 Posted by Randy on 10 Feb, 2010 05:19 PM
Julia, when on the import screen, there is a line that says "Import to" and you choose "Existing Account" , then pick the one you want the data to go to from the dropdown list next to the word "Existing Account".
Is this what you do? And you pick a different account when appropriate?
11 Posted by Julia Gear-Evan... on 10 Feb, 2010 06:24 PM
Hi Randy,
No I choose to create new accounts as if you try to choose an existing account then everything ends up in there, and there is no way to select multiple accounts. In fact you can't export accounts separately so it wouldn't help to try to import into each separate account as then I'd end with all the accounts having the merged transactions.
________________________________
From: Randy <[email blocked]>
To: [email blocked]
Sent: Wed, 10 February, 2010 17:19:33
Subject: Re: Throughly cheesed off with Moneydance 2010 [Problems]
12 Posted by Randy on 10 Feb, 2010 07:06 PM
Julia, I think I finally understand your issue. Here is a "workaround" that will involve some work, but would surely be better than having to rekey everything.
You may want the Moneydance staff to comment on this before trying it (I haven't had the need to test this, but in theory it looks like it would work).
There is an extension called "find and replace". Get that and install it, if you don't have it all ready.
Load one of your old files in MD2010.
Go to one of the accounts in the file
Create a transaction tag that is named similar to (or exactly) the same name as the account name for the account you just loaded.
using the find and replace extension you can "find" all transactions in this account in the file and "add" a tag (the new tag you just created in step 4 above). The find and replace extension will do this in one operation.
repeat step 5 above for each account in the file
now you can perform the export.
Create a new file in MD2010. In that file create an account named "big file". Import the qif file created in step 7 to the "big file" account in this new file. Be sure to use the two pass process (first time choose the option "Account info only" and second time uncheck the box "Account info only"
Go to the register for the "big file". Type in the search box at the top the name of the tag created in step 4. You should get just a list of transactions that have that tag.
Hit ctrl - a to select all these transactions, then right click and choose "batch change -> account" and pick the account with the same name as the transaction tag created in step three. All the selected records should be moved to the account you chose.
repeat step 9 for all accounts, at the end the "big file" account should not have any transactions in it.
You would have to repeat these steps if you have multiple files per year, one time for each year.
After you finish converting everything, you could also use the find and replace extension to remove the tags, if you no longer need them.
Angie Rauscher closed this discussion on 24 Jul, 2011 07:25 PM.