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....@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 <robinra...@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_li...@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@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@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@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 _______________________________________________ gnucash-user mailing list gnucash-user@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.
