Overview
| Panel | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||
|
Sample Reports
(Click an image to enlarge)
Back Office
Field Definitions
Field | Calculation Formula | Description |
|---|---|---|
| Current Month |
| The totals of the accounts receivable items for the current month. | |
| Previous YM |
| The totals of the accounts receivable items for the same month of previous year. | |
| Current YTD |
| The year-to-date totals of the accounts receivable items for the current year. | |
| Previous YTD |
| The year-to-date totals of the accounts receivable items for the previous year. | ||
| AR |
AR Balance at Beginning of Period |
The balance of the account at the beginning of the time period. | |
| Charges Billed |
| The amount billed for total charges for each service fee. | ||
| Payments to Line Items |
| Total of payments received and applied to a service fee. | |
| Payments Posted to 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. | |
| MIsc Adjustments |
| 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 | Charges Billed – [Payments + (All Miscellaneous Transactions + Refunds)] | A sum of all the itemized transactions.
| ||
| Ending Balance | AR Balance at Beginning of Period + Net Activity | The balance of the account at the end of the time period. | ||
| Days Production in AR | 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.
| ||
| Net Collection % | (Payments to Line Items + Refunds from AR) / (Charges Billed + Contractual Writeoff) | The percentage of net receivables. | ||
| Non-AR |
| Payments Posted to Suspense |
| Total of payments received and applied to the suspense repository. It is a non-AR distribution. | |
| Payments Posted to Misc Income |
| Total of payments received and applied to the miscellaneous income repository. It is a non-AR distribution. | ||
| Refunds from Suspense & Misc Income |
| The sum of refund transactions directly reversed from suspense and miscellaneous income repositories. | ||
| External Collections |
| Balance at Beginning of Period |
| The beginning balance of external collection transactions written off of the active AR. | |
| Transfers |
| The sum of services lines transferred off the active AR to external collections. | |
| Payments Posted to External Collections |
The sum of payment distributions to external collection accounts. | ||
| Adjustments |
| The individual adjusted amounts on the service fee line. | |
| Ending Balance |
| The balance for external collection accounts at the end of the accounting period. | ||
| Totals |
| Total Payments | Payments to Line Items + Payments Posted to On Account + Payments Posted to Suspense + Payments Posted to Misc Income + Payment Posted to External Collections | The sum of payments posted to the active AR and non-AR, combined. |
| Total Refunds | Refunds from AR + Refunds from Suspense & Misc Income | The sum of refund transactions directly reversed from guarantor or insurance payments. |
Available Report Filters
Option | Type | Required | Description |
|---|---|---|---|
Accounting Date Begin / Accounting Date End | Drop Down | Yes | Filters transactions displayed by the selected time period |
| 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. |
.
| |||||
Primary/Secondary/Tertiary Group By | Drop Down | Yes | These groups allow for arbitrary selection of up to three variables.
| ||
| Show External Collections | Checkbox | No | If selected, External Collections transactions are included in the report output. By default, the option is not selected |
| . | |||
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. |
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. |
Providers | List Selection | Yes | Filters by all |
providers or by one or more |
providers for which transactions were posted. By default, this filter is set to All. |
Financial Classes | List Selection | Yes | 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. |
Payers | List |
| Selection | Yes | 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 |
| Selections | Yes | Filters by all |
plans or by one or more |
plans for which transactions were |
posted. By default, this filter is set to All. |
Primary/Secondary/Tertiary Group By
These groups allow for arbitrary selection of up to three variables.
Displays all transactions that carry the Primary group attribute, then;
Filters within the Primary group those transactions that carry the Secondary group attribute, and;
Filters within the Secondary group those transactions that carry the Tertiary group attribute
Note 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.
| Output Options | Radio Selection | Yes | There are three output options available for the reports: View/Print, CSV, Excel, PDF. By default, the View/Print option is selected for the report. |