Huge Savings
Get our price list!
Buy with Confidence
from a Premier Intuit Reseller
Free Shipping
Direct from Intuit
No Sales Tax
(in some states)
Try it free for 30 days

Huge Savings!

Add-ons


CRM: Online marketing: Field service mgmt.: POS email marketing: Inventory: E-commerce: Reporting: Time tracking: Billing/invoicing: Travel/expense mgmt: Donor management:

Business Tools


Social media mgmt: Cloud applications: Email marketing: Webstores: Online chat:

How to Book Customer Deposit Refunds in QuickBooks

Hope you can help me.  A client gave me money on account which I deposited.  After invoicing him he was due a refund. I wrote a check out to him and in the account field I assigned it A/R.  When I go into my chart of accounts in the A/R the amount I refunded is added .  Why is this?  If I gave a refund shouldn't the A/R balance be less?   I used the help tab in my QuickBooks and that is what it told me to do.
It depends on how you booked the original money on account you deposited.  You need to book the refund to the same account you used for the original deposit.  I’m guessing it was probably a revenue account instead of A/R since the deposit would’ve caused a negative A/R balance.

When you write a check to a customer and use A/R as the account, QuickBooks thinks you just made a loan that should be repaid and this increases A/R.  If you had posted the original deposit to A/R, there would’ve been a negative balance equal to the amount of the refund so the refund would’ve brought the account back up to $0.

Assume the deposit was $1000 but you only did $800 in work.  Your transactions probably looked like this:

$1000 Deposit:
Increased cash $1000
Increased revenue $1000

$800 Invoice:
Increased revenue $800
Increased A/R $800

$200 Refund Check:
Increased A/R $200
Decreased cash $200

In the above scenario, both revenue and A/R are overstated by $1000.  Not only that, but this isn’t really the proper way to handle customer deposits because you’re booking $1000 in revenue before you’ve actually earned it and as you learned you sometimes have to refund some (or all) of the customer deposit.  This is how they should be booked:

  1. Go to Lists > Chart of Accounts, click on the Account button, select New, and add a current liability account called "Customer Deposits".
  2. Go to Lists > Item List, click on the Item button, select New, and add an other charge item called "Customer Deposits" mapped to the Customer Deposit account you setup above.
  3. Create an invoice or sales receipt using the Customer Deposit item you created above, and receive payment as usual.
  4. On the final invoice, invoice for the full amount of the contract and add a line using the Customer Deposit item using a negative amount for the deposit already received. The total on the invoice should show the remaining amount due.
  5. Periodically go to Banking > Reconcile and reconcile the Customer Deposit account so that the customer deposits that have been applied to invoices are marked as cleared.
  6. Then you can filter a report to only show uncleared transactions to get a report of only customer deposits that haven't been applied yet.

In this case, if you owe your customer a refund you’d use the customer deposit account which should still have a balance equal to the amount that should be refunded because it hasn’t been invoiced yet.

The transactions would look like this:

$1000 Deposit:
Increase cash $1000
Increase customer deposits $1000

$800 Invoice:
Increase revenue $800
Decrease customer deposits $800 (leaving a balance of $200)

$200 Refund Check:
Decrease customer deposits $200 (bringing the balance to $0)
Decrease cash $200


Visit our webstore for huge savings on QuickBooks!

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Web Store | Price List | Free Trials | Newsletter

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>