Home Page link  

Investment report logic?

 

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
Investment report logic? Paul_B 11-03-2006
Posted by Paul_B on November 3, 2006, 11:59 am
Please log in for more thread options
When I call up a report on investment transactions, restricting
it to a certain security, it seems the report is incorrect.
Simplifying, I show:

date        action        quote        shares        cash        amt.inv.        cash+inv.

5/16        bought         4.6        700        -3233        3233
5/17        bought        4.6        800        -3694        3694
5/25        bought        4        1000        -4015        4015
9/11        sold        .5        -2500        10942        -10942
        Realize gain                -9720        0                -9720
        Totals                        -9720        0                -9720

Quicken is telling me that when I buy shares I debit the cash
balance and credit the amount invested balance. Fine.

But the fourth entry, a sale, increases my cash balance by 10492
rather than 1250 (2500 shares X .50/share), and debits the amount
invested the same (incorrect) amount.

As I see it, I spent about 10942 buying the shares and got back
1250 selling, for a loss of 9692. So when you figure in
commissions, which I don't show here, Q has the final result
about right. But how it gets there I have no idea.

Thanks,
p.
--
Using Quicken '06 premier H&B on Windows XP.

Similar ThreadsPosted
Trying to do an Investment Goal Report and Quicken doesn't seem to know what I own December 14, 2007, 1:04 am
Investment Perf Report - divs vs re-invest gains January 2, 2007, 12:07 pm
Can I run a report of one investment in one account showing running totals? July 12, 2008, 3:33 pm
Report Wont Ask to Create Reconcile Report March 15, 2008, 7:42 pm
Cannot Create New Report From Existing Report December 30, 2007, 3:53 pm
Foreign Investment October 1, 2006, 8:39 am
Investment Error '07p October 13, 2006, 10:27 am
Investment name change November 13, 2006, 5:10 pm
Investment Planning? March 15, 2007, 12:49 pm
Investment Category? September 13, 2007, 2:12 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