Remove a Customer Account Balance in QuickBooks Desktop Easily 

Managing customer balances accurately is essential for keeping your books clean and your financial reports reliable. If you’re trying to remove a customer account balance in QuickBooks Desktop, you’re not alone—many businesses encounter situations where old balances, overpayments, or incorrect entries need to be cleared out. Whether you’re using QuickBooks Desktop Pro, Premier, or Enterprise, the process requires careful handling to ensure your accounting records remain accurate and compliant.

In this guide, we’ll walk you through how to remove a customer account balance in QuickBooks Desktop across all versions—Pro, Premier, and Enterprise—while explaining the reasons you might need to do so and the best practices to follow.

What is a customer account balance in QuickBooks? 

A Customer Account Balance in QuickBooks represents the total outstanding amount a specific customer owes for invoices, minus any payments or credits, effectively serving as an accounts receivable tracker. It is used to track sales ledger activity, manage credit control, and identify unpaid invoices via the “Customer Balance Detail” report. Synonyms include “Customer Balance List,” “Accounts Receivable,” or “Customer Open Balance.”

Why Do We Need to Remove a Customer Account Balance? 

Removing a customer account balance—whether cleaning up a “ghost” balance, closing a dormant account, or correcting overbilling—is necessary to ensure accurate financial reporting, avoid unnecessary fees, and maintain compliance. For businesses, it corrects aged receivables, while for banks, it prevents negative balances and legal issues arising from inactive accounts. 

Two Ways to Remove a Customer Account Balance in QuickBooks

Removing a customer account balance in QuickBooks can be done using different methods, depending on the balance’s nature and your accounting needs. Choosing the right approach ensures your records stay accurate and compliant while avoiding future discrepancies: 

Option 1: Create a general journal entry to write off the amount

Accounts receivable

1. Record the necessary journal entry.

• Open the company menu and choose Make General Journal Entries. 
• In the Journal Entry window, update the date and assign an entry number if needed. 

If a customer has overpaid:

• In the Account column, choose Accounts Receivable.
• Enter the amount in the Debit column, then move to the Name column and select the relevant customer. 
• On the next line, pick the corresponding offset account (typically an expense account) and enter the same amount in the Credit column. 

If a customer has underpaid:

• Select Accounts Receivable in the Account column.
• Enter the amount in the Credit column, then select the appropriate customer in the Name column.
• On the next line, choose the offset account and enter the amount in the Debit column.

• Click Save & Close to complete the entry.

2. Apply the General Journal Entry to the Existing Credit/Debit:

• Go to the Customers menu and select Receive Payments.
• Enter the customer’s name in the Received From field.
• Select the invoice, then click on Discounts & Credits.
• Under the Credits tab, choose the available credit and click Done.
• Click on Save & Close.

Accounts payable

1. Create an appropriate journal entry:

• From the Company menu, select Make General Journal Entries.
• In the Make General Journal Entries window, update the date and enter the entry number if required.

For a vendor with overpayment

• In the Account field, select Accounts Payable from the dropdown list.
• Enter the amount in the Credit column, then move to the Name column and choose the vendor name from the dropdown list.
• On the next line, select the offset account and enter the amount in the Debit column.

For a vendor with underpayment

• In the Account field, choose Accounts Payable from the dropdown list.
• Enter the amount in the Debit column, then move to the Name column and select the vendor from the dropdown list.
• On the following line, select the offset account and enter the amount in the Credit column.
• Click on Save & Close.

2. Apply the journal entry to the existing debit/credit:

• From the Vendors menu, click on Pay Bills.
• Choose the bill, then select Set Credits.
• In the Credits tab, select the available credit, then click Done.
• Click on Save & Close.

Option 2: Use discounts to write off small amounts

2. Set up an account and item for writing off small amounts:

• Create a Charge-Off Account.
  • From the Lists menu, select Chart of Accounts.
  • Click the Account button and choose New.
  • Select Income, then click Continue.
  • Enter Minor A/R and A/P Charge-Off in the Account Name field and click Save & Close.
