Overview

This article will cover how to Assign Lines and Columns under the GL Mappings section for Worksheets A and C. The Assign Lines relates to mapping a department to a Medicare Cost Report Line. The Assign Columns relates to mapping the classified Operating Expense and Revenue accounts to the specific Column on Worksheet A and C that they relate to.

Assign Lines

Select the GL Account

For a new report that does not have prior year mappings assigned to it, the user will need to first select the GL defined accounts that should be used for assigning to the Medicare lines on Worksheet A and C; the defined department from the uploaded GL is usually the most appropriate in assigning lines. This process will be the same for both sections. 

To complete the line assignments for Worksheet A, click on from the Dashboard. To complete the line assignments for Worksheet C, click on from the Dashboard. 

To select the accounts, click on . This will show the user the fields from the GL that were identified as accounts in the Define GL Headers section. Select the appropriate account level by checking the box next to the field and selecting the green circle to confirm. This will populate all of the GL data for that field.

To Assign Lines

The departments that need to be mapped will present at the top of the page under the Accounts to Assign. If the report utilized a prior year report for mappings, then the departments that were mapped in the prior year will automatically assign consistent with that report. Any new departments will be listed under the Accounts to Assign section. Below that, the user will see the standard Worksheet A Lines available in Absolute for the departments to be assigned to.

To assign a department to a Worksheet A Line, first the user must select the appropriate line, which will be highlighted blue. The next step is for the user to click on the department above, which will automatically move the department down to that highlighted line. 

The user can review each department that has been assigned by clicking on each line. To remove a department from the line assignment, click on the "X" to the right of the department.

To Import Assignments

For information on how to Import Assignments for Worksheet A and Worksheet C, see related article Import Assignments. 

To Edit a Line Description 

To edit a line description, first click on the line that needs to be edited, then click the button. A text input box will open, where the description can be edited. Once updates are made, click O to confirm or click the X  to cancel the changes. 

To Insert a Line

To insert a new subscript for an existing line, first highlight the line the subscript will need to be added to, then click on . This will open up a text input box where the line subscript and line description can be added. When entering the new subscripted line, the user only needs to enter the subscript (i.e. to add line 194.01, enter "01" in the Suffix field, not "194.01"). Once updated, click on the O  to confirm or click the X to cancel the changes.

To Complete Assign Lines

When all updates and modifications are complete, click on to mark the section complete. Please NOTE that all departments must be mapped to a line number before Absolute will allow you to mark the section complete. This process is the same for both the Worksheet A Expense and Worksheet C Revenue line assignments. 

Assign Columns

Select the GL Account

For a new report that does not have prior year mappings assigned to it, the user will need to first select the GL defined accounts that should be used for assigning to the appropriate Columns on Worksheet A and C, the defined account level detail from the uploaded GL is usually the most appropriate field. This process will be the same for both sections.

To complete the column assignments for Worksheet A, click on from the Dashboard. To complete the line assignments for Worksheet C, click on  from the Dashboard. 

To select the accounts, click on . This will show the user the field from the GL that were identified as accounts during the Define GL Headers section. Select the appropriate account level by checking the box next to the field and selecting the green circle to confirm. This will populate all of the GL data for that field.

Assign a Column

To assign an account to the appropriate column, click on the box to the left of the account, ensure that the correct column is selected prior to assigning the accounts, and then click on the Assign Selected button in the middle of the page to move the accounts.

There is also the option to Select All or Deselect All accounts for faster assignment of accounts. 

Remove Assigned Accounts

To remove accounts that have already been assigned to a column, click on the box next to the account, and then click the Remove Selected button. This will move the accounts back to the Accounts to Assign section above. 

To Complete Assign Columns

When all updates and modifications are complete, click on  to mark the section complete. Please NOTE that all accounts must be mapped to a column before Absolute will allow you to mark the section complete.