cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit
29 helpful votes

Write off bad debt in QuickBooks Online

Learn how to write off bad debt in QuickBooks Online.

Bad debt means a customer owes you money but you can't collect it. They have a debt with you, but you know you aren't going to get paid. If your business uses accrual method accounting, you can sometimes write off bad debt as a deduction.

When invoices you send in QuickBooks become uncollectible, you need to record them as a bad debt and write them off. This ensures your accounts receivable and net income stay up-to-date.

Select the method that’s most appropriate for your company.

Accrual basis

You can use this method if the amount you are writing off will significantly affect your gross sales. Note: Talk to your accountant before following the steps below to ensure this is the best method for your company.
  1. Create a bad debt expense account.
    1. Select the Settings ⚙ icon. Under Your Company, select Chart of Accounts.
    2. At the upper right, select New.
    3. From the Account Type ▼ drop-down, select Expenses.
    4. From the Detail Type ▼ drop-down, select Bad debts.
    5. In the Name field, enter “Bad debts.”
    6. Select Save and Close.
  2. Create a bad debt item.
    1. Select the Settings ⚙ icon. Under Lists, select Products and Services.
    2. At the upper right, select New, and then Non-inventory.
    3. In the Name field, enter “Bad debts.”
    4. From the Income account ▼ drop-down, select Bad debts.
    5. Select Save and Close.
  3. Create an adjustment note for the bad debt.
    1. Select New ⨁.
    2. Under Customers, select Adjustment Note.
    3. Under the Customer ▼ drop-down, select the appropriate customer.
    4. In the Product/Service section, select Bad debts.
    5. In the Amount column, enter the amount you want to write off.
    6. In the Message displayed on statement box, enter “Bad Debt.”
    7. Select Save and Close.
  4. Apply the adjustment note to the invoice.
    1. Select New ⨁.
    2. Under Customers, select Receive Payment.
    3. From the Customer ▼ drop-down, select the appropriate customer.
    4. From the Outstanding Transactions section, select the invoice.
    5. From the Credits section, select the adjustment note.
    6. Select Save and Close.

The most common method of recording bad debts is using the allowance for bad debts account.

  1. Create a bad debt expense account.
    1. Select the Settings ⚙ icon. Under Your Company, select Chart of Accounts.
    2. At the upper right, select New.
    3. From the Account Type ▼ drop-down, select Expenses.
    4. From the Detail Type ▼ drop-down, select Bad debts.
    5. In the Name field, enter “Bad debts” or “Uncollectible debts.”
    6. Select Save and Close.
  2. Create an allowance for bad debt account.
    1. Select the Settings ⚙ icon. Under Your Company, select Chart of Accounts.
    2. At the upper right, select New.
    3. From the Account Type ▼ drop-down, select Current Assets.
    4. From the Detail Type ▼ drop-down, select Allowance for bad debts.
    5. In the Name field, enter “Allowance for bad debts.”
    6. Select Save and Close.
  3. Create a bad debt item.
    1. Select the Settings ⚙ icon. Under Lists, select Products and Services.
    2. At the upper right, select New, and then Non-inventory.
    3. In the Name field, enter “Bad debts.”
    4. From the Income account ▼ drop-down, select Allowance for bad debts.
    5. Select Save and Close.
  4. Create an adjustment note for your invoice.
    1. Select New ⨁.
    2. Under Customers, select Adjustment Note.
    3. From the Customer ▼ drop-down, select the appropriate customer.
    4. In the Product/Service section, select Bad debts.
    5. In the Amount column, enter the amount you want to write off.
    6. In the Message displayed on statement box, enter “Bad Debt.”
    7. Select Save and Close.
  5. Apply the adjustment note to the invoice.
    1. Select New ⨁.
    2. Under Customers, select Receive Payment.
    3. From the Customer ▼ drop-down, select the appropriate customer.
    4. From the Outstanding Transactions section, select the invoice.
    5. From the Credits section, select the adjustment note.
    6. Select Save and Close.
  6. Enter a journal entry for the allowance account.
    1. Select New ⨁.
    2. Under Other, select Journal Entry.
    3. Enter the correct journal date.
    4. In the first line, select or enter the following:
      • Account ▼ drop-down: Allowance for bad debts
      • Debit: amount you want to write off
      • Description: enter “To write off bad debt - [customer name]”
      • Name: customer name
    5. In the second line, select or enter the following:
      • Account ▼ drop-down: Accounts Receivable (A/R)
      • Credit: (the amount auto-populates)
      • Description: enter “To write off bad debt - [customer name]”
      • Name: customer name
    6. In the Memo box, enter “To write off bad debt - [customer name].”
    7. Select Save.
  7. (Optional) You can create a recurring bad debt expense journal entry. To do this:
    1. Estimate your yearly bad debt expense, then divide it by 12.
    2. Select the Settings ⚙ icon.
    3. Under Lists, select Recurring Transactions.
    4. From the Transaction Type ▼ drop-down, select Journal Entry.
    5. Name the template, set the type to Scheduled, then change the interval and the start date.
    6. In the first line, select or enter the following:
      • Account ▼ drop-down: Bad debts.
      • Debit: monthly estimated bad debt amount.
      • Description: enter “Estimated bad debt.”
    7. In the second line, select or enter the following:
      • Account ▼ drop-down: Allowance for bad debts
      • Credit: the amount auto-populates.
      • Description: enter “Estimated bad debt”
      • Name: customer name
    8. In the Memo box, enter “To write off bad debt - [customer name].”
    9. Select Save template.