• Create a charge-off item.
  • From the Lists menu, select Item Lists.
  • Click the Item button and choose New.
  • Select Other Charge as the Item Type and click Continue.
  • Enter Minor Charge-Off in the Item Name/Number field.
  • Select Non-Taxable Sales in the Tax Code field.
  • Choose Minor A/R and A/P Charge-Off in the Account field.
  • Click OK to save and create the item.

2. Choose the scenario that most closely matches the small amount you want to clear.

Customer underpayment

• From the Customers menu, select Receive Payments.
• Enter the customer’s name in the Receive From field.
• Choose the invoice you want to write off the amount for.
• Click on Discounts & Credits.
• Move to the Discount tab:
  • Enter the amount in the Amount of Discount field.
  • Select Minor A/R and A/P Charge-Off in the Discount Account field.
  • Click Done to close the Discount and Credits window.
  • Click Save & Close to exit the Receive Payments window.

Customer overpayment

• From the Customers menu, select Create Invoices.
• Choose the customer name in the Customer: Job field.
• In the Item field, select Minor Charge-Off and enter the overpayment amount.
• Click on Apply Credits.

• In the Available Credits section, select the credit (ensure the credit amount matches the invoice amount).

• Click Done to close the Apply Credits window.
• Finally, select Save & Close.

Vendor underpayment

• From the Vendors menu, select Pay Bills.
• Choose the bill that has the balance you need to write off.
• Click Set Discount.

• Go to the Discount tab:
  • Enter the amount in the Amount of Discount field.
  • Select Minor A/R and A/P Charge-Off in the Discount Account field.

• Click Done to close the Discount & Credits window.
• Click on Pay Selected Bills to close the Pay Bills window.
• Hit Done in the Payment Summary window.

Vendor overpayment

• Enter a bill that will offset the credit.
  • From the Vendors menu, select Enter Bills.
  • Choose the vendor in the Vendor field.
  • In the Items tab, select Minor Charge-Off in the Item field.
  • Click Save & Close.
• Apply the available credit to the bill you created.
  • From the Vendors menu, choose Pay Bills.
  • Select the bill entered to offset the credit.
  • Click Set Credits.
  • Go to the Credits tab and select the credit.
  • Click Done to close the Discount & Credits window.
  • Click Pay Selected Bills to close the Pay Bills window.
  • Click Done in the Payment Summary window.

Conclusion 

Removing a customer account balance is necessary to ensure accurate financial records, eliminate outstanding discrepancies, and maintain proper accounts receivable tracking. This detailed guide covers how to remove a customer account balance in QuickBooks and, if needed, identify and correct any related errors.

If you need further assistance, we recommend consulting QuickBooks ProAdvisors available at 866-500-0076. Consult your issues with certified experts now!

Frequently Asked Questions 

1. How do I remove a customer credit balance in QuickBooks?

To remove a customer credit balance in QuickBooks, you can apply it to an existing invoice, issue a refund check, or delete/void the credit memo if it was created in error. The best method depends on whether the credit represents an overpayment, a returned item, or a mistake. 

2. How do I delete a customer account in QuickBooks?

To delete a customer in QuickBooks Online, you make them inactive, which hides them from lists while retaining their transaction history for reports. Navigate to Sales > Customers, select the customer, click Edit, and choose Make inactive. For QuickBooks Desktop, use the Customer Center to delete customers with no transactions. 

3. When should I use a general journal entry to clear balances?

Use a general journal entry to clear balances when adjustments cannot be made through standard, automated sub-ledger transactions. Typical scenarios include month-end accruals, correcting misposted transactions, recording non-cash transactions, or clearing lingering, inactive, or reconciled balances in “clearing” accounts. 

4. What is the difference between overpayment and underpayment?

An overpayment occurs when a payer sends more than the agreed-upon amount (resulting in a negative balance, refund, or credit). In contrast, an underpayment occurs when the payment is less than the required amount. Overpayments often result from errors or duplicate billing, whereas payment mistakes often cause underpayments. 

5. Can I write off small balances without journal entries in QuickBooks?

Yes, you can write off small, uncollectible balances in QuickBooks without manual journal entries by using a Credit Memo or a Bank Deposit adjustment. This method is preferred as it automatically links the write-off to the specific customer invoice and updates accounts receivable.