Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
April 9, 2021
Solved

bad debt write off

  • April 9, 2021
  • 2 replies
  • 20 views

I wrote off a bad debt in ihe GJ as shown.

When I run an aging report, it shows up as a positive and a negative. How do I get it to not show up at all on an aging report? 

 

Best answer by AlexV

Hello gloriadeb204!

 

The reason why it shows positive and negative lines is because of the method you used, the journal entry. Let me show you how to properly write it off as bad debt.

 

Based on the screenshot, I'll assume you already have an expense account to track the bad debt. If so, proceed to these steps:

  1. From the Customers menu, select Receive Payments.
  2. Select customer in the Received from drop-down, and enter $0.00 in the Payment amount.
  3. Click the Discounts and credits button. 
  4. On the pop-up, enter the amount you'd like to write off in the Amount of Discount field.
  5. For the Discount Account, select the bad debt expense account.
  6. Tap Done, then Save & Close.

 

Once done, pull up the A/R Aging report again to verify.

 

Need more references on how to manage your business in QuickBooks Desktop? Check this link: QBDT All Articles.

 

Leave a reply below if you more of my help. I'll be here!

2 replies

AlexV
AlexVAnswer
Level 10
April 9, 2021

Hello gloriadeb204!

 

The reason why it shows positive and negative lines is because of the method you used, the journal entry. Let me show you how to properly write it off as bad debt.

 

Based on the screenshot, I'll assume you already have an expense account to track the bad debt. If so, proceed to these steps:

  1. From the Customers menu, select Receive Payments.
  2. Select customer in the Received from drop-down, and enter $0.00 in the Payment amount.
  3. Click the Discounts and credits button. 
  4. On the pop-up, enter the amount you'd like to write off in the Amount of Discount field.
  5. For the Discount Account, select the bad debt expense account.
  6. Tap Done, then Save & Close.

 

Once done, pull up the A/R Aging report again to verify.

 

Need more references on how to manage your business in QuickBooks Desktop? Check this link: QBDT All Articles.

 

Leave a reply below if you more of my help. I'll be here!

December 9, 2021

I followed steps 1-2 but in Step 3, I do not see "Discounts and Credits" button anywhere on the screen

February 21, 2023

Good to see you on the thread, @mgonzalez86.

 

The discount option to write off bad debt provided above is for QuickBooks Desktop (QBDT). Allow me to give you some insight on how to clear the items on a bad debt account in QuickBooks Online (QBO). 

 

When the invoices you send to your customers 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. 

 

To do this, you'll need first to create an expense account. Here's how:

  1. Click the Gear ⚙ icon at the top.
  2. Select Chart of Accounts.
  3. In the upper right, select New.
  4. Choose Expenses for the Account Type.
  5. For the Detail Type ▼ drop-down, choose Bad debts.
  6. Enter Bad debts in the Name field.
  7. Select Save and Close.

 

Second, create a bad debt item:

  1. Click the Gear ⚙ icon at the top.
  2. Select Products and Services.
  3. Click New.
  4. Choose Non-inventory.
  5. In the Name field, enter Bad debts.
  6. From the Income account ▼ drop-down, select Bad debts.
  7. Select Save and Close.

 

Third, create a credit memo for the bad debt.:

  1. In the left menu, click the + New button.
  2. Select Credit Memo.
  3. Enter the client name on the Customer ▼ drop-down.
  4. Select Bad debts in the Product/Service section.
  5. Add the amount you want to write off.
  6. (Optional) enter Bad Debt in the Message displayed on statement box.
  7. Select Save and Close.

 

Lastly, apply the credit memo to the invoice:

  1. In the left menu, click the + New button.
  2. Select Receive Payment.
  3. Choose the appropriate customer in the Customer ▼ drop-down, .
  4. From the Outstanding Transactions section, select the invoice you want to write off.
  5. From the Credits section, select the credit memo.
  6. Select Save and Close.

 

After that, the uncollectible receivable now appears on your Profit and Loss report under the Bad Debts expense account.

 

To learn more about recording uncollectible accounts in QBO, see this article: Write off bad debt in QuickBooks Online. It also contains information on how you can run a bad debts report.

 

For future help, if you need to check your sales report and see your cash flow from your customers, I recommend checking out the articles from our Sales reports topic page. 

 

Feel free to visit the Community with any other questions you may have. Or if you run into any trouble along the way. I’m more than happy to assist further. Wishing your business continued success.


Unfortunately I've done this and am now seeing the Invoices on the P&L in the Income, and as the Bad Debt Expenses (therefore Income doesn't balance/ is inaccurate, and the outcome of credit & debt = net $0 / defeats the purpose).  PLEASE advise how to correct this.

BigRedConsulting
Level 15
April 9, 2021

This happens when the journal isn't linked to the invoice it's writing down. Same thing will happen if you record a Payment received transaction and don't apply it to invoices.

To complete the transaction, open the Receive Payments window, select the customer, and then apply the outstanding credit to the open invoice(s).