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

Jan 01, 2009 4 Replies

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.



I've not been one, historically, to sing hosannahs about Quicken's acumen when it comes their programming but I don't think they really deserve any special opprobrium for this "defect."

Users of accounting programs and programmers of accounting programs all struggle with how much time, effort and money to put into trying to "earmark" accounting entries so that every possible way you might want to slice and dice historical accounting information can be done "at the push of a button." (Man! How many times in my accounting career have I heard "Can't you just push a button and get the (report/ information) out of the computer?") The fact is there's no way anyone can anticipate *every* possible way *anyone* might want to get information out of a set of accounting records.

I guarantee you that at the biggest companies in the world with the most sophisticated and expensive accounting programs available the ol' spreadsheet get's fired up routinely so some accountant can pluck out and summarize accounting information in a way that *can't* be done via that expensive program. I'm kind of inclined to give a $40 program a "pass" on this issue since I think it would take a pretty sophisticated bit of programming to add this feature, a feature that (I'm guessing) few people would want or use. It seems like you've come up with a pretty good work-around to Quicken's "deficiency" and, offhand, I can't think of a better way to do it.

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.

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.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required