Aged Receivables Report

The Aged Receivables Report displays the aged balances of accounts and the total aging of all receivables as of today or for a specified aging bracket. You can send this report to your accountant monthly.

To view the aged receivables report

1. On the Home menu, under Reports, click (or tap) Aged Receivables.

   The Aged Receivables page opens.

2. Set up the following options:

   • Locations - The aged receivables and aged totals will be calculated for the selected locations. Do any of the following:

     • Select the All checkbox to view aged totals for all locations. Aged receivables will not be displayed. Clear the checkbox to quickly remove all location selections.

     • Select or clear the checkbox next to the current location's name to show or hide the aged receivables and aged totals for that location.

     • Click (or tap) Select Locations to select the locations whose aged totals you want to view. If more than one location is selected, the aged receivables will not be displayed. If only one location is selected, the aged totals and aged receivables will be displayed.

     Note: Only locations that you have access to are available.

   • Include Summary - Select this checkbox to view the organization's aged totals (the sum of the aged totals for all locations in the organization).

     Note: If you have access to 40 or more locations, this checkbox is not available.

   • Skip accounts with claim pending (CP) - Select this checkbox to not include accounts (a guarantor and all patients with that person specified as their guarantor) that have pending claims. Clear this checkbox to include accounts on the report regardless of claim status. The number of claims that are associated with a given account appear in the CP column on the report.

   • As Of - Leave the current date entered, or click (or tap) in the box to select a different date. The calculation of the aged receivables will include the current revision or a past revision of transactions, depending on which revision was in effect on or before the specified date.

   • Period - Select the age of account balances to include: All, Over 30 days, Over 60 days, or Over 90 days. Aged receivables will be calculated according to the selected age and the As Of date.

   • Procedures - Filter the report to include all procedures, to include only orthodontic procedures, to exclude all orthodontic procedures, or to include or exclude any set of procedures. You can customize the procedure filter presets to suit your preferences.

     Note: The procedure filter presets are also used by the Provider A/R Totals Report, so changes made to the presets from the Aged Receivables Report affect the Provider A/R Totals Report.

3. Click (or tap) Search.

   Note: If you have selected more than 40 locations for this report, a warning appears, stating that there are potential performance issues if you run the report for that many locations. If you want to return to the report options to reduce the number of locations for this report, click the X in the upper-right corner of the message; otherwise, click (or tap) OK to acknowledge the risk and run the report anyway.

   

   Wait for the report to load. This can take from one to five minutes, depending on the date range.

4. To print the report, click (or tap) Print.

Notes:

• You can click (or tap) the name of a guarantor on the report to open his or her ledger in a new browser tab.

• If there is a Statement icon next to a guarantor's Balance, you can click (or tap) it to open the most recent statement that was generated for that account.

• To view the guarantor, insurance, and write-off portions of the aging and total balance of an account, expand that guarantor's row.