Aged A/R and A/P over 90 days: what they’re telling you in QBO

When your aging reports start to look like a graveyard

You open a new QuickBooks Online file, run the A/R Aging Summary, and your stomach drops. There’s a whole column of invoices sitting in the ">90" bucket. Scroll to A/P Aging and it’s the same story: old vendor bills from 6, 9, 12 months ago, still sitting open.

The owner says, "But my customers always pay eventually," or, "Those old vendor bills are wrong, I’m not paying them." Meanwhile, the balance sheet is carrying every one of those amounts as if they’re real assets and real liabilities.

This is one of the most common cleanup landmines: aged receivables and payables that no one has forced a decision on. Not necessarily wrong yet, but not being managed either. Your job in a cleanup is to turn that vague mess into a clear list of decisions: collect, pay, write off, or fix.

Where this problem hides inside QuickBooks Online

The good news: QBO actually surfaces this pretty cleanly if you know where to look. The bad news: most people only glance at the totals and ignore the details.

Start with:

A/R Aging Summary and A/R Aging Detail, run as of today (or your analysis date), all customers, all terms.
A/P Aging Summary and A/P Aging Detail, same settings for vendors.

Use a 90‑day review point as your default. You’re looking at the ">90" column and anything where days past due is greater than 90.

A realistic example:

A/R Aging Detail shows 7 invoices for "Acme Construction" dated between 2/1 and 4/15 last year.
Terms Net 30, all still open.
Today is 12/31. The oldest invoice is 334 days past due; the group totals $40,000.
A/P Aging Detail shows 3 bills to "Metro Supply" from 5/10, 5/25, and 6/1, all over 150 days past due, totaling $15,000.

On paper, the business "has" $40k more in A/R and "owes" $15k more in A/P than reality probably supports.

Red flags you’ll see over and over:

Customers with multiple invoices sitting in the ">90" bucket.
Vendors with old bills that the owner insists are "wrong" or "already handled".
Old credit memos or vendor credits that never got applied.
Delayed charges and billable expenses that are years old and never invoiced.
A/R or A/P balances that don’t match what the owner believes they’re owed or owe.

Run A/R and A/P Aging Detail with the "Days Past Due" column turned on, then filter or sort by that column. It’s the fastest way to see what’s truly beyond your 90‑day line.

What happens if you just live with it

Leaving aged A/R and A/P alone is tempting. It’s messy, it requires client conversations, and it often touches prior years. But it quietly breaks both the numbers and the relationship.

The damage inside your numbers

Aged receivables that will never be collected inflate assets and equity. Aged payables that will never be paid inflate liabilities and understate equity.

Common impacts:

Balance sheet is wrong: overstated A/R and A/P distort working capital and debt ratios.
P&L is off: if you eventually write off a big chunk of A/R, it hits bad debt expense in the current period instead of when the revenue was recognized.
Tax planning gets fuzzy: owners think they have more customers to collect from or more expenses to deduct than they really do.
Bank conversations suffer: lenders look at aging quality, not just totals. A file with a big ">90" column looks sloppy and risky.

On the A/P side, old unpaid bills can hide vendor disputes, duplicate entries, or bills that were paid outside QBO. You end up with vendors "paid" in real life but still showing as unpaid in the books.

The damage in client conversations

This is where trust can erode.

You show the owner the aging report and they say, "Those customers don’t owe me that anymore," or, "We settled that vendor bill years ago." Now they’re realizing their books haven’t been telling them the truth.

If you don’t force decisions on these aged items during cleanup, you’re effectively blessing the fiction. Six months later, when they ask, "Why does QBO say I’m owed $120k when I know it’s more like $70k?", you own that problem.

How strong firms tackle aged A/R and A/P

The goal isn’t to magically know which invoices will be collected or which bills will be paid. Your job is to surface a clean list, apply some structure, and then walk the owner through decisions.

Here’s a practical workflow that works well:

