Hello all, new QBO user here, migrated from Desktop Pro 2018.  I'm attempting to recreate all my go-to reports in QBO and struggling with this one.  I've done a ton of searching of the community here, QB help resources, and Google, but I'm not finding anything that really addresses what I'm trying to recreate.  Hopefully, you can point me in the right direction.

I'm trying to have a report that shows certain bank balances on a specific date (month end), with a total at the bottom. 

I can run an account list, but there's not a total and any transactions I entered after the end of the month are included.

I can run a Balance Sheet (using month end date) and ignore the non-bank account information below them, but I can't exclude a couple of bank accounts using this method.

For those wondering why I'm looking to report this way, these are the books for a volunteer fire department which has an explorer post (junior FF's) that is technically part of our organization, but we treat them as if they were their own entity.  In the books, we're all one organization and that's the way we file our tax returns, etc., but when we issue monthly reports to the fire department, we exclude the explorers details and report those separately (to the explorers).

For now, I'll be stopping the processing of any transactions in the following month until all my reports are done and live without a total at the bottom of the account list.  Hopefully there's a solution that someone can point me in, or even suggest better ways of handling of the above - I'm open to any feedback.

Thanks!