#5 - Insurance Company Analysis, Open Charges & Gross Profits by Frames Sold

This report details, by each Insurance Company, many key insurance company indicators. In addition it shows open receivables and gross profits by frames sold to patient with insurance. If you wonder why you are working more and making less, this report may answer that question. Know what per cent of your fees are charged to patients and insurance and what % of those fees you are actually collecting. All KPI's include the breakout by Insurance Company and the fee slip associated with the charge. You can also calculate collections or gross profits by fee slip

For more information on how this popular report can be used to increase revenue, watch our 5 minute video!

Summary Page

Enter your Provider total hours and calculate Fees and Write-offs per hour. This summary takes the details of the many KPI's and presents them on one page. Easily see what percentage of your fees are charged to insurance and what percent of those fees are written off and not collected.

Key Performance Indicators for Patient and Insurance Charges, Write-Offs and Collections

Patient and Insurance Charges, Write-offs, and Collections

• Patient and Insurance Gross and Net Charges
• Patient and Insurance Write-offs
• Patient and Insurance Total Collections
• Patient and Insurance % Collected
• Patient and Insurance % Not Collected
• Gross Profits after fees less write-offs less costs

Patient and Insurance Charges, Write-Offs and Adjustments & Collections

Sales by Product Type by Insurance Company

Patient and Insurance Charges and Actual Collections against the Charges

• Total Gross and net charges to Patient and Insurance
• Total Collected from Insurance and Patients
• Total Uncollected from Insurance and Patients
• Total Collected from Insurance and Patients
• % Collected from Insurance and Patients
• % Uncollected from Insurance and Patients
• Gross Profits after collections and from product costs

Patient & Insurance Charges and Actual Collections against the Charges

Charges to Insurance Companies Only

• Total Charged to Insurance
• Total Collected from Insurance
• Total Uncollected from Insurance
• % of charges charged to Insurance
• % collected from Insurance
• % Uncollected from Insurance

Recap of Total Charges to Insurance and Insurance Amounts Write-Off

Insurance Receivables by Insurance Company, Patient and Fee Slip Number

After you select a year or months, this report lists all fee slips that were charged to the insurance company. If the Outstanding balance is not $0.00 then there are still fee slips that have balances due. If they are past the time when they should have been closed by posting payments and/or write-offs, research the fee slip and find out why there is still an open balance. Maybe there are additional monies to be collected.

Insurance Receivables by Insurance Company, Patient and Fee Slip Number

Gross Profits by Frames and Lenses after Insurance Write-offs and Costs

When you sell a frame or lens to patients with insurance and there are product costs and write-offs made, do you know what frames and lenses you are losing money on by selling that frame and/or lens? If you know which ones you are losing money on but still have to sell the frame, maybe instruct your staff to try and steer the patient away from that frame or locate the frames in another area of the dispensary.

This eyeReport lists all product sales and shows you the gross profit on the product after fees less write-offs less costs.

Gross Profits by Frames and Lenses after Insurance Write-offs and Costs

This one lists gross profits after collections

Gross Profits after Collections

Graphs of Charges to Insurance Companies Only

• Total Charged to Insurance
• Total Collected from Insurance
• Amount Uncollected from Insurance
• % Uncollected from Insurance

Gross Fees vs. Collections - Patient & Insurance

Uncollected & % Uncollected by Insurance Company