Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group
Key Takeaways
- The AR aging report works as a live collections worklist that maps each aging bucket to a specific action.
- Prioritize collections by combining age, dollar amount, customer payment history, and dispute status instead of relying on age alone.
- Maintain a weekly collections worklist with named owners and dated next actions for every overdue balance.
- Escalate on a fixed schedule with prepared language and scripts so follow-up stays consistent.
- Condesa Financial provides ex-Big 4, nearshore fractional CFO and outsourced accounting support to run this collections workflow for SMEs.
Before You Begin: Use the Aging Report as a Live Worklist
The aging report is a live collections worklist that changes every time a payment posts, a dispute opens, or a promise date slips. Treating it as a static month-end document leaves cash trapped in buckets nobody owns. Teams that use it as an operational tool see faster collections and fewer surprises.
Standard bucket conventions in QuickBooks Online and Xero follow the Current, 1–30, 31–60, 61–90, and 90+ days past due structure, though QuickBooks Online’s official documentation labels the final bucket as “91 and Over.” Buckets should match actual payment terms. On net 45, the first late flag appears at day 46, not day 31.
Before running the weekly routine, four prerequisites must be in place. Clean customer records and accurate invoice dates determine whether the report is trustworthy. A named collections owner ensures someone is accountable for each balance. Access to the general ledger allows the aging report to be reconciled and trusted.
- Clean customer records with accurate contact information
- Accurate invoice dates and payment terms on every open invoice
- A defined collections owner, a named person rather than a shared inbox
- Access to the general ledger for reconciliation
A lean internal team can run the report, send reminders, and log notes. Outside accounting, FP&A, or fractional CFO support becomes helpful when the books span multiple entities, receivables cross borders, dispute patterns trace back to billing failures, or the 90+ bucket keeps growing despite internal effort. Condesa Financial Group fits these situations as a price-competitive, nearshore, ex-Big 4 fractional CFO and outsourced accounting firm for SMEs, delivered from Panama and Mexico City, time-zone aligned and English-fluent. Condesa runs this collections workflow for clients across a range of accounting and payroll platforms.
Get help setting up your AR worklist
How To Use an Accounts Receivable Aging Report for Collections: 8 Steps
Step 1: Read the AR Aging Report Buckets for Collections Action
Each bucket maps to one specific action, and every balance should have a next step assigned. The bucket-to-action framework is:
- Current: Monitor only. Send a pre-due reminder where terms allow. No collections contact.
- 1–30 days past due: Send a friendly reminder confirming invoice receipt and request a payment date.
- 31–60 days past due: Follow up directly with the account owner. Identify and resolve any dispute blocking payment.
- 61–90 days past due: Escalate with a formal notice and firm deadline. Discuss a payment plan.
- 90+ days past due: Send a final demand. Review credit hold and consider third-party involvement.
Completion looks like a bucket-to-action map the team can recite without opening a policy document.
Step 2: Prioritize Collections by Risk, Not Age Alone
Age alone misdirects effort. A $12,000 balance with no payment history needs a different response than a long-term client’s single $250 invoice that is 10 days late. Rank accounts within each bucket by layering four signals: age, dollar amount, customer payment history, and dispute status.
A useful weekly concentration check divides 60+ day AR by total AR. Companies with weak collections discipline routinely see 20–30% of AR concentrated in 60+ day buckets. Calculate this ratio weekly, not monthly. Switching from monthly to weekly tracking catches deteriorating trends 3–4 weeks earlier, when accounts are still easily collectible.
Separate “cannot pay” from “will not pay.” Hardship cases need a payment plan or forbearance. Strategic defaulters need firmer and earlier escalation. A model that treats both the same routes hardship cases into aggressive outreach and lets strategic defaulters wait. Completion looks like a ranked list, not a sorted report.
Step 3: Build the Collections Worklist
The collections worklist converts the aging report into assigned work. Every row ends in a dated next action, which separates a live worklist from a sorted report. The worklist uses these column headers:
| Customer | Balance | Days Past Due | Dispute Status | Last Contact | Promise Date | Next Action |
|---|---|---|---|---|---|---|
| Meridian Logistics | $8,400 | 47 | None | 2026-09-15 — email sent | 2026-09-26 | Call AP manager if no payment by 9/26 |
| Crestview Partners | $3,200 | 22 | Invoice disputed — wrong PO | 2026-09-18 — dispute logged | — | Send corrected invoice by 9/23 |
| Halcyon Media | $15,750 | 78 | None | 2026-09-10 — voicemail left | 2026-09-30 | Formal notice; escalate to CFO if no response by 9/24 |
Maintain the worklist weekly. Refresh balances from the aging report, carry forward open disputes, update promise dates the moment a customer commits, and close rows only when cash is applied to the specific invoice. “We will pay soon” is not a usable forecast. Ask for date, method, and remittance detail. Completion looks like every overdue balance with a named owner and a dated next action.
Get help running your collections workflow
Step 4: Use Escalation Language by Bucket
Ready-to-send language removes the hesitation that stalls follow-up. Escalate on a schedule. Each step fires on a calendar date rather than when an overdue invoice finally becomes annoying. The table below fixes the action, channel, and completion signal for each bucket so no one has to improvise.
| Bucket | Primary Action | Contact Channel | Completion Signal |
|---|---|---|---|
| 1–30 days past due | Confirm invoice receipt; request payment date | Customer confirms date, method, and remittance detail | |
| 31–60 days past due | State no payment received; request contact by specific date; offer payment arrangements | Email + phone if no response after 7–10 days | Payment received or payment plan agreed in writing |
| 61–90 days past due | Formal notice with firm deadline and stated consequence; escalate to decision-maker | Phone call + formal written notice | Payment commitment from finance manager or controller |
| 90+ days past due | Final demand with decision point; credit hold review; third-party consideration | Multi-channel: email, phone, certified letter | Payment received, payment plan signed, or account placed externally |
1–30 days — email template: “Hello [Name], our records show invoice [number] for [amount] was due on [date]. Please confirm the payment date or let us know if you need another copy of the invoice.”
31–60 days — email template: Subject: “Second Notice: Invoice #[NUMBER] Now [X] Days Past Due.” Body: “No payment has been received for invoice [number] totaling [amount], now [X] days past due. Please contact us by [specific date] to confirm payment or discuss arrangements to avoid account disruption.”
61–90 days — call script: “This is [Name] from [Company]. I am calling about invoice [number] for [amount], now [X] days past due. We have sent two notices without a response. I need to speak with your finance manager today to confirm a payment date. If we do not hear back by [date], we will need to place the account on credit hold and escalate formally.”
90+ days — final demand: Subject: “URGENT: Final Notice Before Account Escalation — Invoice #[NUMBER].” Body: “Invoice [number] for [amount] is now [X] days past due. This is our final notice before referring the account to our collections department. Please respond within 10 business days with payment or a signed payment plan.”
Step 5: Record Collections So Invoices Clear the Report
When a customer pays, the journal entry is: debit Cash, credit Accounts Receivable. In QuickBooks Online, apply the payment to the specific open invoice. A payment entered as a bank deposit reduces the bank balance correctly but never applies against the open invoice. The invoice stays open, the customer gets chased again, and the aging report overstates what is actually owed.
Completion looks like cash posted and the invoice cleared from the aging report. If a previously written-off account later pays, record the recovery in two steps: first reinstate the receivable by debiting Accounts Receivable and crediting Allowance for Uncollectible Accounts, then record the cash collection by debiting Cash and crediting Accounts Receivable.
Step 6: Reconcile AR Aging to the General Ledger
The AR aging report total must tie to the AR control account in the general ledger as of the same date. Reconciling to the wrong date makes the comparison meaningless. The reconciliation process follows seven steps:
- Pull the AR aging report as of period-end.
- Pull the GL AR control account balance as of the same date.
- Calculate the variance: AR subledger total minus GL AR balance.
- Investigate the variance line by line.
- Post correcting journal entries with documented explanations.
- Re-run both reports to confirm they agree.
- Review the aging report for 60+ and 90+ day invoices to prioritize collections, payment plans, or write-offs.
Common causes of variance include payments posted to the GL but not applied to invoices, invoices in the subledger not yet posted to the GL, unapplied credit memos, write-offs recorded in one system only, and period-end timing differences. Set a materiality threshold, for example any variance greater than $50 or 0.1% of total AR, and document it so it is applied consistently. Completion looks like a zero variance and a signed-off reconciliation.
Get support reconciling AR and the GL
Step 7: Apply the 10 Rule for Accounts Receivable
The 10 rule has two distinct usages, and practitioners should clarify which one a colleague means before applying it.
The primary usage is a collections prioritization heuristic. Focus on the top 10 customers or the top 10% of balances that represent the majority of overdue AR. Once the overdue portion of a customer’s balance crosses the 10% threshold of their total receivables, collections should move beyond invoice-by-invoice chasing to reviewing the customer as a whole, particularly when the aged balance is concentrated in 90+ day buckets. This is also the cross-aging threshold lenders use when calculating a borrowing base. If more than 10% of a single customer’s total receivables are overdue, the entire account may be reclassified as ineligible.
The second, looser usage sets a cash-flow target: collect at least 10% of total outstanding AR each month. Sources disagree on which meaning is canonical, so the practical step is to ask which definition is in use before building a target around it.
Completion looks like a short list of accounts that receive disproportionate attention each week, with owners and next actions attached to each.
Step 8: Run a Weekly Collections Meeting and Connect to Cash Flow
Once the worklist and escalation language are in place, the remaining piece is cadence. A standing 30-minute weekly meeting is what keeps the worklist alive. The agenda covers five items:
- Review the worklist and refresh balances from the aging report.
- Update promise dates for any customer who committed since last week.
- Escalate open disputes and assign resolution owners.
- Assign next actions for every overdue balance.
- Note what slowed collections last week and assign one corrective action.
The Current and 1–30 day buckets represent near-term expected cash. Promise dates sharpen the timing of that forecast. DSO is the lagging indicator that tells the team whether the cadence is working. DSO averages collection time across the entire receivables portfolio, while the aging report breaks it down customer by customer. DSO tells the team how the program is performing overall. The aging report tells the team which specific customers are causing the problem. Completion looks like a standing meeting with a written agenda and a refreshed worklist every week.
Common Mistakes, Watch Outs, and Troubleshooting
Even with the routine in place, the same failure patterns show up across teams. The most common mistakes in AR collections management are:
- Treating the aging report as a static document rather than a live worklist
- Failing to assign a named collections owner
- Skipping promise dates and accepting “we will pay soon” instead of a date
- Letting disputes sit unresolved while the invoice ages
- Recording payments without applying them to specific invoices
- Reconciling AR aging to the GL only at year-end
Several warning signs do not appear in the aging report itself:
- A growing 90+ bucket means write-offs not yet recognized, collection inefficiency, deteriorating customer quality, or all three.
- A customer who looks current can file for bankruptcy before the deterioration shows up in the report. The gap between when a customer starts deteriorating and when it shows up in the aging report is where credit losses actually occur.
- A sudden jump in a customer’s current balance can mean they are buying more because they cannot get credit elsewhere.
Troubleshoot an aging report that will not tie to the GL by checking unapplied cash first, then unposted invoices, then credit memos and write-offs recorded in one system only. If reminders go unanswered, verify the right person is being contacted and move from the day-to-day contact to the finance manager or controller. If the same customers are repeatedly late, the problem sits upstream in credit terms or billing accuracy rather than in collections effort.
Weak documentation and unreliable external support often cause collections breakdowns. An underperforming accountant can leave these gaps undetected because of the information asymmetry between non-technical owners and the accountants who serve them. Owners often cannot diagnose the damage until it is significant.
Talk with Condesa about fixing AR issues
How To Evaluate Progress
Evaluate whether the workflow is working through process maturity rather than promised outcomes alone. Indicators of a maturing collections process include cleaner customer records, clearer reporting, faster turnaround on overdue invoices, stronger documentation of every contact, fewer unresolved disputes, and improved management visibility into AR.
Track two operational metrics weekly. The first, the 60+ day concentration ratio introduced in Step 2, shows whether the portfolio is aging faster than you are collecting. The second, promise-to-pay performance, measures kept promises divided by promises due and shows whether customers honor the commitments your team records. A declining promise-to-pay rate signals either that customers are not being held to commitments or that the team is accepting vague commitments rather than specific dates and amounts.
Advanced Considerations and Next Steps
Teams that run the weekly routine reliably encounter additional complexity as the business grows. Cross-border collections introduce differing legal frameworks, currency risk, and enforcement challenges with no universal standard. Statutes of limitations and legal remedies vary by country. For new international relationships, export credit insurance or letters of credit may be appropriate.
System upgrades and automation of reminder sequences can reduce manual reporting time significantly. Internal controls require segregation of duties between the person applying cash and the person reconciling. Having one person perform both functions creates a controls gap that lets errors and fraud go undetected. Audit readiness requires a maintained allowance for doubtful accounts under GAAP. Apply aging-method percentages consistently so the allowance is defensible.
For SMEs that need this workflow to run reliably without building an internal finance team, Condesa Financial Group provides ex-Big 4, nearshore accounting and fractional CFO oversight across a four-layer stack: accounting and financial operations, FP&A, financial modeling, and fractional CFO oversight delivered personally by the founder. The model is price-competitive because Condesa partners with an accounting firm based in Panama, staffed with professionals who are deeply familiar with US accounting practices, delivering Big 4-caliber work at well-below-US-market rates for SMEs in high-cost cities including New York, Chicago, and San Francisco.
The financial rigor behind this model is documented. Condesa built financial models for an Ecuador-based real estate developer raising capital across two projects, one at $20M and one at $80M, and both rounds closed successfully. That level of modeling discipline applies directly to the collections and cash flow work Condesa runs for SME clients every week.
Explore fractional CFO support for AR
Frequently Asked Questions
How Do You Record a Collection of Accounts Receivable?
Debit Cash and credit Accounts Receivable, and apply the payment to the specific open invoice in QuickBooks Online. See Step 5 for the full journal entry and the two-step recovery process for written-off accounts.
How Do You Reconcile AR Aging to the General Ledger?
Pull both reports as of the same date and compare the totals. See Step 6 for the seven-step reconciliation process, common variance causes, and the materiality threshold.
What Is the 10 Rule for Accounts Receivable?
The 10 rule has two meanings in practice. See Step 7 for the two meanings of the 10 rule and the cross-aging threshold.
How Often Should You Run an AR Aging Report for Collections?
Most businesses with meaningful invoice volume should run the report weekly on the same day and at the same time. Monday morning is the standard choice because it creates a clear worklist for the days ahead. Very small teams can use a monthly cadence, but monthly timing is often too slow to catch accounts before they age into harder buckets. High-volume businesses with shorter collection cycles may run the report daily. The frequency matters less than the action protocol attached to each threshold.
What Is the Difference Between an AR Aging Report and DSO?
DSO is a single average figure that tells the team how the receivables portfolio is performing overall. It blends payment terms and collections performance into one number. The aging report breaks the same receivables down customer by customer, showing which specific accounts are causing the problem. See Step 8 for the full explanation of how DSO and the aging report work together.
When Should an SME Bring in a Fractional CFO for Collections Oversight?
Triggers include a 90+ bucket that keeps growing despite internal follow-up, disputes that trace back to billing process rather than customer behavior, receivables that span multiple entities or currencies, or a collections cadence that no one owns internally. Additional triggers include a growing reliance on credit lines to cover payroll gaps caused by slow-paying customers, an aging report that will not reconcile to the GL, and an incumbent accountant who cannot explain the variance. These situations create the most risk for non-technical owners, and fractional CFO oversight paired with ex-Big 4 accounting closes that gap.
Conclusion
The AR aging report becomes a collections tool only when it functions as a live worklist rather than a static document. The weekly routine is straightforward. Read the buckets and map each one to a specific action. Prioritize by age, dollars, payment history, and dispute status. Build the worklist with a named owner and a dated next action for every overdue balance. Escalate on a schedule with prepared language. Record payments correctly so invoices clear from the report. Reconcile the aging report to the GL so the numbers stay trustworthy. Meet weekly to connect collections to cash flow forecasting and DSO.
59% of small businesses have at least some invoices overdue by 30 days or more, and collection rates deteriorate sharply with invoice age, from 90–95% at 0–30 days past due to below 20% past 180 days. The cadence described here keeps balances in the recoverable range.
For SMEs that need this workflow run reliably with ex-Big 4 accounting, fractional CFO oversight, and a team that is time-zone aligned and English-fluent, Condesa Financial Group delivers that support at a price point built for companies with 1 to 100 employees.
Schedule a call with Condesa Financial
