cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Explorer **

inactive vendors on Sales tax Liability report

Why do inactive sales tax vendors still show up on the sales tax liability report.  I recently revamped all of my California tax items and vendors and even if the balance with a vendor is 0.00 and the vendor is marked as inactive, they still show up on the Liability report.

5 Comments
QuickBooks Team

Re: inactive vendors on Sales tax Liability report

Hi k_trom,

 

QuickBooks will always show the sales tax vendors regardless of whether the balance is zero or not or even if it's set up as active or inactive. As a workaround, you can export the report to Excel and remove the inactive vendors from there. Let me guide you how.

  1. Click Reports.
  2. Select Report Center.
  3. Locate the report and click Run.
  4. Click Excel on the upper part.
  5. Select Create new worksheet.
  6. Click Export.

Once done, you can delete the inactive vendors so it won't show on the list.

 

I got this link in case you have other questions about QuickBooks Desktop: Taxes.

 

Please let me know if you have any other concerns. I'm always right here to help.

Community Explorer **

Re: inactive vendors on Sales tax Liability report

Unfortunately, my QB file is on a server which does not have excel and exporting a .csv is the only option, which is possible but requires a lot of reformatting to get it into a workable file (I sell all over the country and therefore have a lot of tax vendors.).  Any other suggestions from the community would be welcomed.  

Thank you for your response.

QuickBooks Team

Re: inactive vendors on Sales tax Liability report

Let me further assist you with your report, @k_trom

 

You can take note of your active vendors, then filter the report by name selecting only the active one. Here's how:

  1. Generate the Sales Tax Liability report. 
  2. Click the Customize Report button at the top to modify.
  3. Select the Filters tab on the window that appears.
  4. Below Choose Filter, select Name.
  5. Then, click on Multiple Names and click on name that you want to include in the report.
  6. Hit the OK button once you’re done.

Here's a screenshot:

 

Check the following articles for more information about this:

Let me know if there's anything else that I can assist by leaving a comment below. I'm always here to help. Have a good one!

Community Explorer **

Re: inactive vendors on Sales tax Liability report

This does not help.  The Sales Tax vendors do not show up in the "Name" filter.

QuickBooks Team

Re: inactive vendors on Sales tax Liability report

Thanks for getting back, k_trom.

 

All inactive vendors won't show on the Name filter. The best option I can suggest is to temporarily make them active again. That way, it will reflect on the Name filter and we'll be able remove it in the Sales Tax Liability report. These are the steps on how to reactivate them:

  1. Go to the Vendors menu and Vendor Center.
  2. Select All Vendors.
  3. Locate and double-click the inactive vendor.
  4. On the pop-up, remove the check for Vendor is inactive.
  5. Click OK to save.

Once done, let's follow again the steps shared by MaryJoyD to filter the report.

 

Reply again if you have more questions. 

Need to get in touch?

Contact us