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.
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.
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.
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.
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:
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!
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:
Once done, let's follow again the steps shared by MaryJoyD to filter the report.
Reply again if you have more questions.