Skip to main content
September 16, 2022
Question

Does anyone know how to get sub-totals for several bank accounts in Quickbooks online? It is combined with my prepaids for total on Balance Sheet.

  • September 16, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

September 16, 2022

Hi there, @rcl-candw-ky.

 

The option to filter banks and calculate their subtotals in the balance sheet is unavailable in QuickBooks Online (QBO). This report will only show the total sum of all your bank accounts.

 

As a workaround, you can open again the report and export your files to Excel. Then, filter the bank accounts and get their sub-totals. Simply click the Export icon and select Export to Excel.

 

Additionally, I've included a link you can visit to learn how to export a custom report in Excel or PDF format: Customise reports in QuickBooks Online.

 

Drop by anytime you need more insights or guidance on managing reports in QuickBooks. I'm here to help you anytime.