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?

Run a Report for Patients with the same Insurance, such as Medicare, BCBS, etc.

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 a Report?

Share a Report

  1. Share vs Copy on Custom Queries

  2. Copy a Report to another User



    • Related Articles

    • 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 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 ...

    • Employer/Attorney Ledger

      Employer/Attorney Ledger The Employer/Attorney Ledger can be used to provide more information than is on the Invoice. (Libraries > Employer/Attorney Library > ID) Select the Ledger link at the top of the Employer/Attorney Dashboard. Employer/TPA: The ...

    • Print a Patient Ledger

      Uses for the Patient Ledger HSA requests Auto Accident or Workers Comp Cases Attorney requests Medical Records, any time we need a printout of patient activity that does not need a HCFA or electronic claim Specific Facilities Print a Patient Ledger ...

    • Aging by Patient Report

      Aging by Patient Report The Aging by Patient Report can be used for outstanding Patient/Insurance balances, Patient/Insurance credits, and Escrow. This is similar to the Unresolved Claims Report and Interactive Aging. Patient Escrow is highlighted in ...