Cleaning Up A/P Aging: Old Bills, Credits, and Balance Sheet Gaps

When your A/P aging and Balance Sheet don’t agree

You open a new QBO cleanup file, run the A/P Aging Summary, and your stomach drops. There’s a >180 days column full of old vendor bills, a couple of vendors with negative balances, and the total doesn’t match Accounts Payable on the Balance Sheet.

The client swears, "But I pay my vendors every month." And they might! The problem is that the A/P subledger in QBO hasn’t kept up with reality. Bills were entered and paid outside the workflow, credits never got applied, or someone posted directly to the A/P account.

This is one of those issues that looks small on the surface—"just a few old bills"—but it’s actually a structural integrity problem. If your A/P aging doesn’t tie to the Balance Sheet, you can’t trust vendor balances, and you definitely shouldn’t be tying Schedule L or advising on cash flow off those numbers.

Where this mess hides inside QuickBooks Online

Most of what you need is in two places: the A/P Aging report and the Balance Sheet, both on an accrual basis and as of the same date (your cleanup period end date—often year-end).

Start with Reports → A/P Aging Summary (or Detail) as of, say, 12/31/2024:

• Basis: Accrual
• All vendors
• All aging buckets

Then pull a Balance Sheet as of the same date, also on accrual, and note the total of all Accounts Payable–type accounts.

Typical ugly scenario:

• A/P Aging Summary total: $40,000
• Balance Sheet A/P total: $38,000
• Discrepancy: $2,000
• Several bills sitting in the >180 days bucket totaling $15,000
• Two vendors with negative balances from unapplied credits/overpayments

That’s your signal that the subledger and GL are out of sync.

Key red flags to scan for:

• Aging buckets with large balances in 91–120 or >120 days
• Vendors with negative balances (net credits) on the aging
• Vendors that show both big open bills and big open credits
• A/P Aging grand total that doesn’t match the Balance Sheet A/P total
• Multiple A/P accounts on the Balance Sheet with odd balances

If you want to go deeper, switch to A/P Aging Detail or Vendor Balance Detail as of the same date. That’s where you’ll see which specific bills and credits are causing the problem.

What happens if you just live with it

Ignoring this isn’t just about a messy aging report. It ripples through tax work, vendor relationships, and your firm’s credibility.

The damage inside your numbers

When old or unapplied vendor balances sit in A/P:

• Expenses may be overstated or understated depending on how payments were recorded.
• A/P on the Balance Sheet doesn’t reflect real obligations—Schedule L won’t reconcile cleanly.
• Cash flow projections based on "open payables" are misleading.
• Negative vendor balances hide unapplied credits or overpayments that should either reduce expense, be refunded, or be reclassified.

If the A/P Aging total doesn’t match the Balance Sheet A/P:

• Someone likely posted directly to the A/P account on a bill payment, journal entry, or vendor check.
• There may be duplicate bills, voided bills not fully cleared, or misapplied payments.
• You can’t rely on the aging as a subledger. That’s a big deal if you’re signing off on compiled or reviewed financials.

The damage in client conversations

This is also where trust can erode.

You tell a client they owe $40,000 to vendors based on the aging, but they insist they only owe about $25,000. You dig in and discover $15,000 of old, never-cleaned-up bills and a $2,000 discrepancy to the Balance Sheet.

Now you’re explaining why last year’s numbers might not have been right, why Schedule L didn’t really tie, and why you need extra time (and fees) to fix it. That’s not a fun conversation.

On the flip side, when you can say, "Your A/P aging ties exactly to your Balance Sheet, and we’ve cleared old and unapplied balances," the client feels like someone finally has a handle on their books.

How solid firms clean up A/P aging

A good A/P cleanup process is systematic. You’re not just deleting old bills; you’re reconciling the subledger to the GL and respecting closed periods.

Here’s a practical workflow:

1. Set your cleanup date and basis
   Decide the period end (e.g., 12/31/2024). Run A/P Aging Summary and Balance Sheet as of that date on accrual.

