top of page

How to Write Off an Invoice in QuickBooks Online?

  • Writer: Cost Construction Accounting
    Cost Construction Accounting
  • Jan 7, 2021
  • 4 min read

Updated: Oct 23

As a business owner, you might face an unfortunate reality uncollectible invoices. Despite your best efforts to retrieve the money, sometimes customers simply cannot pay or refuse to pay altogether. When this happens, writing off these uncollectible invoices becomes necessary to maintain accurate financial records. In this guide, we'll walk you through the complete process of writing off an invoice in QuickBooks Online with clear, practical instructions.

ree

Table of Content:

Understanding Invoices in QuickBooks

QuickBooks Online offers a versatile invoicing system designed to meet diverse business needs. Whether you're creating standard service invoices or managing more complex billing formats, the platform handles it all. However, even with the best collection practices, some invoices inevitably become uncollectible and begin piling up in your accounts receivable. Learning how to properly write off these amounts is essential for keeping your financial statements accurate and making informed business decisions.

Preparing to Write Off an Invoice

Before you proceed with writing off an invoice, it's crucial to ensure you've made the right decision. This isn't a step to take lightly, as it directly impacts your business's financial records. Ask yourself these important questions:

  • Have you exhausted all reasonable collection efforts, including phone calls, emails, and formal notices?

  • Has sufficient time passed since the invoice became overdue? Most businesses typically wait 90 to 180 days before considering a write-off.

  • Is the debt truly irrecoverable, or is there still a reasonable chance of payment?

  • Have you documented all your collection attempts for tax and audit purposes?

Once you've determined that a write-off is necessary, take a moment to back up your QuickBooks data. This precautionary step protects you from any unintended changes during the write-off process.

Setting Up Your Bad Debt Expense Account

Before you can write off any invoices, you'll need a dedicated account to track these losses. If you haven't already created a Bad Debt Expense account, here's how to set one up:

  1. Click the Settings gear icon and select Chart of Accounts

  2. Click New to create a new account

  3. Choose Expenses as the account type

  4. Select Bad Debts as the detail type

  5. Name the account "Bad Debt Expense" for clarity

  6. Click Save and Close

With this account in place, you're ready to begin the write-off process. This dedicated account will help you track all uncollectible invoices in one location, making it easier to monitor patterns and assess the impact on your bottom line.

Step-by-Step Guide to Writing Off an Invoice

Now that you've prepared your account structure, let's walk through the actual write-off process. We'll use the credit memo method, which is the cleanest and most professional approach in QuickBooks Online.

Step 1: Create a Bad Debt Item

First, create a service item that links write-offs to your Bad Debt Expense account:

  1. Go to Settings > Products and Services

  2. Click New > Service

  3. Name it "Bad Debt"

  4. Set Income account to your Bad Debt Expense account

  5. Leave price at $0

  6. Click Save and Close

Step 2: Find the Invoice

Locate the invoice you need to write off:

  1. Click Sales > Invoices

  2. Find the uncollectible invoice

  3. Open it to review the details

  4. Note the invoice number and amount

Step 3: Create a Credit Memo

Now create a credit memo to cancel out the unpaid invoice:

  1. Click +New > Credit Memo (under Customers)

  2. Select the same customer from the original invoice

  3. Choose your "Bad Debt" item in the Product/Service column

  4. Enter the full unpaid amount

  5. Add a memo note (e.g., "Write-off Invoice 1001 - uncollectible")

  6. Click Save and Close

Step 4: Apply the Credit Memo

Finally, link the credit memo to the invoice:

  1. Go to Sales > Invoices

  2. Open the unpaid invoice

  3. Click Receive Payment

  4. Check the box next to the credit memo to apply it

  5. Verify the payment amount shows zero

  6. Click Save and Close

The invoice is now closed, and the bad debt has been recorded as an expense.

Verify the Write-Off

After completing the write-off, confirm everything is correct:

Check Accounts Receivable: Open the Accounts Receivable Aging Summary report to confirm the invoice no longer appears and your A/R balance decreased by the write-off amount.

Review Financial Statements: Check your Profit and Loss to see the bad debt expense, and verify your Balance Sheet shows the reduced accounts receivable.

Document the Write-Off: Record the invoice date and number, customer name, write-off amount and date, reason for write-off, and collection efforts made. Keep this documentation for tax purposes and future reference.

Common Issues and Solutions

Even when following these steps carefully, you might encounter a few hiccups. Here are the most common issues and their solutions to help you resolve them quickly.

  • Credit Memo Won't Apply: Verify the credit memo is for the same customer, hasn't been applied elsewhere, and doesn't exceed the invoice balance. Try refreshing your browser if issues persist.

  • Invoice Still Shows Unpaid: Creating a credit memo doesn't automatically apply it. You must go to the invoice, click Receive Payment, and check the box to apply the credit memo.

  • Bad Debt in Wrong Account: Edit your Bad Debt item in Settings > Products and Services and ensure the Income account is set to Bad Debt Expense. You may need to recreate the credit memo.

Conclusion

Writing off an invoice in QuickBooks Online doesn't have to be complicated. By following this systematic approach setting up the right accounts, creating the necessary items, and carefully applying, credit memos, you can maintain accurate financial records while properly accounting for uncollectible debts.

Remember that every write-off tells you something important about your business. While nobody likes dealing with bad debt, tracking these losses helps you identify patterns, adjust your credit policies, and make smarter decisions about extending credit in the future. The key is to be thorough in your collection efforts, careful in your documentation, and consistent in your accounting practices.

For busy Contractors in the construction industry, managing these complex accounting tasks can be overwhelming. That's where Construction Cost Accounting (CCA) steps in. We specialize in providing comprehensive outsourced financial services, including QuickBooks support so you can focus on building your projects.

ree

bottom of page