Income Allocation Report

The Income Allocation Extended report provides data points for measuring clinician performance in terms of Opening and Closing Balances, Production and Collection 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.

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 clinician and/or location.
• Establish Clinician Payroll and use transactional data to rectify any underpayment or overpayment situations, regardless of whether clinicians are compensated based on production or applied payments.
• Generate a report based on the Transaction Date to track clinician performance.
• Employ filters such as Location, Clinician Type, Clinician, and Patient Flag for a detailed analysis of completed treatments, Production and Collection Adjustments, and Net Applied Payments, among other aspects.

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.

Click here to learn how to save and manage your saved filter criteria in operational reports.

Explore below to learn more about the desired views, filter criteria, and results.

Income Allocation View ⌵

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 Clinician 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 clinician/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	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	Clinician Type*	Choose to focus your report on selected treatment clinician types.
6	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected clinicians.
7	Patient Flag	Choose to focus the report based on the patients with the selected patient flags.
8	Payor	Choose to focus the report based on the payor you want to view in the report.
9	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians from the report. *By default, it is unchecked.
10	Exclude Membership Discount Credits	Select this option to exclude membership discount credits.
11	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.
12	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 full name of the treatment location associated with the transaction.
• Opening Bal.: The outstanding balance to be collected at the start of the selected time period.
• Fee: The office's standard fee for the procedure code, based on your practice settings.
• Gross Prod. (Trans. Date): The total amount of production generated from procedures completed by the clinician at the specified location.
• Prod Adj.: The amount of adjustments made to the production generated by this clinician at the location.
• Net Prod. (Trans. Date): The total production generated by the clinician at the location, adjusted for any production changes.
• Migrated Prod.: The total production brought in by migrated codes (MSB codes).
• Membership Discount Credits: Any applicable membership discount credits applied to the procedure 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, after factoring in collection adjustments.
• 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. This metric does not include Income Reduction payment category.
• Allocated Advance Payments: The total amount allocated from advance payments within the selected date range. This metric does not include Income Reduction payment category.
• Clinician Adj. (Adjustment): The total amount of production adjustments applied to the clinician during the selected time period.
• Income Reduction: The total amount of income reduction applied to the clinician.

Click on the teal-coloured entries to view more information on the corresponding entries.

Gross Production Summary View ⌵

For the Gross Production Summary View, the filter options include:

No	Filters	Description
1	Group By*	This view can be grouped by the Treatment Clinician 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	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	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected clinicians.
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	Payor	Choose to focus the report based on the payor you want to view in the report.
8	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• 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'.
• Fee: The fee associated with the code.
• Contr. Adj: The difference between the office's standard fee and the amount payable.
• Gross Prod. (Trans. Date): The production amount generated from the procedure completed on the transaction date.
• Membership Discount Credits: Any applicable membership discount credits applied to the procedure codes.

Click on the teal-coloured entries to view more information on the corresponding entries.

Gross Production Detail View ⌵

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	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	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected clinicians.
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	Payor	Choose to focus the report based on the payor you want to view in the report.
7	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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).

• Membership Discount Credits: Any applicable membership discount credits applied to the procedure code.
• 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.
• Clinician: The clinician associated with the procedure.
• Payor: The payor linked to the treatment, indicating whether the procedure was completed under NHS, Private or any other Payor.
• Clinician Short Name: The short-name of the clinician 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'.
• Fee: The fee associated with the code.
• Contr. Adj: The difference between the office's standard fee and the amount payable.
• Gross Prod. (Trans. Date): The production amount generated from the procedure completed on the transaction date.

Click on the teal-coloured entries to view more information on the corresponding entries.

Applied Payments Summary View ⌵

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, Clinician, 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 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 on selected patients. This will focus the report on applied payments against selected patients.
5	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts and income reduction receipts added against the selected clinicians.
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	Payor	Choose to focus the report based on the payor you want to view in the report.
11	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• 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.

Applied Payments Detail View ⌵

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	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	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected clinicians.
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	Payor	Choose to focus the report based on the payor you want to view in the report.
10	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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 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.
• Location: The location associated with the transaction.
• Clinician: The clinician associated with the procedure.
• Payor: The payor linked to the treatment, indicating whether the procedure was completed under NHS, Private or any other payor.
• Clinician Short Name: The short name of the clinician 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 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.

Adjustments Summary View ⌵

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, Clinician, 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	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	Clinician*	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected clinicians.
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 Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• 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.

Adjustments Detail View ⌵

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	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	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected clinicians.
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 Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• Clinician: The treatment clinician associated with the procedure code.
• Clinician Short Name: The short name of the treatment clinician.
• 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.

Payments Summary View ⌵

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 Clinician. 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 Clinician	Choose to focus your report on the selected receipt clinician(s). This helps to filter out transactions like advance receipts added against the selected clinicians.
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 Method	Choose to focus the report on selected payment methods.
8	Payment Type	Choose to focus the report on selected payment types.
9	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• 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.

Payments Detail View ⌵

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 Clinician	Choose to focus your report on the selected receipt clinician(s). This helps to filter out transactions like advance receipts added against the selected clinicians.
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 Method	Choose to focus the report on selected payment methods.
7	Payment Type	Choose to focus the report on selected payment types.
8	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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 Clinician: The clinician against which the advance receipt has been created.
• Clinician Short Name: The short name of the clinician 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.

Allocated Payments Summary View ⌵

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 Clinician. 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 Clinician	Choose to focus your report on the selected receipt clinician(s). This helps to filter out transactions like advance receipts added against the selected clinicians.
5	Treatment Location	Select the location(s) to focus the report on the treatment location(s).
6	Treatment Clinician	Choose to focus your report on the selected treatment clinician(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 Method	Choose to focus the report on selected payment methods.
11	Payment Type	Choose to focus the report on selected payment types.
12	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• 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 Clinician: The clinician associated with the treatment clinician.
• Treatment Clinician Short Name: The short name of the treatment clinician.
• 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.

Allocated Payments Detail View ⌵

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 Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like production, applied payments, adjustments, advance receipts, and income reduction receipts added against the selected clinicians.
4	Treatment Location	Select the location(s) to focus the report on the treatment location(s).
5	Treatment Clinician	Choose to focus your report on the selected treatment clinician(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 Clinicians	Select this option if you would like to exclude Inactive Clinicians 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 Clinician: The clinician associated with the treatment clinician.
• Treatment Clinician Short Name: The short name of the treatment clinician.
• 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 Clinician: The clinician against which the advance receipt has been created.
• Receipt Clinician Short Name: The short-name of the clinician 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.

Income Reduction Summary View ⌵

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 Clinician. *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	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like income reduction receipts added against the selected clinicians.
6	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• 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.

Income Reduction Detail View ⌵

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	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	Clinician	Choose to focus your report on the selected treatment clinician(s). This helps to filter out transactions like income reduction receipts added against the selected clinicians.
5	Exclude Inactive Clinicians	Select this option if you would like to exclude Inactive Clinicians 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.
• Clinician: The clinician associated with the procedure.
• Clinician Short Name: The short name of the treatment clinician.
• 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.

Permissions ⌵

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.