How to Write Off Customer Balances in QuickBooks?

Businesses must maintain accurate financial records to understand their true financial position. When customers fail to pay their dues, and the amount becomes uncollectible, companies need to remove it from accounts receivable. This process is called writing off customer balances in QuickBooks, where unpaid invoices are recorded as a bad debt write-off instead of being shown as active receivables.

While performing this task, users often face common issues such as “You must select a customer for this transaction,” “Accounts Receivable requires a customer name,” or errors related to unapplied payments and mismatched balances. These problems can disrupt accounting workflows and lead to inaccurate reports if not resolved properly.

In this guide, we’ll discuss the causes, warning signs, prerequisites, solutions to write off customer balances in QuickBooks, preventive tips, and more.

Why do Businesses Write Off Customer Balances in QuickBooks

Businesses write off customer balances in QuickBooks when invoices become uncollectible or impractical to recover. Common causes of bad debt write-off may include:

• Uncollectible bad debt (bankruptcy, disappeared customers, or refusal to pay)
• Small or residual balances left after partial payments or rounding differences
• Overpayments or underpayments requiring adjustment to balance accounts
• Customer disputes or invoicing errors resolved by writing off the amount
• Long-outstanding (aged) receivables with low chances of recovery
• Lack of communication or inactive customer accounts
• Weak credit policies or inadequate customer screening

What are the Signs That Show Write Off Customer Balances in QuickBooks?

You can identify the need to write off customer balances in QuickBooks by observing these signs. Here are the key signs to watch out for:

• Aged accounts receivable with invoices overdue beyond 90-120 days
• Uncollectible balances due to bankruptcy, business closure, or no response
• Small residual amounts from overpayments or underpayments
• Negative receivables caused by misapplied payments or unused credits
• Repeated follow-ups with no payment progress
• Unresolved disputes or inactive customer accounts

What are the Prerequisites to Consider Before You Fix the Write-Off Customer Balances in QuickBooks?

Before you write off customer balances in QuickBooks, ensure you complete the necessary checks and set up to avoid errors and maintain accurate records:

• Review the Accounts Receivable Aging Detail report to identify uncollectible invoices
• Verify all outstanding balances and confirm they cannot be recovered
• Create a Bad Debt Expense account to track write-offs
• Set up a Bad Debt item (non-inventory/service) linked to the expense account
• Check for unapplied payments, credits, or misapplied transactions
• Reconcile bank accounts to ensure all payments are properly recorded
• Ensure the correct customer name is selected in transactions
• Run Rebuild/Verify Data utility (for QuickBooks Desktop) to avoid data issues
• Confirm the appropriate accounting method (accrual vs. cash) for tax treatment
• Consult an accountant for compliance and reporting requirements

Solutions to Fix the Write-off Customer Balances in QuickBooks Online?

You can write off customer balances in QuickBooks Online using different methods based on the situation, such as bad debts, small balances, or payment differences. Below are the most effective and structured solutions:

Solution 1: Write Off Using Credit Memo (Bad Debt Method)

This is the most commonly used method to handle uncollectible invoices and record them as bad debt. Here are the steps to write off in your Profit & Loss as a bad debt expense.

• In the first step, go to Settings > Chart of Accounts and create a Bad Debt Expense account.
• In the next step, navigate to Settings > Products & Services and create a Non-inventory item (e.g., “Bad Debt”) linked to the bad debt account.
• After that, click on + New > Credit Memo.
• Select the customer name, then choose the Bad Debt item you created.
• Enter the amount you want to write off and save the credit memo.
• Once you are done with it, you have to go to + New > Receive Payment.
• Select the same customer, and then apply the credit memo to the open invoice.
• Ensure the balance becomes zero, and save and close the transaction.

Solution 2: Write Off Using Journal Entry

This method is suitable for making direct accounting adjustments to accounts receivable.

• In the first step, go to + New > Journal Entry.
• Enter the date and required details.
• In the next step, add the following entries:
• Debit: Bad Debt Expense
• Credit: Accounts Receivable
• Make sure to select the customer name in the Accounts Receivable line.
• After that, save the journal entry.
• Once you are done with it, you have to go to + New > Receive Payment.
• Select the customer, and then apply the journal entry to the invoice.
• Save and close the transaction.

This method helps clear balances while keeping your books accurate.

Solution 3: Write Off Small Balances Using Discount Option

This method works best for minor differences caused by underpayments, overpayments, or rounding issues.

• In the first step, go to + New > Receive Payment.
• Select the customer and the related invoice.
• In the next step, click on Discounts and Credits.
• Enter the write-off amount as a discount.
• Choose the appropriate charge-off or expense account.
• After that, click Done, and then save and close the transaction.

This approach is ideal when the remaining balance is too small to justify further collection efforts.

Solution 4: Adjust Directly on Invoice (Quick Fix Method)

This is a quick method for handling very small discrepancies.

• In the first step, open the invoice you want to adjust.
• In the next step, add a new line item using a bad debt/write-off item.
• Enter a negative or positive amount depending on whether it is an underpayment or overpayment.
• Then, review the updated balance and save the invoice.

Solutions to fix the write-off customer balances in QuickBooks Desktop

