Home → Problems →

Un-recorded downloaded transactions

• Edit

mgc0424

07 Apr, 2009 09:37 PM

I'm already locked out of Moneydance 2008 r3 (631) after several attempts to import file from Quicken 2006 (running under Windows 2000 v5.00.2195 SP4). In the first attempt I imported everything at once, but MD recorded several $USD accounts as $CAD accounts. Is this a bug? After Deleting the xxx.md file, I imported the account info only and had to manually change the incorrect $CAD accounts to $USD accounts. At the same time, updated each account default from 'advertising' to 'interest inc', 'dividend inc' etc and updated items that should not appear on main page quote section. After setting up the account, I tried to import the transactions, memorized payee list, etc, but only got part way through recording each transaction before I got the error I exceed the 100 transactions in the trial version. How do I proceed with loading the outstanding transactions so that I can properly evaluate MD? I'm considering switching from a Windows platform to Linux, but want to check out MD first.

Also, some suggested enhancement to the home page - when displaying the account info, the currency should also be displayed if different from the base currency. - in the investment section, add separation between the nbr of shares and stock code - in the stock price section, include the time of the last update - new account category for 'collectibles' and ability to 'hide' from the home page / quote regardless if account is 0 or not

1. 1 Posted by mgc0424 on 08 Apr, 2009 06:34 PM

   

   Hi Ben,

   Sorry for the duplicate posting. I didn't receive a successful response to the initial posting and couldn't delete the duplicate. Thank you for responding in the initial posting but I wished you left it open for just a bit longer. MD does have a problem with different currency accounts if you import from Quicken and select 'Import to new account' , 'File source is from another program' , 'Currency = Canadian dollar'. Accounts in US$ are set up as CA$ and you cannot change the account's currency because there are transactions recorded. After reading 'Chapter 16 - Advanced topics - Preparing MD for Quicken import', I realized I needed to set up the accounts first before importing the transactions. However, there is still a problem in your procedures. After deleting the xxx.md file, I imported from Quicken and selected 'Import to new account', File source is from another program', 'Currency = Canadian dollar', 'Import Account info only'. Again, Accounts that should be in US$ are set up as CA$ by MD, but at least now I can edit and change them to US$. These accounts are in US$ in Quicken, but if I understand the QIF file , I think it's not being transmitted (if I had the specs I would know the answer) (e.g. NUS Daily Interest Chequing Account TBank ^ NIBM TPort ^ !Type:Security NINTERNATIONAL BUSINESS MACHINE SIBM TStock ^

   Back to the setup. I've imported the accounts info to MD and manually corrected the currency and saved the file. Now to import the transactions. Since accounts are set up, I assumed the next step would be 'Import from Quicken', select 'Import to existing account' , 'File source is from another program' , 'Currency = Canadian dollar'. However, this imports all the transactions to the 'cash account' and not to their respective accounts. I exited MD without saving the updates, started MD again, but this time selected 'Import from Quicken', 'Import to NEW account' , 'File source is from another program' , 'Currency = Canadian dollar'. This time, the transaction went to the correct accounts. The Help documentation needs to be updated regarding 'Import from Quicken' is a 2-step process and in both cases you need to import to NEW accounts.
   

   I got around the 100 transaction limit by deleting my xxx.md file, uninstalling MD, running Registry Mechanic to clean up the registry , then re-installing MD. However, this time after the account info phase was loaded, I did the minimal number of manual updates (e.g. before importing the transactions. only changed currency, and not 'do not display if 0 amount). Don't know how many transaction I have left, but now have MD in shape to evaluate.

   • Edit

2. 2 Posted by Brian Adler on 11 Apr, 2009 02:55 AM

   

   Hello, The reason you are encounter this issue is that exported QIF files are not able to distinguish currencies and so allow two different currencies in one file. So if you import your CAD accounts first and then your USD accounts, you should not encounter this issue.

   We will be updating and upgrading the file import process within Moneydance and the instructions in the help documentation soon.

   All of your suggestions are good ones. I will share/discuss them with Sean, our developer. Also, you can create new account categories by choosing the tools->edit categories menu.

   • Edit

3. 3 Posted by mgc0424 on 13 Apr, 2009 11:39 PM

   

   Please see the attachment. I've figured out a work-around, but can't seem to enter it here. Error = Body is suspected as spam.

   • aa_MD_problems.doc 74 KB
   • Edit

4. 4 Posted by Brian Adler on 16 Apr, 2009 03:15 PM

   

   M, Thank you for this extensive analysis. I am posting your reply in it's entirety here:

   Subject: Un-recorded downloaded transactions

   Hello Brian,

   I was able to locate some documentation on QIF and can see there are no 'key codes' to associate a currency to an account that is different from home/base.

   While comparing against my Quicken file. I noticed that historical prices for bonds were not being set up in the QIF file for import to MD. This was due to the inability to set up a 'stock symbol' in 'Edit Security Details' in Quicken was TYPE= BONDS. I figured out a work around by doing the following In 'Edit Security Details in Quicken:

   1. Set TYPE=OTHER

   2. Set 'SYMBOL= NAME

   (e.g. NAME of bond=BC GEN INT 04DEC10, SYMBOL=BC GEN INT 04DEC10

   1. Set TYPE=BONDS

   In the Quicken File drop-down menu, select Export to QIF.

   In the QIF pop-up window,

   1. Set up 'QIF file to Export to': path \ name of file

   2. Set up 'Quicken Account to Export from' = 'All accounts'

   3. Set up 'Include Transactions in Dates' = from / to dates

   4. Set up 'Include in Export' = 'Security Lists'

   5. Click OK.

   Once the QIF file is created but before importing to MD, do the following:

   1. Change the file extension from QIF to TXT

   2. Edit the file using an editor like Notepad and delete irrelevant data so that you only have historical quote prices for your bonds. In my example, the following 3 lines of data exists for every day of historical data (with obviously the price and date changing)

   2a. !Type:Prices

   2b. "BC GEN INT 04DEC10",0.693," 4/30' 3"

   2c. ^

   1. Save your changes

   2. Change the file extension from TXT back to QIF

   Before Importing the QIF file into MD, click on Tools-Edit Securities and for EACH bond that you will be importing historical prices:

   1. Highlight the security in the 'Edit Security' pop-up window and click EDIT

   2. In the 'Currency/Security History' pop-up window click Edit

   3. In the 'Edit Security' pop-up window, set the TICKER SYMBOL= SECURITY NAME (in my example BC GEN INT 04DEC10)

   4. Click OK to close 'Edit Security' pop-up window

   5. Click DONE to close 'Currency/Security History' pop-up window.

   6. Repeat steps 1-5 for other bonds that require a ticker symbol

   7. Click DONE to close the 'Edit Security' pop-up window.

   Now the bond securities in MD are ready from the historical prices:

   1. Click on File-Import-Quicken Interchange Format (QIF)

   2. In the 'Choose QIF file to Import' pop-up window, select the QIF file you create in the previous steps

   3. In the 'Import QIF file' pop-up window:

   3a. Set Import to = New Account

   3b. Set File Source = From another program

   4, Click OK.

   Historical prices are imported to MD (I believe there was a pop-up window with the number of entries processed).

   While going through all of this, I came across a couple of other things. Since the stock exchange that a security is listed on doesn't come across from Quicken, some securities may be getting the wrong quotes. For example, Miranda Gold is MAD, but MD is getting quotes for Madeca S.A. Once I changed the stock symbol to MAD.V, I started getting the correct quotes.

   Also, my set would seem to freeze for a few seconds. It turns out it occurs when the ''Exchange Rate Downloader' extension was running. It would be nice if it behaved like the 'Stock Quote Synchronizer', whereby you see a status of its progress at the bottom of the screen.

   I've recorded my findings for the benefit of others and update of the Help documentation. As far as I'm concerned, you can close the problem ticket.

   M

   • Edit