The income allocation report furnishes a comprehensive overview of location and provider transactional performance, encompassing both production and applied collection, within a specified date range. Users can assess total UCR, Gross Production, and Net Production. Furthermore, the report facilitates the ability to view provider payment allocation specifics based on paying entities and payment categories.
This report shows real-time data and is available in five views:
- Income Allocation
- Gross Production
- Applied Payments
- Adjustments
- Allocated Advance Payments
- Income Reduction
Income allocation is the consolidated high-level grouping for all production by provider. It includes Opening and Closing Balance, UCR and Gross and Net Production, Migrated Production, Applied Payments, Production and Collection Adjustments, Net Applied Payments, Income Reduction, and Advance Payments grouped by Location or Provider.
Core Scenarios for Report Usage:
- View Opening/Closing balances, Gross Production, Production Adjustments, Net Production, Advanced Payments, Applied Payments, Collection Adjustments, and Net Applied Payments for a provider and/or location.
- Establish Provider Payroll and use transactional data to rectify any underpayment or overpayment situations, regardless of whether providers are compensated based on production or applied payments.
- Generate a report based on the Transaction Date to track provider performance.
- Employ filters such as Location, Provider Type, Provider, and Patient Flag for a detailed analysis of completed services, Production and Collection Adjustments, and Net Applied Payments, among other aspects.
To run the report, perform the steps below:
- Navigate to the System Menu > Operational Reports.
- Click the + icon of Income Allocation or click on Generate Report to create a new report.
- Select the desired Filter Criteria.
- Click Generate Report.
|
Note: The filters with red asterisk signs are mandatory fields. |
Income Allocation View, the filter options include:
- Group By*: Decide whether to group the report results by Provider or Location. By default, the Provider will be selected.
- Sort By*: Decide whether to sort the report results by Name, Gross Production or Applied Payments. By default, the Name will be selected.
- Date Range*: The income Allocation report is dated by Transaction date. Focus the report on transactions made within your selected date range. By default, the current date will be selected.
- Location*: Focus the report on transactions completed at the selected location(s). By default, the User's default location will be selected.
- Provider Type*: Generate the report data based on the type of provider (dentists, hygienists, or both). By default, All is selected.
- Provider: Choose whether to focus the report on the selected treatment provider(s).
- Patient Flag: Choose whether to focus the report based on patients with the selected patient flag(s).
- Exclude Inactive Providers: Checkmark this option to exclude inactive providers from the report.
Income Allocation Report
The report provides information in column form grouped by either provider or location as selected. The report also has a consolidation of the income allocation values across all the selected providers and locations at the end of the report. Remember that you can use the tools in the top blue icon bar to move quickly through the pages or adjust the size.
The results columns shown in the above report include:
- Provider: The treatment provider to which these transactions apply.
- Opening Balance: The opening balance of outstanding charges that remained to be collected going into this selected time period.
- UCR: The total UCR of procedure codes checked out transactionally in the selected date range.
- Gross Production: The Pound amount of production generated from procedures completed by this provider at this location.
- Prod Adj.: The pound amount of positive/negative adjustments made against this provider's production generated at this location.
- Net Production: The pound amount of production generated by this provider at this location, including any production adjustments made.
- Migrated Production: The total production brought in by the MSB codes.
- Applied Payments: The pound amount of payments that have been applied towards these balances.
- Collection Adjustment: The pound amount of positive/negative adjustments made against this provider's expected receivables at this location.
- Net Applied Payment: The pound amount of payments applied towards these balances after any collection adjustments are made.
- Closing Balance: The remaining balance will be collected for this provider at this location after production is generated and receivables are collected during this period.
- Advance Payments: The total dollar amount of advance payments collected during this time period.
- Allocated Advance Payments: The total pound amount allocated from the advance receipts is added to the selected date range.
- Income Reduction: The total dollar amount of income reduction payment type added against the provider.
Applied Payments View
Applied Payments is used to track details of payments applied to codes and includes Patient and Insurance Payments and Adjustments, Reversals, and Patient and Insurance Collection Adjustments. This view details the Date of Service, Patient Name, Carrier, Code, Adjustment Code - Description, User Name, and Amount. It also shows the estimate of the code.
The net applied payment view consists of patient payments that are applied, the reversals of payments applied, collection patient adjustments, and collection insurance adjustments. Each of these sections and groupings has the totals shown and shows the consolidated Grand Total - Applied Payments, Grand Total - Reversals, Grand Total - Collection Adjustments, and Grand Total - Net. Applied Payment at the end of the report.
The results columns shown in the above report include:
- Provider: The treatment provider to which these transactions apply.
- Patient ID: The Identifier of the patient that was seen for treatment.
- Patient Name: The name of the patient that was seen for treatment.
- Paying Patient: Mention the name of the patient who is paying the amount.
- Code: Mentions the treatment procedure in context.
- Code - Description: The procedure code that was completed for this patient, along with its description.
- Date Of Service: The date on which the patient was seen by their treatment provider for the completion of these services.
- Patient Balance: The patient's balance at the time of checkout.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system.
- Receipt User: The user who completed the transaction in the system.
Adjustments View
This view provides details on Patient Adjustments made during the selected date range. This report can be generated by Production or Collection Adjustments. Details include Transaction Date, Carrier, Code, Date of Service, Patient Name, Adjustment Code - Description, User's Name, and Amount.
The adjustments view consists of two sections- patient side production/ collection (as selected) adjustments and insurance production/ collection (as selected) adjustments. Each section has the totals shown and shows the consolidated Grand Total - Production/ Collection (as selected) Adjustments at the end of the report.
The results columns shown in the above report include:
- Provider: The treatment provider to which these transactions apply.
- Patient ID: The Identifier of the patient that was seen for treatment.
- Patient Name: The name of the patient that was seen for treatment.
- Adj. Code - Desc.: The adjustment code used to adjust the resulting balance for treatment completed (along with the description and action of the adjustment code).
- Amount: The pound amount of the adjustment completed.
- Code: Mentions the treatment procedure in context.
- Desc: The procedure code that was completed for this patient, along with its description.
- D.O.S: The date on which the patient was seen by their treatment provider for the completion of these services.
- User Name: The user that completed the transaction in the system.
Allocated Advance Payments View
Allocated Advance Payments allows the user to see the details of payments applied from Advance Payment receipts and includes the details associated with the Advance Payments, Transaction Date, Patient ID, Patient Name, Receipt Location, Receipt Provider, Treatment Location, Treatment Provider, Applied Payment Transaction Date, Paying Patient, Code, Code Description, Date of Service, Patient Amount, Insurance Amount, Receipt # and User's Name.
The allocated advance payments view shows the payments that are applied from the advance receipts from the selected locations in the selected date range. The applied payments allocated from the advance receipts are shown as positive, while their reversals appear negative. This differs from the primary report. The view also has a total that shows the total applied payments that are allocated from the advance receipts, which were added in the selected date range.
The results columns shown in the above report include:
- Receipt Location: The receipt location of the advance receipt in context.
- Patient ID: The Identifier of the patient that was seen for treatment.
- Patient Name: The name of the patient that was seen for treatment.
- Applied Payment: The amount applied against the code from the advance receipt.
- Treatment Location: Treatment location of the code.
- Treatment Provider: Treatment provider of the code.
- Paying Patient: Mention the name of the patient who is paying the amount.
- Code: Mentions the treatment procedure in context.
- Code Desc: The procedure code completed for this patient, along with its description.
- Date of Service: The date on which the patient was seen by their treatment provider for the completion of these services.
- Patient Balance: The patient's balance at the time of checkout.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system.
- Receipt User: The user who completed the transaction in the system.
Practices can use this guide as a quick reference to run the Income Allocation Report.