How to Write off an Invoice in QuickBooks Desktop & Online?

When customers fail to pay their bills, companies must write off their invoices or debts. When all other attempts to […]

Voiced by Amazon Polly

When customers fail to pay their bills, companies must write off their invoices or debts. When all other attempts to recover the funds have failed, the only option left is to write off the invoice as a bad debt. Users can use Accountant Tools to write off their invoices, and the methods outlined here will assist you in doing so. Know how to write off an Invoice in QuickBooks.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.

For many businesses, unpaid invoices are a sad reality. The majority of customers enter into a business relationship with the intention of paying in whole and on time, but occasionally they are unable to do so. And sometimes they are completely unable to make a payment. In such a case, it is important to write off the uncollectible invoice. You can remove unpaid invoice amounts from your accounting records in a number of methods.

In this article, you get to know about Accountant Tools, which is nothing more than a collection of distinct characteristics. Accountant Tools provide features that make it simple to analyze and manage financial data for your customers, as well as shortcuts to useful QuickBooks Online sections. The Accountant Toolbox is used in the same way in your employer’s QuickBooks Online Accountant Company as it is in your client’s QuickBooks Online Accountant Company.

What are the Reasons to Write off an Invoice?

For the following reasons you might want to write off an invoice in QuickBooks:

  • Bad Debt: A customer may occasionally be unable to pay an invoice because of uncontrollable financial conditions. Customer chooses not to pay for other reasons occur less frequently. In either case, it’s important to correctly record a customer’s payment default in your books by writing off the invoice.
  • Underpayment: Perhaps your customer has already made a payment on your invoice, but there is still a balance owed. This is usually the result of a customer’s end clerical error. When there is an underpayment, the amount is frequently too tiny – sometimes only a few pennies – to justify asking the customer for the balance.

What are the Mistakes to Avoid?

You might believe that deleting an invoice is the simplest way to write off an Invoice in QuickBooks. Avoid doing this. The effects of deleting the invoice as opposed to correctly writing it off on your business’s bookkeeping include the following:

  • You Lose Valuable Information: In order to avoid selling to that customer again on credit, you should keep track of any invoices you write off for customers owing to bad debt. You will lose this information if you delete the invoice. The percentage of invoices you write off should also be known to you. You may manage your business more profitably and effectively by using this useful business metric.
  • The Deleted Invoice’s Items will be Listed as Unbilled: All the items on an invoice that is deleted in QuickBooks will appear as unbilled. These items will appear every time you try to invoice the customer whose invoice you wrote off if you keep doing business with them, confusing and cluttering your books.
  • You Lose Valuable Information: In order to avoid selling to that customer again on credit, you should keep track of any invoices you write off for customers owing to bad debt. You will lose this information if you delete the invoice. The percentage of bills you write off should also be known to you. You may manage your business more profitably and effectively by using this useful business metric.

If You are a Cash Basic Taxpayer

From a tax viewpoint, you don’t actually have accounts receivable if you are a cash basis taxpayer. If you invoice customers, you must still keep track of your accounts receivable. Modified cash basis accounting is what this is.

If you are a cash basis taxpayer, some Accountants and Bookkeepers would suggest that you simply eliminate bad debt invoices. Others would recommend you issue a credit memo instead of employing a bad debt expense item, which will result in a decrease in your overall sales for that item. The same issues outlined in the previous section can be brought on by either of these ways. Even if you file on a cash basis, you should appropriately write down your bills to maintain the integrity of your QuickBooks file.

What is the Process to Write off an Invoice in QuickBooks?

  • Open the QuickBooks account
  • Then open the Toolbox that has \uD83D\uDCBC
  • Now select the option Write off Invoices
  • Mention the details like Balance due less than, To Date, and Age
  • Apply the filters according to the invoice that you want to search
  • After this, click on the Refresh button to get the fresh list according to the applied filters
  • Choose invoices by tick mark the checkbox that you want to write off in QuickBooks
  • In the Write off the account, you have to choose the account from the drop-down menu that you are using for the bad debts
  • Review the things by clicking on the Preview option
  • Then click on the Write Off option
  • You have to analyze the invoices that you have selected to write off
  • After all, is done, click on the Write Off that starts the process to write off an invoice in QuickBooks
  • When done click on the Close button.

