How should a healthcare practice track revenue by provider?
The most practical way to track revenue by provider is to use classes or tags in your accounting software. In QuickBooks Online, you create a class for each provider and assign every deposit or payment to the provider who generated it. This gives you profit and loss reports filtered by provider so you can see exactly how much revenue each one brings in over any time period.
Your practice management software already tracks production and collections by provider. The accounting side needs to match. When you post deposits to QuickBooks, break them out by provider rather than lumping everything into one revenue line. If you receive a single insurance payment covering multiple providers, split the deposit accordingly. This takes a few extra minutes per deposit but makes your financial data far more useful.
Set up a consistent process for how deposits get recorded. Someone in the office should be matching each payment to the provider who performed the service, not just recording the total bank deposit. If you batch deposits, include a breakdown sheet that shows how much belongs to each provider. Without this step, you end up guessing at allocation later and the numbers lose all credibility.
Track adjustments and write-offs by provider too. Revenue alone doesn’t tell the full story if one provider has significantly higher insurance adjustments or patient write-offs than another. Net collections by provider is the number that actually matters for compensation decisions and profitability analysis. Medical and dental practices that skip this step often discover they’ve been overpaying associates or underpricing certain procedures for years.
For practices with production-based compensation or bonus structures, accurate provider-level tracking is not optional. You can’t calculate what an associate earned if you don’t know what they collected. And if you’re considering bringing on a new provider or evaluating whether an existing one is covering their costs, you need clean revenue data by provider to make that decision with confidence.
Run a monthly report comparing each provider’s collections to their associated costs including salary, benefits, and supplies specific to their procedures. This tells you the true contribution margin per provider. Most practice owners know their total revenue but have no idea which providers are actually profitable after accounting for all the related expenses.
If your books are behind or your current setup doesn’t separate revenue by provider, getting that corrected now will save you from making blind decisions about staffing and compensation. Our virtual bookkeeping services in Florida can help you configure your chart of accounts and classes so that every dollar of revenue is properly attributed from this point forward. The setup takes some initial effort, but once the structure is in place, maintaining it becomes part of your normal deposit routine.
The First Coast's Trusted Bookkeeping Partner
The Next Step:
A Free Discovery Call
Tell us where things stand with your books. Whether you're months behind or just looking for reliable bookkeeping going forward, we'll give you an honest assessment and a clear price.
More Questions
How long does it take to catch up on a year of messy books?
Most businesses can get a full year cleaned up in two to four weeks. The actual timeline depends on transaction volume, the number of accounts involved, and how much documentation you can provide upfront.
Read answerWhat's the difference between a fractional CFO and a controller?
A controller focuses on the accuracy and integrity of your financial records. A fractional CFO uses those records to guide strategy, forecasting, and business decisions.
Read answerHow do I track my actual spending against my budget?
Run a budget vs. actual report monthly from your accounting software. Compare each category to what you planned, focus on the biggest dollar variances first, and figure out whether the difference is a timing issue or a real overspend that needs attention.
Read answerHow far behind on my books is too far behind?
There's no point where it's too late to fix. We've cleaned up books that were multiple years behind. But the longer you wait, the more it costs and the more risk you carry with the IRS and missed business decisions.
Read answerWhat's the difference between cash flow and revenue?
Revenue is the total amount your business earns from sales or services. Cash flow is the actual money moving in and out of your bank account. A business can show strong revenue and still struggle to pay bills if customers haven't paid yet.
Read answerShould I let QuickBooks automatically categorize my transactions?
You can use it as a starting point, but never accept the suggestions blindly. QuickBooks guesses based on limited information and gets it wrong often enough to create real problems in your books.
Read answer