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 analyzes miscellaneous adjustments applied to the account on the Active AR tab by patient, amount, facility, account, transaction code, or accounting period. The report is a summary of miscellaneous adjustments made within a specified period. The Account Adjustment Analysis report does not include adjustments that were applied during payment entry, for example, contractual writeoff.

Category

Financial

Type

Detail

Mode

Accounting / Posted

Output Options

CSV or Excel


Info
titleBGColoraaaaaa
iconfalse
titleHow to Get Here?


From Portal:
From Back Office:
  1. From the Reports tab, locate the Account Adjustment Analysis Detail 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 Account Adjustment Analysis Detail report from the list of reports.
  3. Click Run (or press [Alt] + [
M
  1. R]).
  2. Enter/select the filter criteria from the Parameters window.
  3. Click Run (or press [Alt] + [
M
  1. R]).



 

Sample Reports

(Click an image to enlarge)

Portal

Image Removed 

 Image Added

Back Office

Image Modified

 



Field Definitions

Field

Calculation Formula

Description

Practice
 
The practice for which the charge is being billed.
Account ID
 
The account number of the guarantor account. Displays as Account Prefix + Account ID.
Guarantor 
 
The name of the person on the guarantor account.
Patient 
 
The name of the patient.
Facility 
 
The name of the facility where services were rendered. 
Facility Case IDThe identification number assigned to the case by the facility, for example, the hospital medical record.
Case Reporting TypeThe list of categories that can be associated to a case for reporting purposes, for example, Cardio (for treatments associated with the heart and lungs).
Rendering Provider
 
The name of the provider who rendered services on the case.
PayerThe primary insurance payer on the case with financial responsibility for the outstanding debt.
PlanThe primary insurance plan on the case to which charges were billed.
Date of ServiceThe date the service is rendered.
Billed AmountThe billed amount of the procedure to which the adjustment was applied.
BalanceThe current balance of the procedure to which the adjustment was applied.
CPT 
 
The general procedure code that was entered as the procedure billed on the case in charge entry.
ASA 
 
The anesthesia procedure code that was entered as the procedure billed on the case in charge entry.
Date of Service The date the service is rendered.Accounting Date  The date within the accounting period when the adjustment was posted. The accounting date is stored at the practice configuration in Connect Back Office.Posted Date  The date the adjustment transaction was posted to the guarantor account.Posted By UPDATETransaction Code  The code for the type of transaction that was applied to the account, for example, CHAR = Charity Adjustment.
Modifier 1

The primary concurrency modifier entered on the case.

Modifier 2 - 4

The second - sixth procedure modifiers entered on the case.

Transaction Code 

The code for the type of adjustment applied to the account.

Info

Example transaction codes:

  • MADJN (Negative Adjustment)
  • MADJP (Positive Adjustment)
  • RVADJ (Reversed Payment Adjustment) 


Transaction Description 
Transaction Description  
The description of the transaction code used as the adjustment.
Transaction Subcode
 

The user-defined adjustment code. This is the Type field value from created adjustment codes.

Info
Example: CHAR
UPDATE


Transaction Subcode Description
 UPDATE

The description of the user-defined adjustment code. This is the Description field value from created adjustment codes.

Info
Example: Charity Adjustment


Adjustments
Adjustment Amount  
The amount of the adjustment transaction. Each adjustment is shown as an individual line item.
Accounting Date

The date selected at the time the adjustment was posted.

Note
This may not always be the same as the Posted Date, as the user can manually select the Accounting Date.


Posted Date The date the adjustment transaction was posted to the guarantor account.
Posted ByThe person who posted the adjustment transaction to the guarantor account.


Available Report Filters

Option

Type

Required

Description

Date ModeDrop DownYes

Determines how the results are grouped and ordered:

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

  • Posted Date - Groups and orders by the date the transaction was posted to the account.

DateDrop Down Yes 

Filters transactions 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 366 days.


PracticesList Selection Yes

Filters by all practices or one or more practices for which adjustments were applied. By default, this filter is set to All Practices

Date Mode

Note

Only active practices are returned in the search results.

Transaction SubcodeDrop Down
Yes

Options include:

  • Accounting Date
  • Posted Date
NoFilters transactions displayed by the selected transaction subcode.
Include Zero BalancesCheckboxNo Filters by account balances, including those with zero balances. This filter does not include reversed service lines from rebill option 1.
Date
Report Folder
 
Drop Down
 UPDATEFrom

Free Text

(Date)

 Filters by beginning date from which adjustment transactions were posted. To

Free Text

(Date)

 Filters by ending date to which adjustment transactions were posted. Last # of Days   UPDATE

 

YesDesignates where to place or save the output from the executed report.




 

 

Panel
titleColorWhite
titleBGColorGray
titleRelated Topics

Portal

Reports (Portal)

 

 



Search this documentation

Livesearch
spaceKeyCD