PMS data
Clinical and scheduling activity from practice management systems is mapped into standardized measures.
Connected data
Unify PMS, Finance and Payroll Data Without Manual Reconciliation
ARQ Dental connects PMS, finance, payroll and HR data within one governed performance model. It helps DSOs standardize definitions, reduce conflicting reports and create a trusted view of performance across systems, locations and teams.
ARQ Dental is a prescriptive intelligence and enterprise performance platform built specifically for multi location dental service organizations. It unifies PMS, finance, payroll and HR data to provide standardized KPIs, performance visibility, root cause analysis and prioritized actions that help leadership improve EBITDA.
Last updated: · Published · By Arqipelago, Inc.
Why DSO systems produce conflicting numbers
Finance says one number. The PMS says another. Payroll is reconciled separately in Excel. Leadership is left deciding which report to trust.
Each system was designed for its own job, with its own definitions, calendars and categories. Production in the PMS is not revenue in the ledger. Payroll periods do not line up with accounting periods. When a group runs several practice management platforms, the same measure can be constructed differently in each one. The reconciliation work that follows is manual, repetitive and hard to audit.
- Different systems define the same measure in different ways
- Acquired practices arrive with their own configurations and habits
- Reconciliation lives in spreadsheets maintained by a small number of people
- Disagreement about the numbers slows down the decision itself
Creating one governed data model
ARQ Dental connects each source system and maps its data into a single governed performance model. Definitions are standardized once and applied everywhere, so a metric means the same thing in every location. Source data is not altered, and each figure retains a path back to where it came from.
- PMS, finance, payroll and HR data in one model
- Standardized KPI definitions maintained centrally
- Read only treatment of source systems
- Traceability from a reported metric back to its source
Key capabilities
Finance data
General ledger and financial data is aligned with operational activity in the same model.
Payroll data
Payroll information is brought into the performance model rather than reconciled separately in spreadsheets.
HR data
Workforce data provides the staffing context behind labor cost and productivity measures.
KPI governance
Definitions are agreed and maintained centrally so reporting stays consistent as the group grows.
Source traceability
Each reported figure can be traced back to the connected system and records it came from.
How it works
- 1
Inventory the systems
Every PMS, finance, payroll and HR source across the group is identified along with how each one is currently used.
- 2
Connect and map
Sources are connected and their fields mapped into standardized measures within the governed model.
- 3
Agree definitions
Leadership signs off the KPI definitions that will apply across all locations, including acquired practices.
- 4
Reconcile and validate
Reported figures are validated against source data so teams can trust the model before it drives decisions.
Standardizing KPI definitions
A definition agreed once and applied everywhere is what makes location comparison meaningful. ARQ Dental holds those definitions centrally, and the governance model is covered in more depth on standardize KPIs and operations.
Reconciling data across multiple source systems
Rather than rebuilding reconciliations each period in spreadsheets, the mapping is defined once in the model and reapplied as new data arrives. That is what removes most of the recurring work described in replace manual Excel reporting.
Maintaining traceability back to source data
Trust depends on being able to check. Every figure keeps a path back to the connected system and underlying records, so a challenged number can be verified rather than argued about.
Supporting DSOs with multiple PMS platforms
Groups rarely run a single platform, particularly after acquisition. ARQ Dental maps each connected platform into the same standardized measures so mixed estates can be reported together. Onboarding a newly acquired practice is covered on integrate new dental acquisitions.
Business outcomes
Removing reconciliation work changes both the speed and the credibility of reporting.
- Fewer conflicting versions of the same metric
- Less recurring manual effort in finance and operations
- Reporting that does not depend on a single spreadsheet owner
- A defensible audit path from metric to source record
Which systems can be connected, and how deeply, depends on the platforms in use and the data access each one permits.
Frequently asked questions
Why do PMS and finance reports show different numbers?
Because they measure different things on different calendars. Production recorded in a practice management system is not the same as recognized revenue in the ledger, and adjustments, write offs and period cut offs are handled differently in each system.
Can ARQ Dental connect multiple PMS systems?
Yes. ARQ Dental is designed for mixed estates and maps each connected practice management system into the same standardized measures. The specific platforms available for a given group are confirmed during scoping.
Does ARQ Dental change data in the source systems?
No. Source systems are read from, not written to. ARQ Dental builds its performance model from that data and leaves your PMS, finance, payroll and HR systems as the systems of record.
How are KPI definitions standardized?
Definitions are agreed with leadership and maintained centrally in the governed model, then applied to every connected location so the same measure is calculated the same way group wide.
Can users trace a metric back to its source?
Yes. Reported metrics can be opened to show the contributing detail and the connected system it originated from.
Related solutions
See your systems in one model
Book a demo and we will walk through how ARQ Dental connects PMS, finance, payroll and HR data into one governed view.