Old accounts receivable balances won’t clean themselves up with a single journal entry. Each outstanding invoice needs review to figure out why it’s still showing as unpaid. Most stale AR falls into a few categories.

Start by running the Accounts Receivable Aging report sorted by oldest invoices first. Anything over 90 days needs investigation. Pull up each invoice and look at the customer’s payment history to see if the payment came in but never got matched.

Unapplied payments cause the most confusion. When a payment comes in, it needs to be matched to the specific invoice it’s paying. If someone recorded the deposit without matching it, the invoice stays open even though the money is in the bank. Check each customer’s account for credits or payments sitting there unmatched. In QuickBooks Online, go to the customer’s transaction list and look for payments that show as unapplied.

Duplicate invoices happen when someone creates an invoice, can’t find it later, and creates another one for the same work. Now the customer shows owing twice as much. Look for invoices with similar amounts on close dates to the same customer. Delete or void the extras.

Payments outside QuickBooks are common with small businesses. A customer pays cash, sends a Venmo, or drops off a check that gets deposited without being recorded against their invoice. Compare your bank deposits to recorded payments and match what you can.

Credits that were never applied work the same way. Maybe you issued a credit for returned goods or a pricing adjustment but never applied it to the open invoice. These credits sit there making AR look messier than it is.

Bad debt is money you’re not going to collect. If you’ve genuinely tried and the customer won’t pay, stop carrying the receivable. Write it off using a bad debt expense account. In QuickBooks you create a credit memo for the uncollectible amount and apply it against the invoice.

After working through everything, run the aging report again. What remains should be legitimately outstanding invoices you’re actively collecting.

Accurate AR matters beyond knowing who owes you money. Uncollected receivables still show as income on an accrual basis, which affects business tax preparation because you could owe taxes on money you didn’t actually receive. If you’re carrying receivables you’ll never collect, your books overstate income.

If your AR is a mess going back months or years, this type of cleanup takes time and requires understanding both QuickBooks and bookkeeping principles. Catch-up bookkeeping from someone who has done this before can work through it systematically and set up processes so the problem doesn’t repeat. Going forward, the key is matching payments to invoices at the time of deposit and reconciling weekly so problems get caught early.