Combined A/R Summary

  • Updated

The Combined A/R Summary report shows the total outstanding balance and aging of receivables for all patients. This report can be used to gain insight into potential revenue and the overall health of your receivables, and to identify patients and cases that may require additional collection efforts. AveaOffice claims and billables in an open state will appear on this report.

This report combines insurance claims and patient balances into one report.

Creating the Report

Go to the Reporting section from the left-side menu. This Report is only available at the Organization level. Under Accounting Reports, select Combined A/R Summary.        

mceclip0.png    

Report Options

Screen_Shot_2020-10-29_at_19.42.58.png

Selected Practices

Choose one or more practices in the drop-down.

Group By

Group the report by patient, practice, payer, claim status, claim queue, or claim issue to see total outstanding amounts by these different categories. 

Age Basis Date

Submitted Date will generate a report with balances and aging buckets based on the date the charges were submitted or approved.

Service Date will generate a report with balances and aging buckets based on the date services were rendered, regardless of when the claim was submitted or private pay billable was approved.

Amount Type

Difference Covered vs. Expected (Default)

Balances will reflect the difference between the expected rate (defaults to charge rate unless a service rate override for a given service exists) and the covered rate (defaults to $0 unless an ERA/EOB has been received from the payer with a covered or allowed amount present).

Patient payments applied to a billable reduces the balance when Difference Covered vs Expected is selected.

Charges

Balances will reflect the total amount charged, regardless of whether payments have been received against open claims

Includes Negative Balance

Toggle to yes to include negative balances. Negative balances indicate more than one payment has been posted against a claim(s) or the patient's payments exceed the Total Balance. This is typically the result of an overpayment, or receiving two ERA for the a single claim without an offsetting ERA to balance the claim.

Claim Type

All (default) will provide balances based on on both insurance receivables and patient receivables

Insurance Only will provide balances based on insurance receivables only

Private Pay Only will provide balances based on patient receivables only

*** Receivables will appear as Private Pay if Patient Billables were created/approved using AveaOffice Patient Billing or patient responsibility is submitted to the guarantor using the Inbox Health integration.

Report Date

The balances that appear and the aging buckets they fall into are based on the date selected

Run Report

Click Run Report to run the report using the selected filters.

Refresh Data

To improve report speed, report and dashboard data is cached up to the last 24 hours. To use real-time data, click Refresh Data to update report results using the most recent data.

Download

Choose Download to export the report data as CSV. Your CSV file can be opened with Excel.

Results

The A/R Aging Summary produces a table where each row represents a patient with open claims and outstanding receivables, and the age of these receivables. Columns include: Patient, Patient ID*, Days Since Submitted (Aging) 0-30, 31-60, 61-90, 91-120, 121-150, 151-180, 181-210, 211-240, Unapplied Payments**, Total Outstanding, Total Outstanding %, Organization**, and Practice**.

*The column Patient ID is only shown when grouping by Patient.

**The columns Unapplied Payments, Practice, and Organization are only shown when grouping by Patient and by Practice.

Screen_Shot_2020-10-29_at_20.04.59.png

Calculations & Definitions (Report Output)

Row Name Definition/Calculation
Patient Patient Name
Patient ID Patient ID
0-30, 31-60, 61-90, 91-120, 121-150, 151-180, 181-210, 211-240, 241+ Sum of amounts within the corresponding age bucket. 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

Tips and Tricks

Search

Search by patient name to filter the report without having to download to excel.

Total Outstanding Percentage

Use the Total Outstanding % column to see how much of the organization's total outstanding A/R is included in that row.Screen_Shot_2020-10-29_at_19.49.10.png

Screen_Shot_2020-10-29_at_19.55.28.png

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.