About
This article will go over a comparison of the new Practice Analytics reports with the Billing Reports, including changes, key elements, and updates.
Comparison Table
|
Tip: Java must be enabled in order to use the search and sort capability. To quickly find the form you want in this table:
|
|
Report Name
|
Purpose of Report
|
New Reports Logic
|
Previous Reports Logic
|
| Charges Per Scheduled Appointment
|
Use this report to view charges associated with historical appointments scheduled for a specific time. You can see total charges based on all patients with the same appointment type and drill down into the specific charges for each patient.
|
Exclude CPT Codes 1-4
Patients: Only shows patients with charges. To view patients with appointments who have NO charges use the Unbilled Charges for Scheduled Visit report |
Shows CPT Codes 1-4 (Payments, copays)
Patients: Also shows patients with NO charges. |
| Scheduled Appointments
|
Use this report to view future appointments scheduled for a specified of time. | Excludes non-patient notes | Show's non-patient notes |
| Reimbursements per Scheduled Visit |
Use this report to view the reimbursement values per scheduled visit, by Appointment Type |
Visit Type: Driven by what is listed on the appointment and will show all CPT codes for that visit Average Charges: Based on all CPT Codes under that visit type Average Collected: Based on all CPT Codes under that visit type |
Visit Type: Driven by the highest numbered CPT code only Average Charges: Based on that single CPT code Average Collected: Based on that single CPT code |
| Unbilled Charges for Scheduled Appts
|
Use this report daily or weekly to view scheduled appointments for patients that do not have an associated superbill or billed charges for appointments scheduled for the practice. | CPT Codes 1-4: Include patients with no true charges today but have CPT codes of 1-4 | CPT Codes 1-4: If a patient had an appointment today, charges were not entered but payments, adjustments, etc. were made on a previous claim with today's date, the report didn't recognize that these weren't charges as we use CPT codes 1-4 to capture these. Therefore these patients are being excluded from the report. |
| Accounting Transfers
|
Use this report to view credits debited from patient credit accounts for a specified period. | Patient Count: Distinct count of patients
|
Patient Count: includes duplicate records
|
| Patient Credit Account | Use this report to view credits that were credited and debited from patient credit accounts for a specified period. | Posted Date: Anything with a posted date of today will not show on report
Patient Count: Distinct count of patients |
Posted Date: Anything with a posted date of today will show on report. Will need to exclude those from the OP report when comparing as there is a 1 day delay in Sigma
Patient Count: includes duplicate records |
| Practice Level Adjustments
|
Use this report to view Practice Level Insurance Adjustments (PLAs) for a specified period. For example, when users process Electronic Remittances, and there is an Insurance Adjustment (ex: take back or interest payment) OP will create a PLA adjustment transaction to balance the electronic remittance. | Date of Service & Posted Date: Pulls only daysheeted items and sigma is 1 day behind
|
Date of Service & Posted Date: Pulls only daysheeted items
|
| Receipts for Deposit
|
Use this report to view payments and credits collected for a specified period that can be used to match your deposits to your bank. | *NEW* Posted Date filter: This will show the transactions for the posted date selected AS LONG AS they were daysheeted
|
|
| Total Receipts
|
Use this report to view payments and credits collected for a specified date range. | Patient Count: Distinct count of patients
|
Patient Count: Includes duplicate patient records
|
| Transaction Analysis
|
Use this report to view your charges, payments, or adjustments for a day, a week, a month, or any time frame that you wish to isolate your data. | No changes. | No changes. |
| Transactions for Check Number
|
Use this report to review a posted EOB/ERA and balance funds posted, especially when there are complex elements such as recoups or take-backs. | Posted Date: Patient Credits will show the correct posted date | Posted Date: Patient Credits were showing posted date as payment date
|
| Compare Allowable to Payment
|
Use this report to view your reimbursement values from your payers vs what your contracted allowable rates are. Users can easily see in the column Allowable Difference if they are seeing a trend of less or more for reimbursements. | NOT Daysheet Dependent: End of Day snap shot | Daysheet Dependent: Only shows daysheeted transactions |
| Daysheet Log
|
Use the Daysheet Log to view pertinent financial totals from each daysheet processed. | No changes. | No changes. |
| Financial Summary
|
Use this report to view a summary of charges and payments collected for a specified time frame of transactions. | Patient Count: Distinct count of patients | Patient Count: includes duplicate records |
| Reimbursement Analysis | Use this report to view a summary of billing data, determining the average reimbursement of CPT codes. Commonly used for Payment history by CPT, Insurance payment monitoring, and Payment history by provider. | Patient Count: Distinct count of patients | Patient Count: includes duplicate records |
| Void Transactions Only
|
Use this report to view a summary of billing data, determining the average reimbursement of CPT codes. Commonly used for Payment history by CPT, Insurance payment monitoring, and Payment history by provider. | Search Fields: Removed options for DOS and Posting Date.
Posted Date: Anything with a posted date that hasn't been daysheeted will not show on report. |
Search Fields: Has search fields for DOS and Posting Date but you can't void something unless it's been daysheeted. The data will only show daysheeted items with a DOS of X date. The search results are the same as searching by daysheet date, then filtering the DOS by X date.
Posted Date: Anything with a posted date that hasn't been daysheeted yet will show on report. Will need to exclude those from the OP report when comparing as there is a 1 day delay in Sigma. |
| A/R Aging Analysis - Insurance Payer - Insurance A/R
|
Use this report to displays all outstanding insurance balances due from the payer. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight.
The Patient Details will be a day behind. |
Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for.
The Patient Details are real-time/independent of when you daysheeted. Today you can see the details don't always add up to the summary total because transactions have occurred after daysheeting. |
| A/R Aging Analysis - Insurance Payer - Patient A/R
|
Use this report to display displays the practice's Patient Accounts Receivable by Insurance Payer. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight.
The Patient Details will be a day behind. |
Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for.
The Patient Details are real-time/independent of when you daysheeted. Today you can see the details don't always add up to the summary total because transactions have occurred after daysheeting. |
| A/R Aging Analysis - Insurance Payer - Secondary Responsibility Date A/R
|
Use this report to displays all outstanding A/R is for when the Secondary Insurance Payer became responsible for a balance due.
See patient A/R balances for when a secondary payer became responsible for balances rather than just view the age of the claim. |
Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight.
The Patient Details will be a day behind. |
Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for.
The Patient Details are real-time/independent of when you daysheeted. Today you can see the details don't always add up to the summary total because transactions have occurred after daysheeting. |
| A/R Aging Analysis - Insurance Payer - Total A/R
|
Use this report to displays all outstanding Accounts Receivable by aging bucket and by Insurance and Patient Totals/Insurance Balances. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight. | Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for. |
| A/R Aging Analysis - Insurance Payer - Patient Responsibility Date A/R
|
Use this report to displays Accounts Receivable for dates when a patient became responsible for a balance. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight.
The Patient Details will be a day behind. |
Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for.
The Patient Details are real-time/independent of when you daysheeted. Today you can see the details don't always add up to the summary total because transactions have occurred after daysheeting. |
| A/R Aging Analysis - Location - Patient A/R
|
Use this report to displays all outstanding balances due from the patient, by Location. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight.
|
Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for. |
| A/R Aging Analysis - Location - Insurance A/R
|
Use this report to displays all outstanding Insurance Accounts Receivable by Location. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight. | Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for. |
| A/R Aging Analysis - Location - Total A/R
|
Use this report to displays all outstanding Accounts Receivable (Insurance and Patient) by Location and breaks the balances up by different aging buckets. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight. | Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for. |
| A/R Aging Analysis - Rendering Provider - Insurance A/R
|
Use this report to display Insurance Accounts Receivable by Rendering Provider. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight. | Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for. |
| A/R Aging Analysis - Rendering Provider - Patient A/R
|
Use this report to display Patient Accounts Receivable by Rendering Provider. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight. | Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for. |
| A/R Aging Analysis - Rendering Provider - Total A/R
|
Use this report to display all outstanding Accounts Receivable (Insurance and Patient) by Rendering Provider. | Daily Snap Shots: True end of day snapshot that occurs after hours. Therefore the Summary Totals no longer depend on daysheet date and are more real-time. Payments or charges entered after daysheeting will be accounted for because we take a snapshot overnight. | Summary Totals are based on the last daysheet date. Any transactions that occur after daysheeted are not accounted for. |
If you have an idea for new reports or dashboards, please post them on our ideas portal!
