Old A/R and A/P aging items: how pros really clean them up

When your aging reports turn into a graveyard

You open a new QuickBooks Online file and pull an A/R Aging Summary. There it is: a wall of 90+ day invoices, some from two or three years ago. Then you flip to A/P Aging and see the same thing on the vendor side. The client swears, "But my customers pay me!" or "We don't owe those vendors anymore."

This is one of the most common cleanup headaches: old open invoices and bills, plus unapplied credits, sitting on the aging forever. The business thinks they're fine because cash is flowing. But the aging reports tell a different story.

Left alone, these zombie items distort receivables, payables, and working capital. They make it impossible to trust the Balance Sheet. And when you finally try to fix them, you end up digging through years of transactions just to figure out what actually happened.

Where this problem hides inside QuickBooks Online

In QBO, this all lives in the A/R and A/P aging reports and their detail. The mess usually shows up when you:

• Run A/R Aging Summary and A/P Aging Summary as of a specific date, on an accrual basis.
• Drill into the 61–90 and 91+ columns.
• See a mix of old invoices/bills and negative balances (credits, payments, vendor credits) that clearly should have been matched but never were.

A classic pattern:

• 01/01/2023: Invoice #1001 for Customer A, $1,000.
• 02/01/2023: Credit Memo #15 for Customer A, -$1,000.
• As of 12/31/2024, both are still open. The aging shows a $1,000 receivable and a $1,000 credit, both 90+ days old, netting to zero economically but cluttering the books.

You see the same thing with vendors: old bills and old vendor credits that obviously belong together but were never applied.

Red flags to look for:

• Customers with both old positive and old negative balances in aging.
• Vendors with long-outstanding bills and equally old vendor credits.
• Invoices or bills partially paid, with small open balances lingering for years.
• Unapplied customer payments or vendor credits sitting in the 90+ column.
• Aging totals that don't line up with what the client believes they actually owe or are owed.

What happens if you just live with it

Old open items in A/R and A/P are easy to ignore because they rarely affect cash today. But they absolutely affect the story your reports are telling.

The damage inside your numbers

When invoices and bills sit open long after reality has moved on, you get:

• Inflated A/R: Revenue that was never collected, was collected but misapplied, or should have been written off still shows as an asset.
• Inflated A/P: Bills that were paid, disputed, or canceled still show as liabilities.
• Misstated income: If you eventually write off large batches of old invoices or bills, you can swing net income dramatically in the write-off period.
• Bad working capital metrics: Days Sales Outstanding and Days Payable Outstanding become meaningless when the aging is full of ghosts.

On the credit side, old unapplied credits and payments hide real issues:

• Customer credits that should reduce A/R but aren't applied.
• Vendor credits that could improve cash flow but are effectively forgotten.
• Netting situations where a customer both owes and is owed, but the books show two separate balances.

The damage in client conversations

This is also a trust problem. When you show a client an aging report with years of old items, they either:

• Disagree with the numbers ("We don't owe that vendor"), or
• Lose confidence in the system ("QuickBooks is always wrong").

Either way, you're stuck explaining why the software says one thing while their bank account and memory say another. And if you skip this cleanup, any advisory work you do on cash flow, collections, or vendor management is built on sand.

How to clean up old A/R and A/P systematically

A good cleanup doesn’t just clear the 90+ column; it documents what happened and leaves a repeatable process behind. Here’s a practical workflow you can use across clients.

1. Pick a diagnostic date and threshold.

   • Common: diagnostic date = year-end; threshold = 90 days.
   • For high-volume clients, you might use 60 days; for slow-paying industries, maybe 120.

2. Pull aging detail reports on accrual basis.

   • A/R Aging Detail and A/P Aging Detail as of the diagnostic date.
   • Filter or focus on items older than your threshold.

3. Identify old open invoices and bills.

   • For each customer/vendor, list invoices/bills with non-zero open balances older than the threshold.
   • Note due date (if present), transaction date, and remaining open balance.

4. Identify old unapplied or partially applied credits.

   • Customer side: credit memos, payments, refunds with negative balances.
   • Vendor side: vendor credits, bill payment credits with negative balances.
   • Focus on items older than the same threshold.

5. Match obvious pairs by customer/vendor.

   • Within each customer/vendor, look for equal and opposite amounts (or within a small tolerance, say $1).
   • Flag these as candidates to apply, not as automatic changes.

6. Decide treatment: apply, write off, or leave as-is.

   • Apply credits to matching invoices/bills where the business confirms they belong together.
   • Write off truly uncollectible A/R or unpayable A/P using appropriate bad debt or other income/expense accounts.
   • Leave legitimate long-term items (e.g., formal payment plans) but document them.

7. Post adjustments and document decisions.

   • Use memos and attachments on write-off journal entries.
   • Keep a simple worksheet listing each old item, what you did, and why.

Tools like CleanupOwl can run this kind of check automatically before you even start, handing you a list of old open invoices, bills, and likely matchable credits by customer and vendor. That turns what used to be an hour of report wrangling into a focused review and decision-making exercise.

Turning this into a standard firm habit

This shouldn’t be a heroic one-time cleanup. It should be a line item in your standard diagnostic and year-end procedures.

• Add "Review old A/R and A/P aging items" to your onboarding checklist for every new QBO file.
• Define firm-level defaults: e.g., 90-day threshold, $1 matching tolerance, and how to handle immaterial balances.
• Decide when you involve the client (e.g., anything over $500 or any write-off over X days old).
• For recurring clients, rerun the same diagnostic annually or quarterly to keep the aging clean.

A diagnostic tool like CleanupOwl can be wired into this workflow so that every new file or period-close automatically produces a list of old items and potential matches, and your team just reviews and acts. If you're a business owner, this is exactly the kind of behind-the-scenes hygiene you want your accountant running for you.

The patterns you'll keep seeing in client files

When you see just a handful of older items, you can usually clear them with a quick client email and a couple of entries. When you see pages of 90+ day items, especially with lots of negative balances, you’re looking at a structural process problem—cash is being recorded, but not applied correctly.

For those heavier situations, you’ll want to:

• Spend more time on matching and write-off decisions.
• Tighten current processes (how payments and credits are applied going forward).
• Consider more frequent diagnostics so the backlog doesn’t rebuild.

Making this part of your cleanup playbook

Old open items in A/R and A/P are one of those things that separate a light tidy-up from a true cleanup. If the aging reports are wrong, the Balance Sheet is wrong, and everything built on top of it is suspect.

This deserves its own checklist line: "Review and resolve old A/R and A/P aging items and unapplied credits." Run it at onboarding, at year-end, and any time you’re doing a diagnostic review before quoting a cleanup. Let a tool like CleanupOwl surface the list of old invoices, bills, and matchable credits so your team can focus on judgment calls instead of hunting through reports.

If you’re a business owner, ask your accountant how they handle old items on your aging reports and whether they’re running a structured diagnostic—manually or with an automated tool—to keep those balances real.