cancel
Showing results for 
Search instead for 
Did you mean: 
sbright11
Level 1

How do I write off an unpaid invoice?

Can you tell me how to do that in QBO?  Following the above it gave me a negative figure on the customer account.  

Jovychris_A
Moderator

How do I write off an unpaid invoice?

Welcome to the Community, @sbright11.

I can definitely walk you through on how to write off bad debts in QBO. Let me show you how:

 

Create an expense account and name it Bad Debt:

  1. Go to the Gear⚙ icon and then select Chart of Accounts.
  2. Click New on the upper right.
  3. Select Expenses from the Account Type▼.
  4. Choose Bad Debt from the Detail Type▼.
  5. Enter "Bad debts" in the Name field and then click Save and Close.

Create a bad debt item:

  1. Go to the Gear⚙ icon and then select Products and Services.
  2. Click New on the upper right and then Non-inventory.
  3. Enter “Bad debts” in the Name field.
  4. Select Bad debts from the Income account▼ and then hit Save and Close.

Create a credit memo for the bad debt:

  1. Go to + New on the upper left and then select Credit Memo.
  2. Under the Customer▼, select the customer.
  3. In the Product/Service, select Bad debts and then enter the amount to write it off.
  4. In the Message displayed on statement box, enter "Bad Debt" and then click Save and close.

You can now apply the credit memo to the invoice:

  1. Go to + New and then select Receive Payment.
  2. Select the appropriate customer from the Customer▼.
  3. Add the invoice from the Outstanding Transactions section.
  4. Select the Credit memo from the Credits section and then Save and close.

After these steps, you can run the bad debts report:

  1. Go to the Gear⚙ icon and then select Chart of Accounts.
  2. Select Run report in the Action column.

You can refer to this article on how to write off uncollected money: Write off bad debt in QuickBooks Online.


Refer to this article in reconciling your account: Learn the reconcile workflow in QuickBooks. It includes there how to edit completed reconciliation and fix a reconciliation.

Please get back to this thread if you need more assistance. I'll be around to help you. Have a fantastic day!

 

Mark381
Level 2

How do I write off an unpaid invoice?

I have followed the steps through creating the credit memo.  Everything worked as described here and in the Quickbooks Online help instructions until I get to the Receive Payment step.  When I do Receive Payment, it allows me to select the customer and I see the outstanding transactions.  What is missing is the Credit section where I can apply the credit memo.  It is requiring me to select a payment method and enter an amount.

 

When I look at my open receivables report,  I see the reduction in the open receivables for the write-off.  Am I no longer required to apply the credit memo to one of the invoices?

Michelle_b
QuickBooks Team

How do I write off an unpaid invoice?

Thanks for joining the thread, @Mark381.

 

I appreciate you for following the steps provided by my colleague above. There's a possibility that the Automation feature is turned on, that's why you're able to see a reduction to the receivables reports in QuickBooks Online. 

 

It would be my pleasure to help walk you through the steps on how to check the settings. Here's how:

 

  1. Go to the Gear icon on the upper right pane. 
  2. Select the Account and Settings tab.
  3. Choose Advance, then locate Automation
  4. Verify if the Automatically apply for credits is On

 

Once verified, nothing to worry about your reports because you're on the right track. If you don't want to automatically apply the credits to your existing transaction, simply turn off the feature. 

 

However, if the Automation is already turned off and still unable to apply to credit, I suggest performing a few basic troubleshooting steps to resolve the issue. To start, access your QBO account using a private browser. At times, the stored data can cause some problems in your browser's web pages.

 

Use these shortcut keys: 

  • Ctrl+ Shift + N (Google Chrome)
  • Ctrl + Shift + P (Mozilla Firefox)
  • Ctrl + Shift + P (Internet Explorer)
  • Command + Shift + N (Safari)

Once logged in, go to the Received Payments and check if you're able to apply the credit memo. If the private browser works, you can clear the cache depending on which browser you're using through this helpful article: Delete Temporary Internet Files. Using another compatible browser is a good option too.

 

Let me know if there's anything else you need about QuickBooks by clicking the Reply button below. I'm always here to help.

Mark381
Level 2

How do I write off an unpaid invoice?

Thanks.  That is what it turned out to be.  I found it in another training video.  When this feature is turned on, it applies the credit to the next invoice.  Once I turned it off, I was able to apply it to a current invoice.

 

Thanks for the quick response.

LW2
Level 2

How do I write off an unpaid invoice?

