🚨 Important to remember: This is a Tier 3 report. If you do not have access to the report. Please contact our support team to upgrade on Support@mypracticecloud.com
📝 Please note: This report is coming soon for Dentally users.
Why Use Treatment Types and Appointment Chair Time Report:
Analyse Appointment Efficiency
Compare scheduled time vs. actual chair time for each treatment type.
Identify treatments that consistently run longer or shorter than expected.
Adjust scheduling templates to better match real-world times, reducing delays and patient wait times.
Improve Clinical Workflow
Spot variations in chair time between clinicians for the same treatment type.
Investigate causes like technique differences, patient complexity, or documentation practices.
Use findings to standardize best practices or provide targeted training.
Financial & Productivity Insights
Link chair times with billing codes to assess productivity and profitability by treatment.
Identify opportunities to improve throughput without compromising care quality
Report Description
This report compares the scheduled appointment time for a treatment with the actual chair time recorded.
🚨 Important: The accuracy of the report depends entirely on clinicians correctly using the Patient Management Software (PMS) to log chair time. If a seating time is started but not properly closed, it may result in chair times being recorded as several hundred minutes.
The report parameters are:
Start/End Date: Optional unless Date Range is unused. Used to set a custom reporting period.
Date Range: Predefined periods that override manual date entry.
Practices: Only one practice can be selected at a time.
Providers: Defaults to all active; consider including inactive for historical data.
Payor Code: Optional filter; defaults to all codes in the PMS.
Reporting Level: Controls how detailed the report is.
Reporting Levels
There are three reporting levels: Invoice Summary, Invoice Total, Invoice Lines.
Invoice Summary Reporting Level and what it shows
Invoice Summary Reporting Level and what it shows
Practice: Practice name selected from Practices parameter.
Working Provider: Code of the COT Provider
Working Provider Type: The role (Dentist, Therapist etc) of the Working Provider as defined in the Patient Management Software (PMS)
Invoice Payor Code: The payor code of the payor associated with the invoice, for example NHS, Private, or DENPLAN
Scheduled Length (Minutes): Appointment time scheduled in the Patient Management Software (PMS) Appointment Diary
Appointment Chair Time (Minutes): The seating time managed by the Provider in the Patient Management Software (PMS) from the start of the appointment treatment to when the patient leaves the surgery
Invoice Count: The number of invoices associated with the Working Provider and their appointments during the reporting period
Invoice Line Count: The number of invoice lines (items) within the total Invoice Count
Payor Fee: The invoice amount if the invoice is a payor invoice
Patient Fee: The invoice amount if the invoice is a patient invoice
Total Fee: The total invoice amount i.e. Payor Fee + Patient Fee
Invoice Total Reporting Level and what it shows
Invoice Total Reporting Level and what it shows
If the 'Reporting level' parameter is set to 'Invoice Total', the following additional fields are shown:
Patient: The full name of the patient associated with the COT
Patient Code: The Patient Management Software (PMS) code for the patient associated with the COT
Owning Provider: The Patient Management Software (PMS) Provider Code of the Dentist that has been assigned to the Patient. This Provider may not have ever completed any work on the Patient and thus maybe different to the Working Provider i.e. the Provider who has performed a treatment on the patient
COT No.: The unique Course of Treatment reference number. Clicking on the COT number will open a new tab in the browser showing the Treatment Plans Detail
Invoice No: The invoice number generated by the Patient Management Software (PMS) for the treatment undertaken by the Working Provider
Date: Date of the appointment and treatment
No. of Lines: The number of invoice lines (items) within the invoice
Service Code (Highest Value): The service code within the COT with the highest fee
Service Description (Highest Value): Description of the service code (from the Patient Management Software (PMS)) with the highest fee
Invoice Lines Reporting Level and what it shows
Invoice Lines Reporting Level and what it shows
If the 'Reporting level' parameter is set to 'Invoice Lines', every line item that comprises the invoice is shown. This Reporting level has the following additional field:
Line No.: The line number of this line within the invoice (1, 2, 3, etc).
To download a copy of your report you can use the Export Data button to download a CSV spreadsheet.
You can use the Print button in the top right as needed.
To set up automation of the report you can use the Schedule Report button.