AP Aging Report: How Bookkeepers Read the...

AP Aging Report: How Bookkeepers Read the 0/30/60/90+ Buckets (2026)

It's the 14th of the month. You're running your mid-month AP check for a landscaping client and you pull the AP aging report. The first three buckets look reasonable. Then you hit the 90+ column: $14,200 sitting in five vendor balances that haven't moved in three months.

None of these are new. They were there last month. And the month before. Your client has been paying current bills while four old ones pile up, including $3,800 to a supply vendor your client stopped using in February.

That $14,200 isn't just a number. Two of those balances are probably legitimate liabilities your client is avoiding. One is likely a credit the vendor already issued that never got entered. And at least one is a disputed invoice your client mentioned once and then forgot to follow up on. The AP aging report told you all of this in one view. Knowing what to do next is the bookkeeper skill.

What is an AP aging report and how do you read it?

An AP aging report is a snapshot of every open vendor balance organized by how long it has been outstanding. It groups unpaid bills into time buckets, typically 0-30 days, 31-60 days, 61-90 days, and 90+ days, so you can see at a glance which vendors are current, which are past due, and which have been sitting unpaid long enough to signal a dispute or write-off. To read it: current bucket (0-30) = healthy; 31-60 = needs a payment plan or vendor call; 61-90 = there's a reason this hasn't been paid and you need to find it; 90+ = something is wrong, whether a dispute, a missed credit, or a liability the client is pretending doesn't exist. The total of all open balances must match your AP control account on the trial balance. If it doesn't, you have a posting error to find before you close.

Key Takeaways

0-30 days is healthy. Bills within terms need scheduling, not escalation. Your job is to confirm due dates and batch payments before late fees trigger.
31-60 days needs a vendor call or internal explanation. Late AP doesn't fix itself. Find out whether it's a cash flow hold, a missing approval, or an owner who hasn't gotten around to it.
61-90 days is a relationship signal. A balance this old usually means a dispute the client is avoiding, a vendor they stopped working with, or an invoice the owner is contesting. Each needs a direct conversation.
90+ days is almost never just slow-pay. It's a write-off candidate, an unapplied vendor credit, or a disputed invoice. Address each balance individually before it reaches the vendor's collections process.
AP aging above 10% in the 90+ bucket signals broken AP discipline. One or two stuck balances are normal. If 10% or more of total AP is 90+, the monthly close process needs a reset.
AP aging feeds both cash flow forecasting and 1099 roll-up. The same aging data that tells you when cash goes out tells you which vendors are 1099 candidates. Clean aging means both outputs are accurate.

How to Run the Report in QBO, Xero, and Growthy

The AP aging report is a standard output in every major accounting platform. Here's how to pull it in the three most common tools.

QuickBooks Online: Reports → All Reports → What you owe → Accounts Payable Aging Summary (or Detail). Run it as of the last day of the period you're reviewing. Change the aging period from the default 30-day buckets if your client needs different intervals. Use the Detail view when you need to investigate specific vendor balances: it shows individual bills rather than vendor totals. Export to Excel if you're doing bucket analysis across multiple clients.

Xero: Accounting → Reports → Aged Payables Summary. Run it as of a specific date. Toggle between summary (total per vendor) and detail (individual bills). Xero calculates aging from the invoice due date by default, not the invoice date. Check this setting if your buckets don't match expectations. If a vendor has both open bills and unapplied credits, Xero shows a net balance. Confirm whether the gross bills are accurate before acting on the net.

Growthy: The AP aging view is part of the close checklist. Run it from the client workspace after bill entry is complete for the period. Growthy flags vendors with 90+ day balances that have a 1099-eligible status set, so you can cross-reference aged AP with potential 1099 candidates in one step rather than two separate reports. The subledger-to-GL tie-out runs alongside the aging view as part of the monthly close, so you're confirming bucket totals and account balance in the same workflow. See the full AP feature set for how it fits the close workflow.

One rule that applies across all platforms: run the AP aging report AFTER vendor statement reconciliation, not before. If you haven't reconciled vendor statements first, the aging report will show you stale or incorrect balances. The report is only as accurate as the underlying data.

The 4 Buckets and What Each Means

The AP aging report's usefulness isn't in the numbers. It's in what each bucket represents about the payment relationship between your client and their vendors.

Here's the mental model. Each bucket is a different question.

0-30: Is this getting paid before the due date?
31-60: Why hasn't this been paid yet?
61-90: What's actually going on here?
90+: Is this still a real liability?

These are four different conversations, with four different levels of urgency, and four different action paths.

0-30 Days: Normal — Pay on Terms or Take Discounts

