Insurance Payment Analysis by Location

With the Insurance Payment Analysis by Location function, you can generate a payment analysis report of insurance payment activity by insurance plan, insurance class and insurance carrier for one or multiple locations.

Data Field Information
Prompt Response Req Len
Beginning Plan Code Type the code you want to begin with, select from the Plan Code list, or leave the field blank to start with the first code in the table.   5
End with Plan Code Type the code you want to end with, select from the Plan Code list, or leave the field blank to end with the last code in the table.   5
Insurance Class Type the code you want, select from the Insurance Class list, or leave the field blank to include all codes in the table.   5
Begin with Insurance Carrier Type the code you want to begin with, click the magnifying glass to search the table, or leave the field blank to start with the first code in the table.   5
End with Insurance Carrier Type the code you want to end with, click the magnifying glass to search the table, or leave the field blank to end with the last code in the table.   5
Begin with Location Code Type the code you want to begin with, select from the Location list, or leave the field blank to start with the first code in the table.   6
End with Location Code Type the code you want to end with, select from the Location list, or leave the field blank to end with the last code in the table.   6
Begin with Procedure Code Type the code you want to begin with, click the magnifying glass to search the table, or leave the field blank to start with the first code in the table.   10
End with Procedure Code Type the code you want to end with, click the magnifying glass to search the table, or leave the field blank to end with the last code in the table.   10
Include Patient Payments If you want to include patient payments and adjustments applied to charges on this report, select this check box.   1
Print from Date Type the Accounting Date you want the report to begin with or click the calendar icon to select a date.   10
Print through Date Type the Accounting Date you want the report to end with or click the calendar icon to select a date.   10
Summary Only If you want to print a summary only, select this check box. 1

You can print this report to Word by selecting the Microsoft Word via MyReports option, or to Excel by selecting the Microsoft Excel via MyReports option in the Printers dialog box and then retrieve the report from MyReports. For additional information about the available printing options, see Printing in CGM webPRACTICE.

Sample Report
This report is sorted first by plan code, then by each individual insurance carrier under each plan code, and then by location. The report reflects the total payments received for the time period requested. If detail is selected, the report includes the service date, CPT code, total number of days between the date of service and when the claim was initially filed to the primary carrier, individual charges, Medicare allowed amount, plan allowed amount, what percentage the payment is of the Medicare and plan allowed amounts, the date the charge was filed to the insurance carrier, payment amount, payment date, and the number of days it took to receive payment from the carrier.

NOTE: The total charge amounts will not match the procedure analysis report. This figure is based strictly on charges that payments were applied to during the specified timeframe.