Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

MPC KPI Tracking


*Practice Hours – Hours available

Performance > Appointment Analysis By Period report
*Missed revenue will be automatically calculated by other field' being filled in (Patient Revenue and Chairtime utilisation)







Patient Revenue Private

Use "Income Report (Financial Reports)" .
Use the sum of all figures (all except NHS) for private revenue: Totals

Chair-time Utilisation

Use "Appointment Analysis by Period (New) (Performance Reports)"

  • Select: Hours available, Hours worked, Whitespace %, Worked %, New patients, Hours cancelled, Hours failed (FTA)
  • Summary Level: Practice
  • Cancel Reasons: "None"

For Chair-time Utilisation use the "Worked %" figure:


Unbooked time

As above: Use "Appointment Analysis by Period (New) (Performance Reports)"
Calculation: Unbooked %

Short notice cancellations

As above: Use "Appointment Analysis by Period (New) (Performance Reports)"
Use: "Hours cancelled %

FTAs

As above: Use "Appointment Analysis by Period (New) (Performance Reports)"
Use: "Hours Failed %"





Billable hours

As above: Use "Appointment Analysis by Period (New) (Performance Reports)"
Calculation; "Hours worked + Extra Hours"
Get new pt numbers in this report before next item…

Recall Effectiveness

From the dashboard homepage – Click "Practice Management Tab" on left side of screen. Use the figure against the relevant month under "Recall Effectiveness":



Outstanding recalls

From the Practice Management Tab under Recall effectiveness – clink on the arrow (top right of that section)
Use: Failed for the relevant month (many need to date range the report)

Average hourly earnings

Use "Gross Revenue & Waiting Time (Performance Reports)":

  • Remove "Stock" from drop-down list

Calculation: "Earnings/Hour available" column, make sure to date range report


Dentist AHE Worked

Use "Gross Revenue & Waiting Time (Performance Reports)":

  • View the income report, under Financial Report, this breaks down the dentist vs Hygienists
  • Change to Monthly Report
  • Include all providers except Hygienist from the dentist drop down list – never include Stock

Use "Earnings/Hour" column






Hygienist AHE Worked (as above but select Hygeinists)

Use "Gross Revenue & Waiting Time (Performance Reports)":

  • View the income report, under Financial Report, this breaks doen the dentist vs Hygeinists
  • Change to Monthly Report
  • Include all providers except Hygienist from the dentist drop down list – never include Stock

Use "Earnings/Hour" column





Practice AHE Worked

Use "Gross Revenue & Waiting Time (Performance Report)

  • Remove Stock


Use "Earnings/Hour" in Summary






New patients

As above: Use "Appointment Analysis by Period (New) (Performance Reports)"
Calculation: "New patients"

Net Patients (0-24m)

Use "Active Patients in Period (Performance Reports)
Calculation: "Active Patients" – Select year / Month

Debt

Use "Debtors List (Financial Reports)" – up to the end of the relevant calendar month:

  • Select; "Debt", "Active", "All" (total of all totals – bottom of list)





Workflow compliance Planned and Failed Recalls

Use "Workflow Compliance Period (Performance Report)"
Failed

  • Select "Monthly Report", "Practice"
  • Show Success/Failure as "Failed"
  • At the bottom use show/hide report data


Success

  • Select "Monthly Report", "Practice"
  • Show Success/Failure as "Success"
  • At the bottom use show/hide report data


Use just the percentage on the success of key items. This is a breakdown of patients who left with everything completed.

  • No labels