Bills in the 0-30 bucket are current. They're within standard net-30 or net-15 terms. Your job in this bucket is scheduling, not investigation.

Two things to check:

Due dates before early payment discounts expire. Some vendors offer 2/10 net 30 terms: 2% discount if paid within 10 days, full amount due at 30. For a client with predictable cash, taking a 2% discount is a 36% annualized return on that cash. Check which vendors offer early payment terms and batch those payments first.

Bills that are current but approaching the bucket boundary. A bill entered on the 3rd with net-30 terms is current today but past due on the 2nd of next month. If your monthly close falls mid-cycle, bills near the 30-day mark need to be on the upcoming payment batch, not rolled into next month's review.

The 0-30 bucket rarely needs a client conversation. If a client regularly runs 80%+ of their AP in this bucket, their payment discipline is solid. Note that in the session log and don't create noise about it.

31-60 Days: Late (Trigger Vendor Follow-Up)

Bills in the 31-60 bucket are past due. They didn't get paid on terms, and the reason matters.

The common causes:

Owner hasn't approved the payment. Some clients want to sign off on every bill before payment. If you batch bills for approval and the owner sits on them, bills slide from current into late without anyone doing anything wrong from a process standpoint. But the vendor is still waiting. The fix is a tighter approval turnaround expectation, not more follow-up from you.

Cash flow is tight. The client has the liability but is managing cash and decided to pay some vendors late this cycle. This is your client's business decision. Your job is to flag it. "Your AP balance with [Vendor] is now 45 days past due; they may add late fees at 60 days." Document that you raised it.

The bill is in dispute. Sometimes a bill sits in 31-60 because your client has a problem with it but hasn't told the vendor yet. Ask directly: "Is there anything on this one that's being sorted out?" An undisclosed dispute explains a lot of slow-pay patterns.

The client forgot. Less common with regular clients, but it happens. A bill entered late, an approval email missed, an owner on vacation. In these cases, a simple reminder is all it takes.

How to flag 31-60 day balances without sounding alarmist: keep it factual and action-oriented. "The Staples balance is at 45 days. I'll add it to next week's payment batch unless you want to hold it." That's it. You're not predicting disaster. You're asking for a decision.

61-90 Days: Relationship Signal

A balance in the 61-90 bucket is almost never just paperwork delay. At 61-90 days, something happened.

The three real reasons a balance reaches this age:

A dispute the client is avoiding. Your client received bad goods, got overcharged, or has a quality problem with the work done. Instead of calling the vendor, they stopped paying the invoice and hoped it would resolve itself. It won't. The vendor is calling accounts receivable on their end. At 61-90 days, you need to name the dispute clearly: "This looks like it might be on hold because of an issue with the delivery in February. Do you want me to request a credit memo, or is this still being worked out?"

Your client stopped using the vendor. The relationship ended, but the final invoice never got paid or formally disputed. These are uncomfortable conversations. The client may not even remember the balance exists. Pull up the invoice detail and show it to them: "There's an open balance from March with [Vendor]. Looks like your last transaction. Do you want to pay this out, request a credit, or dispute it?"

A timing or posting error. Occasionally a 61-90 day balance is a bill that was paid but the payment wasn't recorded, especially credit card payments that went directly to an expense account instead of clearing the AP module. Before escalating to the client, confirm the bill wasn't paid by checking bank or credit card statements for the vendor name and amount. A $1,200 balance that was actually paid two months ago is a recording error, not a vendor relationship problem.

How to flag 61-90 day balances to a client: be direct but not accusatory. "You have three balances in the 61-90 day range. I want to make sure we're not getting into late-fee or vendor-credit territory. Can we go through these?" That framing makes it a practical review, not a performance conversation.

90+ Days: Write-Off, Uncredited Returns, or Disputed Invoices

The 90+ bucket is where you need to treat every balance as its own case. There's no batch-treatment here.

The three categories you'll find:

Disputed invoices that never got resolved. The client has been avoiding this vendor call for three months. At this point, the vendor may have turned it over to collections or written it off on their end. Your client still shows the liability. You need a decision: pay it, dispute it formally, or get documentation that the vendor has waived it. If the vendor has issued a credit and your client never entered it, you may find a zero-net balance once the credit is posted. If the vendor is still expecting payment, your client needs to make a call.

Uncredited returns. Your client returned merchandise or had work redone, the vendor agreed to issue a credit, but the credit memo never came through or never got entered. The AP aging shows the original invoice as 90+ days past due when the real net balance may be zero or minimal. Pull the vendor statement (see vendor statement reconciliation) and confirm what the vendor's records show. If they show a credit, request the credit memo in writing and enter it.

