How to show how much deposited in an account

Dennis Mahoney

I recently opened an managed investment account with a set amount of money (e.g. $150,000 deposited using the contributx action). Obviously I am interested in how the manager does over time. My question is how to show the total investment in the portfolio view. I have tried using the cost basis and the amount invested but they both vary as trades in the account are made. Is there a column that will show the initial (and any added) deposits but be unaffected by the activities in the account?

Jim_Harman

There is no column that shows exactly what you are asking for. Amount Invested comes the closest, but it includes dividends received as cash.

If you are interested in short term performance, I suggest you look at the ROI (%) columns, which are not annualized.

For periods of longer than one year, I suggest Av. Annual Return (%), which is the annualized Internal rate of return (IRR).

In either case, click on Options and Portfolio Preferences in the Portfolio view and make sure the starting date for the analysis is set correctly.

Dan Glynhampton

Jim's suggestions are excellent if you are looking for performance information on the investment, but if you just want to know the amount(s) you have invested in the  account then using a report is the way to do it.

Take a look at the Investment Transactions report, customise it to include all dates and restrict it to the account(s) you are interested in, then set the Action to XIn, or ContributX, or whatever action is assigned to the transfers you made into the account.  That report will then show you how much you have paid in without including  dividends etc.

q_lurker

If you choose not to track the individual investments the manager makes, you could have an account where you "buy" 1,000 share of "XYZ Mgd Fund" at $150/share, then vary the share value accordingly each month.

If you want to track the individual investments he makes, you might try setting up a security as I suggested above, but identify that account with that holding as "Separate".  You would have two accounts in Quicken - one real and included, the second not-real and separate.

Jim_Harman

There is no column that shows exactly what you are asking for. Amount Invested comes the closest, but it includes dividends received as cash.

If you are interested in short term performance, I suggest you look at the ROI (%) columns, which are not annualized.

For periods of longer than one year, I suggest Av. Annual Return (%), which is the annualized Internal rate of return (IRR).

In either case, click on Options and Portfolio Preferences in the Portfolio view and make sure the starting date for the analysis is set correctly.

Dan Glynhampton

Jim's suggestions are excellent if you are looking for performance information on the investment, but if you just want to know the amount(s) you have invested in the  account then using a report is the way to do it.

Take a look at the Investment Transactions report, customise it to include all dates and restrict it to the account(s) you are interested in, then set the Action to XIn, or ContributX, or whatever action is assigned to the transfers you made into the account.  That report will then show you how much you have paid in without including  dividends etc.

q_lurker

If you choose not to track the individual investments the manager makes, you could have an account where you "buy" 1,000 share of "XYZ Mgd Fund" at $150/share, then vary the share value accordingly each month.

If you want to track the individual investments he makes, you might try setting up a security as I suggested above, but identify that account with that holding as "Separate".  You would have two accounts in Quicken - one real and included, the second not-real and separate.

Dennis Mahoney

Thanks to all three of you for your answers. Jim, your answer was very helpful in explaining that there is no column that meets my definition. Dan and q_lurker, I plan to try your ideas as well and see which ones best meet my needs.