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. That step only works if the deposit is actually sitting in QuickBooks to apply, so if a stretch of bank activity never made it in, import that period first; our comparison of the best CSV to QBO converters covers the tools that build a clean file for it. 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.

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

Nine times out of ten the two reports disagree for a reason that has nothing to do with bad data. The A/R Aging Summary is always produced on an accrual basis, while a balance sheet can be run on either basis, so a cash basis balance sheet and an accrual aging report will never agree by design. The second cause is the aging method setting. The third, and the only one that is a genuine error, is a transaction that hit Accounts Receivable without an invoice behind it.

Work through them in this order before you assume anything is broken.

The aging method trap is the one that costs bookkeepers the most time, because the report looks correct in every other respect. Under the Current method, QuickBooks ages invoices against today. Run a 12/31 aging report in March under that setting and any invoice that was open on 12/31 but got paid in January simply will not appear, so the report understates what was really outstanding at year end. Switching Aging Method to Report Date puts those invoices back and is what makes the aging tie to a prior-period balance sheet.

Why is accounts receivable showing on my cash basis balance sheet?

A cash basis balance sheet should not show an A/R balance at all, because on cash basis an unpaid invoice is not income and not an asset. When A/R appears anyway, something in the file is forcing it: most commonly an invoice or credit memo posted to an account that is not an income account, a journal entry that touches A/R directly, or a payment that was never linked to the invoice it paid. Transactions dated in a future period will do it too.

Chase it by opening the A/R register and sorting by transaction type. Journal entries and unapplied payments float to the surface quickly. If an invoice uses an item pointed at a balance sheet account rather than an income account, QuickBooks has nowhere to net the entry on cash basis and leaves the residue in A/R. Repointing the item and re-saving the invoice usually clears it. Do not paper over the balance with another journal entry, because that adds a second untraceable line to the register and you will be back here next year.

How do I write off bad debt in QuickBooks Online?

In QuickBooks Online the sequence is create the expense account, create a product or service item that points at it, issue a credit memo for the unpaid invoice, then apply the credit memo to that invoice. Applying the credit is the step people skip, and skipping it leaves both documents open so the aging report gets worse rather than better.

The specific clicks: open the Chart of Accounts, select New, set Account Type to Expenses and Detail Type to Bad debts, and name it Bad debts. Then add a non-inventory service item called Bad debt with its income account set to that Bad debts account. Create a credit memo for the customer using that item for the exact unpaid amount. Finally open Receive Payment for the same customer, tick the original invoice and the credit memo together, and save at a zero payment amount. The invoice closes, the loss lands in Bad debts, and the customer history still shows what happened.

To check your work later, open the Chart of Accounts, find the Bad debts account and run a report on it. Everything you have written off will be listed there, which is exactly what a reviewer or a tax preparer will ask to see.

How do I clear accounts receivable from prior years in QuickBooks Desktop?

The mechanics are the same as the current year with one extra constraint: if the period is closed, do not reach back into it. Write the credit memo in an open period instead and apply it to the old invoice. The invoice closes, the aging report clears, and your prior-year financial statements and filed tax return stay exactly as they were reported.

In Desktop, create the Bad Debt item first (Lists, Item List, New, type Other Charge, account Bad Debts). Then Customers, Create Credit Memos or Refunds, pick the customer, use the Bad Debt item for the invoice amount, save. Then Customers, Receive Payments, select the customer, tick the old invoice, click Discounts and Credits, apply the credit on the Credits tab, and save with a zero payment. For a long list of small dead balances, the Accountant menu in Premier Accountant and Enterprise includes Client Data Review with a Write Off Invoices tool that handles them in one pass and posts to an account you choose.

One caution before a batch write-off: make sure the balances really are uncollectible and not just unapplied. A stretch of bank activity that never made it into QuickBooks produces payments you cannot apply, which look identical to bad debt on the aging report. Importing the missing period first, then re-running the aging report, often shrinks the write-off list dramatically.

Can I deduct an unpaid invoice on my taxes?

Only if you already reported the amount as income. IRS Topic 453 is explicit that if you are a cash method taxpayer you generally cannot take a bad debt deduction for unpaid salaries, wages, rents, fees, interest, dividends and similar items of taxable income. The logic is simple: you never picked up the income, so there is nothing to reverse. Accrual basis businesses did report the income when the invoice was issued, so the write-off gives back the deduction.

This is why the cash basis cleanup in Step 4 is a bookkeeping exercise and not a tax event. Zeroing an old invoice makes your receivables list honest; it does not create a deduction. It is worth saying that out loud to a client who expects a tax benefit from clearing five years of dead invoices, because the expectation is common and the disappointment is worse if it lands at filing time.

The other point tax preparers raise is method. For books, GAAP wants an allowance for doubtful accounts, an estimate booked before you know which specific customer will fail. For the federal return, most taxpayers are required to use the specific charge-off method, which means you deduct a particular debt in the year it becomes partly or wholly worthless. Those two methods disagree on purpose, and the difference is a book to tax adjustment your preparer handles. QuickBooks itself is doing the specific charge-off, which is why the credit memo names a customer and an amount rather than a percentage.

Does writing off bad debt affect sales tax you already remitted?

It can, and it is worth checking rather than assuming. If you invoiced sales tax, remitted it to the state on an accrual basis, and then never collected from the customer, most states let you recover that tax through a bad debt credit or deduction on a later return. The eligibility rules, the time limit and the required documentation vary by state, and some states restrict the credit to the original seller.

The practical step in QuickBooks is to make sure your bad debt credit memo mirrors the original invoice line by line, including the sales tax line, rather than being a single lump sum. That way the tax portion is identifiable when you or your preparer work out what is recoverable. A one-line write-off buries it and you will be reconstructing the split from the original invoice later.

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.

What is the difference between the allowance method and the direct write-off method?

The allowance method estimates uncollectible receivables in advance and books a contra-asset account, so the balance sheet shows receivables net of expected losses. The direct write-off method waits until a specific invoice is known to be worthless and expenses it then. GAAP requires the allowance method for financial statements; the IRS generally requires the specific charge-off approach for the return. Most small businesses in QuickBooks run the direct method and let the preparer adjust.

How long should an invoice sit before you write it off?

There is no fixed rule, but a receivable past 120 days with no payment, no promise to pay and no response to collection attempts is usually worth writing off. What matters more than the calendar is evidence: a documented collection effort, a returned notice, a bankruptcy filing or a closed business. Write off when the debt is genuinely worthless, and keep the file that shows why, because that documentation is what supports the deduction.

Can I reverse a bad debt write-off if the customer eventually pays?

Yes, and you should not simply delete the old credit memo. Record the money as income in the period you receive it, typically to a bad debt recovery account or back to the same Bad Debts account so it nets against current write-offs. Leaving the original write-off intact preserves the audit trail and keeps prior periods and the filed return untouched.

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. The mirror image of this job on the vendor side is the accounts payable cleanup, and most files that need one need the other, because the habit that strands an unapplied customer payment in A/R is the same habit that strands a bill payment in A/P.