powerful reports for your practice to excel

Reports

0. Key Performance Indicators and Practice Metrics

1. Compare Insurance Company Net Collections, Profits, Charge Backs & VSP Lab Charges

2. Track Sales by Dispensers and Source

3. Track Sales by Product Categories (for Frame Reps and Buyers)

4. Analyze Daily Services and Product Sales

5. Analyze Sales w/Monthly Comparisons

6. "Trunk Show" & Patient Marketing

7. Research Patient & Insurance Charges & Payments Received

8. Track Frame and Lens Lab Orders and Notify Patients

9. Easily View & Analyze with Graphs

10. Audit Appointment, Pre-appointment, No Show and Cancelled Results - Audit Fee Slips that are Recorded

11. Analyze Payments Applied to Groups and Codes

12. Compare Provider Productivity by Codes Billed

13. Patient Charges Never Recorded and Patient & Insurance Receivables

  • 1030 - Patient Accounts Receivable
  • 1035 - Insurance Company Accounts Receivable
  • 1040 - Patient ExamWRITER and Lab Order Open Charges

14. Product & Services Setup Listings

15. Audit Financial & Inventory Adjustments, Deleted Payments, Fee Slip Postings and Electronic Insurance Claims

16. Track Who Purchased Frames and Contact Lenses

17. ExamWRITER®

18. Inventory

19. Analysis Reports for Managed Care Managers

20. eyeReports By Request


#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.

report
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
report
Patient and Insurance Charges, Write-Offs and Adjustments & Collections
report
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
report
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
report
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.

report
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.

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

This one lists gross profits after collections

report
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
report
Gross Fees vs. Collections - Patient & Insurance
report
Uncollected & % Uncollected by Insurance Company