The Production Summary Report shows the provider's overall production details with respect to different treatment locations. This report allows you to see how much each provider has produced compared to the total number of procedures completed at each location. You can customise the report to group it by provider or location, so you can easily check out the production summary for each provider or the summary for providers at each location.
To access the production summary report, perform the steps below.
- Navigate to the System Menu > select Operational Reports.
- Click the Production Summary (+) sign or click Generate Report.
This report shows real-time data and is available in two views- Summary and Detail View.
- The Summary View shows the total no. of Completed procedures, gross production, no. of appointments % of total production, etc. It shows the production summary for each provider or each location as per the grouping.
- The Detail View shows the patient-level details along with the Code, Patient ID, DOS, Patient and Insurance Amount, etc that are contributed to the production towards the Provider and Location.
- The Production Summary Report can be generated based on the Transaction Date or the Date of Service.
Note: Setting the filter criteria is essential for your report. It helps you focus on the exact information you need without going through irrelevant data. |
Summary View
For the Production Summary Report Summary View, your filter options include:
- Date As: Choose to focus the report with the selected Date as the Date Of Service or Transaction Date. By default, the date will be selected as the Date Of Service. On choosing the date as DOS, filter out codes with DOS in the selected date range. On choosing the date as Trans. Date, filter out all code completions, fee updates, and code deletions, with transaction date in the selected date range.
- Date Range: Choose to focus the report within the selected date range. The date range can be selected for a maximum of 3 months. By default, the date range will be for the current day.
- Group By: Production summary’s Summary View Report can be grouped by treatment provider or by treatment location. This decides whether to group the production by Location/Provider. By default, it will be set as Provider.
- Treatment Location: Choose the locations in which the report data should be focused. By default, the location will be the user’s default location.
- Provider Type: Choose whether to focus your report based on the selected treatment provider type. The multi-select dropdown shows Dentist, Hygienist, and In-house provider as options. This helps to filter production, fee updates, and deletions by the provider type of the provider. By default, it will be set to All.
- Treatment Provider: Choose whether to focus your report only on the selected provider(s). By default, it will be set to All.
- Exclude Inactive Providers (checkbox): Checking this excludes inactive providers. By default, it would be checked.
- Exclude Migrated Production (checkbox): Checking this excludes production entries involving MSB codes. By default, it would be checked.
Results
Summary View
The report provides information in column form grouped by treatment location or treatment provider as selected. Remember that you can use the tools in the top blue icon bar to move quickly through the pages or adjust the size.
The results columns shown in this report include:
- Location/Provider: If the group by selection is Location, the column title will be the provider and show the contribution from each provider’s split by location group.
- If the group by selection is by Provider, the column title will be location and show the contribution from each location split by provider group.
- Gross Production: It would list the gross production made by each provider/location. There would be a Total in the end to show the group aggregate value.
- Completed Procedures: In the DOS version, it represents the number of code completions with DOS in the selected date range. In the trans. date version, it represents the number of code completions that were checked out transactionally in the selected date range.
- Patients Seen: The number of patients seen by the provider in the location across the selected date range.
- No. of Appointments: This lists the number of appointments in the selected date range that are in the checked-out status. If the treatment provider has an appointment linked to that code, it is considered. The distinct appointment count for multiple codes completed in the same appointment is also considered.
- Avg Prod ($) Per Code: This shows the Gross production/Codes completed based on DOS for the DOS version and based on transactional code completions for the Trans version.
- Avg Prod ($) Per Patient: This shows the Gross production/Patient seen completed.
- Avg Prod ($) Per Appt: This shows the Gross production/Number of checked-out appts.
- % of Location/Provider Production: If the Group By option is set as Provider, this column shows the percentage of Provider Production, by taking each location production under that provider/total production in that grouping. If the Group By is set as Location, this shows the percentage of Location Production, by taking each provider's production under that location/total production in that grouping.
- % of Total Production: If the Group By is set as Provider, this column shows the percentage of Total Production, by taking each location production/consolidated total production. If the Group By is set as Location, this column shows the percentage of Total Production, by taking each provider's production/consolidated total production.
- Distinct Patients Seen: In location grouping, it gives the distinct patient seen count across the selected date range, in that particular location (across all providers). In Provider Grouping, it gives the distinct patient seen count across the selected date range, by that treatment provider (across all locations).
- Distinct Checked-Out Appts: In location grouping, it gives the total (active) checked-out appointments in the selected date range. In Provider Grouping, it gives the total (active) distinct checked-out appointments (each day) in which the provider is the treatment provider.
- % of Dentist Production: Column in Location grouping only. Total production made from providers with provider type as Dentist/total production.
- % of Hygiene Production: Column in Location grouping only. Total production is made from providers with provider type as hygienist/total production.
- % of Inhouse Production: Column in Location grouping only. Total production made from providers with provider type as Inhouse Provider/total production.
| Note: The blue-coloured entries are links to the Detail View of the corresponding entry. Click the hyperlinks to see the Detail Report listing these productions and their details. |
Detail View
The Results columns shown in this report include:
- D.O.S/ Transaction Date: The column is named D.O.S when the Date As is set to the Date Of Service, and it is named the Transaction Date when the Date As is set to Transaction Date.
- Action: This column is present if the Date As selection is set as Trans. Date, and the possible actions applied against the code will be seen here as Code completion, Code deletion, and Fee updates.
- Patient ID: The system-assigned number used to identify this patient and their records. Click this hyperlink to be taken to the patient's overview.
- Patient Name: The name of the patient that was seen for treatment.
- Code: The procedure code in which the code completion, deletion, and updates were made.
- Code Description: The description of the procedure code used.
- Tx. Location: The location where the treatment for the code was completed, deleted or a fee update was made.
- Tx. Provider: The treatment provider of the code when the action was made.
- Total Amt: The sum of the total patient estimate and the insurance estimate of the code. If the action is Code Deletion or if the fee update is to a decreased amount then this entry would be in red.
- Last Modified User: This shows the user who performed the action.
| Note: The Production Summary Report provides detailed insights into provider productivity across locations. With customisable filters and views, it helps you analyse performance efficiently, offering both high-level overviews and patient-specific details to support informed decision-making. |
Practices can use this resourceful guide to learn about generating Production Summary Reports in CareStack.