Aging Report

Pathway: Reports > Standard Reports > AR > Aging


The Accounts Receivable (AR) Aging report is to provide a clear and organized overview of outstanding customer invoices. This report categorizes receivables based on the length of time they have remained unpaid.


Required Permissions

The Aging report requires the following user permissions:


Report Parameters

ParameterValue
As Of Period    
Filters to a specific month and year.

Balance Type    
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 A Report

  1. Select the As Of Period the report applies to.
  2. Enter a Balance Type being collected for the report.
  3. Optional filters to apply:
    • Division
    • Bill Group
    • Account Class
  4. 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.

Understand The Report




ColumnDescription
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.