Skip to main content
December 11, 2018
Solved

What is the correct procedure to record a customer deposit (or prepayment towards an invoice) for a cash based business in order to correctly record sales tax?

  • December 11, 2018
  • 3 replies
  • 0 views

We run a cash based photography business, and I am struggling with how to correctly record our customer deposits. Customers pay $200 to book a date that will apply to the balance of their invoice - sometimes these can be in separate years. How do these get recorded so that the sales tax is recorded correctly and their invoices are accurate?

3 replies

December 11, 2018
December 11, 2018
Thank you! That does help. When handling it this way, does the sales tax get recorded in quickbooks on the date of the deposit/retainer, or does it get recorded on the date of the remaining balance paid? We are cashed based, so want to make sure I am paying sales tax when I should be. Sometimes deposits are paid months, sometimes close to a year, in advance.
March 15, 2019

not sure if you are still working on this problem...

the way you set up the pre-payment item determines whether the tax is applied to that item.

Think of it like you are selling your services on a tax-exempt basis for customer deposits. Mark the item as tax exempt (either in the set up of the item or on each line item on the sales receipt/invoice). Double check with the local sales tax authority to make sure that they don't require you to collect sales tax on deposits.

qbteachmt
December 11, 2018

Upfront prepayments are income for a cash basis entity, one that is not allowed to carry liability.

Prepayments that are taxable when you get them are also taxable when put on a credit memo to apply them (creates a negative sale and reversal of tax). Or, it is Not Taxed when you get it and Not Taxed when you use it to apply to the actual sale.

Putting it on a Sales Receipt = the date of this sale, just like any sale you report for Sales and sales taxes.

May 7, 2022

Income for sales tax purposes is ALWAYS reported in accrual basis, so it's irrelevant if you're cash basis.

 

Now, in your case, Since it is merely a deposit and not yet invoiced there's no sales tax due. So what you need to do is:

A. Create a Sales Order

B. Only use the following method to record customer deposits:

1. Use the "Make Deposits" screen to record deposits and make sure you choose your Customer deposit account (Liability) OR;

2. Use Journal entry: Debit Cash, Credit Customer Deposit Account (Liability)

What this will do is increase your liability and cash account, but it will not affect your income nor the "Sales Tax Liability" and "Sales Tax Revenue Summary" report. That means you are not declaring it as income and so you don't owe any sales tax. What a lot of people keep on forgetting is; that there's this "Sales Tax Liability" report in QB under the Vendor menu. If you get audited and they know that you are using qb, this is one of the reports the Auditor will request from you. 

 

Therefore, NEVER use the "Enter Sales Receipt" screen/template to record your customer deposit.  Although it is true that it will not show as income in your Profit and Loss Statement, it will certainly show as Sales income under the "Sales Tax Liability" report. This is what I've learned from programming my client's QB in the past 15 years. 

 

I hope this helps. Good luck!

 

www.theaccountantsgroup.com

March 8, 2023

Your answer is the BEST.   After entering deposits as sales receipts in a prior month, then sold the item in the next month.  It shows up on my Sales Tax report as Non taxable sales. In reading all the other help answers yours is the only logical one to use.  Because in TN it is not a sale yet, just a deposit. But after thinking it thru with my co-worker she had the same answer as you.  There is no way to enter this as Sales receipts or invoice even if you enter NON taxable QB records it as a sale.  THANK YOU so much!  Now to do some clean up.

April 25, 2024

I’m in this same position right now and I don’t quite understand what you did to fix this. Could you elaborate? Thanks!