Report Filter for zero subtotal

Yo_Be_Low2 · ‎October 02, 2024

We frequently look at a report in QBO with subtotals, but the only entries we're interested in are those for whom the subtotal is not zero. Is this possible to do in QBO reporting? If not, it would be a great feature.

To give some context about the specific report we're looking at ... it's essentially a transaction report of all transactions that occur in our customer pre-payment/deposit liability account. It details all customer pre-payment/deposit transactions. Most of of our customers have paid us a deposit at one time or another, but 95% have either been refunded or have had the deposit applied against a final payment. So 95% of our customers have a zero pre-payment/deposit balance. We're trying to identify those customers who do NOT have a zero balance. The only way we can figure out how to do this is to sorting and subtotaling this report by customer, and then scroll through the thousands of customers who have a zero balance to find those few who have a non-zero balance. This is incredibly tedious and time consuming.

If there was a way to filter out those customers with a zero subtotal, we could quickly see those who have a non-zero balance.

GenmarieM · ‎October 02, 2024

Thank you for taking the time to share your concern here in the Community about filtering subtotals in QuickBooks Online transaction reports, Yo_Be_Low2. I'll be happy to assist you with this.

To exclude zero subtotals from your report, you can generate a Transaction List by Customer report and apply the except zero amount filter. Let me guide you through the process.

Here's how:

Go to Reports, then search for Transaction List by Customer on the search bar.
Click General options.
Tick the checkmark beside the Don't show zero amounts.
Hit Refresh report.

That'll exclude all the customers with zero subtotals. Additionally, I'm adding this article as your reference in memorizing your customized reports in QBO: Memorize reports in QuickBooks Online.

Thank you for reaching out, Yo_Be_Low2. I hope the information and steps above have solve your concern about filtering out the customers with zero subtotals. If you have further questions or concerns, please don't hesitate to post a reply. Our team is available to help and looks forward to assisting you further.

Yo_Be_Low2 · ‎October 02, 2024

This solution does not work. It just hides the zero subtotal, but all the other non-zero transaction detail (that adds up to zero) is still displayed.

Rasa-LilaM · ‎October 02, 2024

We appreciate your thoughts on the solution shared by our colleague, Yo_Be_Low2. This information is important for enhancing the programs.

Our main goal is to always deliver a product that users can rely on for their business. We can send a request to our engineers to incorporate a feature that allows users to remove or hide none zero transactions (add up to zero). They'll look into customer recommendations and consider them in future releases.

Here's how:

Open your QBO company, and go to the Gear icon at the top to select Feedback.
Type a brief description of your product suggestions in the field box.
Click Next to submit.

Also, explore the QuickBooks Blog to learn what's up and coming about the product as well as innovations rolled out by our developers. Visit these resources to see the reports that come with each QBO version and the steps to personalize them using the modern view:

If you want to maintain your current customization settings for your reports or export them to Excel, take a look at the solutions in these articles:

If you have any product-related concerns or additional questions about customizing your reports, visit the Community again. We'll get back to you and provide the assistance you need.

Topics

Training

Community

Resources

Report Filter for zero subtotal