For practices that prefer to pay their dentists on net production, the best approach to use is to enable the Auto Post PPO Write-off switcher.
You can turn this switcher on or off. When it is on, the insurance adjustment will be automatically posted into the ledger when a claim is created. When it is off, no adjustment will be posted when creating the claim. Also, this insurance adjustment will post for not just PPO plans, but all insurance plans. To view a video that demonstrates how this switcher impacts the ledger and day sheet, follow this link: The impact of the auto post ppo write-offs on the ledger and day sheet: Should you turn this on or off?
Paying Dentists on Net Production: Auto Post PPO Write Off Switcher On
The best report to show each provider’s net production is one you create from scratch using the Analysis Ledger Report Builder in the Financial tab.
Add the following fields:
- Service date – choose month and year (if you pay monthly)
- Provider - add them into rows and filter out unavailable spaces
- Primary Guarantor (use this because adjustments can be applied to guarantor)
- Production or Collection - and filter to include production only - add to columns
- Description - Category - add to columns
- Measure – Amount
Under Report options, add Grand Totals for rows and Grand Totals for columns
Here is a sample of what that report will look like:
Paying Dentists on Net Production: Auto Post PPO Write Off Switcher Off
When this switcher is off, the best report to show each provider’s net production is the pre-built Adjusted Production report – customized to the timeline you’re paying on. This report is also found in the Financial tab and will takes into account primary insurance estimates based on your PPO fee schedule.
This report defaults to include 3 filters:
- First, you need to change the date from the 7 previous days, to reflect last month. To do this, click the X beside the date filter to delete this filter. Do not delete the date field, only the filter.
- Next, look in the Available Fields column under Service Date (YMD) and double click on the Month. This will add the month into the report.
- Next, right click on the Month in the yellow box on the report and choose Filter. Now checkmark Previous Month and click Ok.
As you make changes to the report you will see an alert letting you know it has been modified. Click the Refresh Report button on the far right to see the updated information.
Now you will have the following columns in your report:
Since this is hard to see, here they are:
- In yellow:
- Date (this is date of service)
- Procedure Code
- Procedure Description
- Claim Status
- In blue:
- Procedure Charges
- Applied Credit Adjustments
- Contracted Fee
- Estimated Write-Off
- Adjusted Production
Click on the yellow box labeled Month in your report and drag it all the way to the left (you’ll see a blue line appear for where this column will move to). This will automatically group your data by month first.
Now, to understand this report, you have the following columns:
Looking at the yellow column items there are several best practice reviews you can perform.
- First, you may want to have a team member look down the dates. If there is only one procedure charged out on a day, perhaps it was charged out in error?
- Next, look down the code and description columns. Make sure your dentist is being paid for the proper procedures. For example, let’s say your dentist is not paid on x-rays, if you see any x-rays listed, you should go into that patient’s ledger and change the provider.
- Finally, you will want to look down the Claim Status column. Are there any claims that have been rejected or are still outstanding that you can resend or clear up? This doesn’t impact the net production, but it does help the practice maintain cash flow.
Moving to the blue column items, there are also some best practice reviews you can perform.
- First, review the Procedure Charges column just to confirm that the fees look accurate. If you see any $0 fees, you may want to check that individual patient ledger to confirm this is accurate.
- Next, looking down the Applied Credit Adjustment column; this is where your insurance write-offs will show up. If you see any large amounts, you may want to review that patient’s ledger and confirm adjustments are applied accurately and for good reason. Best practices require a note for every adjustment created including the reason for the adjustment and the initials of the team member that applied it. You may also want to just pop quiz a couple ledgers to make sure the adjustment looks correct as well.
- Finally, look down the Estimated Write-Off column. Go to the ledger for every patient to try to close this claim.
As usual, for future auditing purposes, save this report in Excel, with each workbook labeled for a specific month and the document labeled Adjusted Production Year Provider Name, for example “Adjusted Production 2017 Dr. Tom Smith”.
General comment regarding the Adjusted Production Report
This report was built specifically to provide a detailed net production estimate and the calculation will not work correctly if the report is modified. Overall, we don't recommend changing or removing any fields in this report. (However, it is fine to change the date range from the default of the last 7 days.)
Another reporting option: Use the Day Sheet
Since most dentists and team members are familiar with looking at day sheets, you also can use this report to identify net production and pay your dentists. One item to consider is that the day sheet calculates the estimated write off for primary insurance only.
To understand the Dentrix Ascend day sheet, here are the terms to identify each of these items:
Procedure charges are Gross Production
Applied Payments + Unapplied Payments = Total receipts (for the bank)
Applied credit adjustments are adjustments entered and applied to charges within the report range (for example professional courtesy)
Unapplied credit adjustments are adjustments entered and either not applied or applied to charges outside the report range (for example another professional courtesy but outside the date range on the day sheet)
Charge adjustments are adjustments entered within the range of the report (for example patient refund)
Charges billed to insurance are procedure charges within the date range of the report that have been billed to insurance
Estimated net production is calculated inside of Dentrix Ascend - the logic is that we start with procedure charges and then factor in the estimated write off and any adjustments applied to procedures in the report range. FYI - You cannot look at the day sheet and run your own math to see the estimated net production number.
To use this to determine a dentist’s compensation, you will first run your day sheet for the date range of your pay period. To do that, choose Custom Range as your date range and select the dates of the pay period. Each time you run this day sheet to determine your dentist’s compensation, be sure to save this in a digital (or hard copy) file labeled for the pay period and the date it was run. (Tip: the day sheet information pastes nicely into Excel.)
In this example day sheet below, you can see that the estimated net production is $1,198. If you are paying your dentists 25% of net production, then you can use this number x .25 to determine their compensation.
Since the day sheet reflects an estimated net production, this suggests that this number can change. Over time, once all the insurance claims have been closed for this date range, you will see the Estimated Insurance Write-offs goes to $0. When that happens, your estimated net production is now your actual net production.
(As an aside, if you’re thinking “Wouldn’t it be great to wait until we have actual net production to calculate our dentist’s compensation?” you may want to consider setting up a draw for your dentists and then calculating their compensation using the day sheet 3 months back. On this payroll schedule, if you can successfully close all your claims in 90 days, then you would never have to worry about auditing your net production reports.)
Unfortunately, the reality is that sometimes we have open claims for several months, and that means we need to audit our net production numbers to make sure our dentists are being paid accurately.
To audit your net production, re-run your day sheet for that same pay period. Look at your Estimated Insurance Write-Offs. If it’s anything other than $0, that means you have open claims and you will want to find these open claims, get them paid and closed. This suggests that your audit for net production will continue until you run a day sheet for that provider’s pay period and finally, the estimated insurance write-offs are $0. Once you hit $0, you can stop running that date range in your auditing process.
Auditing Net Production and Tracking Open Claims
Since the day sheet does not show which patients have open claims, you will want to identify which patients have claims that are outstanding. To find this, use the Outstanding Claims report located in Home, under the Reports category. Best practices recommend running this report at the beginning of each month for the month previous, and working through each open claim until all claims are paid.
Another report you can use to audit net production and identify open claims is the Adjusted Production report (found in the Financial tab of Power Reporting). This report is only as accurate as your fee schedules set up for your insurance carriers, but it is a quick way to view open claims.
One question many dentists ask is, “Why doesn’t my day sheet match my power report?” The answer lies with the dates. The day sheet only looks at the transactions that occurred inside the date range. So let’s say your month just ended last week. As part of your auditing protocols, your team caught that a patient seen within that month had a duplicate x-ray taken and so an additional adjustment was added. The day sheet would not include this additional adjustment inside the estimated insurance write-offs because the transaction date is outside of the date range.
On the other hand, the power report (in this case the Adjusted Production report) is based on procedure date—so no matter when an adjustment is posted, it will reflect in this report. The day sheet is generally more limited by date range than the power reports.
(Article authored by J. Alldredge, J. Nesbitt 2017)