How to Compare Dental Payroll Against Collections
Compare earned and paid dental staff costs, weight rolling payroll percentages correctly, and attribute clinic collections before a staffing decision.
Compare earned and paid dental staff costs, weight rolling payroll percentages correctly, and attribute clinic collections before a staffing decision.
Calculate dental staff payroll as a percentage of collections by dividing a clearly defined staff cost by net posted collections for the same reporting window. Then compare the cost earned during that window with the cash paid during it. A third payroll date or collections from older treatment can change the percentage without proving the practice needs fewer people.
This guide helps an established practice choose between additional clinical support, front-office capacity, or further investigation. Our associate compensation reconciliation guide checks an individual provider's contract and payable balance. Here the decision concerns the practice's staffing mix and the reliability of its comparison.
For the example below, staff cost includes hygienists, assistants, and administrative employees, plus associated employer payroll taxes and benefits. It excludes dentist compensation, owner distributions, contractor invoices, and unrelated overhead. These are chosen management categories. Show excluded labor separately so replacing an employee with temporary coverage does not appear to eliminate the cost.
Use gross wages rather than employees' take-home pay. Do not add employee tax withholding to gross wages again. State how paid leave, bonuses, employer benefits, and temporary coverage are classified. Where benefit invoices cover several periods, ask the accountant to prepare a consistent management allocation and reconcile it to the ledger.
Define the denominator as practice-management payments posted during the period, less refunds, under a saved reporting policy. Identify unapplied money and corrections. Reconcile the total with settlement reports; bank deposits may differ because of settlement timing and withheld fees. Use the dental deposit exception checklist to explain that difference before interpreting payroll percentages.
The IRS accounting-method guide explains general cash and accrual timing, with exceptions. A staffing worksheet can show both views, but it does not change the practice's tax method. Label the management adjustments and let the accountant determine the books' treatment.
Original hypothetical example: Assume all figures below are invented, with complete records and no other payroll adjustments. During one month, gross staff wages paid total $42,000. Of that amount, $12,000 was earned in the previous month. Another $10,000 was earned in the current month but remains unpaid at the cutoff.
Current earned wages are $42,000 − $12,000 + $10,000 = $40,000. Add $5,000 of employer taxes and benefits attributed to that work period to reach $45,000 earned staff cost. Actual staff-related cash paid is $47,000, consisting of the $42,000 wages and $5,000 employer payments assumed here. The matching employer amounts are an example assumption; real payment timing can differ.
With $150,000 net posted collections, the earned-cost ratio is $45,000 ÷ $150,000 = 30.0%. The paid-cost ratio is $47,000 ÷ $150,000 = approximately 31.3%. The 1.3 percentage-point difference comes from the stated timing assumptions. Neither result is an industry target, and the earned-cost ratio still does not match wages to the exact treatment that generated those collections.
Maintain monthly earned staff cost and collections using the same definitions. For a rolling three-month view, divide the sum of costs by the sum of collections. Do not average monthly percentages when collections differ. Keep the monthly columns visible because a rolling result can conceal a recent deterioration.
| Hypothetical month | Earned staff cost | Net collections | Ratio |
|---|---|---|---|
| 1 | $30,000 | $100,000 | 30.0% |
| 2 | $45,000 | $150,000 | 30.0% |
| 3 | $45,000 | $200,000 | 22.5% |
| Combined | $120,000 | $450,000 | 26.7% |
The combined calculation is $120,000 ÷ $450,000 = approximately 26.7%; averaging the three monthly percentages gives 27.5%, which answers a different question. Assume month 3 contains $40,000 of an unusually large older-balance collection. A separately labeled sensitivity excluding that receipt has $410,000 collections and a 29.3% ratio. Retain the actual 26.7% result and explain the sensitivity; do not silently remove inconvenient receipts.
Review working days, leave, temporary coverage, and collection timing beside the trend. Compare a longer consistent history where seasonality matters. A lower ratio caused by one old payment gives little evidence that today's schedule can support a permanent hire.
For multiple clinics, define collections by the treatment location in the source records, if reliable, rather than the bank account receiving the deposit. Track staff who work across clinics using approved time records. Allocate shared administration by a stated method and keep unassigned receipts or hours visible. Reconcile clinic totals to the practice total before comparing clinics.
For a separate invented illustration, clinics A and B collect $90,000 and $60,000. Direct earned staff cost is $23,000 and $14,000. Shared cost of $8,000 is allocated 60% to A and 40% to B using documented support hours. Costs become $27,800 and $17,200; ratios are approximately 30.9% and 28.7%. The checks are $27,800 + $17,200 = $45,000 and $90,000 + $60,000 = $150,000.
Those percentages do not rank clinical quality or staff effort. A's treatment mix, service hours, or receipt timing may differ. The allocation needs evidence and an explanation before it can support moving people between locations.
Suppose a proposed support role costs $4,000 monthly including employer costs. The owner estimates it could support $7,000 additional monthly collections after the hiring ramp, with $1,500 additional nonlabor cash costs. The assumed incremental amount is $7,000 − $4,000 − $1,500 = $1,500 before other effects. If only $3,000 arrives during the ramp, it becomes negative $2,500.
Compare that proposal with billing support only if specific unresolved claims and follow-up capacity support its receipts assumption. Assign a review date and measure actual hours, collections, and incremental spending. The SEC financial-statement guide distinguishes profit from cash; check payment timing as well as the staffing percentage.
TaxBowl's dental practice accounting service can connect the payroll bridge, rolling comparison, and clinic attribution to a supported hiring discussion. Bring the saved reports and assumptions so the owner can judge what additional work the proposed role can realistically support.