How to Resolve Common Sales Tax issues in QuickBooks Desktop Enterprise?

Tax issues are common issues for QuickBooks users and must be dealt with on time to prevent hampering business productivity. […]

Voiced by Amazon Polly

Tax issues are common issues for QuickBooks users and must be dealt with on time to prevent hampering business productivity.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

In today’s article, learn how to fix problems or unwanted results you may experience when handling sales tax in QuickBooks Desktop.

Listed below are some of the sales tax issues experienced by QuickBooks users.

Fix Invoice Prints “T” even When the Sales Tax option is Switched off Error

Invoice in QuickBooks Print “T” beside Taxable Amount even when the sales tax option is switched off. The primary reason can be a damaged invoice template (Edit Invoice Template). Intuit suggests more than one troubleshooting method for such a problem. The first troubleshooting method may fix your issue or you require to try all the solutions to fix the problem. To get optimum results, execute the solutions in the order displayed below:

Method 1: Prepare a New Template

Step 1: From the menu, Choose Lists and then choose Templates.

Step 2: In the Templates screen, Choose the Templates drop-down seen at the bottom. Now select New.

Step 3: Select the template type. Now choose OK.

Step 4: Allocate a template name and then save the customization.

Method 2: Replicate the Particular Template

Step 1: From the menu section, Select Lists. Now choose Templates.

Step 2: In the Templates screen, Choose to highlight the particular template you utilize for the given invoice.

Step 3: Choose the Templates drop-down seen below. Now select Duplicate.

Step 4: In the screen for Select Template Type, select Invoice. Now choose OK.

Step 5: Open a particular invoice and then use the duplicate template.

Method 3: Default to the Template Copy

Step 1: From the menu for Lists, Choose Templates.

Step 2: In the Templates screen, Choose the Invoice Template.

Step 3: In the screen for Basic Customization, Choose Additional Customization.

Step 4: Select Default. Then click OK on the particular dialogue box that gets displayed.

Step 5: Choose OK.

Fix the Sales Tax Payable is incorrect after using the Write Checks Window to Pay Sales Tax Error

Before proceeding to fix this issue, ensure that you use the Pay Sales Tax screen. Make sure you do not utilize the Write Checks option while recording a particular payment for Sales Tax.

In order to fix this issue while using QuickBooks Enterprise or QuickBooks Accountant, utilize Client Data Review. If you use any other QuickBooks edition, use the steps provided below:

Step 1: Back up the QuickBooks Company File

Step 2: Locate the wrong sales tax payments by navigating to the Bank Register that is utilized to do the payments

Step 3: Enter the Sales Tax Payments again

  • From the given Vendors menu, choose Sales Tax. Now select Pay Sales Tax.
  • In case you have one or more than one checking account, Select the one you wish to utilize for such tax payments in the particular Pay from Account.
  • Review the Ending Bank Balance below the screen to ensure you have adequate money in the particular checking account to do the sales tax payments. In case not, Select a new checking account
  • In the field for Check Date, Add the date of the particular sales tax payment. Begin with the payment that is the oldest one
  • Under the option, Show Sales Tax Due Through, Edit the date when the payment period date ends
  • In the column for Pay, Review to choose the items you wish to pay
  • In case you wish to edit the amount of any of the items, choose the amount provided in the column for Amount Paid. Now perform the change
  • Confirm whether the original amount and total amount matches or not. Now choose OK
  • You may witness a message, Problem: Another Check already has a number [xxx]. Choose Keep Number. It will save the actual original check number when deleting the actual sales tax payments later on.
  • In case you have additional payments to add, repeat the 2nd step to the 9th step for every payment before beginning

