Report on Productivity in the Report Library

Practices can report on provider and practice productivity over time using the Total Charges and Payments by Provider and Month report. This report is helpful for practices using a revenue-based compensation model for clinicians. Practices looking to minimize unpaid charges can use this report to compare payments by procedure group as well.

To get an overview of productivity trends at your practice, visit the Practice Vitals Dashboard productivity page.

Contents

1 Run the Total Charges and Payments by Provider and Month Report
2 Select Criteria Options
3 Customize to Identify Additional Columns and Criteria
4 Interpret Report Results

Run the Total Charges and Payments by Provider and Month Report

To view provider or practice productivity, or to get an overview of charges and payments by month, you can run the Total Charges and Payments by Provider and Month Report in the Report Library.

Open the Report Library

Open the Report Library from the Reports menu in PCC EHR.

Select the Report

In the Financial Oversight category, select the Total Charges and Payments by Provider and Month report.

Limit Access to This Report: Users with permission to manage categories in the Report Library can edit the Financial Oversight category in the Manage Categories window and uncheck roles to remove access. See Restrict Access to Reports in the Report Library for more information.

Select Your Criteria

You can select criteria to control the results that display on your report output. For practices using this report to identify revenue generated, or for clinician compensation models, common procedure exclusions for this report are immunizations, injections, and miscellaneous office fees.

To explore your options for this report’s criteria, read the Select Criteria Options section below.

Generate the Report

Click “Generate” to run the report.

Adjust Output

You can sort, arrange, and filter your report output in a variety of ways.

The Group By drop-down will group entries by the criteria that you select. If you group by transaction month, for example, the report data will be organized by month. Numerical columns subtotal at the bottom of each group.

You can further organize each section by clicking the column headers to sort the information by the column of your choice.

To learn more about navigating and working with report output, read Run Reports in the PCC EHR Report Library.

Optionally Export or Print

You can choose your output format and print or export your report to PDF or CSV.

Select Criteria Options

Use the section below to understand your financial oversight criteria options.

Transaction Date

You can choose your date range using the drop-down list, the date fields, or the calendar icon.

This report uses the transaction date by default. For charges, the transaction date is based on dates of service. For payments, the transaction date is the date found on the check, EOB, or ERA.

You can compare the finalized report of payments within a specific transaction date range with payments deposited into your bank account during the same transaction date range.

Include by Procedure

The default for this report is to include all procedures. Click “Edit” and use the search filter to find and select procedures by name, group, or procedure code.

To run a report for a specific procedure or procedure group, select the procedures from the Include by Procedure list. Your report will only include the charges and payments attributed to the procedures you chose, so you do not need to exclude any procedures.

To run a report including charges and payments attributed to all procedures except a few, leave the Include by Procedure default of All Procedures. Then exclude the procedures you don’t want included by selecting them on the Exclude by Procedure list.

To learn more about including and excluding criteria in reports, visit Run Reports in the PCC EHR Report Library

Exclude by Procedure

The default for this report is to exclude no procedures. Click “Edit” and use the search filter to find and select procedures by name, group, or procedure code.

Location

The default setting for this report includes all locations in the report output. If you select a location to include before you generate the report, only that location’s data will be included in the report output.

Provider

The default setting for this report includes all providers of service in the report output. If you select a provider to include before you generate the report, only that provider’s data will be included in the report output.

Provider of service is set when charges are posted or entered manually during payment posting.

Customize to Identify Additional Columns and Criteria

The Total Charges and Payments by Provider and Month report uses aggregate data that can be organized by including columns during report customization and by sorting the report output.

When you customize this report to include additional criteria, such as location and procedure, you must select the criteria as well as the column in order for the criteria to display as a column in the report output. To learn more about customizing a report, read Create a Custom Report.

Optionally Add a Column to Subtotal by Location

To display location and other additional columns in your report output, customize your report and select the columns you wish to include.

You can group the report by location so that the total charges and total payments subtotal within each location.

For more information on how to work with your report output read Run Reports in the PCC EHR Report Library.

Optionally Include Service Charges and Non-Service Charges

To see your practice’s service and non-service charges totaled separately, select these columns during customization.

Whether a charge is considered service or non-service depends on the assigned accounting type for the charge’s procedure as set in the procedure table found in the table editor (ted).

Service charges are procedures that have an accounting type of “Revenue”. These are typically clinical procedures, such as office visits, immunizations, and screenings.
Non-service charges are procedures that do not have the accounting type of “Revenue”. Some examples are non-clinical service fees, capitation payment offsets, and insurance interest or incentive payment offsets.

To learn more about accounting types, read Edit Your Practice’s Procedures, Codes, Adjustments, and Prices.

Optionally Include Posting Date

PCC recommends running this report solely by transaction date when measuring provider charge and payment productivity. Running solely by transaction date, not posting date, will reflect charges and payments attributed to the specified transaction date range as opposed to when the charges and payments were posted.

To include the posting date range, customize your report, click “Select Criteria”, and then select “Posting Date”.

You can include the posting date in addition to, or instead of, the transaction date.

Interpret Report Results

This report displays a snapshot of all charges and payments within a given transaction date range.

Your report output is based on the criteria you selected. The default report criteria present a simple overview of your providers’ productivity by transaction month. Customized reports present a more detailed, and more complex, organization of the data.

Interpret the Default Report

The default report output is sorted by provider and then by transaction month. Total charges and total payments subtotal within each row.

