Aging Report
Last Modified on 05/20/2026 2:18 pm PDT
Pathway: Reports > Standard Reports > AR > Aging
The Accounts Receivable (AR) Aging report provides a clear and organized overview of outstanding customer invoices to help monitor payment trends. This report displays account balances as of a selected period, filtered by division, bill group, balance type (All, AR,AP), and account class. It includes key account information such as account ID, status, and name, along with balances distributed across aging buckets.
Report Parameters
Parameters are the specific criteria required to run a report, ensuring the system pulls only the specific data you need for your analysis.
| Parameter |
Description |
As Of Period
Required |
Filters to a specific month and year.
|
Balance Type
Required
|
Filters the report to only return results matching the selected balance type. Options include: All, AR (Accounts Receivable) and AP (Accounts Payable).
|
Division
|
Filters the report to only return results for accounts in the selected Division.
|
Bill Group
|
Filters the report to only return results for accounts in the selected Bill Group.
|
Account Class
|
Filters the report to only return results for accounts in the selected Account Class.
|
Run the Report
Follow these simple steps to run the report.
- Select the As Of Period the report applies to.
- Enter a Balance Type being collected for the report.
- Optional filters to apply:
- Division
- Bill Group
- Account Class
- Select Run Report or Run as Excel.
- Run Report: results of the generated report will display in a new window tab.
- Run as Excel: results will be exported to Excel for the user to open and view.
- Create a Saved Template for faster use later.
-
After all parameters are set, click on the Save As button at the top of the screen.
- Enter a Name for the template and click Save.
- The option to make the template available to other users is provided by checking the Public Access check box. Otherwise, if left unchecked, the report is only available to the user account it was created under.
Understand The Report
Below is a sample report followed by a detailed breakdown of the data in the report.
Header / Footer
The header of the report displays the selected parameter values. Page numbers are also located at the top of every page. For audit purposes, the bottom of each page includes the name of the user who generated the report and a precise generation timestamp.
Report Body
The data in the report is a straight list of the following information by division.
| Column |
Description |
Account #
|
The account ID associated with the aging balance.
|
Name
|
The name of the account associated with the aging balance.
|
Status
|
The current status of the account.
|
Current
|
Displays the total deposit balance available.
|
Aging Buckets:
1 - 30; 31 - 60; 61- 90;
91 - 120; Over 120
|
AR aging buckets categorize an account’s outstanding balances by time period. |
Total
|
Displays the total balance amount across all aging buckets less the current amount.
|
Grand Total
| The totals calculated for each of the Current, Aging Bucket and the Total columns.
|
Permissions
| Permission ID |
Permission Name |
|
134
|
Reports Main Menu
|
| 154 |
Standard/AR Reports |
