cancel
Showing results for 
Search instead for 
Did you mean: 
Mark_R
QuickBooks Team

What is the best way to record a customer prepayment and deposit?

Welcome back, @golden2010.

 

Let me guide you through the process of handling prepayment in QuickBooks Online (QBO).

 

When you receive a prepayment higher than the invoice amount, you'll need to create a sales receipt. This will increase the amount in your liability account to show that the money isn't truly yours yet, and to avoid treating it as income until later. Here's how:

 

  1. Click the + New button, then select Sales Receipt.
  2. Select the customer from the drop-down.
  3. Choose the bank account from the Deposit to drop-down.
  4. Select the Retainer item you've set up in the Product/Service column.
  5. In the Amount column, enter the (300) amount.
  6. Click Save and close.

 

Once done, you need to turn the retainer into credits on the invoice. This way, it'll decrease the amount in your liability account and applies the credit to your customer's invoice, turning it into income. Please be guided with the steps below:

 

  1. Click the + New button, then select Invoice.
  2. Select the customer from the drop-down.
  3. In the Product/Service field, select the services or goods you provided and enter the (100) amount.
  4. On the last line of the Product/Service field, choose the Retainer item. Then, enter the (-100) amount as a negative to subtract it from the invoice.
  5. Click Save and close.

 

I'm adding this article for the detailed steps: Record a retainer or deposit.

 

You might want to review all your sales transactions made in QuickBooks Online. You can go to the Sales menu and select All Sales.

 

Please know that I'm just a reply away if you need any further assistance recording prepayments from your customers. Wishing you continued success, @golden2010.

golden2010
Level 1

What is the best way to record a customer prepayment and deposit?

thanks for your prompt reply. I'm not sure if I get the point. when I provide the service to the client, I invoice him. First, In the Product/Service field, select the services or goods you provided and enter the (100) amount, then I add a new line below, choose the retainer item I set up in the "Product and services", and then enter the -100 amount into the "amount". Now the balance below is 0, which means the client does not need to pay extra money. And my other current liability will decrease by 100? am I right?

 

JessT
Moderator

What is the best way to record a customer prepayment and deposit?

Yes, you're absolutely right, golden2010.

 

Every time you create an invoice or sales receipt and add the retainer item with a negative amount, the balance of the liability account decreases. You can open it in the Chart of Accounts to see the result.

 

I got a sample below with a $10,000 prepayment. I deducted $1,000 on the first invoice of the customer. The remaining balance of the prepayment is now $9,000.

 

If there's anything that I can help you with your transactions, feel free to go back to this thread. Take care!

Sstirn-VPC
Level 1

What is the best way to record a customer prepayment and deposit?

Mark,

 

How do I do the entry as you describe if we have QuickBooks Premier Edition 2018?

trilliumvt
Level 1

What is the best way to record a customer prepayment and deposit?

The article you linked is not totally correct. In step 3: This optional step (if you hold retainers in a separate bank account) suggests to open a liability bank account by selecting 'other current liabilities'. This is not correct as this is not a bank account. For the actual bank account where the retainers land, that bank account would have to be an asset (bank), otherwise, the debit and credit can't balance out (money goes into the bank account as a debit to the bank and then you credit the liability account (created in step 2) to balance the transaction.  This reflects what's really happening as well. While theoretically, on paper, you could make the debits and credits work by making a bank account a liability account and then reflecting a debit (instead of a credit) when money goes into that bank account, it's not as straight forward, plus it doesn't work with QB software. For example, in QB Online, you can't deposit money into a liability account when creating a sales receipt (like it suggests in article) because it's not an asset account. It would be great if QB could revisit the article and fix it so as to avoid future customer confusion. 

Kurt_M
QuickBooks Team

What is the best way to record a customer prepayment and deposit?

Thanks for joining the thread, @trilliumvt.

 

I appreciate you for letting us know about this, and I want to ensure we can help our valued customers through these helpful articles. Also, please know that we care about your voices towards our product, and for us to improve your experience using our written guidelines or articles, you can submit feedback. This way, we'll be able to rewrite and correct our materials to continue assisting those QuickBooks users in resolving their queries.

 

 

I'll be happy to input the steps below to get you going. To begin, here's how:

 

  1. Access the article that you'd like us to revisit or edit.
  2. Scroll down, and then click the No button below the Was this helpful?
  3. If the article doesn't work, you can choose The instructions don't work as your reason for sending feedback.
  4. You can also select Something else in the option so you can give us a detailed reason why we need to edit the guide.
  5. Once done, click the Submit button.

 

For visual reference, see the screenshot that I've attached below: 

 

 

In addition, I've got you this article to help you manage your bank transactions inside QBO: Categorize and match online bank transactions in QuickBooks Online.

 

And if you have time to spare, you can also check this page to learn more about reconciling an account: Reconcile an account in QuickBooks Online.

 

It's been a pleasure to have you here today, @trilliumvt. In case there's anything else that you'd like me to help you with or have any additional QuickBooks-related concerns. Feel free to leave a comment below. I'll be happy to help you out again. Take care, and have a nice day!

Kurt_M
QuickBooks Team

What is the best way to record a customer prepayment and deposit?

Thanks for joining the thread, @trilliumvt.

 

I appreciate you for letting us know about this, and I want to ensure we can help our valued customers through these helpful articles. Also, please know that we care about your voices towards our product, and for us to improve your experience using our written guidelines or articles, you can submit feedback. This way, we'll be able to rewrite and correct our materials to continue assisting those QuickBooks users in resolving their queries.

 

 

I'll be happy to input the steps below to get you going. To begin, here's how:

 

  1. Access the article that you'd like us to revisit or edit.
  2. Scroll down, and then click the No button below the Was this helpful?
  3. If the article doesn't work, you can choose The instructions don't work as your reason for sending feedback.
  4. You can also select Something else in the option so you can give us a detailed reason why we need to edit the guide.
  5. Once done, click the Submit button.

 

For visual reference, see the screenshot that I've attached below: 

 

 

In addition, I've got you this article to help you manage your bank transactions inside QBO: Categorize and match online bank transactions in QuickBooks Online.

 

And if you have time to spare, you can also check this page to learn more about reconciling an account: Reconcile an account in QuickBooks Online.

 

It's been a pleasure to have you here today, @trilliumvt. In case there's anything else that you'd like me to help you with or have any additional QuickBooks-related concerns. Feel free to leave a comment below. I'll be happy to help you out again. Take care, and have a nice day!

GodzChlyd
Level 1

What is the best way to record a customer prepayment and deposit?

Hey Phillip i don't see the plus icon I am using Qb Online.

KayePe
QuickBooks Team

What is the best way to record a customer prepayment and deposit?

Thanks for joining us here in the thread, @GodzChlyd. Let me give you insights on where you can see the Plus New icon in QuickBooks Online (QBO).

 

QBO has many features that you may use for your business. The features will be visible when you click the Gear icon or the Plus New button. Here's a virtual reference on where to see the Plus New button in QBO:

 

Capture 6.PNG

 

If you still haven't been able to trace the Plus New button, I suggest performing browser troubleshooting steps to help you fix this issue. See the following keyboard shortcuts for suitable browsers to open a private window:

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Option + P

 

Check out this article for a detailed process on how to clear your cache: Clear cache and cookies to fix issues when using QuickBooks Online.

 

On the other hand, you may also visit this article as a guide on adding transactions to account register: Manually add transactions to account registers in QuickBooks Online.

 

You can reply to this thread for further questions about handling your business in QBO. I'm here to assist. Keep safe!

Need to get in touch?

Contact us