cancel
Showing results for 
Search instead for 
Did you mean: 
Daniela_A
QuickBooks Team

How do I write off an unpaid invoice?

Thanks for keeping in touch with us @mbell19.

 

Ideally, the steps provided by my colleague above is the correct process in writing off a bad debt. Since QuickBooks has its own method to solve cases like yours, I would suggest working with your accountant to properly sort out this kind of matter.  If you don't have an accountant, we can help you locate a ProAdvisor in your local area.

 

In addition, I've also included this reference for a compilation of articles you can read while working with us: The different transactions you can use to track your sales.

 

If there's anything else you need, please let me know. I'd be more than willing to lend you a hand.

printingorlando
Level 1

How do I write off an unpaid invoice?

This is how I am currently setting up Credit Memos.  The issue I have is that only two of the multiple credit memos are showing up in the Sales Tax Report.  All are dated for the same date/month.  They all have sales tax listed that I have already paid the State and I am trying to deduct going forward.  Any advice is appreciated.

 

Thank you,

Shannon

CharleneMaeF
QuickBooks Team

How do I write off an unpaid invoice?

This is unusual, printingorlando.

 

Let me make it up to you by ensuring this gets resolved.

 

There might be an issue with your company file's data that's causing the credit memos not to show in the Sales Tax report. I recommend running Verify and Rebuild Data utility. The tool scans data issues within the company file and self-resolves them.

 

Beforehand, make sure to create a backup copy. If there are changes that occur, having a copy allows you to restore it to undo the changes.

 

Follow the steps below on how to verify data:
 

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
  4. Click OK if QuickBooks detected no problem with your data.
  5. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
  6. Click Close or View Errors and take note of the specific error message.

 

Next, here's how to rebuild data:
 

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Rebuild Data.
  4. Click OK if you receive a prompt to back up your company file.
  5. Click OK when you get the message, Rebuild has completed, and proceed to the next step.
  6. Run Rebuild Data again to make sure there's no error.

 

Also, it's best to make sure your QuickBooks Desktop is up-to-date. This way, you always have its latest features and fixes. 

 

Additionally, I've added an article that'll help you easily personalize and keep track of your sales transactions in QuickBooks Desktop: Customize Customer and Job Reports.

 

Please keep me updated on how this works on your end. I'm determined to help you succeed. Take care always!

printingorlando
Level 1

How do I write off an unpaid invoice?

Thanks for the response!

 

I have quickbooks online, does that make a difference?

Carneil_C
QuickBooks Team

How do I write off an unpaid invoice?

I appreciate you getting back on this thread and clarifying that you're using QuickBooks Online to help us get on the same page, printingorlando.

 

To get around this issue with your credit memo not showing up in the Sales Tax report, you'll want to double-check the breakdown of the sales taxes on your credit memos. I'll show you how to do it. 

 

  1. Go to the Sales menu and select Customers
  2. Choose the customer and find the credit memo. 
  3. View the credit memo and review the details. 
  4. Select See the math or the total tax amount.

 

This opens the "How your sales tax is calculated" page, where QuickBooks gives you a detailed breakdown of the sales tax. Then, verify the information, specifically in the Location and Address section

 

If the issue persists, I suggest contacting our Customer Team Support so they can investigate this issue further and find potential solutions. Here's how: 

 

  1. Go to Help (?), then click Search.
  2. Select Contact Us.
  3. Please enter your question and tap Continue.
  4. Choose a way to connect with a live support agent: Ask the communityHave us call you, or Chat with us.

 

Moreover, please see this article for more insights on how QBO calculates your sales taxes: Learn how QuickBooks Online calculates sales tax

 

Furthermore, I've added these great resources that'll help you modify your reports based on the data you need:

 

 

Don't hesitate to leave a comment below if you need further assistance with sales taxes in QBO. I'm always here to help.

DianaDe
Level 1

How do I write off an unpaid invoice?

Hello,  How is invoice going to be shown as "washed away" if it was never received and thus not reflected as income using cash basis.  Thank you!

AbegailS_
QuickBooks Team

How do I write off an unpaid invoice?

Thanks for chiming in, @DianaDe. I'm here to help you keep the process of writing off-invoice balances easy and simple.

 

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.

 

