8 min read

How to Clean Up AR / AP Aging

Stale receivables and phantom payables distort your books. How to clean up AR and AP aging — investigate old balances, fix negatives, and match bills to payments.

The AR and AP aging reports are where a lot of quiet damage lives. Stale receivables overstate your income and what you think you’re owed; phantom payables inflate your liabilities. Cleaning both up sharpens the balance sheet and gives you a real picture of cash.

Cleaning up accounts receivable

Review the A/R aging line by line. In 30 years of doing this, I’m not sure I ever took on a client that didn’t have invoices marked open that were actually paid — usually because the payment was booked straight to a deposit instead of applied to the invoice. Find the deposit, swap in the invoice payment, and the receivable clears.

Almost every messy file has invoices sitting “open” that were paid months ago.

Fixing negative balances

Negative A/R usually means a payment or credit was applied without a matching invoice, or a payment was over-applied. Track down the underlying transaction — a payment on the wrong customer, a duplicate credit, a missing invoice — and correct it so each balance reflects reality.

Writing off what’s dead

Write off receivables that are genuinely uncollectible — the customer is gone or the debt is dead. Don’t write off something just because it’s old if it’s still collectible, and document why you wrote each one off so the adjustment has an audit trail.

Cleaning up accounts payable

A/P works just like A/R in reverse. Review the A/P aging for old unpaid bills that were actually paid or were never real — they inflate your liabilities. Match bills to payments and clear the noise. While you’re there, look for early-payment discounts you can capture if the cash flow supports it.

Many of the paid-but-open invoices trace back to unapplied payments and undeposited funds, so the two cleanups go hand in hand — both part of the full messy-books process.

Clean books shouldn’t require heroics.

🧹Clean Books is AI-native accounting built by a 30-year accountant — designed so the cleanup you just did stays done. Plain-English bank rules, reconciliations that don’t fight you, and reports that actually look like reports — not to mention the most amazing transaction search on the planet.

Frequently asked questions

How do I clean up my accounts receivable aging?

Review the A/R aging line by line. Look for invoices that were actually paid but never marked as such — often the payment was booked straight to a deposit instead of applied to the invoice. Fix those, investigate anything ancient, resolve negative balances, and write off what's genuinely uncollectible. Stale receivables overstate both your income and what you think you're owed.

Why does my AR aging show negative balances?

Negative balances usually mean a payment or credit was applied without a matching invoice, or a payment was over-applied. Track down the underlying transaction — a payment booked to the wrong customer, a duplicate credit, or a missing invoice — and correct it so each customer's balance reflects reality.

How do I clean up accounts payable aging?

A/P works like A/R in reverse. Review the A/P aging for old unpaid bills that were actually paid or were never real — they inflate your liabilities. Match bills to their payments and clear the noise. While you're there, look for early-payment discounts you can capture if the cash flow supports it.

Should I write off old receivables?

Write off receivables that are genuinely uncollectible — the customer is gone, the debt is dead, or it was never a real invoice. Don't write off something just because it's old if it's still collectible. Document why you wrote each one off so the adjustment has an audit trail.

Want help untangling a messy aging report? Find a specialist in the Clean Accountants and Bookkeepers Directory.