Overview
Purpose
This report analyzes monthly transactions for a 13 month accounting range.
This itemized report summarizes the monthly transaction activity of AR and Non-AR transactions. Use this report to compare the totals in active AR for the current month/current year to date with the same month of the previous year/previous year to date.
Category
Financial
Type
Summary
Mode
Accounting
Output Options
CSV or Excel
Sample Reports
(Click an image to enlarge)
Portal
Back Office
Field Definitions
Field | Calculation Formula | Description |
|---|---|---|
| Primary / Secondary / Tertiary Group By | Displays the value for the selected Primary Group By, Secondary Group By, and Tertiary Group By filters. | |
| Month (DOS) | Horizontal listing by month of the previous 13 months, to capture all financial activity. | |
| Beginning Balance | The balance of the account at the beginning of the time period. | |
| Charges Billed | The amount billed for total charges for each service fee. | |
| Cases | The number of cases for the month. | |
| Procedures | The number of procedures for the month. | |
| Anesthesia Units | Total number of base, time, and physical status units for a specific service fee. | |
| RVU - Work | The total work Relative Value Units on a procedure configured in the fee schedule. | |
| Total Expected | The total dollar amount of reimbursement expected for services rendered from the payer or plan. | |
| Payments - Line Items | Total of payments received and applied to a service fee. | |
| Payments - On-Account | Total of payments received and applied to a guarantor account as a credit balance. | |
| Contractual Write-off | The disallowed amount entered on the payment, which is taken as a negative adjustment. | |
| Insurance Withhold | The amount being withheld by the payer, as indicated by the EOB. | |
| Refunds from AR | The sum of refund transactions directly reversed from guarantor or insurance payments. | |
| Adjustments - Misc | The sum of line item adjustments taken from the active AR or guarantor payment entry. | |
| External Collections | Indicates any amount of the case service fee line that is included in an external collections case. This field also includes the service fees transferred from External Collections to Account Receivable (EXTRF) transactions. | |
| Net Activity | A sum of all the itemized transactions. | |
| Ending Balance | The balance of the account at the end of the time period. | |
| Payments - Suspense | Total of payments received and applied to the suspense repository. It is a non-AR distribution. | |
| Payments - Misc Income | Total of payments received and applied to the miscellaneous income repository. It is a non-AR distribution. | |
| Refunds Suspense - Misc Income | The sum of refund transactions directly reversed from suspense and miscellaneous income repositories. | |
| Beginning Balance - Ext Coll | The beginning balance of external collection transactions written off of the active AR. | |
| Payments - Ext Coll | The sum of payment distributions to external collection accounts. | |
| Adjustments - Ext Coll | The sum of adjustment transactions applied to external collection accounts. | |
| Transfers - Ext Coll | The sum of services lines transferred off the active AR to external collections. | |
| Ending Balance - Ext Coll | The balance for external collection accounts at the end of the accounting period. | |
| Avg Daily Charges | Charges Billed / Days in Month | The total charges billed on average per day. |
| Avg Charge/Case | Charges Billed / Cases | The charges billed on average per case per day. |
| Avg Charge/Procedure | Charges Billed / Procedures | The charges billed on average per procedure per day. |
| Avg Daily Payments | [Sum of Payments - All (Line Items, On-Account, Suspense, Misc Income, Ext Coll)] / Days in Month | The total payments received on average per day. |
| Avg Payment/Case | (Payments - Line Items) / Cases | The payments received on average per case per day. |
| Avg Payment/Procedure | (Payments - Line Items) / Procedures | The payments received on average per procedure per day. |
| Gross Collection % | [(Payments - Refunds) * 100] / Billed Charges | The percentage of gross receivables. |
| Net Collection % | (Payments to Line Items + Refunds from AR) / (Charges Billed + Contractual Writeoff) | The percentage of net receivables. |
| Bad Debt % | External Collections / Charges Billed | The percentage of charges sent to collections. |
| Days in A/R | Current month: Ending AR Balance / (Current Month Charges / # of Days Reported) Current year: Ending AR Balance / (YTD Charges / # of Days Reported) | The number of days for which you have open balances in the AR. Days Production in AR does not include the On Account Ending Balance. # of days reported is based on the actual number of days in the reporting period, which is specified in the Accounting Day End or DOS End filters. |
Available Report Filters
Option | Type | Required | Description |
|---|---|---|---|
| Date / To | Drop Down / Free Text (Calendar) | Yes | Filters by the specified date for the ending period. If Custom End Date is selected from the Date drop down, the To field is enabled to select a date. |
| 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 one or more providers for which transactions were posted. By default, this filter is set to All. |
| Facilities | List Selection | Yes | 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 Selection | Yes | Filters by all payers or by one or more specific payers for which transactions were posted. By default, this filter is set to All. |
| Plans | List Selection | Yes | 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 Selection | Yes | Filters by all financial classes or by one or more financial classes for which transactions were posted. By default, this filter is set to All. |
| Show External Collections Summary | Checkbox | No | If selected, the Ext Coll line items are displayed in the summary. If not selected, they are omitted from the display. |
| Primary/Secondary/Tertiary Group By | Drop Down | No | These groups allow for arbitrary selection of up to three variables.
Options include: None, Practice, Facility, Provider, Financial Class, Payer, Plan, Case Reporting Type. When the financial activity is grouped by None, transactions not associated with a particular facility or provider are shown for every facility or provider. When the financial activity is grouped by Facility or Provider, only those transactions associated with the particular facility or provider are shown for that facility or provider. Transactions not associated with a particular facility or provider are shown as None for the facility or provider, as applicable. |
| Report Folder | Drop Down | Yes | Designates where to place or save the output from the executed report. |