Accounts Receivable Report

The report shows all kept appointments that have open invoices (unpaid or partially paid) for the specified date and day range(s). 
You can quickly identify outstanding balances and follow up with the appropriate clients and insurance companies. The report is generated based on the applied Date Range filters. It can also be customized using the customize grid option.

1. Click Reports in the primary navigation bar and click Accounts Receivable Report under the Billing section.
   
    

Set Filters

1. Date - the report will use this date as the target date to calculate Days Past Due. Filters out invoices created after this date and ages all invoices based on the entered date.
2. Days Past Due - shows outstanding balance totals within the selected day range(s) up to the target date. Allows users to select the age buckets they wish to show on the report.
   NOTE:  All aging is done based on the invoice date.
3. Click Run Report. 

    NOTE:  Change the number of Clients shown per page (10, 25, 50 or 100) by clicking desired unit at top of report. 

   

Read the Report

1. Totals Calculated in Report. 

   NOTE:  These totals will reflect selections made in the column filters.

2. Search the Report using the column headers:
   • Client
   • Date of Birth
   • Insurer
   • Service Date
   • Code
   • Units Billed
   • Insurance Billed Amount
   • Allowed Amount
   • Client Billed Amount
   • Insurance Paid
   • Client Paid
   • Insurance Due Amount
   • Client Due Amount
     
     
      
3. Click Customize Grid to add additional columns.

Payer ID- ID associated with the insurance Service Type - service type associated with invoice line item Code - code associated with the service type Units Billed - total units being billed for the invoice line item Contract Rate - rate that is set at the insurer level for the service type. Allowed Amount - the expected insurance amount calculated based on the contracted rates entered into the system. The contracted rate is multiplied by the units on the invoice line. Insurance Billed Amount - total amount billed to the insurance Client Billed Amount - total amount billed to the client Total Paid - total dollars paid on the invoice line item Invoice Number - number associated with the invoice the line item belongs to, links to ledger

Download Report

Once you have run the Report, you can copy or download the CSV, Excel, and PDF version directly to your computer.

1. Click the CSV and PDF button on the upper right tab.
   

[Back to Top]