Bad debt in QuickBooks Online (QBO) is money a business expected to collect from a customer but now considers uncollectible. To record it accurately, first check whether the books use accrual or cash accounting; accrual-based businesses commonly write off an unpaid invoice through a bad-de debt expense account and a credit memo, while cash-basis treatment can differ.
What bad debt means in QBO
An invoice creates accounts receivable (A/R), an asset representing money customers owe. If a customer will not pay, leaving the invoice open overstates A/R and the income previously recorded. A write-off removes the uncollectible amount from A/R and records the loss in the appropriate expense account, so the customer balance and financial reports reflect the adjustment.
In QBO, “bad debt” is not a special button that makes an invoice disappear. The usual workflow uses a bad debt expense account and a credit memo applied to the invoice. This preserves the customer transaction history while reducing the receivable. Menu names and workflows can change as QuickBooks Online is updated, so look for the current Sales or Customers area when following the steps.
Before writing off an invoice
Confirm that the balance is genuinely uncollectible, rather than merely overdue or disputed. Review the invoice, payment records, customer communications, any payment plan, and any partial payments. A late invoice alone is not proof that it should be written off.
- Confirm the customer and invoice are correct, including any credits or payments already applied.
- Check that the amount being written off is the amount that will not be collected; do not write off a balance that is still being pursued.
- Identify the accounting method used for the books. The effect of uncollected invoices differs between accrual and cash accounting.
- Consider whether a customer’s payment is still expected, or whether only a specific portion of the invoice is uncollectible.
- For a material balance, uncertain accounting treatment, or tax-reporting question, ask a qualified accounting professional to review the situation.
Set up a bad debt expense account
If an appropriate expense account does not already exist, create one in the Chart of Accounts. In QBO, open the chart of accounts and choose the option to add an account. Select an expense account type and a suitable detail type, then name it “Bad Debt Expense” or another clear name that fits the business’s chart of accounts. The exact available detail types may vary.
Use a consistent account for write-offs so they can be found on the profit and loss report. Do not create duplicate accounts simply because a particular invoice needs a write-off. If the company’s accountant has specified a different account structure, follow that structure.
Write off an unpaid invoice using a credit memo
For a typical accrual-basis workflow, create a credit memo for the amount being written off, then apply that credit to the original invoice. This reduces A/R without recording a cash payment. The key is to assign the credit memo’s product or service line to the bad debt expense account, rather than treating the write-off as a deposit or payment.
- Open the customer’s record and locate the unpaid invoice. Confirm its open balance.
- Create a credit memo for that customer. Use a product or service item mapped to the Bad Debt Expense account. If necessary, create a dedicated non-inventory or service item and select the expense account in its income-account mapping as appropriate for the QBO setup; account mapping can affect how the transaction posts, so verify the account on the resulting reports.
- Enter the amount being written off. For a partial write-off, use only the uncollectible portion and ensure the remaining invoice balance is correct.
- Save the credit memo, then apply it to the invoice through the available credit application workflow. If QBO prompts to apply the credit to an open invoice, select the intended invoice.
- Check the customer’s transaction list and A/R balance. The invoice should be paid or reduced by the credit, and the bad debt expense should appear in the appropriate account.
For example, if a customer has an unpaid $500 invoice and the entire balance is deemed uncollectible, a $500 credit memo applied to it removes the open receivable and records the write-off expense. If only $120 is uncollectible, a $120 credit should leave the remaining amount open. These figures illustrate the bookkeeping mechanics, not a rule for deciding when a debt qualifies as uncollectible.
Cash-basis accounting and other situations
Do not assume that the accrual-basis credit-memo workflow is correct for every company. Under cash-basis accounting, income is generally recorded when payment is received, so an unpaid invoice may not have increased reported income in the same way. Recording a bad debt expense for an unpaid invoice can therefore produce a different result from the accrual workflow. Cash-basis reporting in QBO also does not itself determine the correct accounting or tax treatment.
Other cases need care. If a customer later pays an amount previously written off, record the recovery so the books show the receipt and its relationship to the earlier write-off. If the customer made a partial payment, apply it to the invoice before writing off any remaining uncollectible amount. For sales tax, foreign-currency transactions, or a prior-period invoice, the right entries can depend on the business’s setup and accounting method. Avoid deleting the original invoice or recording a write-off as a bank deposit; either can make the audit trail and reports misleading.
Check the accounting result and avoid common errors
After saving the transactions, review the customer balance, the invoice status, the Bad Debt Expense account, and the A/R balance. A trial balance or general ledger report can help confirm which accounts the credit memo affected. If the amount appears in sales income instead of bad debt expense, review the item’s account mapping and correct the transaction with appropriate accounting guidance.
- Recording a payment: A write-off is not cash received. Do not use Receive Payment unless a payment actually arrived.
- Deleting the invoice: Deletion removes history and may affect reports. A credit memo typically provides a clearer record of why the balance was removed.
- Writing off too much: A partial write-off should leave the collectible portion outstanding.
- Using the wrong expense account: Check the credit memo item’s account mapping and verify the general ledger result.
- Mixing accounting methods: The workflow and reporting effect may differ for cash and accrual books.
Frequently Asked Questions
Does QBO automatically write off bad debt?
No. QBO tracks invoices and credits, but the business must decide whether a balance is uncollectible and record the appropriate transaction.
Should I void or delete an unpaid invoice?
Usually, do not delete it just to clear an uncollectible balance. A credit memo applied to the invoice generally keeps a clearer record of the original sale and the adjustment. Follow your accounting professional’s instructions for unusual cases.
Can I write off only part of an invoice?
Yes. Record a credit for the portion considered uncollectible and apply it to the invoice. Confirm that any remaining collectible balance stays open.
What if the customer pays after I write off the debt?
Record the money actually received and account for it as a recovery of the prior write-off using the method appropriate to the company’s books. Do not simply reopen or alter the old invoice without checking the accounting effect.
Is a bad debt write-off automatically tax-deductible?
Not necessarily. Bookkeeping entries do not determine tax treatment. Rules depend on circumstances and jurisdiction; consult a qualified tax professional for tax questions.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this section
- Debt-to-Income Ratio Calculator and Explanation30.00 %
- Personal Loan Debt-to-Income Ratio Calculator26.67 %
- Debt-to-Income Excel Spreadsheet Calculator24.00 %
- Debt-to-Income Ratio: How It Works and What It Means24.00 %
- Debt-to-Income Ratio Calculator in Excel36.67 %
- Debt-to-Income Example: Formula and Calculator33.33 %