ctcLink Reference Center9.2 Finance9.2 FIN - Accounts ReceivableApplying Payments9.2 Using a Payment Worksheet to Apply an Underpayment

9.2 Using a Payment Worksheet to Apply an Underpayment

Purpose:  Use this document as a reference for how to Use a Payment Worksheet to Apply an Underpayment 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.

Using a Payment Worksheet to Apply an Underpayment

Navigation:   NavBar > Navigator > Accounts Receivable > Payments > Apply Payments > Create Worksheet

Note:  The following QRG demonstrates only one of several potential scenarios.  This serves as a guideline that will vary depending on the accounting conditions.

  1. The Create Payment Worksheet displays.
  2. Enter Deposit Unit.
  3. Enter the Deposit ID associated with the payments you wish to apply.
  4. Select Search.
  5. If there is more than one un-applied payment in the deposit, each payment will be listed at the bottom of the Create Payment Worksheet;  select the payment you wish to apply.  If there is only one payment in the deposit, it will be selected automatically.
Create Payment Worksheet page
  1. The Payment Worksheet Selection page displays.
  2. 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 Worksheet Selection step.  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:
    1. Select 'Customer Items' from the Customer Criteria drop-down menu (the default selection).
    2. Enter the Customer ID (which will prefill if the customer was identified on the payment).
    3. Enter your district's Business Unit (which may be prefilled).
    4. Select Build.
Payment Worksheet Selection page
  1. The Payment Worksheet Application page displays.
  2. Use the Payment Worksheet Application page (step 2 of the payment worksheet process) to select the open items you wish to pay with the current payment.  For each item you want to pay with the current payment:
    1. Select Pay An Item as the Entry Type (the default selection).
    2. Select (via the Sel Checkbox) the open item(s) you wish to pay.
    3. The Pay Amount for each open item displayed in the worksheet defaults to the full amount of the item.  Manually change the Pay Amt field to the amount you wish to pay.  In this example we change the Pay Amt field from $711 (the full amount of the open item) to $15 (the total amount of the payment we are working with).  This represents an underpayment of the open item totaling $696.
  3. Select Refresh (at the bottom of the page).
Payment Worksheet Application page
  1. The system generates a new open item representing the outstanding balance of $696 (which you can treat as you would any other open item).  The generated item will have the same Item ID as the original.  Remember that AR items are uniquely identified by the Group ID they are defined in; the duplicate Item ID will help you link this item with the original.
  2. Select Save.
  3. Select Worksheet Action (at the bottom of the page).
Payment Worksheet Application page
  1. The Payment Worksheet Action page (step 3 of the payment worksheet process) displays.  Use it to:
    1. Create / review accounting entries
    2. Delete the worksheet
    3. Post the payment
    4. Select Create/Review Entries to generate the payment accounting
Payment Worksheet Action page
  1. The Accounting Entries page displays.  Review and update as needed.
  2. Select Save.
  3. Select Return to Previous Panel.
Accounting Entries page
  1. The Payment Worksheet Action page displays.  To post the accounting immediately, select 'Post Now' as the Action, then select OK.
Payment Worksheet Action page

Note 1:  You must select OK 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.

  1. A new window will open to the Process Monitor.  Insure that the payment posts without incident.   Refer to the Process Monitor QRG for instructions.
  2. To review the accounting navigate to NavBar > Navigator > Accounts Receivable > Payments > Review Payments > Deposit Accounting Entries.
  3. The Deposit Accounting Entries search page displays.
  4. Select Deposit Unit.
  5. Select the Deposit ID with which you are working.
  6. Select Search.
  7. If multiple payments in the deposit have accounting, each payment will be listed at the bottom of the Deposit Accounting Entries search page; select a payment.  If only one payment in the deposit has accounting created, it will select automatically.
Deposit Accounting Entries search page
  1. The Payment Control page displays.
  2. Select the Accounting Entries tab.
Payment Control page
  1. The Accounting Entries page displays.  The payment you selected has been successfully applied to the open item selected on the payment worksheet.
Accounting Entries page

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.

  1. Note that the item is still open with a remaining balance. To review activity on that item:
    1. Navigate to NavBar > Navigator > Accounts Receivable > Customer Accounts > Item Information > Item List.
    2. Search for open items associated with the customer.
    3. Select the item you made a partial payment for.  Select the Item Activity tab.
  2. Process complete.

0 Comments

Add your comment

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