How To Use an AR Aging Report for Collections

Published by Andrew Cohen, CFA, CPA on September 23, 2026

Key Takeaways

An AR aging report turns open invoices into a prioritized collections worklist by bucketing balances by days past due, so teams focus effort on the highest-risk amounts first.
Always age invoices from the due date to ensure collectors chase balances that are truly overdue rather than those still within terms.
Every overdue invoice needs an owner, a specific next action, and a follow-up date before the week begins to prevent lines from going dormant.
Follow a structured escalation sequence with written reminders at 1–30 days, calls at 31–60 days, manager escalation at 61–90 days, and formal demand or outside referral at 90-plus days, while triaging genuine disputes separately from refusals to pay.
Condesa Financial is the best outsourced accounting and fractional CFO partner for turning an accounts receivable aging report into collected cash because it runs the collections discipline, including prioritization, calls, dispute triage, and promise-to-pay tracking, on top of QuickBooks Online with ex-Big 4 nearshore professionals.

Start Here: Read The AR Aging Report For Collections

A standard AR aging report groups every open invoice into five buckets: current (not yet due), 1–30 days past due, 31–60 days past due, 61–90 days past due, and 90-plus days past due. Each row shows customer name, invoice number, invoice amount, due date, days outstanding, and the aging bucket the invoice falls into.

The single most important setting to verify before acting on any report is whether invoices are aged from the invoice date or the due date. Invoice-date aging starts the clock when the invoice is issued: an invoice raised 45 days ago on Net 30 terms lands in the 31–60-day bucket even though it is only 15 days past due, whereas due-date aging places the same invoice in the 1–30-day bucket, which is where a collector would expect it. For collections, always use due-date aging. The credit losses illustration in FASB Accounting Standards Update 2025-05 sorts balances as current, 1 to 30 days past due, 31 to 60 days past due, 61 to 90, 91 to 120, and more than 120 days past due, with every band measured from the due date.

Before reading the report, confirm three prerequisites are in place: a clean customer list with agreed terms per invoice, a system of record (QuickBooks Online, Xero, or NetSuite), and one named person accountable for working the list.

A healthy AR aging profile keeps the large majority of its balance in the current and 1–30-day buckets, with very little past 90 days. No published benchmark for a “good” percent-current aging figure survives differences in industries, customer types, and payment terms, so a borrowed target is worth less than the company’s own trend line. The direction of movement across buckets is the warning sign, not the absolute level on any single report.

Internal bookkeeping is sufficient when someone with authority reviews the report weekly, owns every overdue line, and can escalate. When no executive layer exists to set escalation policy, or when the same invoices reappear month after month, outsourced accounting with fractional CFO oversight becomes the appropriate next step. For more on preparing the report itself, see How To Prepare An Accounts Receivable Aging Report.

Talk With A Fractional CFO

The Six-Step AR Aging Report Collections Workflow

Prioritize Which Overdue Invoices To Chase First
Turn The Report Into A Collections Worklist
Run The Collection Sequence
Triage Disputes Versus Refusals To Pay
Track Promises To Pay And Follow Up
Run A Weekly Review Cadence

Step 1: Prioritize Which Overdue Invoices To Chase First

Age is a useful first filter, but it is not the only one. Expected payment dates and missed commitments help identify which past-due invoices need more attention. Sort within buckets rather than treating every invoice in a bucket identically.

Rank overdue invoices by three criteria, applied together:

Oldest Days Past Due. An invoice at 75 days past due on Net 30 terms has been unpaid for over three months past its due date. Data from the Commercial Collection Agency Association indicates roughly 70–80% of 90-day-past-due invoices are still collectible, falling to 45–55% by six months. That matters because recovery odds fall fast with age.
Largest Balance. Large balances in the 31–60-day band come first because they are big, slipping, and still recoverable. The recoverable money often sits in large balances that have not yet crossed into the danger zone, while the oldest, smallest invoices at the tail of the book are usually the least collectible.
Repeat-Offender Status. Among repeat business customers who had paid at least five invoices, 27.4% were never late on a single invoice, while the 24.3% who were late on most invoices generated 51.9% of all late payments. A customer who has broken prior promises or gone quiet should jump the queue regardless of balance size.

