Creating and Tracking Customer Deposits

Customer Deposits:

Some companies receive deposits from their customers before they will process an order. In many cases, this deposit can be received directly into QuickBooks, then after creating an invoice in Acctivate and syncing it, the payment can be applied in QuickBooks to the invoice. However, some Acctivate users need to be able to receive a deposit in Acctivate for a particular order and see what the balance of the order is after the payment. The following configuration will allow you to send deposit payments to QuickBooks from Acctivate while also being able to see the balance of a particular order or job.

Steps to Track Customer Deposits:
  1. In QuickBooks, create a new GL account with the account type of Other Current Liability since these will be deposits that have not been applied to a particular invoice yet.
Other Current Liability

Customer Deposit GL Account

  1. After a sync, you can create a new Product Class in Acctivate. This product class will use the Customer Deposit GL account we just created.

  1. Next create the product for this Deposit. The item type should be Other Charge and the Product Class should be the one just created (In this case “Customer Deposits”). You’ll also want to ensure that the cost method is set to None. The tax code will be your non taxable tax code.

  1. Create the sales order for the items. At the end of the sales order add your deposit item for the amount of the customer’s deposit. Add the deposit again with a negative deposit amount. Set the scheduled quantity to be “0” for all the items except the deposit item. Our first invoice should only include the positive amount deposit item.

  1. Next, you will click Create Invoice. This will open the invoice window where you will record the deposit payment info. Acctivate will create an invoice for the deposit amount, in this case $25, and apply the payment to it. Both the invoice and payment will sync over into QuickBooks.

Invoice order

  1. In QuickBooks, the customer will have a zero dollar balance, however there will be a $25 entry in the Customer Deposits account. This amount reflects that you have $25 of deposits money which has not been used.

Customer Deposit Balance

  1. After creating the first invoice in Acctivate, you will schedule the remainder of the order, which includes the negative deposit amount. This will reduce the balance of the order by the deposit amount. When you create your invoice, your customer will see the deposit being deducted which leaves a balance due of $75.

  1. After creating the invoice for the balance due and syncing it to QuickBooks, the customer balance will reflect the amount due and the Customer Deposits account will reflect zero dollars, indicating that we’ve use all of the customer deposit on hand.

 

Accounting Impact:

First Invoice

Accounts Receivable $25
Other Current Liability – Customer Deposits $25
Customer Sales Invoice with initial Deposit

 

Checking Account $25
Accounts Receivable $25
Deposit Payment synced with initial Invoice

Second Invoice

Accounts Receivable $75
Sales – Widgets $50
Sales – Gadgets $50
Other Current Liability – Customer Deposits -$25
Customer Sales Invoice for remainder of invoice

 

Posted in Customer, Sales - Last modified on April 28, 2016Lauren Stine
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.