cancel
Showing results for 
Search instead for 
Did you mean: 
Ian77
Level 2

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

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

Solved
Best answer January 04, 2024

Best Answers
BigRedConsulting
Community Champion

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

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.

View solution in original post

9 Comments 9
Carneil_C
QuickBooks Team

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

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.

Ian77
Level 2

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

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
Community Champion

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

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?

Ian77
Level 2

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

Hello,

The tax item in question does not exist anywhere except in the Pay Sales Tax module. I have looked back as far as 1997 and only found one instance of this amount which was a sales tax discount item,  properly applied at the time of filing (June 1999). Somehow, within Quickbooks, the item duplicated itself as a tax due with no vendor name and only shows up in the pay sales tax module. It does not appear in any ledger at any time except as an attempted adjustment to clear it from the pay sales tax module. Due to there being no vendor name associated with the amount, I cannot permanently clear it from the module. (Any transaction in the pay sales tax module must contain a vendor name)

This is why I am seeking another method to delete or remove this figure from the pay sales tax module.

Thanks for your interest.   Ian77

Rea_M
Moderator

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

We appreciate you getting back to us and providing more details about your sales tax concern, Ian77. We can use the Sales Tax Liability report to identify which sales tax item is the source of the amount and resolve the issue. I'll guide you on how to do this.

 

In addition to BigRedConsulting's recommendation, we'll have to determine the cause of the issue by pulling up a sales tax report. To do this, here's how:

 

  1. Go to Reports.
  2. Select Vendors & Payables, then Sales Tax Liability.
  3. Customize if necessary.
  4. Locate the sales tax amount in question and double-click it to view its details.
  5. Identify the sales tax item used.

 

After you recognize the item, refrain from using it again and then make the required adjustment to correct your sales tax return.

 

Once everything is all set, remit your sales taxes to the appropriate tax collecting agency. To guide you on how to do this, please see this article: Pay sales tax.

 

Let me know in the Reply section if you need more help with your sales tax return in QBDT. The Community is always ready to help you out.

Ian77
Level 2

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

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

 

BigRedConsulting
Community Champion

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

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.

Ian77
Level 2

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

Yay!

In the report you recommended, I found 2 items totaling $3.42 from March & April of 1999 that were sales tax adjustments but had no tax vendor assigned. I corrected these entries, and made a general journal entry to reverse the now no longer (blank) tax due and no tax vendor amounts. Tax due, after the current remittance is now $0. The $3.42 amount no longer appears in the pay sales tax module.

Many thanks once again to all who helped solve this decades old problem.Your dedication and expertise will long be remembered!

Ian77

 

Ian77
Level 2

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

To allay any confusion as to weather the solution proposed by Big Red Consulting was helpful, please note that running the suggested report revealed the 2 entries which combined, for years, had been continually causing an amount to show as payable in the pay sales tax module but had no tax vendor assigned.

I am very grateful to Big Red Consulting and all who helped me resolve this issue. Thanks again,  Ian77

Need to get in touch?

Contact us