Advanced Reporting - Cash Basis Aging Report

The Cash-Basis Aging dashboard displays an accurate representation of cash flow in your practice, helping you manage the revenue cycle. All charges, payments, adjustments, and write-offs for the timeframe selected are reflected in this report, including overpayments and patient fund debits and credits. The payments in this report reconcile to banking transactions using real-world events that reflect the debits and credits found on a banking statement. 

RXNT's Advanced Reporting feature is exclusively accessible to users with an Advanced Reporting license!

Viewing the dashboard

Click Reports.

Select All

Click Cash Basis Aging Report under the Advanced Reporting section. 

Understanding the dashboard 

The 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, including Service Date, Encounter Created Date, Batch Date, or Initial Billed Date, while payments can be viewed based on their Payment Date or Posted Date. Select the tab with the combination that best fits your needs.  

In its default state, the dashboard will display data for the previous month, by Service and Posted date, and include all Charges and Payments.

The snapshots at the top display the Number of Encounters, Charges, Payments, Adjustments, Write-Offs, Payments Missing Posted Date, Encounters Missing Service Dates, and Total AR for the selected timeframe. Total AR is calculated by totaling all charges for a specific timeframe and subtracting all payments, adjustments, and write-offs for the same timeframe.


You can utilize the customizable filters located on the left as well as above the grid to generate a summary view of your Cash Basis Aging Report. All line item details that make up the Summary section of the dashboard will be included in the Drilldown section below. Choose a section of the Summary table to delve into the specifics in the drilldown table. 

By default, the Summary grid includes all Charges, Insurance Payments, and Patient/Guarantor Payments as well as Billed and Unbilled Encounters. If you’d like to remove any items from the grid, make a selection from the menus on the left. The grid can be grouped by one item, including Payer, Procedure Code, Place of Service, Rendering Provider, Billing Provider, Scheduling Provider, or Financial Class.


Once you’ve grouped the grid by your desired parameters, you can dive into the details in the Drilldown grid below, or select a section of the Summary table to view those details only.

Use the Billing Event Type filter on the left to add/remove billing event types from the grid.

Select the Clear Filter icon in the Summary Grid to remove the filter.

Use the three (3) dots above the grid to expand all items in the grid.

Note: Initially, the Drilldown table loads only the first 10,000 rows. Once you scroll through the first 10,000 rows, the next 10,000 rows will be loaded into the grid.

Additional details

Patient Funds and Insurance Overpayments occur when a real-world event results in a credit that hasn’t been allocated to a specific charge. These payments, whether manually created or through automated processes, contribute to the reflected overall payment totals. 

Patient funds

The Patient Funds include:

  • Manual patient fund credits
  • Manual patient fund debits
  • Patient payments made through patient funds
  • Patient funds created as a result of an insurance payment after patient payments have been applied

Insurance Overpayments 

The Insurance Overpayments include:

  • Insurance payments greater than the charge amount 
  • Insurance payment greater than the balance amount

Use the three (3) dots above the selected grid to expand all items in the grid.

Learn how to utilize the features of selecting a timeframe, applying filters, and exporting data by clicking here!


Still need help? Contact us!

Have a great idea? Tell us about it!


Was this article helpful?
0 out of 0 found this helpful