Dentrix Enterprise
Help

Provider A/R Totals Report

The Provider A/R Totals Report production totals for a date range or lists a daily total for each day in the range. This report is more accurate than other production reports because it takes into account production and collection adjustments. For example, if a procedure was posted for $1000, but a $900 Charity Care credit was given to the patient, the Production A/R Totals Report will show the procedure produced $100 in revenue, rather than $1000.

Note: For accurate reporting, follow these recommendations:

·        Post charge (production) and credit (collections) adjustments properly.

·        Close your books nightly.

·        Look at the net production figures within the date range of the report.

·        To see where allocations occur, you can run the Provider Revenue Report.

To generate the report

1.   In DXOne Reporting, select Management, and then double-click Provider A/R Totals.

The Provider A/R Totals dialog box appears.

2.   Set up the following options:

·        Date Range - Do one of the following:

·        Select Specific Range, and then enter the date range in the From and To boxes.

·        Select Relative Date Range, and then select the range:

Current Day

Previous Day

Previous 6 Months

Next Week

Next Fiscal Year

Current MTD

Previous Week

Previous Fiscal Year

Next Month

Next Calendar Year

Current Fiscal YTD

Previous Month

Previous Calendar Year

Next 3 Months

 

Current Calendar YTD

Previous 3 Months

Next Day

Next 6 Months

 

Note: For a credit or charge to be included on the report, it must have a date within the specific date range or relative date range, based on the Date Type.

·        Date Type - Select whether to run the report by Entry Date or Procedure Date. Entry date indicates the date of a transaction that was entered into the database. Procedure date indicates the date of a transaction that was manually changed. Most of the time, procedures will have the same entry and procedure date. They will only differ when you backdate a procedure. Applied credits use the allocate date instead of the entry or procedure date.

·        Base Collections On - Select whether collections on the report are based on each credit's Allocation Date or each Credit's Procedure/Entry Date.

·        Clinic - Click the search button to select the clinics you want to include on the report, or select the All check box to include all clinics. Select whether to run the report by Collecting Clinic or Rendering Clinic.

Notes:

·        When grouping the report by Initial Provider:

·        The Collecting Clinic and Rendering Clinic options are not available.

·        The report uses the Collecting Clinic for credits and the Rendering Clinic for charges.

·        When using No Group By for the report (or grouping the report by something other than the initial provider):

·        Regardless of whether Collecting Clinic or Rendering Clinic is selected, the report always uses the Rendering Clinic for charges.

·        With Collecting Clinic selected, the report uses the Collecting Clinic for credits.

·        With Rendering Clinic selected, the report uses the Rendering Clinic for credits.

·        Provider - Click the search button to select the providers you want to include on the report, or leave All selected to include all providers.

Notes:

·        When grouping the report by Initial Provider, the report includes a transaction if the corresponding patient has an initial provider (in the Family File).

·        When using No Group By for the report (or grouping the report by something other than the initial provider), the report includes a transaction associated with one of the specified providers.

·        Exclude ADA Codes - Click the search button to select the procedure codes you want to exclude from the report, or select the None check box to not exclude any procedure codes. If any procedures codes are being excluded, to include a list of those procedure codes on the report, select the List Descriptions check box.

·        Billing Type - Click the search button to select the billing types for the patients you want to include on the report, or select the All check box to include all billing types.

·        Patient Tag - To have the report include patients with certain tags assigned to them, select the Run By Patient Tag check box; and then, click the search button  to select the desired patient tags, or select the All check box to include patients with any patient tag. To not filter the report by a patient tag, clear the Run By Patient Tag check box.

·        Report Type - Select the type of report you want to generate:

·        Standard Summary - To include totals for the selected date range. This option defers to the Group By selection to group the report.

·        Daily Summary - To include totals for each day in the date range. The totals are broken down by the Group By option selected and then by day.

Notes:

·        With Collecting Clinic under Select Clinic selected, the grouping of credits is based on the Date Type.

·        With Rendering Clinic under Select Clinic selected, the grouping of credits is based on the allocation date.

·        Group By - Select one of the following options:

·        No Group By - For no grouping. Only the grand totals will be displayed. The totals are not broken down by provider or clinic.

·        Initial Provider - To group the report by each patient's initial provider. Totals are broken down by the initial provider (entered in the Family File) and show grand totals. The provider grouping is based on the initial provider rather than the rendering provider.

·        Rendering Provider - To group the report by the provider assigned to each procedure. Totals are broken down by the rendering provider, and grand totals are shown.

·        Clinic - To group the report by clinic and provider. Then, select either Provider then Clinic or Clinic then Provider.

Notes:

·        When grouping the report by Initial Provider, The report includes suspended credits and uses the full amount of each credit.

·        When using No Group By for the report (or grouping the report by something other than the initial provider), the report does not include suspended credits.

·        Adjustment Types - Do any of the following as needed:

·        Click Debits vs Credits to assign the adjustment types as either Production Adjustments or Collection Adjustments. By default, all debit adjustments are in the Production Adjustments list and all credit adjustments are in the Collection Adjustments list. To close the Assign Adjustment Types dialog box, saving any changes, click OK.

Important: Make sure the adjustment types for the report are set up correctly:

·        The adjustment types that affect production are assigned to Production Adjustments.

·        The adjustment types that affect collections are assigned to Collection Adjustments.

·        To include a list of all credit and debit adjustments and to which category (production or collection) each are assigned on the report, select the Include Adjustment Type List check box.

3.   Click Save as Default to save the current settings for the next time you run the report.

4.   Click Clear Defaults to revert the dialog box options to the original defaults.

5.   Click Schedule to schedule a report job.

6.   Click OK to preview the report.