Quicken - A Gripe (or is there a solution?)

I own the same Mutual Fund (Vanguard Index Total) in both my investment account and also as in my Roth IRA account.

I also own the same Mutual Fund (Fidelity Spartan Total Market Index) in both my IRA account and in my Roth IRA account.

It is useful for me to be able to run a report in Quicken of my Portfolio Value with subtotals by Investment Goal, i.e., ...

----- Portfolio Value by Investment Goal -----

Investments ...Mutual Shares ...Vanguard Index Total ...Vanguard Prime MM ...Cash ......TOTAL Investments

TaxFree ...Vang NY Tax-Exempt Fund ...Vanguard NY Tax-Exempt MM Fund ......TOTAL TaxFree

IRA ...Fidelity Spartan Total Market Index ......TOTAL IRA

Roth IRA ...Fidelity Spartan Total Market Index ...Vanguard Index Total ......TOTAL Roth IRA

TOTAL Investments

-----

The way I indicate the Investment Goal is in the definition of the Mutual Fund, so to be able to get the Portfolio Value by Investment Goal report it is necessary to invent two new Mutual Funds, each with Roth IRA as its Investment Goal:

Fidelity Spartan Total Market Index Roth Vanguard Index Total Roth

This is a pain! Also, this year, when I converted IRA assets to Roth IN KIND, I had to reflect it in Quicken as a removal of the non-Roth assets and an addition of the Roth assets, rather than as a simple transfer of the same fund shares from a non-Roth account to a Roth account.

Intuit simply forgot that the same assets could have different goals at different times, or that some fraction of these assets could have different goals from the remainder. The Investment Goal doesn't properly belong to the Fund definition. It could either be a property of the Account or a propery of the account/fund combination.

OK, I'm done ranting. Maybe it was ME that goofed, and should have set this all up differently to be able to get my Investment Goal report.

Reply to
Gary
Loading thread data ...

I suggest that you:

  1. Make a customized portfolio view
  2. Arrange the view as you want
  3. Select File-Print Portfolio and Export to Tab Delimited
  4. Import the file into Excel
  5. Sum as wanted and print.
Reply to
ebloch

AMEN! Well said!

Reply to
Frank Kirk

Which is why (at least for me) having Excel with its fairly rich set of tools (autofilters, sorts, Pivot charts and Pivot Tables) is such a nice thing to always be able to export to for this sort of purpose....regardless of the original source (ie: QB, Quicken, bank statements online, etc.. etc...etc...) of the data.

Reply to
Andrew

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.