[GNC] how to track home equity with mortgage loan Gnucash 4.2

[pyz01 at cox.net]

Sorry - forgot to copy the group

 

From: pyz01 at cox.net <pyz01 at cox.net> 
Sent: Sunday, October 11, 2020 6:30 PM
To: 'Nathan Falco' <anasteso1454 at hotmail.com>
Subject: RE: [GNC] how to track home equity with mortgage loan Gnucash 4.2

 

z- Increase or Decrease in Assets  (main account) 

  Property value increase or decrease (sub account) 

 

Ps - named such since the property value can increase or decrease.   I also
have in this account group the Opening / Beginning balances sub account for
when I start a new account. 

 

Let me know if that makes sense. 

 

Ken  

 

From: Nathan Falco <anasteso1454 at hotmail.com
<mailto:anasteso1454 at hotmail.com> > 
Sent: Sunday, October 11, 2020 5:56 PM
To: pyz01 at cox.net <mailto:pyz01 at cox.net> 
Subject: Re: [GNC] how to track home equity with mortgage loan Gnucash 4.2

 

ok. that helps some. so when you go to update the value of your property in
the subaccount, what other account do you use for the double-entry? keeping
things easy is what I want to do, I just get hung up on that question.

 

  _____  

From: pyz01 at cox.net <mailto:pyz01 at cox.net>  <pyz01 at cox.net
<mailto:pyz01 at cox.net> >
Sent: Sunday, October 11, 2020 4:00 PM
To: 'Nathan Falco' <anasteso1454 at hotmail.com
<mailto:anasteso1454 at hotmail.com> >; gnucash-user at gnucash.org
<mailto:gnucash-user at gnucash.org>  <gnucash-user at gnucash.org
<mailto:gnucash-user at gnucash.org> >
Subject: RE: [GNC] how to track home equity with mortgage loan Gnucash 4.2 

 

Nathan --  I think you might be overthinking it a little.  Here is a neat
trick that may help --  Here is what I did:

My Home - Property (Equity)  ---- main account  -- no entries
  Property value (subaccount)  --- only periodic entries when I want to
evaluate value of the property (adjust up or down)
  Mortgage Loan (subaccount)  -- entries are the mortgage split entries that
I split between account I pay from (increase) and the principle decrease
(this account) and the interest expense -decrease

At any point in time -- the "My home properties (Equity) account shows the
equity in the property.  The property sub account shows the values as of the
last time I updated the value.  And the mortgage loan shows the outstanding
principle balance on the loan. 

Easy -peasy -- and I'm letting Gnucash do the math for me! 

Hope that helps. 
 
Ken 

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+pyz01=cox.net at gnucash.org
<mailto:gnucash-user-bounces+pyz01=cox.net at gnucash.org> > On
Behalf Of Nathan Falco
Sent: Sunday, October 11, 2020 1:34 PM
To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
Subject: [GNC] how to track home equity with mortgage loan Gnucash 4.2

Hello,

I am a "knee deep" Gnucash user meaning I have a fair grasp of the basic
accounting principles and functions of the program. I successfully added my
house as a fixed asset, and added my mortgage as a liability. I have also
set up my mortgage payments as a scheduled transaction between my checking
account, liability account, and expense accounts.

It really bugs me that my home equity account only shows the appraisal value
of my home and the original loan principal balance. Every time I make a
mortgage payment I am reducing my liability and thus increasing my equity. I
cannot figure out how to track that. For argument sake let's use this
example:

Fixed Asset Opening Balance:
Fixed Asset: First home ($200,000 appraisal value)
Liability: 30 year mortgage ($150,000 principal balance)
Equity: Initial Home equity ($50,000 net value)

Monthly mortgage payment:
$1,000 debit: checking account
$600 credit: loan interest and escrow fees
$400 credit: mortgage loan principal balance

What I want to see happen when the first mortgage payment is recorded:
Fixed Asset: First home ($200,000 appraisal value) Current Asset: Checking
account debit ($400 toward loan principal)
Liability: 30 year mortgage decrease ($149,600 principal balance)
Equity: Initial Home equity increase ($50,400 net value)

If I credit the Home Equity account once per month, what account is missing
for me to debit?
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.