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 

  1. You can filter which clinics appear in the report using the View Clinics by: drop-down menu and corresponding (…) menu button.
  2. Select the Month and Year.
  3. 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.
  4. Add a Bar, Line, Curved Line, Pie, Scatter Plot, Heatmap, or Gauge Chart here or to your Dashboard.
  5. 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
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.