Combined A/R Summary

This report is only available for organizations with the Patient Billing module.

The Combined A/R Summary report provides users with a comprehensive overview of all outstanding balances and aging of receivables for every patient. This report can be very helpful in analyzing potential revenue and understanding the overall health of your receivables. It displays open insurance claims and open patient billables, providing valuable insights into your practice's financial status.

Generating the Report

Let's review how to generate the Combined A/R Summary report!

• 1. Navigate to the Reporting section.
  2. Under Accounting Reports, select Combined A/R Summary Report.
     
  3. Update the filters to instruct the system on how to generate the report.
     
  4. Select Run Report.
     
  5. To download the report, select Download.
     
     
  6. To include any change occurring within the last 24 hours, select Refresh Data.
     

Available Filters and Definitions

• The Group By filter enables users to customize the display of the total outstanding amount based on the category selected. These groupings include:
  • By Patient
  • By Payer
  • By Practice
  • Claim Queue
  • Claim Status
  • Issue Type
    
• The Age Basis Date filter enables users to customize the report by either using the Submitted Date or the Date of Service. By default, the Age Basis Date is set to the Submitted Date, but it can be updated to the Date of Service in the dropdown.
  
• The Amount Type filter enables a user to customize the report using either Charges, Charged vs Paid, or Difference Covered vs Expected by default.
  
  • Charges: The amount charged on the claim.
  • Charges vs Paid: This is calculated as the Amount charged on a claim minus what was Paid to the facility.
  • Difference Covered vs. Expected: The expected allowed amount minus the covered amount. This metric should alert users that the payer did not pay by their contractual obligations, or that the payer did not cover as the provider expected them to (or if no expected allowed amount was entered, this amount will show that the payer did not cover 100% of charges). Patient Responsibility amounts from payments are not considered in this balance amount.
  
• The Include Negative Balances filter enables a user to generate the report with open claims that have negative balances as well as patients with negative statement amounts.
   
• The Claim Type filter will only be available when the report is grouped By Patient or By Practice. This filter enables a user to filter the results by displaying patients who have Insurance Only or Private Pay Only.
   
• The Report Date filter enables a user to include balance activity up to a specified date. Select Refresh Data to include activity within the last 24 hours.
   

Reviewing the Report

This report provides a user with two tables that display an aging summary of an organization's current A/R. The first table provides the totals of all open billables, broken down by aging buckets of 0-30, 31-60, 61-90, 91-120, 121-150, 151-180, 181-210, 211-240 days (since submission) as well as the percentage of the totals that is still outstanding. The table will also display the sum of all Unapplied Payments (when grouped by Patient) and Total Outstanding balances. 

The information in the second table displays the source data from the totals calculations in the first table. This table will always display the Total Outstanding and Total Outstanding % for each grouping option, however, some groupings allow for more detailed information.  Grouping the report By Patient or By Practice can provide additional information such as Unapplied Payments, Insurance Outstanding, and Patient Outstanding. To see an example of the report, click here. 

Calculations & Definitions (Report Output)

Row Name	Definition/Calculation
Patient	Patient Name
Patient ID	Patient ID
Aging Buckets (0-30, 31-60, 61-90, 91-120, etc.)	The sum of amounts within the corresponding age bucket is determined by the Age Basis and Amount Types selected when creating the report. Age Basis Date: Submitted Date (date the claim/billable was submitted) or Date of Service (first date of service on the claim/billable) Amount Type: Difference Covered vs Expected (reduced amount taking into account claim adjudication and any payments) or Charges (full charge/"rack rate" for claim/billable)
Unapplied Payments	Patient payments that have not yet been applied to billable(s)
Total Outstanding	The total outstanding A/R for the patient (sum of rows 0-30, 31-60, etc. minus any unapplied payments)
Total Outstanding %	% of the total for the corresponding patient and insurance payer
Organization or Practice	The practice or facility (respectively) at which the patient was admitted for the claim

Helpful Hints

• Create a template for this report using the Date of Service as the Age Basis and the Difference Covered vs Expected for the Amount Type. 
• This report can be used concurrently with the Detail version to combine the aging buckets and get a comprehensive understanding A/R aging.

• Combined A_R Summary Report- Demo.xlsx 20 KB