Step 4: Delete the Actual Payment Transactions from different Areas in your QuickBooks Account

  • From the provided Lists menu, Choose Chart of Accounts.
  • Now click the bank account that you used twice when you add the payment twice
  • Go down the sales tax payment date to change. It is important to note that because the date on both the re-entered and original payment is the same, you must review the entries closely to each other.
  • The payment that is entered again will be a TAXPMT. In case the actual payment is already cleared by the bank, Ensure that a checkmark is added to the TAXPMT entry. Now choose Record.
  • In case your sales tax payment are not written in sequential order and are written to one or more tax agencies, It is necessary that you edit the Number of the particular checks that are recreated in the register so that they match the original check numbers before you select Record.
  • Choose the actual sales tax payment and then in the Edit menu section, Choose Delete Check. In case you added a big and then made a bill payment check, It is necessary that you remove the bill to ensure that it does not appear in the Unpaid Bills Detail report.
  • Now repeat steps 3 to 6 for every sales tax payment you added again

Step 5: Confirm that the Problem is Resolved

  • Run the Report for Sales Tax Liability via the present date. Now compare it with the Sales tax Payable account balance.
  • View the vendor balances for every tax agency by running the report for Vendor Balance Detail.
  • Now run the Vendor Report Transaction list to make sure that there are zero duplicate payments.

Fix Warning: You must Specify a Vendor Name for the Sales Tax Account Error

To fix this issue, you need to add a vendor name in the column for Customer: Job while writing a check that is utilized for sales tax payable account or preparing a journal entry.

Fix Negative Sales Tax Payable on the Cash Basis Balance Sheet Report error

The cash basis Balance Sheet displays a negative amount for your particular a sales tax payable, showing that the province or state needs to pay you money.

When you pay sales tax at month end, you can clear the amount in the month when you prepare the invoice or the month when you get money for the invoice. It is quite likely that you will witness a negative balance for the particular Sales Tax Payable account in the given Balance Sheet report in case you pay on the accrual basis and then on a cash basis you run the report.

Note: You are required to ensure that QuickBooks is fixed on the proper basis. Also, you may be needed to get in touch with QuickBooks professionals to make sure that you are clearing off your sales taxes in a correct manner.

Here is How You Set the Sales Tax Basis in QuickBooks:

Step 1: Login as an administrator to your particular Company data.

Step 2: Now shift to single-user mode (File > Switch to Single-user Mode).

Step 3: From the provided Edit menu, Choose Preferences.

Step 4: In the particular Preferences screen, Choose Sales Tax provided in the side-bar. Now select the Company Preferences tab.

Step 5: In the section when do you owe sales tax? Choose the right basis for your enterprise.

Step 6: Press OK.

Fix Inactive Sales Tax Items affect a Sales Tax Group Error

When a specific Sales Tax item is fixed to be Inactive, it is not deleted from the allocated Sales Tax Group. The sales tax items that are inactive should be deleted from the Sales Tax Group in order to let the active Sales Tax items be applied in the right manner.

Step 1: From the given Lists menu, Choose Item List.

Step 2: Press on the concerned Sales Tax Group tab twice.

Step 3: Highlight the specific sales tax item or items you wish to delete. Now choose CTRL + Delete.

Step 4: Press OK.

Note: In case there are invoices that were prepared using the Sales Tax Group along with the last Sales Tax Item, this modification will not impact how such invoices were determined.

Fix an Error When trying to Create a Credit Memo

When you prepare a credit memo from any particular invoice or sometimes from the Customers menu, you get a warning notification that says, Error. The possible reason for this error can be that the invoice may comprise a sales tax item. Not to mention, the error can also arise because the Sales tax settings is turned off in the particular company file.

In order to Prepare the Credit Memo, it is important that you switch on the Sales Tax option. After that, prepare the credit memo and then the Sales Tax should be turned off. Here is how you do it:

Step 1: Turn on Sales Tax in the provided company file. For that, go to the Edit menu and choose Preferences.

Step 2: On the left-side of the pane, select Sales Tax. Now navigate to the tab for Company Preferences.

Step 3: Select the Yes radio button that says, Do you charge sales tax?

Step 4: Now prepare the Credit Memo.

Step 5: Now turn off the Sales Tax in the given company file by doing as per the directions in step 1 Now choose No for Do you charge sales tax option.

Fix Warning: This item is used in Customer Data. It cannot be Deleted Error

You are removing a sales tax item and then an error message appears, Warning, this item is utilized in Customer Data. Hence, it cannot be deleted.

