How to Collect Prepayments/Deposits in QuickBooks Desktop with a Customer Liability Account

If a customer prepays for a product/service that is considered a “liability.”

A liability is “the state of being responsible for something, especially by law.”

Meaning, your customer paid you. Now it’s on you to provide the product/service they paid for.

These payments do not count as income. Instead, they go into a prepaid liability account. Once you provide the goods/services and are ready to collect funds from the customer that’s when the payment becomes income.

Here’s an overview of how to account for these prepayments in QuickBooks Desktop:

  1. Create a liability account.
  2. Map an item to that liability account.
  3. Use that item on invoices to record prepayments/deposits from customers.
  4. When you collect payment for goods/services use the item mapped to the liability account on the invoice.

For this tutorial, I’ll show you how to create a liability account and map an item to that account. I’ll also show you an example of a prepayment being collected and applied to an invoice.

I’m using QuickBooks Premier 2022. The instructions are the same for all 2022 versions of QuickBooks Desktop.

Quick Instructions:

Create a Customer Prepaid Liability Account

  1. In the top menu click Lists -> Chart of Accounts
  2. In the bottom menu click Account -> New
  3. Select Other Account Types
  4. In the drop-down menu select Other Current Liability
  5. Click Continue
  6. Fill in Account Name
  7. Fill in Description (optional)
  8. Click Save & Close

Map an Item to the Customer Prepaid Liability Account

  1. In the top menu click Lists -> Item List
  2. In the bottom menu click Item -> New
  3. In the Type drop-down select Service
  4. Fill in Item Name/Number
  5. Fill in Description (optional)
  6. In the Account drop-down select your new liability account
  7. Click OK

Request a Prepayment/Deposit 

  1. On the Home Page click Create Invoices
  2. In the CUSTOMER:JOB drop-down menu select the customer/client you’re requesting the prepayment from
  3. Fill in the following:
    • QUANTITY: 1
    • ITEM: The item mapped to your customer liability account
    • DESCRIPTION: The reason for collecting the deposit
    • PRICE EACH: The deposit amount you’re collecting
  4. Click Save & Close

Receive a Prepayment/Deposit

  1. In the top menu click Customers-> Receive Payments
  2. In the RECEIVED FROM drop-down select the customer making the prepayment/deposit
  3. Select the invoices being paid
  4. Click Save & Close

Apply a Prepayment to an Invoice

  1. On the Home Page click Create Invoices
  2. In the CUSTOMER:JOB drop-down menu select the customer/client you’re invoicing
  3. Add the product/services you’re invoicing the customer for
  4. Add the item mapped to your customer liability account
  5. Give the item a negative dollar amount equal to the prepayment/deposit
  6. Click Save & Close

Keep reading for a complete walkthrough with screenshots:

Create a Customer Prepaid Liability Account

To create your Liability account click Lists in the top menu, then select Chart of Accounts.

Navigating to the Chart of Accounts in QuickBooks Desktop.

At the bottom of the Chart of Accounts click Account and select New from the menu.

Creating a new account in the Chart of Accounts in QuickBooks Desktop.

Select Other Account Types and from the drop-down menu click Other Current Liability.

Other Account Types drop-down when creating an account in QuickBooks Desktop

Other Current Liability accounts are for tracking money your business owes and expects to pay within one year. If you think it’ll take longer than a year select Long Term Liability. Click Continue.

Now you’ll give your new account a name. I’m using “Client Prepaid Funds” you can use any name you’d like.

Entering a description, account number, routing number, and mapping to a tax-line are all optional.

When ready click Save & Close.

Entering account information for an Other Current Liability account in QuickBooks Desktop.

Your new account will now appear in your Chart of Accounts.

Your new account in the Chart of Acccounts in QuickBooks Desktop.

When there’s value in this account it will appear in the Balance Sheet in the Liabilities section.

Map an Item to a Customer Prepaid Liability Account

Now you’ll need to create an item to map to this account. 

In the top menu click Lists  -> Item List.

Opening the Item List in QuickBooks Desktop

At the bottom of the screen click Item then select New from the menu.

Creating a new item in QuickBooks Desktop

From the Type drop-down select Service.

Item Name/Number is the name that will appear on invoices in reports. I’m calling mine “Customer Deposit.”

The Description is optional. But it’s a good idea to enter something that will remind you how you’re using this item.

There’s no Rate to enter.

For the Account, find the liability account you created earlier from the drop-down menu.

When you’re done filling out this screen click the blue OK button.

Creating an item to map to a customer liability account in QuickBooks Desktop

This item is now mapped to your customer prepaid liability account.

Request a Prepayment/Deposit from a Customer

Let’s imagine you have a customer you’d like to collect a prepayment from. 

First, you’ll need to create an invoice. From the Home Page click Create Invoices.

Creating an invoice from the QuickBooks Desktop Home Page.

Select the customer you’re requesting the prepayment from in the CUSTOMER:JOB drop-down.

  • QUANTITY:  1
  • ITEM: The customer deposit item you created earlier
  • DESCRIPTION: The reason for collecting the deposit
  • PRICE EACH: The deposit amount you’re collecting

When you’re ready click the Save & Close button at the bottom of the screen.

Creating an invoice to collect a customer PrePayment in QuickBooks Desktop

Receiving A Prepayment

Receiving a prepayment is the same as receiving any other type of payment. 

In the top menu click Customers -> Receive Payments.

Navigating to Receive Payments from the main menu in QuickBooks Desktop.

Select the customer making the prepayment in the RECEIVED FROM drop-down.

Any open invoices for that customer will appear you can select which ones they’re paying and click Save & Close.

In my example below I’m collecting a $500 prepayment and $10 for a previous invoice.

Receive a payment from a customer in QuickBooks Desktop.

Apply a Prepayment to an Invoice

Now we’re going to pretend that some time has passed and we’re ready to apply the prepayment to an invoice for a project.

Click Create Invoices on the Home Page. Select your customer from the CUSTOMER:JOB drop-down.

In my example, the first item on the invoice is a project with a price of $1,000.

Next, I add the customer deposit by using the ITEM Customer Deposit and giving it a price of -$500 on the invoice.

This applies the $500 prepayment to the invoice leaving a balance due of $500.

When you’re ready click Save & Close.

An invoice with a prepayment applied in QuickBooks Desktop

You now know how to create a customer liability account that you can use to collect prepayments. Then apply those prepayments to invoices.

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

Below are videos if you prefer to watch a walkthrough.

If you have any questions about customer prepayments or liability accounts in QuickBooks Desktop click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

A Guide to Using Practice Protect for Accountants

An introduction to Practice Protect, a cybersecurity platform for accountants.

How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Learn how to use Saasant to upload multiple checks to QuickBooks Online for printing.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.