Avatar PM 'Summary Trial Balance Report'
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Summary Trial Balance Report
Scenario 1: 'Summary Trial Balance Report' - Verification of report results
Steps
- Open Avatar PM 'Summary Trial Balance Report' form (under 'Avatar PM / Billing / Billing Reports / Monthly Closeout Reports' menu).
- Enter/select values for 'Summary Balance As Of ', 'Aging Category' and 'Include Bad Debt Information' report criteria fields.
- Click 'Process' button to run report/render result data.
- Ensure that 'Summary Trial Balance Report' results are rendered/displayed in the default report format within myAvatar/Avatar NX.
- In 'Summary Trial Balance Report' results display, ensure that the following information fields are present:
- 'Run Date' (current date)
- 'As Of' (from 'Summary Balance As Of' report criteria field)
- 'Revenue Group'
- 'Unbilled' report information
- 'Financial Class'
- 'In-House' (with dollar values)
- 'Disc' (discharged; with dollar values)
- 'Days' (with value)
- 'Total'/'Totals' (with dollar values)
- 'Billed' report information
- 'Financial Class'
- Aging Categories (default or custom entered/edited values as defined in 'Aging Category' report criteria field; '0', '30', '120', etc; with dollar values)
- 'Total'/'Totals' (with dollar values)
- Ensure that 'Summary Trial Balance Report' results display includes information/dollar values for all fields/groupings noted above with expected values based on unbilled/billed services and payments present in Avatar PM system for selected 'Summary Balance As Of' report criteria date, including 'Total'/'Totals' calculated values.
- Ensure that Summary Trial Balance Report' results display includes 'ALL' Revenue Group summary information (summary totals for report information); ensure that 'ALL' Revenue Group summary information includes information/dollar values for all fields/groupings noted above display with expected values based on unbilled/billed services and payments present in Avatar PM system for selected 'Summary Balance As Of' report criteria date, including 'Total'/'Totals' calculated values.
- In 'Summary Trial Balance Report' results display, click 'Print All Pages', 'Print Page', 'Export All Pages' and/or 'Export Page' button to print or export/save report data as desired.
- Click 'Close' button to close 'Summary Trial Balance Report' results display.
Scenario 2: 'Summary Trial Balance Report' - Verification of .CSV format report results
Steps
- Open Avatar PM 'Summary Trial Balance Report' form (under 'Avatar PM / Billing / Billing Reports / Monthly Closeout Reports' menu).
- Enter/select values for 'Summary Balance As Of ', 'Aging Category' and 'Include Bad Debt Information' report criteria fields.
- Ensure 'Export Detail Information to CSV' field is present in form, with 'Yes' checkbox/selection available.
- No selection in the 'Export Detail Information to CSV' field will render report results in the default report format
- Selecting 'Yes' in the 'Export Detail Information to CSV' field will display report results in CSV (comma-separated value) format (allowing user to export/save 'Summary Trial Balance Report' results for external use)
- Click 'Process' button to run report/render result data.
- If no value is selected in 'Export Detail Information to CSV' field, ensure that 'Summary Trial Balance Report' results are rendered/displayed in the default report format.
- If 'Yes' is selected for 'Export Detail Information to CSV' field, ensure that 'Summary Trial Balance Report' results are rendered/displayed in .CSV format within myAvatar/Avatar NX, with following header and individual data rows present:
- 'Summary Trial Balance Report' .CSV format data header (first row in report data results) will contain the following data elements:
- 'RRG'
- 'RRG Description'
- 'Financial Class'
- 'Financial Class Description'
- 'Unbilled In-House'
- 'Unbilled Disch'
- 'Days'
- Aging Categories (default or custom entered/edited values as defined in 'Aging Category' report criteria field; 'Aging 0', 'Aging 30', 'Aging 60', 'Aging 120', etc.)
- Header row examples:
- "RRG,RRG Description,Financial Class,Financial Class Description,Unbilled In-House,Unbilled Disch,Days,Billed/Aging Category 0,Billed/Aging Category 30,Billed/Aging Category 60,Billed/Aging Category 90,Billed/Aging Category 120,Total"
- "RRG,RRG Description,Financial Class,Financial Class Description,Unbilled In-House,Unbilled Disch,Days,Billed/Aging Category 5,Billed/Aging Category 10,Billed/Aging Category 20,Billed/Aging Category 30,Billed/Aging Category 40,Billed/Aging Category 50,Billed/Aging Category 60,Total"
- 'Total'
- 'Summary Trial Balance Report' .CSV format individual data rows (second and all subsequent rows in report data results) will contain report data for each element, one row per result.
- Data row examples:
- "5,Outpatient Substance Abuse,7,Medicare Part A,2397.15,0.00,0,1181.21,0.00,0.00,0.00,815.00,4393.36"
- "1,Inpatient Psychiatric,10,Non-Recoverable,18635.12,6000.50,0,3360.52,88.00,1500.00,200.00,6526.80,40022.44"
- "5,Outpatient Psychiatric,3,Blue Cross,1176903.89,0.00,0,1476.11,0.00,0.00,0.00,0.00,0.00,12365.15,1190745.15"
- In 'Summary Trial Balance Report' results display, click 'Export All Pages' or 'Export Page' button to export/save .CSV format report data to file.
- Open/review exported .CSV format file, ensuring that data header and all individual data rows are present in file as displayed/defined above.
|
Topics
• NX
• Summary Trial Balance Report
|
