Workflow

Recording customer deposits in QuickBooks Desktop

Record a customer advance, apply it to the eventual invoice and check that the deposit and customer balances reconcile.

Updated

Agree the treatment before setup

An advance for work not yet supplied needs a defined process. Intuit documents a workflow using a liability account and a linked deposit item. Agree the account, item and tax treatment with your accountant; the correct treatment depends on the transaction and local rules.

Record and apply the advance

  1. Set up the deposit item against the agreed liability account.
  2. Record the money received on a Sales Receipt using that item and the correct customer or job.
  3. When the sale is invoiced, apply the deposit through the invoice line or credit method described in Intuit’s guide. Use one method for the same amount, not both.
  4. Check the remaining deposit balance and the amount still due on the invoice.

Work through the numbers

For a simple example before tax, a customer pays a 30,000 advance against a later invoice for 100,000. Applying that advance should leave 70,000 due and clear the 30,000 held for that order. The application of the advance is not a second receipt of cash.

If part of the advance remains unused, track it against that customer and resolve it under the agreed process.

Reconcile the detail as well as the total

Review the deposit account, customer statement and open invoices. A net customer balance of zero can hide an invoice and credit that have not been linked.

Cancellations and refunds need their own entries. Have the accountant review the treatment before staff copy the routine to other transactions.

Intuit documentation

Need help with your setup?

Titan Cloud Servers handles QuickBooks Desktop Enterprise setup, hosting, staff training and ongoing support.

Was this guide useful?

Follow Titan Cloud Servers on Facebook for more QuickBooks guides and practical advice.

Worked with our team? You can share your experience on our Google Business Profile.

Business software we work with every day

We support QuickBooks Desktop Pro, Premier, Enterprise and Enterprise Accountant, plus Sage, Tally, Peachtree, Microsoft Office, SQL Server, Outlook and other Windows business software.

QuickBooks Desktop Sage Tally Peachtree Microsoft Microsoft Office SQL Server Microsoft Outlook
WhatsAppTalk to our team