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

Problem with Quickbooks 2020 desktop not properly recording non-refundable deposits in sales tax liability report

I have followed the post in quick books community on how to manage upfront deposits or retainers and how to properly record them as a liability, then when necessary how to keep all or part of the deposit.  I have no issues when I move the deposit to a customer invoice however, when I try to keep any of the deposit due to the job cancelling, this is where I am having issues.  I followed the instructions in the post  to create an invoice debiting the upfront deposit account and crediting the customer job that had the deposit for the same amount which creates a zero balance invoice.  All seems well except I am having issues with it not posting the amount to the Sales Tax Liability Report properly. For some reason the Sales Tax Liability Report is posting a debit and credit for the same amount which cancels itself out. It should be adding this amount to my non taxable sales tax column so I can report this amount as sales to the state. What seems strange is the sales in the P&L report shows the correct amount.

I am hoping someone can help me with this issue as I have multiple non-refundable deposit that I need to report as sales to the state and can't find a way to make this happen.

Any thoughts would be greatly appreciated.

I was hoping I could reply to the original post on the community so this question would make more sense, but wasn't able to do this. I am sure it is operator error, as I have never posted to the community before, trying to figure it out.

Thanks in advance.

 

 

4 Comments 4
Anna S
QuickBooks Team

Problem with Quickbooks 2020 desktop not properly recording non-refundable deposits in sales tax liability report

Thanks for joining the Community, @Hunters16.

 

I hope you're having a successful week so far. Based on the information you provided, I recommend running a verify and rebuild for troubleshooting purposes. This will fix any discrepancies on reports and account for any missing transactions. The steps below will show you how:

 

Verify Data:

  1. Go to Window and click Close All.
  2. Navigate to the File tab, hover over Utilities, and choose Verify Data.

 

       3. If you get any specific error message, such as, "Your data has lost integrity," proceed to the rebuild steps below.

 

 

Rebuild Data:

  1. In the File menu, cruise over Utilities, and select Rebuild Data.

 

       2. Back up your company files to start the rebuild process.

       3. Hit OK when your receive the "Rebuild has complete" message.

 

 

Now your Sales Tax Liability report should run as usual and adding the correct amount to your nontaxable sales tax column. You may find these articles helpful as well:

 

 

Feel free to reply below if you have any other questions. Wishing you continued success now and in the future.

Hunters16
Level 1

Problem with Quickbooks 2020 desktop not properly recording non-refundable deposits in sales tax liability report

Anna S.

Hello,

Thank you for your reply and possible solution. I followed the process to verify and found a few errors, rebuilt data, re verified and all errors have been cleared. Unfortunately, my issue still exists. Any other thoughts you may have would be greatly appreciated.

Thank you! 

MariaSoledadG
QuickBooks Team

Problem with Quickbooks 2020 desktop not properly recording non-refundable deposits in sales tax liability report

Thanks for reaching back to us, Hunters16.

 

Since you've already performed the troubleshooting steps and is still getting the same issue, I suggest contacting our phone support team. They have the tools to pull up your account in a secure environment and help you verify why deposit is not recording on the Sales Tax Liability report.

 

Here's how: 

  1. Open QuickBooks.
  2. Go to Help, then select QuickBooks Desktop Help.
  3. Select Contact Us.
  4. Enter your concern, then select Continue.
  5. Choose a way to connect with us:
    • Post a question and get an answer from expert and other customers.
    • Start messaging with a support expert.
    • Get a callback from the next available expert.

You also run and customize reports in QuickBooks Desktop to show the information you need. Please visit this article: Understand Reports.

 

Let us know if there's anything else you need to know. We're always right here to help you anytime.

Hunters16
Level 1

Problem with Quickbooks 2020 desktop not properly recording non-refundable deposits in sales tax liability report

Thank you for your help, I will contact Quickbooks for a solution.

Need to get in touch?

Contact us