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 generates a summary list of all accounts within the insurance collections queue.

Category

Management

Type

Detail

Mode

Not applicable

Output Options

CSV or Excel


Info
titleBGColoraaaaaa
iconfalse
titleHow to Get Here?


From Portal:
From Back Office:
  1. From the Reports tab, locate the Insurance Collection Queue 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 Insurance Collection Queue Detail 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 Added

Back Office



Field Definitions

Field

Description

PracticeThe practice to which the charge was billedpractice associated with the collection task.
AccountThe account number of the guarantor account. Displays as Account Prefix + Account ID. 
CaseThe unique number assigned to the case.
Patient

The name of the patient.

Patient DOBThe date of birth of the patient.
FacilityThe name of the facility where services were rendered.  
ProviderThe physician that renders rendered services.
RankThe order in which the payer has financial responsibility when there is more than one payer.
DOSThe date the services were rendered.
CPTThe general procedure code that was entered as the procedure billed on the case in charge entry.
ASAThe anesthesia procedure code that was entered as the procedure billed on the case in charge entry.
Billed AmountThe total amount that was billed for total charges for each procedurethe service line item.
Expected AmountThe expected amount of payment from the responsible party for the amount billed, which is determined by the expected fee schedule configured at the practice configuration.
BalanceThe current balance of the procedure when action is takenon the guarantor account.
AgeThe age of the collection line item.
Last ActionThe last action taken in the collection effort.
Last Action DateThe last date that action was taken in the collection effort.
Next Action The next action that is scheduled on the service fee lineto be taken in the collection effort.
Next Action Date The date the next action will occur.
Collector The person who is assigned to the collection task.
Collector GroupThe name of the collector group to which the task is assigned.
Member NumberThe unique number issued by the payer to identify the patient who participates in a group plan.
Group NumberThe unique number issued by the payer to the owner of the insurance policy.
Last Denial CodeThe group and reason code for the last payment for the responsible insurance plan.
Total Number of ActionsThe total number of actions associated to the collection line item.
GuarantorThe guarantor on the account.
Guarantor DOBThe date of birth of the guarantor.
Guarantor Address 1The street address of the guarantor.
Guarantor Address 2The street address (line 2, if applicable) of the guarantor.
Guarantor CityThe city of the guarantor's address.
Guarantor StateThe state of the guarantor's address.
Guarantor ZipThe zip of the guarantor's address.
Guarantor Day PhoneThe 10-digit telephone number (Day) of the guarantor.
Guarantor Evening PhoneThe 10-digit telephone number (Evening) of the guarantor.
SubscriberThe person who owns the insurance coverage.
Subscriber NumberThe identification number of the insurance owner.
ProcedureThe procedure performed on the case. The information is displayed with the values: CPT / ASA.
Provider NPIThe National Provider Identifier number of the provider.
Group NPIThe NPI number for the provider group (facility).
TINThe tax identification number.
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.
Plan ContactThe name of the primary contact for the plan.
Plan Address 1The address line 1 for the responsible plan.
Plan Address 2The address line 2 for the responsible plan.
Plan CityThe city for the responsible plan.
Plan StateThe state for the responsible plan.
Plan ZipThe postal zipcode for the responsible plan.
Plan PhoneThe phone number for the responsible plan.
Account StatusThe value assigned to the account to assist in grouping and searching for accounts.
Last Payment DateDate of the last patient or guarantor payment received on the account.
Last Payment AmountThe amount of the last patient or guarantor payment.
Last Payment TypeThe type of the last patient or guarantor payment.
Statement ProcessingThe status of the statements generated on the account.
Next System Statement DateThe date the system generates a statement for the account.
Returned MailSets the flag to indicate mail has been returned on the account and follow-up is needed.
Collection Transfer DateThe first date that action was taken in the collection effort.
AttachmentThe field display Yes or No depending on if there is an associated attachment.


Available Report Filters

Option

Type

Required

Description

Date

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


Practices List SelectionNo

Filters by all practices or one or more practices for which collection tasks exist. By default, this filter is set to All.

Note

Only active practices are returned in the search results.

ProvidersList SelectionNoFilters by all providers or by one or more providers for which collection tasks exist. By default, this filter is set to All.
FacilitiesList SelectionNoFilters by all facilities or by one or more facilities for which collection tasks exist. By default, this filter is set to All.
PayersList SelectionNoFilters by all payers or by one or more payers for which collection tasks exist. By default, this filter is set to All.
PlansList SelectionNoFilters by all plans or by one or more plans for which collection tasks exist. By default, this filter is set to All.
CollectorList SelectionNoFilters by all external collection agencies or by one or more external collection agencies.
Collector GroupDrop DownNo

Filters by all external collection agency groups or by one or more external collection agency groups.

CPT From/ToText EntryNoFilters by all CPT Codes in the entered range.
ASA From/ToText EntryNoFilters by all ASA Codes in the entered range.
Days Outstanding From/ToNumericNo

Filters by the designated number of days outstanding since the claim was generated.

Balance From/ToNumericNo

Filters by the designated balance on the account.

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