How to Write Off Bad Debt in QuickBooks

June 15, 2023

How to Write Off Bad Debt in QuickBooks

Despite your utmost efforts, there are instances where customers fail to settle their outstanding invoices, resulting in unpaid accounts receivable. To maintain accurate financial records and ensure the true depiction of your business's financial status, it is vital to appropriately write off bad debts. QuickBooks, a popular accounting software, offers a simple and efficient way to accomplish this task. This article will guide you through writing off bad debts in QuickBooks step-by-step.

Contents

Boost Your Financial Accuracy: Writing off Bad Debts in QuickBooks

Step 1: Review and Identify Bad Debts

Step 2: Create a Bad Debt Expense Account

Step 3: Create a Bad Debt Item

Step 4: Prepare a Credit Memo

Step 5: Apply the Credit Memo

Step 6: Run Financial Reports

FAQs

Boost Your Financial Accuracy: Writing off Bad Debts in QuickBooks

Step 1: Review and Identify Bad Debts

Before you can write off bad debts, it’s essential to review your accounts receivable and identify the debts that are considered uncollectible.

  • Check your aging accounts receivable

  • Review other invoices or receivables that should be considered as bad debt using the Accounts Receivable Aging Detail report

  • Navigate to Business Overview menu, then select Reports

  • Find and open the Accounts Receivable Aging Summary

AR aging summary to review and identify bad debts

  • Check which outstanding accounts receivable should be written off

Step 2: Create a Bad Debt Expense Account

To accurately track and report bad debts, you must create a dedicated expense account in QuickBooks. This account will record the value of the debts you’re writing off.

  • Click the Settings gear icon and select ‘Chart of Accounts’

chart of accounts to create a bad debt expense account

  • At the upper right in the ‘Chart of Accounts screen’ select ‘New’ to create a new account

  • From the Account Type ▼ dropdown, select ‘Expenses’

  • From the Detail Type ▼ dropdown, select ‘Bad debts’

  • In the Name field, enter ‘Bad debts’

  • Select Save and Close

creating a account for bad debt

Step 3: Create a Bad Debt Item

  • Click the Settings gear icon and select ‘Products and Services’

create bad debt item products and services list

  •  In the ‘Product/Service information screen’ select 'New' and then 'Non-inventory'

new non inventory item for bad debt

  • In the Name field, enter ‘Bad debts’

  • From the Income account ▼ dropdown, select ‘Bad debts’

  • Select Save and Close

product service information bad debt

Step 4: Prepare a Credit Memo

Once you’ve created the bad debt items, the next step is to prepare a credit memo for each customer who owes an uncollectible amount.

  • Click + New

  • Select Credit memo

credit memo for bad debt

  • Select the customer from the Customer ▼ dropdown

  • Select' Bad debts in the 'Product/Service' section

  • In the Amount column, enter the amount you want to write off

  • In the Message displayed on the statement box, enter ‘Bad Debt’

  • Select Save and Close

creating cedit memo

Step 5: Apply the Credit Memo

After creating the credit memo, apply it to the specific invoices that are deemed uncollectible. QuickBooks automatically adjusts the customer's accounts receivable balance, as a result, the bad debts will be reduced.

  • Click + New

  • Under Customers, select Receive Payment

receive payment to apply credit memo

  • From the Customer ▼ dropdown, select the appropriate customer

  • From the ‘Outstanding Transactions’ section, select ‘Invoice’

outstanding transactions and invoices

  • From the ‘Credits’ section in the ‘Receive Payment’ menu select the ‘Credit Memo’

  • Select Save and Close

credit memo in receive payment menu

Step 6: Run Financial Reports

After completing the write-off process, run financial reports in QuickBooks to ensure the bad debts have been accurately reflected. Generate reports such as the Profit and Loss statement and the Balance Sheet to review the impact on your business’s financial position.

FAQs

Q1: What Are Bad Debts in QuickBooks?

Bad debts in QuickBooks refer to unpaid customer invoices that are considered uncollectible. These are debts that you have determined cannot be recovered and need to be written off as an expense.

Q2: Why Is It Important to Write Off Bad Debts in QuickBooks?

Writing off bad debts in QuickBooks is crucial for maintaining accurate financial records. It allows you to reflect the actual state of your accounts receivable and helps you make informed decisions based on accurate financial information.

Q3: How Do I Identify Bad Debts in QuickBooks?

To identify bad debts in QuickBooks, review your aging reports to determine invoices outstanding for an extended period without any signs of Payment. Consider these invoices uncollectible and write them off as bad debts.

Q4: How Do I Create a Bad Debt Expense Account in QuickBooks?

To create a bad debts expense account in QuickBooks, navigate to the 'Chart of Accounts' section, click on the 'New Account' section, and click 'New Account.' Choose the account type as 'Expense' and provide a name for the account, such as 'Bad Debts Expense.' Save the account to create it.

Q5: Can I Recover Bad Debts after Writing Them off in QuickBooks?

Yes, it is possible to recover bad debts after writing them off in QuickBooks. If a customer eventually pays the debt that was previously written off, you can record the payment as income and apply it to the appropriate accounts receivable.

Q6: How Do I Generate Financial Reports in QuickBooks to Verify the Written-off Bad Debts?

In QuickBooks, navigate to the 'Reports' section and select the desired financial reports, such as the Profit and Loss Statement or the Balance Sheet. Customize the report settings as needed, then run the report to review the updated financial statements reflecting the written-off bad debts.

Q7: Can I Write Off Bad Debts in QuickBooks without Creating a Credit Memo?

Creating a credit memo in QuickBooks when writing off bad debts is recommended, as it helps maintain a clear record of the debt cancellation. However, the process may vary depending on your business requirements and accounting practices.

Q8: What Happens to the Customer’s Account Receivable Balance When a Bad Debt Is Written off in QuickBooks?

When a bad debt is written off in QuickBooks, the customer’s accounts receivable balance is automatically reduced by the amount of the written-off debt. This adjustment reflects the uncollectible status of the debt.

Tags

accounting

bad debt

bookkeeping

quickbooks

write off

Scale Your Bookkeeping

Download the guide to scale and streamline your bookkeeping business.

Automated data Import / Export to QuickBooks Online
Say goodbye to the hassle of managing transactions manually
Grow exponential with Clear Financial Visibility