Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Level 7
December 11, 2018
Solved

Customer prepayments for inventory items

  • December 11, 2018
  • 5 replies
  • 10 views

We have some customers prepay for inventory item assemblies before the assemblies are built. When our accountant invoices the items on the sales order for the prepayment, the items are immediately subtracted from inventory and drive it to a negative inventory. This messes up our inventory and QB thinks we already shipped the items so we don't know that we still need to ship the parts. How would be the best way to handle this, create a prepayment or deposit item and assign it to a special account? then put this item on the sales order, then once we build the items and invoice against the sales order use the prepayment as a credit? Will this payment be accociated correctly with the inventory item and the COGS account be correctly applied to this inventory item?

Best answer by lindak1119
Just go to Customers -> Receive payments. Enter amount and in the lower left corner click "remain as available credit". This will record payment, and it will stay as available credit. As soon as assembly will be ready and you will create an invoice - click apply credits in the upper right corner of invoice, and apply it to the invoice.

5 replies

lindak1119AuthorAnswer
Level 7
December 11, 2018
Just go to Customers -> Receive payments. Enter amount and in the lower left corner click "remain as available credit". This will record payment, and it will stay as available credit. As soon as assembly will be ready and you will create an invoice - click apply credits in the upper right corner of invoice, and apply it to the invoice.
Level 7
December 11, 2018
exactly what i needed and thank you so much
qbteachmt
Level 11
December 11, 2018

"When our accountant invoices the items on the sales order for the prepayment, the items are immediately subtracted from inventory and drive it to a negative inventory. "

Yes, that is done using an Other Charge type item, not the actual inventory item.

"Just go to Customers -> Receive payments. Enter amount and in the lower left corner click "remain as available credit". "

That creates negative AR and is not a good process to use holding this for any length of time.

You want this method, for the prepayment:

https://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k12/contentpackage/core/re...

And this for the application of the prepayment to the final/actual gross charges:

http://support.quickbooks.intuit.com/support/Articles/HOW12869

December 12, 2018

Instead of using Other Charge, why not set up an inventory item that only hits Customer Deposits Liability?

December 11, 2018

a sales order is non-posting and does not change inventory.  receive the payment from the customer and do not apply it to an invoice.  it resides as a credit on the customer account.  when the build is complete and you're ready to ship, invoice the total amount and apply the credit to the invoice.  the customer will owe you the balance.

December 12, 2018

I met with a customer yesterday also dealing with customer deposits.  Her customers want "receipts", so posting the paying and leaving a credit will not suffice.  My best resolution is to create a Customer Deposit Account in current liabilities, then set up a Customer Deposit item that hits the account.  You invoice customer for deposit, then apply deposit received on a later invoice and it backs it out of the liability account.  The liability account also makes a very nice list of who you have deposits from if keep the account reconciled to zero.  Do not use sales receipts for this - they don't show up on customer statements.  The tricky part is remembering to apply the deposit, because QB isn't going to do it for you.  Also, using the Memo at the bottom for "Deposit Request" on invoice and "Deposit Received" on payments make nice neat notes on the statements.

December 12, 2018

I met with a customer yesterday also dealing with customer deposits.  Her customers want receipts, so posting the paying and leaving a credit will not suffice.  My best resolution is to create a Customer Deposit Account in current liabilities, then set up a Customer Deposit item that hits the account.  You invoice customer for deposit, then apply deposit received on a later invoice and it backs it out of the liability account.  The liability account also makes a very nice list of who you have deposits from if keep the account reconciled to zero.  Do not use sales receipts for this - they don't show up on customer statements.  The tricky part is remembering to apply the deposit, because QB isn't going to do it for you.  Also, using the Memo at the bottom for Deposit Request on invoice and Deposit Received on payments make nice neat notes on the statements.