The Income Allocation report provides data points for measuring provider performance in terms of Opening and Closing Balances, Production and Collection Amounts, Adjustments, Payments, and Income Reductions.
This report shows real-time data in multiple views: Income Allocation, Gross Production, Applied Payments, Payments, Allocated Payments, Adjustments, and Income Reduction View.
Use Cases
- Evaluate Provider performance across multiple locations.
- Retrieve data based on Transaction Date, Payment Date, Deposit Date, etc., to use for Payroll processing.
Let's get started!
- Navigate to the System Menu > select Operational Reports under Insights.
Click the + icon on the left or the Generate Report button on the right for the chosen report.
| Tip: You can access the automated Payroll feature right from here. Just click ‘Try Now’. |
Explore below to learn more about the desired views, filter criteria, and results.
The report provides information in column form. The report results will be displayed in the order that the data variables in the Group By filter are selected. The user can drill through the options based on that order.
Let us explore the filters:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* | This view of the report can be grouped by the Treatment Provider and/or Location. *By default, the Location will be selected. |
| 2 | Sort By | Choose the sort criteria for the report. This report can be sorted based on provider/location Name, Gross Production, or Applied Payments. |
| 3 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 4 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 5 | Provider Type* | Choose to focus your report on selected treatment provider types. |
| 6 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected providers. |
| 7 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 8 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
| 9 | Exclude Special Credits from Applied Payments | Select this option if you would like to exclude special credits from applied payments from the report. *By default, it is unchecked. |
| 10 | Exclude Special Credits from Advance Payments and Allocated Advance Payments | Select this option to exclude special credits from advance payments and allocated advance payments. *By default, it is selected. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Results
Now, let us take a look at the result of the Income Allocation View.
- Location: The short name of the treatment location associated with the transaction.
- Opening Bal.: The outstanding balance is to be collected at the start of the selected time period.
- Gross Prod. (Trans. Date): The total amount of production generated from procedures completed by the provider at the specified location.
- Prod Adj.: The amount of adjustments made to the production generated by this provider at the location.
- Net Prod. (Trans. Date): The total production generated by the provider at the location, adjusted for any production changes.
- Migrated Prod.: The total production brought in by migrated codes (MSB codes).
- Applied Payment (Trans. Date): The amount of payments applied towards outstanding balances during this time period.
- Coll Adj.: The total amount of collection adjustments made against patient receivables during the selected time period.
- Net Applied Payment (Trans. Date): The total payments applied during the time period.
- Closing Bal.: The remaining outstanding balance to be collected after accounting for production and receivables collected during the time period.
- Advance Payment: The total amount of advance payments collected during the selected time period.
- Allocated Advance Payments: The total amount allocated from advance payments within the selected date range.
- Payments: The total amount of payments tagged to providers that are collected during the selected time period, including advance payments.
- Allocated Payments: The total amount allocated from payments tagged to providers within the selected date range.
- Provider Adj. (Adjustment): The total amount of production adjustments applied to the provider during the selected time period.
- Income Reduction: The total amount of income reduction applied to the provider.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Gross Production Summary View, the filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* | This view can be grouped by the Treatment Provider and/or Location. *By default, the Location will be selected. |
| 2 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 3 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 4 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected providers. |
| 5 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 6 | Code | This helps to filter out production created from the selected code in the chosen date range. |
| 7 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Gross Production Summary View
Now, let us take a look at the results of the Income Allocation Report (Gross Production Summary View).
- Location: The location associated with the transaction.
- Trans. Date: The date when the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Code: The treatment procedure against which an action was performed.
- Code Desc.: The description of the procedure code.
- Date Of Service: The date of service of the code against which the transaction is performed.
- Action: The action taken during the transaction, such as 'code completion', 'fee update', or 'code deletion'.
- Pat. Amt: The patient payable amount at the time of code completion.
- Gross Prod. (Trans. Date): The production amount generated from the procedure (sum of insurance and patient payable) completed on the transaction date.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Gross Production Detail View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be for Today. |
| 2 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 3 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected providers. |
| 4 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 5 | Code | This helps to filter out production created from selected code in the chosen date range. |
| 6 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Gross Production Detail View
Now, let's take a look at the results of the Income Allocation Report (Gross Production Summary View).
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Location: The location associated with the transaction.
- Provider: The provider associated with the procedure.
- Provider Short Name: The short name of the provider associated with the procedure.
- Code: The treatment procedure against which an action was performed.
- Code Desc.: The description of the procedure code.
- Date Of Service: The date of service of the code against which the transaction is performed.
- Action: The action taken during the transaction, such as 'code completion', 'fee update', or 'code deletion'.
- Pat. Amt: The patient payable amount at the time of code completion.
- Gross Prod. (Trans. Date): The production amount generated from the procedure (sum of insurance and patient payable) completed on the transaction date.
- Membership Discount Credits: Any applicable membership discount credits applied to the procedure code.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Applied Payments Summary View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* | This view of the report can be grouped by Location, Provider, Paying Entity, Payment Category and Payment Type. By default, Location will be selected. |
| 2 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be for Today. |
| 3 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 4 | Patient | Choose to focus the report on selected patients. This will focus the report on applied payments against selected patients. |
| 5 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts and income reduction receipts added against the selected providers. |
| 6 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 7 | Code | This helps to filter out production created from selected code in the chosen date range. |
| 8 | Payment Category | Choose to focus the report on selected payment categories. |
| 9 | Payment Type | Choose to focus the report on selected payment types. |
| 10 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Applied Payments Summary View
Now, let's take a look at the results of the Income Allocation Report (Applied Payments Summary View).
- Location: The location associated with the transaction.
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Applied Payment (Trans. Date): The amount of payments applied towards outstanding balances during this time period.
- Payment Date: The payment date of the receipt. This is the actual date the patient paid the practice.
- Paying Patient: The name of the patient whose receipt the payment is applied to.
- Code: The treatment procedure against which an action was performed.
- Code Desc.: The description of the procedure code.
- Date Of Service: The date of service of the code against which the transaction is performed.
- Pat. Bal: The patient payable amount at the time of code completion.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system.
- Receipt User: The user who added the receipt on which the transaction was done.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Applied Payments Detail View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 2 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 3 | Patient | Choose to focus the report on selected patients. This will focus the report on applied payments against selected patients. |
| 4 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected providers. |
| 5 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 6 | Code | This helps to filter out production created from selected code in the chosen date range. |
| 7 | Payment Category | Choose to focus the report on selected payment categories. |
| 8 | Payment Type | Choose to focus the report on selected payment types. |
| 9 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Applied Payments Detail View
Now, let's take a look at the results of the Income Allocation Report (Applied Payments Detail View).
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Location: The location associated with the transaction.
- Provider: The provider associated with the procedure.
- Provider Short Name: The short name of the provider associated with the procedure.
- Payment Date: The payment date of the receipt. This is the actual date the patient paid the practice.
- Payment Category: The category of payment, whether it was made by cash, cheque, credit card, and so on.
- Payment Type: The type of payment accepted, whether it was made via Visa, MasterCard, Cash, Check, and so on.
- Applied Payment (Trans. Date): The amount of payments applied towards outstanding balances during this time period.
- Paying Entity: The entity against whom the receipt is addressed (Patient, Collection Agency).
- Paying Patient: The name of the patient whose receipt the payment is applied to.
- Code: The treatment procedure against which an action was performed.
- Code Desc.: The description of the procedure code.
- Date Of Service: The date of service of the code against which the transaction is performed.
- Pat. Bal: The patient payable amount at the time of code completion.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system.
- Receipt User: The user who added the receipt on which the transaction was done.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Adjustments Summary View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* | This view of the report can be grouped by Location, Provider, and Adjustment Type. By default, the Location will be selected. |
| 2 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 3 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 4 | Provider* | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected providers. |
| 5 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 6 | Adjustment Type* | Choose to focus the report on selected adjustment types. |
| 7 | Adjustment Code | Choose to focus the report based on selected adjustment codes. |
| 8 | Code | This helps to filter out adjustments related to the selected code in the chosen date range. |
| 9 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Adjustments Summary View
Now, let's take a look at the results of the Income Allocation Report (Adjustments Summary View).
- Location: The location against which the adjustment was made.
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Adj. Code (Adjustment Code): The adjustment code that was made.
- Adj. Code Desc (Adjustment Code Description): The description of the adjustment code used to adjust the balance.
- Amount: The amount that was adjusted in this transaction.
- Code: The procedure code against which the adjustment was made.
- Desc. (Description): The description of the code.
- D.O.S (Date of Service): The date of service of the code against which the adjustment was made.
- User Name: The user that created/modified the adjustment.
- Remarks: Any remarks added by the user regarding the transaction.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Adjustments Detail View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 2 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 3 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected providers. |
| 4 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 5 | Adjustment Type* | Choose to focus the report on selected adjustment types |
| 6 | Adjustment Code | Choose to focus the report based on selected adjustment codes. |
| 7 | Code | This helps to filter out production created from selected code in the chosen date range. |
| 8 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Adjustments Detail View
Now, let's take a look at the result of the Income Allocation Report (Adjustments Detail View).
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Adj. Code: The adjustment code that was made.
- Adj. Code Desc.: The description of the adjustment code used to adjust the balance.
- Adjustment Type: The type of adjustment, either a collection adjustment or a production adjustment.
- Amount: The amount that was adjusted in this transaction.
- Location: The location against which the adjustment was made.
- Provider: The treatment provider associated with the procedure code.
- Provider Short Name: The short name of the treatment provider..
- Code: The procedure code against which the adjustment was made.
- Desc.: The description of the code.
- D.O.S: The date of service of the code against which the adjustment was made.
- User Name: The user that created/modified the adjustment.
- Remarks: Any remarks added by the user regarding the transaction.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Payments Summary View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* | This view of the report can be grouped by Receipt Location and Receipt Provider. By default, the Receipt Location will be selected. |
| 2 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 3 | Receipt Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 4 | Receipt Provider | Choose to focus your report on the selected receipt provider(s). This helps to filter out transactions like advance receipts added against the selected providers. |
| 5 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 6 | Payment Category | Choose to focus the report on selected payment categories. |
| 7 | Payment Type | Choose to focus the report on selected payment types. |
| 8 | Payment Method | Choose to focus the report on selected payment methods. |
| 9 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Payments Summary View
Now, let's take a look at the results of the Income Allocation Report (Payments Summary View).
- Receipt Location: The location against which the advance receipt has been created.
- Transaction Date: The date the transaction was completed in the system.
- Payment Date: The date when the payment was done.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Deposit Amount: The total amount deposited.
- Payment Category: The category of payment, whether it was made by cash, cheque, credit card, and so on.
- Payment Type: The type of payment accepted, whether it was made via Visa, MasterCard, Cash, Check, and so on.
- Payment Source: The source of the payment, whether it was Stripe or None.
- Ref No.: The reference number entered by your office staff when creating a receipt.
- Receipt #: The system-assigned number used to identify the payment entered into the system.
- Receipt User: The user who added the receipt on which the transaction was done.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Payments Detail View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 2 | Receipt Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 3 | Receipt Provider | Choose to focus your report on the selected receipt provider(s). This helps to filter out transactions like advance receipts added against the selected providers. |
| 4 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 5 | Payment Category | Choose to focus the report on selected payment categories. |
| 6 | Payment Type | Choose to focus the report on selected payment types. |
| 7 | Payment Method | Choose to focus the report on selected payment methods. |
| 8 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Payments Detail View
Now, let's take a look at the results of the Income Allocation Report (Payments Detail View).
- Receipt Location: The location against which the advance receipt has been created.
- Receipt Provider: The provider against which the advance receipt has been created.
- Provider Short Name: The short name of the provider against which the advance receipt has been created.
- Transaction Date: The date on which the transaction was completed on the system.
- Payment Date: The date when the payment was done.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Deposit Amount: The total amount deposited.
- Payment Category: The category of payment, whether it was made by cash, cheque, credit card, and so on.
- Payment Source: The source of the payment, whether it was Stripe or None.
- Ref No.: The Reference number entered by your office staff when creating a receipt.
- Receipt #: The system-assigned number used to identify the payment entered into the system.
- Receipt User: The user who added the receipt on which the transaction was done.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Allocated Payments Summary View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* | This view of the report can be grouped by Receipt Location and Receipt Provider. By default, the Receipt Location will be selected. |
| 2 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 3 | Receipt Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 4 | Receipt Provider | Choose to focus your report on the selected receipt provider(s). This helps to filter out transactions like advance receipts added against the selected providers. |
| 5 | Treatment Location | Select the location(s) to focus the report on the treatment location(s). |
| 6 | Treatment Provider | Choose to focus your report on the selected treatment provider(s). |
| 7 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 8 | Code | This helps to filter out production created from selected code in the chosen date range. |
| 9 | Payment Category | Choose to focus the report on selected payment categories. |
| 10 | Payment Type | Choose to focus the report on selected payment types. |
| 11 | Payment Method | Choose to focus the report on selected payment methods. |
| 12 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Allocated Payments Summary View
Now, let's take a look at the results of the Income Allocation Report (Allocated Payments Summary View).
- Receipt Location: The location against which the advance receipt has been created.
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Applied Payment (Trans. Date): The amount of payments applied towards outstanding balances during this time period.
- Treatment Location: The location associated with the procedure code.
- Treatment Provider: The provider associated with the treatment provider.
- Treatment Provider Short Name: The short name of the treatment provider.
- Paying Patient: The name of the patient whose receipt the payment is applied to.
- Code: The treatment procedure against which an action was performed.
- Code Desc.: The description of the procedure code.
- Date Of Service: The date of service of the code against which the transaction is performed.
- Pat. Bal: The patient payable amount at the time of code completion.
- Receipt #: The system-assigned number used to identify the payment entered into the system.
- Receipt User: The user who added the receipt on which the transaction was done.
- Payment Category: The category of payment, whether it was made by cash, cheque, credit card, or so on.
- Payment Type: The type of payment accepted, whether it was made via Visa, MasterCard, Cash, Check, and so on.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Allocated Payments Detail View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 2 | Receipt Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 3 | Receipt Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected providers. |
| 4 | Treatment Location | Select the location(s) to focus the report on the treatment location(s). |
| 5 | Treatment Provider | Choose to focus your report on the selected treatment provider(s). |
| 6 | Patient Flag | Choose to focus the report based on the patients with the selected patient flags. |
| 7 | Code | This helps to filter out production created from selected code in the chosen date range. |
| 8 | Payment Category | Choose to focus the report on selected payment categories. |
| 9 | Payment Type | Choose to focus the report on selected payment types. |
| 10 | Payment Method | Choose to focus the report on selected payment methods. |
| 11 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Allocated Payments Detail View
Now, let's take a look at the results of the Income Allocation Report (Allocated Payments Detail View).
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Applied Payment (Trans. Date): The amount of payments applied towards outstanding balances during this time period.
- Treatment Location: The location associated with the procedure code.
- Treatment Provider: The provider associated with the treatment provider.
- Treatment Provider Short Name: The short name of the treatment provider.
- Paying Patient: The name of the patient whose receipt the payment is applied to.
- Code: The treatment procedure against which an action was performed.
- Code Desc.: The description of the procedure code.
- Date Of Service: The date of service of the code against which the transaction is performed.
- Pat. Bal: The patient payable amount at the time of code completion.
- Receipt #: The system-assigned number used to identify the payment entered into the system.
- Receipt Location: The location against which the advance receipt has been created.
- Receipt Provider: The provider against which the advance receipt has been created.
- Receipt Provider Short Name: The short-name of the provider associated with the receipt.
- Receipt User: The user who added the receipt on which the transaction was done.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Income Reduction Summary View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Group By* | This view of the report can be grouped by Location and Provider. *By default, the Location will be selected. |
| 2 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 3 | Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 4 | Patient | Choose to focus the report based on selected patients. |
| 5 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like income reduction receipts added against the selected providers. |
| 6 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Income Reduction Summary View
Now, let's take a look at the results of the Income Allocation Report (Income Reduction Summary View).
- Location: The location associated with the transaction.
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Payment Type: The type of payment accepted, whether it was made via Visa, MasterCard, Cash, Check, and so on.
- Payment Date: The payment date of the receipt. This is the actual date the patient paid the practice.
- Amount: The receipt amount added as an income reduction.
- Refunded: The amount refunded from the receipt as per the current day.
- Applied: The amount applied from the receipt as of the current day.
- Unapplied: The amount remaining as credits in the receipt as of the current day.
- Receipt #: The system-assigned number used to identify the payment entered into the system.
- Receipt User: The user who added the receipt on which the transaction was done.
Click on the teal-coloured entries to view more information on the corresponding entries.
For the Income Reduction Detail View, your filter options include:
| No | Filters | Description |
|---|---|---|
| 1 | Date Range (Max 1 year)* | The date range can be selected for a maximum of 1 year. This works based on the transaction date. *By default, the date range will be Today. |
| 2 | Treatment Location* | Select the location(s) to focus the report on the treatment location(s). *By default, the location will be the user’s default location. |
| 3 | Patient | Choose to focus the report based on selected patients. |
| 4 | Provider | Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like income reduction receipts added against the selected providers. |
| 5 | Exclude Inactive Providers | Select this option if you would like to exclude Inactive Providers from the report. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Generation/Download Criteria
- Due to data volume, reports with more than 20 Treatment Locations or a date range exceeding 1 Year will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result - Income Allocation Detail View
Now, let us take a look at the result of the Income Allocation Report (Income Reduction Detail View,).
- Trans. Date: The date the transaction was completed in the system.
- Patient ID: The system-assigned number used to identify this patient and their records. On clicking on the Patient ID, the user is taken to the patient's ledger.
- Patient Name: The name of the patient.
- Location: The location associated with the transaction.
- Provider: The provider associated with the procedure.
- Provider Short Name: The short name of the treatment provider.
- Payment Type: The type of payment accepted whether it was made via Visa, Master Card, Cash, Check, and so on.
- Payment Date: The payment date of the receipt. This is the actual date the patient paid the practice.
- Amount: The receipt amount added as income reduction.
- Refunded: The amount refunded from the receipt as per the current day.
- Applied: The amount applied from the receipt as of the current day.
- Unapplied: The amount remaining as credits in the receipt as of the current day.
- Receipt #: The system-assigned number used to identify the payment that has been entered into the system.
- Receipt User: The user who added the receipt on which the transaction was done.
Click on the teal-colored entries to view more information on the corresponding entries.
To enable Permissions for the Income Allocation Report:
- Navigate to the System Menu > select Practice Settings > Administration > Profiles.
- Click Manage Permissions for the intended profile.
- Select Insights.
- Select the Generate Income Allocation Report option under Operational Reports to enable the permission.
- Click Save.
On the Confirm Action modal that appears, click Yes to proceed.
A toast notification appears on the top right stating, 'Profile updated successfully'.
Practices can use this elaborate guide to generate filters for the income allocation report.