Delinquent Accounts Receivable Reports

The Delinquent Aged Accounts Receivable (A/R) Reports menu provides the following functions for printing delinquent aged accounts receivable reports by various sorting criteria:

The Delinquent Aged A/R by Location function is described below.

With the Delinquent Aged A/R by Location function, you can generate a report that provides a detailed aging of delinquent account balances sorted by location. The aging is calculated based on the date the transactions were posted and the sorting is based on the location stored for each transaction when it was originally posted.



Data Field Information
Prompt Response Req Len
Begin with Location Type the code you want to start with or leave the text box blank to start with the first code in the table.   8
End with Location Type the code you want to end with or leave the text box blank to end with the last code in the table.   8
Print Detail of Guarantors If you want to print the individual detail of the guarantors, select this check box.   1
Alpha or Numeric If you selected Print Detail of Guarantors, select Alphabetic, Numeric, or High Balance 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 Guarantors and want to print the address information, select this check box.   1
Print Transaction Detail If you selected Print Detail of Guarantors and want to print the transaction detail, select this check box.   1
For Balances older than Select the age, in days, that a balance must be older than to be included on the report. 3
And Balances not older than Select the age, in days, that a balance can not be older than to be included on the report. If you do not select an age, the report prints all balances older than the age selected in the previous field.   3
No Payment since what date Type the date you want or click the calendar icon to select a date.   10
For Balances greater than $ Type the amount you want or leave the text box blank to include all accounts.   10
Include Insurance Balances If you want the report to list the insurance balance separately, select this check box.   1
Include Patient Balances If you want the report to list the patient balance separately, select this check box.   1
Acct Date or Patient Aging Select the aging option you want when printing the report. 1

Report-Specific Notes

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

Sample Report
If you select to include guarantor detail, the information that will be on the report is: patient account number, guarantor name, guarantor's phone number, date of last visit, date of last statement, date of last payment (broken down by 'P'atient and 'I'nsurance if selected), the total balance due on the account and the aging of that balance. 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 location 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 locations combined.

Note: The report may print a location 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.



For the Alphabetic and Numeric reports, the information included on the report is: account number, guarantor name, date of last payment (broken down by 'P'atient and 'I'nsurance if selected), the total balance due on the account and the aging of that balance. The patient's name (if different than guarantor), the guarantor's phone number, and the date of the last visit print beneath the guarantor's name along with any Report comment stored in the patient's Billing Information. The last page of the report prints the summary information, which includes the total balances for all the accounts (broken down by 'P'atient and 'I'nsurance if selected), the aging breakdown of the balances, grand totals, and the percentage each aging category represents of the total balance owing.