Financial Dashboards: Understanding Dashboard Data and How to Compare It to OP Data

This content is intended for use by OP RCM Clients only.

Overview

The dataset for OP Financial Dashboards includes three full calendar years in addition to the present year. Meaning, prior to January 1, 2021, the first date in the dataset is January 1, 2017 and after January 1, 2021, the first date in the dataset is January 1, 2018.

Compare Dashboard Data to OP Data

Path: Billing tab > Transactions drop-down > Transaction Analysis

OP Financial Dashboards reference the same data as that which is displayed in the Billing Analysis Report. The only caveat to take into consideration when comparing one to the other for the purpose of validating data is the dataset restriction described in the Overview section above. The steps below should be taken if you are attempting to validate Financial Dashboard data to data displayed in the Billing Analysis Report.

  1. Navigate to the Billing Analysis report by following the path above.
  2. Set the report parameters:
  1. Enter your date range. If you are validating data from the beginning of the dataset, enter January 1, 2018 as your start date and the ending date that you used when viewing your Dashboards.
  2. Select the Posting (entry) radio button and deselect the Include voids checkbox if it is selected.
  3. Click Refresh Grid to populate the report data.
  1. Click the Add columns button , and select the checkboxes (if not already selected) for the following to add them to the grid.
  • Date Posted
  • Trans. #
  • Tx # Paid
  1. Click the Date Posted column header to sort the transactions by earliest date, and scroll to the top of the list so that you are starting with the earliest date in your range.
  2. In the report grid, scroll down to identify the first occurrence (based on Date Posted) of an actual charge CPT code. CPTs such as 1, 2, or 4 reference transactions made on charges outside of the dataset and do not count as actual CPTs.
  3. Make note of the Trans. # for that line item. This is the transaction number that begins your dataset and will be used in step 8.
  4. Hover over Tx # Paid column, select the filter icon, and click Custom
  5. Create your filter to be equals 0 or greater than the Trans. # you identified as the start to your dataset in step 6.

  1. Click OK.