In most books, a handful of accounts hold the majority of the aged balance, and that list becomes the week’s worklist.

Step 2: Turn The Report Into A Collections Worklist

The aging report is a snapshot, and the worklist is the operating document. Every overdue line needs an owner and a next action before the week begins, and the fields below exist to make that possible by closing common failure modes where lines go dormant or disputes get missed.

Customer And Invoice Number. Identify the legal entity responsible for payment and tie every action to a specific document, not a general balance.
Invoice Date And Due Date. Show when the obligation was created and the contractual date from which days past due is calculated.
Days Past Due And Amount. Provide the urgency metric, calculated from the due date, and the dollar impact that drives prioritization.
Last Contact Date. Prevent duplicate outreach and show whether follow-up is happening.
Reason For Nonpayment And Dispute Status. Separate disputes, approval delays, and cash difficulty, and flag invoices that should leave the reminder sequence and enter a resolution workflow.
Promised Payment Date And Next Follow-Up Date. Capture the specific calendar date the customer committed to and the date for the next touch so no line goes dormant.
Owner. Name the individual accountable for the next action on this specific invoice line.

Those fields only work if they are enforced, so no overdue line closes without an owner and a next action. Each priority invoice should have a specific next action, owner, and follow-up date so collections efforts do not hinge on one person’s memory.

Get Your Collections Workflow Running

Step 3: Run The Collection Sequence

The escalation ladder matches action to bucket and payment history:

1–30 Days Past Due: Send a written reminder referencing the specific invoice, amount, and due date, and confirm the invoice was received and approved.
31–60 Days Past Due: Make a direct phone call, since this bucket signals a forming pattern and a soft reminder is insufficient. The most productive collection work is often in the 31–60-day bucket for the largest invoices, because those accounts are still responsive and the money is almost certainly collectible.
61–90 Days Past Due: Escalate to a manager or senior relationship owner and send formal written notice referencing contract terms.
90-Plus Days Past Due: Send a formal demand letter, review for credit hold, or refer to outside collections. Illustrative escalation triggers place legal review or third-party collections referral at 90-plus days past due.

The collection call script below centers on a single key outcome, which is a specific promise-to-pay date.

Verify Right-Party Contact. “Am I speaking with [Name], the person who handles accounts payable for [Company]?”
Identify Yourself And State The Purpose. “This is [Your Name] from [Your Company]. I am calling about invoice [Number] for [Amount], which was due on [Due Date].”
State The Balance Neutrally. “Our records show a balance of [Amount] outstanding on that invoice.”
Listen First. “Can you help me explain what is holding up payment on this one?” Then stop talking.
Ask The Key Question. “What date can we expect payment?” Accept only a specific calendar date, not “soon” or “end of month.”
Confirm The Commitment. “So to confirm: [Amount], arriving by [Specific Date], via [Payment Method]. Does that reflect what you are agreeing to?”
Close And Document. “I will send you a written confirmation of that now. If anything changes before [Date], please call me directly at [Number].” Log the amount, date, method, contact name, and next follow-up date in the worklist immediately.

A promise is only as good as its specifics. Get the amount, the exact date, and the method, then repeat all three back and confirm you will send it in writing. Vague commitments break, while a commitment the customer said out loud and received in writing tends to hold.

Step 4: Triage Disputes Versus Refusals To Pay

The decision rule relies on specificity, timing, and documentation. A genuine dispute is specific, raised at the time the issue arises, and supported by contemporaneous evidence, whereas avoidance is vague, raised for the first time only after collection begins, and unsupported by documentation.

When a genuine dispute is identified:

Remove the disputed amount from the standard reminder sequence immediately.
Continue collecting the undisputed balance in parallel. Pausing collection reminders only on the disputed amount while continuing to collect the undisputed balance prevents a $400 quality claim from holding up payment on the other $9,600 of an invoice.
Assign a named internal owner, outside the collections team, to resolve the underlying issue.
Acknowledge the dispute in writing within 24 hours and commit to a resolution date.
Once resolved, issue any credit, confirm the corrected balance and a firm new payment date in writing, and resume the normal collection sequence.