What to do to Write-Off Unpaid Invoice in QuickBooks

Balances that you can’t claim on accounts receivable can be handled in QuickBooks. Unpaid invoices can also be written off, and below are several methods for doing so and later declaring their bad debts. It signifies that a customer owes you money but you are unable to collect it due to a variety of circumstances. You owe them money, but you know you’re not going to get paid. If your business follows the accrual accounting approach, you can readily deduct bad debt.

How to Write off an Invoice in QuickBooks Online?

Using the credit memo tool is the most effective way to write off an invoice in QuickBooks, whether you are using QuickBooks Desktop or QuickBooks Online. Your Sales Tax Liability Account will remain spotless if you use a credit memo with a bad debt expenditure item, so you won’t ever need to be concerned about paying too much in sales tax.

1. Open the Invoice You are Writing Off

As you carry out the ensuing stages, you should refer to the invoice. To find the invoice you have to follow the below steps:

  • You have to click on Sales.
  • Select Customers.
  • To open an invoice, enter the customer’s name and select it from the list.
Open the Invoice you are Writing Off
Open the Invoice you are Writing Off

2. Create a New Credit Memo

  • Right-click the browser tab to duplicate it. This enables you to compare the credit memo and the original invoice side by side.
  • To start a new transaction, click the + New button on the new tab.
  • From the drop-down menu that opens, choose Credit Memo.
Create a new credit memo
Create a new credit memo

3. For the Credit Memo you have to Enter Identifying Information

Type in the name of your customer and the day you are writing off the bad debt. You will see that QuickBooks enters a credit memo number automatically. As updating this could cause issues with your invoice and credit memo numbering in the future, it is advised against doing so.

credit memo you have to enter identifying information
credit memo you have to enter identifying information

4. Create the Bad Debt Expense Item

You can quickly enter Items in both QuickBooks Desktop and QuickBooks Online. If your item drop-down list doesn’t already include a bad debt expense item, you should add one.

  • Click Add new after entering the Product/Service form.
  • Select the Service product category.
  • The item is called Bad Debt.
  • For the income account type, select your bad debt expense account.
  • Make the nontaxable sales tax category the default. This can be changed for each credit memo separately.
Create the bad debt expense item
Create the bad debt expense item

5. Fill out the Credit Memo

You effectively duplicate the invoice you are writing off on the Credit Memo screen at this stage. However, you will use the bad debt item you created in the previous step rather than the original good/service/item you used in the invoice. As you proceed, be sure to mark anything as taxable. If the amount on your credit memo matches the amount still owed on the invoice you are writing off, you have done it correctly.

Your credit memo requires only one line with the term bad debt if the invoice you are writing off contains all taxable items or only nontaxable items. On this line, enter the entire, pretax amount of the invoice you are writing off. If the invoice contained sales tax, add it to the credit memo at that point.

Fill out the credit memo
Fill out the credit memo

6. Apply the Credit Memo to the Invoice

Your accounts receivable balance will remain accurate if you skip this step, but the invoice for which you created the credit memo will continue to show up on your Open Invoice report.

  • To write off an invoice, click it.
  • Then select Receive Payment.
  • You can choose to include the outstanding credit memo in your payment on the next screen. After applying the credit memo, the payment should be in the amount of $0 only. Your check register will reflect a $0 transaction as a result, which you can remove the following time you Reconcile Your Bank Account.

Overstated Income Problem

The invoice will show as paid when the credit memo is applied when you write off an invoice in the way described above. This indicates that the amount of the invoice will be added to your income on your cash basic profit and loss statement. On the other hand, there will also be an offsetting amount in the bad debt expense account, thus the impact on your net income will be zero.

This is sufficient in most of the states to prevent you from paying more income tax than necessary. However, if your state levies a gross receipts tax, you must make sure your accountant subtracts the amount of the bad debt charge from your overall revenue before you file your tax return. If not, you will be taxed on money that you never made.

Small Amount Write-offs

