Net Worth Reporting over time

Matche87

I am a new Quicken Deluxe user (R19.44) and only have about 3 months of my financial data in Quicken so far.

I am trying to setup a net worth report by month using the standard net worth report provided by Quick. I set the date range to <Custom Dates> for the months I know I have data and the interval to <month>.

When the report displays a couple of things happen:

(1) Previous months show "$0.00" in all account types except the investment accounts and those all have the exact same value for each month I ask the report to display when I know the value is different each month. The is true for all the months except for the last month if I set the end custom date to today's date. The today's date net worth data is correct.

(2) The report only shows accurate net worth if I set the end custom date to today. If I set the date to any date outside of today my home value goes back to the original price I purchased it for not the current value of the home or the value of the home at the date specified in the custom date field.

Any help would be very much appreciated.

NotACPA

Do you have data, in the other non-investment accounts, that goes back prior to last month?

Have you included all categories, and all accounts in your Net Worth report?

What happens if, instead of a custom date, you pick "Last Quarter" or "Year to date" or something like that as the time period?

Jim_Harman

Also the numbers in the Net Worth report for your investments depend on Quicken having accurate share prices for your securities for the end of each month or whatever period you are using.

Quicken can download up to 5 years of historical prices for most publicly traded securities. Go to Investing > Download Activity > Historical prices to do this. The interval between the dates for the downloaded prices gets longer as you go back in time.

Ps56k2

Matche87 said:

I am a new Quicken Deluxe user (R19.44) and only have about 3 months of my financial data in Quicken so far.

ok- a couple of points....
- are you using One Step Update and downloading all your info - or doing it manually -
- Banking - need to have current online balances - and all recent transactions -
- Investments - need it have your Security List - and all quotes/prices for "history"  along with all your recent transactions... buy/sell/divs
- Home - just curious, how have you included your home - and "current value" -

NotACPA

Do you have data, in the other non-investment accounts, that goes back prior to last month?

Have you included all categories, and all accounts in your Net Worth report?

What happens if, instead of a custom date, you pick "Last Quarter" or "Year to date" or something like that as the time period?

Jim_Harman

Also the numbers in the Net Worth report for your investments depend on Quicken having accurate share prices for your securities for the end of each month or whatever period you are using.

Quicken can download up to 5 years of historical prices for most publicly traded securities. Go to Investing > Download Activity > Historical prices to do this. The interval between the dates for the downloaded prices gets longer as you go back in time.

Ps56k2

Matche87 said:

I am a new Quicken Deluxe user (R19.44) and only have about 3 months of my financial data in Quicken so far.

ok- a couple of points....
- are you using One Step Update and downloading all your info - or doing it manually -
- Banking - need to have current online balances - and all recent transactions -
- Investments - need it have your Security List - and all quotes/prices for "history"  along with all your recent transactions... buy/sell/divs
- Home - just curious, how have you included your home - and "current value" -

Matche87

Thanks everyone for your responses - they have been very helpful!!

It turns out some of my accounts did not download transactions as far back as I thought and as a result my net worth report was doing funky things.

I ended up starting with a single backing account and building up from there by adding one account at a time to see where there were gaps. By doing this I was able to identify accounts that didn't have the account balances and transactions as far back as I wanted to look.

For home value it turns about Quicken defaults to either the original purchase price or the value as reported in your transaction ledger. In my case since I didn't have home values for past months so I was seeing the original purchase price.

For the home value I do an <update balance> at the start of each month.

I also took Jim's advice and downloaded historical pricing which helped.

For my homes there is still something going on when I include my mortgage account. I will figure that one out eventually.

Thanks again!