Quickbooky

Accounting News

Accounts Receivable

QuickBooks Online Users Clear Uncollectable Invoices With Credit Memos

QuickBooks Online users are clearing uncollectable invoices with a credit memo workflow that records the loss in a dedicated bad debts expense account.

COMMUNITY ISSUESQUICKBOOKY

A stubborn entry keeps returning to the QuickBooks Online community: the invoice that will never be paid. The customer has gone quiet, the balance remains, and accounts receivable drifts a little further from reality each month. The formally accepted answer is a credit memo workflow, and it is more deliberate than most people expect. We walked it end to end; here is what it does and why each step exists.

Receivables that age but never clear

Users usually meet the problem on the Accounts Receivable Aging Detail report, found among the standard reports. Balances from departed customers sit in the older buckets and never move. The headline total overstates what the business can realistically collect. From there the temptation splits three ways: delete the invoice, void it, or push it out with a journal entry. Each option damages the record differently.

Deleting the invoice backfires

Deletion or voiding erases the sale as though the work never happened. Revenue for that period quietly drops, and the loss is never recorded anywhere. Month-to-month comparisons become subtly wrong. A journal entry clears the cash side but leaves the invoice open, so the aging report still lists it. The write-off handles both faults at once. The sale stays on the books, the invoice closes, and the loss lands in a visible expense account.

The accepted workflow, step by step

The accepted solution builds a small structure first and then uses it. Follow the sequence in order:

  1. Run the Accounts Receivable Aging Detail report and decide which balances are genuinely uncollectable. Nothing later in the workflow matters until this review is done.
  2. In the chart of accounts, create a new account. Set the type to Expenses, set the detail type to Bad debts, name it Bad debts, and save.
  3. In the products and services list, create a new non-inventory item. Point its income account at the new bad debts account, mark it as something you sell to customers, and save.
  4. Create a credit memo for the customer. Put the bad debts item on it, enter the amount you intend to write off, and set the statement message to something plain such as Bad debt.
  5. Open Receive payment for the same customer. Tick the invoice under outstanding transactions, tick the credit memo under credits, and save. The credit applies and the invoice closes.
  6. Verify the result. A quick report on the bad debts account shows the expense, and a fresh aging report no longer lists the invoice.

One step carries the weight

The fifth step is the one that decides the outcome. A credit memo on its own changes nothing about the invoice; both documents simply sit open until you apply the credit through Receive payment. Match the memo amount to the balance you want cleared. A partial amount leaves a partial balance, which is a legitimate choice when you expect to recover some of the money.

Marking the customer as a credit risk

One closing touch in the accepted answer draws notice. Edit the customer record and append Bad Debt or No Credit to the display name, so the warning travels with the customer wherever the name appears. Anyone preparing a future quote or sale sees the flag before extending terms again. It is a manual label rather than a system block, but it puts the history in front of the next person who opens the record.

Does the write-off change your taxes?

Sometimes, and only sometimes. Businesses on accrual accounting can often deduct the written-off amount, because the sale was reported as income even though the cash never arrived. Eligibility and timing depend on the specifics, so confirm the treatment with your accountant before filing. The entry is worth recording either way; honest receivables matter even when no deduction follows.

A separate path for Desktop

These steps belong to QuickBooks Online. Desktop editions follow their own write-off procedure, and the two sequences are not interchangeable. Confirm which edition holds the invoice before you start, since the steps are easy to mix up.

The takeaway

Writing off bad debt in QuickBooks Online is a reclassification, not a deletion. The invoice closes, receivables shrink to a number you can defend, and the loss becomes a visible expense instead of a silent overstatement. Six steps, in order, done once.

← Back to Community Issues