AR Account Activity Report
Last Modified on 05/20/2026 1:14 pm PDT
Pathway: Reports > Standard Reports > Account > AR Account Activity
The AR Account Activity report provides a detailed transaction history for all sites associated with an account. Each transaction entry includes key information to allow for a quick assessment of account activity. Additionally, an AR aging summary is featured at the top of the report, offering a snapshot of overall account health.
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 |
Account ID
Required |
Filters the report to the account that matches the Account ID entered.
|
Limit To Open
Required |
Select 'Yes' to limit the report to only return the open AR activity for the account.
|
Run the Report
Follow these simple steps to run the AR Account Activity report for a given account.
- Enter the required report parameters:
- The Account ID of the account the report is for.
- Select whether to Limit to Open AR Activity or all AR Activity.
- Choose preferred output method by clicking one of the buttons:
- Run Report: Displays the results immediately in a new browser tab.
- Run as Excel: Exports the report directly into an Excel file for offline viewing and analysis.
- 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 and the Account Name linked to the Account ID. There is also this information:
| Additional Header Info | Description |
| Current Balance | The current balance for this account.
|
| Aging Balances | The balances for each aging bucket: 1-30 days, 31-60 days, 61-90 days, and Over 90 days
|
| Total Due | The total due for this account.
|
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 for the selected account.
| Column |
Description |
| Date |
The date of the transaction.
|
| Type |
The type of transaction recorded for the site.
|
| Reference |
A (payment) reference or invoice number for the transaction.
|
| Location |
The site ID the transaction is associated with.
|
| Site Name |
The name of the site associated with the transaction.
|
| Amount |
The amount of the transaction.
|
| Applied |
The amount of the transaction that was applied toward the balance.
|
| Balance |
The balance for the invoice. The bottom line balance (Total) is displayed after the last invoice.
|
| Running Balance |
The unpaid balance amount for all sites under the account.
|
Permissions
| Permission ID |
Permission Name |
| 154 |
Standard AR / Report |
| 155 |
Standard Account / Report |
