How to Account for Bad Debts and Record it in Quickbooks Online and Desktop (2024)

One of the more unpleasant aspects of being a business owner is having to chase clients that do not pay. It is frustrating, stressful and disheartening, while attempts to collect are an unproductive use of time and can have a significant impact on cash flow, particularly if you are unprepared. A bad debt, in accounting terms, refers to an amount charged to a customer that is never paid. While the original sale would have been reflected as revenue, the uncollectible bad debt would then have to be written off as a separate line item on the profit and loss statement

A bad debt may occur for several reasons:

  • The customer has experienced financial difficulty or worse, they have filed for bankruptcy or creditor protection

  • Your client feels that the invoice amount is to high for the services rendered and therefore was only willing to pay a part of the invoice.

  • Your customer has become non responsive despite efforts to contact them and you feel that it is not longer worth trying to collect

There are ways to mitigate the possibility and impact of bad debts. Some of these include:

Regardless of your efforts to prevent them, incurring bad debts is usually inevitable and ultimately, a cost of doing business. Consequently, it is important to ensure that you are prepared.

Designate an Amount to reserve for bad debts (before you incur them):

Setting up a reserve for bad debts is an excellent way to prepare for them if and when they happen. It allows the business owner to show bad debts in small increments on their profit-loss and smooth out the effects rather than taking one big hit when they actually occur. In accounting parlance this is referred to as an Allowance for Doubtful Accounts (somewhat self explanatory) or AFDA. There are two ways to do this:

  1. You can designate a percentage of your accounts receivable as uncollectible based on experience or the quality of your accounts receivable.

  2. Periodically review your accounts receivable and specifically identify which amounts due might not be collectible. These can be enumerated in a schedule and written off right away or at the end of the year. The total of these amounts will represent your bad debts.

Set up a Reserve:

Once the amount of bad debts has been calculated, you should reflect it on your books. Since the bad debts are an expense it will reduce your net income for the period. The corresponding credit will be applied to a separate account called Allowance for Doubtful Accounts which reduces your accounts receivable.

what is the journal entry for a Bad Debt:

The journal entry for a specifically identified bad debt expense is:

Debit: Bad Debt Expense

Credit: Accounts receivable (for the specific customer for who the bad debt was incurred)

The journal entry for an allowance for bad debts is:

Debit: Bad Debt Expense

Credit: Provision or Allowance for Bad Debts (this is a negative or contra account that is shown right under the accounts receivable on your balance sheet)

The journal entry when you want to move a bad debt from the provision and take it off your accounts receivable listing:

Debit: Provision or Allowance for Bad Debts

Credit: Accounts receivable (for the specific customer for who the bad debt was incurred)

Since you have already set up the bad debt expense with the provision, it would only be a balance sheet entry.

How to Reflect AFDA and Bad Debts in Quickbooks desktop:

  1. Set up a new Accounts Receivable accounts called Allowance for Doubtful Accounts (AFDA)

  2. Set up a new expense account called Bad Debts expense

  3. Set up a new Customer called AFDA

  4. Setup a new item called Bad Debts and select Bad Debts expense as the account.

  5. Create an invoice credit note for the estimated amount of the bad debts with AFDA as the customer and Bad Debts as the item.

  6. When specific customers are deemed uncollectible, write off the amounts by creating a credit note for the specific customer and select bad debt expense.

  7. Reduce your allowance either via a period end adjustment or create an invoice for the exact amount of the bad debt written off in #6 following the steps in #5. Since the bad debt has already been provided for, this will not impact on your bottom line

How to Reflect specific Bad Debts in Quickbooks online:

The initial entry in QBO when you make a sale to a customer would have been to record an invoice for the amount owing by the customer which would then be reflected on the accounts receivable report. In accounting parlance there would be a credit to sales and a debit to accounts receivable. Any payments would be offset against the invoice by “receiving payment” in the invoice module in QBO. To write off the full invoice or the balance of the amount owing for a customer:

  1. Go to the + sign on the top left corner

  2. Under customers select “credit memo”

  3. Select the customer for whom you want to write off a balance

  4. Select the date (note if you want to do it before a period or year end, then this date should be selected so that it is reflected on the profit loss)

  5. Under “product/service”, type in “Bad Debt”. You will be prompted to create a new item. You can select non inventory product or service here.

  6. Under “income account” you would add a new account called “Bad Debt” which is “expense” account. The detailed type is bad debts.

  7. You can then add a sales tax code if you have the same sales tax code for all customers or leave it blank and enter it manually if your sales tax code varies by customer

  8. All other fields are optional and can be completed if desired.

  9. Once the product/service item and the chart of accounts account has been set up as Bad Debt, this will be available going forward for any future bad debts.

  10. Enter the amount and sales tax code that applies to the specific customer.

  11. You can then save and close.

  12. Go to the profit-loss report and verify that the write off shows up in the bad debt section

Monitor your Reserves:

Depending on the size and number of accounts receivables, you should review your bad debt expense regularly. It helps to maintain a schedule which can be reviewed and updated.

Cash Flow and Tax Implications:

  • It is important to reflect a reserve for bad debts in your cash flow forecasts and budget. This will allow for you to contemplate other options in advance.

  • When specific bad debts are recorded in your books, make sure to reflect the sales tax impact. i.e. if your invoice included sales tax, make sure that it is reversed, so that you can recover sales taxes that were never actually received from your customer/client.

  • Reserves for bad debts (AFDA) are not tax deductible and need to be added back to net income when preparing your Federal tax return.(T2). It is only when specific invoices are written off that they become deductible.

In a perfect world customers would pay their debts on time. The unfortunate reality is that this does not always happen, for a variety of reasons, some uncontrollable. Ensuring that you are prepared can help reduce stress and lead to better business decisions .

