cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

How can I display amount in our Money Market Account when developing reports?

We are a 501(c) (3) not-for-profit organization. We have a brokerage account in QB online that we use to maintain a money market fund. Our donors donate shares of stock to us, some of which we transfer to our checking account.  A great deal of our stock is being held in the brokerage account, because of its ability to earn interest.  

 

At the moment, most of our money is in our brokerage (money market account), and not in our checking account.  Every report I am trying to run does not include the funds in this account, so our actual cash is greatly understated.  The money market account is set up as a bank account/money market in QB.

 

Is there a way to report what is in this account, so that we can see our actual holdings, not just what is deposited in our bank operating account?

 

Thank you in advance for your response.

1 Comment
Highlighted
Level 15

How can I display amount in our Money Market Account when developing reports?

Couple of issues here that are separate

If a donor donates money, then in QB you should have a bank type account named for the brokerage and you show a deposit in that amount as donation income.

 

If a donor donates stock, then you should have an asset account named for the stock part of the brokerage and you enter a deposit in the donated stock asset account as donation income. This can be dicey, you need to talk to the brokerage about how they establish donated stock cost, since they now report that to the IRS when a sale is made.

 

if you get dividends paid to the brokerage account from the stocks you hold, then that is a deposit to the brokerage banking account in QB as dividend income

 

If you sell a stock, then you reduce the brokerage asset value by the cost of what was sold, and that cost is a deposit to the brokerage bank account. Then the excess amount received over cost, is a deposit in the brokerage bank account as income.

 

No there is no way to see actual stock holdings in QB, QB is just not set up to track investments in stocks at all.

 

Best option there is to rely on the brokerage holdings listing and or, use quicken or a spreadsheet.

Need to get in touch?

Contact us