enriching the Net worth report for estate plan.

CTMarkell
CTMarkell Member ✭✭
edited February 8 in Reports (Mac)
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.
1
1 votes

New · Last Updated

Comments

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    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.
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • CTMarkell
    CTMarkell Member ✭✭
    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
    NotACPA SuperUser ✭✭✭✭✭
    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?
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    edited February 7
    @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.
    Quicken Mac Subscription • Quicken user since 1993
  • CTMarkell
    CTMarkell Member ✭✭
    @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
    jacobs SuperUser, Mac Beta Beta
    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 Mac Subscription • Quicken user since 1993
  • Quicken Anja
    Quicken Anja Moderator mod
    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.

    -Quicken Anja
  • CTMarkell
    CTMarkell Member ✭✭
    Thanks Anja!
  • Quicken Anja
    Quicken Anja Moderator mod
    @CTMarkell You're welcome! :)
    -Quicken Anja