Reporting FAQs

Reporting FAQs


Reporting FAQs

A/R (Account Receivables)

How do I work my A/R?

Contains vs Includes

What is the difference between Contains and Includes when Filtering?

Contains vs Includes in Filter Criteria

  • Contains: Looks at any part of the value.

    • Example: A Patient has the last name Shoemaker.

      • The Last Name Contains = "Shoe" Filter will pull the Patient last name Shoemaker since "Shoe" is included in "Shoemaker".

  • Includes: Looks at the whole value.

    • Example: A Patient has the last name Shoemaker.

      • The Last Name Includes = "Shoe" Filter will not pull the Patient last name Shoemaker.

      • The Last Name Includes = "Shoemaker" Filter will pull the Patient last name Shoemaker since the entire value is included in the Filter value.

Custom Encounter Query (CEQ)

How do I Filter for multiple Procedure Codes on the same Encounter with the CEQ?
Using the CEQ: Filter for multiple Procedure Codes on the same Encounter
  • Method 1: Use the Filter Encounter - CPT List as many times as needed for each Procedure Code.
  • Use "Contains" instead of Equals or Includes.
  • Use "AND" to separate each line.


  • Method 2: Add the Filter Encounter - CPT List as a Column and create a comma separated list.


Custom Patient Query (CPQ)

How can I run a report for Patients with the same Insurance?

Executive Summary Report

Why did my KPI number change for previous months?

Font on Reports

How can I change the Font on Reports?

Change the Font on Reports

  • The font on these reports can only be changed if exported to CSV: Custom Queries, Collection Agency, Reference Batch, Interactive Aging, and Period End Reports cannot be changed unless you export the output to CSV.

  • The font can be changed on most other reports.

    • At the bottom of the filters screen, select the Font Size: S, M, L, XL, or L.

Include/Exclude Items on a Report

How can I Include or Exclude Items on a report, such as Billing Providers, CPTs, Insurances, etc.?

Include or Exclude Items on a report, such as Billing Providers, CPTs, Insurances, etc.

Patient Ledger

Why is the Patient Ledger missing the Practice Address?
The Patient Ledger is missing the Practice Address

The Address is stored in Statement Profiles (Admin > Statement Profiles).

Race

What Reports can I run by Race?
Report for running by Race

All Custom Query Reports can be run by Race or Race ID: CEQ, CPQ, CTQ, CRQ, and CAQ.

Examples:

  • CPQ: Custom Patient Query (Under Demographics panel > Race; use Contains, not Equals)


CAQ, CEQ, CTQ, and CRQ

  • CEQ: Custom Encounter Query (Under Patient Panel > Race ID or Race; Using Contains, not Equals)


Share/Copy a Report

How do I share or copy a Report?

Copy a Report

  1. Copy a Report to another User

Only the Custom Query reports can be shared

Share a Report

Only the Custom Query reports can be shared

  1. Share vs Copy on Custom Queries

  2. Copy a Report to another User


Share a Report
Only the Custom Query Reports can be shared.




    • Related Articles

    • Custom Query Reports Hub

      Custom Query Reports (CQR) Custom Encounter Query = CEQ Custom Receipt Query = CRQ Custom Transaction Query = CTQ Custom Patient Query = CPQ Custom Appointment Query = CAQ Overview Filters and Criteria Create a CQR CEQ CRQ CTQ CPQ CAQ Overview Custom ...
    • Executive Summary Calculations

      Executive Summary Calculations The Executive Summary Report provides Monthly totals incorporating key revenue cycle KPI components, broken down for each month over a 12 month reporting period. Net Payments: The Dollars Posted for the selected time ...
    • Custom Encounter Query (CEQ)

      The CEQ is a Custom Query that queries Encounter Data. Access the CEQ Report by selecting Reports on the left side menu. Select Custom Encounter Query in the Transactions panel. Build a Custom Encounter Query Filter Criteria: Add your filter criteria ...
    • Custom Patient Query (CPQ)

      Custom Patient Query (CPQ) The Custom Patient Query report is located in the Patient panel on the Reports screen and is built by the User. The content of this report is Patient related. For instructions on building a Custom Query Report, see Create a ...
    • Custom Query Reports Overview

      Custom Query Reports Overview Custom Query Reports can be custom-built to produce the output and columns you want specifically. A Default Report is System delivered for each Custom Query Report. They all operate in the same way but pull specific ...