cancel
Showing results for 
Search instead for 
Did you mean: 
Jolynn0501
Level 1

Sales Tax Liability Report (Remove Inactive Groups)

Hello - 1st time user of the community.  I recently 'inactivated' a set of local taxes from a Sales Tax Group setup in QB by the prior bookkeeper.  We do not use these codes and I want to see the Liability report w/o all these excess zero lines.

1. They are inactive.

2. I tried the report options to show only NON ZERO transactions.  Tested a few to make sure they were not ZERO as a result of + / - activity.

 

I am getting pages of ZERO line items and want only tax labilities for the new codes I am setting up.

 

Solved
Best answer January 12, 2021

Best Answers
JenoP
QuickBooks Team

Sales Tax Liability Report (Remove Inactive Groups)

We're glad to see you here in the Community, Jolynn0501.

 

Inactive items will still show up in the report. Make sure to select Non Zero for both Rows and Columns when customizing the report. Here's how:

 

  1. Go back to the Sales Tax Liability report. 
  2. Click Customize Report, then click Advanced under the Display tab. 
  3. Select Non-zero for both Display Rows and Display columns.
  4. Click OK

Aside from that, you can also add more filter so you can only see the new tax codes that you created. Here's how:

 

  1. Proceed to the Filters tab.
  2. Type in Items in Search bar and click Item once you see it.
  3. Click the drop-down list for All items and select Multiple items.
  4. Check all the newly added codes and click OK

Let me also share this article with you about customizing reports for more details: Customize Reports In QuickBooks Desktop.

 

The Community is always here if you have follow-up questions. 

 

non zero.PNG non zero 2.PNG non zero 3.PNG

View solution in original post

1 Comment 1
JenoP
QuickBooks Team

Sales Tax Liability Report (Remove Inactive Groups)

We're glad to see you here in the Community, Jolynn0501.

 

Inactive items will still show up in the report. Make sure to select Non Zero for both Rows and Columns when customizing the report. Here's how:

 

  1. Go back to the Sales Tax Liability report. 
  2. Click Customize Report, then click Advanced under the Display tab. 
  3. Select Non-zero for both Display Rows and Display columns.
  4. Click OK

Aside from that, you can also add more filter so you can only see the new tax codes that you created. Here's how:

 

  1. Proceed to the Filters tab.
  2. Type in Items in Search bar and click Item once you see it.
  3. Click the drop-down list for All items and select Multiple items.
  4. Check all the newly added codes and click OK

Let me also share this article with you about customizing reports for more details: Customize Reports In QuickBooks Desktop.

 

The Community is always here if you have follow-up questions. 

 

non zero.PNG non zero 2.PNG non zero 3.PNG

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up