Manually adjust market value of main home

treasur2

I get to spam by request. Zillow and Redfin. They are hugely different. So I add them together and divide by 2 to get the average and to manual entry—tedious & time-consuming.

Does anyone have a smarter/different way to automate this?

Quicken Kristina

Hello @treasur2,

Currently, Quicken for Windows offers Zillow as a way to get automated property value updates. See this article for more information:

https://info.quicken.com/win/about-adding-property-and-debt-accounts

If you are wanting a different automated process added into the Quicken program, then I would recommend creating an Idea post detailing what you want to see. For information on creating an Idea post, please see the post linked below.

https://community.quicken.com/discussion/7849425/creating-and-voting-for-ideas-in-the-community

Ideas that get enough votes may be implemented in the future!

If you're looking for an automated process outside of Quicken, I'm not aware of any 3rd party tools that would fully automate the process for you. Many spreadsheet programs let you set up formulas that would do the math part for you, but you'd likely still need to manually fetch the updated values to input into the spreadsheet and then update Quicken with the newly calculated number.

I hope this helps!

Quicken Kristina

Hello @treasur2,

Currently, Quicken for Windows offers Zillow as a way to get automated property value updates. See this article for more information:

https://info.quicken.com/win/about-adding-property-and-debt-accounts

If you are wanting a different automated process added into the Quicken program, then I would recommend creating an Idea post detailing what you want to see. For information on creating an Idea post, please see the post linked below.

https://community.quicken.com/discussion/7849425/creating-and-voting-for-ideas-in-the-community

Ideas that get enough votes may be implemented in the future!

If you're looking for an automated process outside of Quicken, I'm not aware of any 3rd party tools that would fully automate the process for you. Many spreadsheet programs let you set up formulas that would do the math part for you, but you'd likely still need to manually fetch the updated values to input into the spreadsheet and then update Quicken with the newly calculated number.

I hope this helps!

Boatnmaniac

@treasur2 - Are you actually entering a manual transaction to update the value in the register?

If so, there is an easier way to get the balance updated. Above the register and on the right is a Gear icon. Click on that and then click on Update Balance. That will open a popup where you simply enter the new average house value and then click on OK. That will enter a transaction into the register without you needing to manually enter it yourself. It's still not ideal but it is a little less tedious.

Another thing you might want to try doing is to set up a simple Excel spreadsheet with 4 columns for: Date, Zillow, Redfin and Average.

In the Average column enter a simple formula: (Zillow value + Redfin value)/2. Copy that formula down the spreadsheet a ways.

Then enter the date in the Date column and enter the Zillow and Redfin values in those columns. The average value will be automatically calculated. Copy that calculated average value and paste it into the Update Balance popup. Then save the file for the next time you want to update your house value in Quicken.

I use this process for updating the value of my 3 vehicles and boat. Once it is all set up the process goes pretty quickly.

Rocket J Squirrel

The value you really need to track is the cost basis of your home. This is important for tax purposes when you sell the house. Any online "value" of your home is just a guess. The real value is what someone will buy it for.

I split the value of my home into 2 Quicken accounts: 1 tracks the actual basis and 1 tracks the approximate appreciation (i.e., Zillow's guess minus the basis or Redfin if you prefer).

NotACPA

I keep the value of my house all in a single Q account … but I use Tags to differentiate between "Market Adjustment" and other changes in the value.