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

[Scott Zahn]

On Sat, 6 May 2006, Edward Reid wrote:

> Date: Sat, 06 May 2006 10:57:43 -0400
> From: Edward Reid <edward at paleo.org>
> Reply-To: General discussion related to Moneydance
>     <moneydance-info at moneydance.com>
> To: General discussion related to Moneydance <moneydance-info at moneydance.com>
> Subject: Re: [moneydance] QMac->MD: loans become liabilities?
> 
> 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.

Honestly, the way I switched to MD is that I made a giant QIF of all my 
accounts in Quicken and checked every box on the export dialog except the 
one that mentions a macintosh.  I then imported everything all at once 
into MD, converted the liabilities into loans, and then matched up the 
balances of the accounts between the two programs.  It took a weekend of 
tracking down duplicate entries, etc., but they eventually matched.  Then 
I started hunting down the small stuff (getting rid of "X" accounts, 
entering in account details, etc).  That method worked well for me, but I 
only had 11 accounts or so.

> 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?

Yeah, you can't edit loan entries in the loan accounts.  Go to the account 
where the payment was from and edit it there.  The loan register is only 
showing the principle amount from the split transaction.

> 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.)

Hmm... did you specify the number of payments in the loan account?  My 30 
year mortgage has 360 payments.  I think MD uses that to calculate your 
payment splits.  That's all that comes to mind on that one.

hope this helps,
Scott