Uh oh...that's how I have been doing it while in accruel is that ok? Nothing has ever ended up in bad debt...not because I didn't want it to but because I didn't know how. My only concern was that it might look as if the customer returned items to inventory and that obviously never happened so all these years when I didn't want to have inventory in qbks it's affected my cost of good sold probably making it appear I had more in inventory than is real...I hate accounting and bookkeeping as they make it impossible to understand the accruel and I bet I've lost so much money not understanding anything. Sorry but whoever thought up accruel

makes me upset.

Rasa-LilaM
QuickBooks Team

How do I write off an unpaid invoice?

Thanks for following on this thread, @LW2.


Based on the details provided, record the uncollectible customer transactions using the bad debt process. This ensures your accounts receivable and net income are up to date.


You can also use this method for accrual accounting. Since there were transactions recorded as credits, I recommend consulting with an accountant for further assistance.


They can provide recommendations on how to properly input them in QBO. This way, it will not throw off your records.


If you’re using the online version, follow the steps provided by @Jovychris_A above. For QuickBooks Desktop, let me show the process.

 

  1. Go to the Lists menu to choose Chart of Accounts.
    bd.png
  2. Scroll down to the bottom of the page and click the Account drop-down to select New.
    bd1.png
  3. This will open another window where you can continue setting up the account.
  4. Mark the radio button for Expense and then tap the Continue button.
    bd2.png
  5. Enter a term that will identify the entry in the Account Name field, for example, Bad Debt.
    bd3.png
  6. Press Save and Close to keep the changes.

You’re now ready to close the bad debt. To accomplish this task, follow the recommended steps in this article and proceed directly to Step 2: Write off bad debt in QuickBooks Desktop.


Let me know in the comment section below if you need further assistance. I’m always ready to help you. Have a good one.

Swebber
Level 1

How do I write off an unpaid invoice?

I have tried this, the issue I find is these write offs will eventually end up in the sales tax liability report. So my question is, are the items supposed to be taxable or nontaxable items. We have been audited by the State of Texas before and anything listed under non tax has to have a valid reason. If non taxable or taxable, either way shows up on reports we submit to the state. What do you advise.

Thank you.

sw

andrewcoplon
Level 1

How do I write off an unpaid invoice?

How do you create a Credit Memo if you don't use Quickbooks for invoicing?

DivinaMercy_N
Moderator

How do I write off an unpaid invoice?

Thanks for joining this thread, @andrewcoplon.

 

Credit Memo is used for the overpayment of the customer which is greater than the outstanding invoice. If you want to keep it, you'll have to create a deposit posting to the Accounts Receivable account.

 

  1. On the Homepage, navigate to Record Deposits / Make Deposits.
  2. In the Payments to Deposit window, select the payments you want to combine. Then OK.
  3. In the Make Deposits window, pick the A/R account you want to put the deposit into from the Deposit to dropdown.
  4. Check the deposit total. 
  5. Enter the date you made the deposit at your bank.
  6. When you're done, hit Save & Close.

 

If you want to refund it to your customer, you'll need to create a check

 

  1. Go to the Banking menu and click Write Checks.
  2. Under the Bank Account field, choose the account where the money will be taken from.
  3. In the Pay to the Order of box, should be the name of the customer the check was issued for.
  4. Enter the Date and Amount.
  5. Hit Save & Close when done. 

 

Before doing changes in your company file, we recommend always create a backup copy so you can always restore your data

 

Here's a great source where you can find articles that can help you in managing your books in QuickBooks, please visit our QBDT help articles page. This includes topics such as reconciliation, track income, and expenses, run reports, etc.

 

Keep in touch with me if you have further concerns about creating a credit memo in QuickBooks. I'll be around whenever you need further assistance. Take care always.

greencross
Level 1

How do I write off an unpaid invoice?

Do you have to create a bad debt account for each customer? I have several that just didn’t pay their last bill. If I have to create a bad debt account for each it seems there should be an easier way...

LieraMarie_A
QuickBooks Team

How do I write off an unpaid invoice?

This is just the place to get the answers you're looking for, @greencross.

 

There are times when an invoice becomes non-collectible and you need to write it off and declare it as a bad debt so you can clear the invoice out of your accounts receivable and reduce your net profit by its amount. All you need to do is to create one expense account for bad debt. There's no need to create one for each customer. You can track them by running an Account QuickReport. The steps below will ensure your success in writing off bad debts:

 

