Cash in Money Market Accounts

[SLO GUY]

I am trying to reconcile initial cash balances in a series of accounts all of which use the same Schwab sweep account. I have attempted to make purchase or sell entries to get the cash to balance. When I do so in one account the transaction is repeateed in all accounts holding this fund, thus driving other portfolios out of balance. I note that when using the B/S function it lists a series of portfolios with this fund. How can I limit the transaction to a single sub-portfolio? When I use the B/S for other securities held in multiple sub-portfolios, it lists only the portfolio currently opened.

Thanks.

[Mark]

Hi SLO GUY,

It sounds like you have the same cash investment in multiple sub-portfolios. If you're trying to track cash separately in each of these sub-portfolios you would want to create a cash investment for each of them, so they each have their own, instead of all using the same investment.

To verify that it is the same investment in multiple sub-portfolios, turn on "Location" and "Filename" in the portfolio editor using "View / List Columns...". If the same file is included in multiple sub-portfolios, then you can close it out of the duplicates, and then create a new investment to add into the sub-portfolio that you just closed the old investment from.

You might find this FAQ helpful:

http://www.fundmanagersoftware.com/faq_ ... tments.php

[SLO GUY]

Hi Mark,

As suggested, I have made "New Investments" in each sub-portfolio. This seems to have solved my problems. It also helped me to better understand the software's file system.

Thanks for your prompt help.

[SLO GUY]

I have had no further problem with the duplicating of manual transactional input from account to account. However, I have been unable to update some of the transactional (Dividend YES ... sweeps NO) information from Schwab for these sweep accounts. Thus the balances are moving further and further from correct as daily sweeps do not record. Schwab uses the symbol swsxx. I am now using the symbol swsxx1 through swsxx12 for my various accounts. All other transactional data for other securities seems to correctly flow into the correct accounts.

Thanks.

[Mark]

Hi SLO GUY,

I'm not sure I followed the exact problem, but it sounds related to the use of a default cash account. Each sub-portfolio can have its own default cash account assigned. You do this in the "Properties..." of that sub-portfolio. Once you have a default cash account assigned, any recorded transactions that use or generate cash will have the proceeds automatically take out, or added into, this assigned investment. Hopefully this helps straighten out the problem you're describing.