Home Page link  

Any way to get net worth details BY DAY?

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Any way to get net worth details BY DAY? Gary 10-08-2007
Posted by Andrew DeFaria on October 9, 2007, 12:02 pm
Please log in for more thread options
 This is a multi-part message in MIME format.
--------------080201050507070905020609
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

John Pollard wrote:

> But the statement you quote here was indeed, a strong influence on my
> choice of approaches: that and the fact that investment accounts pose
> a more difficult "reconciliation" problem, so
> perhaps outside advice might provide more benefit in the investment
> account realm.
John, of course. Stop being defensive. I was just pointing out what I
believe to be a more complete picture...
--
Andrew DeFaria <http://defaria.com>
If mother always knows best...What happens when two mothers disagree?


--------------080201050507070905020609
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
John Pollard wrote:
<div class="moz-signature"><br>
<small><font color="#999999"></font></small></div>
the statement you quote here was indeed, a strong influence on my
choice of approaches: that and the fact that investment accounts pose a
more difficult "reconciliation" problem, so <br>
perhaps outside advice might provide more benefit in the investment
account realm.<br>
</blockquote>
John, of course. Stop being defensive. I was just pointing out what I
believe to be a more complete picture...<br>
-- <br>
<a moz-do-not-send="true" href="http://defaria.com">Andrew DeFaria</a><br>
<small><font color="#999999">If mother always knows best...What happens
when two mothers disagree?</font></small><br>
<br>
</body>
</html>

--------------080201050507070905020609--

Posted by JM on October 9, 2007, 9:34 am
Please log in for more thread options
> I have found a huge jump, over 11%, in my net worth between 9/29/2007
> and 10/9/2007. In an effort to understand where and when it is coming
> from, it would be useful to be able to print account totals and total
> net worth for each day between those two dates. This way I could more
> easily understand where and when the increases are happening. This
> way I could validate whether the increase is a true increase because
> of market conditions or a generous error on my part.
>
> In the event a "daily" interval cannot be done (I couldn't figure out
> how), can someone suggest a debugging strategy that would make the
> where and when of the increase more apparent?
>
> Thanks in advance.

You can get a Net Worth Report for any given day - you can not get a
single summary report with one day intervals.

Run the Net Worth Report and customize to select "Custom dates" and
Interval "None". In the Date boxes, set the "To" date to the day you
want to see - ignore the "From" date. The report gives you your net
worth as of the "To" date. Repeat for each day you are interested in.

You can then copy/paste each daily report to Excel and construct a
report in Excel that presents a summary report by day for further
analyses.

Not real quick and easy but it will get you there.



Posted by R. C. White on October 9, 2007, 3:00 pm
Please log in for more thread options
Hi, Gary.

Start simple. You didn't say which version of Quicken you are using. I
have Q2008 Deluxe, but there should be only minor variations in whatever
version you have.

Click Reports | Reports & Graphs Center | Net Worth (under Net Worth &
Balances) | Show Report. This should show you - onscreen - the Net Worth
Report as of today (10/9/07). Then go back to that same screen and change
the date in "Report balance as of:" to yesterday, 10/8/07, and see if the
bottom number is unexpectedly different from today. Get the report for each
prior day until you see one that takes a big jump. Then print out the two
successive days and compare them.

If the unexplained increase happened gradually over the 10-day period, you
may have some sleuthing to do. But it more likely happened on a single
transaction on a single day, and you should be able to quickly identify that
one day. And, by comparing those two days line by line, you should soon see
which line - whether asset or liability or something else - took the big
jump. By then you know which account and which day, so the rest of the
solution should be almost intuitive.

If John's hunch is right - and it probably is - an even easier approach is
just to click the Portfolio button. If you don't already use a "today's
quotes" "View", you should be able to click Customize View... and create one
quickly enough. The important columns to include, of course, are
Quote/Price, Shares and Market Value; Day Change or Day Gain/Loss may also
help focus on securities that took a jump in value. The default is for
Portfolio to show today's numbers; note the total at the bottom of the
Market Value column. Then change the "As of:" date to yesterday, then back
one day at a time until you see the big change in Market Value and in the
day's gain/loss.

Quicken often fails to properly handle stock splits and other such
transactions, so watch for those.

