Old unpaid invoices in QuickBooks: when to call it bad debt

When "open" invoices are really dead receivables

You open a new QuickBooks Online file, run an A/R Aging Summary, and your eyes go straight to the 91+ column: $187,000. The client shrugs and says, "Oh, those? They're really old. Some of those customers went out of business."

Meanwhile, their balance sheet shows a healthy Accounts Receivable balance and last year’s income looks great on paper. But you know a chunk of that "revenue" is never turning into cash.

This is the quiet mess: very old open invoices that everyone has emotionally written off, but nobody has actually written off in the books. They sit there year after year, inflating A/R and income, confusing lenders, and complicating tax conversations.

If your firm does cleanup work, you need a systematic way to surface these zombies, separate the truly dead from the merely slow, and push the client to make decisions.

Where this problem hides inside QuickBooks Online

The core of this lives in one place: the A/R Aging Detail report.

The pattern is simple:

1. Invoice is still open.
2. Invoice date is old (often 180–365+ days).
3. Remaining balance is still material.
4. Little or no subsequent activity from that customer.

In QBO, a practical way to see it:

• Go to Reports → A/R Aging Detail.
• Set the "Report period" to "All dates" or at least through your cleanup cutoff date.
• Make sure it’s filtered to "Open" invoices only.
• Sort by "Due Date" or "Invoice Date" ascending.

Now you’ll see the bottom of the report fill up with things like:

• Invoice #1045 dated 10/15/2022 for $8,500, still fully open.
• Invoice #1089 dated 01/03/2023, original $12,000, $2,000 still open.
• A cluster of invoices for the same customer, all 365+ days old.

A realistic scenario from a messy file:

Customer "Adwin Co" has five open invoices dated between 10/01/2023 and 11/15/2023, totaling $20,200. No payments, no credits, no later invoices, no later payments for Adwin at all. Each invoice is $3,000–$5,000.

Those are classic bad debt candidates. Contrast that with a customer who has a 400‑day‑old invoice for $150, but you see steady invoices and payments every month since. That one might be a dispute or a partial write‑off situation, not necessarily a full bad debt.

Key red flags to look for:

• Invoices older than 180–365 days with a non‑trivial open balance.
• Customers with no transactions after the old invoice date.
• A/R Aging Detail where the same customer name repeats in the oldest bucket.
• Old invoices that have never had a payment or credit applied.
• Old partial balances that are still large (e.g., 50%+ of the original invoice).

What happens if you just live with it

At first, ignoring old invoices feels harmless. The client already "knows" they won’t get paid, and the bank is looking more at cash than A/R anyway.

But from a file quality and tax perspective, it’s a problem.

The damage inside your numbers

Leaving very old, likely uncollectible invoices open:

• Overstates Accounts Receivable on the balance sheet.
• Overstates prior‑period income if revenue was recognized when invoiced.
• Distorts KPIs like DSO, collection rates, and customer concentration.
• Makes it harder to reconcile A/R subledger to the GL cleanly.

For tax‑basis clients, you also get into awkward territory:

• If they’re accrual for tax, they may have paid tax on income they’ll never collect.
• If they’re cash‑basis for tax but accrual in QBO, the books and the return drift apart and become harder to explain.

And practically, every future review of A/R becomes slower. You waste time re‑evaluating the same dead invoices because nobody ever made a decision and documented it.

The damage in client conversations

This is where trust can erode.

You show the owner an A/R Aging with six‑figure 90+ balances. They say, "That’s not real. Those people disappeared years ago." Now they don’t trust their own reports.

If you clean up everything else but leave these zombies, the story doesn’t hang together. Lenders, investors, or potential buyers see a big A/R balance and ask about collectability. If the client admits half of it is uncollectible but there’s no bad debt policy or write‑off trail, it looks sloppy.

On the flip side, if you push too hard to write everything off without a clear method, you can spook the client: "Why are you trying to kill all my receivables?"

You need a defensible, repeatable way to identify high‑risk invoices and present options.

A practical way to clean up old receivables

