[GNC] Investment Portfolio Report + Parent Cash Amount

[David Carlson]

Actually, at one brokerage house the cash actually gets swept into a
special type of bank account rather than a MMF.  In GnuCash I have set up a
bank sub-account in those brokerage accounts that appear listed with the
stock accounts in the reports.

On Tue, Mar 23, 2021 at 7:21 PM David Carlson <david.carlson.417 at gmail.com>
wrote:

> 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
>


-- 
David Carlson