Skip to main content
I
Ian77
January 4, 2024
Solved

desktop pro/ manage sales tax/ pay sales tax / there is an amount due that has no vendor (blank). I cannot clear this amount.

  • January 4, 2024
  • 1 reply
  • 0 views

Sales tax due amount (always the same amount) with blank in vendor block has been there for years and I have never found a way to clear it. Any suggestions? Thanks, Ian77

Best answer by BigRedConsulting

Thanks to all who are looking at this problem.

I am enclosing 2 items for your perusal.

First: a screenshot of the pay sales tax module in .pdf format.

Second: a copy of the sales tax liability report you requested going back to 1997.  It only shows the amount I use to offset the tax due item which seemingly came out of nowhere in the pay sales tax module.

Hopefully, this will help you understand the problem here. (As I am only allowed 1 attachment please note that the only amount in this report is the amount I use to offset the amount in question.)

Regards Ian77

 


Only one file was attached.

 

The line item on the Pay Sales tax window has neither a vendor name nor a payroll item. This normally not allowed in current versions of QuickBooks, though there may be a way to trick QuickBooks into letting it happen (or there used to be in older versions.)  It also could be a result of damage to one or more sales, where somehow both the item and the vendor name are lost.

 

The amount is very small and so may be from just one transaction. To find it, follow these steps:

1. Start with a Custom Transaction Detail report. from the QB menu at Reports | Custom Reports | Transaction Detail

2. Filter the report for your Sales Tax Payable report and for All dates. Run the report.

3. At the top of the report Total the report by Item Detail.

4. Scroll to the bottom of the report where there will be a section called "No item". The transaction(s) causing the -3.42 cent amount should be listed there.  You can double-click on the transaction(s) to open them. Then, determine the needed change to either stop using the Sales Tax Payable account or to fix it so that it has a vendor and tax item.

1 reply

C
Carneil_C
January 4, 2024

Hi there, @Ian77.

 

I've got your back in clearing the sales tax due amount in QuickBooks Desktop.

 

Please know that we're unable to adjust your sales tax without specifying the vendor. Since it shows blank, you can create a dummy vendor to select one before adjustment. You can reach out to your accountant before doing this process to ensure the accuracy of your books.

 

Here's how: 

 

  1. From the Vendor menu, select Vendor Center.
  2. Click the New Vendor drop-down on the upper right of the window.
  3. Enter the details needed.
  4. Click OK to save.

 

Once done, you can now start adjusting your sales tax due. I'll show you how:

 

  1. From the Vendors menu, select Sales Tax, then Adjust Sales Tax Due.
  2. Enter the adjustment date, sales tax vendor, adjustment account, and other relevant information.
  3. In the Adjustment section, choose if you need to increase or reduce sales tax, then enter the adjustment amount.
  4. Tick OK once done.

 

To learn more about it, please review this handy article: Process sales tax adjustment.

 

If you encounter problems while working on your sales tax, please visit this resource: Resolve common sales tax issues.

 

I'm still ready to back you up if you need more help with taxes in QBDT. I'll keep the thread open so you can comment back.

I
Ian77Author
January 4, 2024

Hi there,

Thank you for the quick reply to my question. Unfortunately, I have tried your solution more than once over the years without success as, I cannot create a tax vendor without a name.

I do have an account called "No Tax Vendor" which I use to adjust (offset) the amount in the Blank (No Vendor Name) field  when paying sales tax due. This keeps the actual sales tax due at the proper amount.

This, however, does not remove that amount from the pay sales tax module, as the amount shows up again the next tax reporting period.

How this amount showed up for the first time is still a mystery to me after 23 years of dealing with it. This started in June 1999 and all attempts to resolve have proven futile. I try to resolve it, get frustrated, and put it off till the next reporting period. I have to find a way to delete this amount from the pay sales tax module by other means, such as, a program patch, etc.

I hope this gives you some insight as to the problem here. I will provide additional info if you think it helpful.  Thanks again,  Ian77

    BigRedConsulting
    BigRedConsulting
    January 4, 2024

    You should be able to edit the tax item that has taxes with no vendor and then add a vendor, or perhaps change the vendor and then save the item and then edit it and change the vendor back and then save it again. Does that fix the issue?

    Terms & ConditionsAccessibility statement