Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Overview

Panel
borderColorblack
bgColorgray
titleColorblack
borderWidth2
titleBGColorwhite


Info
titlePurpose

This report summarized summarizes posted charges and related financial activity for specified dates of service.

Category

Management

Type

Detail

Mode

Date of Service

Output Options

CSV or Excel


Info
titleBGColoraaaaaa
iconfalse
titleHow to Get Here?


From Portal:
From Back Office:
  1. From the Reports tab, locate the Charge Analysis Detail Summary report.
  2. Click Edit for the report.
  3. Enter/select filter criteria on the Criteria page.
  4. Click Run Report.
  1. Open the Manage menu and select Reports.
  2. From the Reports page > Modern tab, select the Charge Analysis Detail Summary report from the list of reports.
  3. Click Run (or press [Alt] + [R]).
  4. Enter/select the filter criteria from the Parameters window.
  5. Click Run (or press [Alt] + [R]).



 

Sample Reports

(Click an image to enlarge)

Portal

Image RemovedImage Added

Back Office

Image RemovedImage Added



Field Definitions

The numberissued by the primary or referring physician for a specific treatment or treatment series. Payment for services rendered may rely on whether a referral number is associated with a case.The amount the payer will reimburse for the procedure Guarantor Refunds  and posted from .Adjustments Balance Any Charge Entry custom fields will display as columns at the end of the report

Field

Description

PracticeThe practice for which the charge is being billed.
Account IDThe account number of the guarantor account. Displays as Account Prefix + Account ID.
Charge Batch ID The unique number assigned to the charge batch.
Case ID The unique number assigned to the case.
Claim IDThe identification number issued to the claim when it was generated.
Facility Case Number The case number issued by the facility, i.e., Medical Record Number.
External Case NumberAn identification number for the case issued by a facility or payer.
Case Reporting Type The unique code assigned to the case for identifying the case for reporting purposes.
Patient The name of the patient.
GenderThe gender of the patient.
Patient DOB The date of birth of the patient.
Patient EmployerThe name of the patient's employer.
Facility The name of the facility where services were rendered. 
Facility RoomThe room number used at the facility, if provided.
Rendering Provider  

The name of the provider(s) who got credit for the case.

This name, or names, can be affected by the Team Billing option selected for the relevant plan, e.g., Bill Physician Only, Bill Physician and CRNA on the same claim.

Rendering Provider NPIThe national provider identification number issued to the rendering provider.
Rendering Provider TypeThe classification of the type of rendering provider associated with the procedure on the charge.
Performing ProviderThe name of the provider(s) who performed services on the case.
Referring Provider The name of the provider who referred the patient.
Referring Provider NPIThe national provider identification number issued to the referring provider.
Referring Provider SpecialtyThe specialty of the referring provider, based on the referring provider's specialty ID.
PayerThe primary insurance payer on the case with financial responsibility for the outstanding debt.
Plan The primary insurance plan on the case to which charges were billed.
Primary Member Number The primary member number tied to the subscriber's effective coverage.
Primary Group NumberThe primary group number tied to the subscriber's effective, primary coverage.
Pre-Auth NumberThe authorization number issued by the payer for authorization of the treatment or surgery. 
Referral Number
Primary / Secondary / Tertiary Group ByDisplays the value for the selected Primary Group By, Secondary Group By, and Tertiary Group By filters. Options include: Practice, Facility, Rendering Provider, Payer, Plan, Case Reporting Type, Date of Service, Procedure Category, Procedure Code.
Procedure QuantityThe quantity of the procedure.
Charges - BilledThe amount billed for total charges for each service fee.
Charges - ReversedAll charges (SVCFE) that were reversed.
ExpectedThe amount expected for receipt from the payer for the service fee.
AllowedThe amount the payer will reimburse for the procedure.
Contractual WriteoffThe disallowed amount entered on the payment, which is taken as a negative adjustment.
Withhold

All withhold adjustments (additional payer adjustment) applied to the service line in payment entry.

The amount held by the insurance company and applied as a credit to the SVCFE line item

Payer - Secondary The secondary payer on file for claims submission.
Date of Service - CaseThe default date of service used for the case.
Date of Service - ProcedureThe date of service for ancillary procedures.
Hold StatementDesignates if there is a statement hold on the service line charge.
Start Time The time the anesthesia procedure began.
Stop Time The time the anesthesia procedure ended.
Procedure MinutesThe total number of minutes for the associated procedure, anesthesia only.
Base Units The number of base units for each procedure on the case.
Time UnitsThe number of time units for each procedure on the case.
Physical Status Units The number of physical units for each procedure on the case.
Total UnitsThe sum of base, time, and physical units billed.
Work RVUThe work relative value unit entered on the ASA or General procedure in the billing fee schedule to which the payer or plan is associated and to which the claim was billed.
Anesthesia Method The method in which the anesthesia was administered to the patient.
Physical Status Level The physical status of the patient, as indicated in charge entry.
Place of ServiceThe location where the services were rendered.
Type of Service The type of procedure: Anesthesia or General.
CPT The general procedure code that was entered as the procedure billed on the case in charge entry.
CPT Short DescriptionA short description of the assigned CPT code.
ASA The anesthesia procedure code that was entered as the procedure billed on the case in charge entry.
ASA Short DescriptionA short description of the assigned ASA code.
Modifier 1 The primary modifier entered on the procedure of the case.
Modifier 2 The second modifier entered on the procedure of the case.
Modifier 3 The third modifier entered on the procedure of the case.
Modifier 4 The fourth modifier entered on the procedure of the case.
Diagnosis 1 The primary diagnosis entered on the case.
Diagnosis 2 The secondary diagnosis entered on the case.
Diagnosis 3 The tertiary diagnosis entered on the case.
Diagnosis 4 The fourth diagnosis entered on the case.
Procedure QuantityThe quantity of the procedure.
Billed

