Insurance Receipts By Procedure Report

Owned by Dylan Nigh
Mar 15, 2023
3 min read

The Insurance Receipts By Procedure Report lists the insurance receipts for procedures.

This documentation contains the following sections:

Filter Options

Screen_Shot_2017-05-02_at_9.52.54_AM.png

  • Providers: Filters the report based on the provider on the charge(s) being paid for.

  • Offices: Filters the report based on the charge(s) being paid for.

  • Insurances: The name of the insurance company, as entered in References.

  • Procedures: Filters the report by procedures listed on the receipts.

  • Plans: Filters the report by plans listed on the receipts. 

  • Payment Posted Start/End Date: Filters results by a date range based on the date in which the payment was posted.

  • Plan Type: Filters Results by the type of plan.

  • Procedures Include Modifiers:

  • Show Only Primary Claims: Filters results to display primary claims only.

Results Columns

Unexpanded

Screen_Shot_2017-05-02_at_9.56.19_AM.png

  • Code: The Procedure Code listed on the receipt.

  • Description: A description of the Procedure as defined in the Procedure reference within the Fee Schedule.

  • # of Payments: The number of payments to which the procedure code result has associated receipts.

  • Avg. Days Open: The average number of days that the claims associated to the Insurance payments were open.

  • Fees: The total amount of all Fees associated with the procedure by receipt.

  • Allowed: The total allowed amount for the procedure.

  • Paid: The total amount Paid on the receipts for the procedure result.

  • Write-Offs: The dollar amount total of the Write-Offs listed for the insurance payment tied to the charge within the receipts.

  • % Paid of Allowed: The percentage which has been paid on the allowed amounts.

  • % of Paid: The percentage which has been paid towards the total fees.

First Expansion

 

  • Insurance Company: The Insurance Company to which the receipt for the procedure result is associated.

  • # of Payment: The number of payments from the Insurance Company for the procedure code result.

  • Avg. Days Open: The average number of days for which the claim was open.

  • Fees: The Fees for this procedure on the Insurance receipts for this Insurance Company.

  • Allowed: The total allowed amount on all insurance receipts by for this procedure.

  • Avg. Allowed: The average dollar amount of the allowed amounts for the Procedure within this Insurance Company result.

  • Paid: The total amount paid by the Insurance company for all receipts with this procedure.

  • Write-Off: The total write-off for the Insurance company for all receipts with this procedure.

  • Avg Write-Off: The average write-off amount for all receipt for this procedure with this Insurance company.

  • % Paid of Allowed: The percentage paid of the allowed amounts for all receipts with this Insurance Company for this procedure.

  • % of Paid: The total percentage paid towards the total Fees.

Second Expansion

 

  • Patient Last, First: The first and last name of the patient.

  • Plan Name: The name of the patient's Insurance plan.

  • Procedure Date: The date of the procedure charged to the Insurance.

  • Days Open: The number of days the claim was open.

  • Fees: The total Procedure Fees charged.

  • Allowed: The dollar amount that was allowed by the Insurance.

  • Paid: The dollar amount that was paid by the Insurance.

  • Write-Off: The dollar amount of any write-off applied.