Ronika Khanna is an accounting and finance professional who helps small businesses achieve their financial goals. She is the author of several books for small businesses and also provides financial consulting services.

Subscribe to our biweekly newsletter to receive articles, tips, tools and special offers for small businesses.

How to Account for Bad Debts and Record it in Quickbooks Online and Desktop (2024)

FAQs

How to Account for Bad Debts and Record it in Quickbooks Online and Desktop? ›

Create a bad debt expense account

From the Account Type ▼ dropdown, select Expenses. From the Detail Type ▼ dropdown, select Bad debts. In the Name field, enter “Bad debts.” Select Save and close.

How do you account for Bad debts in QBO? ›

Create a bad debt expense account

From the Account Type ▼ dropdown, select Expenses. From the Detail Type ▼ dropdown, select Bad debts. In the Name field, enter “Bad debts.” Select Save and close.

How do I record bad debt expense in Quickbooks desktop? ›

Step 1: Add an expense account to track the bad debt
  1. Go to the Lists menu and select Chart of Accounts.
  2. Select the Account menu and then New.
  3. Select Expense, then Continue.
  4. Enter an Account Name, for example, Bad Debt.
  5. Select Save and Close.

What type of account is allowance for Bad debts in Quickbooks? ›

The allowance for doubtful accounts, aka bad debt reserves, is recorded as a contra asset account under the accounts receivable account on a company's balance sheet. It's a contra asset because it's either valued at zero or has a credit balance.

How do you account for bad debt in accounting? ›

Bad debt is debt that cannot be collected. It is a part of operating a business if that company allows customers to use credit for purchases. Bad debt is accounted for by crediting a contra asset account and debiting a bad expense account, which reduces the accounts receivable.

What is the journal entry for bad debts? ›

Record the journal entry by debiting bad debt expense and crediting allowance for doubtful accounts. When you decide to write off an account, debit allowance for doubtful accounts and credit the corresponding receivables account.

What is the accounting method to account for a bad debt? ›

There are two different methods used to recognize bad debt expense. Using the direct write-off method, uncollectible accounts are written off directly to expense as they become uncollectible. On the other hand, the allowance method accrues an estimate that gets continually revised.

What are the two methods used to account for bad debts? ›

Bad debt can be reported on financial statements using the direct write-off method or the allowance method. The amount of bad debt expense can be estimated using the accounts receivable aging method or the percentage sales method.

Is bad debt an expense or income? ›

Bad debt is basically an expense for the company, recorded under the heading of sales and general administrative expenses. But the bad debt provision account is recorded as a contra-asset on the balance sheet.

How is bad debt recorded? ›

Bad debt expense or BDE is an accounting entry that lists the dollar amount of receivables your company does not expect to collect. It reduces the receivables on your balance sheet. Accountants record bad debt as an expense under Sales, General, and Administrative expenses (SG&A) on the income statement.

How do you record allowance for bad debts? ›

You record the allowance for doubtful accounts by debiting the Bad Debt Expense account and crediting the Allowance for Doubtful Accounts account. You'll notice the allowance account has a natural credit balance and will increase when credited.

What account type is allowance for bad debts? ›

An allowance for doubtful accounts is considered a “contra asset,” because it reduces the amount of an asset, in this case the accounts receivable. The allowance, sometimes called a bad debt reserve, represents management's estimate of the amount of accounts receivable that will not be paid by customers.

What is the allowance method for accounting for bad debts? ›

The allowance method is an estimate of the amount the company expects will be uncollectible made by debiting bad debt expense and crediting allowance for uncollectible accounts. If a specific account becomes uncollectible, it will debit allowance for doubtful accounts and credit accounts receivable.

How do you record a bad debt in QuickBooks? ›

In the Product/Service section, select Bad debts. In the Amount column, enter the amount you want to write off. In the Message displayed on statement box, enter “Bad Debt.” Select Save and Close.

How do you account for bad debt on P&L? ›

After applying credit memos to unpaid invoices, the bad debt showed up as negative 'Service Income Revenue' which is the top level revenue category. The original invoices appear as paid with positive revenue in a P&L revenue subcategory.

Which account should be credited for bad debts? ›

When there is a bad debt, you will credit debtors account and debit allowance for doubtful accounts.

What to do with unpaid invoices in QuickBooks? ›

Write off (A/R), old unpaid invoices
  1. Go to the + New icon and select Credit memo.
  2. Choose the customer from the Customer ▼ dropdown.
  3. In the Product/Service section, select Bad Debts.
  4. Under the Amount column, enter the remaining balance to write off.
  5. In the Message displayed on statement box, enter “Bad Debt.”
Dec 4, 2023

How do I record a failed payment in QBO? ›

Here's how:
  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click the + New button, then select Journal Entry.
  3. Make sure the Date, Entry No, and Vendor name are correct.
  4. Debit the checking account for the amount of the returned payment.
  5. Credit the A/P account for the amount of the returned payment.
  6. Click Save & Close.
Nov 15, 2022

Top Articles
Latest Posts
Article information

Author: Dr. Pierre Goyette

Last Updated:

Views: 6371

Rating: 5 / 5 (70 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Dr. Pierre Goyette

Birthday: 1998-01-29

Address: Apt. 611 3357 Yong Plain, West Audra, IL 70053

Phone: +5819954278378

Job: Construction Director

Hobby: Embroidery, Creative writing, Shopping, Driving, Stand-up comedy, Coffee roasting, Scrapbooking

Introduction: My name is Dr. Pierre Goyette, I am a enchanting, powerful, jolly, rich, graceful, colorful, zany person who loves writing and wants to share my knowledge and understanding with you.