Home Page link  

Can I run a report of one investment in one account showing running totals?

 

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
Can I run a report of one investment in one account showing running totals? Gary 07-12-2008
Posted by Jerry Boyle on July 13, 2008, 2:25 pm
Please log in for more thread options

> I've been needing this over and over on many occasions in which I am
> trying to understand where something went wrong.
>
> That would be a report of the register of a single investment in a
> single account (which might have other investments in it), showing all
> transactions and a running total of shares balance and investment
> value.
>
> Actually a cash balance isn't as critical, but if included would
> probably be ACCOUNT cash balance...not cash balance due to that
> particular investment.
>
> Does anyone know how I can generate such a report in Quicken? If you
> do, and you share it, I'd really appreciate it!

No such report that I know of. But you may be able to use Portfolio
(Investing -> Portfolio or Ctrl-U) to find when your share balance went
wrong.

The following method (known as binary convergence) works quite well if you
have brokerage statements that go back to the date or dates where the
error(s) occurred.

Set Show:Holdings and Group by:Accounts and As of:<date of interest> to see
your share balance, cost basis, etc. on that date. You can customize this
report to add or remove columns.

Then find a date G where the balance was good, a date B where it is bad and
a date M about midway between G and B.

If the balance on M is bad the error is between G and M, so divide that
interval in half and repeat the process. If the balance on M is good divide
the interval between M and B. Keep dividing until you find the date where
the error occurred.



Posted by Jerry Boyle on July 13, 2008, 2:35 pm
Please log in for more thread options

I forgot to mention that if you have Group by:Accounts in Portfolio you can
click the "+" to the left of the security name to see the lots of the
security that you held on the As of: date. This may provide a further clue
as to what's wrong.

Jerry


Similar ThreadsPosted
Report showing running shares July 8, 2007, 11:11 am
Report Showing Basis? November 5, 2007, 9:59 am
Q2007 ~ Xfrs fromiInvestment account not showing up in linked account. October 27, 2007, 5:16 pm
Transactions not showing up in linked checking account August 2, 2007, 9:59 am
Investment report logic? November 3, 2006, 11:59 am
securities transaction NOT showing up in linked checking account December 21, 2006, 12:37 am
Trying to do an Investment Goal Report and Quicken doesn't seem to know what I own December 14, 2007, 1:04 am
Cannot accept downloaded transactions into Ameritrade-Cash account "You should make this change from the investment account" message July 8, 2006, 9:15 am
Investment Perf Report - divs vs re-invest gains January 2, 2007, 12:07 pm
Problem with Investment Account July 30, 2006, 1:32 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