Overview

Purpose

The Financial Activity Summary - Detail Reports provide analysis of account transactions at a detailed level.

Specifically, the Payments to Line Items Detail report analyzes Payments to Line Items detail for the Financial Activity Summary.

Category

Financial

Type

Detail

Mode

Accounting / Posted

Output Options

CSV or Excel

How to Get Here?

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

 

Sample Reports

(Click an image to enlarge)

Portal

Back Office 


Field Definitions

Field

Description

PracticeThe practice for which the charge is being billed.
Account IDThe account number of the guarantor account.
Payment Batch IDThe unique number assigned to the payment batch.
Case IDThe unique number assigned to the case.
Facility Case NumberThe case number issued by the facility, i.e., Medical Record Number.
Case Reporting TypeThe unique code assigned to the case for identifying the case for reporting purposes.
PatientThe name of the patient.
Patient DOBThe date of birth of the patient.
GuarantorThe name of the person on the guarantor account.
FacilityThe name of the facility where services were rendered. 
Place of ServiceIndicates where services for the facility are rendered.
Rendering ProviderThe name of the provider who rendered services on the case.
Rendering Provider NPIThe national provider identification number issued to the rendering provider.
Referring ProviderThe name of the physician who referred the patient.
Referring Provider NPIThe national provider identification number issued to the referring provider.
Primary Financial ClassIndicates the primary plan grouping of the case. Financial class is used for reporting purposes.
Primary PayerThe primary insurance payer on the case with financial responsibility for the outstanding debt.
Primary PlanThe primary insurance plan on the case to which charges were billed.
Secondary PayerThe secondary payer on file for claims submission.
Secondary PlanThe secondary insurance plan on file for claims submission.
Tertiary PayerThe tertiary payer on field for claims submission.
Tertiary PlanThe tertiary insurance plan on file for claims submission.
Date of Service - ProcedureThe date of service for ancillary procedures.
Anesthesia MethodMethod used to administer anesthesia, e.g., General, Regional.
Type of ServiceThe type of procedure: Anesthesia or General.
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.
Modifier 1

The primary concurrency modifier entered on the case.

Modifier 2 - 6

The second - sixth procedure modifiers entered on the case.

Payment Type

The type of payment, as entered during creation of the payment. Values include:

  • Insurance
  • Guarantor
  • Collection
Transaction TypeThe type of transaction used for the payment, e.g., credit card, check.
Check NumberThe check number of the check making the payment.
Check AmountThe amount of the check payment.
RemitterThe name of the person or payer who remitted the payment.
Rank

The rank designation of the payer as primary, secondary, tertiary 1, and tertiary 2.

ValueDescription
1The payer holds the primary responsibility for reimbursement.
2The payer holds the secondary responsibility for reimbursement.
3The payer holds the first position tertiary responsibility for reimbursement.
4The payer holds the second position tertiary responsibility for reimbursement.
Transaction Code

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

Example transaction codes:

  • GPYMT (Guarantor Payment)
  • IPYMT (Insurance Payment)
  • RVPAY (Reverse Payment)
  • RVACC (Reverse Payment - Move to On-Account)
  • RVSUS (Payment Reversal - Transfer to Suspense)
  • SDISTR (Suspense Distribution to Guarantor)
  • RSCND (Rescinded Payment)
  • RVRSC (Reversal Rescinded Payment)
Transaction DescriptionThe description of the transaction code.
Transaction AmountThe amount of the transaction. Each transaction is shown as an individual line item.
Accounting Date

The date selected at the time the transaction was posted.


This may not always be the same as the Posted Date, as the user can manually select the Accounting Date.
Posted DateThe date the transaction was posted to the guarantor account.
Root ID

Identification number of a service line item in AR.

The Root ID is assigned to the main service line and all sub-line items are assigned to the same Root ID.

Available Report Filters

Option

Type 

Required 

Description

Date Mode

Drop Down

Yes

Determines how the results are grouped and ordered:

  • Accounting Date - Groups and orders transactions by the Accounting Date entered during payment entry.

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

DateDrop DownYes

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.

By default, this filter is set to Current Month.

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.

Practices

List SelectionYes

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

Only active practices are returned in the search results.

Providers

List SelectionYes

Filters by all providers or by one or more providers for which transactions were posted. By default, this filter is set to All.

Facilities

List SelectionYes

Filters by all facilities or by one or more facilities for which transactions were posted. By default, this filter is set to All.

Payers

List SelectionYes

Filters by all payers or by one or more payers for which transactions were posted. By default, this filter is set to All.

Plans

List SelectionsYes

Filters by all plans or by one or more plans for which transactions were posted. By default, this filter is set to All.

Financial Class

List SelectionYes

Filters by all transaction financial classes or by one or more financial classes by which transactions were classified. By default, this filter is set to All.

Report OutputDrop DownYesDesignates which detail report to run from the Financial Activity Summary.
Report FolderDrop DownYesDesignates where to place or save the output from the executed report.


 

Related Topics

Portal

Reports (Portal)



Search this documentation



  • No labels