See the core accounts receivable reports, what each one shows, who uses it, and how often to run it to control collections and cash.
Shyam Agarwal
Accounts receivable reporting is the practice of producing and reviewing reports built from receivables data, including open invoices, payments, credits, disputes, and collection activity. AR reports show what customers owe, how quickly they pay, which balances are at risk, and where collection work should focus. The core report is the AR aging report.
Accounts receivable reports fall into three groups. Balance reports show what is owed and how old it is. Performance reports show how effectively receivables are being collected. Exception reports show items that need action, such as disputes, deductions, unapplied cash, and customers over their credit limit.
An AR report is different from an AR KPI. A KPI is a single measure, such as days sales outstanding. A report is the view that presents that measure along with the detail behind it. For the metrics themselves, see our guide to AR KPIs.
The ten core accounts receivable reports are the aging summary, aging detail, customer account history, DSO trend, collection effectiveness, collector activity, promise-to-pay, dispute and deduction, unapplied cash, and credit exposure reports. Together they cover balances, collection performance, and the exceptions that slow cash.
The AR aging summary shows each customer's total open balance split into aging buckets: current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days past due. It is the starting point for collections, the allowance for doubtful accounts, and month-end reconciliation. It should include the customer name, total balance, each bucket, and the percentage past due.
The AR aging detail lists every open invoice behind the summary. Each line should show the customer, invoice number, invoice date, due date, original amount, open amount, days past due, and purchase order number. Collectors use it to identify exactly which invoices to discuss with each customer. Both aging views are covered in our guide to AR aging reports.
The customer account history shows all activity for one customer, including invoices, payments, credit memos, disputes, and collector notes, with a running balance. It is used before collection calls, credit reviews, and account escalations.
The DSO trend report tracks days sales outstanding by month or quarter, both overall and by customer segment. Each period should show the AR balance, credit sales, DSO, and the change from the prior period. A rising DSO signals slower collections before the effect appears in cash. See how DSO is calculated in our days sales outstanding guide.
The collection effectiveness report measures how much of the collectible balance was collected during a period, usually through the collection effectiveness index (CEI). It requires beginning receivables, credit sales, ending receivables, and ending current receivables for the period, and shows whether collections are keeping pace with amounts falling due.
The collector activity report shows the work completed and results achieved by each collector or team, including accounts worked, calls, emails, promises to pay obtained, and amounts collected. AR managers use it to balance workloads and coach collectors.
The promise-to-pay report lists each payment commitment a customer has made, with the invoice, promised amount, promised date, and status of kept, broken, or open. Broken promises are an early indicator of payment risk and should trigger escalation.
The dispute and deduction report lists open disputes and short payments by customer, invoice, amount, reason code, owner, and age. It identifies recurring root causes such as pricing errors, shortages, or missing proof of delivery. Teams with high deduction volumes often manage these through dedicated deductions management workflows.
The unapplied cash report lists payments received but not yet matched to invoices, with payer, payment date, amount, reference, and age. Unapplied cash overstates the aging and can lead to reminders being sent to customers who have already paid.
The credit exposure report compares each customer's open balance to its credit limit and shows available credit, percentage of limit used, and past due amount. Credit teams use it to decide on credit limit reviews and order approvals.
Different roles use different AR reports. CFOs and controllers use summary, trend, and risk reports such as the aging summary, DSO trend, collection effectiveness, and credit exposure. AR managers use nearly every report. Collectors use aging detail, account history, and promise-to-pay reports. Credit teams use credit exposure and account history. Sales teams use customer balances and dispute reports.
Matching each report to the people who act on it keeps report packs short and relevant.
Operational AR reports should be run daily, management reports weekly, and performance reports monthly. Daily reports include aging detail, promise-to-pay, unapplied cash, and new disputes. Weekly reports include the aging summary, collector activity, and credit exposure. Monthly reports include DSO trend, collection effectiveness, and dispute analysis.
Quarterly reviews typically add customer and segment trend analysis and a review of write-offs and the allowance for doubtful accounts.
A month-end AR report pack should include a headline summary of total AR, percentage current, percentage over 90 days, and DSO; the aging summary with the largest past due customers; a 12-month DSO trend; collection effectiveness; open disputes and deductions by reason; credit exposure; write-offs and the allowance; and confirmation that the aging reconciles to the general ledger.
Keep the pack in the same order with the same definitions every month, and add commentary only for movements beyond an agreed threshold. This makes month-to-month comparison straightforward for leadership.
AR reports should be segmented because company-wide totals can hide problems concentrated in one part of the customer base. Segmenting aging and DSO by customer tier, industry, region or business unit, payment terms, collector portfolio, and sales owner shows where collections are slowing and who should act.
Start with aging and DSO, since they show the largest differences between segments and are the easiest to act on.
Reliable AR reporting requires one source of receivables data, current data, consistent definitions, drill-down from totals to invoices, and balances that reconcile to the general ledger. When finance, collections, and sales pull from different systems, reports disagree and time is spent debating numbers instead of acting on them.
Consistency matters as much as accuracy. Aging buckets, the DSO calculation method, and dispute reason codes should be fixed and documented so trends remain comparable over time.
The most common AR reporting mistakes are mixing billed and unbilled balances in the same aging, changing aging buckets or DSO methods between periods, running reports before cash has been applied, presenting totals without invoice-level drill-down, and including disputed amounts in collectible totals. Each one makes reports less accurate or harder to act on.
Manual AR reporting relies on exported data and spreadsheets, so reports are only as current as the last export and take hours to prepare each cycle. Automated AR reporting updates as transactions post, applies the same rules every time, and provides drill-down and role-based access without separate files.
| Item | Spreadsheet Reporting | Automated AR Reporting |
|---|---|---|
| Data freshness | As of the last export | Updated as transactions post |
| Preparation time | Hours per reporting cycle | Minimal after setup |
| Error risk | Formula and copy errors | Lower, with rules applied consistently |
| Drill-down | Separate files | Built in |
| Access | Emailed files | Shared views by role |
For teams that manage customer relationships in Salesforce, an accounts receivable dashboard brings aging, DSO, disputes, and collector activity into the same system account owners already use.
40%
DSO reduction70%
less manual work95%
cash match accuracyFind out exactly how much time and money your AR team can save with Quick Receivable. No commitment, no setup required.
AI-powered Accounts Receivable Automation on Salesforce, built to accelerate collections, automate workflows, and improve cash flow.