Generate Income Allocation Extended Report

The Income Allocation Extended report provides data points for measuring provider 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.

Competitor Reports

• Analysis Summary (Dentrix)
• Collection by Provider/Credit Distribution (Eaglesoft),
• Practice Analysis (Dolphin).

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.

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 display 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*	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	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 Payments from Migrated Receipts	Select this option to exclude payments from migrated receipts.
10	Exclude Membership Discount Credits	Select this option to exclude membership discount credits.
11	Exclude Special Credits from Applied Payments	Select this option to exclude special credits from applied payments.
12	Exclude Special Credits from Payments and Allocated Payments (Including Advance and Allocated Advance)	Select this option to exclude special credits from payments and allocated payments, including advance and allocated advance payments.

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 

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 to be collected at the start of the selected time period.
• UCR. (Trans. Date): 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 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).
• 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 and insurance 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.
• 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.: 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-colored 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 Provider and/or Location. *By default, the Location will be selected.
2	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.
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	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	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.'
• UCR: The UCR fee of the procedure code(s) is based on your office's standard fees, as configured in your practice settings.
• Contr. Adj: The difference between the office's standard fee and the amount payable according to the insurance carrier's agreement.
• Pat. Amt: The patient payable amount at the time of code completion.
• Ins. Amt: The insurance 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-colored 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*	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	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.'
• UCR: The UCR fee of the procedure code(s) based on your office's standard fees, as configured in your practice settings.
• Contr. Adj: The difference between the office's standard fee and the amount payable according to the insurance carrier's agreement.
• Pat. Amt: The patient payable amount at the time of code completion.
• Ins. Amt: The insurance 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-colored 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, Provider, Paying Entity, Payment Category and Payment Type. By default, the Location will be selected.
2	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.
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	Paying Entity	Choose to focus the report on selected paying entities (Patient, Insurance, Collection Agency or all).
5	Patient	Choose to focus the report on selected patients. This will focus the report on applied payments against selected patients.
6	Carrier	Choose to focus the report on selected Carriers. This will focus the report on applied payments against selected carriers.
7	Collection Agency	Choose to focus the report on selected Collection Agencies. This will focus the report on applied payments against selected collection agencies.
8	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.
9	Patient Flag	Choose to focus the report based on the patients with the selected patient flags.
10	Code	This helps to filter out production created from selected code in the chosen date range.
11	Payment Category	Choose to focus the report on selected payment categories.
12	Payment Type	Choose to focus the report on selected payment types.
13	Exclude Inactive Providers	Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked.
14	Exclude Payments from Migrated Receipts	Select this option to exclude payments from migrated receipts.

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.
• Carrier: The name of the insurance carrier associated with the receipt.
• Collection Agency: The name of the collection agency associated with the receipt.
• 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.
• Ins. Bal: The insurance 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-colored 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*	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	Paying Entity	Choose to focus the report on selected paying entities (Patient, Insurance, Collection Agency, or all).
4	Patient	Choose to focus the report on selected patients. This will focus the report on applied payments against selected patients.
5	Carrier	Choose to focus the report on selected Carriers. This will focus the report on applied payments against selected carriers.
6	Collection Agency	Choose to focus the report on selected Collection Agencies. This will focus the report on applied payments against selected collection agencies.
7	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.
8	Patient Flag	Choose to focus the report based on the patients with the selected patient flags.
9	Code	This helps to filter out production created from selected code in the chosen date range.
10	Payment Category	Choose to focus the report on selected payment categories.
11	Payment Type	Choose to focus the report on selected payment types.
12	Exclude Inactive Providers	Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked.
13	Exclude Payments from Migrated Receipts	Select this option to exclude payments from migrated receipts.

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, check, credit card, or 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, Insurance, Collection Agency).
• Paying Patient: The name of the patient whose receipt the payment is applied to.
• Carrier: The name of the insurance carrier associated with the receipt.
• Collection Agency: The name of the collection agency associated with the receipt.
• 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.
• Ins. Bal: The insurance 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-colored 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, Provider, and Adjustment Type. *By default, the Location will be selected.
2	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.
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	Provider	Choose to focus your report on the selected treatment provider(s). This helps to filter out transactions like adjustments 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 Against*	Choose to focus the report based on the entity against which the adjustment is posted.
8	Adjustment Code	Choose to focus the report based on selected adjustment codes.
9	Code	This helps to filter out production created from selected code in the chosen date range.
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 - 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: The adjustment code that was made.
• Adj. Code Desc: The description of the adjustment code used to adjust the balance.
• Adj. Against: Indicates whether the adjustment was made against a patient balance or an insurance balance.
• Amount: The amount that was adjusted in this transaction.
• 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-colored 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*	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	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 Against*	Choose to focus the report based on the entity against which the adjustment is posted.
7	Adjustment Code	Choose to focus the report based on selected adjustment codes.
8	Code	This helps to filter out production created from 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 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.
• Adj. Against: Indicates whether the adjustment was made against a patient balance or an insurance balance.
• 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-colored 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 Provider. By default, the Receipt Location will be selected.
2	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.
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.
10	Exclude Payments from Migrated Receipts	Select this option to exclude payments from migrated receipts.

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, check, 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 Bluepay, CareStack Pay, Apex Payments, None, or Not Applicable.
• 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-colored 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 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 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 Providers	Select this option if you would like to exclude Inactive Providers from the report.
9	Exclude Payments from Migrated Receipts	Select this option to exclude payments from migrated receipts.

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, check, credit card, or so on.
• Payment Source: The source of the payment, whether it was Bluepay, CareStack Pay, Apex Payments, None, or Not Applicable.
• 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-colored 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 Provider. By default, the Receipt Location will be selected.
2	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.
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 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 Providers	Select this option if you would like to exclude Inactive Providers from the report. *By default, it is unchecked.
13	Exclude Payments from Migrated Receipts	Select this option to exclude payments from migrated receipts.

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 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.
• Ins. Bal: The insurance 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, check, credit card, and 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-colored 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*	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 Method	Choose to focus the report on selected payment methods.
10	Payment Type	Choose to focus the report on selected payment types.
11	Exclude Inactive Providers	Select this option if you would like to exclude Inactive Providers from the report.  *By default, it is unchecked.
12	Exclude Payments from Migrated Receipts	Select this option to exclude payments from migrated receipts.

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 Advance Payments Detail View

Now, let's take a look at the results of the Income Allocation Report (Allocated Advance 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.
• Ins. Bal: The insurance 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-colored 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 Provider. *By default, the Location will be selected.
2	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 for 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 will be checked.

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.

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

Income Reduction Detail View

For the Income Reduction 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 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	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 Reduction 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, 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 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.

Permissions

If users in your practice cannot use this report, please ensure that the relevant permissions are enabled.

To enable Permissions for the Income Allocation Report:

• Navigate to the System Menu > 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 comprehensive guide to efficiently generate reports, explore various use cases, and apply the necessary filter criteria to generate the desired report. Following this guide will help you create reports quickly, understand the different views available, and customize reports to meet specific needs.

Click here to explore the complete list of permissions and their descriptions.