The Procedures by Contracted Amount Report displays completed procedures (and other charges) and the payments and adjustments that are associated with those procedures (or charges). For each completed procedure, the contracted rate with the patient's insurance carrier (payer) also appears.
|
Why: |
To analyze contracted rates for payers |
When: |
As needed |
To generate the report
In DXOne Reporting, select Lists, and then double-click Procedures By Contracted Amount.
The Procedures By Contracted Amount dialog box appears.
Set up the following options:
Date Range - To filter the report by date, do one of the following:
To include patients with procedures that have dates (based on the Date Type) within a range that you specify, select the Specific Range option. With this option selected, do one of the following:
Enter a date range (in a m/d/yyyy format) in the From and To boxes.
To select a date, do the following for From and To:
Click the corresponding calendar icon to view a month calendar.
Navigate to the correct month, using the left and right arrows.
Note: To quickly change the year and month, click the month-year at the top of the calendar, navigate to the correct year, using the left and right arrows, and then click the correct month.
Click the correct day.
To include patients with procedures that have dates (based on the Date Type) within a range that is relative to the report date, select the Relative Date Range option. With this option selected, select one of the following relative date ranges from the list:
Current Day Current MTD Current Fiscal YTD Current Calendar YTD |
Previous Day Previous Week Previous Month Previous 3 Months Previous 6 Months Previous Fiscal Year Previous Calendar Year |
Next Day Next Week Next Month Next 3 Months Next 6 Months Next Fiscal Year Next Calendar Year |
Date Type - Select one of the following options:
Entry Date - To include a procedure based on the date that it was created (entered into the database).
Procedure Date - To include a procedure based on the date that was specified for it.
Notes:
Most of the time, a procedure will have the same entry and procedure date. They will differ only if you backdate the procedure.
Using a relative date range is recommended if you want to save the current report settings as the default settings so you do not have to manually enter a date range each time you run the report.
Patient - To filter the report by the patients who are associated with procedures, do one of the following:
To include all patients in the clinics that you are allowed to generate the report for, select the All checkbox for both From and To.
To include a specific range of patients, select the starting patient (alphabetically by last name) of the range for From and the ending patient of the range for To.
To include a specific patient, select the same patient for both From and To.
To include an open-ended range of patients, select a patient for either From or To, and then select the All checkbox for the other option.
To select a specific patient for From or To, do the following:
Click the corresponding search button
.
The Selection Patients dialog box appears.
Note: Only the patients in the clinics that you are allowed to generate the report for are available.
Do one of the following:
To get a list of all patients, do not enter any search criteria.
To search for patients by last name, birth date, status, chart number, Social Security Number, ID, and/or home phone number, enter the first character or more of a patient's last name, birth date, status, chart number, Social Security Number, ID, and/or home phone number in the Name, Birthday, Status, Chart#, SS#, OtherId, and Home Phone # boxes, respectively.
Note: To clear any text that you have entered, click Clear Search.
Click Show Results to view a list of patients.
Note: To clear the list so you can search again, click Search.
In the list, select a patient.
Click OK.
Clinic - To filter the report by the clinics that are associated with procedures, do one of the following:
To include all clinics that you are allowed to generate the report for, select the All checkbox.
To include specific clinics, do the following:
Click the search button .
The Select Clinics dialog box appears.
Note: Only the clinics that you are allowed to generate the report for are available.
If the list is long, to search for a clinic by ID and/or title, do the following:
Click Search.
The options for searching appear in the upper list.
Enter the first character or more of a clinic's ID and/or title in the ID and Practice Title boxes, respectively.
Click Show Results to view a list of matching clinics.
Note: To return to viewing the list of all the clinics, click Search, click Clear Search to clear the search criteria that you entered, and then click Show Results.
In the upper list, select one or more clinics.
Note: To select multiple clinics, click a clinic, and then, while pressing the Ctrl key, click the other desired clinics. To select a range of adjacent clinics, click the first clinic of the desired range of clinics, and then, while pressing the Shift key, click the last clinic of the desired range of clinics.
Click Add.
Repeat steps b-d as needed to add other clinics.
Note: To not include a clinic that you added, select that clinic in the lower list, and then click Remove.
Click OK.
Patient Status - To filter the report by the statuses that are associated with patients who have procedures entered in their records, do one of the following:
To include all patient statuses, select the All checkbox.
To include specific patient statuses, do the following:
Click the search button .
The Select Patient Status dialog box appears.
To search for a patient status by ID and/or name, do the following:
Click Search.
The options for searching appear in the upper list.
Enter the first character or more of a patient status's ID and/or name in the ID and Patient Status boxes, respectively.
Click Show Results to view a list of matching patient statuses.
Note: To return to viewing the list of all the patient statuses, click Search, click Clear Search to clear the search criteria that you entered, and then click Show Results.
In the upper list, select one or more patient statuses.
Note: To select multiple patient statuses, click a patient status, and then, while pressing the Ctrl key, click the other desired patient statuses. To select a range of adjacent patient statuses, click the first patient status of the desired range of patient statuses, and then, while pressing the Shift key, click the last patient status of the desired range of patient statuses.
Click Add.
Repeat steps b-d as needed to add other patient statuses.
Note: To not include a patient status that you added, select that patient status in the lower list, and then click Remove.
Click OK.
Patient Tag - Do one of the following:
To not filter the report by a patient tag, clear the Run By Patient Tag checkbox.
To filter the report by the tags that are assigned to patients who have procedures entered in their records, select the Run By Patient Tag checkbox. With this checkbox selected, the options to filter the report by tag are available. Do one of the following:
To include patients with any patient tag, select the All checkbox.
To include patients with specific tags, do the following:
Click the search button .
The Patient Tag Selection dialog box appears.
If the list is long, to search for a patient tag, do the following:
Click Search.
The options for searching appear in the upper list.
Enter the first character or more of a patient tag name in the Tag Name box.
Click Show Results to view a list of matching patient tags.
Note: To return to viewing the list of all the patient tags, click Search, click Clear Search to clear the search criteria that you entered, and then click Show Results.
In the upper list, select one or more patient tags.
Note: To select multiple patient tags, click a patient tag, and then, while pressing the Ctrl key, click the other desired patient tags. To select a range of adjacent patient tags, click the first patient tag of the desired range of patient tags, and then, while pressing the Shift key, click the last patient tag of the desired range of patient tags.
Click Add.
Repeat steps b-d as needed to add other patient tags.
Note: To not include a patient tag that you added, select that patient tag in the lower list, and then click Remove.
Click OK.
Other Options - Select or clear the following checkboxes as needed:
Excel Friendly - With this check box selected, the report displays the data in a format that you can easily export to a spreadsheet program. With this checkbox clear, the report displays data in its standard format.
Do not display Patient Name - With this checkbox selected, the report does not display patient names. With this checkbox clear, the report displays patient names.
Click Save as Default to save the current settings for the next time you run the report.
Click Clear Defaults to revert the dialog box options to the original defaults.
Click Schedule to schedule a report job.
Click OK to preview the report.
Important information this report provides
You can hide the patient names by selecting the Do not display Patient Name check box when setting up the options to run this report. You can also display this report in a format that you can easily export to a spreadsheet program. The list is sorted by patient, payer, and then date (of the completed procedure, of the charges not applied, and then of the credits not applied).
Procedure Information - Details regarding the procedure, such as the Date of Service (if the report was run by Procedure Date) or Entry Date (if the report was run by Entry Date), Patient Name, ADA Procedure Code and Description, and Payer Name (based on the primary dental insurance carrier of the claim with the completed procedure attached to it; or if there is not a claim, the payer is blank).
Charge - Consists of one of the following:
The amount charged for the completed procedure.
The sum of other charges:
Charge adjustments.
Insurance charge adjustments.
Finance and late charges.
Charge initial balances.
Charge special adjustments.
Contracted Rate - The amount allowed by the payer. This amount is based on the insurance carrier’s fee schedule. If the procedure is not attached to a primary dental claim, the contracted rate is blank. If the procedure is not associated with the insurance carrier’s fee schedule (or the insurance carrier does not have a fee schedule), the contracted rate is blank.
Payment - The sum of the payments that are associated with the completed procedure regardless of the allocation date:
Guarantor payments.
Insurance payments.
Adjustment - The sum of any adjustments that are associated with the completed procedure regardless of the allocation date:
Credit adjustments.
Credit initial balances.
Credit special adjustments.
Remaining Balance - The difference of the Charge and the Payment and Adjustment amounts.
