Purpose
The Income Allocation Extended Report is used to measure provider and location financial performance within a dental practice.
It provides real-time data that shows production, applied payments, adjustments, and other financial transactions that impact provider income and overall practice revenue.
|
Best Practices: The report includes several views, but the Income Allocation View should be the primary way dental offices run the report as it provides the most complete picture of provider performance. |
Why This Report is Important
This report helps dental practices understand how production and applied payments (how collections have been distributed) translates into provider income and practice revenue.
It allows offices to:
Evaluate provider performance across locations
Understand the relationship between production and reconciled collections (payments applied to completed services against a respective provider)
Track adjustments that affect revenue
Monitor advance payments and allocations
Review income reductions and provider adjustments
This report is especially valuable for practices that need accurate financial data for provider compensation, payroll calculations, and financial analysis.
Running this report regularly helps leadership identify revenue trends, production efficiency, and financial discrepancies.
What Information It Provides
Income Allocation View (Primary View)
| 1 |
Opening Balance The total outstanding patient and insurance balances for the respective locations/providers at the start of the selected period. |
| 2 |
Gross Production Represents the full income potential of the practice based on services rendered. Translates to the total production value generated before any adjustments, write-offs, fee updates or deletions are applied.
|
| 3 |
Production Adjustments Adjustments that impact production totals. |
| 4 |
Net Production Refers to the value of a procedure after all production adjustments have been applied to a completed procedure code.
|
| 5 |
Applied Payments Refers to funds that have been allocated to a completed procedure code. This means the payment has been officially assigned to a specific service and attributed to the responsible provider and location. |
| 6 |
Collection Adjustments Adjustments applied to completed procedures that impact Net Applied Payments and Net Collection. |
| 7 |
Net Applied Payments Applied payments +/- collection adjustments. |
| 8 |
Closing Balance Remaining outstanding balance for the selected time period based on opening balance +/- net production and applied payments. |
| 9 |
Advance Payments Payments collected before services are completed. These receipts are tagged |
| 10 |
Allocated Advance Payments Total $ value of receipts that were applied to completed services during the selected time period that were originally entered as an ‘Advance Payment’. |
| 11 |
Provider Adjustments Adjustments that impact production totals. |
| 12 |
Income Reduction An internal financial reallocation tool that ensures revenue attribution aligns with clinical responsibility and outcome. Commonly referred to as “Provider Payback” |
Users can click the highlighted entries to drill down for more detailed information.
|
Important to Know: Special Credits: Receipt types that have no net increase to Gross or Net Collection but behave like an unapplied credit and can be applied to balances and have an impact on applied payments Migrated Credits: Receipt Type of Special Credit, intended to mimic a payment that was previously collected in another system but used natively to decrease a current balance. |
When to Run the Report
The Income Allocation Extended Report is typically run:
Monthly for provider performance reviews
During payroll cycles for provider compensation calculations
Quarterly or annually for financial analysis
The report allows practices to retrieve data based on transaction date, payment date, or deposit date, making it useful for payroll processing and financial reporting.
Step-by-Step: How to Generate the Report
To Generate the Report:
Step 1: Navigate to the System Menu → select Operational Reports under Insights
Step 2: Search for Income Allocation Extended. Click the + Icon on the left or the Generate Report button on the right to access the report filters.
Step 3: Configure Filters
Group By
Location
Treatment Provider
Best practice is to group by both Provider and Location to evaluate provider performance.
Date Range
Maximum range is 1 year
Default is today
Location
Select one or more treatment locations.
Provider / Provider Type
Filter by specific providers if needed.
Exclusion Options
Inactive providers (excluding this limits your ability to view codes that may have been posted inaccurately)
Migrated receipt payments
Membership discount credits (Excluding this prohibits your view that may impact production-based payroll, if your office chose membership credits as a deduction from production. Excluding this also removes membership credits from applied and net applied payments.)
Special credits
Step 4: Generate the Report
Click Generate
Save Filter: to preserve your selections for future use.
Access & Permissions
If the report is not visible- connect with a super admin at your office to enable your permissions.
User Resource Article: Generate Income Allocation Extended Report