2. Compare A/P Aging total to Balance Sheet A/P
   Sum all Accounts Payable–type accounts on the Balance Sheet. If the aging total doesn’t match within a small tolerance (e.g., $1–$10), flag it for deeper review.

3. Identify and triage old bills
   In A/P Aging Detail, filter or sort by due date or aging bucket. Anything >90 or >180 days past due deserves a look. For each old bill, determine:

   • Was it actually paid via a check or expense coded directly to an expense account?
   • Was it a duplicate or data entry error?
   • Is it a legitimate unpaid bill that the client still intends to pay?

   Then either apply existing payments, void/credit, or write off via a controlled journal entry (respecting closed periods).

4. Find negative vendor balances and unapplied credits
   On the aging, look for vendors with negative totals. Drill into each:

   • Are there unapplied vendor credits that should be matched to open bills?
   • Was an overpayment recorded that should be refunded or reclassified?
   • Is there a mis-posted journal entry to A/P?

   Apply credits properly, reclassify overpayments if needed, or clear bad entries with documentation.

5. Match vendors with both big bills and big credits
   In Vendor Balance Detail, for each vendor, compare open bills vs open credits. Where both sides are large (say, $500+), apply credits to the appropriate bills. This often clears a surprising amount of "old A/P" in one move.

6. Fix direct postings to A/P
   If the aging and Balance Sheet still don’t match, run a General Ledger report filtered to the A/P account(s). Look for:

   • Journal entries hitting A/P without a vendor name
   • Bill payments or checks coded directly to A/P
   • Manual adjustments from prior accountants

   Reclassify those entries to proper expense or liability accounts, or convert them into proper bills/credits where appropriate.

7. Re-run reports and document
   After adjustments, re-run the A/P Aging and Balance Sheet as of the same date. Confirm they now tie. Document what you did, especially if you touched prior periods or tax years.

Building this into your standard review

The firms that stay sane on cleanups don’t "remember" to check A/P—they bake it into their diagnostic workflow.

At intake or pre-quote, run a basic diagnostic: A/P Aging vs Balance Sheet, count of old bills, negative vendors, and vendors with offsetting bills and credits. Tools like CleanupOwl can hand you that list automatically so you know, before you price or promise a timeline, how deep the A/P cleanup will go.

During the actual engagement, your workpaper or checklist should have explicit lines for:

• A/P Aging ties to Balance Sheet as of [date]
• Old bills over [X] days reviewed and resolved
• Negative vendor balances reviewed and resolved
• Large offsetting bills/credits applied

That way, every file gets the same level of scrutiny, whether a senior partner or a new staffer is doing the work.

The patterns you’ll keep seeing in client files

Not every file needs a full forensic dig. If most bills are current, there are no negative vendors, and the A/P Aging total matches the Balance Sheet within a dollar or two, you can treat A/P as low-risk and move on.

But once you see old balances, negative vendors, or a mismatch between aging and Balance Sheet, you’re in "don’t skip this" territory. That’s when a structured cleanup plan and clear documentation matter.

Making this part of your cleanup playbook

A/P aging cleanup deserves its own line on your standard QBO diagnostic checklist. It’s one of the fastest ways to gauge how much untangling a file will need and how reliable the liabilities are.

Run the A/P Aging vs Balance Sheet comparison early, not after you’ve already quoted and started. A diagnostic tool like CleanupOwl can run that check before you touch the file and flag old bills, negative vendors, and offsetting balances so your team isn’t hunting them down manually.

If you’re a business owner reading this, this is exactly the kind of question to ask your accountant: "Does my A/P aging actually tie to my Balance Sheet, and have we cleared old and unapplied vendor balances?" If they’re using a diagnostic tool such as CleanupOwl, they should be able to show you that reconciliation in black and white.

Once you’ve cleaned a file, keep this check in your recurring review process—quarterly or at least annually—so old bills and unapplied credits don’t quietly pile up again.