How do I display only non-zero rows in a custom report related to a Balance sheet account

Yes, pkeogan. You can adjust the report to display only non-zero rows. I'll elaborate on this below.

The Modern view offers customization options for reports, even though it doesn't have a specific Customize button like the Classic view. In the Modern view, you can also filter the report to show only non-zero rows. However, instead of leaving out accounts with zero balances like in the Classic view, it displays a dash (-) for those accounts. 

Here's how to filter your custom report:

1. Navigate to the General options.
2. Tick the Don't show zero amounts and Non-zero selection.
   

Moreover, I recommend creating a custom report in Classic view moving forward. This will enable you to tailor your reports accordingly.

Finally, I’d like to share some resources that can help you maximize your financial reports and learn how to delete a balance sheet account from your chart of accounts:

• Export a custom report in Excel or PDF format  
• Restore an inactive balance sheet account in QuickBooks Online

For further concerns about customizing your financial information, comment below. I'll be here to ensure you have all the help you need.

Sorry, I must not have asked my question well. I am asking about a custom report related to a Balance sheet account not the balance sheet it's self.

I have a liability account "2300 Unearned Income"  which is used when we pre-bill a customer.  So each month we make adjustments.  After several years we now have may customers with a non Zero balance.  I would like to have a custom report that shows the balances of customers (so grouped by customer) but only display the ones with a non Zero balance.

1) If I start from the balance sheet in the Modern View then I can not create the report that only displays the customers with a non Zero balance -  That makes sense based on your earlier answer.

2) If I start from the balance sheet from the Classic View already set to only display the customers with a non Zero balance then I can create the Custom report and it works correctly.  However (a) if I switch the modern view then all the zero balance customers are displayed again (b) if I keep in Classic view then I can not save in the same group as my modern reports.  

I am choosing to use option 2b; but this means I can not schedule this report to be emailed and its in a different group than other related reports

Sorry, I must not have asked my question well. I am asking about a custom report related to a Balance sheet account not the balance sheet it's self.

I have a liability account "2300 Unearned Income"  which is used when we pre-bill a customer.  So each month we make adjustments.  After several years we now have may customers with a non Zero balance.  I would like to have a custom report that shows the balances of customers (so grouped by customer) but only display the ones with a non Zero balance.

1) If I start from the balance sheet in the Modern View then I can not create the report that only displays the customers with a non Zero balance -  That makes sense based on your earlier answer.

2) If I start from the balance sheet from the Classic View already set to only display the customers with a non Zero balance then I can create the Custom report and it works correctly.  However (a) if I switch the modern view then all the zero balance customers are displayed again (b) if I keep in Classic view then I can not save in the same group as my modern reports.  

I am choosing to use option 2b; but this means I can not schedule this report to be emailed and its in a different group than other related reports

Ensuring that the General options have been configured according to your report needs helps achieve your goal of creating a Balance Sheet by account with non-zero balances, Pkeogan. I'm here to navigate you and operate troubleshooting steps if needed.

In your QuickBooks Online (QBO), guarantee that you've toggled and marked checked the box beside Don't show zero amounts and the Non-zero option so that your Balance Sheet reports display the said information.

Here's a visual reference you can refer:

However, if the details are not visible, let's troubleshoot the browser to rule out any web browser-related issues. Let's start by logging out of your QBO, and then log into an incognito or private website. You can use these keyboard shortcuts below:

• Google Chrome: Ctrl + Shift + N
• Safari 11 or newer: ⌘ + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Microsoft Edge: Ctrl + Shift + N
   

After that, check if you can see the non-zero rows in your customized Balance Sheet report. If it works, return to your standard browser and clear its cache. Implementing this step can help eliminate cookies that disrupt web page performance. You can also utilize other QuickBooks-supported browsers.

Additionally, if you remove a balance sheet from your chart of accounts, QuickBooks makes it inactive but preserves the transactions, allowing you to restore it later.

Acquiring the information needed for your Balance Sheet report is my top priority. Don't hesitate to return to this thread if you have more questions. I'll be sure to address them in no time.