Post back with details if you have more questions. And be sure to tell us
which version of Quicken.

RC
--
R. C. White, CPA
San Marcos, TX
(Retired. No longer licensed to practice public accounting.)
rc@grandecom.net
Microsoft Windows MVP
(Currently running Quicken 2008 Deluxe in Vista Ultimate x64 SP1 beta)

> I have found a huge jump, over 11%, in my net worth between 9/29/2007
> and 10/9/2007. In an effort to understand where and when it is coming
> from, it would be useful to be able to print account totals and total
> net worth for each day between those two dates. This way I could more
> easily understand where and when the increases are happening. This
> way I could validate whether the increase is a true increase because
> of market conditions or a generous error on my part.
>
> In the event a "daily" interval cannot be done (I couldn't figure out
> how), can someone suggest a debugging strategy that would make the
> where and when of the increase more apparent?
>
> Thanks in advance.


Posted by Gary on October 10, 2007, 4:02 am
Please log in for more thread options
I've located several stray transactions that erroneously transferred
cash into two of my accounts that caused the false 11% increase.

My thanks to everyone who suggested how I could accomplish the
equivalent of daily interval reports. Nonetheless, there is no reason
that Intuit did not include that function in the program (incidentally
I use 2008 Premiere H&B).

I will need to remain extra vigilant of one-step update transactions.
I cannot imagine what else could have caused these erroneous
transactions to pop up.


>I have found a huge jump, over 11%, in my net worth between 9/29/2007
>and 10/9/2007. In an effort to understand where and when it is coming
>from, it would be useful to be able to print account totals and total
>net worth for each day between those two dates. This way I could more
>easily understand where and when the increases are happening. This
>way I could validate whether the increase is a true increase because
>of market conditions or a generous error on my part.
>
>In the event a "daily" interval cannot be done (I couldn't figure out
>how), can someone suggest a debugging strategy that would make the
>where and when of the increase more apparent?
>
>Thanks in advance.

Posted by R. C. White on October 10, 2007, 8:43 am
Please log in for more thread options
Hi, Gary.

Thanks for the report back. I'm glad you figgered it out. ;^}

RC
--
R. C. White, CPA
San Marcos, TX
(Retired. No longer licensed to practice public accounting.)
rc@grandecom.net
Microsoft Windows MVP
(Currently running Quicken 2008 Deluxe in Vista Ultimate x64 SP1 beta)

> I've located several stray transactions that erroneously transferred
> cash into two of my accounts that caused the false 11% increase.
>
> My thanks to everyone who suggested how I could accomplish the
> equivalent of daily interval reports. Nonetheless, there is no reason
> that Intuit did not include that function in the program (incidentally
> I use 2008 Premiere H&B).
>
> I will need to remain extra vigilant of one-step update transactions.
> I cannot imagine what else could have caused these erroneous
> transactions to pop up.
>
>
>>I have found a huge jump, over 11%, in my net worth between 9/29/2007
>>and 10/9/2007. In an effort to understand where and when it is coming
>>from, it would be useful to be able to print account totals and total
>>net worth for each day between those two dates. This way I could more
>>easily understand where and when the increases are happening. This
>>way I could validate whether the increase is a true increase because
>>of market conditions or a generous error on my part.
>>
>>In the event a "daily" interval cannot be done (I couldn't figure out
>>how), can someone suggest a debugging strategy that would make the
>>where and when of the increase more apparent?
>>
>>Thanks in advance.


Similar ThreadsPosted
Seriously in need of help after changing online account details! March 9, 2008, 1:02 am
Routing Number (Account Details Screen) - Quicken Deluxe 2006 September 3, 2006, 11:26 am
Net Worth Graph February 5, 2007, 9:45 am
Net Worth calc -any good??? January 30, 2008, 3:28 pm
Quicken errors in Net Worth July 10, 2008, 11:21 am
individual net worth with joint accounts July 15, 2006, 4:24 am
Is 2007 from 2006 worth the upgrade? October 23, 2006, 10:40 am
Q2007 / R5 Fixes Bug in Net Worth Report May 18, 2007, 7:40 am
Net Worth error in 2007 premier May 24, 2007, 9:54 am
Is quicken 2008 worth the upgrade? September 13, 2007, 9:10 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap