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 track and account for medical equipment financing and lease payments?
The accounting depends on whether you have an equipment loan, capital lease, or operating lease. Recording the full monthly payment as an expense is the most common mistake. Each arrangement requires different treatment on your balance sheet and income statement.
Read answerHow should I handle change orders in my construction job costing system?
Track each change order as an amendment to the original contract. Update the total contract value and revised cost estimate in your WIP schedule, and keep unapproved change orders separate until the client signs off.
Read answerHow do I account for tip income and tip reporting requirements at my salon?
Your obligations depend on whether your stylists are W-2 employees or booth renters. Employees must report all tips to you, and tips over $20 per month are subject to FICA. Booth renters handle their own tip reporting on Schedule C.
Read answerWhat are the most commonly missed tax deductions for owner-operator truck drivers?
Per diem alone can save owner-operators thousands each year, and most drivers miss it entirely. Other commonly overlooked deductions include ELD device fees, lumper fees, scale tickets, truck washes, and DOT physicals.
Read answerWhat bookkeeping records does a licensed contractor need to keep for state board compliance?
Arizona's Registrar of Contractors requires financial records that demonstrate solvency. That means keeping job contracts, invoices, receipts, payroll records, insurance certificates, and license renewal documentation with a minimum three-year retention period.
Read answerHow 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 answer