Worksheet A-8-1 Adjustments

A-8-1 Related Organization Overview

The A-8-1 Related Organization Cost interface allows for the compilation and analysis of related organization and home office expenses, and displays a summary for offset. The total amount offset on A-8-1 will flow to the A-8 Summary in Absolute. This section is comprised of three sections/tab as follows:

The A-8-1 Lines tab allows the user to set up the structure of the Worksheet A-8-1 lines, Worksheet A-8-1 line description, and the corresponding Worksheet A line.

The WS A Amounts tab allows the user to identify A-8-1 Column 5 amounts (expenses included in Worksheet A) either via filtered GL accounts or by entering external amounts (if these expenses aren't easily identifiable in a specific GL account).

The Allowable Expense Adjustments tab allows users to enter the Allowable Home Office or Related Party Expense for each A-8-1 Line (for A-8-1 Column 4 reporting).  This tab also generates and summarizes the total adjustments for each A-8-1 lin. 

A-8-1 Lines Tab

This tab allows for setting up the structure of Worksheet A-8-1 Lines, the A-8-1 descriptions, and the Worksheet A Lines associated with each corresponding A-8-1 Line.

To add an A-8-1 Line, the following values may be edited/input:

  • A-8-1 Line Column: Enter the A-8-1 Line. The number must be between 1-3, or 4.xx (with optional two decimal points). 
  • A-8-1 Line Description Column: Enter the applicable A-8-1 line description. The description must be 160 characters or less. This description will flow forward to the Allowable Expense Adjustments tab. 
  • A Line Column: Enter the Worksheet A Line number that the A-8-1 Line will be associated with. Only one WS A line is allowed to be associated with each A-8-1 Line. 
  • I E (Interest Expense): Check the Interest Expense box if the line will contain interest expense. This value will then flow through to the Interest Expense Adjustments section A-8 C.
  • Worksheet A-7 Reference: This value is required for A-8-1 lines affecting capital lines. The A-7 reference may be selected from the drop-down menu. Once entered, click the O to confirm, or X to cancel.

Worksheet A Amounts Tab

This tab allows for setting up A-8-1 Column 5 amounts either via account filters or by manually adding External Values (use the External Value option if expenses aren't easily identifiable in a GL account).

Account Filters:

Accounts can be selected for inclusion on A-8-1 Column 5 via account filters. The Account Selector allows the selecting of accounts for the account pool for inclusion on A-8-1 Column 5. Accounts are selected via filters, which can contain one or more rules. The accounts that fall under these rules are added to the account pool.

For more information on how to filter, please review the related article: Overview of Filters

Selected GL Accounts:

An account must either be offset, or given an explanation as to why it isn't being offset, to be considered complete.

  • Adjusting an account: Click the adjustment cell. This opens up the adjustment form. Click the Type field to open the type selector. Select the desired operation.

    Percentage - Select to adjust account(s) by a percentage (ex. 23.7% or 100.00%).

    Fixed Amount - Select to adjust account(s) by a dollar amount (ex. $100).

  • Value:  

    For a Percentage, enter the percentage to adjust by. (ex. 23%).

    For a Fixed Amount, enter the dollar value of the adjustment operation (ex. $100).

  • A-8-1 Line: From the dropdown, select the A-8-1 line number the adjustment will be applied to. The available lines in the dropdown generated will show the WS A-8-1 lines created on the "WS A-8-1 Lines" tab, which correspond to the associated WS A line (ex. WS A-8-1 line 1 is assigned to WS A Line 5).
  • Source: To attach a support paper from the Source Documents pool, click the Source button to select the desired uploaded support paper from the list. 
  • To Add the Operation: After entering a new value in the input box, click the O button to enter the changes, or click the X button to cancel.
  • Excluding an account: Click the exclude box to open a text box. Enter an explanation as to why the account is being excluded. After entering an explanation in the input box, click the O button to enter the changes, or click the X button to cancel.
  • Comment: Click the Comment button to open up the comment window. Enter a comment about the account being offset, up to 160 characters. Click the O to update the comment. You can enter a blank field to clear out the comment. Any account with a comment will show an orange filled icon. Hovering the mouse over the comment button will display any comments already added.

Manually Add A-8-1 Lines / WS A Amount

This section will allow you to add an A-8-1 line with no associated Worksheet A costs or assign a specific worksheet A amount to an A-8-1 line without identifying the associated GL account.

  • Amount: If entering an A-8-1 Line with no WS A Column 5 costs, enter 0. If entering a specific WS A amount, enter the dollar value (ex. $100).
  • A Line:  The Worksheet A line will automatically generate after the A-8-1 line is selected from the dropdown.
  • A-8-1 Line: Select the A-8-1 line number from the dropdown that the adjustment will be applied to. The available lines in the dropdown generated will show the WS A-8-1 lines created on the "WS A-8-1 Lines" tab, which corresponds to the associated WS A line (ex. WS A-8-1 line 1 is assigned to WS A Line 5).
  • Source: To attach a support paper from the Source Documents pool, click the Source dropdown to select the desired uploaded support paper from the list.
  • To add the A-8-1 line/WS A amount: Click the O button to add the A-8-1 line/WS A amount, or click the X button to cancel.

 

Allowable Expense Adjustments tab

This tab summarizes the Worksheet A-8-1 Column 5 amounts, which are automatically brought over from the WS A Amounts tab, and allows for the input of A-8-1 Column 4 Allowable amounts. This tab also calculates the total A-8-1 adjustment by line. 

The A-8-1 Line Adjustments section displays a summary of A-8-1 values for reporting on the Medicare Cost Report, and allows for entering Column 4 Allowable Amounts. To open any line for editing, click on "Edit" to the right-hand side of that row. The following values may be edited/input:

  • Allowable Expense Column: Enter the amount of home office related organization costs that are allowable. Once entered, click the O to confirm, or X to cancel.

The WS A Amount flows from the WS A Amounts tab, and the Adjustment amount is a calculated field.

Other Items to Note

  • To clear an A-8-1 Line: While an A-8-1 line has selected accounts associated with it, the data for the line may not be totally deleted, but the values for Allowable Expense may be cleared by clicking Clear. Then, Click the O button to clear the row, or X to cancel. After the line(s) is cleared, click on the button at the bottom of the adjustments. 

 

Worksheet A-8-1 Data Import

If A-8-1 Column 5 values are not easily identifiable in a particular GL account, or if extensive analysis and adjustments are done to the A-8-1 values prior to reporting on the cost report, Worksheet A-8-1 data may be imported into Absolute via an import template, on the A-8-1 Setup tab. 

Note that Importing data will overwrite all manually added lines and amounts, as well as all amounts inserted on the Adjustments tab. Data can only be imported prior to selecting accounts via filters.

An import template may be downloaded out of Absolute by clicking on the Download Template Link.

A-8-1 Import Template.png

The data in this template should conform to the following criteria:

  • Column 1: WS A-8-1 line the expenses will be reported on. It must be a number between 1-3, or 4 with optional two decimal places.
  • Column 2: A-8-1 line description. It must be 160 characters or less.
  • Column 3: WS A line the expenses will be offset against. This must be an existing WS A line.
  • Column 4: Allowable expenses. This is the amount of home office related organization costs that are allowable, with an optional $.
  • Column 5: WS A7 reference. This is required when the Ws A line is 1, 2, or 113. It must be between 9 and 14.
  • Column 6: WS A line amount and is optional. This is the amount on the Ws A line to be offset against.
  • The first row in the source file is assumed to contain headers and will be ignored.

Once this template is completed and saved, it may be uploaded into Absolute by clicking on the Import A-8-1 Data option, and browsing to where this file is saved. 

Note: Every row in the source file must pass validation in order for the information to be added to the database. If one or more rows does not pass validation, an error message will display detailing the issue(s) in the row(s).

Was this article helpful?
0 out of 0 found this helpful