Accounts Receivable Aging Summary Report
Overview
The Accounts Receivable (A/R) Aging Summary Report helps you monitor outstanding customer balances and track how long invoices have remained unpaid. This report organizes receivables into aging buckets (such as Current, 1-30 days, 31-60 days, etc.) to give you visibility into your cash flow and identify accounts that may require follow-up.
Use this report to:
- Track outstanding balances by customer
- Identify overdue accounts that need attention
- Monitor cash flow and collection trends
- Analyze payment patterns across your customer base
Accessing the Report
To access the Accounts Receivable Aging Summary Report:
- Navigate to the Reports section in Discovery
- Select Accounts Receivable Aging Summary from the available reports
- The report will open with default settings applied
Using the Report
Report Controls
Before generating your report, you can customize it using the following controls:
As of Date
- Select the date for which you want to view aging data
- Defaults to today's date
- Cannot select a future date
Show Client Accounts
- Toggle on to display individual account rows beneath each client
- Toggle off to show only client-level totals
- Default: Off
Show Non-Zero Only
- Toggle on to display only clients/accounts with outstanding balances
- Toggle off to show all clients/accounts, including those with zero balance
- Default: Off
Exclude Archived Accounts
- Toggle on to exclude archived accounts from the report
- Toggle off to include archived accounts
- Default: Off
Default Payment Method
- Filter the report by one or more payment methods
- Default: Any (shows all payment methods)
Report Settings
Note: The aging period configuration is managed in the report settings. To customize how aging buckets are calculated, access the report settings to edit these values.
- Days per Aging Period (configured in settings)
- Set the number of days for each aging bucket (e.g., 30 days)
- Default: 30 days
- Example: Setting this to 30 creates buckets like 1-30, 31-60, 61-90, etc.
- Number of Periods (configured in settings)
- Choose how many aging buckets to display
- Default: 4 periods
- Example: 4 periods with 30 days each creates Current, 1-30, 31-60, 61-90, and 91 & Over
Understanding the Report Layout
The report displays the following columns:
Company - Customer name, with individual accounts listed beneath (when Show Client Accounts is enabled)
Current - Invoices that are not yet past due
Aging Buckets - Columns showing past due amounts by time range (e.g., 1-30, 31-60, 61-90, 91 & Over). The number and range of these columns adjust based on your "Number of periods" and "Days per aging period" settings.
Subtotal - Total amount owed by the client across all aging periods
Unapplied Payments & Credits - Any credits or payments that haven't been applied to specific invoices
Total - Net amount owed (Subtotal minus Unapplied Payments & Credits)
The report concludes with a TOTAL row summarizing all amounts across all clients.
Optional Columns
You can add additional columns to the report for more detailed information:
- Account number
- Primary contact name
- Primary telephone number
- Primary email address
- Default payment method
- Payment terms
Tips for Using the Report
- Weekly Reviews: Run this report weekly to stay on top of aging receivables and prioritize collection efforts
- Custom Aging Periods: Adjust the days per aging period to match your business cycle or payment terms
- Focus on Problem Accounts: Use "Show Non-Zero Only" to quickly identify accounts that need attention
- Payment Method Analysis: Filter by payment method to see if certain payment types correlate with faster or slower payment
- Clean View: Turn off "Show Client Accounts" for a high-level summary when presenting
If you have additional questions or need more in depth information, please feel free to send us a message using the help beacon in the lower right-hand corner.