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? ›

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 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 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.

What is the correct account type for bad debt expense? ›

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.

What is the journal entry for bad debt expense? ›

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 treatment for bad debt? ›

When a sale is made an estimated amount is recorded as a bad debt and is debited to the bad debt expense account and credited to allowance for doubtful accounts. When organisations want to write off the bad debt, the allowance for doubtful accounts is debited and accounts receivable account is credited.

How do you record bad debt in accounting? ›

To record the bad debt entry in your books, debit your Bad Debts Expense account and credit your Accounts Receivable account. To record the bad debt recovery transaction, debit your Accounts Receivable account and credit your Bad Debts Expense account. Next, record the bad debt recovery transaction as income.

Where does bad debt expense go on P&L? ›

Accountants record bad debt as an expense under Sales, General, and Administrative expenses (SG&A) on the income statement.

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.

When to record bad debt expenses? ›

Note: Recording a bad debt expense is only needed if you work with accrual accounting. If you use cash accounting, you won't have an entry for the collectible amount because you never received payment. Unfortunately, it still creates a problem for cash flow.

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.

What are the accounting terms for bad debt? ›

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 double entry for doubtful debt? ›

The double entry for a bad debt will be:

We debit the bad debt expense account, we don't debit sales to remove the sale. The sale was still made but we need to show the expense of not getting paid. We then credit trade receivables to remove the asset of someone owing us money.

Is bad debt expense a liability or expense? ›

Bad debt is considered an expense which offsets assets in business's accounts receivable, also known as the net realizable value of the accounts receivable. The expense is recorded according to the matching principle so that accounts receivable assets are not overstated.

Where should bad debt expense be on an income statement? ›

Accountants record bad debt as an expense under Sales, General, and Administrative expenses (SG&A) on the income statement.

How to write off bad debts? ›

When money owed to you becomes a bad debt, you need to write it off. Writing it off means adjusting your books to represent the real amounts of your current accounts. To write off bad debt, you need to remove it from the amount in your accounts receivable. Your business balance sheet will be affected by bad debt.

Top Articles
A Smart Trick for Reheating Leftover Pancakes
WireGuard
123Movies Encanto
Nehemiah 4:1–23
Chatiw.ib
Marist Dining Hall Menu
Victoria Secret Comenity Easy Pay
Bed Bath And Body Works Hiring
U.S. Nuclear Weapons Complex: Y-12 and Oak Ridge National Laboratory…
Animal Eye Clinic Huntersville Nc
Are They Not Beautiful Wowhead
Blackwolf Run Pro Shop
E22 Ultipro Desktop Version
U Break It Near Me
Bridge.trihealth
Erica Banks Net Worth | Boyfriend
Walgreens Alma School And Dynamite
Transactions (zipForm Edition) | Lone Wolf | Real Estate Forms Software
Company History - Horizon NJ Health
Yosemite Sam Hood Ornament
Scripchat Gratis
Bolly2Tolly Maari 2
Cona Physical Therapy
Lbrands Login Aces
Miles City Montana Craigslist
Mastering Serpentine Belt Replacement: A Step-by-Step Guide | The Motor Guy
Poe T4 Aisling
APUSH Unit 6 Practice DBQ Prompt Answers & Feedback | AP US History Class Notes | Fiveable
Chadrad Swap Shop
60 Second Burger Run Unblocked
Tra.mypatients Folio
Bus Dublin : guide complet, tarifs et infos pratiques en 2024 !
Where Do They Sell Menudo Near Me
Crystal Mcbooty
Imperialism Flocabulary Quiz Answers
Evil Dead Rise (2023) | Film, Trailer, Kritik
Prior Authorization Requirements for Health Insurance Marketplace
511Pa
What to Do at The 2024 Charlotte International Arts Festival | Queen City Nerve
John M. Oakey & Son Funeral Home And Crematory Obituaries
Stosh's Kolaches Photos
R/Gnv
25 Hotels TRULY CLOSEST to Woollett Aquatics Center, Irvine, CA
Automatic Vehicle Accident Detection and Messageing System – IJERT
Marine Forecast Sandy Hook To Manasquan Inlet
Concentrix + Webhelp devient Concentrix
Uno Grade Scale
Okta Hendrick Login
Strange World Showtimes Near Century Federal Way
라이키 유출
Latest Posts
Article information

Author: Velia Krajcik

Last Updated:

Views: 6192

Rating: 4.3 / 5 (74 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Velia Krajcik

Birthday: 1996-07-27

Address: 520 Balistreri Mount, South Armand, OR 60528

Phone: +466880739437

Job: Future Retail Associate

Hobby: Polo, Scouting, Worldbuilding, Cosplaying, Photography, Rowing, Nordic skating

Introduction: My name is Velia Krajcik, I am a handsome, clean, lucky, gleaming, magnificent, proud, glorious person who loves writing and wants to share my knowledge and understanding with you.