SXs for mortgage druid not paying attention to 'i' value

Donald Allen donaldcallen at gmail.com
Wed Feb 10 10:19:23 EST 2010


Beth --

I started a new thread this morning with the message below and then
noticed your post, which I believe is describing the same (or related)
problem that I did. The two threads should be consolidated, so let's
use yours, since you got here first :-)

/Don

My message from earlier this morning:

I am running Gnucash 2.2.9 on an up-to-date Arch Linux system. The
payment of my home mortgage is entered into Gnucash by a scheduled
transaction. The problem is that the scheduled transaction does not do
the mortgage amortization correctly, though that is what I intended
when I set it up and it did work for awhile.

I refinanced my mortgage on 5/1/2004, a 10-year fixed-rate mortage at 4.625%.

The Overview tab of the scheduled transaction shows the Enabled and
Create automatically boxes checked. In the Occurrences section, the
Until radio button is selected, with the date set to 5/1/2014.

The Frequency tab has the frequency set to Monthly, start date =
5/1/2004, every = 1 months, on the 1st.

The template transaction looks like this (I’ve substituted x for the
original amount of the mortgage for privacy reasons):

Description
 Tot debit       Tot credit
Mortgage payment - Payment      Assets:Checking         n
         pmt( 0.04625 / 12 :
120.00 : x : 0 : 0 )
Mortgage payment - Principal    Liabilities:Mortgage            n
 ppmt( 0.04625 /
12 : i : 120.00 : x : 0 : 0 )
Mortgage payment - Interest     Expenses:House:Mortgage int.    n       ipmt(
0.04625 / 12 : i : 120.00 : x : 0 : 0 )

(Apologies for the alignment, if it doesn't look right. Tabs are a
problem in Gmail. The formula for the payment is in the Tot credit
column, those for the Principal and Interest are in the Tot debit
column.)

What is happening is that every month, I get an automatically
generated transaction where the principal and interest payments are
those that would be correct if the payment were dated 3/1/2008. So I’m
getting this constant 3/1/2008 payment every month and every month I
go in and fix it, having calculated the correct amortization
separately.

This would appear to be a bug, though it’s certainly possible I’m
doing something wrong.

Ideas?

/Don Allen


More information about the gnucash-user mailing list