Sorted Open Credit Reports

The Sorted Open Credit Reports menu provides the following functions for printing sorted reports with a detailed or summary listing of all charges, payments and credit adjustments that are not allocated or applied towards other transactions:

The Open Credit by Bill Grp and Default Location function is described below.

With the Open Credit by Bill Grp and Default Location function, you can generate a report that is sorted by the Billing Group and the Default Location stored on the patient's account and lists all the charges, payments, and credit adjustments that have open credits (unallocated amounts) that have not been applied towards other transactions. You can limit the report to a range of posting dates.



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.   8
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.   8
Begin with Default 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 Default 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
From Posting Date Type the first posting date to include on the report or click the calendar icon to select it.   10
Through Posting Date Type the last posting date to include on the report or click the calendar icon to select it.   10
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 to print detail of guarantors - select the sorting option you want.   1
Include Address Information If you selected to print detail of guarantors and want to print the address information, select this check box.   1
Print with Detail If you selected to print detail of guarantors and want to print the transaction detail that caused the open credits, select this check box.   1
Include Insurance Balances If you want the report to list the insurance balance of the open credit, select this check box. If you also select to Include Patient Balances on the report, both balances will be combined and only one amount will print.   1
Include Patient Balances If you want the report to list the patient balance of the open credit, select this check box. If you also select to Include Insurance Balances on the report, both balances will be combined and only one amount will print.   1

For detailed information on allocating open credits, see Allocating Open Credit Payments and Allocate Open Credit Adjustments.

Sample Report
If guarantor detail is selected, the information included on this report is: the default location, the guarantor account number and name, patient name (if different), address information (if selected), telephone number, the total of the unapplied credits on the account beneath the applicable column for the open credit type, the total credit and debit balance on the account, and the ending account balance.



A summary page will print at the end of the report which reflects the totals of the unapplied credits beneath the applicable column for the open credit type, the total credit and debit balances, and ending balances per billing group and default location as well as a grand total for all the billing groups.



Report-Specific Notes

The other Open Credit Report functions work the same way, with the following differences:

Sorted Open Credit Report to Excel

With the Sorted Open Credit Report to Excel function, you select the primary and secondary sort options on the first screen and then enter the report parameters on the second screen.



Data Field Information
Prompt Response Req Len
Primary Sort Option Select the first sort option you want to use for the report.   5
Secondary Sort Option Select the second sort option you want to use for the report.   5



Data Field Information
Prompt Response Req Len
Begin with [primary sort option] Type the code you want to start with or leave the text box blank to start with the first code in the table. The prompt displays the primary sort option you selected on the previous screen.   8
End with [primary sort option] Type the code you want to end with or leave the text box blank to end with the last code in the table. The prompt displays the primary sort option you selected on the previous screen.   8
Begin with [secondary sort option] Type the code you want to start with or leave the text box blank to start with the first code in the table. The prompt displays the secondary sort option you selected on the previous screen.   8
End with [secondary sort option] Type the code you want to end with or leave the text box blank to end with the last code in the table. The prompt displays the secondary sort option you selected on the previous screen.   8
From Posting Date Type the first posting date to include on the report or click the calendar icon to select it.   10
Through Posting Date Type the last posting date to include on the report or click the calendar icon to select it.   10
Alpha or Numeric Select the sorting option you want.   1
Print with Detail If you want to include the transaction detail that caused the open credits, select this check box.   1
Include Insurance Balances If you want the report to list the insurance balance of the open credit, select this check box. If you also select to Include Patient Balances on the report, both balances will be combined and only one amount will print.   1
Include Patient Balances If you want the report to list the patient balance of the open credit, select this check box. If you also select to Include Insurance Balances on the report, both balances will be combined and only one amount will print.   1

The Print Detail of Guarantors and Include Address Information prompts are not available for the Excel version of the report. The guarantor address is included in the spreadsheet columns.

Sample Report
The first rows of the spreadsheet show the report date, the practice name, the report title, the sort option, the posting date range, and whether the balances are combined. The column headings begin on row 7.

For each guarantor, one row lists the unapplied credit beneath the applicable payment or adjustment column along with the credit balance, debit balance, and account balance. If you select Print with Detail, the row beneath it lists the transaction that caused the open credit (date posted, accounting date, date of service, transaction code, transaction amount, and the total remaining).






Column Definitions

Column Heading
A Primary sort option selected (Billing Group in the example)
B Secondary sort option selected (Default Location in the example)
C Account Number
D Guarantor's Name
E Address Line 1
F Address Line 2
G City
H State
I Zip
J Patient's Name
K Phone Number
L Insurance Adjustment
M Personal Adjustment
N Overpaid Charge
O Copay
P Insurance Payment
Q Personal Payment
R Date Posted
S Accounting Date
T Date of Service
U Transaction Code
V Doctor
W Location
X Transaction Amount
Y Total Remaining
Z Credit Balance
AA Debit Balance
AB Account Balance
AC Report Comment