Advanced Reporting - Revenue Insights

The Revenue Insights dashboard provides a detailed breakdown and analysis of revenue-related data, including information on sources of revenue, billing trends, payment patterns, outstanding balances, and other key financial metrics that provide a comprehensive view of the revenue generated within a specific timeframe or across different categories.     

RXNT’s Advanced Reporting feature is exclusively accessible to users with an advanced reporting license! Learn more about Advanced Reporting licenses here! 

Access Revenue Insights

In the Billing product, click Reports, then select All.

Click Revenue Insights under the Advanced Reporting section. 

Understanding the dashboard

The Revenue Insights dashboard is organized into eight (8) different tabs that allow you to view information in a variety of ways. Charges can be viewed based on different encounter criteria, such as Initial Billed Date, Service Date, Batch Date, or Encounter Created Date, while payments can be viewed based on Payment Date or Posted Date. Choosing the right tab allows you to focus on the specific information that best supports your billing, reconciliation, or reporting needs.

Initial Billed & Posted Date

When to use: When comparing the date a claim was first billed to the date a payment or adjustment was posted.
Why: Helps track payer turnaround time and evaluate how quickly claims move from submission to resolution.

Initial Billed & Payment Date

When to use: When analyzing payments based on the original billing date and the date payment was received.
Why: Useful for understanding payer payment cycles and monitoring cash flow tied specifically to first-time submissions.

Service & Posted Date

When to use: When reviewing the date services were performed alongside the date payments or adjustments were posted.
Why: Ideal for verifying that all services within a timeframe have been fully processed and posted to accounts.

Service & Payment Date

When to use: When evaluating payments in relation to the actual date of service.
Why: Helps determine payment timelines after services are rendered and supports provider productivity and financial reporting.

Batch & Posted Date

When to use: When reconciling claims submitted in batches and checking when corresponding postings occurred.
Why: Useful for billing teams that work with daily or weekly batch submissions and need to confirm status and accuracy of related postings.

Batch & Payment Date

When to use: When tracking payments received for claims that were included in a specific batch.
Why: Helps identify trends in batch performance and detect any delays or issues tied to specific submission batches.

Encounter & Posted Date

When to use: When analyzing encounters based on their creation date and the timing of payment or adjustment postings.
Why: Helpful for identifying workflow delays, such as late charge entry or inconsistent posting practices.

Encounter & Payment Date

When to use: When reviewing payments relative to the encounter creation date and the date payment was received.
Why: Supports full revenue cycle analysis, from encounter creation to final payment, and helps pinpoint bottlenecks in documentation, billing, or submission processes.

By default, the selected timeframe is set to the last 6 months, but you can change it to options such as this month, previous month, this year, previous year, or enter a custom range to focus on a specific period. For example, you might choose This Month to review current billing activity, Previous Month to finalize month-end reporting, This Year to analyze year-to-date performance, or Previous Year to compare trends from the prior year. A Custom Range is useful when you need to view activity from a specific timeframe, such as reviewing claims submitted during your busiest season or analyzing data from a particular project or audit period.

By default, the dashboard displays information for the entire practice, but you can narrow results using filters such as Rendering Provider, Place of Service, Billing Provider, Scheduling Provider, Financial Class Name, Payer, Referring Provider, or Billing Event Types, and you can combine multiple filters for more targeted analysis. 

For example, you might filter by Rendering Provider to evaluate individual productivity, by Place of Service to focus on a specific location, or by Billing Provider to review billing trends for a particular clinician. You can also filter by Financial Class Name to compare self-pay versus insurance, by Payer to track activity with a specific insurance company, or by Billing Event Types, including billed charges, insurance payments, patient payments, unapplied payments, or unbilled charges, to focus on specific financial activity. Combining filters, such as Payer and Rendering Provider, allows you to drill down further and identify key trends or potential issues. Click here to learn more about filtering Advanced Reports. 

Charges vs. payments

The Charges vs. Payments line chart displays total charges and payments side by side for the selected timeframe, while the Total Charges and Total Payments boxes below show the overall sums. For example, if you select “This Month,” the chart will compare all charges and payments processed during that month, and the totals will reflect the combined amounts for that period.

