9.2 Using a Payment Worksheet to Apply an Overpayment
Purpose: Use this document as a reference for how to use a Payment Worksheet to apply an overpayment in ctcLink.
Audience: AR Specialists
You must have at least one of these local college managed security roles:
- ZZ AR Apply Payments
You must also set these User Preference Definitions:
If you need assistance with the above security roles or User Preference Definitions, please contact your local college supervisor or IT Admin to request role access.
The following QRG demonstrates only one of several potential scenarios. This serves as a guideline that will vary depending on the accounting conditions.
Using a Payment Worksheet to Apply an Overpayment
Navigation: Accounts Receivable > Payments > Apply Payments > Create Worksheet
- The Create Payment Worksheet search page displays.
- Enter your district's business unit as the Deposit Unit (it may be prefilled).
- Enter the Deposit ID associated with the payments you wish to apply.
- Select Search.
- The Payment Worksheet Selection page displays.
- If there is more than one unapplied payment in the deposit, each payment will be listed. Select the payment you wish to apply. If there is only one payment in the deposit, it will open automatically.
- Note that using a payment worksheet generally involves three steps: (1) Worksheet Selection, (2) Worksheet Applications, and (3) Worksheet Actions. You are currently on the Payment Worksheet Selection page. Use the Payment Worksheet Selection page to select AR item(s) for inclusion on the worksheet, with the assumption that you might pay those items with the payment you are currently working. To include all open items for a particular customer, configure the Customer Criteria section as follows:
- Select Customer Items from the Customer Criteria drop-down menu (the default selection).
- Enter the Customer ID (which will prefill if the customer was identified on the payment).
- Enter your district's Business Unit (which may be prefilled).
- Select Build.
- The Payment Worksheet Application page (step 2 of the payment worksheet process) displays. Use it to select the open items you wish to pay with the current payment. For each item you wish to pay with the current payment:
- Select Pay An Item as the Entry Type (the default selection).
- Select via the Sel checkbox the open item(s) you wish to pay. Type defaults automatically to 'PY'. The Balance section updates automatically.
- If the payment amount is greater than the sum of selected open items, the open items will be fully paid by the payment. A remainder represents a credit balance for the customer and needs to be addressed on the worksheet:
- Add a new item to the worksheet by selecting the Add a New Row [+] icon at the end of any row in the Item List.
- In the Pay Amt field, enter a negative number representing the amount of overpayment.
- For the Type field select "OA", for "Place an Amount on Account". Note that you do not need to enter a Reason Code when placing an amount on account. The Item ID is assigned automatically. The Balance section is updated automatically.
- Select Save. In the example here, there are now two items selected: the originally selected item for $20 and a newly added credit item for $15. Together the items represent full use of the payment; the remaining balance of the worksheet is zero.
- Select Worksheet Action at the bottom of the page.
- The Payment Worksheet Action page displays. Use it (step 3 of the payment worksheet process) to:
- Create / review accounting entries
- Delete the worksheet
- Post the payment
- Select Create/Review Entries to generate the payment accounting.
- The Accounting Entries page displays. Review it. Adjust as needed. Select Save.
- Select Return to Previous Panel.
- The Payment Worksheet Action page displays. Select 'Post Now' as the Action, then select OK.
Note 1: You must select the OK button after selecting a posting action; no posting will occur if you simply Save.
Note 2: You may also set the posting action to "Batch Standard" to have the accounting post when AR Update next runs.
- A new window opens to Process Monitor. Insure that the payment posts without incident. Refer to the Process Scheduling QRG for further instructions. Close the Process Monitor window.
- To review the accounting, navigate to NavBar > Navigator > Accounts Receivable > Payments Review Payments > Deposit Accounting Entries.
- The Deposit Accounting Entries search page displays. Enter Deposit Unit and Deposit ID.
- Select Search.
- If multiple payments in the deposit have accounting, each payment will be listed. Select a payment. If only one payment in the deposit has accounting created, it will open automatically.
- The Payment Control page displays. Select the Accounting Entries tab.
You must have at least one of these local college managed security roles:
- ZC AR Customer Maintenance
- ZD AR Inquiry
- ZZ AR Customer Maintenance
If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.
- The Accounting Entries page displays. The payment you selected has been successfully applied to the open item selected on the payment worksheet.
- Note that the item is now closed. To review activity on that item:
- Navigate to: NavBar > Navigator > Accounts Receivable > Customer Accounts > Item Information > Item List.
- Search for closed items associated with the customer.
- Select the item you (over) paid.
- Select the Item Activity tab.
- Process complete.
Video Tutorial
The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.
VIDEO COMING SOON!
View Tutorial via Panopto
View the external link to Using a Payment Worksheet to Apply an Overpayment. This link will open in a new tab/window.
0 Comments
Add your comment