Thank you for your response. I understand , its just that the reports are scheduled,  so I would have to manually prepare them each week to hide the sub accounts in an excel report. I am off work next week for a few weeks , so I was hoping for a work around. 

I did pull another report from the chart of accounts  but it doesn't show the total bank balance just the sub accounts . If I could show the bank balance that would be okay . Is there anyway that it can show the total balance like the other bank accounts?