The amount billed for the procedure.

 
ExpectedThe amount expected for receipt from the payer for the service fee.
Allowed

.

Payments - AllThe amount distributed on a particular line item.
Payments - InsuranceThe total amount of insurance payments received on a case.
Payments - GuarantorThe sum of payments applied on the guarantor account.
Payments - SuspenseThe sum of payments applied on Suspense.
Reversals - AllThe sum of all payment reversals.
Reversals - InsuranceThe sum of payment reversals performed on insurance payments.
Reversals - GuarantorThe sum of payment reversals performed on guarantor payments.
Reversals - SuspenseThe sum of payment reversals performed on suspense distributions.
RefundsThe total amount of refunds, or payments reversed, and posted from the account
Contractual Write-off The disallowed amount entered on the payment, which is taken as a negative adjustment.
Withhold 

All withhold adjustments (additional payer adjustment) applied to the service line in payment entry.

The amount held by the insurance company and applied as a credit to the SVCFE line item.

for the specified date range.
Adjustments - NegativeThe sum of negative adjustments and reversals of negative adjustments performed on the service fee line.
Adjustments - PositiveThe sum of positive adjustments and reversals of positive adjustments performed on the service fee line.
External CollectionsThe amount sent to external collections.
BalanceThe current balance of the claim.
Responsible Party Displays the value Guarantor for service lines in guarantor responsibility.
Accounting Date The date within the accounting period when the charge was posted. The accounting date is stored at the practice configuration in Connect Back Office.
Charge Received DateThe date recorded on the case for when the charge was received.
Submitted Date The date the claim was submitted.
Base UnitsThe number of base units for each procedure on the case.
Time UnitsThe number of time units for each procedure on the case.
Physical Status UnitsThe number of physical units for each procedure on the case.
Total UnitsThe sum of base, time, and physical units billed.
Work RVUThe total work Relative Value Units on a procedure configured in the fee schedule.
Cases CountThe total number of cases as per the groupingsCustom Fields.


Available Report Filters

of Service - Data is displayed based on the date of service of Posted posted

Option

Type

Required

Description

Date ModeDrop DownNo

Determines how the results are grouped and ordered:

  • Accounting Date
  • - Groups and orders by the Accounting Date of the charge
  • Date

  • of Service - Data is displayed based on the

  • date of service of the charge


Date

Drop DownYes
Filters charges displayed by the selected time period. Options include: Custom Date Range, Last # of Days, Today, Previous Day, Current Month, Previous Month, Current Year, and Previous Year.


Note

If Custom Date Range is selected, the From and To fields are enabled to enter specific dates to run the query on.

If Last # of Days is selected, the Last # of Days field is enabled to enter a specific number of days to run the query on.


Warning
The maximum timespan for the report is 31 days.


Practices List SelectionNoFilters by all practices or one or more practices for which charges were billed. By default, this filter is set to All
Providers List SelectionNoFilters by all providers or by one or more providers. By default, this filter is set to All.
Provider GroupList SelectionNoFilters by one or more pre-designated groups of specific providers. By default, this filter is set to All.
Referring ProvidersList SelectionNoFilters by all referring providers or by one or more referring providers. By default, this filter is set to All.
Facilities List SelectionNoFilters by all facilities or by one or more facilities where services were rendered. By default, this filter is set to All.
Payers List Selection NoFilters by payer to which the claims were submitted. By default, this filter is set to All.
Plans List SelectionNoFilters by plan to which claims were submitted. By default, this filter is set to All.
Financial Class List SelectionNoFilters by all financial classes or by one or more financial classes.
Case Reporting Types List SelectionNoFilters by case reporting types. By default, this filter is set to All.
Procedure Categories List SelectionNoFilters by system and custom procedure categories. System-defined procedure categories are identified as (System), for example, Anesthesia (System). User-defined procedure categories are identified as (Custom), for example, Pain Management (Custom). By default, this filter is set to All.
Types of Service List SelectionNoFilters by all types of service or by one or more types of service. By default, this filter is set to All.
Place of Service List SelectionNoFilters by all places of service or by one or more places of service. By default, this filter is set to All.
CPT From/ToText EntryNoFilters by all CPT Codes in the entered range.
ASA From/ToText EntryNoFilters by all ASA Codes in the entered range.
Include Zero BalancesCheckboxNoFilters by account balances, including those with zero balances. This filter does not include reversed service lines from rebill option 1.
Include Reversed CasesCheckboxNoFilters by cases, including reversed cases. The filter is unchecked by default and will not include reversed cases in search results unless checked.
Primary / Secondary / Tertiary Group ByDrop Down Yes 

These groups allow for arbitrary selection of up to three variables.

  • Displays all transactions that carry the Primary group attribute, then;

  • Filters within the Primary group those transactions that carry the Secondary group attribute, and;

  • Filters within the Secondary group those transactions that carry the Tertiary group attribute.

Options include: None, Practice, Facility, Rendering Provider, Payer, Plan, Case Reporting Type, Date of Service, Procedure Category, Procedure Code.

Report FolderDrop DownYesDesignates where to place or save the output from the executed report.




 

Panel
titleColorWhite
titleBGColorGray
titleRelated Topics

Portal

Reports (Portal)



Search this documentation

Livesearch
spaceKeyCD