Aging Details To Date
Last Modified on 04/23/2026 12:26 pm PDT
Pathway: Reports > Standard Reports > AR > Aging Details To A Date
The Aging Details To A Date report provides aging details for accounts in the selected division based on the date entered. It includes a detailed, transaction-level view of accounts receivable as of a selected date, filtered by division with key account information displayed such as account ID, status, name, transaction type (Invoice, Unapplied, Voided), due date, payment terms, original amount, and bill group, 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 |
Value |
Division
Required |
Filters the report to only return results for accounts in the selected Division.
|
Date
Required
|
Filters the report to run the AR Aging data as it exists on that day. It is used to calculate the age of outstanding invoices; for example, an invoice due on Oct 1st will show as 30 days past due if the report is run for Oct 31st.
|
Run the Report
Follow these simple steps to run the report.
- Select the Division the report applies to.
- Select the Date to be used in AR Aging calculations.
- Select Run Report or Run as Excel.
- Run Report: results of the generated report will display in the Report Results 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.
-
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.
Report Results
The data returned is a list of all transactions for all accounts that meet the parameter criteria showing status, term, due date, and aging buckets.
| Column |
Value |
| Account ID |
The ID of the account.
|
| Status |
The current status of the account.
|
| Name | The name of the account.
|
| Type | The type of transaction, such as Invoice, Unapplied Payment, Unapplied Adjustment
|
| ID |
An identifier associated with the Type, such as Invoice Number.
|
| Date | The date of the transaction, like the invoice date.
|
| Due Date | The date the invoice is due.
|
| Term | The term assigned to the account which is used along with Due Date to calculate the "age" of an invoice.
|
| Original Amount | The original amount of the invoice or transaction.
|
| Current | How much is due.
|
Aging Buckets:
1 - 30, 31 - 60, 61- 90,
91 - 120, over 120 |
The AR Aging buckets for the account’s outstanding balances by time period.
|
| Bill Group |
The billing group assigned to the account.
|
Permissions
| Permission ID |
Permission Name |
154
|
Standard / AR Reports |
155
|
Standard / Account Reports |
