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 |
|---|---|---|
| Beginning Balance | The balance of the account at the beginning of the time period. | |
| Charges Billed | UPDATE | |
| Cases | The number of cases for the month. | |
| Procedures | The number of procedures for the month. | |
| Anesthesia Units | Billed Total Units * Accounting Status | UPDATE |
| RVU - Work | RVU - (Work * Accounting Status) | The total work Relative Value Units on a procedure configured in the fee schedule. |
| Total Expected | Expected * Accounting Status | UPDATE |
| Payments - Line Items | UPDATE | |
| Payments - On-Account | UPDATE | |
| Contractual Write-off | The disallowed amount entered on the payment, which is taken as a negative adjustment. | |
| Insurance Withhold | UPDATE | |
| Refunds from AR | UPDATE | |
| Adjustments - Misc | UPDATE | |
| 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 | Charges Billed – (Payments + All Adjustments) | UPDATE |
| Ending Balance | The balance of the account at the end of the time period. | |
| Payments - Suspense | UPDATE | |
| Payments - Misc Income | UPDATE | |
| Refunds Suspense - Misc Income | UPDATE | |
| Beginning Balance - Ext Coll | UPDATE | |
| Payments - Ext Coll | UPDATE | |
| Adjustments - Ext Coll | UPDATE | |
| Transfers - Ext Coll | UPDATE | |
| Ending Balance - Ext Coll | UPDATE | |
| Avg Daily Charges | Charges Billed / Days in Month | UPDATE |
| Avg Charge/Case | Charges Billed / Cases | UPDATE |
| Avg Charge/Procedure | Charges Billed / Procedures | UPDATE |
| Avg Daily Payments | [Sum of Payments - All (Line Items, On-Account, Suspense, Misc Income, Ext Coll)] / Days in Month | UPDATE |
| Avg Payment/Case | (Payments - Line Items) / Cases | UPDATE |
| Avg Payment/Procedure | (Payments - Line Items) / Procedures | UPDATE |
| Gross Collection % | [(Payments - Refunds) * 100] / Billed Charges | UPDATE |
| Net Collection % | ([Payments - Refunds] * 100) / (Charges - Contractual Write Off) | UPDATE |
| Bad Debt % | External Collections / Charges Billed | UPDATE |
| Days in A/R | UPDATE |
Available Report Filters
Option | Type | Required | Description |
|---|---|---|---|
| Date / To | Drop Down / Free Text (Calendar) | Yes | Filters by the specified date for the ending period. |
| 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. |
| 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 | UPDATE |
| Show External Collections Summary | Checkbox | No | UPDATE |
| 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. 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. |