1. Home
  2. Quicken Personal Finance
  3. "Cash" appears twice in Portfolio Value report

"Cash" appears twice in Portfolio Value report

I have Quicken 2004 Premier R5 (U.S. version). When I create an Investment Portfolio Value report, the first line of the report always says "Cash" in the "Securities" column. If I have no cash in the investment accounts, this line still appears, but with a "Balance" of zero, otherwise the "Balance" is the amount of cash I have. If I do have cash in the investment accounts, then the last line of the report also says "Cash" in the "Securities" column, and shows the amount of cash in the "Balance" column. This means that my cash is counted twice and the Total Balance in the report is wrong.

If choose the Portfolio Value and Cost Basis report instead, the cash only appears once. By customising the Portfolio Balance report, I can exclude cash entirely by deselecting it on the securities tab, but then of course the Total Balance is still wrong (it's missing the cash).

The Portfolio Balance report didn't used to work this way. The only thing I can think of that I have done since the last time it worked is moving to a new PC. I reinstalled Quicken, restored my Quicken fileset and downloaded the R5 update. I have tried validating and super-validating the file, but no errors were found.

Does anyone have any suggestions?

Reply to
Blackwood
Loading thread data ...

I tried to make Quicken 2004 Deluxe behave as you describe, and was unable to do so.

Is it possible that you've accidentally created a security named "Cash"?

In Q2004D, at least, your cash is covered by something called "No Security (includes Cash)" on the securities tab, not by something actually called "Cash".

- Bob

Reply to
Bob Weissman

Investment

accounts, this

"Balance" is

accounts,

Reply to
vodil

I've never encountered this "problem" in my investments. Money market fund purchases show (rightly) only as units with a value of $1/unit and not also as cash.

Reply to
Mike B

Thanks for the suggestion. I don't have a security called "Cash". You are right about cash being covered by "No Security (includes Cash)", I was a little lazy describing what I did there.

I did manage to eliminate the problem. By choosing different time periods for the report, I found that the "cash appearing twice" problem only occured for certain time periods. Narrowing that down, I found three XIn transactions that I had recently changed (but forgot to mention in my original post - sorry) that caused the problem. I deleted those transactions and recreated them and everything seems to be OK now. I'm still not sure what the problem was though.

Reply to
Blackwood

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.