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 nonprofits track restricted donations and grant expenses?
Restricted funds require separate tracking because donors or grantors specified how the money must be used. Set up your accounting system to tag each funding source, record releases from restriction when money is spent according to donor intent, and align grant expenses to approved budget categories.
Read answerWhat happens if my Texas sales tax filings do not match my POS reports?
The Texas Comptroller can flag discrepancies between your sales tax returns and POS data, bank deposits, or marketplace reports. Mismatches may result in notices requesting explanation or audits that lead to penalties and back taxes.
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 answerHow often should a small business reconcile bank and credit card accounts?
Monthly is the standard for most small businesses. Bank feeds pull transactions automatically but don't catch duplicates, uncategorized items, or missing entries. Monthly reconciliation is the checkpoint that keeps your books accurate.
Read answerHow should retail shops track inventory and cost of goods sold?
Proper retail inventory tracking starts with recording every purchase at cost, then adjusting for customer returns, vendor credits, and shrinkage. Regular physical counts verify your numbers and catch problems before they compound.
Read answerHow do I train staff to enter bills without breaking the books?
Train staff on vendor setup, bill coding, approval workflows, attachments, due dates, and duplicate checking. Consistency in how every bill gets entered keeps your books clean and prevents costly errors.
Read answer