Insurance AR Aging Report - By Company Report
Run an Insurance AR Aging (Accounts Receivable Aging) report to obtain a detailed aging of each patient's insurance accounts, grouped by insurance company. This report features a pie chart that shows the percentage of amounts due in each aging category for the selected patients. In addition to the chart, the report lists each patient's name and primary ID, status, responsible party name, home and work phones, total amount due, aging by number of days past due, total number of days past due, balance, amount of last receipt, and date of last receipt. The total amount of each figure is printed on the last page of the report. Due to the large number of columns required by the report, it prints in landscape mode (sideways).
Insurance Company Aging vs/ Responsible Party Aging Reports - This article describes running the Accounts Receivable Aging report for insurance companies: To run a similar report for responsible parties, run the Accounts Receivable Aging report instead.
Open the Report
Select Reporting from the Reporting section of the Home ribbon bar. Then from the Insurance section, open the Insurance AR Aging - By Company report. (You can also use the Search field to find the report you want to work with.) You might also be able to run this report from your Recent Reports or Quick Reports list. See "Run Edge Cloud Reports" for details.
Report Settings
Select the options to use for choosing records and generating this report. Choose carefully, as your selections will affect which data is included in the report. (If the report settings panel is not visible, click the Show/Hide icon in the upper left corner of the Reporting window.)
Date - Choose the date to use. You can type a date in the Date field, or click the v button to select a date from a calendar. You can also enable the Today option to use today's date. If Today is enabled, you cannot type a date or open the calendar: Disable the Today option first if you want to choose a specific date. The date or you select will appear just under the report title; if you select a date that is not "today", this date will be different from the run date that appears in the report header. Note that the past due amounts printed on this report are calculated from the date you choose here, not necessarily today's date.
Exclude Zero Dollar Balances - Enable this option to omit accounts with no balance (and are therefor not past due) from the report.
Office - Choose to include only the records for a specific office, or include the records for all office locations in your practice.
Orthodontist / Doctor - Choose to include only the records for a specific orthodontist / doctor, or include the records for all orthodontists in your practice.
Specialty - If you have Edge Specialist, you can choose to include only records for a specific specialty, or include the records for all specialties in your practice.
Insurance Company Filter - If you enable the Filter option, you can select to print the report for an individual insurance company. Otherwise, the report will include all insurance company that fit your report settings.
Subgroup - You can optionally choose a subgroup to use to narrow the records to include on the report. Only records that fit your selected subgroup as well as all other report settings will be included. If you use a subgroup, the report will display the name of your selected subgroup just under the report name, so you know which criteria was used to generate the results. See "Subgroup Editor" for details.about creating subgroups.
View Report Results
If needed, click View at the top of the report settings panel to view the results on your screen. When you run a report or form from your Recent Report list, or when you run a Quick Report, the initial results are sent to your screen immediately, with one exception: A Quick Report that has the Print Only option enabled will not show your results on the screen at all, but continue with the printing options. You can use the arrows in the View section of the ribbon bar to view additional pages of a multiple-page report. You can also use the dropdown button or type a number in the zoom field to change the size of the report in your window.
Report Title & Header
Whether you view the report on your screen or print it, the report title and run date appear in the header of each report page. If you used subgrouping or other report options, that information appears just under the report title so you know which criteria was used to generate the results.
Show / Hide Details
If this report supports showing / hiding the details that comprise report totals, you can click the expand / collapse icons to show / hide the details. Not all Edge Cloud reports support this feature. If your cursor changes to look like a hand, the feature is available.
Use Arrows to Re-Sort Report
While viewing certain Edge Cloud reports, you can use the arrow beside certain column headings to re-sort the report according to that column's criteria. Click the arrows a second time to sort that column in reverse order, or click the arrows beside a different column to change the sort order again. (Not all Edge Cloud reports support this feature. If your cursor changes to look like a hand, the feature is available.)
Open the Patient Folder / Responsible Party Record
While viewing some Edge Cloud reports, you can click a patient name or responsible party name to open that record. Not all Edge Cloud reports support this feature. If your cursor changes to look like a hand, the feature is available.
Get Detailed Report Description
Click the icon to the right of the View button to open the help article with the detailed description of the report.
Choose the Output
With the results on your screen, you can choose the output with the toolbar at the top of the report window. See "Report Output Options" for details.
Report Details and Calculations
Amt Due - This column is the total amount due for that contract line. This amount is broken down further into the respective aging columns. When you run the report for a date in the past, the amount due results are calculated from that date, not from "today".
Days – This column tells you the highest number of days past due on any outstanding charges for the contract.
Last Amt and Received – These columns list the amount and date of the last payment posted to the contract.
Past Due Calculations - The account aging is calculated from the date you selected in the report settings, not necessarily today.
Last Page – The last page of the report includes totals for the number of patient contracts listed, amount due, amounts in each of the 0 – 30, 31-60, 61-90, and 91+ days past due categories, and the account balances.