The Combined A/R Detail report is a way to see charges, payments, adjustments, patient responsibility, and balance of individual receivables. This report can be used to gain deeper insight into receivables at the individual claim and service level. 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 Detail.
Choose one or more practices in the drop-down.
The report will pull all claims and/or billables that have a submission date or DOS Start prior to the date selected.
Submitted Date will generate a report with claims based on the date the claim was submitted
Service Date will generate a report with claims based on DOS Start
All (default) Balances 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.
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 reports results using the most recent data.
Choose Download to export the report data as CSV. Your CSV file can be opened with Excel.
The Combined A/R Detail report produces a table with where each row represents an individual service line based on report date and age-basis date selected. Results include: Patient, Patient ID, MRN, DOS start, DOS end, Service, Payer, Claim ID, Units, Insurance Charges, Expected Allowed Amount, Insurance Paid, Insurance Adjusted, Deductible, Co-insurance, Co-pay, Patient Responsibility (sum of PR and 100 adjustments for the claim), Patient Paid, Patient Balance (Insurance Charges - [Insurance Paid, Insurance Adjusted, Patient Paid]) + [Deductible, Co-insurance, Co-pay, Patient Responsibility]), Practice Name, Facility Name
Calculations and Definitions (Report Output)
|First Date of Service on Claim
|Last Date of Service on Claim
|The Service Name
|AveaOffice generated Claim ID
|Number of Units for each service on the claim
|The claim charges for a specific service that went to insurance or the charges for a private pay billable
|Expected Allowed Amount
|Payer Rate multiplied by units
|The amount(s) the insurance company paid on the claim
|The total insurance adjustments for the claim, excluding PR and 100 adjustments (see Patient Responsibility Column)
|The deductible amount as entered on the insurance payment
|The co-insurance amount as entered on the insurance payment
|The co-pay amount as entered on the claim
|Sum of PR and 100 adjustments for the claim
|The amount the patient paid that is applied to the claim
|(Insurance Charges - [Insurance Paid, Insurance Adjusted, Patient Paid]) + [Deductible, Co-insurance, Co-pay, Patient Responsibility])
|The practice at which the patient was admitted for the claim
|The facility within the practice at which the the patient was admitted for the claim
Tips and Tricks
Use this report as a companion to the Combined A/R Summary. If concerns are identified on the summary report, use the Combined A/R Detail to filter down to the patient and review claims. You can also use Excel to drill down and find out which services, payers, or locations have the greatest outstanding balance, in order to focus your collections efforts.
Search by patient name or claim ID to filter the report without having to download to excel.