When the objection is vague, raised only after chasing began, and unsupported by any documentation, treat it as a refusal and escalate rather than negotiate. Routine reminders should stop once they are clearly being ignored, moving instead to a formal demand. Generic reminders fired at disputed invoices are a real cash-flow leak and a relationship cost.

Documentation also matters at tax time. Under 26 U.S.C. § 166, a deduction is allowed for any debt that becomes worthless within the taxable year, but sitting in an old aging bucket does not by itself trigger a deduction. Proper dispute documentation protects both the collection effort and any eventual write-off treatment.

Step 5: Track Promises To Pay And Follow Up

Every contact that produces a commitment should result in six fields recorded in the worklist immediately:

The named contact and their authority to release payment
The specific amount committed
The specific calendar date
The invoices the payment will settle
The payment method
The next follow-up date, set for the promised date or one day after

A commitment missing any of the first four, such as “we will process it soon,” should not be recorded as a promise to pay. Send a written confirmation immediately after the call and set a reminder 48 hours before the promised date.

On the promised date, check whether payment was received and applied. If it was not, follow up the same day. Two or three broken promises to pay should trigger a credit review or hold rather than a fourth reminder, since repeatedly broken promises are one of the strongest early indicators of genuine credit deterioration. A broken promise is an escalation trigger and should not result in another routine reminder.

Step 6: Run A Weekly Review Cadence

The AR aging report should be run weekly for active collections and monthly on a fixed date for management review. A workable aging cadence has collections staff reviewing the report weekly for anything past 30 days, finance leadership reviewing aggregate bucket trends and allowance adequacy monthly, and credit policy revisited quarterly or when a customer’s payment behavior changes materially.

The Monday-morning weekly checklist:

Refresh the aging report with a consistent as-of date
Review the worklist and confirm every overdue line has an owner and a next action
Check the over-60 and over-90 share and see whether older buckets are growing or shrinking
Review the promise-to-pay kept rate and confirm whether commitments are being honored
Identify any new invoices crossing into the 31-plus bucket for the first time
Confirm all disputes have an owner and a resolution date

Many teams use a weekly operating review plus a formal month-end view, with a consistent reference date, inspection of material movements, assigned owners, and prompt reconciliation of matched payments. A report pulled on the 5th one month and the 28th the next distorts trend analysis, so the as-of date must be consistent.

Set Up A Weekly AR Review

Common Mistakes And Watch-Outs

Aging From Invoice Date Instead Of Due Date. Invoice-date aging counts from the day the invoice was issued, so an invoice still inside its payment terms can appear in an older column. This causes collectors to chase invoices that are not yet overdue and miss the ones that are.

Chasing The Largest Balance While Ignoring The Oldest. A common collections mistake is working an AR aging report top to bottom alphabetically or chasing only the oldest invoices, because the oldest invoices are often the least collectible while the recoverable money sits in accounts sliding now. Prioritize by a combination of age, balance, and payment history.

Sending Generic Reminders To Disputed Invoices. A disputed invoice left inside a reminder sequence is the single most common way a collections process damages a customer relationship. The moment a query comes back, the invoice should leave the reminder ladder and join a queue with a named owner and a resolution date.

Failing To Record What Was Said On A Call. Inconsistent PTP recording, such as one agent entering amount and date in a system and another using a spreadsheet or free-form notes like “will pay soon,” makes promise-to-pay tracking much harder across hundreds or thousands of accounts. Every call must produce a documented disposition.

No Named Owner Per Invoice Line. When nobody owns a line, nobody follows up, and the same invoices reappear month after month. Often the root cause is an underperforming outsourced accountant who produces the report but never works it.

Treating The Report As A Monthly Artifact. A static spreadsheet AR aging report is out of date the moment it is exported: an invoice that was current on Monday can be 31 days past due by the next review without anyone touching it because the report was run the prior week. Weekly is the minimum operating cadence for active collections.

