Doctor Production: Reconcile the Provider Field

Which provider does doctor production follow?

Open Dental's default appointment-view production uses the appointment provider, not the procedure provider, subject to its display settings. Its Daily Procedures Report instead filters by the treating provider assigned to completed procedures. The same provider name can therefore select different rows. See appointment production totals and the Daily Procedures Report.

Before comparing two totals, name the provider field in each report. A difference may come from how rows are assigned, even when the underlying fee amounts match. A seller, buyer or accountant should resolve that grouping issue before using a provider subtotal in a larger analysis.

Worked example: one set of fees, two groupings

This invented file has four completed procedure rows in one period at one clinic. All fees are supplied inputs. There are no adjustments, write-offs or receipts. A, B and H are anonymous provider labels. Grouping the rows demonstrates the documented distinction; it is not a promise about every software version or report configuration.

Grouping by appointment provider gives A $800 and B $1,200. Grouping by procedure provider gives A $900, B $900 and H $200. Both views total $2,000. For A alone, the difference is $100; it is not missing money. Row 2 leaves A's group and row 4 enters it when the grouping field changes.

Save both assignments beside each row during the review. A matching total is a useful control, but it does not prove the provider subtotals match. Also check date, clinic and completion filters before claiming that a field choice explains the entire gap.

Two independent checks

First, raise only row 2's supplied fee from $200 to $250. The overall total becomes $2,050. A's appointment-based total rises to $850, while A's procedure-based total remains $900. The extra $50 belongs to H in the procedure grouping.

Next, reset to the original fees. In a separate supplied file, assign row 4 to procedure provider B. A's appointment-based total stays $800, while A's procedure-based total falls to $600. Procedure provider B now has $1,200 and H still has $200. The overall total stays $2,000. This tests alternate input data; it does not recommend changing provider attribution in a clinical record.

Keep the subtotal in its proper role

The exercise establishes no compensation entitlement, collections forecast or replacement labor cost. Those questions need their own agreements and evidence. Resolve the report definition first, then use only the relevant reconciled measure in that later work.

For a potential sale, start with seller-blind outreach that omits owner and practice identity, exact location, financials and staff details. Obtain an NDA before giving an authorized buyer identifying reports. Include staff when their actual reporting or transition responsibilities require it. Keep patient-data access separate from commercial disclosure approval.

Summary: reconcile the field before the amount

The base case has one $2,000 total and two different provider groupings. Each sensitivity changes one input and leaves a clear trail to the new result. Preserve that trail before relying on a subtotal in a transaction.

Related topics include production and collections, procedure mix, fee schedules and selling while staying as an associate. See the buyer guide and DSO overview for transaction context. Discuss a confidential review.