[moneydance] QMac->MD: loans become liabilities?

Edward Reid edward at paleo.org
Sat May 6 10:57:43 EDT 2006


At 00:08 05/05/06 -0400, Scott Zahn wrote:
>Then go to File -> Export and export your data as XML.  Then open it with
>your favorite text editor (like notepad, not Word).  Find each Loan
>account and change the account type to L.  Then save the file and open
>moneydance.  Go to File -> Open and open the XML file you just edited.  I
>believe the loans will then show up as loans and you can go into those
>accounts and edit the details about them.

Thanks. This seems to have mostly worked. But ...

First I tried correcting the account type after I imported all the setup 
info (accounts etc) but before I imported the transactions. The setup 
looked good before the transaction import -- the liability accounts were 
gone and all had become loan accounts. But when I imported the 
transactions, the liability accounts re-appeared, and it looks like 
payments were duplicated. Or something, I didn't completely figure it out. 
The liability accounts ended up with the balances the loan accounts should 
have had, and the loan accounts had much larger balances. It was a mess. 
Clearly not the right method.

So then I started over from scratch, imported the setup, imported the 
transactions, and changed the account types. So far so good -- have loans 
rather than liabilities, and the register is close to being OK -- a few 
errors but easily within range of fixing by hand. And I can enter the loan 
details. But ... the loan registers are not editable. !?!?!?!? I click on a 
transaction and instead of being normally selected, it gets a gray 
background. No amount of clicking or double-clicking makes it editable. 
Right-click is inactive. Meanwhile, all other accounts are acting normal. 
Any idea what's going on?

Beyond all that, when I did get the loan set up, I went on to set up the 
reminder. When I did, MD said the interest on my first payment was going to 
be twice what it actually should have been. For example, loan amount 
$20,000, interest rate 6%, one payment every month, MD said the first 
payment would include $200 interest. It's not a general loan problem, since 
if I set up a loan from scratch with the same numbers, the interest is 
correctly calculated as $100. Again, any ideas? (On this loan, I was just 
setting it up to start with the current balance, since I didn't have the 
original numbers easily accessible.)

If I can even figure out why these anomalies occur, I'll be happy to try to 
figure out how ti fix them in the XML file. But on these two, I don't even 
know where to start.

Edward
Art works by Melynda Reid: http://paleo.org



More information about the moneydance-info mailing list