Batch Cash Posting Worksheet - PM

Worksheet Columns

The top row displays a running total of payments for each claim.

Entering a payment in the top row distributes that payment amount to individual charges for the claim.

Click the + column to display individual client rows, to view services.

The field displays client guarantors assigned through a financial eligibility form.

The bottom row displays a running set of totals for amounts entered in the worksheet.

The totals update as changes are made in the worksheet.

Dates entered in the Begin Date and End Date fields control the display of services for the episode.

Begin Date/Svc Date - displays the first date of service, can be edited. When expanded, this field displays individual service dates.
End Date/Svc Code - displays the last date of service, can be edited. When expanded, this field displays individual service codes.
Total Charges - displays the claim’s total charges. When expanded, this field displays individual service charges.
Liability - displays the total client liability for the claim.
- When expanded, this field displays individual services liability.
- If client payment exceeds the client liability, the client payment amount displays in parenthesis.
Payment Amount - enter the client payment amount.
Payment Code - select the payment code. When a debit payment code is selected, the adjustment amount displays (in bold).
Adjust Amount - enter the adjustment amount.
Adjust Code - select the adjustment code.
Transfer Amount - enter the transfer amount.
Transfer Code - select the transfer code.
Transfer Guar - select the transfer guarantor.
New Balance - displays the balance for the date of service.
- This field updates when changes are made to payments, adjustments and transfer amounts.
- When the balance for a service is exceeded:
- Overpayments display (in red) for the total balance, and in individual service dates.

Accept - save selections and entries made in the worksheet. Enabled when all required fields are entered.
Find - displays the Find Value section.
- Enter the value to search for in the Value field, click Find.
- Rows that match the search criteria are highlighted in yellow.
Revert - remove all changes made to the worksheet.
- When editing a batch, clicking Revert removes all changes made since the batch was last saved.
- A confirmation message displays. Click Yes to remove changes.
Default - displays the

‘Default’ fields are used to select information in the worksheet to speed up workflow. Once this information populates it can be edited.

Guarantor - select the guarantor to populate the Payor field.
Payment Code - select the code to populate the Payment Code field.
Adjustment Code - select the code to populate the Adjustment Code field.
Transfer Code - select the code to populate the Transfer Code field.
Trans. To Guarantor - select the guarantor to populate the Transfer Guar field.

The guarantor must have been assigned to the client through a financial eligibility form.

New Row - add a row to the worksheet.
Auto Select - choose Auto Select to select amounts located on various rows of a column.
- Click a field and hold the Shift button. Move the cursor down the column, selecting all cells.
- Release the cursor. Each field in the column with the same amount is highlighted.
- This functionality works in any column of the worksheet.