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 1031 exchange cost basis and carryover depreciation on the replacement property?
The replacement property's basis equals the relinquished property's adjusted basis plus any additional cash you paid. Depreciation splits into two layers: carryover from the old property on its remaining schedule and a new 27.5-year schedule on any additional basis.
Read answerWhat are the penalties for misclassifying employees as 1099 contractors?
The IRS will assess back FICA taxes, income tax withholding penalties, and W-2 filing penalties. Arizona adds back unemployment taxes plus interest. Intentional misclassification doubles the federal penalties, and you may also owe back pay for overtime, benefits, and workers' comp.
Read answerWhat are the trust accounting requirements for property managers in Arizona?
Arizona requires property managers to hold tenant deposits and collected rents in a separate trust account, never commingled with operating funds. A monthly 3-way reconciliation of the bank statement, trust ledger, and individual tenant ledgers is required, and violations can result in license revocation.
Read answerHow much cash reserve should an HVAC contractor keep for the slow season?
Plan for three to six months of fixed overhead in a dedicated savings account. HVAC businesses have predictable seasonal dips during the shoulder months between heating and cooling demand, so building that reserve during peak season is the move.
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 answerHow do I account for service agreements and maintenance contracts in my HVAC business?
Record the payment as deferred revenue when collected, then recognize it as earned revenue when each service visit is performed. This prevents your P&L from overstating income in the months you collect and understating it in the months you do the work.
Read answer