We are currently updating the OP Help Center content for the release of OP 14.19 or "OP 19". OP 19 is a member of the certified OP 14 family of products (official version is 14.19.1), which you may see in your software (such as in Help > About) and in the Help Center tabs labeled 14.19. You may also notice that the version number in content and videos may not match the version of your software, and some procedural content may not match the workflow in your software. We appreciate your patience and understanding as we make these enhancements.

Accounting and Billing Reports

Version 14.19

The following reports are available and are included with a new install or update of Office Practicum. 

Please contact Office Practicum support if you require a report not on this list, or if you need a report on this list but don't have it on your computer.

  • A/R Aging Analysis
  • Historical A/R Analysis
  • Patient Proof Accounts
Reports are only visible if a user is given specific permission: OP_Rpts_AR . If user is logged in and does not see these available reports, please see your office administrator.

Standard Reports

Billing tab > Transactions button > Standard Billing Reports

Use of Standard reports will allow users to view, in 7 simple drop down reports, a quick summary of the office’s productivity. These reports will display information that has been processed on a daysheet.

  1. To utilize these reports, a user will choose their desired report:

  1. Enter a Reference Date range.
  2. Choose transactions based on:
  • Charge/Payment
  • Posting (entry)
  • Daysheet
  • Daysheet ID

Printing Grid

You can use the Print grid button if you would like to have a paper or PDF copy of the report. 

  • If you export to PDF, you will be given some options regarding how you would like to save the image. Remember, that when saving practice sensitive information or any kind of PHI outside of Office Practicum, you should consider who has access to the information you are saving. You can add a password to the PDF you are saving by going to the Security tab, checking the box that says Enabled and Adding a User Password. You can also choose to protect your data in some other way within your own network.
  • Once you click OK, a "Save As" dialog box appears. You can then save it in any location under any name you prefer. If you have added a password, you will be prompted to enter it when you attempt to open the report.

Export to Excel

You may also export to Excel if you would like to reorganize or further calculate the data from the A/R Report. 

  1. Click the Export button. You will be given a Save As dialog box where you can name and chose a file location.
  2. The exported information will appear in Excel exactly as you see it in Office Practicum.

Billing Transaction Analysis

Billing tab > Transactions button > Transaction Analysis

OP’s Billing Transaction Analysis shows users the flexibility of reporting options that are available for all users' needs. This report can be used to capture items such as provider productivity or CPT Utilization, to name a couple examples. This report can be filtered, sorted, and grouped using the column headers, and can also be printed or exported. 

There are several Reference Date options to choose from depending on the data that is needed:

  • Charge/payment date: This report accesses charges according to their charge date (usually date of service) and payments and adjustments according to their payment date (which can be backdated at the time of posting).
  • Posting (entry) date: This report accesses charges, payments, and transactions that have a posting date within the time frame selected. NOTE: This date is time stamped from the local computer where the user is posting payments and does not take into consideration the date of service for charges or any backdating done when posting payments.
  • Daysheet: This report accesses only daysheeted transactions between the two reference dates entered. 
  • Daysheet ID: This report accesses data based on the Daysheet ID range that is entered in the Choose Daysheet ID Range field once this radio button is selected.  

Reimbursement Analysis

Billing tab > Transactions button > Reimbursement Analysis

This report accesses reimbursement information as a summary instead of individual transactions. Therefore, any payments shown are associated with the date of the charge to which they are applied. This report can be used for addressing contractual payments from the insurance, but should not be used for accounting purposes.

  • Charge DOS: This report processes a reimbursement summary for charges according to their charge date (date of service).
  • Posting (entry) date: This report processes a reimbursement summary for charges that have a posting date within the time frame selected. This date is time stamped from the local computer where the user is posting payments and does not take into consideration the date of service for charges.
  • Daysheet date: This report processes a reimbursement summary for charges daysheeted during a specific date range. This selection excludes non-daysheeted transactions.

A/R Aging Analysis

Billing tab > A/R button > A/R Aging Analysis

The A/R Aging Analysis report displays a summary of the practice’s accounts receivable. It is intended to help practices identify areas of concern and manage the practice’s financial health. In order to access this report in OP, users will need the OP_Reports_AR permission.

As a reminder, clicking the Update button in the Patient Calculation window runs a function that adds new charges and payments to the A/R grid. It also recalculates the date range buckets (the time that has elapsed from the date of service to the current date). You should run the update prior to running your A/R Aging Analysis report if daysheets have been processed, or if days have passed since you last ran the update process.

