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.
Summary
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.
Drilldown
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.
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 payments 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!