Report Cash in each Brokerage Account

John Burgess

Is there a way to get a report (or filtered view or something else) that shows the cash balance in each brokerage account, and nothing else?
I have multiple accounts, and just need to know where the cash is.

Bob_L

Try creating an account balances report. Then customize the securities tab by clearing all of the securities except for the “no security, includes cash”.

John Burgess

I don't see an "Account Balances" report. when I click "New Report...", the choices are "Comparison", "Summary" and "Transaction".  There is not a pre-defined Account Balance report, either.
Also, I've never see a "securities tab" either in a report or in the Customization dialog.  Is that perhaps a Windows feature?

PS I'm running QMac 2018, v5.7.2  (Waiting for 5.8.1 after hearing various bad things about the "dot zero".)

Bob_L

Sorry, overlooked it was Mac. Too bad as windows does do what you want.

John Burgess

RickO said:

John,

Bob answered for QWin, but since you're using QMac, what he described won't work.

There is a workaround that involves exporting the Portfolio Value display to Excel or Numbers and manipulating it there to derive the report you want. It might be worth doing if you have many accounts. In fact, if you have many accounts and need this often, you could even write an Excel macro to repeat the process rather than having to do it manually.

If you think you want to try the Excel manipulation process, let me know and I'll lay out the steps. (I'm not going to take the time to write it up unless you tell me you're interested.)

Thanks, Rick. I’m enough of an excel wiz that I can handle that end of things. The data was going to excel anyway...


OTOH, isn’t there another thread that tracks report features in QWin that are missing in WMac? This should be added or referenced there.

John Burgess

RickO said:

John,

Bob answered for QWin, but since you're using QMac, what he described won't work.

There is a workaround that involves exporting the Portfolio Value display to Excel or Numbers and manipulating it there to derive the report you want. It might be worth doing if you have many accounts. In fact, if you have many accounts and need this often, you could even write an Excel macro to repeat the process rather than having to do it manually.

If you think you want to try the Excel manipulation process, let me know and I'll lay out the steps. (I'm not going to take the time to write it up unless you tell me you're interested.)

Another automation thought... does QMAn support Automator hooks? Then I could in theory automate the whole process.