You can write off customer balances in QuickBooks Desktop using different methods depending on whether you are dealing with bad debts, overpayments, or small remaining balances. Below are the most structured and effective solutions to write off a balance in QuickBooks.

Option 1: Create a General Journal Entry to Write Off the Amount

This method is ideal for adjusting accounts receivable or payable balances through proper accounting entries.

For Accounts Receivable (Customers)

Create a General Journal Entry:

• In the first step, go to the Company menu and select Make General Journal Entries.
• In the next step, update the date and enter the journal entry number if required.

For Customer Overpayment:

• Select Accounts Receivable in the Account field.
• Enter the amount under the Debit column, and choose the customer name.
• After that, on the next line, select an expense (offset) account and enter the amount under the Credit column.

For Customer Underpayment:

• Select Accounts Receivable in the Account field.
• Enter the amount under the Credit column, and choose the customer name.
• Then, on the next line, select an expense (offset) account and enter the amount under the Debit column.
• Once you are done with it, you have to click Save & Close.

Apply the Journal Entry:

• After that, go to the Customers menu and select Receive Payments.
• Select the customer in the Received From field.
• Choose the invoice, then click Discounts and Credits.
• Under the Credits tab, select the available credit and click Done.
• Then, click Save & Close to complete the process.

For Accounts Payable (Suppliers)

Create a General Journal Entry:

• In the first step, go to the Company menu and select Make General Journal Entries.
• In the next step, update the required details.

For Supplier Overpayment:

• Select Accounts Payable/Receivable (as applicable) in the Account field.
• Enter the amount under the Credit column and select the supplier name.
• After that, enter the offset account with the amount under the Debit column.

For Supplier Underpayment:

• Select the Account and enter the amount under the Debit column.
• Choose the supplier name, and then add the offset account with the amount under the Credit column.
• Once you are done with it, you have to click Save & Close.

Apply the Entry:

• After that, go to the Suppliers menu and select Pay Bills.
• Select the bill, then click Set Credits.
• Under the Credits tab, choose the available credit and click Done.
• Then, click Save & Close.

Option 2: Use Discounts to Write Off Small Amounts

This method is best for clearing minor balances, such as rounding differences or small unpaid amounts.

Step 1: Create a Charge-Off Account

• In the first step, go to the Lists menu and select Chart of Accounts.
• Click Account > New, and select Income, then click Continue.
• Enter the name “Minor A/R and A/P Charge-Off”.
• Then, click Save & Close.

Step 2: Create a Charge-Off Item

• In the next step, go to the Lists menu and select Item List.
• Click Item > New, and choose Other Charge as the type.
• Enter the name “Minor Charge-Off”.
• Select Non-Taxable as the tax code.
• Link it to the charge-off account created earlier.
• After that, click OK.

Customer Underpayment

This helps clear small unpaid balances from invoices.

• In the first step, go to the Customers menu and select Receive Payments.
• Select the customer, and choose the invoice.
• Click Discounts and Credits, then go to the Discount tab.
• Enter the discount amount and select the charge-off account.
• Then, click Done and Save & Close.

Customer Overpayment

This method adjusts excess payments made by customers.

• In the first step, go to the Customers menu and select Create Invoices.
• Select the customer, and in the next step, add the Minor Charge-Off item.
• Enter the overpayment amount.
• Click Apply Credits, and select the available credit.
• After that, click Done, and then Save & Close.

Supplier Underpayment

This clears small unpaid balances on bills.

• In the first step, go to the Suppliers menu and select Pay Bills.
• Select the bill, then click Set Discount.
• In the next step, enter the discount amount and choose the charge-off account.
• Click Done, and then select Pay Selected Bills.
• Once you are done with it, you have to click Done.

Supplier Overpayment

This method adjusts excess payments made to suppliers.

• In the first step, go to the Suppliers menu and select Enter Bills.
• Select the supplier, and in the next step, add the Minor Charge-Off item under the Items tab.
• Click Save & Close.

Apply the Credit:

• After that, go to Suppliers > Pay Bills.
• Select the bill created, and click Set Credits.
• Choose the available credit under the Credits tab.
• Then, click Done, followed by Pay Selected Bills.
• Once you are done with it, you have to click Done to complete the process.

You may also read this: How to Enter, Edit, or Delete Expenses in QuickBooks

What are the best practices to Write Off Customer Balances in QuickBooks?

Writing off customer balances helps you maintain accurate accounts receivable and reflect the true financial position of your business. To ensure proper accounting and compliance, follow these best practices.

• Create a Bad Debt Expense account in the Chart of Accounts
• Set up a “Bad Debt” item and link it to the expense account
• Review the Accounts Receivable Aging Report regularly
• Use Credit Memos to write off specific invoices
• Use the Write Off Invoices tool (QuickBooks Online Accountant)
• Verify invoices are truly uncollectible before writing off
• Avoid frequent small write-offs without investigation
• Maintain proper documentation and records
• Consult your accountant or tax advisor before finalizing write-offs

Conclusion

Writing off customer balances in QuickBooks ensures accurate financial records and clear accounts receivable. By following these best practices to Write Off Customer Balances in QuickBooks, you can manage bad debts efficiently, reduce errors, and maintain compliance while improving overall accounting accuracy and financial transparency.

Frequently Asked Questions