Run Billing Reports - Custom Report Module

The custom reporting module encompasses the Encounter Report, Insurance Payment Report, Patient Payment Report, Aging Report, Patient Report, Cash-Basis Aging Report, and Activity Report. With this tool, you can:

  • Create flexible reports based on the reporting period, report type, and date type.
  • Filter, sort, and group fields are most important to you.
  • Set favorite and default views for future use.
  • Run high-level reports for management or line item reports for revenue cycle specialists.

Encounter Report

Use this report to generate an extensive breakdown of encounter-specific data, including claim tracking, unsettled encounters, payments, and more for a particular report period.

Running the Report

Select Encounter Report from the Report Type drop-down.

123.png

Select the Date Type from the following options:

  • Service Date
  • Billed Date
  • Created Date
  • Batch Date

Screen_Shot_2023-01-23_at_2.35.18_PM.png

Select the Report Period or enter custom dates in the Date From and Date To fields.

Screen_Shot_2023-01-23_at_2.35.27_PM.png

Click Run Report to generate the Encounter Report. This report will filter the encounters based on the date type and range selected. 

Screen_Shot_2023-01-23_at_2.35.27_PM.png

The Encounter Report will be added to the queue in the Pending state.

Screen_Shot_2023-01-23_at_3.05.53_PM.png

Once ready, the status will change from In Progress to Completed , and the View Report link will be available. Click View Report to open the report.

Screen_Shot_2023-01-23_at_3.07.51_PM.png

Understanding the Report

Encounter data is contained under 7 different tabs.

  • All - Displays all columns contained in the 6 other tabs.
  • Encounters - Displays encounter data based on the search criteria.
  • Claim Tracking - Displays claim details for the filtered encounters.
  • Unsettled Encounters - Displays unsettled encounters for the report period.
  • Line Items - Contains the line item details of the filtered encounters.
  • Payments - Contains payment information associated with the encounters.
  • Miscellaneous -  Miscellaneous line items or charges will be listed here.
  • Users - Displays details of the users that created the encounters.

Screenshot_2023-05-26_at_8.07.49_AM.png

Export to CSV and PDF

Click on the CSV icon to export the report in the CSV format.

CSV.png

Click on the PDF icon to export the report in a PDF format.

PDF.png

Click Export by Group to export the PDF report based on the groupings in the report.

EXPORT_by_group.png

Starting Wednesday, May 31st, 2023, The encounter report data will now be fetched from a reporting database (BigQuery). This does not affect your data or impact your totals, but the frequency of data updates will change to every 2 hours. The date and time of the latest data update is indicated under the **Data Synced Until** field. 

Data Synced Until - This field indicates the date and time of the latest data update

EXPORT_by_group.png

Insurance Payment Report

This report consists of insurance payment details at a line item level. Use this report to get a total picture of insurance payments collected or posted in a specific period of time. 

Running the Report

Select Insurance Payment Report from the Report Type drop-down.

ip1.png

Select the Date Type from the following options:

  • Payment Date
  • Posted Date
  • Service Date

ip2.png

Select the Report Period or enter custom dates in the Date From and Date To fields.

Screen_Shot_2023-01-23_at_2.38.24_PM.png

Click Run Report to generate the Insurance Payment Report. This report will filter the encounters based on the date type and range selected. 

Screen_Shot_2023-01-23_at_2.38.24_PM.png

The Insurance Payment Report will be added to the queue in the Pending state.

 

Screen_Shot_2023-01-23_at_2.38.24_PM.png Once ready, the status will change to Completed from In Progress, and the View Report link will be available. Click View Report to open the report.

Screen_Shot_2023-01-23_at_2.51.39_PM.png

Understanding the Report

This report consists of line item level details for all insurance payments that match the search criteria.

Screen_Shot_2023-01-23_at_2.52.14_PM.png

Use Include Unposted Payments to also display unposted insurance payments that match the search criteria.

Screen_Shot_2023-01-23_at_3.23.26_PM.png

Callout: Keep in mind that this report contains only payments that are linked to an encounter. 

Export to CSV and PDF

Click on the CSV icon to export the report in the CSV format.

Screen_Shot_2023-01-23_at_2.52.14_PM.png

 

Click on the PDF icon to export the report in PDF format.

Screen_Shot_2023-01-23_at_2.52.14_PM.png

Click Export by Group to export the PDF report based on the groupings in the report.

Screen_Shot_2023-01-23_at_2.52.14_PM.png

Patient Payment Report

This report consists of patient payment details at a line item level. Use this report to get a total picture of patient payments collected or posted in a specific period of time. 

Running the Report

