QuickBooks A/R Aging Cleanup: Clear Old Unpaid Invoices

Short answer: To clean up accounts receivable in QuickBooks, run the A/R Aging Detail report, identify invoices you will never collect, and clear them. On accrual basis you write them off to a Bad Debts expense account with a credit memo; on cash basis you zero out the invoice since it was never counted as income. Do this on a schedule so your receivables reflect money you can actually collect, not stale invoices from years ago.

An A/R aging report that is full of ancient open invoices lies to you. It tells you customers owe more than they really do, it distorts your working capital, and on accrual basis it can overstate income you already recognized. Cleaning it up is not about hiding losses, it is about making the number on your balance sheet true.

Step 1: Run the A/R Aging Detail report

Start by seeing exactly what is outstanding and how old it is. In QuickBooks, go to Reports and open the Accounts Receivable Aging Detail report. It groups every unpaid invoice into buckets: current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. The invoices sitting in the 90-plus column are your cleanup targets, because the older a receivable gets, the less likely it is to ever be paid.

Step 2: Separate real receivables from dead ones

Go through the aged invoices one by one and sort them into three piles: still collectible, already paid but not applied, and genuinely uncollectible. Some old balances are not really owed at all, they are payments that were received but never matched to the invoice, or duplicate invoices. Fix those by applying the missing payment or deleting the duplicate. What is left, the invoices a customer truly will not pay, is what you write off.

Step 3: Write off bad debt on accrual basis

If you report on accrual basis, you already recorded the income when you created the invoice, so you clear it by recording an expense. First create a Bad Debts expense account if you do not have one: open the Chart of Accounts, add a new account, choose the Expenses type and the Bad Debts detail type. Then create a credit memo for the customer using a Bad Debt item pointed at that account, and apply the credit memo to the open invoice. The invoice closes, and the loss lands in Bad Debts where it belongs.

Step 4: Clear old invoices on cash basis

On cash basis the handling is simpler, because you never recorded the income in the first place, an unpaid invoice was never on your P&L or balance sheet. In that case you can zero out or delete the old invoice, provided you have access to the prior period and it is not locked. Since the invoice was never counted as income on cash basis, removing it does not affect a closed period. When in doubt about whether a period is closed, check with your accountant before editing prior-year entries.

Step 5: Clear customers with zero net balances

After write-offs, you will often have customers whose credits and charges net to zero but still show open lines. QuickBooks has a Clear customers with zero net balances routine (through the A/R aging reports area) that links those offsetting entries so they drop off the report. Running it tidies the aging report so only genuinely open balances remain, which makes the report usable again for collections.

Keep A/R clean going forward

The point of the cleanup is to make the aging report a tool you trust for collections. Once it is accurate, review it monthly, chase the 30-to-60-day bucket before it ages further, and write off uncollectible balances quarterly rather than letting them pile up for years. A receivables list that reflects reality is what lets you act early, which is when overdue invoices are still collectible. On the flip side of the ledger, if inbound bills stack up too, tools that pull the data off vendor invoices automatically keep your payables as current as your receivables.

Frequently asked questions

What is a good A/R aging cleanup schedule?

Review the aging report monthly and act on the past-due buckets right away, then do a deeper write-off pass each quarter and a full reconciliation at year end. Monthly review catches problems while the money is still collectible, and the quarterly write-off keeps dead invoices from distorting your reports for months at a time. Year end is your last chance to clean the report before it feeds your tax filing.

Does writing off bad debt hurt my books?

It reflects reality rather than hurting anything. On accrual basis the write-off records a loss you already effectively took when the customer stopped paying, and it lowers overstated receivables to a true figure. Your balance sheet becomes more accurate, not weaker. The alternative, leaving uncollectible invoices open forever, is what actually misleads anyone reading your financials.

Should I write off or delete an old invoice?

On accrual basis, write it off with a credit memo so the loss is documented in Bad Debts and there is a clear audit trail. Deleting the invoice erases that history and can throw off prior-period reports. On cash basis, where the invoice never touched income, zeroing it out is acceptable. The general rule is to preserve the trail on accrual and keep it simple on cash.

Why does my A/R aging not match the balance sheet?

The two disagree when transactions hit Accounts Receivable without going through an invoice or payment, most often a journal entry posted straight to A/R, or a payment applied to the wrong customer. Run the A/R Aging Detail report and the Balance Sheet for the same date, then look for journal entries in the A/R register. Re-post those as proper invoices or credit memos tied to a customer, and the aging report and balance sheet fall back into agreement. Keeping every A/R movement on a real customer transaction is what keeps the two reports tied out.

For related cleanup, see the Opening Balance Equity cleanup guide and the chart of accounts cleanup walkthrough, which often surface the same stray balances an A/R review turns up.