Skip to main content
January 5, 2021
Question

How to I exclude advance deposits from being counted as "sales"?

  • January 5, 2021
  • 3 replies
  • 0 views

Is there a way to invoice and record advance deposits / retainer deposits without QuickBooks including it as a sale to that customer? All of the procedures I've seen either result in the deposit being a "sale" amount when received as opposed to when it becomes income, or result in the deposit being counted in sales twice (once when received as an advance and again when applied as a payment to an invoice). Attributing the advance deposit to an "item" that is linked to a liability excludes it from income, sure, but not from sales. I should mention that all advance deposits are held in a separate bank account.

 

I usually just record it as a regular bank deposit (not linked to a sales receipt or invoice), and then receive it from the separate bank account via a sales receipt when it becomes income, which is an okay workaround some of the time. But if the client wants to pay using QuickBooks Payments (or whatever QuickBooks Desktop's ACH payment service is called), QuickBooks requires me to create an invoice, so the advance deposit is linked to that invoice and always recorded as a sale.

3 replies

john-pero
January 5, 2021

Recording the deposit as a liability, essentially a loan from your customer, does not include it in "sales" any more than obtaining an operating loan from a bank is a sale.

 

Yes, in order for your customer to pay through QB you issue an invoice. But this invoice should only reflect the liability account and nothing more. Once you invoice again for actual service you create a credit memo to apply the in hand deposit to the sale

AL13Author
January 5, 2021

From what I've seen, it is included in "sales" if it is linked to an invoice or sales receipt. So, if I create an invoice for the client to pay a $100 deposit in January and they submit that deposit in January, and then in March I create an invoice for $300 of work ($100 of which is paid from that deposit and $200 of which is a balance due), the "sales" are $100 in January and $200 in March, whereas they should be $0 in January and $300 in March.

January 5, 2021

Hello, AL13. 

 

Thank you for the additional explanation of your issue. Let's make sure you've added the deposit to the correct bank account and also check the date in the Make Deposit window to make sure you used the correct date and not some date later. 

 

If the date and account are both correct. You may want to consider rebuilding and verifying your data in case there's any damage. The Verify Data utility identifies any potential data damage issues, while the Rebuild Data utility repairs data in your company file.  

 

If the program is in multi-user mode, you need to change to single user mode (Go to File -> Switch to Single User Mode). It is very important that you have to create a backup copy of your company file before running Verify and Rebuild Data.  

 

Verify Data: 

 

  1. Press the File menu. 
  2. Choose Utilities from the drop-down option.  
  3. Select Verify Data
  4. Tap Ok to continue.  

 

Note: If the verify process is successful, you are done. In case it fails due to some problem, QuickBooks will notify you to run Rebuild data.

 

Rebuild Data:

 

  1. Click the File tab at the top. 
  2. Select Utilities from the drop-down option. 
  3. Choose Rebuild Data
  4. Click Ok on Rebuild has completed.     

As always, you can contact our QuickBooks Support team if you need assistance with the steps. They'll be able to pull up your account in a secure environment and help you navigate using one of their tools.  

 

Feel free to let me know if you have other questions about recording your payments. I'm always here to help. Have a great day!

BigRedConsulting
November 20, 2021

Given that retainers are a liability, then for as long as they are correctly characterized as a liability, they are not income to your business for income tax or sales tax purposes. They are not really even "sales", but instead a precursor to sales, rather like taking a down payment or "deposit" (not a bank deposit, but a deposit on account) for an order you are not yet ready to deliver. You might intend to order the product from a supplier or manufacture it at some later date, for example.

 

I can think of two ways to record retainers which will exclude them from sales reports and sales tax reports.

 

1) Record the retainers on invoices using an item that links to a liability account, as described in this thread.  However, instead of dating the retainer invoice with a current date, post date into the future far enough so it will stay off your sales reports until you go back and change it when you start to deliver on the sale. Record the money received as a Payment with a current date and apply it to the invoice. Later, when you actually deliver on the sale, edit the invoice, remove the retainer item, and add the appropriate sales items.

The issue I see with this method, if it matters to you, is that the payment will reduce your current AR account balance but the invoice, while dated in the future, will be invisible to your balance sheet and so you will not see the corresponding increase to the AR and liability accounts.

 

2) Record the payment received as you would if you were receiving a payment against an AR invoice, but don't create an invoice for the retainer and don't apply the payment to anything. This will reduce your AR account balance and - when you deposit it - increase your cash balance. Later, when you have something to bill the customer for, create an invoice and then edit the payment and apply it to the invoice. 

Optionally, so you can see the total of these retainer payments on your balance sheet, create a second/special AR account just for these unapplied payments. Use it when first receiving the payments. (An account field will automatically appear at the top of the payment form when you have more than one AR account.) When you do this, your balance sheet will show the full AR balance for your actual outstanding invoices and a negative/contra balance for the special account. Later, when applying a payment, change the AR account on the payment to your standard AR account and apply it to the invoice recorded there.

The "issue" with this method that I've heard in the past, which I don't really think is an issue, is that you'll have unapplied payments - payments for nothing at all. Some people think this is somehow bad. Notably, though, this works fine in QuickBooks (it does not care) and I think the accounting is just as it should be for a retainer or other unearned money received that is refundable.  Such money belongs only on the balance sheet, and not on sales reports or your Profit & Loss reports.  Sure, normally it's seen as a liability, but a contra-asset account, always with a negative balance, has the same effect on the balance sheet.

December 23, 2022

Almost 3 years since your question, but I've found an answer that works in Quick Books Online. I have not tested it in the Desktop version.

 

My conjecture was that using an invoice was causing Quickbooks to classify the transaction under "Sales". So the first step was to use journal entries -- first between A/P and a liability account "Customer Advance Payments"; then, when the customer pays, between A/P and a bank account. Unfortunately, this still resulted in the advance payment showing up in "Sales".

 

So then I looked at the journal entries to see if anything could be causing them to be considered "Sales". Sure enough, I had put "Exempt (Sales)" in the Sales Tax field. When I deleted this (the "Sales Tax" field is now empty) and hit "Save", the transaction magically disappeared from "Sales".

 

When you use a Sales Invoice in QBO, the Sales Tax field cannot be left blank. So using journal entries is the only workaround for this bug in QBO. It may be different in Desktop.