Reports

A pleasant day, @Accounting4050,

I'll help show you the steps on how to exclude customers with zero balance.

You can simply customize the report by filtering the amount to greater than or equal to one.

Here's how:

1. On the Transaction Detail by Customer report, click Customize Report.
2. Go to the Filters tab.
3. Search Amount, choose the >= option, then enter 1 in the box.
4. Click OK to save the filter. 

That will do the trick.

To learn more about customizing reports, please read through here: Customize reports in QuickBooks Desktop.

Let me know if there's anything I can do with your reports in QuickBooks Desktop. I'm always glad to help.

I've already tried that.  It doesn't work.  I want to exclude all clients with a -0- Total at the bottom of each client's transactions.

Hello there, @Accounting4050.

I'd be delighted to provide you with additional details about generating Transactions Detail Report in QuickBooks Desktop.

Here's how:

1. Go to the Edit menu.
2. Select Preferences.
3. Choose Reports & Graphs.
4. Go to the Company Preferences tab.
5. Click Format button below Default formatting for reports.
   1. Choose the Fonts & Numbers tab.
   2. In the Show All Numbers section, put a check mark on Except Zero Amounts.
   3. Click Ok. 

That should do it! This will allow you to run reports and exclude all transactions that have 0.00 amounts on it.

Fill me in if you have other questions about customizing your transaction reports. I'm always here to help.

I followed your instructions in Preferences and checked "Except Zero Amounts".

The report still shows customers who have a zero balance.  

I think Except Zero Amounts does not reflect totals, only individual transactions.

I'm grouping transactions by Customer so I get a total by Customer.  I want the report to exclude any -0- Totals by Customer.

Allow me to jump into this conversation, Accounting4050.

I've got a few details to share with you about the report.

The Transaction Detail by Customer report lists individual transactions, showing each account involved on a separate line. If you're referring to removing the $0 on the report, you can follow the steps provided by my colleague, MaryLandT, then enter zero (0) instead of one (1).

I've attached a screenshot below, so you'll know what I'm referring to.

If you want to see the actual balance of a customer, you can pull up the Customer Balance Detail report. This will show you all unpaid balances for each customer and job.

Let me show you how:

1. Go to Reports.
2. Select Customer & Receivables.
3. Choose Customer Balance Detail.

Otherwise, removing a customer that has no charge or unpaid balance on the report hasn't been made available in QuickBooks Desktop. We are constantly improving our products feature to meet your needs.

I encourage checking back for any updates and feature enhancements through this link: Firm of the Future.

That should do it. Please let me know how it goes by leaving a comment below. I'll be around.