Combined A/R Detail

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

The Combined A/R Detail report offers a comprehensive view of an organization's accounts receivable. It provides detailed information at the individual claim and service level, enabling users to see the balance of open receivables. This report breaks down receivables by charges, payments, adjustments, and patient responsibility, making it easier for users to understand the receivables' status.

Generating the Report

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

1. Navigate to the Reporting section.
2. Under Accounting Reports, select Combined A/R Detail Report.
   
3. Next, update the filters to specify how the system should generate the report.
   
4. Then click Run Report.
   
5. To download the report into a .csv Excel document, click Download.
   
    
6. To include any change occurring within the last 24 hours, click Refresh Data.
   

Available Filters and Definitions

• The Selected Practices filter allows users to generate the report based on the practice under which claims were submitted.
  
• The Age Basis Date filter specifies which claims to include in the report, based on when the claim was submitted to the payer (Submitted Date) or the claim's dates of service (Date of Service).
  
• The Amount Type filter allows users to generate the report using either the item balance (Balance) or the sum of all items (Charges). Note that claims or billables with a $0 balance will not be included in the report.
  
• The Claim Type filter enables users to filter results to display only claims (Insurance), patient billables (Private Pay Only), or both (All).
  
• The Claim State filter lets users filter the report by each claim's current state.
  • Any: This is the default claim state setting. When Any is selected, the report will include any claims or billables with balances.
  • Closed: Selecting Closed will generate the report with only closed receivables.
  • Open: Selecting Open generates the report for open receivables only.
    
• The Report Date filter enables a user to include balance activity up to a specified date.
  

Reviewing the Report

The Combined A/R Detail report produces a table where each row represents an individual service line based on the report date and age-basis date selected. For an example of this report, click here.

Calculations and Definitions (Report Output)

Row Name	Definition/Calculation
Patient	Patient Name
Patient ID	Patient ID
MRN	MRN
DOS Start	First Date of Service on Claim
DOS End	Last Date of Service on Claim
Service	The Service Name
Payer	Payer Name
Claim ID	The RCM-generated claim number.
Units	Number of Units for each service on the claim
Charges	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 When no payer rate is entered, then it is calculated as the(Facility Service Rate x Number of Units). When a Service Rate is entered at the Patient Level (ex. single case agreement), Expected Amount will be reported as the amount entered for the patient's service rate. In other words, the patient's service rate will override the payer profile and facility rates in the report.
Insurance Paid	The amount(s) the insurance company paid on the claim
Insurance Adjusted	The total insurance adjustments for the claim, excluding PR and 100 adjustments (see Patient Responsibility Column)
Deductible	The deductible amount as entered on the insurance payment
Co-insurance	The co-insurance amount as entered on the insurance payment
Co-pay	The co-pay amount as entered on the claim
Patient Responsibility	Sum of PR and 100 adjustments for the claim
Patient Paid	The amount the patient paid that is applied to the claim
Patient Balance	(Insurance Charges - [Insurance Paid, Insurance Adjusted, Patient Paid]) + [Deductible, Co-insurance, Co-pay, Patient Responsibility])
Practice Name	The practice at which the patient was admitted for the claim
Facility Name	The facility within the practice 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 Balance for the Amount Type. 
• This report can be used concurrently with the Summary version to combine the aging buckets and get a comprehensive understanding A/R aging. 

• Combined A_R Detail Report - Demo.xlsx 300 KB