Effective Intelligence Power BI Report Training Definitions
Power Bi is an analytic tool designed by MedEvolve to allow practices to have real time insight into key metrics. It allows the end user to quickly diagnosis the health of the practice based on financial metrics.
MedEvolve Ei Vault
Effective Intelligence
- Service Location – List of Service Location in which claims are sent out for
- Visit Count – Total number of visits in which claims were billed
- Visit Resolution % - Percentage of visits assigned to a representative that were successfully resolved. [Visit that received an insurance payment within 60 days of the first action taken] / [Assigned Visits]
- Zero Touch Visits % - Percentage of total visits that required no touches. [Visits without an Edit, Denial, Refile, or AR Action] / [Total Visits]
- Collection Effectiveness % - Percentage of collections out of expected collections on assigned visits. [Realized Gross Collections on Assigned Visits] / [Expected Gross Collections on Assigned Visits]
- Exhausted Visit % - Percentage of Visits that have been touched 5 or more times. [Visits with 5 or more touches] / [Assigned Visits]
- 7At Risk % - Percentage of outstanding AR that needs special attention. [Open Balance Insurance Visits with a balance >$25, has had no Insurance Payment, and hasn’t been touched in 90 days] / [Open Balance Insurance Visits]
- Work Effort Rate – Average touches it takes to receive a successful resolution. [Action Taken] / [Assigned Visits]
Zero Touch Visits
- Service Location – List of Service Locations in which claims are sent out for
- Visit Count – Total number of visits in which claims were billed
- Zero Touch Visits % - Percentage of visits assigned to a representative that were successfully resolved. [Visit that received an insurance payment within 60 days of the first action taken] / [Assigned Visits]
- Edited Visits % - Percentage of visits that required a representative to correct an Edit (unprocessables, invalid, or reject)
- Refiled Visits % - Percentage of visits that required a representative to refile the claim with the payer for any reason.
- Denied Visits % - Percentage of visits that required a representative to resolve or attempt a denial received on the visit.
- Action Visits % - Percentage of visits that required a representative to take any action on the claim to get the visit paid.
-
Task Visits % - Percentage of visits that required a representative to create a task for additional help or information to get the visit paid.
Work Effort Rate
- Service Location – List of Service Locations in which claims are sent out for
- Visit Count – Total number of visits in which claims were billed
- Work Effort Edit Rate – Average number of times a claim is touched for a unprocessables, invalid or rejection edit worked.
- Work Effort Refile Rate – Average number of times a claim is touched to refile the claim with the payer.
- Work Effort Denial Rate - Average number of times a claim is touched a denial on the claim.
- Work Effort Action Rate – Average number of times a claim is touched in Workflow for Insurance AR Follow Up to get the claim paid.
- Work Effort Task Rate – Average number of times a task is touched from another department for clarification to assist in resolving the claim in Workflow.
MedEvolve RCM Scorecard
Key Metrics
- Charge Lag – Office – The average number of days that pass between the Service Date and the first charge postdate on the visit. Benchmark is 2 days.
- Charge Lag – Other – The average number of days that pass between the Service Date and the first charge postdate on the visit. Benchmark is 5 days.
- Visits – The number of visits for the month.
- New Patient Visits % - Percentage of visits that recorded a new patient procedure code (90791, 90792, 99201, 99202, 99203, 99204, 99205, 99217, 99218, 99219, 99220, 99221, 99222, 99223, 99234, 99235, 99236, 99238, 99239, 99241, 99242, 99244, 99245, 92002, 92004, 92070) [New Patient Visit Count] / [Visit Count]
- OTC Collections / Office Visit – The average collection from a patient per visit at an office location. OTC Collection are Private Payments posted within 7 days of the Service Date. [OTC Collections Office] / [Office Visit Count]
- OTC Collections / Other Visit - The average collection from a patient per visit at a surgery location. OTC Collection are Private Payments posted within 7 days of the Service Date. [OTC Collections Other] / [Other Visit Count]
- Unreconciled Appt % - Completed appointments that do not have a matching charge based on Patient Service Date. [Unreconciled Appt. Count] / [Completed Appt. Count]
- Complete Write Off – Visits that have gone to a $0 balance, had more than $0 charges, and were the sum of charges equal the sum of adjustments
- Encounters w Edits – The number of encounters that received an edit response either from MedEvovle PM or Practice Insight Claim Scrubber.
- Edits Amount – The amount of claim that received an edit response either from MedEvovle PM or Practice Insight Claim Scrubber
- Denied Visits – The number of visits that denied
- Denied Amount – The amount of the claims that received a denial
- AR Debit Balance – The AR Debit Balance on all open AR
- AR Debit Opportunity – The estimated amount of revenue on existing AR based on the historic Gross Collection Ration of the primary insurance plan.
- AR Debit Denied % - The percentage of Debit AR that has received a Denial [Denied Debit AR] / [Debit AR]
- AR Debit > 60 Days % - The percentage of Debit AR still open 60 days after the Service Date [Denied AR >60 Days] / [Debit AR]
- AR Debit Insurance > 60 Days % - The percentage of Insurance Debit AR still open 60 days after the Service Date [Insurance Debit AR >60 Days] / [Insurance Debit AR]
- AR Debit Self Pay >60 Days % - The percentage of Self Pay Debit AR still open 60 days after the Service Date [Self Pay Debit AR >60 Days] / [Self Pay Debit AR]
-
AR Days (1yr. avg) – The average number of days it takes a visit from the original Charge Post Date to the $0 balance date (1yr. avg) [Debit AR] / [Average Daily Charges ]
- AR Days (180 days avg) - The average number of days it takes a visit from the original Charge Post Date to the $0 balance date (180 days avg) [Debit AR] / [Average Daily Charges]
- AR Days (90 days avg) – The average number of days it takes a visit from the original Charge Post Date to the $0 balance date (90 days avg) [Debit AR] / [Average Daily Charges]
- AR Credit Balance – The amount of AR Credit Balance on the open AR
Charge Measures
- Control Month End Period – The Month of the Control End Period (which means the month in which the data was entered into the MedEvolve PM System)
- Charges – The total amount of charges entered during the Control Month End Period
- Payments – The total amount of payments entered during the Control Month End Period
- Insurance Payments – The total amount of insurance payments entered during the Control Month End Period
- Private Payments – The total amount of private payments entered during the Control Month End Period
- Adjustments – The total amount of the adjustments entered during the Control Month End Period
- Visit Count – The total visit count of the Control Month End Period
- Charge/Visit – The charges per visit for the Control Month End Period [Charges] / [Visit Count]
- Payment/Visit – The payments per visit for the Control Month End Period [Payments] / [Visit Count]
- Insurance Provider – The Insurance Provider associated with the data reflected
- CPT Group – The CPT Group associated with the data reflected
- Insurance Category – The Insurance Category associated with the data reflected
Collections Ratios
- Service Period – The Service Period is the actual DOS (date of service)
- Charges – The charges entered for the Service Period
- Payments – The payments entered for the Service Period
- GCR % (Gross Collection Ratio %) – The amount of revenue collected on charges so far [Total Payments] / [Total Charges]
- Contractual Adj – The contractual adjustments entered for the Service Period
- NCR % (Net Collection Ratio %) – The amount of revenue collected on the estimated allowable so far [Total Payments] / [Total Charges – Contractual Adjustments]
- Other Adjustments – The other adjustments entered for the Service Period.
- Bill – The patient responsibility amount for the claims of the Service Period.
- No Bill – The insurance responsibility amount for the claims of the Service Period.
- Insurance Provider – The Insurance Provider associated with the data reflected
- CPT Group – The CPT Group associated with the data reflected
- Primary Insurance Category – The Primary Insurance Category on the claims
- Monthly Averages – The average monthly values based on the 6 Service Periods starting 3 months ago
$0 Balances
- Control Month End Period – The Month of Control Month End Period (which means the month in which the data was entered into the MedEvolve PM System) of the final transaction that brought the Visit Balance to $0
- Charges - The total amount of charges entered for visits that went to a $0 Balance in the Control Month End Period
- Payments - The total amount of payments entered for visits that went to a $0 Balance in the Control Month End Period
- Visits - The total visits that went to a $0 Balance for the Control Month End Period
- GCR % (Gross Collection Ratio %) - The amount of revenue collected on charges so far [Total Payments] / [Total Charges]
- NCR% (Net Collection Ratio %) – The amount of revenue collected no the estimated allowable that went to a $0. [Total Payments] / [Total Charges – Contractual Adjustments]
- Complete Write Off – Visits that have gone to a $0 balance, had more than $0 charges, and were the sum of charges equal the sum of adjustments
- Contractual Adjustments – The Contractual adjustments entered for visits that went to a $0 Balance in the Control Month End Period
- Insurance Provider – The Insurance Provider entered for the Control Month End Period
- Last Denial Category – The Denial Category of the last denial that was posted on the claim before it went to $0 Balance
- Last Adjustment Category – The Adjustment Category of the last adjustment that was posted on the claim before it went to $0 Balance
- Primary Insurance Category – The Primary Insurance Category on the claim.
Work RVUs
- Service Period – The Service Period is the actual DOS (date of service)
- Work RVUs – Total number of Work RVUs posted for the Service Period [calculation based on CMS Guidelines]
- wRVUs / Visit – Total number of wRVUs per visit for the Service Period [calculation based on CMS Guidelines]
- Charges- Total Charges that were posted for the Service Period [calculation based on CMS Guidelines]
- Charges / wRVUs – Total Charges per wRVU posted for the Service Period [calculation based on CMS Guidelines]
- Payments – Total Payments that were posted for the Service Period [calculation based on CMS Guidelines]
- Payments / wRVUs – Total payments per wRVU posted for the Service Period [calculation based on CMS Guidelines]
- Total RVUs – Total RVUs posted for the Service Period [calculation based on CMS Guidelines]
- Insurance Provider – The insurance Provider associated with the data reflected
- POS Location Service Period – The POS Location (office or surgery [other]) for the Service Period
- Office Work RVUs – Total number of Office Work RVUs posted for the Service Period [calculation based on CMS Guidelines]
- Office wRVUs / Visit – Total number of Office wRVUs V’s posted for the Service Period [calculation based on CMS Guidelines]
- Office Charges / wRVU – Total Number of Office Charges RVUs posted for the Service Period [calculation based on CMS Guidelines]
- Office Payments / wRVU – Total number of Office Payments RVUs posted for the Service Period [calculation based on CMS Guidelines]
- Other Work RVUs – Total number of Other Work RVUs posted for the Service Period [calculation based on CMS Guidelines]
- Other wRVUs / Visit – Total number of Other wRVUs V’s posted for the Service Period [calculation based on CMS Guidelines]
- Other Charges / wRVU – Total number of Other Charges RVUs posted for the Service Period [calculation based on CMS Guidelines]
- Other Payments / wRVU – Total number of Other Payments RVUs posted for the Service Period [calculation based on CMS Guidelines]
- CPT Group – The CPT Group associated with the data reflected
Edits
- Claim Error – Pre-Claim errors from the Clearinghouse’s scrubber
- Claim Rejection – Pre-Claim payer edits as reported by the Clearinghouse
- Unprocessables – Claim edits from MedEvolve’s claim scrubber
- Edit Type – The type of the edit from either MedEvolve or Clearinghouse claims scrubber
- Edit Message – The edit message associated from the claims scrubber that the claim hit for
- Edits Amount – The amount of the edit that the claims scrubber that the claim hit for
- Insurance Name – The Insurance Name associated with the edit that the claim
Denials
- Denial Category – Category in which specific denial ANSI codes roll up to
- Insurance Provider – The Insurance Provider associated with the data reflected
- Denied Amount – The amount of the denial on the claim
- CPT Group – The CPT Group associated with the data reflected
- Insurance Category – The Insurance Category associated with the data reflected
Payer Mix Trending
- Change % - The percentage of charges by payer category for each month’s total charges
- Payment % - The percentage of payments by payer category for each month’s total payments
- Gross Collection Ration % - The amount of revenue collected on charges that reached a $0 Balance in each given month [Total Payments] / [Total Charges]
AR Liquidity
- AR Balance – The beginning AR balance for the month
- Charges – The total charges for the month
- Insurance Payments – The total insurance payments for the month
- Private Payments – The total private payments for the month
- UCR Write Off – The total UCR Write Off’s for the month
- Other Adjustments – The Total other adjustments for the month
- Change in AR – The Change in AR balance for the month
- Adjustment Category – The Adjustment Category in which specific adjustment codes roll up to
- Transaction Type – The type of transaction posted for the month
- AR Equation / Change in AR – [Charges – Payments – Adjustments = Change in AR]
- Transaction Categories – Expand each of the transaction categories to see which transaction codes roll up under each group.
AR Snapshot
- Current Insurance Category – The last known payer who is responsible for the visit
- a. Self Pay Primary – AR balances for visits that did not have insurance
- b. Self Pay Pass-Through – AR Balances for visits that started with insurance and have since been placed into patient responsibility
- Service Date Aging Buckets – Aging buckets here are AR balances aged since the Service Date
- Service Date 0-60 & 61+ - Aging of AR by Service date reflected 0-60 & 61+
- File Date Aging Buckets – Aging buckets here are AR balances aged since the File Date
- File Date 0-60 & 61+ - Aging of AR by File date reflected 0-60 & 61+
- Visit Entry Aging Buckets – Aging buckets here are AR balances aged since the Visit Entry
- Visit Entry 0-60 & 61+ - Aging of AR by Visit entry reflected 0-60 & 61+
- Bill Date Aging Buckets – Aging buckets here are the balance aged since the Bill Date
- Bill Date 0-30 & 31+ - Aging of AR by bill date reflected 0-30 &31+
- Last Insurance Payment Aging Buckets – Aging buckets here are AR balance aged since the Last Insurance Payment Date
- Last Insurance Payment 0-60 & 61+ - Aging of AR by Last payment reflected payment 0-60 & 61+
- Last Insurance Event Aging Buckets – Aging buckets here are AR balances aged since the Last Insurance Event Date
- Last Event 0-60 &61+ - Aging of AR by Last event reflected Event 0-60 & 61+
- Last Private Payment Aging Buckets – Aging buckets here are AR balances aged since the Last Private Payment date
- Last Private Payment 0-60 & 61+ - Aging of AR by Last payment reflected Payment 0-60 &61+
- Last Self Pay Event Aging Buckets – Aging buckets here are AR balances aged since the Last Self Pay Event Date
- Last Self Pay Event 0-60 & 61+ - Aging of AR by Last event reflected Self Pay Event 0-60 & 61+
AR Snapshot by Count
- Current Insurance Category – The last known payer who is responsible for the visit
- Self Pay Primary – AR balances for visits that did not have insurance
- Self Pay Pass-Through – AR Balances for visits that started with insurance and have since been placed into patient responsibility
- Service Date Aging Buckets – Aging buckets here are AR balances aged since the Service Date
- Service Date 0-60 & 61+ - Aging of AR by Service date reflected 0-60 & 61+
- File Date Aging Buckets – Aging buckets here are AR balances aged since the File Date
- File Date 0-60 & 61+ - Aging of AR by File date reflected 0-60 & 61+
- Visit Entry Aging Buckets – Aging buckets here are AR balances aged since the Visit Entry
- Visit Entry 0-60 & 61+ - Aging of AR by Visit entry reflected 0-60 & 61+
- Bill Date Aging Buckets – Aging buckets here are the balance aged since the Bill Date
- Bill Date 0-30 & 31+ - Aging of AR by bill date reflected 0-30 &31+
- Last Insurance Payment Aging Buckets – Aging buckets here are AR balance aged since the Last Insurance Payment Date
- Last Insurance Payment 0-60 & 61+ - Aging of AR by Last payment reflected payment 0-60 & 61+
- Last Insurance Event Aging Buckets – Aging buckets here are AR balances aged since the Last Insurance Event Date
- Last Event 0-60 &61+ - Aging of AR by Last event reflected Event 0-60 & 61+
- Last Private Payment Aging Buckets – Aging buckets here are AR balances aged since the Last Private Payment date
- Last Private Payment 0-60 & 61+ - Aging of AR by Last payment reflected Payment 0-60 &61+
- Last Self Pay Event Aging Buckets – Aging buckets here are AR balances aged since the Last Self Pay Event Date
- Last Self Pay Event 0-60 & 61+ - Aging of AR by Last event reflected Self Pay Event 0-60 & 61+
AR Trending
- Service Date Age Bucket – Service date Aging buckets
- Service Date Age Bucket 2 – Service date Aging buckets including 60+ or 0-60
- AR Balance – The AR Balance for the indicated Aging Bucket from the Service Date
- AR Balance % - The AR Balance % for the indicated Aging Bucket from Service Date
- Current Insurance Category – The Current Insurance Category
A/R Days
- POS Location – POS Location such as Office or Other (surgery)
- AR Bal – AR Balance
- AR Days 365 – AR Days calculated with 365 days’ worth of data [Debit AR] / [Average Daily Charges]
- AR Days 180 – AR Days calculated with 180 days’ worth of data [Debit AR] / [Average Daily Charges]
- AR Days 90- AR Days calculated with 90 days’ worth of data [Debit AR] / [Average Daily Charges]
- Primary Insurance Category – The Primary Insurance Category
- CPT Group – The CPT Group
Appointments
- Appt Status – The appointment status in MedEvolve PM
- Completed Appt – The number of appointments marked as Completed in the MedEvolve PM
- Unreconciled Appt % - The percentage of appointments that are on the schedule but do not have a corresponding charge posted on the claim [Unreconciled Appt. Count] / [Completed Appt. Count]
- Reconciled – The number of appointments that have a charge associated with the appointment
- Future Appt – The number of appointments scheduled for future months
- Previous Balance Appt – The number of appointments scheduled where the patient has an open Bill balance
- Previous Appt Balance – The Bill Balance owed by patients with appointments scheduled
Appointments by Source
- Primary Referring Provider – The primary referring provider associated with the appointment
- Primary Care Provider – The primary care provider associated with the appointment
- Referring Source – The referring source associated with the appointment
- Scheduled User – The user who scheduled the appointment
Filters for Appointments by Source Tab
- Appt Category – The appointment category associated with the appointment
- AR Balance – The balance of the AR you have the ability to choose a min or max
- Clinic Name – The Clinic names for the client
- Control Month End Period – The Control Month End Period Filter
- CPT Group- The CPT Groups to filter for the client
- CPT Group and Code – The CPT Groups to filter for the client
- Credit Debit – Choice for displaying data for either credits or debits
- Current Insurance Category – The Current insurance category to filter by
- Current Insurance Type – Choice for displaying data for either Insurance or Self Pay
- Custom Division – The divisions the client has identified to filter between
- Denial – Whether the message from the insurance company is considered a denial or not
- Denial _YN – AR balances that have had a denial entered or not
- Denial Category – The Category the denials can be filtered by
- Financial Location – The Financial Locations available to filter for the client
- First Pass Denial – The first time a specific denial code appears on a visit
- Insurance Payment _YN – AR balances that have either received an Insurance Payment or not
- Insurance Provider – The Insurance Provider available to filter for the practice
- Insurance Provider Specialty – The Specialty to filter for the Insurance Providers at the practice.
- Insurance Type – The current payer type responsible for the visit balance
- Open Charge_YN – AR balances that have had their charge entered but not yet posted or not
- Open Denial – Any denial on an open balance that has yet to receive and insurance payment
- Patient Credit Debit – AR balances for patients based on their total owed AR
- POS Location – Ability to filter for the Office visits or Surgery visits
- Primary Insurance Category – The Primary Insurance Category on the claims
- Primary Insurance Type – The Primary Insurance Type on the claims
- Remaining GCR – The percentage of remaining gross collections based on the Charge amount [Total Payments] / [Total Charges]
- Service Location – The Service Locations available to filter for the client
- Service Provider – The Service Provider available to filter for the practice
- Service Provider Specialty – The Specialty to filter for the Service Provider at the practice
- UCR Adjustment_YN – AR balances that have either received a denial or not
MedEvolve Billing Dashboard
- Rule Name – The name the rule from the scrubber in MedEvolve PM that reviews the claim prior to it going to the clearing house for Scrubbing.
- Count of Claim Key – The number of claims that hit the scrubbing edit.
- Claim Charges – The amount of the claim that hit the scrubbing edit.
- Insurance Provider – The insurance provider associated with the claim that hit the scrubbing edit
- Primary Insurance Name – The primary insurance associated with the claim that hit the scrubbing edit
- Claim Date – The file date of the claim that hit the scrubbing edit
- File Type – The filing type of the claim that hit the scrubbing edit
MedEvolve Daily Operations
Current Month thru Previous Day
- Clinic Name – The clinic names for the client
- Previous Day Debit Charges – The total charges that were posted to a closed control yesterday
- Current Month Total Charges – The total charges that have been posted to a closed control MTD
- Previous Day Total Payments – The total payments that were posted to a closed control yesterday
- Current Month Total Payments – The total payments that were posted to a closed control MTD
- Max Service Date – At least one charge has been posted for services from the date reflected
- Max Surgery Date – At least one charge has been posted for surgeries from the date reflected
- Max Procedure Date – At least one charge has been posted for the procedures from the date reflected
- Max Control Process Date – At least one control for charges has been posted/closed from the date reflected
- ERA not Processed – Dollar amount of total ERAs that have not been marked as processed
- DOS Debit Charges –
- Open Charges – Charges that are posted in an open control
- Open Payments – Payments that are posted in an open control.
Daily Operations Summary – Previous Month
- ERA not Processed – Dollar amount of total ERAs that have not been marked as processed
- ERA not Processed Count – Number of ERAs that have not been marked as processed
- DOS Debit Charges –
- Open Charges – Charges that posted in an open control
- Open Payments – Payments that are posted in an open control
Daily Operations Summary – Year through Prior Month
- ERA Not Processed – Dollar amount of total ERAs that have not been marked as processed
- ERA Not Processed Count – Number of ERAs that have not been marked as processed
- DOS Debit Charges –
- Open Charges – Charges that are posted in an open control
- Open Payments – Payments that are posted in an open control
Daily Operations Summary – Prior vs Current Month
- Clinic Name – The clinic names for the client
- Current Month Charges – The total charges that have been posted to a closed control MTD
- Previous Month Charges – The total charges that have been posted to a closed control for the previously EOM Control Period
- Percentage of Last Month – Percentage of current months charges to previous month charges that have been posted to a closed control
- Open Charges – Charges that are posted in an open control
- Max Service Date – At least one charge has been posted for services from the date reflected
- Max Surgery Date – At least one charge has been posted for surgeries from the date reflected
MedEvolve Inbound Queue
- Date Received – Date the charge was received via interface from EMR to Inbound Queue for processing.
- Count – Number of transactions
- Age – How old the transactions are from DOS
- Insurance Provider – Provider who provided the service and should be on the claim
- Primary Insurance Category – Primary Insurance Category associated with claim
- CPT Category – CPT Category for the charges on the claim
MedEvolve Payment Lag Analysis
- Primary Insurance Category – The primary insurance category associated with the payment.
- Payer Response YN –
- Denial YN – Filter options for payments for denials vs not denied
- Finical Location – The Financial Location in which the payment is associated with
- Service Location – The Service Location in which the payment is associated with
MedEvolve PM User Productivity
Overview
- PT User – The user name for the representative in the PM.
- Total Worked Per Day – The total number of transactions worked for the day
- Count of Day Worked –
- Total Count – The total count of transactions worked
- Total Count Manual – The total count of transactions that were entered in manually to the PM
- Total Count Electronic – The total count of transactions that were entered via an interface to the inbound queue in the PM
- Charge Count – The total count of charges that were entered
- Charge Count Manual – The total count of charges that were entered in manually to the PM
- Charge Count Electronic – The total count of charges that were entered in via an interface to the inbound queue in the PM
- Payment Count – The total count of payments that were entered
- Payment Count Manual – The total count of payments that were entered in manually to the PM
- Payment Count Electronic – The total count of payments that were entered in via an interface to the inbound queue in the PM
- Adjustment Count – The total adjustments that were entered
- Adjustment Count Manual – The total adjustments that were entered in manually to the PM
- Adjustment Count Electronic – The total adjustments that were entered in via an interface to the inbound queue in the PM
Overview by User
- PT User – The user name for the representative in the PM
Weekly View
- Hours Worked – The hour during the day in which transactions were entered into the PM
- PT User – The user name for the representative in the PM
- Week Worked – The Week Ending date for the transactions that were posted and worked.
MedEvolve Workflow AR Snapshot
AR Snapshot
- Clinic Name – The clinic names for the client.
- No Actions – No Actions – Aging from last time the claims was touched in the Workflow Tool
- 000-030 days – 000-030 days - Aging from last time the claims was touched in the Workflow Tool
- 031-060 days – 031-060 days - Aging from last time the claims was touched in the Workflow Tool
- 061-090 days – 061-090 days - Aging from last time the claims was touched in the Workflow Tool
- 091-120 days – 091-120 days - Aging from last time the claims was touched in the Workflow Tool
- 121-150 days – 121-150 days - Aging from last time the claims was touched in the Workflow Tool
- 151-180 days – 151-180 days - Aging from last time the claims was touched in the Workflow Tool
- 181-365 days – 181-365 days - Aging from last time the claims was touched in the Workflow Tool
- Visits - Total Number of Visits
- AR Balance – Total AR Balance of Visits
- Opportunity – Total Cash Opportunity of Visits
- Charges – Total Charges of Visits
- Insurance Payments – Total Insurance Payments of Visits
- Private Payments – Total Private Payments of Visits
- Adjustments – Total Adjustments of Visits
- Last Claim Activity – Last Claim Activity chosen in WF by representative on claim worked
- Last Claim Status – Last Claim Status chosen in WF by representative on claim worked
- Last Claim Action – Last Claim Action chosen in WF by representative on claim worked
- Clinic Name – The clinic names for the client
- Visit Entry Age Bucket – The age of the account from date of service
- Ins Payment_YN – Filter for if the claim has received an insurance payment or not
- Denial_YN – Filter for if the claim has received a denial or not
- AR Balance – Filter to set AR Balance thresholds
- Remaining GCR – Filter to set GCR thresholds
- Unique User Actions – Filter to set number unique user action (i.e. how many times a representative has worked an account)
AR Snapshot by Last Action User
- Last Claim Action Representative –
- No Actions – No Actions – Aging from last time the claims was touched in the Workflow Tool
- 000-030 days – 000-030 days - Aging from last time the claims was touched in the Workflow Tool
- 031-060 days – 031-060 days - Aging from last time the claims was touched in the Workflow Tool
- 061-090 days – 061-090 days - Aging from last time the claims was touched in the Workflow Tool
- 091-120 days – 091-120 days - Aging from last time the claims was touched in the Workflow Tool
- 121-150 days – 121-150 days - Aging from last time the claims was touched in the Workflow Tool
- 151-180 days – 151-180 days - Aging from last time the claims was touched in the Workflow Tool
- 181-365 days – 181-365 days - Aging from last time the claims was touched in the Workflow Tool
- Visits - Total Number of Visits
- AR Balance – Total AR Balance of Visits
- Opportunity – Total Cash Opportunity of Visits
- Charges – Total Charges of Visits
- Insurance Payments – Total Insurance Payments of Visits
- Private Payments – Total Private Payments of Visits
- Adjustments – Total Adjustments of Visits
- Last Claim Activity – Last Claim Activity chosen in WF by representative on claim worked
- Last Claim Status – Last Claim Status chosen in WF by representative on claim worked
- Last Claim Action – Last Claim Action chosen in WF by representative on claim worked
- Clinic Name – The clinic names for the client
- Visit Entry Age Bucket – The age of the account from date of service
- Ins Payment_YN – Filter for if the claim has received an insurance payment or not
- Denial_YN – Filter for if the claim has received a denial or not
- AR Balance – Filter to set AR Balance thresholds
- Remaining GCR – Filter to set GCR thresholds
- Unique User Actions – Filter to set number unique user action (i.e. how many times a representative has worked an account)
AR Snapshot by Payer Category
- Clinic Name – The clinic names for the client.
- No Actions – Aging from last time the claims was touched in the Workflow Tool
- 000-030 days – Aging from last time the claims was touched in the Workflow Tool
- 031-060 days – Aging from last time the claims was touched in the Workflow Tool
- 061-090 days – Aging from last time the claims was touched in the Workflow Tool
- 091-120 days – Aging from last time the claims was touched in the Workflow Tool
- 121-150 days – Aging from last time the claims was touched in the Workflow Tool
- 151-180 days – Aging from last time the claims was touched in the Workflow Tool
- 181-365 days – Aging from last time the claims was touched in the Workflow Tool
- Visits - Total Number of Visits
- AR Balance – Total AR Balance of Visits
- Opportunity – Total Cash Opportunity of Visits
- Charges – Total Charges of Visits
- Insurance Payments – Total Insurance Payments of Visits
- Private Payments – Total Private Payments of Visits
- Adjustments – Total Adjustments of Visits
- Last Claim Activity – Last Claim Activity chosen in WF by representative on claim worked
- Last Claim Status – Last Claim Status chosen in WF by representative on claim worked
- Last Claim Action – Last Claim Action chosen in WF by representative on claim worked
- Clinic Name – The clinic names for the client
- Visit Entry Age Bucket – The age of the account from date of service
- Ins Payment_YN – Filter for if the claim has received an insurance payment or not
- Denial_YN – Filter for if the claim has received a denial or not
- AR Balance – Filter to set AR Balance thresholds
- Remaining GCR – Filter to set GCR thresholds
- Unique User Actions – Filter to set number unique user action (i.e. how many times a representative has worked an account)
AR Snapshot by Denials
- Denial Category –
- No Actions – Aging from last time the claims was touched in the Workflow Tool
- 000-030 days – Aging from last time the claims was touched in the Workflow Tool
- 031-060 days – Aging from last time the claims was touched in the Workflow Tool
- 061-090 days – Aging from last time the claims was touched in the Workflow Tool
- 091-120 days – Aging from last time the claims was touched in the Workflow Tool
- 121-150 days – Aging from last time the claims was touched in the Workflow Tool
- 151-180 days – Aging from last time the claims was touched in the Workflow Tool
- 181-365 days – Aging from last time the claims was touched in the Workflow Tool
- Visits - Total Number of Visits
- AR Balance – Total AR Balance of Visits
- Opportunity – Total Cash Opportunity of Visits
- Charges – Total Charges of Visits
- Insurance Payments – Total Insurance Payments of Visits
- Private Payments – Total Private Payments of Visits
- Adjustments – Total Adjustments of Visits
- Last Claim Activity – Last Claim Activity chosen in WF by representative on claim worked
- Last Claim Status – Last Claim Status chosen in WF by representative on claim worked
- Last Claim Action – Last Claim Action chosen in WF by representative on claim worked
- Clinic Name – The clinic names for the client
- Visit Entry Age Bucket – The age of the account from date of service
- Ins Payment_YN – Filter for if the claim has received an insurance payment or not
- Denial_YN – Filter for if the claim has received a denial or not
- AR Balance – Filter to set AR Balance thresholds
- Remaining GCR – Filter to set GCR thresholds
- Unique User Actions – Filter to set number unique user action (i.e. how many times a representative has worked an account)
Filters AR Snapshot by Denials
- CPT Code – Specific CPT Codes
- CPT Group – CPT Group for which specific CPT codes Roll Up
- Current Worklist – Worklist Name in which the claim is currently assigned
- File Date Bucket – Aging of claim from the File Date
- Financial Location – Financial Location Name
- Insurance Category – Insurance Category in which specific Insurance Plans Roll Up
- Insurance Name – Insurance Plan Name
- Insurance Provider – Insurance Provider Name
- Last Claim Action Date Bucket – Ability to ONLY show you “no actions” Filter
- Opportunity – Cash Opportunity
- Service Location – Service Location Name
- Service Provider – Service Provider Name
- Worklist Category – Worklist Category i.e. denied, regular, system
MedEvolve Workflow Production
Weekly Employee Quick Summary
- Representative – Representative working accounts.
- Assigned Claims – Number of claims that qualify for worklists assigned to a representative
- Assigned AR Balance – Balance of claims that are assigned to a representative
- Worked Claims – Claims that have been worked by the representative
- Worked Claims % - The percent of claims worked by the representative
- Worked Claims Per Day – The average claims worked per day by the representative
- Unworked Claim Weeks – The number of weeks it would take the representative to get through accounts assigned to them based upon their 8 wk average.
- Avg Actions Per Claim – The average number of actions that a representative has taken on claims worked
- Avg Follow UP Days – The average days that the representative is pushing claims out for follow up
- Avg Claim Age – The average age of the claims from DOS
- Clinic Name – The name of the clinic
- Week End Date – Filter for Week Ending date for the work week
- Team, Representative – Filter for a team or representative
- Worklist Category – Filter for the worklist category (i.e. denial, regular, system)
- Claim Status – Filter for the Claim Status that was chosen by the representative when working a claim
- Current Worklist – Filter for the Current worklist in which the claim is qualifying for
Action Effectiveness
- Representative – Representative working accounts
- Claims Worked – Number of claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative
- Avg Follow Up Days – The average days that the representative is pushing claims out for follow up
- Avg Action Per Claim – The average number of actions that a representative has taken on claims worked
- Orig Claim Balance – The Original Claim Balance on the claims that have been worked by the representative
- Change in AR – The Change in AR on the claims that have been worked by the representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on the claims that have been worked by the representative
- Con Adj – The Contractual Adjustments posted on the claims that have been worked by the representative
- Other Adj – The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – The name of the clinic
- Week End Date – Filter for Week Ending date for the work week
- Team, Representative – Filter for a team or representative
- Worklist Category – Filter for the worklist category (i.e. denial, regular, system)
- Claim Status – Filter for the Claim Status that was chosen by the representative when working a claim
- Current Worklist – Filter for the Current worklist in which the claim is qualifying for
Action Effectiveness by Action Type
- Claim Action – The Claim Action that the representative has chosen when the representative worked the claim
- Claims Worked – Number of claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative
- Avg Follow Up Days – The average days that the representative is pushing claims out for follow up
- Avg Actions Per Claim – The average number of actions that a representative has taken on claims worked
- Orig Claim Balance – The Orignial Claim Balance on the claims that have been worked by the representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on the claims that have been worked by the representative
- Other Adj – The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – The name of the clinic
- Week End Date – Filter for Week Ending date for the work week
- Team, Representative – Filter for a team or representative
- Worklist Category – Filter for the worklist category (i.e. denial, regular, system)
- Claim Status – Filter for the Claim Status that was chosen by the representative when working a claim
- Current Worklist – Filter for the Current worklist in which the claim is qualifying for
Action Effectiveness by Status
- Claim Status – The Claim Status that the representative has chosen when the representative worked the claim
- Claims Worked – Number of Claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative
- Avg Follow Up Days – The average days that representative is pushing claims out for follow up
- Avg Actions Per Claim – The average number of actions that a representative has taken on claims worked
- Orig Claim Balance – The Original Claim Balance on the claims that have been worked by the representative
- Change in AR – The Change in AR on the claims that have been worked by the representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on the claims that have been worked by the representative
- Con Adj – The Contractual Adjustments posted on the claims that have been worked by the representative
- Other Adj - The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – The name of the clinic
- Week End Date – Filter for Week Ending date for the work week
- Team, Representative – Filter for a team or representative
- Worklist Category – Filter for the worklist category (i.e. denial, regular, system)
- Claim Status – Filter for the Claim Status that was chosen by the representative when working a claim
- Current Worklist – Filter for the Current worklist in which the claim is qualifying for
Action Effectiveness by Worklist
- Representative – The representative that worked the claim
- Claims Worked – Number of claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative.
- Avg Follow Up Days – The average days that representative is pushing claims out for follow up
- Avg Actions Per Claim – The average number of actions that a representative has taken on claims worked
- Orig Claim Balance – The Original Claim Balance on the claims that have been worked by the representative
- Change in AR – The Change in AR on the claims that have been worked by the representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on the claims that have been worked by the representative
- Con Adj – The Contractual Adjustments posted on the claims that have been worked by the representative
- Other Adj - The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – The name of the clinic
- Week End Date – Filter for Week Ending date for the work week
- Team, Representative – Filter for a team or representative
- Worklist Category – Filter for the worklist category (i.e. denial, regular, system)
- Claim Status – Filter for the Claim Status that was chosen by the representative when working a claim
- Current Worklist – Filter for the Current worklist in which the claim is qualifying for
Weekly Productivity Trending
- Representative – The representative that worked the claim
- Worked Claims – Number of claims that have been worked by a representative
- Worked Claims Per Day – Number of claims that have been worked per day by the representative
- Action Count – Number of Actions taken on the claim that have been worked by representative
- Change in AR – The Change in AR on the claims that have been worked by the representative
- Avg Follow Up Days – The average days that the representative is pushing claims out for follow up
- Clinic Name – The name of the clinic
- Week End Date – Filter for Week Ending date for the work week
- Team, Representative – Filter for a team or representative
- Worklist Category – Filter for the worklist category (i.e. denial, regular, system)
- Claim Status – Filter for the Claim Status that was chosen by the representative when working a claim
- Current Worklist – Filter for the Current worklist in which the claim is qualifying for
Daily User Productivity
- Representative – The representative that worked the claim
- Clinic Name – The name of the clinic
- Week End Date – Filter for Week Ending date for the work week
- Team, Representative – Filter for a team or representative
- Worklist Category – Filter for the worklist category (i.e. denial, regular, system)
- Claim Status – Filter for the Claim Status that was chosen by the representative when working a claim
- Current Worklist – Filter for the Current worklist in which the claim is qualifying for
MedEvolve Workflow User Tasks
Tasks Overview
- Completed Tasks – Tasks that have been marked as completed in workflow.
- In Progress Tasks – Tasks that are still in progress in workflow
- Cancelled Tasks – Tasks that have been marked as canceled in workflow
- Clinic Name – The Clinic Name
- 000-007 days – Aging from date of creation of Tasks in workflow 000-007 days
- 008-014 days – Aging from date of creation of Tasks in workflow 008-014 days
- 015-021 days – Aging from date of creation of Tasks in workflow 015-021 days
- 022-030 days – Aging from date of creation of Tasks in workflow 022-030 days
- 031-060 days – Aging from date of creation of Tasks in workflow 031-060 days
- 061-090 days – Aging from date of creation of Tasks in workflow 061-090 days
- 091-180 days – Aging from date of creation of Tasks in workflow 091-181 days
- 181-365 days – Aging from date of creation of Tasks in workflow 181-365 days
- Clinic Name – Filter for the Clinic Name
- Task Status – Filter for the Task Status (i.e. Cancelled, Complete, open)
- Task Department – Filter for the Task Department (i.e. the department who works the task)
- Task Category – Filter for the Task Category
Task Overview
- Clinic Name – The Clinic Name
- Task Category – The Category of the Tasks
- Task Department – The Department that the Task is assigned to
- Clinic Name – Filter for the Clinic Name
- Task Status – Filter for the Task Status (i.e. Cancelled, Complete, open)
- Task Department – Filter for the Task Department (i.e. the department who works the task)
- Task Category – Filter for the Task Category
Task Completion Trending
- Clinic Name – The Clinic Name
- Task Category – The Category of the Tasks
- Task Department – The Department that the Task is assigned to
- Clinic Name – Filter for the Clinic Name
- Task Status – Filter for the Task Status (i.e. Cancelled, Complete, open)
- Task Department – Filter for the Task Department (i.e. the department who works the task)
- Task Category – Filter for the Task Category
Tasks by User
- Assigned To – The representative that the Task is assigned to in workflow
- Created by – The representative that created the Task in workflow
- Closed by – The representative that closed the Task in workflow
- Clinic Name – Filter for the Clinic Name
- Task Status – Filter for the Task Status (i.e. Cancelled, Complete, Open)
- Task Department – Filter for the Task Department (i.e. the department who works the task)
- Task Category – Filter for the Task Category
MedEvolve Workflow Overpayments Production
Weekly Productivity Trending
- Action User – The user in workflow who took action on the claim.
- Visit Count – The number of claims that the representative worked
- Action Count – The number of actions that the representative took on claims
- Insurance Payments After Action – Insurance Payments received after action that the representative took on the claim
- Change in AR After Action – Change in AR after action that the representative took on the claim
- Clinic Name – Filter for the Clinic Name
- Week End Date – Filter for the Week Ending date
- Team, Action User – Filter for the team and representative
- Claims Status – Filter for the Claim Status that the representative chosen in workflow
- Current Worklist – Filter for the Current Worklist the claim qualifies for
Action Effectiveness
- Action User – Representative working accounts
- Visit Count – Number of claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on the claims that have been worked by the representative
- Con Adj – The Contractual Adjustments posted on the claims that have been worked by the representative
- Other Adj – The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – Filter for the Clinic Name
- Week End Date – Filter for the Week Ending date
- Team, Action User – Filter for the team and representative
- Claim Status – Filter for the Claim Status that the representative chosen in workflow
- Current Worklist – Filter for the Current Worklist the claim qualifies for
Action Effectiveness by Action Type
- Claim Action – The Action that the representative chose when working the account.
- Visit Count – Number of claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative
- AR Balance – The AR Balance on the claims worked by the representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on claims that have been worked by the representative
- Con Adj – The Contractual Adjustments posted on the claims that have been worked by the representative
- Other Adj – The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – Filter for the Clinic Name
- Week End Date – Filter for the Week Ending date
- Team, Action User – Filter for the team and representative
- Claim Status – Filter for the Claim Status that the representative chosen in workflow
- Current Worklist – Filter for the Current Worklist the claim qualifies for
Action Effectiveness by Status
- Claim Status – The Status that the representative chose when working the account.
- Visit Count – Number of claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative
- AR Balance – The AR Balance on the claims worked by the representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on claims that have been worked by the representative
- Con Adj – The Contractual Adjustments posted on the claims that have been worked by the representative
- Other Adj – The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – Filter for the Clinic Name
- Week End Date – Filter for the Week Ending date
- Team, Action User – Filter for the team and representative
- Claim Status – Filter for the Claim Status that the representative chosen in workflow
- Current Worklist – Filter for the Current Worklist the claim qualifies for
Action Effectiveness by Worklist
- Action User – The representative that worked the claim.
- Visit Count – Number of claims that have been worked by a representative
- Action Count – Number of Actions taken on the claim that have been worked by a representative
- AR Balance – The AR Balance on the claims worked by the representative
- Ins Pay – The Insurance Payments received on the claims that have been worked by the representative
- Pri Pay – The Private Payments received on claims that have been worked by the representative
- Con Adj – The Contractual Adjustments posted on the claims that have been worked by the representative
- Other Adj – The Other Adjustments posted on the claims that have been worked by the representative
- Clinic Name – Filter for the Clinic Name
- Week End Date – Filter for the Week Ending date
- Team, Action User – Filter for the team and representative
- Claim Status – Filter for the Claim Status that the representative chosen in workflow
- Current Worklist – Filter for the Current Worklist the claim qualifies for
Daily User Productivity
- Action User – The representative that worked the claim
- Claim Action – The Claim Action that the representative choose when working a claim
- Clinic Name – Filter for the Clinic Name
- Week End Date – Filter for the Week Ending date
- Team, Action User – Filter for the team and representative
- Claim Status – Filter for the Claim Status that the representative chosen in workflow
- Current Worklist – Filter for the Current Worklist the claim qualifies for
Insurance Overpayments
- Action User – The representative that worked the claim
- Action Count – The number of actions that the representative took on claims
- AR Balance – The AR Balance on the claims worked by the representative
- Claim Activity – The Claim Activity that the representative choose when working a claim
- Claim Status – The Claim Status that the representative choose when working a claim
- Claim Action – The Claim Action that the representative choose when working a claim
- Action – The number of times that an action was taken on a claim
- Visits – The number of claims that the representative worked
- AR Balance – The AR Balance on the claims worked by the representative