How do I track provider productivity and revenue per provider in a multi-provider practice?
The foundation is tracking collections by provider, not charges. Charges represent what you billed. Collections represent what you actually received. In a medical or dental practice with multiple providers, insurance adjustments, write-offs, and denial rates can vary significantly from one provider to the next. A provider billing $50,000 per month but collecting $30,000 is performing very differently from one billing $40,000 and collecting $35,000. If you only look at production numbers you are missing the real story.
The simplest way to set this up in QuickBooks Online is with classes. Create a class for each provider and assign every revenue transaction and direct expense to the appropriate class. When insurance payments come in, allocate them to the provider who generated the charge. Your practice management software already tracks this at the claim level, so the data exists. The key is making sure it flows into your accounting system correctly so your financial reports reflect reality by provider.
Your PMS reports are actually the better source for granular clinical production data. QBO is where the full financial picture comes together. Use both. Pull production and collection reports from your PMS to see the clinical metrics, then use QBO class-based profit and loss reports to see the complete financial picture including allocated overhead.
Collections per visit tells you how much revenue each patient encounter actually generates for a given provider. This varies based on the types of procedures performed, payer mix, and how well claims are coded and submitted. Collections per hour is arguably more useful because it accounts for schedule efficiency. A provider seeing six patients per hour at $45 average collection is outperforming one seeing three patients per hour at $75. Revenue per hour drives the economics of your practice more than any single number.
Overhead per provider requires allocating shared costs like rent, front desk staff, and equipment. Some costs are directly attributable, like a hygienist’s salary or provider-specific supplies. Others need to be allocated based on a reasonable method such as square footage used or percentage of total collections. This doesn’t need to be perfect, but it needs to be consistent month to month so you can spot trends and compare fairly.
Payer mix per provider matters more than most practice owners realize. If one provider’s schedule is 60% Medicaid and another’s is 80% PPO, their collection rates per visit will look very different even if their clinical productivity is similar. Understanding each provider’s payer mix helps you evaluate performance fairly and make scheduling decisions that improve overall practice revenue.
All of this connects directly to compensation. Many multi-provider practices use production-based or collection-based compensation models. If your associate’s pay is tied to a percentage of their collections, those numbers need to be accurate and transparent. Disputes over compensation almost always stem from unclear tracking rather than bad intentions. Having clean books with provider-level detail eliminates ambiguity and builds trust with your team.
Set this up correctly from the beginning. Retrofitting provider-level tracking onto months of existing transactions is possible but tedious and expensive. If you already have months or years of data that isn’t broken out by provider, getting that cleaned up and restructured is worth doing before you try to make decisions based on incomplete numbers. Good small business bookkeeping services will configure classes, map your chart of accounts properly, and build reports that actually tell you which providers are profitable and which need attention.
Your Valley of the Sun Bookkeeper
The Next Step:
A Quick Conversation
Tell us what's going on with your books. We'll listen, ask a few questions, and give you a clear quote with no surprises.
More Questions
How do I handle progress billing for large residential trade jobs?
Define clear milestones in your contract, invoice as each milestone is completed, and track your costs against each phase. Progress billing protects your cash flow so you're not financing a customer's project out of your own pocket.
Read answerHow do I track equipment costs per construction job including depreciation and fuel?
Calculate an internal equipment rate that bundles depreciation, maintenance, insurance, and fuel into a single hourly cost. Multiply that rate by the hours each piece of equipment works on a job to allocate costs accurately.
Read answerWhat vehicle expenses can a plumber or electrician deduct and should I use actual costs or standard mileage?
Both methods work, but the actual cost method usually produces a bigger deduction for tradespeople running service vans and trucks. Standard mileage is simpler. The right choice depends on your vehicle costs and how you use it.
Read answerWhat financial reports should a medical practice owner review monthly?
Focus on a P&L by provider, A/R aging by payer, collections vs charges ratio, overhead percentage, and days in A/R. Monthly review catches revenue and cash flow problems before they get out of hand.
Read answerHow do I account for Medicaid reimbursement delays and denials in my practice books?
Book claims at the expected Medicaid reimbursement amount, not your billed charges. Track Medicaid A/R separately from commercial insurance so you can forecast cash flow accurately and know which claims need follow-up.
Read answerWhat insurance costs should a contractor track by job versus as overhead?
General liability and workers comp premiums tied to job payroll should be allocated per job. Builder's risk and project-specific bonds are direct job costs. General commercial policies, office insurance, and bonding capacity costs are overhead.
Read answer