Here’s a workflow that works well in cleanup projects and year‑end reviews.

1. Define your thresholds.

   • Age: pick a line (e.g., 180 days for active businesses, 365 days for more conservative clients).
   • Materiality: decide what’s worth discussing (e.g., >$100 per invoice, or >5–10% of original invoice amount).

2. Pull the candidate list.

   • Run A/R Aging Detail "as of" your cleanup date.
   • Filter to open invoices older than your age threshold.
   • Exclude invoices where the remaining balance is below your materiality threshold.

3. Assess customer activity.

   • For each candidate invoice, click into the customer.
   • Look for any invoices, payments, credits, or sales receipts dated after that invoice.
   • Mark invoices where there is no subsequent activity as higher‑risk candidates.

4. Check for existing bad debt treatment.

   • Review the Products and Services list for a Bad Debt item and the chart of accounts for a Bad Debt expense account.
   • Scan for credit memos using that item that may have already closed some invoices.
   • Make sure you’re not double‑writing off something that’s already been handled.

5. Prepare a client‑facing list.

   • Export your candidate invoices with: customer, invoice #, date, original amount, open balance, age in days, and a note like "No activity since [date]" where applicable.
   • Group by customer so the client can think in relationships, not just transactions.

6. Decide treatment with the client. For each invoice or group:

   • Keep open and continue collection efforts.
   • Partially write off (e.g., leave a small balance under dispute).
   • Fully write off to Bad Debt.
   • In some cases, reclass to a different account if it was never a real receivable (e.g., setup error).

7. Post and document.

   • Use a standardized Bad Debt item mapped to a Bad Debt expense account.
   • Close invoices with credit memos dated appropriately (often in the current or just‑closed year, depending on tax and GAAP considerations).
   • Save your working paper showing criteria, list, and client approvals.

Tools like CleanupOwl can do the heavy lifting on steps 2–3 by automatically scanning for old, open invoices above your thresholds and tagging those with no subsequent customer activity. You still make the judgment calls, but you’re not burning an hour just building the list.

Turning this into a repeatable firm standard

This shouldn’t be a one‑time heroic cleanup. It should be a standing line item in your review checklist:

• For monthly/quarterly clients: scan for newly aged‑out invoices (e.g., anything crossing 180 days).
• For annual clients: run a full aged‑A/R review before closing the year.
• For cleanup projects: run the scan at intake to scope how much bad debt work is hiding in the file.

This is where a diagnostic tool like CleanupOwl fits nicely: it can flag long‑outstanding invoices and highlight which customers have gone completely quiet, so your staff can focus on talking to the client and posting the right entries instead of hunting through reports.

The patterns you’ll keep seeing in client files

Here are some recurring situations and how they look in QBO:

In practice, you’ll treat these differently. The "customer disappeared" and "large partial balance" cases usually warrant a real conversation and likely write‑off. The "steady later sales" case might need research into misapplied payments. The many tiny balances might be handled with a one‑time sweep using a firm‑approved materiality policy.

Making this part of your cleanup playbook

Old, unpaid invoices are one of those issues that quietly undermine file quality if you don’t address them head‑on. A/R looks strong, income looks healthy, but a chunk of it is fantasy. Building a simple, criteria‑based review for aged receivables into your standard process keeps you from inheriting someone else’s wishful thinking.

For your firm, this is an easy win: it’s objective, it’s explainable, and it leads to visible improvements in the balance sheet and aging reports. It also gives you a natural opening to talk about credit policies, collection processes, and when to stop chasing a customer.

If you’re a business owner reading this, this is a good question for your accountant: "Are you regularly reviewing my old invoices and recommending bad debt write‑offs, or are we just letting them sit there?" Whether they do it manually or with a diagnostic tool like CleanupOwl, the important part is that someone is looking.

Make "review long‑outstanding open invoices for potential bad debt" a named step in your cleanup and year‑end checklists. Decide your thresholds, standardize your Bad Debt item and account, and keep a simple workpaper template for client approvals. Once that’s in place, this goes from a messy, emotional conversation to a straightforward, data‑driven part of your service.