Write Off Bad Debt in QuickBooks

Write Off Bad Debt in QuickBooks
  • January 10, 2024

QuickBooks Desktop has become incredibly popular among small and medium-sized businesses due to its extensive range of advanced features and tools. It prioritizes unmatched data security standards, ensuring that the information entered into the software remains completely protected. In this detailed article, our dedicated experts will thoroughly explain the procedure for writing off bad debts in QuickBooks Desktop.

Bad debt means if a QuickBooks customer is not paying the bill that a customer needs to QuickBooks has a feature to write off a bad debt to this customer so that the customer appears to be blacklisted so that will not be entertained by any company in the future and has to give the penalty for the same once the writing off bad debt in QuickBooks is issued.

Advantages of Write Off Bad Debts in QuickBooks Desktop

  • You will be able to clear the invoices from the accounts receivable. Due to this, you get the net profit amount.
  • You will not have any miscalculations in the income statement and profit and loss reports.
  • When you record a bad debt, invoices become collectible.

Things to Do Before Writing off Bad Debts in QuickBooks Desktop

1. The Accountant Must Be Consulted

The accountant must be consulted before writing off the decision because the loss of the customer or the customer himself must not be aware of the same. So they must be told before this is happening for bad debt in QuickBooks which is assumed to be non-tolerance to the companies using QuickBooks.

2. Allowance Should Not be Used

When the writing-off is performed then the allowance should not be used and the gross high percentage is recorded and entered as well. In journal entries also it should be mentioned if the customer writing off is done so that in the future or at any moment the details must be available about the customer to reduce data corruption and data loss also.

3. Feature to Keep the Recording of The Write-off debt

Generally in QuickBooks Enterprise and QuickBooks Professional, the writing off the bad debt is done as well as the QuickBooks cash basis also has this feature to keep the recording of the write-off debt, and then the invoices are checked so that the debt which is given has the valid reason by checking all the payments and transactions done by the customer is analyzed.

How to Set Up a Bad Debt Account in QuickBooks Desktop?

Before going to learn the process of writing off bad debt, first, you must have a look at the setup process of a Bad Debt Account in Quickbooks.

To set up a bad debt account in QuickBooks, You need to follow the instructions below steps:

  • Login to Quickbooks Dashboard.
  • Click on the Gear Icon.
  • Select Chart of Accounts.
  • Click on New.
  • Select Your Account Type As Expense
  • In the Name Field (Type Bad Debt)
  • Choose Bad Debt as the Detail Type.

Steps to Write off Bad Debts in QuickBooks Online

Verify Aging Report

  1. Click on Reports: First of all, You need to Click on Reports which is in The Left Side panel in QuickBooks.
  2. Search for Account Receivable Aging Report: At the Top Search bar section Search for Account Receivable Aging Report.
  3. Analyze Your Outstanding Receivable Account: To Analyze your Outstanding Receivable Account You need to click on Account Receivable Aging Report details.

Make An Account for Bad Debt Expenses

  1. Choose Chart of Accounts: Go to Company Section >> Click on Gear Icon >> Choose The Chart of Accounts Option.
  2. Select Option: Before Moving to Next >> Select The Option
  3. Click on Expenses Option: Go to Account Type Dropdown List >> Now Click on Expenses Options.
  4. Give A Name to Bad Debts: From the drop-down list>> Select All Bad Debts >> Assign Bad Debt in The Name Field.
  5. Final Step: To end the Procedure >> Click on Save & Close.

Make A Bad Debt Item

  1. Select Product & Service: Go to the list section >> Click on the gear icon >> Select product and services >> Choose The Option.
  2. Click on Non-Inventory Option: Click on New Product >> Click on Non-Inventory Option from the Product/Service Information Section.
  3. Type Bad Debt: Inside the Name Text Box >> Type the Bad Debt.
  4. Select Bad Debt Expenditure: Now Select The Bad Debt Expenditure That you have created in the Income Account Section.
  5. Unmark The Check Box: Unmark the “Is Taxable” Check Box.
  6. Final Step: At Last, you need to click on the Save & close option.