You can customize the Charges vs. Payments chart by choosing to display only Charge Amounts or Payment Amounts. Simply deselect the checkbox for the data you want to hide, allowing you to focus on the information most relevant to your needs. For example, if you want to analyze only payments received, you can hide the charges to simplify the view.

The Charges vs. Payments Details list provides a detailed view of each transaction, including the patient encounter ID, patient’s full name, chart number (if applicable), charge amount, payment amount, service date, procedure code, initial billed date, and posted date. This breakdown helps you track and reconcile charges and payments at a granular level.

The Monthly Charges and Monthly Payments boxes compare your practice’s financial performance over the most recent two months within the selected timeframe. This allows you to quickly see if payments received last month increased or decreased compared to the previous month, helping you track trends and cash flow.

The dashboard also displays Total Encounters, Net Collection Rate, and Gross Collection Rate for the selected timeframe. Reviewing these metrics can help you understand overall patient volume and how efficiently your practice is collecting payments relative to billed charges.

Payer mix

You can view payer mix by charge amount or payment amount using the dropdown menu.

  • The Charge Amount graph shows each payer’s total charges and their percentage of all charges. For example, if Payer A accounts for $50,000 of $200,000 in total charges, it represents 25% of charges. This is useful for understanding which payers drive the most billed revenue and planning strategies accordingly.
  • The Payment Amount graph shows each payer’s total payments and their percentage of all payments. For example, if Payer B accounts for $40,000 of $180,000 in total payments, it represents about 22% of payments. This helps identify which payers are contributing most to collected revenue and highlights payment patterns or delays. 

Both graphs are interactive. Selecting a specific payer filters the entire dashboard to focus on that payer’s data, making analysis more targeted and actionable.

CPT codes and CPT codes by units

The CPT Codes graph by Number of Records displays the top 25 CPT codes billed in the selected timeframe, showing how frequently each code appears at the line-item level. This helps users quickly identify the most commonly performed services. Seeing which CPT codes are billed most often allows practices to understand service volume, assess workload distribution, and focus analysis on high-impact procedures. By clicking on a specific CPT code in the graph, users can filter the entire dashboard to view only data related to that service, making it easier to evaluate associated charges, payments, adjustments, and trends and to identify opportunities for operational or revenue improvement.

The CPT Codes graph by Units displays the CPT codes billed during the selected timeframe and the total number of units billed for each code at the line-item level. For instance, if code 93000 shows 300 units, it indicates that this procedure was performed 300 times in total, providing insight into service volume. This is useful because it helps practices track high-volume procedures, plan staffing and resources, identify trends in service utilization, and prioritize financial or operational analysis on the codes that have the biggest impact on revenue and workflow.

Charges, payments, adjustments & units by CPT code

This graph shows the top 25 CPT codes within the selected timeframe, along with their total charges, payments, adjustments, and units. It provides a comprehensive view of how each CPT code contributes to overall billing and revenue performance. By clicking on any bar in the graph, users can filter the entire dashboard to focus on a specific CPT code, allowing for deeper analysis of related trends and metrics across all reports. Additionally, the dropdown menu lets users switch between charges, payments, adjustments, or units, making it easy to evaluate different financial and volume perspectives and identify patterns, discrepancies, or opportunities for optimization.

Average charges & payments by CPT code

The Average Charges by CPT Code graph shows the top 25 CPT codes based on their average charge amounts during the selected timeframe. This allows users to compare how charges vary across services, identify inconsistencies or outliers in billing, and recognize trends in charge levels, supporting more informed decisions around pricing strategies, coding practices, and revenue optimization.

The Average Payment by CPT Code graph shows the top 25 CPT codes based on their average payment amounts during the selected timeframe. This allows users to quickly see which services generate higher or lower payments on average, helping identify revenue-driving procedures, spot underperforming codes, and support decisions related to pricing, contract negotiations, and service mix.

Patients with payment plans

This table lists all patients with an active payment plan, showing details such as payment dates and amounts. This allows staff to quickly track upcoming payments, monitor expected revenue, and ensure that no scheduled payments are missed, since all payment information is clearly organized in one place.

Hear from an expert: Click here to learn more about Making Data-Driven Decisions and How Dynamic Reporting Insights Can Transform Practice Efficiency.

Was this article helpful?
2 out of 3 found this helpful