Investment Account Register/Transactions Report
Mary Alice Thauvette
Member ✭✭
Originally submitted March 1919
"When I print an investment register report, dividend reinvestment transactions report the dividend received (+cash) but does not include the shares bought (-cash) half of the transaction. Also, the beginning and ending cash balances are not correct."
The responses showed that the responders did not understand that this was not a question, but rather the reporting of a flaw in the report..
See attached file.
I hope that the attached file makes my point clearer. The line beginning "ReinvDiv" (highlighted in blue) is missing from the report.
Sherlock (April-2019): "The cash field in the investment transaction report does not represent the cash holding in the investment accounts."
Answer: The cash field in the report should equal the cash holdings in the investment accounts. The reason they are not equal is because in the past the "ReinvDiv" transactions have not been included in the report.
The amount in the Cash column is currently cash plus investments in the ReinvDiv transactions.
The amount in the "Amount Invested" column is the basis of securities not bought with reinvested dividends. The understatement of "Amounts Investment" is equal the the overstatement of the "Cash."
The "Cash + Invest" amount should/will equal the "Cost Basis" in the Portfolio Value report
Please note that the reinvested Long-term and Short-term Capital Gains Distributions transactions are handled correctly.
"When I print an investment register report, dividend reinvestment transactions report the dividend received (+cash) but does not include the shares bought (-cash) half of the transaction. Also, the beginning and ending cash balances are not correct."
The responses showed that the responders did not understand that this was not a question, but rather the reporting of a flaw in the report..
See attached file.
I hope that the attached file makes my point clearer. The line beginning "ReinvDiv" (highlighted in blue) is missing from the report.
Sherlock (April-2019): "The cash field in the investment transaction report does not represent the cash holding in the investment accounts."
Answer: The cash field in the report should equal the cash holdings in the investment accounts. The reason they are not equal is because in the past the "ReinvDiv" transactions have not been included in the report.
The amount in the Cash column is currently cash plus investments in the ReinvDiv transactions.
The amount in the "Amount Invested" column is the basis of securities not bought with reinvested dividends. The understatement of "Amounts Investment" is equal the the overstatement of the "Cash."
The "Cash + Invest" amount should/will equal the "Cost Basis" in the Portfolio Value report
Please note that the reinvested Long-term and Short-term Capital Gains Distributions transactions are handled correctly.
0
Comments
-
When you want to report a flaw in the product, I suggest you select Help > Report a problem...
If you would like a ReinvDiv to behave like a Div and Bought in the Investment Transaction report, I suggest you use a Div and Bought instead of a ReinvDiv.
If you haven't already, you may want to review: https://community.quicken.com/discussion/7499433/amount-invested-should-decrease-by-the-amount-paid-for-shares-sold-1
This discussion has been closed.