Set Up The Credit Memo for the bad debt

  1. Login to Quickbooks Dashboard >> Click on the Plus Icon.
  2. Go To Customer Section >> Select The Credit Memo.
  3. From the customer drop-down list >> Select Customer.
  4. Select The Item that you have created for the bad debt in the Product & service field.
  5. With Positive Values type the amount of bad debt or unpaid invoices.
  6. Now Type the bad debt amount in the memo text box.
  7. To End this Step Click on the Save & Close Option.

Access A Bad Debt Report

  1. Reach to Receive Payments from The Customers: At the top of the screen Click on + Icon >> Navigate to Receive Payments from The Customers section.
  2. Select The Customer: Go to the customer drop-down list >> select customer.
  3. Select The Invoice: Select the Invoice That you want to write off from the outstanding transaction.
  4. Select The Credit Memo: Go Under the credit section >> Select the Credit Memo.
  5. Run A Check: Perform a check & confirm >> Reflecting amount in the section must be $0.00.
  6. Final Step: Click on the Save & Close option to end the procedure.

Run a bad debt report

If you want to check all the receivables you tagged as bad debt, you can run an Account QuickReport.

  • Select Chart of Accounts from Settings.
  • Select Run report from the Action column of the bad debts account.

Note: Bad-debt entities can be distinguished from other customers by adding a note to their name:

  • Select Customers under Get Paid & pay
  • Choose the name of the customer.
  • At the upper right, select  Edit.
  • Enter "Bad Debt" or "No Credit" in the Display Name field.
  • Select  Save.

How to Write Off Bad Debt in QuickBooks Cash Basis?

If the taxes are filed based on cash then the best to get the due and noncollectable amount removed is to either delete or void the open invoices. You can do this because the open invoices are not reported as income.

1. Deleting or Making the Invoices Void

  • Go to the left menu and choose Invoicing or Sales.
  • Then from the top select Customers.
  • After that choose the Customer's Name.
  • Then go to the drop-down list and select Open Invoices adjacent to Show.
  • After that from the list of drop-downs adjacent to Date, choose the date range.
  • Then ensure that every invoice for which you believe that you are not going to receive any payment is selected, and make sure just one at a time.
  • As soon as the invoice opens up, go to the bottom left and select More and then Void.
  • When you see, Are you sure you want to void this? Click on Yes.
  • To make every invoice void repeat the point from 4-6.

2. Direct Method

In case the writing-off amount is going to have an impact on the amount of your gross sale then for sure get in touch with your accountant before you make this entry.

-Ensure that a bad debt or uncollectible expense account is already created.

-You can always get in touch with the QuickBooks helpline to know how the expense account is created.

Creating the service/product item named: Noncollectable Debt or Bad Debt:

  • Tap on the Gear icon which is present at the top and then on Products and Services.
  • Then go to the top right side and then select New.
  • Then choose the template type, service, or noninventory.
  • Then write the name.
  • Then for the field of Income Account, tap on Uncontrollable Debt or Bad Debt expense account.
  • Select Save.

3. Issuing the Credit Memo to the client

  • Choose the icon depicting Plus (+) present at the top and then select Credit Nemo's.
  • After that use the Uncollectible Debt and Bad Debt items and after getting the amount entered that you are willing to write off as the positive number.
  • Now in the field of Memo enter the Bad Debt.
  • After that select Save.

4. Applying the Adjustment Note or Credit Memo

  • Go to the top choose the icon of Plus (+) and then Receive Payment.
  • After that choose the name of the Customer.
  • All the open transactions can be checked easily below the form. Save it and do not fill in the fields of Receive. Payment. If no transactions are present there then select Cancel.

5. Setting the Allowance for the Bad Debt System

To set and start using the allowance method your tax filing and reporting should be based on an accrual basis.

To get the allowance created for the bad debt account:

  • Choose the Gear icon which is present at the top and then the Chart of Accounts.
  • Then on the right side on the top, choose New.
  • In Category Type tap on Current Assets/Other Current Assets.
  • For the Detail type, you will see Allowance for Bad Debts highlighted.
  • Then click on Save.

How to Write off Bad Debt in QuickBooks Desktop?

To write off bad debt in the desktop version of QuickBooks, you need to follow the mentioned below Methods.

