Worksheet I-Series: Renal Dialysis

I-Series – Renal Dialysis Overview:

The I-Series Module in Absolute automates the population of the Renal Dialysis subcomponent worksheets in the Medicare Cost Report, for those hospitals that have a Renal Dialysis subunit. When a Renal Dialysis provider number is entered into the Report Settings tab for a hospital report in Absolute, the software is prompted to open up the I-Series on the Preparation tab of the Dashboard.

 

Renal Dialysis Expenses - Assign WS I-1 Lines:

The Renal Dialysis Expenses – Assign WS I-1 Lines interface allows accounts that are mapped to Worksheet A Lines 74 and 94 to be mapped to the appropriate lines of Worksheet I-1.

For the Worksheet I-1 Line Assignments, Absolute will display General Ledger values for the Renal Dialysis subunits, considering any reclasses or adjustments that affect the Renal Dialysis lines. Therefore, the Worksheet A-6 and Worksheet A-8 Sections in Absolute need to be marked complete to open the Renal Dialysis Expenses - Assign Worksheet I-1 Lines section for viewing/editing.

In the Assign I-1 Lines section, a list of unassigned accounts will populate in the Accounts to Assign Section. Absolute will display the account level General Ledger detail, for all accounts assigned to Line 74/94 of Worksheet A, including any A-6/A-8 detail, for proper assignment to Worksheet I-1 Lines.

Note: Absolute will carry forward Worksheet I-1 Line Assignments for accounts that were present in the prior year. Only new accounts will need to be mapped to a Worksheet M-1 Line for the current year.

If all accounts are unassigned, the preparer can select an account roll-up option, to display accounts at a specific GL account component. The preparer can also choose to display accounts at multiple GL component levels, i.e. at the account and subaccount level, if that detail is necessary for proper line assignment.

To assign accounts to a Worksheet I-1 Line, first select the accounts to assign to a line in the upper panel, by checking the box to the left of the account. A range of rows may be selected by shift-clicking the beginning and end of an account group. In the bottom panel, select the line or allocation to which the account(s) will be assigned. The active target highlights blue, indicating it is ready to receive an account. Then click the Assign Selected link in the upper panel. The accounts are removed from the panel and display under the active target.

To unassign an account, click the remove button mceclip0.pngadjacent to the assigned account. It is removed from the target and is redisplayed in the Accounts to Assign.

1.png
Accounts can also be assigned to Worksheet I Lines based on an Allocation Percentage, where accounts aren’t broken out into detail for that line type. For example, if all salaries are recorded in a particular account and not broken out by salary type (Registered Nurse, Nurses Aide, etc.), an Allocation can be used to spread these accounts to multiple lines. Accounts that are assigned to an Allocation line will be spread based on the statistics entered.

  • To add a new allocation, select “Add Allocation” in the bottom panel. A new allocation will be added and selected as the active target.
  • To edit an allocation code (ex: L1) or description (ex: Line Allocation 1), click on the text you wish to edit to display a text input box. Enter the desired code or description, and click the O button to save, or click the X button to cancel.
  • The weights section displays a table of weights for each row, representing a percentage and a line assignment. All weights are allocation statistics. These split an account to certain lines, based on the percentage of each weight's allocation statistic to the total allocation statistic amount. For example, entering 100 to line 1, 900 to line 2 will allocate 10% (100 out of 1000 total) to line 1, and 90% (900 out of 1000 total) to line 2.
  • To add allocation weights, click the + in the lower left-hand corner of this table. Enter the desired weight, and select or input the line number to apply this weight to that line. Click the O button to save, or click the X button to cancel.
  • To edit a weight, click in the row you wish to change. This will display a text input box. Once updated values are entered, click the O button to save, or click the X button to cancel.
  • To delete a weight, click on the “x” next to the row you wish to remove. Click the O button to save, or click the X button to cancel.
  • To enter or edit a comment, click into the comment text, to the right of the allocation table, and enter/edit a comment. Click the O button to save, or click the X button to cancel.
    (Insert Screen Shot)
  • To unassign all accounts from the Worksheet M-1 Lines, select Unassign All in the lower section. All accounts will move back up to Accounts to Assign.

When all accounts are assigned, this section can be marked complete in the lower left-hand corner.

2.png

Renal Dialysis External Values:

Worksheet S-5 Statistical Data is entered into Absolute as External Values.

Worksheet I-1 Column 3 Hours are entered into Absolute as External Values.

Worksheet I-2 EPO and Aranesp Services are entered into Absolute as External Values.

Worksheet I-3 Statistical Basis are entered into Absolute as External Values.

Worksheet I-4 Treatments are entered into Absolute as External Values.

Worksheet I-5 Bad Debts are entered into Absolute as External Values.

 

Renal Dialysis PS&R Values:

Renal Dialysis PS&R detail is uploaded into Absolute in the D&E Series Title XVIII Settlement->Import PS&R Summaries Section. Absolute will automatically assign all Medicare PS&R values for the Renal Dialysis to the appropriate Worksheet. Values will be summarized in the Renal Dialysis Workpaper Export, which can be exported out of Absolute via the Exports tab on the Dashboard.

 

Was this article helpful?