AR review without the untracked collection activity.
Most AR aging reports show who owes what but not who called whom or when the next follow-up is due. This template links aging analysis to collection activity so DSO tracking reflects actual effort, not just calendar days.
For ar specialist, accounting manager, finance business partner, and controller teams running accounts receivable aging review. No credit card. First run in under a minute.
AR Review #W47-2026
Week 47 · $342k overdue · DSO 47 days
- AR aging analysis100%AR SpecialistSLA 24h
- Collection activity logAR SpecialistEvidence
- Bad debt reserveAccounting Manager
- DSO and cash trackingFinance BP
- Write-off approvalControllerApproval gateDep. pendente
Opinion
What we cut. And what we kept.
This template is operational, not exhaustive. Exhaustive is why AR reviews become quarterly fire drills.
Cut
- Aging reports with no collection activity context.
- Bad debt reserve calculated once a quarter.
- Write-offs approved via email after the fact.
- DSO tracking that ignores collection effort timing.
Kept
- Collection activity logged with every aging review.
- Bad debt reserve assessed weekly, not quarterly.
- Controller approval gate before any write-off.
- DSO tracking paired with cash conversion metrics.
What this template includes
Process steps
- 1AR aging analysis
- 2Collection activity log
- 3Bad debt reserve assessment
- 4DSO and cash conversion tracking
- 5Write-off approval
Why teams use this template
Weekly AR review: aging analysis, collection activity, bad debt reserve, and DSO tracking. When this work runs through inboxes and ad-hoc spreadsheets, ownership gets fuzzy and evidence gets lost. Accounts Receivable Aging Review gives you a 5-step process with 1 checkpoint so nothing slips between handoffs.
Built for teams led by AR Specialist, Accounting Manager, Finance Business Partner, and Controller: every task has a named owner, every approval routes to a real role, and the run history is the audit trail your auditors actually want.
The checkpoint tasks ("Write-off approval") cannot be skipped, they're where the run produces evidence the next stage depends on. You start with structure instead of building it from scratch every time.
Ready to run this process?
Open this template in Cadenio, customize the fields and approvals for your context, and run it for the first time in under 60 seconds.
Related use case
Accounting use caseRelated templates
Monthly Finance Close
Month-end close checklist template, same tasks, same order, same deadlines every month, with approval gates before reporting and without someone having to remember every step.
FinanceExpense Report Audit
Expense report audit template, pre-approval checks, receipt validation, and policy compliance in a repeatable review cycle with approval gates and an immutable record.
FinanceAccounts Payable Review
Weekly accounts payable review template: AP aging analysis, duplicate-invoice detection, approval-compliance check, payment-run authorization, and cash-flow impact. Five-step AP control with an approval gate.