[GNC] Investment Portfolio Report + Parent Cash Amount

David Carlson david.carlson.417 at gmail.com
Tue Mar 23 20:21:57 EDT 2021


I have used the Balance Sheet report for all my brokerage accounts for
several years.  It shows cash if it happens to exist, which is rare because
it quickly gets swept into a money market fund.

On Tue, Mar 23, 2021 at 6:21 PM Robin Chattopadhyay <robinraymn at gmail.com>
wrote:

> Neither the Investment Portfolio or the Advanced Portfolio reports appear
> to allow the inclusion of currency accounts.
>
> To include the Cash/Cash Equivalents in either of these two reports, I
> think re-structuring is your only option. Otherwise, experiment with the
> other reports that allow for controlling how parent account totals are
> included.
>
> On Tue, Mar 23, 2021 at 11:03 AM Jack Frillman <jcf_m_lists at me.com> wrote:
>
> > Not sure I follow you. I'm not looking to restructure anything just to
> > consolidate information onto one report.
> >
> > On 3/22/21 10:58 PM, Robin Chattopadhyay wrote:
> >
> > You can simply create a generic asset account and set the commodity to US
> > Dollars (since it's an IRA). It would have the same parent as the other
> > securities. I name those accounts "Cash/Cash Equivalents" in my setup.
> >
> > If the cash is invested in a money market mutual fund, you could also set
> > the commodity to that asset as well.
> >
> > On Mon, Mar 22, 2021 at 8:08 PM Jack Frillman via gnucash-user <
> > gnucash-user at gnucash.org> wrote:
> >
> >>
> >> I'm looking for a report that will give me the value of securities in
> >> addition to the cash amount of their parent account.
> >>
> >> For example if I have the following account structure:
> >>
> >> IRA Account
> >>     Security #1
> >>     Security #2
> >>     Security #3
> >>     Security #4
> >>
> >> The "IRA account" has a cash amount of x dollars.
> >> When I run a Reports-->Assets & Liabilities --> Investment Portfolio
> >> report it gives the details and totals for the four securities under the
> >> "IRA Account" but not the cash amount in the parent "IRA Account" even
> >> if I try to select it in the report options.
> >> I'm trying to get this same report type of but with the cash amount of
> >> the parent account "IRA Account" included.
> >>
> >> Any ideas how this can be done?
> >>
> >> Thanks.
> >>
> >> --
> >> Old Unix programmers never die, they just mv to /dev/null
> >> - Anonymous
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> > --
> > Old Unix programmers never die, they just mv to /dev/null
> > - Anonymous
> >
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson


More information about the gnucash-user mailing list