Custom Receipt Query (CRQ)

Custom Receipt Query (CRQ)


Custom Receipt Query (CRQ)


The Custom Receipt Query is driven by entered/posted Receipts. This report will match the Receipt Management report if it is run by the same parameters.


Received Date vs Posted Date

Example:

  • Date Range: Run by Received Date less than 10/01/22 and Post Date Greater Than or Equal To 10/01/22 and Less Than or Equal To 10/31/22 will reveal Deposits made in a specific time period but were posted outside of that time period.

Receipt - Is Registered Type

  • Yes: Receipts for Patient, Insurance, and Invoice Payments
  • No: Receipts for Reversals, Self-Pay Discounts, Mass Write-offs, etc.

Example:


Totals By Receipt Type


Learn More


    • Related Articles

    • Custom Queries - Admin

      Custom Queries - Admin These are custom SQL queries that are written for clients to extract specific information to meet specific needs. There may be a charge for the creation of the Custom Query and will be presented to the client before starting ...

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

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

    • Filter for Custom Fields on a Receipt

      Filter for Custom Fields on a Receipt The Custom Fields must be completed on the Add Payment Screen when the Receipt is created. On the Receipt History screen, filter for Receipts Custom Field. In the following figure, it is Receipt Type. This can be ...

    • Custom Query Report/Table Filters and Criteria

      Custom Query Report/Table Filters and Criteria Custom Query Reports can be custom-built and the selected parameters can be Saved with the option to Share with other Users. With the ability to save and share, your preferred Reports are accessible ...