The Accounts Receivable (A/R) Aging Report leverages state-of-the-art reporting technology for improved performance—both in speed and data quantity. Possible uses of the A/R Statement Report include:
- Determining if the clinic is trending to their A/R aging goals,
- Creating the callback list for late paying clients.
- Identifying clients for the collections process.
Accessing the Report
- Go to the Menu > Reports > New Pulse Reports.
- Click on Aging Report.
Report Details
Initially the Aging Report generates a dashboard and a list of clients who have an A/R balance, grouped by how long the balance has been due—0-30 days, 31-60 days, 61-90 days, and Over 90 days. The defaults are based on the Run as of, Total Minimum Balance, and Active client status parameters.
Default Parameters: Run as of: Today's date and current time. Include: Check either or both boxes to show or hide Active Clients and Inactive Clients. Client Classifications and Client Statuses do not have default values as these fields are defined by the practice. Practices: This parameter will only be displayed if your practice is part of a group of practices. It will allow the user to select which practice to run for the Open Invoice Report.
Note: These parameters can be changed by selecting different values. |
Bookmarks
Bookmarks can be used to save the current view and can be named to easily remember the view, such as “End of Month Close”. They are available on the main New Reports page, the Accounts Receivable Statement Report page, and the Printable View page. For more detailed information about using bookmarks, refer to the topic New Pulse Reports.
Note: Bookmarks are specific to the user, not the device, so the user can go to another laptop/computer and still have access to the bookmarks.
Report Dashboard
The Report Dashboard highlights key data so the user can quickly understand the status of A/R aging. This includes:
- Total Amount
- # of Customers
- Aging Total
The Aging Total is an interactive bar graph. This means, you can click on a bar to filter the data. In the image below, the 0-30 bar was clicked on and shows the accounts with aging accounts receivable in the 0-to-30-day range. The Total Amount reflects the values of the aging totals in that range and the Number of Customers.
Tip: Right-click on the bar and choose Clear selections to clear the filter.
Sorting Columns
Reports with tabular columns can easily sort data by clicking on a column header.
- Move your mouse over any column header.
- Click the mouse to change the sort order.
The black triangle indicates if the column is sorted in ascending or descending order.
Note: The link ( ) next to the client name, when clicked on, will take you to the client record.
Sorting by Multiple Columns
In the image below, the data is sorted by Client Name then by Total Voided Amount. Both columns will be sorted in ascending order.
- Click on one column (for example, Client Name).
- Hold down the shift key as you click on any additional columns to sort the data.
Related Articles
Accounts Receivable Statement Report