Business
Martin Lucas
When a customer fails to pay an invoice and you determine that the balance is unlikely to be collected, you may need to write off bad debt in QuickBooks. Properly recording bad debt helps keep your Accounts Receivable balance accurate and ensures that your financial reports do not continue showing uncollectible amounts as expected income.
However, an invoice should not be written off simply because it is overdue. Before recording bad debt, review the customer's payment history, invoice age, collection efforts, disputes, and the likelihood of receiving payment.
QuickBooks Online and QuickBooks Desktop use different processes for recording bad debt, so it is important to follow the workflow for the version you use.
Bad debt is money owed by a customer that a business has determined it cannot reasonably collect.
For example, suppose your company has a $3,000 invoice that has remained unpaid despite repeated collection attempts. If you determine that the customer will not pay, the $3,000 may qualify for a bad debt write-off under your accounting and tax circumstances.
A proper write-off does not simply delete the invoice. Instead, it removes the applicable amount from Accounts Receivable and records the amount using the appropriate bad debt expense account.
Businesses that frequently deal with overdue customer balances may also benefit from professional Accounts Receivable Services to help monitor invoices, follow up on outstanding payments, and maintain accurate receivable records.
An overdue invoice is not automatically bad debt.
Before writing off an invoice, consider:
For example, a 60-day overdue invoice may still be collectible. Writing it off too early could unnecessarily reduce your receivables.
Review your Accounts Receivable Aging report before deciding that an invoice is uncollectible.
QuickBooks Online uses a credit memo to record the bad debt write-off and apply the amount against the outstanding invoice.
First, identify invoices that may be uncollectible.
In QuickBooks Online:
This review helps you distinguish genuinely uncollectible accounts from invoices that are simply overdue.
Create a dedicated expense account for bad debt.
Generally:
Using a dedicated account makes it easier to identify bad debt on your financial statements.
Next, create a non-inventory product or service item associated with your bad debt expense account.
You can generally:
This item can then be used when creating the credit memo.
Create a credit memo for the amount that has been determined to be uncollectible.
If only part of an invoice is uncollectible, enter only the amount that you intend to write off.
The credit memo needs to be applied to the applicable outstanding invoice.
The applicable receivable balance should then be cleared or reduced.
After completing the write-off, review:
This helps verify that the transaction was recorded correctly.
The process is different in QuickBooks Desktop.
QuickBooks Desktop generally uses a bad debt expense account and a zero-dollar payment with a discount to close the unpaid invoice.
Go to:
Lists → Chart of Accounts → Account → New
Then:
To write off the invoice:
Review the customer's balance and Accounts Receivable reports afterward.
Yes. You do not necessarily have to write off the entire invoice.
Suppose a customer owes $5,000, but you determine that only $1,500 is uncollectible. You can write off the $1,500 while continuing to track the remaining $3,500.
Partial write-offs can be useful when you have recovered part of an invoice but determined that the remaining balance cannot reasonably be collected.
A properly recorded write-off reduces the applicable Accounts Receivable balance.
For example:
Original invoice: $4,000
Amount written off: $4,000
Remaining receivable: $0
The transaction should be recorded rather than simply deleting the invoice.
Maintaining accurate Outstanding Accounts Receivable records is important because your receivables represent amounts you expect customers to pay.
No. A bad debt write-off and deleting an invoice are two different actions.
Deleting an invoice removes the transaction from the accounting records, while a bad debt write-off records that the receivable is no longer expected to be collected.
If an invoice was legitimately issued and later became uncollectible, deleting it simply to remove the balance can create inaccurate accounting records.
Occasionally, a customer may pay after an invoice has already been written off.
Because the original receivable has already been cleared, the payment may need to be recorded as a recovery rather than simply applying it to an open invoice.
The appropriate treatment can depend on your accounting method and tax circumstances. If the original bad debt was claimed as a tax deduction, discuss the recovery with a qualified tax professional.
Yes. When bad debt is properly recorded as an expense, it can affect the Profit and Loss statement.
For example, if you write off a $2,000 uncollectible balance, the appropriate bad debt expense account may increase by $2,000 while the related Accounts Receivable balance decreases.
The accounting entry and tax treatment are separate matters. Recording bad debt in QuickBooks does not automatically mean that the amount qualifies as a tax deduction.
Use Accounts Receivable Aging reports to monitor invoices before they become seriously overdue.
Consistent payment reminders can help identify customer disputes and reduce the number of invoices that eventually become uncollectible.
Maintain records of invoices, payment reminders, emails, collection attempts, disputes, and other relevant communications.
A separate account makes bad debt easier to monitor and review on financial reports.
If an invoice is genuinely uncollectible, use the appropriate write-off process rather than deleting the original transaction.
Regularly review customer balances so that your financial statements provide a more accurate picture of amounts you expect to collect.
Bad debt prevention starts before an invoice becomes uncollectible.
Businesses can improve receivables management by:
Professional bookkeeping and Accounts Receivable support can also help businesses maintain organized records and monitor outstanding customer balances. Accounts Confidant provides Accounts Receivable and bookkeeping-related services designed to help businesses manage financial records and receivables.
Knowing how to write off bad debt in QuickBooks can help keep your Accounts Receivable records and financial reports accurate. The process differs between QuickBooks Online and QuickBooks Desktop, so make sure you follow the appropriate workflow for your version.
Before writing off an invoice, confirm that the balance is genuinely uncollectible rather than simply overdue. Keep documentation of your collection efforts and review your financial reports after completing the transaction.
For tax-related questions, particularly whether a bad debt qualifies for a deduction or how a later recovery should be treated, consult a qualified tax professional.
The process depends on your QuickBooks version. QuickBooks Online generally uses a bad debt expense account, bad debt item, credit memo, and payment application. QuickBooks Desktop generally uses a bad debt expense account and a zero-dollar payment with a discount.
Review the Accounts Receivable Aging Detail report, create a bad debt expense account and item, create a credit memo for the uncollectible amount, and apply the credit memo to the unpaid invoice.
Create a bad debt expense account, open Receive Payments, select the customer, enter a zero-dollar payment, use Discounts and Credits, enter the amount being written off, select the bad debt account, and save the transaction.
Yes, but an overdue invoice is not automatically bad debt. You should determine that the amount is genuinely uncollectible before recording the write-off.
Yes. If only part of the customer balance is uncollectible, you can write off the applicable amount while continuing to track the remaining balance.
Businesses commonly use a dedicated expense account for bad debts. The exact account setup can depend on your accounting practices and QuickBooks version.
No. A write-off records the uncollectible amount and clears the applicable receivable. It is not the same as deleting the invoice.
Yes. A properly recorded bad debt write-off reduces the applicable customer receivable balance.
The later payment may need to be recorded as a recovery because the original receivable has already been cleared. If the original amount was claimed as a tax deduction, consult a tax professional regarding the recovery.
It may be under certain circumstances, depending on applicable tax rules and the business's accounting method. A bookkeeping entry in QuickBooks does not by itself determine tax deductibility.
Do not simply delete old invoices because they remain unpaid. Review the Accounts Receivable Aging report and determine whether each balance is still collectible. Qualifying uncollectible balances can then be recorded using the appropriate bad debt write-off procedure.
Use clear payment terms, invoice customers promptly, monitor aging reports, follow up on overdue invoices, resolve disputes quickly, and regularly review customer payment history.