Select Patient Payment Report from the Report Type drop-down.

Screen_Shot_2023-01-23_at_3.33.57_PM.png

Select the Date Type from the following options:

  • Payment Date
  • Posted Date
  • Service Date

Screen_Shot_2023-01-23_at_2.35.57_PM.png

Select the Report Period or enter custom dates in the Date From and Date To fields.

Screen_Shot_2023-01-23_at_2.37.14_PM.png

Click Run Report to generate the Patient Payment Report. This report will filter the encounters based on the date type and range selected. 

Screen_Shot_2023-01-23_at_2.37.14_PM.png

The Patient Payment Report will be added to the queue in the In Progress state.

Screen_Shot_2023-01-23_at_2.38.08_PM.png

Once ready, the status will change to Completed from In Progress, and the View Report link will be available. Click View Report to open the report.

 

Understanding the Report

This report consists of line item level details of all patient payments that match the search criteria.

Use the Include Unposted Payments to display unposted patient payments that match the search criteria.

Screen_Shot_2023-01-23_at_2.52.52_PM.png

Callout: Keep in mind that this report contains only payments that are linked to an encounter. 

Export to CSV and PDF

Click on the CSV icon to export the report in the CSV format.

Screen_Shot_2023-01-23_at_2.52.52_PM_copy.png

Click on the PDF icon to export the report in PDF format.

Screen_Shot_2023-01-23_at_2.52.52_PM_copy_2.png

Click Export by Group to export the PDF report based on the groupings in the report.

Screen_Shot_2023-01-23_at_2.52.52_PM.png

Patient Report

This report consists of patient details. Use this report to access patient specific details like demographics, cases, prior authorizations, etc. in a specific period of time.

Running the Report

Select Patient Payment Report from the Report Type drop-down.

Screen_Shot_2023-01-23_at_2.36.12_PM.png

Select the Date Type from the following options:

  • Created Date
  • Date of Birth

Screen_Shot_2023-01-23_at_2.36.20_PM.png

Select the Report Period or enter custom dates in the Date From and Date To fields.

Screen_Shot_2023-01-23_at_2.36.43_PM.png

Click Run Report to generate the Patient Payment Report. This report will filter the encounters based on the date type and range selected. 

Screen_Shot_2023-01-23_at_2.36.43_PM.png

The Patient Report will be added to the queue in the Pending state.

Screen_Shot_2023-01-23_at_2.38.08_PM.png

Once ready, the status will change to Completed from In Progress, and the View Report link will be available. Click View Report to open the report.

Screen_Shot_2023-01-23_at_2.39.45_PM.png

 

Understanding the Report

Patient demographic, cases, and prior authorization details are contained under 5 different tabs.

  • Patients - Displays patient demographic details associated with the filtered patients.
  • Cases - Displays active case details for the filtered patients.
  • Prior Authorizations - Displays prior authorizations linked to the cases.
  • Relations - Displays relations associated with the filtered patient cases.
  • Users - Displays details of the users who created the filtered patients.

Screen_Shot_2023-01-23_at_2.52.30_PM.png

Export to CSV and PDF

Click on the CSV icon to export the report in the CSV format.

Screen_Shot_2023-01-23_at_2.52.30_PM.png

Click on the PDF icon to export the report in PDF format.

Screen_Shot_2023-01-23_at_2.52.30_PM.png

Click Export by Group to export the PDF report based on the groupings in the report.

Screen_Shot_2023-01-23_at_2.52.30_PM.png

Aging Report

Click here to learn about the Aging Report.

Cash-Basis Aging Report

Click here to learn about the Cash-Basis Aging Report.

Activity Report

Click here to learn about the Activity Report.

Important Changes After February 22nd, 2023

Starting on February 22nd, 2023, only five (5) previous snapshots will be stored in the Report Queue for each report type (Patient Report, Patient Payment Report, Insurance Payment Report, Encounter Report, and Aging Report). Any remaining snapshots will be deleted from the queue.

Why is This Happening?

Removing unused report snapshots will improve overall system performance.

Steps Before the Sunset:

If there are any snapshots that you'd like to save, please look through your Report Queue and download any of importance to CSV or PDF format by February 22nd.

Future Best Practices:

Please maintain report snapshots locally to avoid losses of historical data after the sunset. Download to CSV or PDF format to access them at a later time, as we will automatically remove old snapshots when new reports are generated.

Important Note:

You can re-generate a report for the same date range at any time. However, please keep in mind that the newly generated report will display the latest data and incorporate all data updates after the previous snapshot was created.

Was this article helpful?
0 out of 0 found this helpful