Running the A/R Analysis Report

The A/R report type you select will determine what data is displayed. For each report type, such as Insurance Payer or Rendering Provider, you can have OP display either Patient A/R, Insurance A/R, or Total A/R and organize it into buckets for you. Additionally, you can choose to Show summary totals or Show Patient Details by selecting the corresponding radio button.

Printing Grid

Some practices like to keep a copy of reports that they have processed. You can use the Print button if you would like to have a paper or PDF copy of the report you have run. The report will open in Print Preview Mode. You can then either click the Print or Export to PDF icon.

If you export to PDF you will be given some options regarding how you would like to save the image. Remember, when saving practice-sensitive information or any kind of PHI outside of Office Practicum, you should consider who has access to the information you are saving. You can add a password to the PDF you are saving by going to the Security Tab, checking the box that says "Enabled" and adding a user password. You can also choose to protect your data in some other way within your own network.

Once you click OK, you will be given a “Save As” dialog box. You can then save it in any location and under any name you like. If you have added a password, you will be prompted to enter it when you attempt to open the report.

Export to Excel or CSV

You may also export to Excel if you would like to reorganize or further calculate the data from the A/R Report. Click the Export button. You will be given a Save As dialog box where you can name and chose a file location.

The exported information will appear in Excel exactly as you see it in Office Practicum.

Historical A/R Analysis

Billing tab > A/R button > Historical A/R Analysis

The Historical A/R Analysis reports display a summary of A/R data as it was during the selected time frame. Transaction balances are summarized for each Daysheet ID. The A/R report type that you choose organizes the data for you into buckets, such as Rendering Provider or Location. In order to access this report in OP, users will need the OP_Reports_AR permission.

Reminder to run Historical A/R Analysis Setup prior to first use

Before you run the Historical A/R Analysis for the first time, a setup process needs to be run manually one time prior to using the Historical A/R Analysis report (please see Proof Patient Account below). This process will assign Daysheet IDs to all past daysheets and capture totals for future calculations. It will take time and a substantial portion of the server’s processor to complete. It is very important to run the setup during off hours so that your office does not experience a slowness in Office Practicum.

Running the Historical A/R Analysis Report

A/R Report Type

The Historical A/R report type you select will determine how Office Practicum organizes your data. OP will organize your historical data into buckets according to your selection, such as Rendering Provider.

Date Range Choices

  • Last Daysheet: By choosing Last Daysheet you can choose to show only your most recent information. This snapshot can show you the charges, payments, and change to A/R from your last daysheet.
  • For Range
  • All 

Include non-daysheeted transactions

You may also set the Historical A/R Analysis to include non-daysheeted transactions by checking the box. If the box is unchecked, the report defaults to only including data that has been processed onto a daysheet.

Depending on the preferences and purposes of the user, the columns that appear in the grid can be customized by choosing the customizer and adding or removing check marks to suit your needs. User preferences can be saved for later use.

Printing Grid

  1. You can use the print grid button if you would like to have a paper or PDF copy of the report you have run. The report will open in Print Preview Mode. You can then either click either the "Print" or "Export to PDF" icon.
  2. If you export to PDF you will be given some options regarding how you would like to save the image. Remember, that when saving practice sensitive information or any kind of PHI outside of Office Practicum, you should consider who has access to the information you are saving. You can add a password to the PDF you are saving by going to the Security Tab, checking the box that says "Enabled" and adding a user password or you can choose to protect your data in some other way within your own network.
  3. Once you click OK, you will be given a "Save As" dialog box. You can then save it in any location and under any name you prefer. If you have added a password, you will be prompted to enter it when you attempt to open the report.

Export to Excel

  1. You may also export to Excel if you would like to reorganize or further calculate the data from the A/R Report. Click the "Export" button. You will be given a Save as dialog box where you can name and chose a file location.
  2. The exported information will appear in Excel exactly as you see it in Office Practicum.

Proof Patient Accounts

Billing tab > Proof Patient Accounts

The Patient Accounts: Proof Calculation and A/R History Maintenance window houses several important functions. Within this window, you can display three cross- referencing database proof calculations, review any accounts out of proof if they exist, and process A/R Data Update Procedures. In order to access this functionality, users will need the OP_Reports_AR permission.

