Before comparing data:
Ensure that the time period selected in Dental Intelligence matches the time period of the report pulled from Dentrix Ascend.
For the most accurate data, run reports after hours once all work has been entered in your practice management system (PMS). Hold onto those reports (printout or save to PDF), and then wait until Dental Intelligence has synced and updated KPIs are available.
Because data syncs overnight, any changes made in the PMS during the day may not yet be reflected in your reports, which can cause discrepancies.
How to Run a Production Report in Dentrix Ascend
All production reporting in Dentrix Ascend is based on the Day Sheet. Follow these steps to run it and compare it to Dental Intelligence.
From Dentrix Ascend, click the Home dropdown menu and then select Day Sheet
Set your date range to match the exact period you are viewing in Dental Intelligence (e.g., August 1 – August 31)
Leave the Run by filter set to Transaction Date
📌 On the Dental Intelligence side, reports must be run by Procedure Date. This is the only setting that aligns the two systems.
Click Search to generate the Day Sheet report
Once generated, collapse the Location Details section to review the Location Totals section of the report
Provider A/R Totals may not match because they leverage only the date that a transaction was modified rather than the date displayed in the Ledger for a procedure.
Compare Performance Board Data
Access the Performance Board from the left side menu in Dental Intelligence. Compare the location-level data from the Dentrix Ascend Day Sheet to Dental Intelligence:
Procedure Charges in the Day Sheet will match Gross Production in the Dental Intelligence Performance Board Production tile.
Compare Collections Board Data
Access the Collections Board from the left side menu in Dental Intelligence. Compare the location-level data from the Dentrix Ascend Day Sheet to Dental Intelligence:
Entered Payments in the Day Sheet in the Day Sheet will match the Collections tile in the Dental Intelligence Collections Board.
Multiple locations? If your practice has more than one location, where a payment or credit adjustment is posted versus applied can change which location it appears under. See “Multi-Location Practices: Payments and Credit Adjustments” below.
Adjustments
Dental Intelligence combines Entered Credit Adjustments and Charge Adjustments from the Day Sheet to calculate the Total Adjustments metric shown in the Performance Board Production tile. These two values together are what you should use when reconciling adjustments.
Note: Adjustments may show a slight discrepancy. Dental Intelligence is introducing a new adjustments metric for Dentrix Ascend that will align more precisely with transaction date. Until that metric is available, minor differences in the adjustments line are expected when an adjustment is entered and the user later changes the date displayed in the Ledger.
Multi-Location Practices: Payments and Credit Adjustments
If you have more than one location and apply part or all of a credit adjustment or payment to a procedure or charge adjustment in another location, this affects which location reflects the payment as posted versus applied.
Where to find the payment or credit adjustment at the location level: Look at the Collections or Collections Adjustments metric under the location where it was posted in Ascend.
Where to find the payment or credit adjustment at the provider level: Look at the Collections or Adjustments metric for the provider, under the location where the procedure was performed or the charge adjustment was posted in Ascend.
What this means when adding up provider values to the location: When payments and credit adjustments are allocated to procedures and charge adjustments in another location, provider amounts will not add up to location amounts. This matches Ascend’s logic, as shown in its Day Sheet report.
Tip: If you want provider metrics to add up to location metrics, post payments under the location where the work or adjustment was performed. Ascend does not let you reassign parts of a payment or credit adjustment to that location after the fact.
Set Adjustments Categories in Dentrix Ascend
📌 Important: Only admin-level users should change adjustment categories in Dentrix Ascend or Dental Intelligence. If the categories in the two systems don’t match, your reporting numbers won’t match either, and mismatches can be difficult to untangle once they’ve affected historical data. If you have any questions about adjustment categories, please contact Dental Intelligence Support before making changes. We’re happy to help.
How adjustments are categorized in Dentrix Ascend affects how they appear in Dental Intelligence. Adjustments can be classified as either Production or Collections adjustments. If your adjustment types are not correctly categorized, your Dental Intelligence data may not reflect the right values.
To review or update your adjustment type categories in Dentrix Ascend:
In Dentrix Ascend, go to Settings
Navigate to Ledger Options
In the Transaction Types tab, review your Charge Adjustments and Credit Adjustments and ensure each is categorized correctly as either Production or Collections
Once you've set the Charge and Credit Adjustments in Dentrix Ascend, you'll need to ensure they match what's set up in Dental Intelligence. To do this, go to portal.dentalintel.com/settings/adjustments and set them up to mirror what you've done in Ascend. Be sure to press Save after each change is made
After making changes to your adjustment categories, a full data sync is required to retroactively apply the correct classification to past transactions. Contact Dental Intelligence Support to request a full sync
Reminder: Changing adjustment categories in Dentrix Ascend will not automatically update historical transactions in Dental Intelligence. A full sync must be requested from our Support team to recapture and reclassify past adjustment data.
How to Run a Provider Production Report in Dentrix Ascend
Provider-level data is also available within the same Day Sheet — there is no need to run a separate report.
From Dentrix Ascend, click the Home dropdown menu and then select Day Sheet
Set your date range to match the exact period you are viewing in Dental Intelligence (e.g., August 1 – August 31)
Leave the Run by filter set to Transaction Date
📌 On the Dental Intelligence side, reports must be run by Procedure Date. This is the only setting that aligns the two systems.
Click Search to generate the Day Sheet report
Collapse the Location Details and Location Totals sections
The Provider sections below will display production data broken out by individual provider
Provider A/R Totals may not match because they leverage only the date that a transaction was modified rather than the date displayed in the Ledger for a procedure.
Compare Provider Pulse Data
Access the Provider Pulse from the left side menu in Dental Intelligence. When comparing provider-level data, use Applied Payments (not Entered Payments) from the Day Sheet provider sections:
Applied Payments in the provider section of the Day Sheet will match Collections in the Dental Intelligence Provider Pulse.
For provider-level adjustments, also use the Applied Credit Adjustments values rather than the Entered values.
Key distinction: Use Entered Payments when reconciling Production at the location level. Use Applied Payments when reconciling Production at the provider level.
Multiple locations? Provider-level payments and credit adjustments are reported under the location where the work was performed, so provider totals may not add up to location totals. See “Multi-Location Practices: Payments and Credit Adjustments” above for details and a tip for making them align.
If Your Report Results Don't Match
Confirm the date ranges match exactly in both Dentrix Ascend and Dental Intelligence.
Ensure the Day Sheet is filtered by Transaction Date.
Confirm your Dental Intelligence Production Display is set to Gross Production (not Net Production) for Dentrix Ascend.
If adjustments are consistently off, review your adjustment type categories in Dentrix Ascend (Settings > Ledger Options > Transaction Types) and contact Support if a full sync is needed.
If provider totals don’t add up to location totals in a multi-location practice, see the multi-location section above.
Quick Reference: Day Sheet Line Items vs. Dental Intelligence Metrics
Dentrix Ascend Day Sheet | Dental Intelligence Metric | Level | Board |
Procedure Charges | Gross Production | Location | Performance Board |
Entered Credit Adjustments + Charge Adjustments | Total Adjustments | Location | Performance Board |
Entered Payments | Collections | Location | Collections Board |
Applied Payments (provider section) | Collections | Provider | Provider Pulse |
What to Know About Dentrix Ascend Net Production
Dental Intelligence calculates Net Production as: Gross Production minus Write-Offs minus Adjustments.
Dentrix Ascend displays an Estimated Net Production figure on the Day Sheet, but this number uses a proprietary calculation that cannot be reverse-engineered or matched to Dental Intelligence. For this reason, when configuring your Production Display in Dental Intelligence for Dentrix Ascend, set your production type to Gross Production. From there, you can review the individual components (gross production, write-offs, and adjustments) separately to understand how your net production is derived.
Important: Do not attempt to reconcile the Estimated Net Production figure in Dentrix Ascend with the Net Production figure in Dental Intelligence — these numbers will not match. The Estimated Net Production in Dentrix Ascend also includes Estimated Insurance Write-Offs, which are not available to Dental Intelligence through the integration.