Unapplied Cash Inflating The Report. Unapplied cash is the most common reason an AR aging report overstates what is owed: the customer paid, the payment landed in the bank, nobody matched it to an invoice, so the invoice stays open in the aging while the cash sits on the account, meaning the business chases a customer for money it already holds.

Fix AR Aging Gaps With Condesa

How To Evaluate Progress

Once the weekly review cadence from Step 6 is running, progress shows up in process maturity before it appears in headline metrics. The indicators below signal that the discipline is working or reveal where it is breaking down.

Cleaner Worklist Discipline. Look for fewer invoice lines without an owner, a next action, and a follow-up date. If every line on the worklist is owned and dated, the process is functioning.

Shrinking Over-60 And Over-90 Share. The share of total receivables sitting past 60 days should trend down over successive weekly reviews. A growing over-60 share while the current bucket stays flat is the signature of a collections function losing ground. For a deeper look at what the aging profile reveals analytically, see How To Do An Accounts Receivable Aging Analysis.

Rising Promise-To-Pay Kept Rate. Well-run B2B collections teams typically achieve a PTP kept rate of 70–85%, while teams recording vague commitments as PTPs often sit below 50%, which is almost always a capture problem rather than a customer problem. A rising kept rate means outreach is producing real commitments, not polite deflection.

Improving Days Sales Outstanding. DSO is a lagging indicator and confirms what the worklist discipline already shows. A rising DSO signals working capital pressure even if every invoice is eventually paid. Track it alongside bucket distribution, not instead of it.

Fewer Repeat Offenders On The Worklist. When the same customers appear in the over-60 bucket month after month, the issue is credit policy rather than collections execution. That is the signal to tighten terms, require deposits, or escalate to a fractional CFO to set policy. See How To Assess Credit Risk With An AR Aging Report for the credit-policy layer.

Review AR Performance With Condesa

Advanced Considerations And Next Steps

Once the weekly collections discipline is running, three adjacent decisions become available.

Tightening Credit Terms. Segmenting chronic late payers and tightening their terms, through deposits, prepayment, or cash-on-delivery, typically shows measurable improvement in the aging profile within one to two billing cycles. This is a policy decision that requires executive authority, not a collections call.

Forecasting Cash From Expected Collections. The aging report, combined with historical conversion rates by bucket, feeds a rolling cash forecast. Aging data should feed cash forecasting by applying historical conversion rates by bucket, for example, assuming 85% of invoices entering the 31–60 bucket collect within 30 days while only 40% of those entering 91-plus ever collect in full. For the full methodology, see How To Forecast Cash Flow With An AR Aging Report.

Coordinating AR With FP&A. When the aging report feeds the cash forecast and the cash forecast feeds the operating plan, AR collections becomes a strategic function rather than an administrative one. A fractional CFO is the appropriate person to set escalation policy, interpret the report strategically, and connect collections performance to the broader financial picture.

Cross-Border And Multinational Considerations. SMEs operating across multiple countries face additional complexity. Statutory payment terms differ, aged balances carry currency risk, and collections must run in local languages. A nearshore, English-fluent, time-zone-aligned team staffed with professionals familiar with both US accounting standards and Latin American markets removes the coordination friction that slows cross-border collections.

Discuss Advanced AR Strategy

Software That Produces The Report Vs. A Partner That Runs Collections

The six-step workflow above assumes someone is actually working the list every week. Most SMEs run that workflow out of QuickBooks Online, NetSuite, or Xero, which are accounting platforms that generate the aging report but do not run the collections discipline on top of it.

QuickBooks Online provides basic invoicing, payment tracking, aged-receivables reporting, and limited automated reminders, but does not provide a complete collections workflow with dedicated escalation, cash application, or dispute automation. Its 2026 updates added AI-drafted reminders for overdue invoices, which is a real improvement but not a collections workflow. QuickBooks Online has no automated dunning or escalation sequence for overdue accounts. It also lacks an AI-driven cash application matching engine for high-volume remittances, and it does not treat disputes and deductions as a first-class workflow. Neither Xero nor QuickBooks Online automatically sends a scheduled communication when an invoice passes its due date, though QuickBooks Online’s 2026 updates added AI-drafted reminders for overdue invoices, so every rung of a collections ladder must either be diarised by a human or handled by a separate automation tool.