Write-off candidates. A vendor your client stopped doing business with three years ago has a $240 balance rolling over every month. The vendor hasn't called. Your client doesn't remember the transaction. This is a write-off candidate. Document the decision (note in the vendor record, get verbal sign-off from the client), debit AP and credit Other Income (or the original expense account, depending on materiality and your firm's policy), and clear it from the aging report.

One thing 90+ balances are almost never: just a slow-pay situation your client will eventually get around to. If a balance is 90+ days old and your client is still actively doing business with that vendor, there's a reason it hasn't been paid. Find it.

Keeping track of resolution status: when you're working through the 90+ bucket across 12 clients, make a note in the vendor record or the session log for each balance. "Contacted client 5/14 re: Acme Supply $3,800, client reviewing invoice dispute, expects resolution by end of month." Otherwise, you'll be reconstructing context at the next close.

The Monthly Workflow: AP Aging to Client Conversation to Action

The AP aging report is not a report you run and file. It's a decision-support tool that drives three types of action.

Step 1: Run after vendor statement reconciliation. Aging data is only useful if the underlying balances are accurate. Run vendor statement recon first (see vendor statement reconciliation), then pull the aging report. In that order, not reversed.

Step 2: Bucket analysis. Look at the total in each bucket. Then look at the percentage each bucket represents of total AP. A client with 70% of AP in 0-30, 20% in 31-60, 8% in 61-90, and 2% in 90+ is in reasonable shape. A client with 40% in 90+ has a systemic problem that goes beyond the aging report.

Step 3: Flag to client by bucket. Not every bucket needs a message. 0-30: no message needed (just batch payments). 31-60: one-line note identifying the specific balances and asking for a decision. 61-90: a direct question about each balance with context. 90+: individual treatment per balance.

Step 4: Record decisions. When your client gives you direction on a 61-90 or 90+ balance, log it. "Pay it," "dispute it," "waiting on credit memo," "write-off approved." You'll need this at next month's close.

Step 5: Tie to the GL. After aging review, confirm the AP aging summary total matches the AP control account on the trial balance. This is the close confirmation. If they don't match, find the discrepancy before signing off. Full reconciliation procedure: accounts payable reconciliation.

How AP Aging Feeds Cash Flow Forecasting and 1099 Roll-Up

The AP aging report does two jobs beyond vendor management.

Cash flow forecasting. The 0-30 bucket is your client's upcoming AP cash requirement. Bills in 0-30 will be paid in the next 30 days. Bills in 31-60 are overdue obligations that need cash now. A clean AP aging report tells you exactly how much cash needs to go out the door this month and next: no guesswork, no surprises for the owner.

This is a practical conversation for clients who ask "how much cash do I need to keep in the account?" Look at 0-30 plus 31-60, subtract any scheduled inflows from the AR aging, and you have a working short-term cash position. It's not a full cash flow forecast, but it's the most accurate 30-60 day cash demand number you can give quickly.

1099 roll-up. Every vendor in your AP aging report with a 1099-eligible flag is a potential 1099 candidate. AP aging gives you a natural cross-reference: any vendor with 90+ day balances and a 1099 flag needs special attention. If your client paid a contractor $3,400 this year but there's still a disputed $800 invoice sitting in the 90+ bucket, the 1099 total should reflect only confirmed payments, not the disputed balance.

Growthy cross-references 1099-eligible vendor status with the AP aging view at month close, so the flag shows up alongside the aged balance rather than requiring a separate report. For clients with vendors near the $2,000 1099-NEC threshold for 2026, this is particularly useful since an unresolved disputed invoice can push a vendor over or under the reporting threshold. See the full 1099 filing workflow for how clean AP data feeds January filing.

Also worth noting: if your client pays vendors via Stripe, PayPal, or Venmo, those payments don't flow through your AP module. The payment processor may file a 1099-K directly. The payment reconciliation workflow covers how to net these so you're not double-reporting vendor payments that went through both AP and a payment platform.

Start Clearing the 90+ Bucket

The AP aging report is one of the fastest reads in bookkeeping. Running it takes two minutes. Knowing what to do at each bucket is the skill.

0-30: schedule and pay. 31-60: ask why and get a decision. 61-90: find the real reason and address it directly. 90+: treat each balance as its own problem until it's resolved.

Most of the time, the bookkeeper who clears the 90+ bucket is the one who makes the client call comfortable: not alarming, not accusatory, just direct. "Here's what I'm seeing. Here's what I need from you."

If you want to see how Growthy handles AP aging, 1099-eligible vendor flagging, and GL tie-out as part of the monthly close workflow for firms managing 8-25 clients, get started with Growthy. Alpha pricing is $99/mo (5 firm cap). Standard pricing starts at $149/mo annual.