In addition, there are two processes you will need to run before you begin to utilize the new set of financial reports contained in OP versions 11.4.16 and higher. The first is to run a maintenance procedure on the Proof Calculation Tab and a setup process on the A/R Data Update Procedures. Directions on how to run these processes are included in the sections that describe the tabs.

  • Proof Calculation Tab
  • Description

The Proof Calculation Tab calculates and displays Patient, Insurance, and Total Accounts Receivable with three different mathematical sequences.

The first time you come to this tab you should begin by clicking the Run button. Office Practicum’s maintenance procedure will recalculate all balances in the patient register and will attempt to correct any out-of-proof accounts. In addition to auto-correcting certain types of out-of-proof claims, the function checks for out of range service dates and assigns a Provider ID of zero to any instances where the Provider ID was not originally included.

External OP Reports

Tools tab > OP Reports button

OP Reports provides a repository of all reports that are generated from within OP. Upon launching OP Reports, OP will prompt the user to log in with the same username and password that they use to access the Office Practicum software. The reports contained in the folders can be utilized or edited from within OP Reports. 

Superbill

[Example]

  • Superbill by Provider - Prints charges on superbill by date by provider.
  • Superbill by Insurance - Prints charges on superbill by date by insurance carrier.

Billing Reports

[Example]

These reports are located in the Billing_Rpts folder and are printed directly from Office Practicum. They should not be modified by the practice.

  • Billing CC receipt - Prints a receipt for a credit card transaction.
  • Billing PCA receipt - Prints a receipt for a patient's credit account.
  • Billing Statement - Prints a billing statement for a selected patient.
  • Billing Statement Family - Billing statement total for the family.
  • Billing Statement cp - Only prints the patient's responsibility on the statement.
  • Billing Statement cp Family - Prints the patient responsibility total for the family.
Version 14.10

The following reports are available and are included with a new install or update of Office Practicum. These reports can be run from the OP Reports program. OP Reports is access from Tools menu in OP. 

Please contact Office Practicum support if you require a report not on this list, or if you need a report on this list but don't have it on your computer.

The following reports are available and are included with a new install of Office Practicum. These reports can be run from within the OP program. To access Financial Reports, click on Reports in the gray toolbar. 

  • Reports  > Standard Reports
  • Reports  > Billing Transaction Analysis
  • Reports  > Reimbursement Analysis
  • Reports  > A/R Aging Analysis (requires permission OP_Rpts_AR)
  • Reports  > Historical A/R Analysis (requires permission OP_Rpts_AR)
  • Reports  > Patient Proof Accounts (requires permission OP_Rpts_AR)
  • A/R Aging Analysis
  • Historical A/R Analysis
  • Patient Proof Accounts
Reports are only visible if a user is given specific permission (OP_Rpts_AR under Security Administration). If user is logged in and does not see these available reports, please see your office administrator.

Standard Reports

Use of Standard reports will allow users to view, in 7 simple drop down reports, a quick summary of the office’s productivity. These reports will display information that has been processed on a daysheet.

  1. To utilize these reports, a user will choose their desired report

  1. Select their Reference Dates:

  1. Choose their transactions based on:
  • Charge/Payment
  • Posting (entry)
  • Daysheet
  • Daysheet ID

The report, displayed below, shows the Charges per Scheduled Appointment for 1/7/2016-9/28/2017.

Printing Grid

  1. You can use the Print grid button if you would like to have a paper or PDF copy of the report. 
    • If you export to PDF, you will be given some options regarding how you would like to save the image. Remember, that when saving practice sensitive information or any kind of PHI outside of Office Practicum, you should consider who has access to the information you are saving. You can add a password to the PDF you are saving by going to the Security tab, checking the box that says Enabled and Adding a User Password. You can also choose to protect your data in some other way within your own network.
    • Once you click OK, a "Save As" dialog box appears. You can then save it in any location under any name you prefer. If you have added a password, you will be prompted to enter it when you attempt to open the report.

Export to Excel

You may also export to Excel if you would like to reorganize or further calculate the data from the A/R Report. 

  1. Click the Export button. You will be given a Save As dialog box where you can name and chose a file location.
  2. The exported information will appear in Excel exactly as you see it in Office Practicum.

Billing Transaction Analysis

OP’s Billing Transaction Analysis will show users the flexibility of reporting options that are available for all users' needs. This report can be used to capture items such as provider productivity or CPT Utilization, to name a couple examples. This report can be filtered, sorted, and grouped using the column headers, and can also be printed or exported. 

