Month End: Accounts Receivable

Accounts Receivable Month End report is an Analysis Grid style report that lists the total charges, payments, and adjustments for each patient that occurred within the closed month and any remaining balances by age.

Note: This report is a static snapshot of your billing data taken when the month was closed. It is captured after all Month End procedures are completed in WebPT Billing. Any changes will be reflected in the next month's data.

This report replaces the previous RevFlow month-end reports, Dashboard Aging By POS and Dashboard InsClass Aging by Current.

Location

This report is located in the Month End Report section in Analytics. If you do not see the report listed here, ensure you have the necessary Analytics Access and User Role permissions.

Run and Customize the Report

You can filter which clinics appear in the report using the View Clinics by: drop-down menu and corresponding (…) menu button.
Select the Month and Year.
Add custom Filters to create specific segments of data using any of the column values in the Report. If you are new to using this type of report, you can find out more here.
Add a Bar, Line, Curved Line, Pie, Scatter Plot, Heatmap, or Gauge Chart here or to your Dashboard.
Check the box to Exclude Liens. This excludes all charges tied to lien payers.

Column Descriptions

Column	Description
Clinic Name	Name of the Clinic where the patient was treated
Patient Name	Name of the patient
Account Number	Patient’s Billing account number
Charges	Charges applied to the patient’s account during the selected month
Total Payments	Total payments applied to the patient’s account during the selected month
Adjustments	Total adjustments applied to the patient’s account during the selected month
Current Balance	Balance 0-29 days old (based on the Date of Service)
30 Days	Balance 30-59 days old (based on the Date of Service)
60 Days	Balance 60-89 days old (based on the Date of Service)
90 Days	Balance 90-119 days old (based on the Date of Service)
120 Days	Balance 120-149 days old (based on the Date of Service)
150 Days	Balance 150-179 days old (based on the Date of Service)
180 Days	Balance 180+ days old (based on the Date of Service)
Balance	Patient’s balance for all time