Jack of All Trades
  • Blog
  • Who I Am
  • Get In Touch
  • Blog
  • Who I Am
  • Get In Touch

YNAB Tracking of Mortgage and Equity

7/11/2017

 
Share
I wandered into a nice little way to keep track of my mortgage and the equity of our house inside of our budgeting software YNAB.  The primary goal for this was to factor in the equity in our house into our net worth.  YNAB has a nice feature inside the Reports tab that shows Net Worth.  It's fun to see the line on the bar graph escalate as your net worth increases.  
Picture
The last 12 months, showing a modest increase in Net Worth
Even though the line seems to be pretty flat, we are happy to see our debt, the orange bars, slowly dropping.  We are slowly chugging along and paying down car loan debt, then we will be attacking some school loan debt.  

So back to the tracking of our mortgage.  I added two accounts, both of which are Tracking accounts, not Budget accounts.  First, create your Mortgage account.  I don't use the auto import feature, because I like to see the large chunks of principal being paid down with our 15 year mortgage, by manually entering the amounts every month.  So once you create the account, enter the manual amount of principal on your loan.  
Picture
When you create this account, the principal amount will show up as a red number, because it's a debt or liability.  Next, we need to create an asset account in order to show the value of the house.  
Picture
Create another Tracking account, and I use the "Other Asset" Account Type.  This will create the positive number, to counter the negative number we created with the Mortgage.  As the loan is paid down, and the value of the house increases, this will show up in your Net Worth.  

How do you keep update the numbers?

Like I said, every month or two I'll jump onto my mortgage account website and find the amount of principal that was applied to the balance for that month's payment.  Our loan is through Wells Fargo, and their website is rather easy to navigate.  
Picture
Wells Fargo Payment Breakdown
This is our payment breakdown from our last payment.  We are 5 years into a 15 year fixed rate loan.  The reason I update the totals every month, is because I fall in love with this loan each time I update.  The large dollar amounts being paid down on the balance make the sacrifice worth the cost.  So this month, $681.49 was paid down on the principal.  I took that number and added to the "Inflow" side of the Mortgage Account register that we created.  
Picture
Principal payments
Every month, I'll jump into this account, "Add a transaction" and enter the principal amount into the account as an "Inflow".  This knocks the amount of the loan down, in turn, causing our Net Worth to increase.  

As far as the House Value account we created, I only change this occasionally, because house values don't increase noticeably month to month like the loan does.  We will compare our house to a recent sold house in the neighborhood, or look into a Zillow estimate, etc.  This part of the equation falls under some grey area, but estimates are close enough to feel confident.  
Picture
Above is the actual Net Worth graph, only showing the Mortgage and House Value accounts.  I love looking at this, especially seeing the $64k increase in Net Worth.  This is a great feature of YNAB and also a strong selling point for the 15 year fixed rate mortgage.  The first couple years were hard, but after that, we've been so happy seeing large dollar amounts coming off the principal.  Next month, we will be breaking below the $100k mark for our principal balance!  

Check out YNAB for yourself, we love it, and would recommend it for everyone!
Picture
Click icon for more information
Orlando link
6/24/2019 08:45:41 am

Hey,

I was looking on how to handle the value of the house vs the mortgage in YNAB and this helped.

Thanks!

Andy B.
6/24/2019 09:38:36 am

Great to hear, it's worked really well for me for the last couple of years. It's nice to see that Net Worth growing one mortgage payment at a time! Thanks for the comment!

HOMEiA link
8/1/2019 11:14:46 pm

Thanks for sharing great tool tracking of mortgage and equity.


Comments are closed.

    Author

    Jack of All Trades, Master of None


    Archives

    February 2018
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    AirBNB
    Bourbon
    Chicago
    Finance
    Fire Department
    Food
    Guns
    Hawaii
    Hunting
    Kentucky
    Lipsense
    Music
    NBA
    Notre Dame
    Paramedic
    Podcasts
    Politics
    Recommendations
    SCUBA
    Sports
    Travel
    Whiskey
    YNAB

    RSS Feed

Proudly powered by Weebly