Bad debts refer to the amount of money that is irrecoverable from your debtor. It is the money that generally your customer or someone you lent but can’t recover now due to circumstances. It is a loss for a business and should go on the debit side of the profit and loss statement. It is very important to write off bad debts in QuickBooks so that the user knows the true position of the business. The money that your debtors owe is an asset for you and thus, not writing off bad debts will show the asset side inflated. The steps to write off Bad debts in QuickBooks Desktop are different from the Online version.
Writing off bad debt in QuickBooks is quite simple. However, issues while locating invoices to write off and unexpected errors can arise at times. In that case, you can contact Asquare Cloud Hosting’s expert team at +1-(855)-738-0359 for immediate assistance
How to Find Bad Debts in QuickBooks?
The very first step to writing off bad debts is to identify them, which is quite easy in QuickBooks. You can access the Account Receivable Ageing Detail Report in QuickBooks for an overview of your customer’s unpaid invoices, outstanding balances, due amounts, and the time past the due date. Following are the instructions to get the Account Receivable Ageing Detail Report in QuickBooks Desktop and Online.
For QuickBooks Online
- Firstly, go to the Reports tab in QuickBooks Online and select Who Owes You.
- Now select the Accounts Receivable Ageing Summary Detail option.
- Now, you will need to customize the report to see how long each transaction is past due.
- Choose Customize and select the Past Due checkbox in the Rows/Columns section.
- Lastly, hit Run Report to conclude.
For QuickBooks Desktop
- In the top menu bar, select Reports.
- Choose the Customers and Receivables option and select Transaction List by Customer.
- Hit the Customize option.
- Now, for the columns and account type, select the Display and Filters option.
- Lastly, click OK, and you will be able to see the latest and aging customer balances.
Now that you have figured out the outstanding Accounts Receivable balances let’s move forward and find out how to write off any bad debt you find.
How to Write off Bad Debts in QuickBooks Desktop
A new account is required to be created to write off bad debts in QuickBooks Desktop. It has to be an expense account that can be used to manage all the bad debts that occur in business. It is a two-step process:-
As a first step, we will create an account in QuickBooks that will be used to track bad debts.
- Go to the Lists menu and choose the Chart of Accounts.
- Now go to the Account menu and click on New.
- Select Expense and then tap on Continue.
- Type in the Account Name by which you want to save it, such as Bad Debt.
- Click on Save and Close
Step 2: Clear Unpaid Invoices
- Go to the Customers menu and tap on Receive Payments.
- Type in the customer’s name in the Received from section.
- Go to Payment Amount and enter $0.00.
- Now click on Discount and Credits.
- Enter the amount you wish to write off in the Amount of Discount field.
- Choose the account you created in step 1 for Discount Account and tap on Done.
- Click on Save and Close.
Method to Record Bad Debt in QuickBooks Online
The process of recording bad debt in QuickBooks Online requires you to set up a separate expense account. This account can be used to record bad debts that occur in the user’s business. Then you would be required to create a bad debt item. These are the steps you need to follow:-
Step 1:- Set up an Expense Account for Bad Debts
If you don’t already have a bad debts expense account, follow the instructions below and create one.
- Tap on the Settings button and choose the Chart of Accounts.
- Click on New in the upper right corner.
- Go to the Account Type list and choose Expenses.
- Then go to the Detail Type list and choose Bad Debts.
- Enter the name by which you want to save this account in the Name field. Example: Bad Debts.
- Lastly, tap on Save and Close to conclude.
Step 2: Create an item for Bad Debt
Before following this step below, you will need to create a non-inventory item to use as a placeholder for bad debts. The item you are creating is not real and is only created to balance the accounting.
- Click on the Settings button and choose Product and Services.
- Click on New in the upper right corner and then tap on Non-Inventory.
- Enter Bad Debts in the Name Field.
- Go to the Income account list and choose Bad debts.
- Tap on Save and Close.
Step 3: Get a Credit Memo Created for the Bad Debt
- Click on the +New button.
- Choose a Credit memo.
- Go to the Customer list and choose the customer.
- Go to the Product/Service section and choose Bad Debts.
- Enter the amount you wish to write off in the Amount section.
- Enter Bad Debt in the Message displayed on the Statement box.
- Tap on Save and Close.
Step 4: Apply the Credit Memo You Created to Invoice
Once a credit memo is created for the bad debt, it is time to apply it to the invoice.
- Tap on +New.
- Select Receive Payments under customers.
- Go to the Customer list and select the right customer.
- Go to the Outstanding Transactions section and choose the invoice you created.
- Choose the credit memo from the Credits section.
- Tap on Save and Close.
The amount that was written off will now appear under the Bad Debts expense account in the Profit and Loss report.
Step 5: Run a Report for Bad Debts
If you want to check all the account receivables that you have marked as bad debts, you can run the Account QuickReport with the instructions below.
- Firstly, select the Chart of Accounts option in the Settings.
- Further, find the Action column in the bad debts account and click Run Report.
NOTE: To identify the bad-debt entity in the list of customers, you can add a note to the name.
- Select Customers in the Sales section and select the name of the customer.
- Click Edit at the top-right corner and enter “Bad Debt” or “No Credit” in the Display Name as field after the customer name.
- Finally, select Save to conclude.
Learn from Experts How to Write off Bad Debts in QuickBooks
So now we hope it is clear to you how to write off bad debts in QuickBooks Desktop and Online. You should run an Account Receivable Aging Detail Report from time to time. It helps you keep a check on which debtor is on the verge of going bad. If you still have some doubts or are stuck somewhere, feel free to contact an expert at Asquare Cloud Hosting Helpline Number 855-738-0359. Don’t proceed if you are unsure of any step, as it can create problems in your Profit and Loss Statements.
FAQs
You can customize the ageing method, Report period, Number of periods, Days per ageing period, and Min. Days Past Due in an accounts receivable ageing detail report.
There is no need to create a new expense account to track bad debts if you have created an allowance account in QuickBooks.
There are several possible consequences you can face if you do not write off an unpaid invoice in QuickBooks. For instance, you can overpay your taxes, as the amount you never received from unpaid invoices will be added to your total income and have incorrect financial reports like profit and loss reports, which can negatively impact your business.
You must write off invoices when a customer fails to renew a subscription for services offered, never returns a product, fails to pay for the registration after attending an event, or fails to repay a loan.
Oriana Zabell, a professional cloud engineer, has over three years of experience in desktop, online QuickBooks support and troubleshooting. She is currently working as a cloud hosting consultant with Asquare Cloud Hosting. She loves to read and write about the latest technologies such as cloud computing, AI, DaaS, small businesses, manufacturing. When not writing, she is either reading novels or is indulged in a debate with movie fanatics.