Creating Reports and Graphs
Tim
via web
Have just downloaded Moneydance and am trying to figure out how to create reports/graphs, particularly for investment accounts. The Help line doesn't seem tell me. Can anyone?
Comments are currently closed for this discussion. You can start a new one.
2 Posted by Randy on 12 Mar, 2010 08:36 PM
Under the tools menu, graphs and reports. You can memorize them for future use.
Also on the side bar there are graphs and reports.
3 Posted by Tim on 13 Mar, 2010 07:51 PM
Thanks for this but I now find the program won't Open when I click on Moneydance.exe. Should I re-install? This is a real pain as I have to transfer 13 bank accounts and 12 portfolios from Money. Can this be done other than one by one?
Support Staff 4 Posted by Tom Freeman on 18 Apr, 2010 03:47 AM
Tim
Sorry for the late response. First, when you installed Money Dance, an icon should have been placed on your desktop. If that icon is not present and you can not open from Moneydance.exe your installation may have been corrupted and I suggest a clean install. If you have already created a data file you can save that to another folder and open it once the program is reinstalled. The data files should have a ".md" format.
As for batch importing from MSMoney, that has been tricky. Microsoft uses a lot of proprietary code and it make transferring, especially investment and loan files difficult.
One of our users developed a system for batch importing from MSMoney that I have included below, which many users have found useful. There was some tweaking here and there and I have included a link to the full discussion at the end of this response.
If this does not help please let us know.
Tom
1) Export all accounts to qif files from MSMoney. Give the files descriptive names so that you don't get confused later. Investement accounts will require two files, one for the investment transactions and one for the cash transactions. That's because MSMoney treats them as two separate accounts internally. Loan accounts cannot be exported. That's okay. You'll work around that limitation later.
2) Create the accounts in Moneydance before you begin importing the files. This is an important step. Make sure you name the accounts with the exact spelling used in MSMoney. You'll need to create two accounts in Moneydance for each investement account. One will be of type of "Investement" and the other will be "Bank". The bank account will contain the cash transactions from the investement from MSMoney. This is just a temporary account used for correctly importing the data. You will combine the transactions and delete this account later. Go ahead and create your loan accounts in Moneydance as well. Remember to use exact spelling or everything will get screwed up.
3) Import the qif files. Make sure you land each qif file into the corresponding account in Moneydance you created in step 2. Remember, to select the "Bank" account when importing the cash portion of the investement accounts. If you make a mistake (like importing into the wrong account) you'll probably need to start over so be extra careful. That's why you should give the qif files descriptive names in step 1. If done correctly every account will get populated with the correct transactions...even the loan accounts. There should not be any of those "Imported Account" accounts or categories. If there are then you've made a mistake.
4) Move all transactions from the temporary "Bank" accounts you created for place holders for the cash portion of the investment accounts from MSMoney into the one and only corresponding investment account in Moneydance. Delete the temporary place holder account in Moneydance. Moneydance will contain the cash transactions in the root of the investment account. That's the way it should be.
5) Edit the loan accounts in Moneydance. When you click done Moneydance will ask if you want to transfer the loan balance to another account. Select yes and choose the account that received the loan proceeds. This may be a checking account if it was an unsecured loan or it may be an asset account if there was an asset that was acquired. You may need to modify the transaction later to account for closing costs, etc.
6) Organize your accounts and categories the way you want. The Find and Replace extension can be very useful in changing the categories of a lot of transactions at once.
7) You may need to make a few balancing entries in some of the accounts to get things balanced correctly. That's because MSMoney is not a double-entry system and so things aren't required to balance there.
8) Relax and feel good knowing that are now liberated from MSMoney.
Full discussion: http://help.infinitekind.com/discussions/problems/114-importing-dat...
Angie Rauscher closed this discussion on 24 Jul, 2011 07:45 PM.