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.
Choose one or more practices in the drop-down.
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.
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.
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.
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.
The balances that appear and the aging buckets they fall into are based on the date selected
Click Run Report to run the report using the selected filters.
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.
Choose Download to export the report data as CSV. Your CSV file can be opened with Excel.
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.
Calculations & Definitions (Report Output)
|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)
|Patient payments that have not yet been applied to billable(s)
|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 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.