How do I clean up old accounts receivable balances in QuickBooks?
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.
Greater Houston's Small Business Bookkeeping Partner
The Next Step:
A Quick Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How should manufacturers track raw materials, work in process, and finished goods?
Manufacturers need three separate inventory accounts that track costs as products move through production. Raw materials hold purchased materials, WIP accumulates materials plus labor and overhead, and finished goods hold completed products until sold.
Read answerWhat bookkeeping cleanup is needed before applying for a business loan?
Lenders expect current, reconciled financial statements before approving a loan. You'll need clean bank reconciliations, an accurate balance sheet, a schedule of existing debt, properly documented owner compensation, and a profit and loss statement that supports your cash flow capacity.
Read answerHow should pest control companies track prepaid service agreements?
Prepaid service agreements create deferred revenue that you recognize as income only when services are performed. Track each contract separately with service dates, and record revenue monthly as technicians complete scheduled visits.
Read answerWhat sales tax issues should Texas Shopify and Amazon sellers watch for?
Texas marketplace facilitator laws mean Amazon collects and remits sales tax on your behalf, but direct Shopify sales are your responsibility. The bigger challenge is often reconciling marketplace payouts where sales, fees, refunds, and taxes are bundled together.
Read answerShould contractor reimbursements be included in 1099 totals?
Usually yes. Reimbursements paid to contractors are generally included in the 1099-NEC total unless you have documented receipts and a formal expense arrangement that meets IRS requirements.
Read answerWhat bookkeeping does a nonprofit need before filing Form 990?
Form 990 requires expense allocation across program, admin, and fundraising categories, plus grant tracking and board-ready financials. Your bookkeeping system needs to track these elements throughout the year, not just at filing time.
Read answer