The results display all locations by default. If you selected locations while setting criteria on the default report, your location selections will be the only locations included in the report output.

Interpret a Custom Report

Custom reports can provide a more detailed view of your data. If you selected location and procedure group during customization, for example, this additional information will display on your report. If you selected many criteria during report customization, the aggregate data will be broken down into even greater detail. Each unique combination of criteria displays on its own row.

For example, if you added location to the report, the data will automatically display by provider and month (the default), and then by location. If you also selected Procedure Group, the data will display by provider, then by month, then by location, and finally by procedure group.

You can group and sort this output to further organize your data.

Interpret the Refund Amount Column

Refunds and reversed insurance payments (also known as “takebacks”) display in the Refund Amount column.

The charges, payments, and refunds displayed on this report are not necessarily associated with each other, except that they share the transaction date range of the report. If a payment and a refund occur within the same selected transaction date range, they will both display on the same report.

The example below shows a charge, a payment, and a refund that were all made on the same day.

Insurance Reversals and Providers: If the insurance payment reversal is not associated with a provider, the Provider column will display “None”.

Differences Between Daysheet-Based Reports and Financial Reports in the Report Library

There are three main differences between PCC’s daysheet-based reports in Practice Management and the Total Charges and Payments by Provider and Month report in the Report Library.

The Total Charges and Payments by Provider and Month report is run by transaction date, rather than posting date, in the default report.
Relinked payments are always included in the Total Charges and Payments by Provider and Month report in the Report Library.
Insurance payments (including insurance check payments) are listed as separate from personal check payments in the Total Charges and Payments by Provider and Month report.

Differences Between Charge-Based Reports and Financial Reports in the Report Library

There are two main differences between PCC’s charge-based reports, such as the Insurance Reimbursement Analysis (ira) report, and the Total Charges and Payments by Provider and Month report in the Report Library.

The Total Charges and Payment by Provider and Month report displays refunds in their own column. Charge-based reports display refunds as charges.
The Total Charges and Payments by Provider and Month report displays payments that have a transaction date in the chosen transaction date range. In contrast, charge-based reports display payments that are linked to charges with a transaction date in the chosen transaction date range.

Example: A patient came in for a well visit on October 1st. This is the Date of Service (DOS) and the charge transaction date. The biller posted the encounter’s charges on the next business day, October 2nd. This is the charge posting date. The payor sent a check or ERA on October 8th. This is the default payment transaction date or Electronic Funds Transfer (EFT) date. The biller posted the payment on October 12th. This is the payment posting date.

The Total Charges and Payments by Provider and Month report displays payments by the October 8th payment transaction date in the example. Charge-based reports display payments linked to the October 1st charge transaction date in the example.

Here are some related articles in Billing and Practice Management > Review Billing and Practice Management Reports:

Pediatric Practice Oversight Reporting with PCC
You can use PCC reports to identify problem areas in your A/R, review collections, and evaluate your growth as a practice. The tables below show PCC’s recommended reporting tools for practice oversight on a daily, weekly, monthly, and annual basis.
Schedule Reports in PCC EHR
Contents1 Schedule a Report to Run Automatically2 Preview Results and Save Output Settings3 View Scheduled Report Results4 Edit Scheduled Reports5 Stop and Start Reports6 Delete Scheduled Reports You can schedule reports to run in the future in PCC EHR. Schedule a Report to Run Automatically Use scheduled reports to automate recall lists, billing oversight reporting, […]
Restrict Access to Reports in the Report Library
Contents0.1 Reports Without a Category1 Restrict Access to Customize Report and Manage Categories When you want to limit access to certain report categories to one or more user roles, click the “Manage Categories” button in the Report Library window. To manage access, select a category and click the “Edit” button, then select one or more […]
Run Reports in the PCC EHR Report Library
The Report Library in PCC EHR is an expanding suite of reports designed to give you useful and meaningful access to information in the EHR.
Follow Up on Unpaid Claims and Insurance A/R
You can use PCC's tools to work on claims with errors, rejections, and denials. But what if a problem is fixed, but the claim wasn't resubmitted? Or what if an insurance payor simply never responds? Are some insurance payers regularly failing to pay you in a timely fashion? You may need specialized tools to track and work down your practice’s insurance A/R.
Run Reports in the Practice Management Window (Partner)
PCC's Practice Management tool, Partner, includes a variety of specialized, customizable reports for billing and financial analysis. Partner's accurate and diverse reporting capabilities can help you with time management, inventory planning, insurance contract negotiations, and financial planning.
SRS: the Report Engine in Practice Management
The Smart Report Suite (srs) is a report library in PCC's previous Practice Management system.
Export SRS Results to a Spreadsheet
You or your practice's accountant may use financial data from reports to analyze profits and make policy decisions for the future of your practice. You may wish to export those reports to another program, such as a spreadsheet, in order to make graphs or combine the numbers with other information.
Financial Reports in Practice Management
The Practice Management (Partner) tool in PCC EHR includes a wide array of financial reports. While many of these functions have been replaced with PCC EHR tools with modern interfaces, there are still many powerful, customizable reports that can help you track charges and payments and report on your practice's overall financial health.
Create a Custom Report
You can generate and save custom reports and report categories in PCC EHR.
Create a Custom Report
How to use PCC EHR's Report Library to create custom reports.
Run Practice Management SRS Reports
Watch this video to learn about Partner's SRS report engine. You'll learn how to open SRS, find reports, adjust criteria, and export results for use in a spreadsheet.