enriching the Net worth report for estate plan.

CTMarkell

hi, the out-of-box net worth report is pretty simple - a list of accounts (grouped in the same hierarchy as the account list on screen) with a current balance.

i would like to use the quicken report as the basis for a document to include in my estate plan -- to show an asset list, with account #, institution name and phone, beneficiaries listed, etc; i have a lot of this information in the "account information" forms in quicken. But there is no way to add columns or descriptions or anything to the report.

Wouldnt it be great to be able to user-select to add columns from the account information form to the report? Does anyone else have this problem? As it stands now i need to jump in/out of excel, to quicken and then into each account info to copy/paste...

Not bad if you have only a few accounts -- but a nightmare if you have a complicated situation.

NotACPA

Q is NOT an estate planning tool, and I doubt that it will ever be.

You need to find another planning tool, while continuing to use Q for personal financial management.

CTMarkell

hi, i guess i worded that post poorly, sorry. I very much agree that Q is not and shouldnt be a tool for estate planning.

Rather, i want the ability to to customize the net worth report, and thats it... Want to bring the report output along to meetings with my financial advisor and lawyer. Its the concise asset list they require as an input to the periodic review process.

When they are done, want to be able to update beneficiaries as needed, and record the updated data back into quicken, and then print out the current state of things for my records.

Q really is, or should be, the one place where i can keep all that sort of information organized and be able to retrieve it.

NotACPA

Precise assets can be presented in 2 reports ... the regular Net Worth report, and then an Investments report that shows what's in the investment accounts.

Re: beneficiaries ... how do you currently have them recorded in Q?

jacobs

@CTMarkell I understand what you're asking for, but I'm doubtful they'll ever add the option to have additional columns of account information to the Net Worth reports. The existing Notes field for each account isn't structured in any way; it provides place for people to record whatever they want, and as such, it isn't designed for reporting. And you're asking for something more than that: structured columns for such things as institution name, phone number, account numbers, beneficiaries, etc.

My suggestion would be to export your Net Worth report as of the end of 2021, open it in Excel, and add the columns for all the additional details you want. Assuming you aren't opening and closing accounts all the time, this list isn't likely to change very often. Perhaps once a year, you could update it. (If you wanted to update the account values, you could export the Net Worth report again, and copy-and-past the current values into your existing Excel spreadsheet if you wish.) But you really don't need to to that; you can use the Net Worth report from Quicken to always show your current holdings, and the Excel spreadsheet as the notes/index/guide to the Net Worth report.

CTMarkell

@Jacobs - yes, what you suggest is actually what i already do. I just find it cumbersome that i need to use excel for info like institution name, account type, account #, contact name, telephone, and name of beneficiary; some of these are in the account detail screen, and some i glom into the notes field. Quicken is supposed to be the place to manage your finances, and having a way to print a detailed account/asset list out of the box doesn't seem (to me) to be too much of a stretch. their report writer for transactions lets you chose the columns you want... why not add that function to the account summary and/or net worth report too?

jacobs

I'm going to flag this thread for a moderator to suggest turning it into an Idea thread -- a request for new features of functionality. Once it's changed, you and other Quicken users can vote for the Idea. Ideas that garner significant votes are presented to the development and product teams for consideration. 

Quicken Anja

Hello All,

Thank you for taking the time to reach out to the Community with your request.

I went ahead and changed this post to an Idea so other users who have the same or a similar request can vote on the idea by clicking the up arrow (see below).

Ideas are also reviewed by our Development and Product teams in order to improve Quicken and implement new features requested by customers.

Please, be sure to add your own vote as well.

CTMarkell

Thanks Anja!

Quicken Anja

@CTMarkell You're welcome!