Skip to main content
Anonymous
Dec 11, 2018 3:27 AM UTC
Solved

How do I hide zero balance items in the detailed balance sheet report

In using the Detailed Balance Sheet report, I would like to hide all of the accounts with a zero balance. I was unable to do that with the Amount filter.

qbteachmt
qbteachmtAnswer
Dec 11, 2018 3:27 AM UTC

"Detail" reports are going to show individual Transactions. That means some things need to show.

Here is a Basic Function for customizing reports: on the Display tab, look bottom right. If you see the Advanced Button, here is where you have some advanced options.

View in thread

24 replies

qbteachmt
qbteachmtAnswer
Dec 11, 2018 3:27 AM UTC

"Detail" reports are going to show individual Transactions. That means some things need to show.

Here is a Basic Function for customizing reports: on the Display tab, look bottom right. If you see the Advanced Button, here is where you have some advanced options.

    Anonymous
    Dec 11, 2018 3:27 AM UTC
    Many thanks to qbteachmt for his reply. For others interested, in a step-by-step solution, those steps are: - -First choose the Customize Report tab on the detailed report display (upper left), then choose the Display tab, upper left, then the Advanced tab, lower right, then in the small, Advanced Options window, under INCLUDE click on the "In Use" circle. Then click OK to return to the report display. As I desired, none of the "zero" balances will be displayed.
      BK545
      Apr 15, 2019 9:22 PM UTC

      Hi

       

      This will still not help if there was some activity during the report period that totals 0

      bookkeepersr
      Oct 30, 2019 7:18 PM UTC

      The same works for the P & L reports but how do we set to hide zero line items as a default in Quickbooks. Mine keep reverting to showing zero line items.

      MaryLandT
      MaryLandT
      Oct 30, 2019 9:10 PM UTC

      Thanks for joining this thread, bookkeepersr.

       

      While zero balance items are still showing on the P&L report, you can export it to Excel. Then, remove those items from there.

       

      Let me show you how:

      1. On the P&L report, click the Excel icon.
      2. Select Create New Worksheet to create a new Excel.
      3. Otherwise, select Update Existing Worksheet to update the data in this report.
      4. Click OK when you're ready to export.

      To learn more about the solution above, check this out: Export reports as Excel workbooks in QuickBooks Desktop. This article will also help you get updated reports while working in Excel.

       

      Keep me posted if there's anything else you need and I'd get back to you.

      bookkeepersr
      Oct 30, 2019 9:28 PM UTC

      Hi, I do know how to do that in Excel but it is more tedious.  I'd like to know if there is a way to set the default to no zero lines like in preferences or somewhere else for reports.  I don't ever want the zero line items on reports.  That would be so much more efficient.  Thanks

      Terms & ConditionsAccessibility statement