Here's how: Step 1: Check your aging accounts receivable:

 

  1. Go to the Reports menu.
  2. Find and open an Accounts Receivable Aging Detail report.
  3. Check which outstanding accounts receivable should be written off.

 

Step 2: Create a bad debts expense account:

 

  1. Go to Settings ⚙ and select Chart of Accounts.
  2. At the upper right, select New to create a new account.
  3. From the Account Type ▼ dropdown, select Expenses.
  4. From the Detail Type, select Bad debts.
  5. In the Name field, enter “Bad debts.”
  6. Select Save and Close.

 

You can take a look at this article for the detailed steps (proceed to Step 3):  Write off bad debt in QuickBooks Online. This will provide you steps on how to manage uncollectible invoices in QuickBooks.

 

Additionally, you can visit the following write-up: Sales and customers. This will provide you links on how to manage your company income as well as resources about other customer-related concerns.

 

I'm only a post away if I can be of additional assistance or need more help with QuickBooks. I'm always here to keep helping. Wishing you a wonderful rest of the week.

BP465
Level 2

How do I write off an unpaid invoice?

I'm in a slightly different situation than the others here.  I use QB online for our homeowners association and send out invoices for amounts due the association.  I took over in 2022 and one member had an overpayment, so I told them to underpay an invoice in 2023. I'm not sure how I should have handled it, but now I have an unpaid balance on the invoice in 2023 (and I don't want to go back and change 2022). Now, I'd like to write off or make a journal entry to eliminate the balance on that invoice with the corresponding credit/debit going to the expense account for that item.  It isn't a bad debt, so I don't want to create a bad debt account.  It's just an accounting mistake to correct, so it doesn't carry over to 2024.  It's a small amount.  

Thanks you

RhoiceW
QuickBooks Team

How do I write off an unpaid invoice?

Thank you for participating in the thread, BP465. I'll be glad to provide more information about how to clear the unpaid balance on your 2022 invoice.

 

You can create a credit memo to immediately reduce a customer's current balance and here's how:

 

  1. Select +New, then click Credit memo.
  2. In the Customer dropdown, choose the customer that you want to add a credit.
  3. Enter the credit memo details, such as the date and amount.
  4. Hit save and close , once done.

 

Here's how to apply the credit memo to an invoice:

 

  1. Click the + New icon.
  2. Press Receive payment.
  3. Select the customer drop-down.
  4. In the Outstanding Transactions section, tick the open invoice if you want to apply the credit memo.
  5. Under the Credits section, pick the credit memos you want to apply.
  6. For the open invoice in the Payment column, enter how much of the credit you want to apply.
  7. Leave the Payment methodReference noDeposit to, and Amount received fields blank.
  8. Fill out the rest of the form, including the Payment date.
  9. Make sure the total is correct after applying the credit memo.
  10. Once done, select Save and close.

 

You can create a journal entry if you don't want to change your 2022 invoice. However, we recommend reaching out to your accountant to ensure your records are in order. If you don't have an accountant, you can click this article to look for an accountant: Add accountant users in QuickBooks Online.


Also, you can check this article with detailed steps on how to give a credit memo to customers: Create and apply credit memos or delayed credits in QuickBooks Online.

 

In case you want to learn how to reverse a journal entry or delete it entirely, feel free to check this article: Reverse or delete a journal entry in QuickBooks Online.


Please don't hesitate to leave a comment if you have further concerns about the unpaid balance on your invoice. I'm just right here to help you out.

BP465
Level 2

How do I write off an unpaid invoice?

Thanks so much.

I am trying what you suggested, but I don't see the credits section that you reference in step 5.

 

Branchironworks
Level 1

How do I write off an unpaid invoice?

I did this whole process and when I hit save it says saved but when I go into the customers account that amount that I just did the discount to the bad debt acct. is till in there so I do not know what to do to get this amount off of the customers acct. and go to bad debt.

 

Branchironworks
Level 1

How do I write off an unpaid invoice?

This whole process seems really simple.  I did just what it says and it showed saved.  I went into the customers account and the amount I just put in bad debt is still there.  It will not save.   I don't know what is keeping this from saving when I am done doing this process.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us