Skip to main content
Question

Balance Sheet Formatting

  • March 21, 2025
  • 0 replies
  • 36 views

Hello!

I am hoping to get some help with report formatting for the balance sheet. My company is looking to replicate how Quickbooks formats their balance sheet (a total column for Subaccounts; a total column for the Accounts; and a total column for the section total). 

I am having issues with my 3rd column displaying any value other than the description if its calculating the sum of multiple Row Lines that have different account Classes. 

If I do an account range in my Total Row, it will populate, but for this specific section, an account range isnt possible, since there are other accounts between 10999 and 12010 that I don’t want the report to publish in this section. 

Anyone have any guidance on how to get the total to populate in Column C when totaling multiple rows with different account classes?? Any and all suggestions are greatly appreciated! 

Column Set:

 

Row Set:

Report: Not populating a value.