These two reports answer two very different business questions. Both are correct, but they are used for different purposes.
(Production by Service Date)
The CPT Billed Services Report shows the value of services that were performed and billed, grouped by CPT code.
It answers the question:
“What services did we provide, and what was their billed and earned value?”
This report is based on the date the service was performed, not when payment was received.
For each CPT code, the report shows:
Used
How many times that CPT code was performed.
Total Value
The full billed charge amount for that CPT code
(what was originally charged before insurance adjustments).
Total Income
The actual earned income for that CPT code after:
Insurance contractual adjustments
Allowed amount reductions
Claim-level adjustments
This represents what the practice ultimately expects to earn for the service.
Measuring clinical production
Understanding service mix (what types of services are being performed)
Analyzing associate productivity by services rendered
Evaluating billing strategy and fee schedules
This report does not reflect when money was paid.
Services may appear here before payment is received.
(Cash Collected by CPT)
The CPT Collections (Gross) report shows actual cash collected, grouped by CPT code, based on payment date.
It answers the question:
“What money did we actually receive, and which services did it come from?”
This report is based on the date payment was received, not the service date.
For each CPT code, the report shows:
Used
The number of service units that payments were applied to.
Collected Amount
The gross dollar amount collected for that CPT code, including:
Insurance payments
Patient payments
This report intentionally shows gross collections:
It excludes refunded payments
It does not prorate refunds or adjustments across CPTs
Tracking cash flow
Measuring associate collections
Reconciling deposits and payments
Understanding what services are generating actual revenue
Because this report is payment-based:
Payments may relate to services performed in prior months
Totals will not match production reports for the same date range
This is expected and correct.
| Question | Use This Report |
|---|---|
| What services were performed? | CPT Billed Services |
| What was billed vs. earned? | CPT Billed Services |
| What money did we actually receive? | CPT Collections (Gross) |
| Associate production | CPT Billed Services |
| Associate pay / bonuses | CPT Collections (Gross) |
| Cash flow tracking | CPT Collections (Gross) |
Practices often try to answer collection questions using production reports, which leads to confusion and inflated numbers.
These two reports intentionally separate:
Production (what was done)
Income (what was earned)
Collections (what was paid)
Using the correct report ensures:
Accurate associate compensation
Clean financial reporting
Clear expectations between providers and owners