cancel
Showing results for 
Search instead for 
Did you mean: 
kt1100
Level 1

How to debit the Sales Tax Payable account

I'm using QuickBooks Enterprise Solutions 22.0. Apparently, I am not using the Pay Sales Tax module correctly because the Sales Tax Liability account is not being debited after payments are made, it just continues to increase each month. BTW, I'm paying the sales tax via the Florida Department of Revenue website. I run the Sales Tax Liability Report, then use that info to pay the sales tax online with a checking account. Then I go back to the QB Pay Sales Tax module and enter the amount paid for each county per the STLR. I thought I was done. But I now notice that the Sales Tax Liability account has steadily increased. The account is not being reduced by this method. I am missing something. Please advise. Thanks.

Solved
Best answer December 22, 2023

Best Answers
Adrian_A
Moderator

How to debit the Sales Tax Payable account

Hi kt1100,

 

I'm here to enlighten you as to why the sales tax payable account is increasing.

 

When you record tax payments, it is advisable to use the Pay Sales Tax window. Writing a check will cause you to increase your liability since it will not affect the liability account. To fix it, you'll have to reenter those tax payments. I'll guide you through the steps.

 

First, let's back up your QuickBooks file so we can restore it if ever you run into problems.

 

Second, find the incorrect sales tax payments through the Bank Register page. Then, let's reenter those payments. Here's how:

 

  1. Click the Vendors menu.
  2. Under Sales Tax, select Pay Sales Tax.
  3. If you have more than one checking account, choose the one you want to use for these tax payments in the Pay From Account. Then, review the Ending Balance.
  4. In the Check Date field, enter the date of the sales tax payment. Start with the oldest payment first.
  5. Under Show sales tax due through, change the date to the end of the payment period in question.
  6. In the Starting Check No. field, type the check number used in the original payment.
  7. In the Pay column, check to select the items you want to pay.
  8. If you need to change the amount for any of the items, select the amount in the Amt. Paid column, and make the change.
  9. Verify that the total amount matches your original payment, then select OK.
  10. If the system prompts you with a Problem: Another Check already has number [xxx]... message, select Keep Number

 

Then, repeat steps number 2 to 10 for each payment before proceeding.

 

Afterward, let's remove the original payment transaction from other areas in QuickBooks. Here's how:

 

  1. From the Lists menu, select Chart of Accounts.
  2. Double-select the bank account you used when you re-enter the payment.
  3. Scroll to the date of the sales tax payment to change. (You should see the entries near each other since both the original and the re-entered payment are the same.
  4. The re-entered payment will be a TAXPMT type. If the original payment already cleared your bank account, put a checkmark on the TAXPMT entry then select Record.
  5. Select the original sales tax payment.
  6. On the Edit menu, select Delete Check.

 

Then, repeat steps number 3 to 5 for the rest of the payments.

 

Once done, you can run these reports to verify that the issue is solved:

 

  • Sales Tax liability report - run the report through the current date and compare it against the balance of your Sales Tax Payable account.
  • Vendor Balance Detail report - check the vendor balances for each tax agency
  • Transaction List by Vendor report - to ensure there are no duplicate payments.

 

Furthermore, I've added this article on how you can handle cash basis sales tax: Handle cash basis sales tax.

 

I'm always around whenever you have concerns about recording sales tax payments.

View solution in original post

3 Comments 3
Adrian_A
Moderator

How to debit the Sales Tax Payable account

Hi kt1100,

 

I'm here to enlighten you as to why the sales tax payable account is increasing.

 

When you record tax payments, it is advisable to use the Pay Sales Tax window. Writing a check will cause you to increase your liability since it will not affect the liability account. To fix it, you'll have to reenter those tax payments. I'll guide you through the steps.

 

First, let's back up your QuickBooks file so we can restore it if ever you run into problems.

 

Second, find the incorrect sales tax payments through the Bank Register page. Then, let's reenter those payments. Here's how:

 

  1. Click the Vendors menu.
  2. Under Sales Tax, select Pay Sales Tax.
  3. If you have more than one checking account, choose the one you want to use for these tax payments in the Pay From Account. Then, review the Ending Balance.
  4. In the Check Date field, enter the date of the sales tax payment. Start with the oldest payment first.
  5. Under Show sales tax due through, change the date to the end of the payment period in question.
  6. In the Starting Check No. field, type the check number used in the original payment.
  7. In the Pay column, check to select the items you want to pay.
  8. If you need to change the amount for any of the items, select the amount in the Amt. Paid column, and make the change.
  9. Verify that the total amount matches your original payment, then select OK.
  10. If the system prompts you with a Problem: Another Check already has number [xxx]... message, select Keep Number

 

Then, repeat steps number 2 to 10 for each payment before proceeding.

 

Afterward, let's remove the original payment transaction from other areas in QuickBooks. Here's how:

 

  1. From the Lists menu, select Chart of Accounts.
  2. Double-select the bank account you used when you re-enter the payment.
  3. Scroll to the date of the sales tax payment to change. (You should see the entries near each other since both the original and the re-entered payment are the same.
  4. The re-entered payment will be a TAXPMT type. If the original payment already cleared your bank account, put a checkmark on the TAXPMT entry then select Record.
  5. Select the original sales tax payment.
  6. On the Edit menu, select Delete Check.

 

Then, repeat steps number 3 to 5 for the rest of the payments.

 

Once done, you can run these reports to verify that the issue is solved:

 

  • Sales Tax liability report - run the report through the current date and compare it against the balance of your Sales Tax Payable account.
  • Vendor Balance Detail report - check the vendor balances for each tax agency
  • Transaction List by Vendor report - to ensure there are no duplicate payments.

 

Furthermore, I've added this article on how you can handle cash basis sales tax: Handle cash basis sales tax.

 

I'm always around whenever you have concerns about recording sales tax payments.

kt1100
Level 1

How to debit the Sales Tax Payable account

OK, got it, thanks. Actually, I was mistaken. Upon closer inspection of the Sales Tax Payable ledger, I see that in fact my payments have debited the account. When I posed my question I was alarmed by the large balance in the Sales Tax Payable account. I forgot - didn't think - that when I pay the monthly Florida sales tax, I am only paying the tax collected in the previous period and not the entire sales tax liability. DOH! My bad. 

Kevin_C
QuickBooks Team

How to debit the Sales Tax Payable account

Thanks for updating us on this, kt1100.

 

On behalf of my colleague, Adrian_A, you're most welcome. Please know that the QuickBooks Community will always be around to lend you a hand any time you need guidance.

 

You can always keep in touch if you need further assistance with any QuickBooks-related tasks. I hope you have a pleasant day ahead. Stay safe always!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us