Any way to get net worth details BY DAY?

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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Gary wrote:

There are no Quicken reports that allow a daily interval. You can create multiple copies of a report, each ending on a different date (likewise displays, such as the Portfolio tab), but not a single report with daily intervals.
It seems that you're saying your 9/29 numbers are correct, but you doubt your 10/9 values.
Unless I'm missing something, the only two factors that can be involved are number of shares owned, and price/share (ignoring cash balances).
Why not start by just comparing the security values for the last good date with the most recent date for which you can get independent verification ... like your broker's web site.
If you print a Portfolio Value report for a date you think is wrong in Quicken, and compare it to the values at your broker's web site for that date, you should be able to determine which securities have incorrect values.
If the difference is in shares owned, you can print a Quicken Investment Transaction report for those securities to see where the problem is.
If the difference is in price/share, you can check your Quicken price history and correct the wrong prices.
--
John Pollard
First initial underscore Last name at mchsi dot com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
John Pollard wrote:

I didn't state that correctly. I should have said:
Why not select a date for which you can get verifiably correct data from your broker and that you believe has incorrect values in Quicken; and compare the two sets of values for that date.
--
John Pollard
First initial underscore Last name at mchsi dot com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
This is a multi-part message in MIME format. --------------090504050504000405050508 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit
John Pollard wrote:

You're not missing something but you are adding something. You are making a possibly invalid assumption that net worth == investments. It does not. Net worth is a combination of all assets and all liabilities. Granted the OP did state "This way I could validate whether the increase is a true increase because of market conditions or a generous error on my part" leading one to think that the error was in the investment accounts. But the error could as easily been in an incorrect entry to a liability or other asset account. Indeed it could be merely that one net worth report is missing a key new account!
The advice about creating multiple net worth reports by day should weed out what the error really turned out to be.
--
Andrew DeFaria <http://defaria.com
Old quarterbacks never die, they just fade back and pass
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Andrew DeFaria wrote:

Yes, I do know that. And I consciously took into consideration the possiblity that the differences could occur in non-investment accounts.

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.

I was certainly playing what I thought were the odds; but taking my approach should not have caused any real problem - it is after all, just starting with a subset of all possible accounts - and could have saved some time and paper. If the difference wasn't found in investment accounts, a subsequent effort for non-investment accounts would have been easy enough to do.

--
John Pollard
First initial underscore Last name at mchsi dot com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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:

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?
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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.

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi, Gary.
Thanks for the report back. I'm glad you figgered it out. ;^}
RC
--
R. C. White, CPA
San Marcos, TX
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
This is a multi-part message in MIME format. --------------020801020800090104080108 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit
Gary wrote:

The reason is most likely that most people do not need nor would use such a report normally. Granted I agree with you, it wouldn't be hard to offer. But most people are not looking at their net worth from day to day.

So tell us, did the problem lie in investment transactions/accounts or other transactions/accounts. I'm curious now...
--
Andrew DeFaria <http://defaria.com
Is French kissing in France just called kissing?
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Andrew:
All the problems were in investment accounts.
There were actually three problems. Two of them were easier to spot, as they occurred in a Janus account I had closed a couple of years ago. These transactions were actually valid transactions that should have been in another account, so I moved them (another question I asked in this same newsgroup).
The third transaction, also with an investment account, was a Transfer In from the same account (which didn't have that much money to transfer in to...and no indication of money being debited out). I have yet to figure out where that transaction came from. The amount didn't show up in any other transactions in my system. I simply deleted it (and, sadly, lowered my net worth by the 11%).
On Wed, 10 Oct 2007 08:12:18 -0700, Andrew DeFaria

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.