Revised:  10/07/2024

Updating Worksheets

ReferencesReferences

Overview

This process may be used if a worksheet was created but not completed. If more than one worksheet needs updating, use the Payment Status Worksheet to get a list of all payments that have not yet been applied.

Steps

• https://ohid.ohio.gov/wps/myportal/gov/myohio/ > Financials > NavBar > Menu > Accounts Receivable > Payments > Apply Payments > Update Apply Payment Worksheet

1. Enter the Deposit Unit and any other search criteria to help find the desired worksheet.

• A worksheet can be searched by Payment Status. The possible statuses are:
  • Applied - Payment matches pending items and will post in the next batch run of the ARUPDATE process.
  • Complete - ARUPDATE successfully posted matched payment.
  • Directly Journalled - Not applicable to worksheets.
  • Identified - Payment references a pending item or worksheet with an identified customer.
  • Identified - Express - Not used by the State of Ohio.
  • Unidentified - Payment has no pending item or customer reference.
  • Worksheet - Worksheet has been built for payment but not set to post.

1. Worksheets may also be updated with a payment status of Applied until ARUPDATE runs. At that point, OAKS FIN changes the status to Complete.
2. Click Search.
3. If more than one worksheet matches the search criteria, a list of search results displays.
4. Click a link on the row of the correct search result.

• The Payment Worksheet Application page displays.

5. Determine the Amount to enter in the Pay Amt field based on the fields in the Balance section.  
   • Amount – Shows the payment amount
   • Selected – Shows the total amount due in the selected rows
   • Remaining – Shows how much of the payment remains to be applied
6. Click the Look Up Item ID icon to select an Item ID for the customer to which to apply payment. Make a note of the dollar amount of the item.
7. Click Refresh.

• The Balance section’s Adjusted and Remaining fields are updated.

8. Click Save to store the changes.
9. Click the Worksheet Action link.

• The Payment Worksheet Action page displays.

10. Click Create/Review Entries.

• The ChartFields display.

11. Review the ChartFields and then click Return to Previous Panel .
12. Click the Action drop-down arrow and select Batch Standard.
    • Once saved, this will make the worksheet available for posting when the ARUPDATE batch process runs.
13. Click OK.

• The posting action is set.

14. Click Save.

• The worksheet is saved to OAKS FIN.