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 I track taxable and non-taxable sales in Texas?
Configure your POS to flag each item as taxable or exempt, and make sure your accounting software tracks them separately. Keep exemption certificates on file for audit protection and verify local rates are accurate for your selling locations.
Read answerHow should a general contractor track job costs by project?
Every dollar in and out gets assigned to a specific job. Track labor, materials, subcontractors, equipment, and overhead by project so you can see which jobs actually make money and which ones lose it.
Read answerHow far back can catch-up bookkeeping clean up old QuickBooks records?
Catch-up bookkeeping can cover months or years of old records. The real limit isn't time but documentation. Bank statements, receipts, the condition of your QuickBooks file, and tax deadlines determine what's possible.
Read answerWhat financial strategy reports help identify unprofitable customers?
Customer profitability reports, gross margin analysis, AR aging, and recurring vs one-off revenue breakdowns reveal which customers drain your resources. Together these reports show who costs more to serve than they're worth.
Read answerHow can a contractor know which jobs are actually profitable?
Profitability by job requires tracking from estimate through closeout. You need the original bid, change orders, all direct costs coded to the job, overhead allocation, and a closeout report run while details are fresh.
Read answerHow do I know whether someone should be on payroll or paid as a contractor?
The answer depends on the actual working relationship, not what you call the person or what your contract says. The IRS evaluates behavioral control, financial control, and the nature of the relationship.
Read answer