If a customer pays an invoice or an amount that you wrote off, you just need to void the adjustment note and the journal entry (for Allowance method) to restore the accounts receivable so you can pay it off.

Note: If you wrote off the bad debt in a prior year, talk to your accountant before making any changes.

  1. Go to the Sales menu, then select Customers.
  2. Select the customer’s name.
  3. Find and open the adjustment note you want to undo.
  4. At the bottom, select More, and then Void.
  5. Confirm you want to void the adjustment note.
  6. Go back to the Sales menu, then select All Sales.
  7. Find and open the journal entry you want to undo.
  8. At the bottom, select More, and then Delete.
  9. Confirm you want to delete the journal entry.

You can now record the payment for the invoice as you normally do.

Cash basis

If you file your taxes on cash basis, you can void the invoice since they haven’t been reported as income yet. To do this:

Does your invoice have billable expenses, billable time, charges, or credits?
If it does, we don’t recommend voiding the invoice. You can write it off by adding products/services with a negative amount to the invoice.
  1. Create a bad debts expense account. Check out the steps under Direct method.
  2. Create a bad debts item. Check out the steps under Direct method.
  3. In the next line, add the original product/service on the invoice, then enter the same amount as a negative.
  4. In the following line, add the bad debt item, then enter the original billable amount as a negative.
  5. Select Save.
  1. Go to the Sales menu, then select Invoices.
  2. Find and select the uncollectible invoice.
  3. Under the GST column, change all the sales tax rate to Out of Scope (0%).
  4. At the bottom, select More, then Void.
  5. Confirm you want to void the invoice.
  6. Reopen the invoice.
  7. In the Message on statement box, enter “Bad debt” after Voided.
  8. Select Save.
  1. Go to the Sales menu, then select Invoices.
  2. Find and select the uncollectible invoice.
  3. Under the GST column, change the sales tax rate for the bad debt to Out of Scope (0%).
  4. In the next lines, select the corresponding products/services for the bad debt.
  5. In the amount column, enter the balance for each product/service as a negative amount.
  6. In the Message on statement box, enter “Bad Debt.”
  7. Select Save.

Note: You can tell a bad-debt entity apart from your other customers by adding a note to their name:
  1. Go to the Sales menu, then select Customers.
  2. Select the customer’s name.
  3. At the upper right, select Edit.
  4. In the Display Name as field, enter “Bad Debt” or “No Credit” after the customer name.
  5. Select Save.

Was this helpful?

You must sign in to vote, reply, or post