Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 11, 2018
Solved

How to exclude inactive accounts from reports

  • December 11, 2018
  • 1 reply
  • 37 views

how to exclude inactive accounts from the P&L reports? or how can I delete the inactive accounts?

Best answer by Rustler

You can not delete an inactive account

if an inactive account has transactions for the report period, then it will show in reports as it should.  If the inactive account has a zero balance, some reports in customize allow you exclude zero balance accounts.

1 reply

Rustler
RustlerAnswer
Level 15
December 11, 2018

You can not delete an inactive account

if an inactive account has transactions for the report period, then it will show in reports as it should.  If the inactive account has a zero balance, some reports in customize allow you exclude zero balance accounts.

Rustler
Level 15
December 11, 2018
Laura, with the report on screen, scroll up and click customize, look for a statement that says except zero amounts in the general section and check that, run the report

If you are running a report that does not have that option in customize, let us know what report it is
November 20, 2024

We can customize the report to exclude inactive customers and zero amounts, @AlidaR. I'm here to provide the steps to omit them.

 

First, we need to manually choose the active customers to exclude the inactive ones from the report:

 

  1. Go to Reports and choose Report Center.
  2. Open the Job Progress Invoices vs Estimates report.
  3. Click Customize Report and choose the Filters tab.
  4. In the Search Filters field, type in Name.
  5. Choose Multiple names in the All names dropdown.
  6. Select Name page will pop up.
  7. Put a checkmark for the active customers from the list.
  8. Click OK.

 

Then, let's exclude the zero amounts:

 

  1. Still on the Job Progress Invoices vs Estimates report.
  2. Click Customize Report and choose the Filters tab.
  3. In the Search Filters field, type in Amount.
  4. Tick the greater than radio button (>=) and put 0 in the field beside it.
  5. Click OK.

 

Additionally, you can memorize your reports for future use to save the personalization you've made.

 

Let us know if you have other queries about customizing your reports in QuickBooks Desktop. We'll be here to lend a hand.


Is there an option to filter the report by customers that are marked "Inactive" without my having to choose the individual names myself? IF they are marked inactive in QB desktop, I do not want them in my customer contact report, my sales summary report or basically any customer based report. They are already marked as INACTIVE.