Viewing a Partial Payment on a Worksheet

Purpose:  To view a partial payment on a worksheet in ctcLink.

Audience:  Accounts Receivable staff.

You must have at least one of these local college managed security roles:

  • ZZ AR Apply Payments

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Viewing a Partial Payment on a Worksheet

Navigation: Accounts Receivable > Payments > Apply Payments > Update Apply Payment Worksheet

After you create a worksheet, you can sort and categorize the items listed on it and determine how to apply or write off items. You can also create adjustments, prepayments, and deductions to balance the worksheet.

  1. On the Update Payment Worksheet search page, enter or select the Deposit Unit.
  2. Enter or select the Deposit ID.
  3. Enter the Payment Sequence. 
  4. Select Search. The Payment Worksheet Application page will display.
  1. Use the Payment Worksheet Application page to view all of the selected open items. You can also use this page to apply payments to selected items. The screenshot below calls out the following details by associated numbering.
  2. The Payment Accounting Date displays the accounting date for the payment activity.
  3. The Item Action section displays the Entry Type and Reason. Some entry types are valid for existing items and some are valid only for new items.
  4. The fields in the Row Selection group box enable you to work with all items in the worksheet or to select a range of items.
  5. On the Detail 1 tab, the number in the Remit Seq (remit sequence) column relates to the order in which the items were entered on the Payment Worksheet Selection page. Initially, the items appear in this order. If you sort the worksheet based on the value in another column, the sequence number stays with the item, but the grid order changes. Use this column to sort the worksheet in the original order. 
  6. On the Detail 1 tab, the Pay Amt (payment amount) column initially displays the open amount for the item. You can change the amount to make a partial payment.
  7. As you select open items, you should check the information in the Balance group box. The system updates the amounts whenever you Select the Refresh button. If the Remaining amount is not 0, you need to adjust the payment amounts or select additional items.
  8. Select the Personalize link to view the Grid Customization page.
Payment worksheet Application
  1. Use the Grid Customization page to to sort by column and to reorder, hide, or freeze columns. This enables you to put the key fields that you want to review on the Detail 1 tab and sort your data. 
Personalization Grid
  1. To complete your review of the Payment Worksheet Application, select OK to return to the Payment Worksheet Application page.

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 Tutorial via Panopto

View the external link to Viewing a Partial Payment on a Worksheet. This link will open in a new tab/window.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.