Customer Deposits

There are a number of ways to handle deposits customers make before an invoice for any work is created. We will describe two such methods in this section.

The easiest way is to just receive the customer payment as normal. When the customer is selected in the Receive Payment window, be sure no invoice is selected. Most of the time, there will be no open invoices for QuickBooks to list in this window. But, if there are, just make sure none of them are selected.

Save the transaction. QuickBooks make ask in a popup message if you want to apply the payment to an invoice or retain it as a customer credit. Retain as a customer credit.

When an invoice is created for the customer, QuickBooks will present an option to apply existing customer credits to the invoice. If that option is selected, the invoice will be partly or completely paid.

Some businesses prefer the see the balance for customer deposits on their financial reports and this is the technically correct way to manage them. If this option is chosen, begin by creating an item to be used for customer deposits.

item customer deposit

It is important that the account used in the item setup is an account used only for this purpose. Name the account in a way that makes sense to you, the QuickBooks user, but be sure it is setup as an Other Current Liability type of account in QuickBooks.

When a customer deposit is received, record it using a Sales Receipt.

sales receipt

Simple. For most people, the payment associated with this sales receipt will post to Undeposited Funds and can be deposited to the bank as normal.

The customer deposit will show on the balance sheet as a liability for the company, but will not be available as a credit on the customer’s account. If many deposits are taken, over time, it may be difficult to distinguish which customers have outstanding deposits and how much they are owed.

Double-click on the Customer Deposits line on the balance sheet, change the resulting transaction report to include a greater date range, perhaps all, and the following could be the result.

deposit report unfiltered

Who still has an outstanding deposit in the above report? While that can be determined, there is an easier way.

deposit report filtered

By changing the Total By field from Account list to Customer, the report shows at a glance the customer deposit total for each customer.

Since these customer deposits do not show in QuickBooks as customer credits, another way must be used to credit them against customer invoices as the sale is made.

When the invoice is created, add a line using the customer deposit item and a negative amount to subtract the customer deposit amount from the invoice total.

final invoice

As you can see from the screenshot of the filtered report on customer deposits, Chris Baker is one of our customers that no longer has an outstanding amount as a deposit. The way the above invoice has been created is the reason why.

Hector Garcia, CPA
Certified Advanced QuickBooks ProAdvisor
12401 Orange Drive #136
Davie, FL 33330
954-414-1524
hector@garciacpa.com

 

Hector Garcia

Hector Garcia

Hector Garcia is a CPA and QuickBooks Consultant.
Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022