Extended Aged A/R Reports

The Extended Aged A/R to Excel menu provides the following functions for generating a detailed aging of account balances that prints to Excel:

The Extended Aged A/R to Excel by Billing Group function is described below.

With the Extended Aged A/R to Excel by Billing Group function, you can generate a report that provides a detailed aging of account balances sorted by billing group. These reports only print to Excel.



Data Field Information
Prompt Response Req Len
Begin with Billing Group Type the code you want to start with or leave the text box blank to start with the first code in the table.   9
End with Billing Group Type the code you want to end with or leave the text box blank to end with the last code in the table.   9
Alpha, Numeric, or High Balance Select the sorting option you want to indicate if you want the accounts sorted alphabetically, numerically, or by the highest balance.   1
Ending Date for Report Type the date you want the report to end with or click the calendar icon to select a date. 10
Include which Balance Select the balance you want the report to include: Insurance, Patient or Total. 1
Aging Increments (15/30) Select the aging increment option you want when printing the report. 2
Print From List If you want to print this report based only on the patients contained in a previously defined DMS List, select the list you want to use. For information about creating a list, see the List Processor function.   20
Include Address
Guarantor or Patient
If you want the report to include an address, select the Include Address check box (it is selected by default), and then select Guarantor to include the guarantor's address or Patient to include the patient's address. If you do not want either address on the report, clear the check box.   1

You can print this report to Excel by selecting the Microsoft Excel via MyReports option in the Printers dialog box. If you select the Notify me when report is complete check box, you will receive a pop-up message when the report is complete. You can select to view the report using the link in the pop-up or you can elect to retrieve the report from MyReports at a later time. For additional information about the available printing options, see Printing in CGM webPRACTICE.

Report-Specific Notes

The other Extended Aged A/R to Excel functions work the same way, with the following differences:

Sample Report

The report prints to Excel with the balance type, sort and ending date shown at the top. The guarantor and patient names each print in separate Last Name and First Name columns, followed by the last visit and last payment dates, the total balance and the aged balances.