Net Worth Report

I use Q16 Deluxe, supposedly uptodate. Maybe someone has a solution. I have given up trying to get a correct printed Net Worth report. This is a new problem - it had worked for years. I cannot make it report a specific account correctly. The total shown in the account list column is OK, but if I try to have it print the report is is wrong, as is a report from the reports menu. If I unmark all securities and then check the 4 that are in the account, the result is good. But if I go back to the defaults, the balance is far too low. Checking or unchecking the unearned stuff makes no difference. The cash balance in the investment account is zero.

Reply to
Jim T.
Loading thread data ...

I have found the Net Worth report reduces its balance by the total of the r eturn of capital transactions transferred from an account (RtrnCapX) for se curities no longer held in the account. Since I don't hold these securitie s in other accounts, I mark them as hidden and easily exclude them from the report.

Reply to
Sherlock

For me the Net Worth Report (selecting only investment accounts), the Portf olio Value Report, and the Portfolio Investing Screen totals don't agree. I use a custom date and set both values to today. I have no cash balances. T he values should simply be the shares times the market price. Am I wrong? ( Even when setting my custom date, an * is reported in the "est" column on t he Portfolio Value report.)

I think the Portfolio Investing Screen is accurate - with the exception tha t the Day Gain/Loss column is incorrect. The difference between yesterday's market value and today's market value is not what is reported in the Day G ain/Loss column.

With regard to the balances reported on the Net Worth and Portfolio Value r eports; Perhaps the reports are not using the six decimal places as the Por tfolio Investing screen does. However, using two decimal places (as display ed on the Portfolio Value Report) times the price does not match what is sh own on the report.

I eliminated any future prices that made it into my quote database. However , since the Portfolio Value and the Net Worth report can be set to a custom date - any future prices should be ignored.

Release 10 doesn't address any of these issues. And yes, they have been bro ught up before. I don't know why someone would be disturbed about that - si nce Intuit doesn't seem to be addressing these problems.

Reply to
Fred Jacobowitz

tfolio Value Report, and the Portfolio Investing Screen totals don't agree. I use a custom date and set both values to TODAY. I have no cash balances. The values should simply be the shares times the market price. Am I wrong? (Even when setting my custom date, an * is reported in the "est" column on the Portfolio Value report.)

****Correction**** The Net Worth Report and the Portfolio Value Report show the "Balance" as opposed to the Market Value as shown on the Portfolio Inv esting screen. The "Balance" is calculated as the "Cost Basis" plus the "Ga in/Loss". ******************************************************************

hat the Day Gain/Loss column is incorrect. The difference between yesterday 's market value and today's market value is not what is reported in the Day Gain/Loss column.

reports; Perhaps the reports are not using the six decimal places as the P ortfolio Investing screen does. However, using two decimal places (as displ ayed on the Portfolio Value Report) times the price does not match what is shown on the report.

****Correction**** Edit->Preferences->Report Only-> select 6 for decimal pl aces for prices and shares. Then you can save the Portfolio Value Report in Excel compatible format and calculate the Market Values and the Day Gain/L oss, and compare them to the values shown on the Portfolio Investing screen .

I found that the Day Gain/Loss was calculated incorrectly on two securities . Therefore, the net Day Gain/Loss is being reported incorrectly.

*************************************************

er, since the Portfolio Value and the Net Worth report can be set to a cust om date - any future prices should be ignored.

rought up before. I don't know why someone would be disturbed about that - since Intuit doesn't seem to be addressing these problems.

Reply to
Fred Jacobowitz

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.