The most possible cause is that the sales tax item you wish to delete is allocated to a minimum one customer on the Additional Info tab of the particular Edit Customer screen.

In case the sales tax item is not used on any transaction and is not allocated to any clients, you can easily delete the item.

In order to delete the sales tax item from your specific list of customers with the help of the Customer Contact List report, perform the steps below:

Step 1: From the provided menu for Reports, choose List. Now click Customer Contact List.

Step 2: Choose Customize Report.

Step 3: From the provided list of available columns, Choose the Tax Item.

Step 4: Choose the Sort By drop-down and now choose Tax Item in order to classify the report and then locate the customer connected with the item easily.

Step 5: Press OK.

Step 6: Press twice and choose any customer with the right sales tax item in the provided Tax Item column.

Step 7: In the screen for Edit Customer, Navigate to the Sales Tax Setting tab.

Step 8: From the Tax Item field, Delete the tax item you want to select or remove another sales tax item.

Step 9: For all the customers connected with the sales tax item, perform step 7 and step 8.

Step 10: After the item is not linked with any customers, you can remove or delete it. From the provided List menu, select the particular Item List. Now press right-click and choose the Sales Tax item. Now choose Delete.

Fix the Sales Tax Line Item does not Appear When Printing Invoices Error

In order for the Sales Tax to be printed as an individual line item on any invoice, there should be a description provided in the given description field of the given Sales Tax item in the displayed Item List.

In order to add a description to the sales tax item, perform the steps provided below:

Step 1: From the Lists option, choose menu. Now choose Item List.

Step 2: Now press twice on the particular Sales Tax item that does not get displayed on the invoices that are printed.

Step 3: In the provided Description field, Enter Sales Tax. You can also add the description for the particular Sales Tax item as you wish it to appear on the Invoice post printing.

Step 4: Press OK.

Fix Your Existing Credit with [Vendor Name] is Sufficient to Pay Your Sales Tax due Error

Paying Sales tax in the provided Pay Sales Tax screen and choosing a sales tax item along with a discount that was added in the Sales Tax payable register will lead to the following message:

Your existing credit with [vendor name] is sufficient to pay your sales tax. A check will not be written for this vendor.” The possible cause for the occurrence of this error can be:

  • While implementing the discount to the particular amount due in the Sales Tax screen, a check is not printed, however, the payment in the Sales Tax payable register is recorded for the complete amount and the discount is not applicable.
  • A sales tax discount lacks the same vendor name as the Sales Tax item.

Here are the Steps for the Solution to this Error:

Step 1: From the provided Lists menu, Select the Chart of Accounts.

Step 2: Press on the Select Sales Tax Payable Account twice in order to open the register.

Step 3: Locate the sales tax payment that was added and choose the payment.

Step 4: From the provided Edit menu, choose Delete Sales Tax Payment. Now select OK.

Step 5: Leave the particular Sales Tax Payable register open.

Step 6: From the given Vendors menu, select Sales Tax and then choose Pay Sales Tax.

Step 7: Confirm that the discount does not include the same vendor name as the sales tax item. Take note of the vendor name on the provided sales tax item.

Step 8: Choose OK in order to close the screen for Pay Sales Tax.

Step 9: Now navigate to the Sales Tax Payable register.

Step 10: Locate the discount and edit the vendor name to match with the particular vendor name linked with the sales tax item.

Step 11: Choose Record in order to save the changes.

Step 12: From the provided Vendors menu, Select Sales Tax. Now choose Pay Sales Tax.

Step 13: Add a check in the Pay Column beside the correct items to choose both the discount item and the sales tax item.

Step 14: Press OK in order to close the screen for Pay Sales Tax.

We hope that this article was informative enough for you to learn how to fix common sales tax issues in QuickBooks. We have highlighted almost all the concerning problems and their solutions. Just ensure that you comprehend properly what is the issue and how it impacts your business.

If you need any kind of professional assistance or help to fixing Common Sales tax issues in QuickBooks, you can get in touch with our Dancing Numbers team via LIVE CHAT.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Call Now+1-800-596-0806
Top