You will use the same method described above if you are writing off the remaining balance on an invoice that has been largely paid. Since small amount write-offs are uncommon and normally do not add up to a sizable dollar amount over the course of the year, using an expenditure account other than bad debt expense for this could complicate your Chart of Accounts and is unnecessary.

Write-offs: The Right Way to Record Bad Debt

You can eliminate bad debt and other uncollectible sums from your accounting records in a number of ways. The procedure described above will help you in maintaining your records and provide you with important managerial information, even if it is more time-consuming than simply erasing the invoice or issuing a credit memo that reverses the charge. This means that you may use your financial statements to manage your business profitably and successfully while also giving your tax expert the data they require to complete your tax return efficiently.

How to Write off Invoices in QuickBooks Desktop?

With the Customers menu in QuickBooks Desktop, writing off invoices is simple. You are able to add bad debt. The item may be brought up in regard to the debt. It could be added to the bill. That invoice needs to be marked as unpaid later. Please make sure that all the data are accurately added as you learn how to write off invoices in QuickBooks Desktop.

  • Start your computer’s QuickBooks Desktop software.
  • Then you have to go to the Customers tab in the top menu bar.
  • Select Customer Center from the menu.
  • Add the customer’s name on the left when the new window starts.
  • Select the invoice from the list of options.
  • Go back to the top and select the Customers tab once more.
  • Choose to Create Credit Memo/Refunds from the menu.
  • Enter the customer’s name when the Credit Memo window appears. Include the deadline for writing off the invoice as well. The credit memo number will automatically fill in as a result.
  • Now select Item and then Bad Debt from the menu that appears.
  • Next, select Add New from the menu.
  • Choose Other charges as the category.
  • Next, select Bad debt by clicking on the Item button.
  • Use the Bad debt you produced as an item to add a new product.
  • At this point, uncheck the Is Taxable option.
  • To save and close, click the button.
  • Mention the pretext amount of the unpaid or problematic debt here.
  • Select the bill you want to write off.
  • Then you have to choose the top option marked Use credit to apply to the invoice.
  • Select Save and Close from the menu.

In the above article, you get to know how to write off an invoice in QuickBooks. The process is mentioned in detail with correct steps that you have to follow properly. This way you won’t face any issues whenever you write off the invoices into your QuickBooks account. Still, if you are facing any glitches then connect with the Dancing Numbers helpdesk team. As they are available 365 days a year to help you with all your queries and issues by assisting you in the best way possible.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Frequently Asked Questions (Faqs)

In QuickBooks Online, Can we Write off an Invoice?

Both QuickBooks Desktop and QuickBooks Online allow you to write off an invoice. The only steps required for the online version are to add the item as a bad debt, create a customer, and write off the invoice.

When should Unpaid Invoices be Written off in QuickBooks?

Customers frequently fail to provide you with the money they owe you. In that case, you ought to write off the customer invoice you made. By doing this, you will avoid having to pay sales tax and save the customer and product data at the same time.

How may an Invoice be Written off in QuickBooks?

Despite the fact that you can write off the bills manually, using the Write off Invoices Tool easier the process. Keep in mind that only QuickBooks Online Accountant users have access to this function. Open the Accountant Tools and select Write off Invoices to use this function. Apply the date, invoice age, and balance filters next, then click Find Invoices. Consider the customer’s name before selecting the bills you want to write off. Remember to select the account you use for bad debts.

What are the Steps to Check the Aging Account Receivable before writing off an invoice in QuickBooks?

In QuickBooks, click on the Report menu option
Locate and then open the report of Accounts receivable Aging Detail
Now, check that which Account Receivable is outstanding and you have to write off.

How can I do a Bad Debt Entity apart from the other Customers after Writing off an Invoice in QuickBooks?

In QuickBooks, click on the Sales menu option
Further, select the option Customers
Click on the Edit option that is at the top right side of the screen
Mention the Bad Debt or No Credit in the field of Display name as (It shows after the name of the customer.)
In the end, click on the Save option.

Is it Important to Create an Account to Write off an Invoice in QuickBooks?

Yes, it is important as you have to show the entry for how you have written off the invoice. The type of account must be an expense that you named as bad debt.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Close X
Call Now+1-800-596-0806
Top