Loan account

pierson949's Avatar

pierson949

17 Apr, 2009 02:15 AM

I have imported my data from Quicken PC, and mostly it has gone pretty smoothly. I have several loan accounts, but the import just puts them in a "liability" account. How do I get Moneydance to make this a "Loan" type account?

  1. 1 Posted by Brian Adler on 22 Apr, 2009 06:28 PM

    Brian Adler's Avatar

    Hello, You should import account-info-only. Then delete the liability account and create a loan account with the exact same name. Then import again. Sincerely, Brian

  2. Brian Adler closed this discussion on 22 Apr, 2009 06:28 PM.

  3. pierson949 re-opened this discussion on 23 Apr, 2009 11:21 PM

  4. 2 Posted by pierson949 on 23 Apr, 2009 11:21 PM

    pierson949's Avatar

    Well, that would have been nice to know BEFORE I imported the data. Is there any way to move the transactions which I have imported to the liability accounts over to the loan accounts?

  5. 3 Posted by Brian Adler on 30 Apr, 2009 04:55 AM

    Brian Adler's Avatar

    Unfortunately, there isn't a simple way to do this. I believe your best option at this point is to create a new Moneydance file and repeat the import process.

  6. 4 Posted by pierson949 on 01 May, 2009 03:45 PM

    pierson949's Avatar

    This is not good news. I have already started using this file and have downloaded transactions, written checks etc. Starting over is not a good option. Is there a way to delete the liability accounts and re-import? They don't have much activity since I started using the file, whereas my checking and investment accounts have enough that it would be a real pain to have to re-enter data.

  7. 5 Posted by Steve on 01 May, 2009 10:14 PM

    Steve's Avatar

    There is a way to change from liability to loan account.... I had same problem a year ago and there was a thread on the forum to resolve. Now that the forum has moved I don't know where to get the info.... I believe you have to rename your .md file to .txt. Here's where I can't remember the exact process but you find a line that has a letter for liability and change it with a letter for a loan account. Sorry I can't remember the exact process but I know the developer(s) can direct you to the process. Don't give up hope there is a resolution. .....Steve

  8. 6 Posted by Steve on 01 May, 2009 10:49 PM

    Steve's Avatar

    I just searched my documents and found I had saved the process to change account type:

    How can I change an account's type after it's been created? ¶

    The type of an account can be changed after being created in Moneydance by following these steps: 1) Export your data to an XML file using the File->Export menu and choosing the Moneydance XML option. 2) Edit the exported file in a text editor. Search for the name of your account and you should see a section like this: {{{ B My Account 110 8 1020.00 ...}}} 3) Change the letter in the field to the correct letter and then save the file. Valid types: A = Asset; B = Bank (checking or savings); C = Credit Card; V = Investment; L = Loan; Y = Liability; S = Security; E = Expense; I = Income 4) Open the edited file in Moneydance by selecting the File->Open menu and choosing the XML file. Note: The file may need to have the ".xml" extension in order for Moneydance to be able to open it.

    Good Luck-- Steve

  9. 7 Posted by pierson949 on 02 May, 2009 02:31 AM

    pierson949's Avatar

    This looks promising. I just did as you said, but Moneydance doesn't want too open the .xml file, and doesn't have an option for importing it. I am tempted to just change the file extension and see if it will open. What can possibly go wrong, right???

  10. 8 Posted by pierson949 on 02 May, 2009 04:09 AM

    pierson949's Avatar

    Moneydance won't open the file with either the .xml or the .md extension. Pinwheel just spins for a long time, then quits, without anything happening.

  11. 9 Posted by Steve on 02 May, 2009 10:48 AM

    Steve's Avatar

    After exporting the original file ( .md ) to ( .xml ) edit it using a text editor .

    as stated in step 2 Edit the exported file in a text editor.

    When edited and saved then rename file back to the original .md extension and reopen in MD.

    Steve

  12. 10 Posted by pierson949 on 02 May, 2009 02:18 PM

    pierson949's Avatar

    I've tried that several times. I suspected that maybe the problem was encryption on the original file, so I removed the encryption, re-exported, edited, saved, renamed. On trying to open I finally got an error message:

    Cannot launch java application Uncaught exception in main method: java.lang.OutOfMemoryError: java heap space

    Do I have corruption in my original file? Or do I have a different version of MoneyDance than you used?

  13. 11 Posted by pierson949 on 04 May, 2009 01:31 PM

    pierson949's Avatar

    I see that the above procedure has been posted to the FAQ section, so I am assuming it should work. I find that the info for each account is slightly different than that shown in the procedure. What I have looks like this:

    </ACCTPARAMS>
    <SUBACCOUNTS>
    </SUBACCOUNTS>
    
    <TYPE>Y</TYPE>
    <NAME>Homeside Mortgage</NAME>
    <ACCTID>41</ACCTID>
    <CURRID>42</CURRID>
    <STARTBAL>0.00</STARTBAL>
    <ACCTPARAMS>
     <PARAM>
      <KEY>gui.col_widths</KEY>
    

    On the seventh line I have been changing the "Y" between to an "L". Is that correct?

    I have tried saving the changed file, and renaming it to have the .xml extension and also tried the .md extension. Moneydance recognizes the file and tries to open, but hangs. One time I got the Java error noted above. What am I doing wrong?

  14. 12 Posted by pierson949 on 04 May, 2009 10:47 PM

    pierson949's Avatar

    OK!! I finally have a solution. Mary's (Is this method to change account type OK?) method works just fine. Why has it taken so long to get an answer on this? Anyway, thanks Mary.

  15. 13 Posted by Steve on 05 May, 2009 01:01 PM

    Steve's Avatar

    Sorry for not responding....

    I've been in Europe for a few days.....

    Glad to see you got your problem solved.....

    Steve

  16. 14 Posted by Brian Adler on 06 May, 2009 09:35 PM

    Brian Adler's Avatar

    I apologize for the delay in replying to this issue. Please let us know if there is something still unresolved.

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