Step 1: Add an expense account to track the bad debt.

  1. Click Lists on the menu.
  2. Select Chart of Accounts.
  3. Select the Account menu and then New.
  4. Select Expense, then Continue.
  5. Enter an Account Name, for example, Bad Debt.
    Capture.JPG
  6. Select Save and Close.

 

Step 2: Close out the unpaid invoices.

  1. Click Customers menu.
  2. Select Receive Payments.
  3. Enter the name of the customer in the Received from field.
  4. For Payment amount, enter $0.00.
  5. Select Discounts and credits.
  6. In the Amount of Discount field, enter the amount you'd like to write off.
  7. For Discount Account, select the account you added in step 1, and select Done.
    Capture2.JPG
  8. Select Save and Close.

 

This article outlines the steps for writing off bad debt: Write off bad debt in QuickBooks Desktop.

 

To run the Account QuickReport, follow the steps below:

  1. Click Lists on the menu.
  2. Select Chart of Accounts.
  3. Locate your Bad Debt account and right-click on it.
  4. Select QuickReport:Bad Debt.

 

In addition, you can check your customers' open balances by running the Accounts Receivable Aging Detail report. Just follow these steps: 

 

  1. Go to the Reports menu.
  2. Select Customers & Receivables.
  3. Click A/R Aging Detail

 

Please let me know if you have any follow-up questions about writing off bad debts. I'm always here to help. Have a wonderful day.

SMOSSCSPUMP
Level 1

How do I write off an unpaid invoice?

The invoice then shows "PAID," and I don't like that. Is there any way to change that terminology?

"WRITE OFF" OR "BAD DEBT" WOULD BE PREFERRABLE.

 

JasroV
QuickBooks Team

How do I write off an unpaid invoice?

I appreciate your thoughts and opinion, @SMOSSCSPUMP.

 

I recognized having the option to change the PAID status stamp to WRITE OFF or BAD DEBT would be beneficial to you and to your business. However, the option to do so isn’t available in QuickBooks Desktop (QBDT).

 

Rest assured our product team is always looking for ways to improve our product to meets the needs of our users. To stay current on our latest news and enhancement, check out our Product Updates page for reference.

 

In addition to this, let me attach this link that you can use for future guidance in personalizing your invoices: Use and customize form templates. This resource can guide you through the steps on how to add logo and change and fonts of your sales form.

 

You’re always welcome to post a comment below if you have any other concerns or questions about invoices in QBDT.

rcoiteux1
Level 1

How do I write off an unpaid invoice?

I'm lost. I have a customer that has not paid me and I have to take her to court. I followed the instructions for bad debt in the customer payment page. My question I can't seem to find an answer for, WHAT account do you select for DEPOSIT TO field?

QB deposit field.JPG

JonpriL
Moderator

How do I write off an unpaid invoice?

Hello @rcoiteux1,

 

You don't have to worry about the account used to deposit the payment for a bad debt invoice. Bad debt is designed to close out invoices from customers with whom you didn't receive any payment with.

 

For an in-depth discussion about these invoices, here's an article you can read to learn more: Write off bad debt in QuickBooks Desktop.

 

On top of that, 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 that I can help you with, please let me know in the comments below. I'll be here to lend a hand.

Youdeline  laurint
Level 1

How do I write off an unpaid invoice?



@CGW08 wrote:

Someone PLEASE hold my hand! I see all this advice to attach memos, etc. When I run a report or open the unpaid invoice my only option (as far as I can tell) is to receive payment and input a monetary amount in the amount paid block before I have the choice to write the unpaid balance off. I'm not going to get the unpaid balance so my only option I can see is to show a payment of at least 1 cent and then write off the remaining. I run a heavy equipment business and I'm good at that but not QB. Thanks for any clarification.


 

LeizylM
QuickBooks Team

How do I write off an unpaid invoice?

I'll help you in writing off the balances of your invoices in QuickBooks, Youdeline laurint. 

 

I know how it is important to record correctly all of your transactions in QuickBooks. When invoices you send in QuickBooks Desktop become uncollectible, you need to record them as a bad debt and write them off.  

 

Here's how to add an expense account to track the bad debt:

 

  1. Go to the Lists menu. 
  2. Select Chart of Accounts.
  3. Click the Account menu at the bottom left, then select New.
  4. Select Expense, then Continue.
  5. Enter an Account Name. 
  6. Click Save and Close.

 