NetSuite provides real-time AR aging reports, customer balance summaries, and dashboards that drill from the portfolio level down to a single invoice, and ties every invoice, payment, credit memo, and write-off back to the general ledger with an auditable trail. However, out of the box, NetSuite does not provide an intelligent collections worklist that tells each collector whom to contact today, in what order, through which channel, with what message, and what to do next. Scheduled dunning in NetSuite requires the Dunning Letters SuiteApp, a separate product with implementation effort estimated at 4 to 6 weeks by consultancy Anchor Group. NetSuite’s native dunning has hard operational ceilings: a dunning procedure tops out at 15 levels, batch print and email jobs are capped at roughly 100 letters at a time, and the Dunning Letters SuiteApp cannot detect bounced emails. NetSuite has no native structured dispute routing or promise-to-pay tracking.

Xero’s US pricing tiers are Early at $27/month, Growing at $59/month, and Established at $97/month after a first-six-months promotional rate, with the Early plan capping invoicing at 20 invoices, which is a hard volume constraint for SMEs with high transaction counts. Xero provides aging and invoicing but, like QuickBooks Online, includes no collections workflow automation, dunning sequences, or AR aging follow-up tooling beyond basic invoice reminders.

Condesa Financial is the better choice for this query because it runs what the software does not: prioritization logic, collection calls, dispute triage, and promise-to-pay tracking on top of QuickBooks Online (its default US accounting platform) with ex-Big 4 nearshore professionals from Panama and Mexico City, and a fractional CFO who directs the accounting team and answers the harder strategic questions. The platforms are the system of record, and Condesa is the operating layer that turns the report into collected cash.

Work With Condesa Financial

Frequently Asked Questions

How Do You Read An Accounts Receivable Aging Report?

Start by confirming whether the report ages invoices from the invoice date or the due date. For collections, due-date aging is the correct basis because it measures how late a payment actually is relative to agreed terms, not how long the invoice has existed. Then read each row for customer name, invoice number, due date, days past due, and the bucket the invoice falls into. Sort by days past due within each bucket rather than alphabetically. A balance in the 31–60-day bucket from a customer on Net 30 terms is 31 to 60 days late. The same balance from a customer on Net 60 terms may not be late at all if the report ages by invoice date, which is why verifying the aging basis before acting is the first step every time.

How Do You Analyze Aging Of Receivables?

Compare bucket movement month over month. A book where the over-60 share is growing while the current bucket stays flat is losing ground even if total AR looks stable. Check concentration, since a large aged balance held by two customers is a relationship or process problem with a known cure, while the same balance spread across two hundred small accounts is a policy problem. Separate disputes from true delinquency, because an invoice in the 90-plus bucket due to an unresolved pricing error is a different problem from one where the customer has simply stopped responding. The roll rate, meaning the share of last month’s 1–30-day balance that moved into 31–60 days this month rather than being paid, is the most useful derived figure because it shows collections losing ground before the totals reveal it.

What Is A Good AR Aging Percentage?

As noted earlier, no universal benchmark survives differences in industries, customer types, and payment terms. A useful qualitative test is to compare the aging profile against your own stated terms: if you offer Net 30 and the large majority of your balance is current or under 30 days past due, the profile is healthy. If a material share sits past 60 days, there is a collections or credit policy gap. The trend matters more than any single snapshot, so a profile improving over three consecutive monthly reviews is more meaningful than a single month that looks clean. Borrowed benchmarks from other industries are rarely applicable.

How Often Should You Run An AR Aging Report?

Run the report weekly for active collections work and monthly for management review. Weekly runs keep the worklist current, and monthly runs let leadership see trends and confirm the allowance for credit losses is adequate. A consistent as-of date is essential, for the reason covered in Step 6.