Overview
Purpose
This report analyzes monthly or daily transactions for a specified date range.
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 Group By | Displays the value for the selected Primary Group By filter. | |
| Secondary Group By | Displays the value for the selected Secondary Group By filter. | |
| Tertiary Group By | Displays the value for the selected Group By filter. | |
| Billed | Charges Billed on Financial Activity Summary | Total charges billed for the specified date range. |
| Payments | Payments to Line Items on Financial Activity Summary | The total amount of payments posted to the service fee line for the specified date range. |
| Refunds | Refunds from AR on Financial Activity Summary | The total amount of refunds, or payments reversed, and posted from the account for the specified date range. |
| Adjustments | CWO + Adjustments + External Collections + Withholds on Financial Activity Summary | The individual adjusted amounts on the service fee line for the specified date range. |
| YTD Charges | Total charges billed for the year to date. | |
| YTD Payments | The total amount of refunds, or payments reversed, and posted from the account for the year to date. | |
| YTD Refunds | The total amount of payments posted to the service fee line for the year to date. | |
| YTD Adjustments | The individual adjusted amounts on the service fee line for the year to date. |
Available Report Filters
Option | Type | Required | Description |
|---|---|---|---|
| Date | Drop Down | Yes | 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. 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. The maximum timespan for the report is 366 days. |
| Primary/Secondary/Tertiary Group By | Drop Down | No | These groups allow for arbitrary selection of up to three variables.
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. |
| Practices | List Selection | No | 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 | No | Filters by all providers or by one or more providers. By default, this filter is set to All. |
| Facilities | List Selection | No | Filters by all facilities or by one or more facilities where services were rendered. 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. |