Pull aging detail reports for both A/R and A/P as of your analysis date, with all open items.
Filter to items over your threshold (start with 90 days). Export to Excel/Sheets if that’s easier to work with.
Group by customer/vendor and total the open balance and count of aged items for each. This helps you prioritize the big exposures.
Tag each line with a proposed action: likely collectible/payable, doubtful, clearly wrong/duplicate, or needs client input.
Meet with the owner and walk through the grouped list, starting with the largest customers/vendors. For each, decide: collect, pay, write off, credit, or research.
Record the decisions: use credit memos, bad debt write‑offs, bill credits, or adjustments as appropriate, documenting any prior‑year implications.
Re‑run the aging reports to confirm that the ">90" column now reflects only genuinely open, actively managed items.

Tools like CleanupOwl can do the heavy lifting on steps 1–3 by automatically flagging every open invoice and bill over your aging threshold and grouping them by customer or vendor. Instead of spending an hour building the list, you start directly at the decision conversation.

Be intentional about your lookback. For some clients, you may decide that anything over, say, 365 days is automatically a write‑off or requires very strong evidence to keep. For others (long‑cycle industries), you might use 120 or 180 days instead of 90. Document your threshold and rationale in your workpapers.

Turning this into a standard part of every cleanup

This shouldn’t be a one‑time heroic effort; it should be a checkbox in your cleanup SOP.

A simple pattern:

During intake, note whether the client has a formal collections process or AP approval workflow. If not, assume aging will be messy.
Early in the diagnostic phase, run your aging checks and capture the over‑threshold list.
Use a standard template to record decisions on each aged item and the journal entries or transactions you’ll post.
In your final deliverables, include a short summary: "We reviewed $X of A/R and $Y of A/P older than 90 days; $A was written off, $B remains open and is being actively collected/paid."

A diagnostic tool like CleanupOwl can run this check on every new file before you quote or start work, so you know upfront whether you’re dealing with a handful of aged items or a full‑blown collections and AP cleanup project.

The patterns you’ll keep seeing in client files

Situation	What you see in QBO	Risk if you shrug it off
Old customer invoices no one is chasing	A/R Aging Detail shows multiple invoices 120–365+ days past due for the same customer, still fully open	Overstated A/R and equity; future big bad‑debt hit; owner thinks they have more cash coming than they do
Vendor bills the owner insists are wrong	A/P Aging shows bills 150+ days old to a vendor the owner says was "already settled"	Overstated liabilities; confusion when vendor statements don’t match; risk of double‑paying or strained vendor relationships
Stray credits and unapplied memos	Old credit memos or vendor credits sitting open for years	Misstated customer/vendor balances; future write‑offs that confuse the P&L; messy statements
Long‑cycle projects with no documentation	Invoices 120–180 days old for construction/consulting jobs, but no notes on retainage or payment plans	Hard to distinguish real risk from normal cycle; potential disputes later if not documented now
Mostly clean aging with a few exceptions	Only a handful of items over 90 days, each with a clear reason (dispute, payment plan)	Low numeric risk, but if not reviewed, those few items can still cause future noise and questions

When you see a file where most of the ">90" bucket is a couple of small, well‑explained items, you can move quickly: confirm, document, and move on. When you see tens of thousands of dollars spread across many customers or vendors, that’s a sign you need a dedicated session with the owner and possibly a separate mini‑project for collections and AP cleanup.

Be careful with closed tax years. Writing off large amounts of old A/R or clearing old A/P can affect prior‑year income. Coordinate with whoever prepared the returns, and get explicit client approval before posting big adjustments that touch prior periods.

Making this part of your cleanup playbook

Aged A/R and A/P over 90 days deserve their own line on your cleanup checklist. They’re not just "old stuff"; they’re where reality and the books quietly drift apart.

If you build a habit of always pulling a 90‑day‑plus list, grouping it by customer and vendor, and forcing clear decisions, you’ll deliver cleaner balance sheets, fewer surprises, and better conversations with both owners and their lenders.

If you’re a business owner reading this, ask your accountant: "How do you review my old invoices and bills over 90 days?" They should be able to show you a concrete list and walk you through what was collected, what was written off, and why.

Whether you build the list manually from QBO aging reports or let a diagnostic tool like CleanupOwl hand you the over‑threshold items in seconds, the important part is that the review happens every time.

Ready to run deeper QuickBooks diagnostics?

Use CleanupOwl to automatically flag issues like this before you quote or start your next cleanup project.

Start Free Trial