Accounts Receivable Aging Report Checklist
Monthly workflow a staff accountant or controller runs to produce, analyze, and act on the AR aging report — from sub-ledger tie-out through collections outreach and controller sign-off.
Pre-Close Setup
-
Confirm the AR cutoff date
Lock the cutoff with the controller before pulling the aging. Cutoff drift — including a payment that posted on the 1st in the prior month's aging — is the most common reason aging totals don't tie to the GL.
-
Post all customer payments through cutoff
Pull the lockbox file, ACH receipts, and merchant deposits from the bank feed. Match each receipt to an open invoice in QBO/NetSuite — short-pays and partial payments are easy to mis-apply against the wrong invoice.
-
Apply unapplied cash and open credit memos
Run the unapplied cash report and clear each line — either match to an open invoice or confirm a customer credit. Unapplied cash sitting on the report inflates AR and distorts every aging bucket.
-
Tie AR sub-ledger to the GL control account
The AR aging total must equal the AR control account on the trial balance to the penny. Variances usually trace to JEs posted directly to AR (a bookkeeping anti-pattern) or to bank-feed rules miscategorizing receipts.
Generate the Aging Report
-
Run the AR aging report
Run AR Aging Detail (not Summary) as of the cutoff date. Export to PDF or XLSX and attach below; the detail report is what collections will work from and what auditors will request as the period-end PBC.
Collects file -
Verify bucket definitions match policy
Confirm the report uses Current / 1-30 / 31-60 / 61-90 / 90+ — or whatever the credit policy specifies. Aging by invoice date vs. due date is a frequent setup error in QBO that shifts everything one bucket older.
-
Investigate negative customer balances
A negative balance means a payment or credit memo without a matched invoice. Resolve by applying the credit, refunding the customer, or reclassing to a deposit liability — never let negatives roll forward.
Bucket Analysis
-
Review the 90+ day bucket
Walk every line in the 90+ bucket with the AR clerk. Categorize each as collectible-with-effort, disputed, or likely write-off. Dollars in this bucket drive both the allowance estimate and the collections priority list.
Collects list -
Compare aging trends to prior month
Pull the prior-month aging and compare bucket totals and DSO. A jump in 31-60 this month usually becomes a jump in 61-90 next month — flag the trend before it becomes a write-off conversation.
-
Document disputed invoices and credit holds
Note every disputed invoice with the dispute reason, sales contact, and target resolution date. Disputes left undocumented end up in the allowance estimate by default; tracked disputes can often be cleared with a credit memo or a sales-team call.
Doubtful Accounts Review
-
Pull credit updates on at-risk customers
For any customer with a 60+ balance over $10K, refresh the D&B / Experian Business report or check public bankruptcy filings. A Chapter 11 filing changes the entire collectibility analysis and may require an immediate full reserve.
-
Recalculate the allowance for doubtful accounts
Apply the percentage-of-receivables method by bucket (e.g., 1% current, 5% 31-60, 15% 61-90, 50% 90+) per company policy, then layer specific reserves on identified high-risk accounts. Compare to last month's balance to determine the AJE.
Collects list -
Post the allowance adjustment AJE
Book the entry as Bad Debt Expense / Allowance for Doubtful Accounts. Memo line should reference the supporting workpaper so the auditor can trace the estimate from JE back to the bucket calculation without an email chain.
-
Recommend uncollectible accounts for write-off
Build the write-off recommendation list with customer name, invoice numbers, original date, balance, and reason. Per the credit policy, write-offs above the partner-approval threshold need controller or CFO approval before posting.
Collections Outreach
-
Send dunning notices for 30/60/90+ buckets
Use the tiered template set: friendly reminder at 30, firmer at 60, demand letter at 90+. Suppress customers in active dispute or on payment plans so the automated send doesn't undercut a live conversation.
-
Place collection calls on $5K+ past-due accounts
Phone calls outperform email for high-dollar past-due. Confirm receipt of recent invoices, identify any disputes, and get a committed pay date. Document every commitment — broken promises become next month's allowance line.
-
Log all outreach in the collections tracker
Each contact gets date, channel, person reached, and committed action. The audit trail supports the allowance estimate (good-faith collection effort) and protects the firm if a balance later goes to a collections agency or to litigation.
Collects file
Management Reporting and Sign-Off
-
Draft the AR aging summary memo
One-page memo: total AR, bucket distribution, month-over-month change, top five overdue customers, allowance movement, and write-off recommendations. Lead with what changed, not a recap of the static numbers.
-
Calculate DSO and bad-debt ratios
DSO = (AR / Trailing 90-day Revenue) × 90. Bad-debt ratio = Write-offs / Net Credit Sales. Track both as a 12-month rolling chart so the trend is visible alongside the point-in-time number.
-
Obtain controller sign-off on the package
Controller reviews the memo, allowance calculation, and write-off list before anything posts to the GL or goes to the CFO. Sign-off here is the internal control that documents segregation of duties between the AR clerk and management review.
Collects signature Collects paragraph
Use this template
Copy it to your account, customize the steps, and run it with your team in minutes.
Browse hundreds of free templates across every team and industry.
Back to template libraryRelated templates
More workflows your team can run.
Run Accounts Receivable Aging Report Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.