There are several Reference Date options to choose from depending on the data that is needed:

  • Charge/payment date: This report accesses charges according to their charge date (usually date of service) and payments and adjustments according to their payment date (which can be backdated at the time of posting).
  • Posting (entry) date: This report accesses charges, payments, and transactions that have a posting date within the time frame selected. NOTE: This date is time stamped from the local computer where the user is posting payments and does not take into consideration the date of service for charges or any backdating done when posting payments.
  • Daysheet: This report accesses only daysheeted transactions between the two reference dates entered. 
  • Daysheet ID: This report accesses data based on the Daysheet ID range that is entered in the Choose Daysheet ID Range field once this radio button is selected.  

Reimbursement Analysis

This report accesses reimbursement information as a summary instead of individual transactions. Therefore, any payments shown are associated with the date of the charge to which they are applied. This report can be used for addressing contractual payments from the insurance, but should not be used for accounting purposes.

  • Charge DOS: This report processes a reimbursement summary for charges according to their charge date (date of service).
  • Posting (entry) date: This report processes a reimbursement summary for charges that have a posting date within the time frame selected. This date is time stamped from the local computer where the user is posting payments and does not take into consideration the date of service for charges.
  • Daysheet date: This report processes a reimbursement summary for charges daysheeted during a specific date range. This selection excludes non-daysheeted transactions.

A/R Aging Analysis

The A/R Aging Analysis report displays a summary of the practice’s accounts receivable. It is intended to help practices identify areas of concern and manage the practice’s financial health. In order to access this report in the Reports menu, users will need the OP_Reports_AR permission.

As a reminder, clicking on the “Update” button in the Patient Calculation window runs a function that adds new charges and payments to the A/R grid. It also recalculates the date range buckets (the time that has elapsed from the date of service to the current date). You should run the update prior to running your A/R Aging Analysis report if daysheets have been processed, or if days have passed since you last ran the update process.

Running the A/R Analysis Report

A/R report type

The A/R report type you select will determine how Office Practicum organizes your data. For each report type, such as Insurance Payer or Rendering Provider, you can have OP display either Patient A/R, Insurance A/R, or Total A/R and organize it into buckets for you.

Summary Versus Show Patient Details

If you choose to review the Ins. Payer report with data for either Insurance A/R or Patient A/R, you will also have the ability to see the details of the outstanding receivables by patient. In this mode, you can review collection efforts for the claim shown as well as access the patient account to work the balance.

Printing Grid

Some practices like to keep a copy of reports that they have processed. You can use the Print grid button if you would like to have a paper or PDF copy of the report you have run. The report will open in Print Preview Mode. You can then either click the Print or Export to PDF icon.

If you export to PDF you will be given some options regarding how you would like to save the image. Remember, when saving practice-sensitive information or any kind of PHI outside of Office Practicum, you should consider who has access to the information you are saving. You can add a password to the PDF you are saving by going to the Security Tab, checking the box that says "Enabled" and adding a user password. You can also choose to protect your data in some other way within your own network.

Once you click OK, you will be given a “Save As” dialog box. You can then save it in any location and under any name you like. If you have added a password, you will be prompted to enter it when you attempt to open the report.

Export to Excel or CSV

You may also export to Excel if you would like to reorganize or further calculate the data from the A/R Report. Click the "Export" button. You will be given a Save As dialog box where you can name and chose a file location.

The exported information will appear in Excel exactly as you see it in Office Practicum.

Historical A/R Analysis

The Historical A/R Analysis reports display a summary of A/R data as it was during the selected time frame. Transaction balances are summarized for each Daysheet ID. The A/R report type that you choose organizes the data for you into buckets, such as Rendering Provider or Location. In order to access this report in the Reports menu, users will need the OP_Reports_AR permission.

Reminder to run Historical A/R Analysis Setup prior to first use

Before you run the Historical A/R Analysis for the first time, a setup process needs to be run manually one time prior to using the Historical A/R Analysis report (please see Patient Proof Account below). This process will assign Daysheet IDs to all past daysheets and capture totals for future calculations. It will take time and a substantial portion of the server’s processor to complete. It is very important to run the setup during off hours so that your office does not experience a slowness in Office Practicum.

Running the Historical A/R Analysis Report

A/R Report Type

The Historical A/R report type you select will determine how Office Practicum organizes your data. OP will organize your historical data into buckets according to your selection, such as Rendering Provider.

