Overview
Purpose
This report analyzes posted external collection transactions and related financial activity for a specified date range.
Category
Management
Type
Detail
Mode
Accounting / Posted / Entry
Output Options
CSV or Excel
Sample Reports
(Click an image to enlarge)
Portal
Back Office
Field Definitions
Field | 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. |
| Case ID | The unique number assigned to the case. |
| Patient | The name of the patient. |
| Patient DOB | The date of birth of the patient. |
| Guarantor | The name of the person on the guarantor account. |
| Facility | The name of the facility where services were rendered. |
| Rendering Provider | The name of the provider who rendered services on the case. |
| Referring Provider | The name of the provider who referred the patient. |
| Payer | The 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. |
| Date of Service - Procedure | The date of service for ancillary procedures. |
| 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. |
| Current Agency | The external collection agency current assigned to the account. |
| Billed | The amount billed for the procedure. |
| Net Payments - AR | The net amount of the payments in AR (Gross Payments – Commission = Net Payments). |
| Contractual Adjustments - AR | Any contractual write-off (e.g., CWOFF, RVCWO, ADCWO) adjustments on the service line in AR. Can have a positive or negative effect on the balance. |
| Adjustments - AR | Any non-contractual adjustments (e.g., MADJN, MADJP) on the service line in AR. Can have a positive or negative effect on the balance. |
| Net Payments - External | The net amount of the external collection payments (Gross Payments – Commission = Net Payments) applied to the external collection transactions. |
| Net Commission - External | The net fees paid to the external collection agency. |
| Adjustments - External | Any adjustments on the service line. Can have a positive or negative effect on the balance. |
| Balance - External | The current balance of the service fee line transferred to external collections. |
| Transfer Date | The date the account was transferred to external collections. |
| Approval Date | The date the account was approved for transfer to external collection. |
| 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. |
Available Report Filters
Option | Type | Required | Description |
|---|---|---|---|
| Date Mode | Drop Down | Yes | Determines how the collection results are grouped and ordered:
|
| Date | Drop Down | Yes | 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. 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 Selection | Yes | 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 Selection | Yes | Filters by all providers or by one or more providers. By default, this filter is set to All. |
| Facilities | List Selection | Yes | Filters by all facilities or by one or more facilities where services were rendered. By default, this filter is set to All. |
| Agencies | List Selection | Yes | Filters by all agencies or by one or more agencies for external collection services. By default, this filter is set to All. |
| Report Folder | Drop Down | Yes | Designates where to place or save the output from the executed report. |