Query by Form

Query by Form

Query by Form   (QBF)

This is a key report for Visit/Encounter Level information. It includes the Insurance Payments and Adjustments and Patient Payments posted on the original Charge. All transactions are reported under the PRIMARY insurance that was on the Claim when the Charge was posted.

The QBF report has multiple filters making it a very versatile report. Most of the filters have the option to select ranges.

This report is not meant to balance to the Period End Report.

QBF FAQs

  • Charge Post date or Service date?: This report always runs Charges with associated payments and adjustments no matter which date type is chosen.

    • The Charges will balance to other financial reports that are run by the same criteria.

    • The payments and adjustments on other financial reports will not balance to this report.

  • Example 1: The QBF Report by Post Date for May

    • Posted Date From: 05/01/22

    • Posted Date To: 05/31/22

      • Results:

        • Charges posted in May

        • Payments and adjustments posted in any month for Charges posted in May.

  • Example 2: The QBF Report by Service Date for May

    • Date of Service From: 05/01/22

    • Date of Service To: 05/31/22

      • Results:

        • Charges with a Date of Service in May

        • Payments and adjustments posted in any month for Charges with a DOS in May.

  • Other Financial reports show Charges posted in the Post Date range and Payments posted in the same range which might not be related to the reported Charges at all.
    • Example: Practice Analysis Report by Posted Date for May.
      • Posted Date From: 05/01/22
      • Posted Date To: 05/31/22
    • Results:
      • Charges posted in May
      • Payments and adjustments posted in May with no relationship to the Charges


Filters

  1. A Date Range must be specified.
  2. If any of the filter fields are left blank, the Report will report all in that category, such as, all Facilities, Billing/Rendering Providers, Insurances, etc.
  3. You can Include/Exclude and use Ranges in the filter fields.

Additional Filters

  • Non-Billable Procedures: The Default is Exclude.

  • Include the Following Fields: Choose the columns to include on the report output.

  • Include Incomplete Encounters: Incomplete Encounters are not included by default, but can be chosen to be included.

  • Include Reversed Encounters: Reversed Encounters are included by default. Uncheck the box if you do not want to include them.

  • Include Collections is not included by default. Select the check box to include.

  • Totals Only: When selected, only one Total line displays. Use the Practice Analysis Report by DOS for more filters and detail.

  • Totals By: Choose how you want the report to Total. Leave as "Nothing" if you do not want it Totaled by any of the fields on the dropdown list. If you do want to select a Totals by, do not have Totals Only selected.

          


Payments Posted From and To

You can define the Payments Posted Dates to include Payments posted for a specific time period.

Example 1:
  1. Charges Posted for 01/01/22 to 03/01/22
  2. Payments Posted for 01/01/22 to 07/31/22
    1. Results
      1. Charges: $72,384.59
      2. Payments: $9,684.63
Example 2:
  1. Charges Posted for 01/01/22 to 03/01/22
  2. Payments Posted Date left blank: Payments posted on any date
    1. Results
      1. Charges: $72,384.59
      2. Payments: $34,533.94

Example 1 Screenshot




Example 2 Screenshot





    • Related Articles

    • Patient Query by Form

      Patient Query by Form The Patient Query by Form Report can be used to gather Patient data by Diagnosis, CPT®, and Insurance by Facility and Provider. Primary Diagnosis: Use a range of Diagnosis Codes or an individual Diagnosis for the Primary ...

    • Print Batched Paper Claims on a HCFA Form or on Plain Paper

      Print a Claims Batch After batching your Claims, on the Claims Management Dashboard, go to the Claim Batches to Be Sent/Printed panel. This panel does not include Batches that contain Encounters in a more recent Batch. Find the batch with Type HCFA. ...

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

    • Recalls

      Recalls are frequently used when the Patient should have an appointment in the future for a maintenance-type visit or an annual visit. Example: A Patient needs to be seen every six months or for a yearly health visit or a yearly eye care exam. These ...

    • Custom Encounter Query (CEQ) Report

      The CEQ is a custom report/query tool that queries Encounter Data. Reports > Custom Encounter Query Build a Custom Encounter Query Filter Criteria: Add your filter criteria by clicking the Plus symbol beside "And". The filters you choose will ...