Aged A/R by Billing Group

With the Aged Receivables by Billing Group function, you can generate a report that provides a detailed aging of account balances sorted by billing group. The aging is calculated based on the date the transactions were posted and the sorting is based on the billing group stored for each transaction when it was originally posted.

This report can be:

Used to generate a DMS List - to activate this function you need to add the report to the DMS Report Integration function
Printed to Microsoft Excel providing enhanced reporting capabilities

Data Field Information

Prompt	Response	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
Print Detail of Guarantor	If you want to print the individual detail of the guarantors, select this check box.	1
Alpha, Numeric, or High Balance	If you selected Print Detail of Guarantor, select the sorting option you want to indicate if you want the accounts sorted alphabetically, numerically, or by the highest balance.	1
Include Address Information	If you selected Print Detail of Guarantor and want to print the address information, select this check box.	1
Print Transaction Detail	If you selected Print Detail of Guarantor and want to print the transaction detail, select this check box.	1
Print By	Select the type of date you want to use when printing the report.	1
Print from Date	Type the date you want the report to start with or click the calendar icon to select a date or leave the field blank to print every open item up through the selected 'Through Date'.	10
Print through Date	Type the date you want the report to end with or click the calendar icon to select a date. If you select a date prior to the current date, you should not select to include the insurance or patient balances on the report because those figures cannot be accurately calculated for past dates. If you select a date prior to the current date, the program automatically scans for any deleted patient accounts to ensure the totals provided for that time period are accurate.	10
Show A/R as	If you want the A/R to print the current open item balances, select Current Balance. If you want the A/R to print the open item balances up through the Ending date, select Balance on Ending Date. Note: If you select Balance on Ending Date, the balances will not include any payments or adjustments applied after the selected ending date.	1
Include Insurance Balance	If you want the report to print the insurance balance separately, select this check box. If you selected a date prior to the current date for the 'Print through Date', you should not select to include either the insurance or patient balances on the report because those figures cannot be accurately calculated for past dates.	1
Include Patient Balance	If you want the report to print the patient balance separately, select this check box. If you selected a date prior to the current date for the 'Print through Date', you should not select to include either the insurance or patient balances on the report because those figures cannot be accurately calculated for past dates.	1
Aging Increments (15/30)	Select the aging increment you want to use when printing the aged balances.	2

Sample Report
This report lists all charges with a balance. If the charges fall within the parameters of the report, the balance of the charge is shown. If it does not fall within the parameters, the charge displays with a 0.00 next to it. Therefore, an account might then be listed under more than one billing group. For example, if you run the report for Med billing group, you can see the actual amount outstanding for that billing group, and then, because of the 0.00 listings, you can also see that there are still other charges on that account under another billing group.

If you select to include guarantor detail, the information that will be on the report is: patient account number, guarantor name, date of last visit, date of last payment, the total balance due on the account and the aging of that balance (broken down by 'P'atient and 'I'nsurance if selected). If a Report comment is stored in the patient's Billing Information, it will print beneath the guarantor's name. Then the address information and transaction detail with the patient name will print if you select to include them.

The last page of the report reflects the summary information, which includes: the billing group code and name, the number of accounts with balances (broken down by 'P'atient and 'I'nsurance if selected), the total balance and the aging breakdown of balances, the percentage each aging category represents of the total balance owing, and grand totals for all billing groups combined.

Note: The report may print a billing group labeled 'None', which will contain any unapplied transaction amounts.

If you select to include both 'P'atient and 'I'nsurance balances, the total number (No.) of accounts listed for each type of balance does not typically breakdown evenly between the patient and insurance balance categories. The reason for this is because many accounts contain both types of balances and will be counted for each category, but will only be counted one time for the total.