Report header
Company name, report title, preparer name, and report date. This identifies the reporting period and responsible party for audit purposes.
A clear aging report focuses collection efforts, reveals concentrated credit risk, supports accurate revenue recognition and allowance estimates, and shortens days sales outstanding. Consistent reporting reduces disputes, improves cash forecasting, and creates an auditable trail for internal control and external review.
The Business Aging Report is used across finance, credit, and customer-facing teams to manage receivables and risk.
Report distributions should match internal roles: preparers, approvers, and recipients responsible for collections and reporting.
The accounts receivable manager compiles source data from the billing system, applies aging rules, annotates disputes, and certifies the report for internal review. That person documents assumptions used for allowance calculations and evidence of follow-up.
Finance leadership reviews and signs off on summary figures and allowance recommendations. The CFO’s approval is typically required before reporting A/R balances externally or making significant write-off decisions.
Company name, report title, preparer name, and report date. This identifies the reporting period and responsible party for audit purposes.
Consistent bucket breakpoints (for example 0–30, 31–60, 61–90, 90+) with a clear definition for the day-count method used.
Invoice number, issue date, due date, original amount, payments applied, and current outstanding balance for traceability.
Balances grouped by customer or account number with subtotaling to highlight top exposures and concentration risk.
Flags for disputed items, contact notes, promised payments, and attachment references for supporting documentation.
Total receivables, % past due, days sales outstanding (DSO), and recommended allowance for doubtful accounts for management review.
| Field | Configuration |
|---|---|
| Source System | ERP export (CSV/API) or billing system integration |
| Frequency | Monthly end-of-period or weekly for high-volume operations |
| Aging Buckets | Standard 0–30, 31–60, 61–90, 90+ days |
| Approval Workflow | Preparer → AR lead → Finance sign-off |
Ensure your platform supports secure file formats, integrations to your ERP, and audit-grade recordkeeping before automating the report.
Produce the report within three business days after month end for timely close activities.
AR lead should reconcile and approve within five business days of report generation.
Contact customers for 30-day past-due invoices within seven calendar days after aging runs.
Refer 90+ day accounts per company policy, typically after documented collection attempts.
Obtain finance sign-off and record write-offs per preset thresholds and authorization levels.
Date when the invoice was created and sent to the customer, starting the aging clock.
When the report is run and invoices are assigned to buckets for monitoring.
Documented customer contact, payment commitments, or dispute resolution steps.
Final outcome: payment, negotiated settlement, or approved write-off and accounting entry.
| signNow | DocuSign | Adobe Sign | PandaDoc | HelloSign | |
|---|---|---|---|---|---|
| Starting Price | $8/user/mo | $15/user/mo | $14/user/mo | $19/user/mo | $15/user/mo |
| Free Trial | 7-day free trial | Varies by plan | Varies by plan | Varies by plan | Varies by plan |
| Bulk Send | Yes | Yes | Yes | Yes | No |
| Audit Trail | Yes | Yes | Yes | Yes | Yes |
| HIPAA Compliant | Yes | Yes | Yes | No | No |