Cash-Basis Aging Report

The Cash-Basis Aging Report is an accurate representation of cash flow in your practice, helping you manage the revenue cycle. This report ties into your bank account and the Activity Report to provide true aging for a specific period of time. The flexibility of this report allows you to filter and age data to fit your practice’s needs. You can also drill down to see the total charges, payments, and adjustments contributing to the aging.

This report differs from RXNT’s existing Aging Report which is accrual-based. Accrual-based means that only payments linked to a charge are displayed in the report. Hence, the accrual-based Aging Report acts as a good working list to follow up on your payments. Click here to learn more about the accrual-based Aging Report.

Now, we’ll cover how to create a Cash-Basis Aging Report and get a realistic picture of your practice’s revenue cycle.

Select the report

Cash basis aging report

Navigate to the Reports tab and select All

Click Customize Your Own Report located under Custom Reports.

Select Cash-Basis Aging Report from the Report Type drop-down.

You will see a set of options to set your criteria, let's go through each one in detail.

Search criteria

Date types

Encounter Date Type: The Encounter Date Type is initially set to Service Date but can be filtered by Batch Date, Initial Billed Date, or Created Date

Payment Date Type: The Payment Date Type is initially set to Payment Date but can be filtered by the Payment Posted Date

Now that we've chosen the date types, let's proceed to select the date range.

Date range

The "Filter To" date defaults with the current date, you will need to enter a start and end date in the Filter From and Filter To fields. 


Charges are aged until the current date based on the Encounter Date Type.

Payments are aged until the current date based on the Payment Date Type.

In this example:

  • The Encounter Date Type is Service Date.
  • The Payment Date Type is Payment Date
  • Charges age based on the service date. 
  • Payments age based on the payment date.
  • The date range to filter charges and payments is August 17th, 2020, and August 17th, 2021.

What does this mean?

The Cash-Basis Aging Report will consist of charges that have a service date and payments that have a payment date between August 17th, 2020 - August 17th, 2021.

The age of the charges is calculated using:

Current Date - Service Date 

The age of the payments is calculated using:

Current Date - Payment Date 


Run report

Click, Run Report. After running the report, charges and payments that fall within the selected date range will be displayed on the report. 

Understanding the report

Report header

The Cash-Basis Aging Report displays the following fields on the top of the report to clearly indicate the details of the report generated:

  • Report Name: Shows the name of the report.
  • Encounter: Displays the selected encounter date type used to run the report.
  • Payment: Displays the selected payment date type used to run the report.
  • Filter Range: Shows the date range for which the report was generated. If only "Date To" was entered, the field name changes to "Aging Through."
  • As Of: Displays the date and time at which the report was created.

Getting an alert at the top?

This alert indicates that some payments or/charges are missing the payment date type or encounter date type. Update payments and charges with correct dates to ensure an accurate report.


Report tabs

The Cash-Basis Aging Report has six views, in which practice data is for the practice grouped by the following:

    • Payer - The payer data can be grouped either by the primary responsible party or the current responsible party (Releasing on 4/27/2022)
    • Procedure Code
    • Facility
    • Rendering Provider
    • Billing Provider
    • Scheduling Provider
    • Financial Class - The financial class data can be grouped either by the primary responsible party or the current responsible party (Releasing on 4/27/2022)

Simply click through the various tabs to find the view most suitable for your practice’s needs. 


Some data under the tabs may not have an associated group. This data will be grouped under the No Payer, No Procedure Code, No Facility, No Rendering Provider, No Billing Provider, and No Scheduling Provider section under their respective tabs.


Toggle button

The Cash-Basis Aging Report allows you to view your practice’s data based on insurance payments, patient payments, or both. 

Want to know how charges are aging based on the insurance payments? Simply click the Insurance toggle button.

If you need to understand how charges are impacted by patient payments, simply click the  Patient/Guarantor toggle button.

Or if you want to see the entire data, toggle back to All.

Aging buckets

The aging amount associated with each group is displayed in corresponding aging buckets:

    • 0 - 30 days
    • 31-60 days
    • 61-90 days
    • 91-120 days
    • 120+ days

The aging amount for each bucket is calculated using the formula: Charges (in that aging bucket) - [Payments (in that aging bucket) + Adjustments (in that aging bucket). 

Drill down into each group to find the associated Charges, Payments, and Adjustments.

Need to expand all groups at once? Simply check the Expand All button in the right-hand corner of the report.


Find Total Aging, Charges, Payments, and Adjustments/Write-offs for each group. 

Find the Total Aging for the entire report below the table.


Additional details table

The additional details table displays the total amount of patient funds and insurance overpayments contributing to the payments. 

Patient funds include:

    • Manual patient fund credits
    • Manual patient fund debits
    • Patient payments made through patient funds
    • Patient fund created as a result of an insurance payment after a patient paid for the same charge

Insurance overpayments include:

    • Insurance payments greater than the charge amount

Hover over the information icon next to patient funds and insurance overpayments to get a tooltip with the information mentioned above.

Patient funds and insurance overpayments are already included in the payment amount of the first table, the Additional Details table is available to give you an idea of the total liabilities to your practice


Exclude unbilled encounters

Unbilled encounters contain information that can change. If you want to see a more solidified view of your data, simply check the Exclude Unbilled Encounters button in the right-hand corner of the Cash-Basis Aging Report.

Summary view

To display the data in a Summary View, simply click Summary View

Export to CSV

If you need to export your data, click on the vertical three dots indicating the "More Menu."

Select Download CSV to download the file for your current tab.


Still, need help? Contact us!

Have a great idea? Tell us about it!

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