1. Method One: Create an Expense Account & Name it Bad Debt

  • Open Chart of Account: Go to the Top navigation bar >> Go to List >> Select Company option >> Now go to Chart of Accounts.
  • Create a New Expense Account: Click on "Account" >> Click on "New" >> Select "Expenses".
  • Give A Name to Expanse Account: Type "Bad Debt" in the "Account Name" Field >> Hit the "Save and Close" Option.

2. Method Two: Record the Bad Debt & Close

  • Go to Customer Menu >> Select the Receive Payments option.
  • In the Receive form, Enter the Customer Name >> In the payment amount field fill the $0.00 >> For Tracking add the invoice number of the bad debt in the description box.
  • Select the "Discount & credits" >> Enter the Bad debt amount in the "Amount of Discount" field. (Note: Fill in the Amount you want to write off).
  • Select the Bad Debt Account you have created in step one in the "Discount Account".
  • Save & Close, Now you're done.

Otherwise, you can reach out to reliable third-party companies like smbaccountants.com. This QB support agency hires top QuickBooks experts who have experience and knowledge combined. They assure feasible support in a very short time. You can give us a call at our Quickbooks Pro Tech support number at ?smbaccountants.com and acquire immediate support.

Frequently Asked Questions

How do I Write off bad debt in QuickBooks Online?

A quick and easy way to do this is simply to delete the bad debt that you can apply to the invoice. Here’s how to do it with these steps:

  • Initially, go to Sales which you find on the left navigation menu.
  •  Next, click on the Customers tab.
  •  Now, choose the customer’s name.
  • After that, select the Credit Memo.
  • Hit more to select the “Delete” option.
  • At last, hit the “Yes” button.

Why Does Bad Debt Occur in QuickBooks Desktop

A bad debt may occur due to several reasons:

  • The customer endured financial distress or worse, they applied for bankruptcy or creditors' protection.
  • Your client believes that the sum of the invoice is too high for the services provided and has only been able to pay a portion of the invoice.
  • Despite your attempts to reach them, the client has become nonresponsive and you believe it is no longer worth trying to obtain.

How do I Create a New Account for Bad Debts?

To create a new account, you have to make an expense account:

  • Go to Toolbar and select the Gear icon. 
  • Next, click on the “Your Company” option.
  •  Now, select “Charts of Accounts.”
  • And then hit the “New” button.
  • After that, select Account Type from the Accounts notification.
  •  A pop menu opens and choose Expenses.
  • Select “Bad Debts” from the Detail type menu.
  • Next, write Bad Debts within the Name field.
  • Finally, click on the “Save” and then the “Close” button.

How do I Write off Amounts on QuickBooks desktop?

  • Go to the Vendors menu and select Pay Bills.
  • Choose the bill that you want to write off the balance for.
  • Select Set Discount.
  • Click on the Discount tab and enter the amount in the Amount of Discount field.
  • To close the Pay Bills window, select Pay Selected Bills.
  • Finally, in the Payment Summary window, select Done.

How Do I Delete a Negative Balance in QuickBooks?

To clear out a negative balance in Undeposited Funds in QuickBooks, follow these steps:

  • Go to the Lists menu.
  • Select Chart of Accounts.
  •  Locate and double-click on Undeposited Funds.
  • Double-click on the Journal Entry (JE) that you want to open, one at a time.
  • Press Ctrl + D on your keyboard to delete the selected Journal Entry.

Infographic of Solutions for Write-off Bad Debt in QuickBooks Desktop

How to Write off Bad Debt in Quickbooks online
Blog Post

Related Articles

How to Set Up Line of Credit in QuickBooks?

December 21, 2023
The credit line serves as a lifeline for small business organizations because it provides you with immediate financing...

Set Up & Calculate Depreciation in QuickBooks

January 4, 2023
Depreciation is an accounting technique utilized to assign a realistic cost to assets. Assets, whether tangible or...

How to Enter Cash Back Rewards in QuickBooks Desktop?

January 9, 2024
What are Cash Back Rewards in QuickBooks Desktop? A Cash Back Reward is nothing but an income when you receive it. It...
Call Now+1-800-961-4963