Date Range Choices

Last Daysheet
By choosing Last Daysheet you can choose to show only your most recent information. This snapshot can show you the charges, payments, and change to A/R from your last daysheet.

For Range

Totals v. Daily Details
You can also precisely define a time frame that you would like to review by selecting a beginning and ending date or beginning and ending Daysheet ID. In this mode you can pinpoint any specific information you would like to review.

In addition to giving you the flexibility to define a date range, the "For Range" option also allows you to choose between seeing totals from that range and seeing daily details when you define the range by beginning and ending dates.

All
You can also see all historical data by choosing All.

Include non-daysheeted transactions

You may also set the Historical A/R Analysis to include non-daysheeted transactions by checking the box. If the box is unchecked, the report defaults to only including data that has been processed onto a daysheet.

Depending on the preferences and purposes of the user, the columns that appear in the grid can be customized by choosing the customizer and adding or removing check marks to suit your needs. User preferences can be saved for later use.

Printing Grid

  1. You can use the print grid button if you would like to have a paper or PDF copy of the report you have run. The report will open in Print Preview Mode. You can then either click either the "Print" or "Export to PDF" icon.
  2. If you export to PDF you will be given some options regarding how you would like to save the image. Remember, that when saving practice sensitive information or any kind of PHI outside of Office Practicum, you should consider who has access to the information you are saving. You can add a password to the PDF you are saving by going to the Security Tab, checking the box that says "Enabled" and adding a user password or you can choose to protect your data in some other way within your own network.
  3. Once you click OK, you will be given a "Save As" dialog box. You can then save it in any location and under any name you prefer. If you have added a password, you will be prompted to enter it when you attempt to open the report.

Export to Excel

  1. You may also export to Excel if you would like to reorganize or further calculate the data from the A/R Report. Click the "Export" button. You will be given a Save as dialog box where you can name and chose a file location.
  2. The exported information will appear in Excel exactly as you see it in Office Practicum.

Proof Patient Accounts

The Patient Account Proof Calculation and A/R History Maintenance window houses several important functions. Within this window, you can display three cross referencing database proof calculations, review any accounts out of proof if they exist, and process A/R Data Update Procedures. In order to access this functionality, users will need the OP_Reports_AR permission.

In addition, there are two processes you will need to run before you begin to utilize the new set of financial reports contained in OP versions 11.4.16 and higher. The first is to run a maintenance procedure on the Proof Calculation Tab and a setup process on the A/R Data Update Procedures. Directions on how to run these processes are included in the sections that describe the tabs.

  • Proof Calculation Tab
  • Description

The Proof Calculation Tab calculates and displays Patient, Insurance, and Total Accounts Receivable with three different mathematical sequences.

The first time you come to this tab you should begin by clicking the “Run” button. Office Practicum’s maintenance procedure will recalculate all balances in the patient register and will attempt to correct any out-of-proof accounts. In addition to auto-correcting certain types of out-of-proof claims, the function checks for out of range service dates and assigns a Provider ID of zero to any instances where the Provider ID was not originally included.

External OP Reports

Lastly, there is one more module of OP reports that is not listed within the Office Practicum windows you have been working in throughout your training. If the user goes to Tools on the Smart Tool Bar there is a dropdown option for OP Reports.

OP will prompt the user to log in with the same username and password that they use to access the Office Practicum software.

There will be folders of different reports to run. The goal with these reports is to modify information that is printing on hard coded reports such as Superbills or Billing Statements. If the user wishes to modify the information that populates on their superbill report, patient statements, or any other report that generates from OP data, the user may open the design of these reports and input information that they wish to see when printing out of Office Practicum software. For more information on designed reports, please see "Designing Reports."

Superbill

[Example]

  • Superbill by Provider - Prints charges on superbill by date by provider.
  • Superbill by Insurance - Prints charges on superbill by date by insurance carrier.

Billing Reports

[Example]

These reports are located in the Billing_Rpts folder and are printed directly from Office Practicum. They should not be modified by the practice.

  • Billing CC receipt - Prints a receipt for a credit card transaction.
  • Billing PCA receipt - Prints a receipt for a patient's credit account.
  • Billing Statement - Prints a billing statement for a selected patient.
  • Billing Statement Family - Billing statement total for the family.
  • Billing Statement cp - Only prints the patient's responsibility on the statement.
  • Billing Statement cp Family - Prints the patient responsibility total for the family.