Once done, we can start over to close out the unpaid invoice. 

 

  1. Go to the Customers menu. 
  2. Select Receive Payments.
  3. Enter the name of the customer in the Received from the field.
  4. For the Payment amount, enter $0.00.
  5. Select Discounts and credits.
  6. In the Amount of Discount field, enter the amount you'd like to write off.
  7. For Discount Account, select the bad debt account, and select Done.
  8. Click Save and Close.

 

In addition, you can check the customer's open balances by going to the Reports menu and selecting Customers & Receivables. Then, click A/R Aging Detail.

 

I'm also adding these resources that can guide you manage your reports in QuickBooks:

 

 

I’m happy to offer assistance again if you have any other concerns or questions about invoices in QuickBooks Desktop. Post a new thread or reply here and I’ll be there. 

ozdavis
Level 3

How do I write off an unpaid invoice?

Fantastic response that went above and beyond. Thank you very much.

Oz

Carolexx
Level 4

How do I write off an unpaid invoice?

I have the same problem.  I want the invoice, which already had work done on it...charged as a loss not just a transaction to clear the balance but actually charged to a loss.  why isn't there just an option to charge off the balance on an invoice instead of either having to just delete the thing and not take the loss in the instance that it's a small re-negotiated amount.  We are professionals, no inventory and are running the enterprise professional just so we can get a correct accrual report and that is screwed up all the time by "paid" but not actually recorded...what does that mean?????  UGH

vsilinin
Level 1

How do I write off an unpaid invoice?

I do have one question. If you write off the bad debt as a whole, do you still then end up paying HST on the sale to the CRA? Is there a way to write off the base amount and apply the HST offsetting credits to your HST account?

Trish_T
QuickBooks Team

How do I write off an unpaid invoice?

Hi vsilinin, 

 

Thanks for joining us here.  When you write off an invoice as 'Bad Debt', the transaction is closed out.  However, if you're still not certain, I recommend reaching out to your accountant for their expertise.  If you don't have an accountant, we can help you locate a ProAdvisor in your local area.

 

Feel free to reach out again if you have other questions or concerns.  We'd be glad to help!

mbell19
Level 3

How do I write off an unpaid invoice?

What are the steps to do this if you do not use the Products/Services portion for invoicing? Meaning that when I'm on the credit memo screen, I cannot choose a product/service as the option to do so isn't there. 

 

I have the bad debt expense in my chart of accounts already.

But I cannot find a place on the credit memo to tie that to this customer's account so that I can clear the $187 portion of the invoice they did not pay, and move it to bad debt expense.

 

FWIW, we are cash basis and I'm using QBO. 

Thank you.

DebSheenD
QuickBooks Team

How do I write off an unpaid invoice?

Hello there, @mbell19.

 

Allow me to jump in and help you write off bad debt in QuickBooks Online (QBO).

 

There are different options on how to close an open invoice, however, the process depends on the scenarios.
 

First, once an invoice becomes non-collectible, you'll need to write it off and declare it as a bad debt to clear the invoice out of your accounts receivable and reduce your net profit by its amount. 

Here's how:

Create a bad debts expense account. 

 

  1. Click the gear icon
  2. Choose Chart of accounts.
  3. From the Account type dropdown, hit Bad debts.
  4. In the Name field, enter Bad debts.
  5. Tap Save and Close.


Then, create a bad debt item.
 

  1. Tap the gear icon.
  2. Choose Products and Services.
  3. At the upper right, hit New, and then Non-inventory.
  4. In the Name field, enter Bad debts.
  5. Tick Save and Close.


After that, create a credit memo for the bad debt.

 

  1. Hit +New.
  2. Tap Credit memo.
  3. Choose the customer from the Customer dropdown.
  4. In the Product/Service section, click 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. Tick Save and close.


Lastly, apply the credit memo to the invoice.
 

  1. Choose +New.
  2. Under Customers, tap Receive payment.
  3. From the Customer dropdown, select the customer.
  4. From the Outstanding Transactions section, tap the invoice.
  5. Find the Credits section, and click the credit memo.
  6. Hit Save and close.

 

You can check this article for detailed steps on how to write off bad debt.

 

Once done, you can now run the Accounts Receivable Aging report again. See this article, for more information: How to get your Aging Reports to match.
 

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

 

I also recommend consulting an accountant if you’re not familiar with the process to ensure your books are accurate.

 

Please know that I'm just a post away if you have any other concerns about the Invoice in QBO. Wishing you and your business continued success. 

mbell19
Level 3

How do I write off an unpaid invoice?

I’m sorry, but you did not fully read my question. We do not use the products & services option on our billing, therefore, I cannot use that method. 

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

Need to get in touch?

Contact us