Direct Journal Payments

Purpose: Use this document as a reference for entering direct journal payments, creating accounting entries, applying payments, and/or copying direct journal payments in ctcLink. These types of deposits/payments are for items not attached to an existing bill or invoice.

Audience:  Accounts Receivable staff/supervisors

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.

Direct Journal Payments are for deposits received that is not connected to an Invoice or Bill. The basic steps for Direct Journal Payments are:

  • Create and balance the deposit.
  • Apply the payment by creating accounting entries for each entry.
Entering a Direct Journal Deposit and Applying Payment (Single Item Entry)

Use the following steps to enter a single entry Direct Journal Deposit and quickly apply the Payment using the 'Apply Payment' hyperlink.

Navigation: Accounts Receivable > Payments > Online Payments > Regular Deposit

  1. The Regular Deposit search page displays.  Select the Add a New Value tab.
  2. Enter the desired information into the Deposit Unit field.
  3. Select the Add button.
Add a new value
  1. The Totals tab displays.  Use it to enter information and control totals for a new deposit, or delete a deposit. The Totals tab is unavailable if the deposit has been reconciled with a bank statement.
  2. Enter the desired information into the Accounting Date field. (Note: Dates will default to the current date)
    • You will use this field to enter the accounting date for each payment and for all pending items created from the payment.
    • You can override the date on the Regular Deposit - Payments page.
    • The system validates the accounting date to make sure it falls within the open period for the business unit and transaction type as defined on the Open Period page for the business unit.
  3. Enter the desired information into the Bank Code field.
    • If you do not know the correct code, you can select the magnifying glass icon to look it up.
  4. Enter the desired information into the Bank Account field.
    • If you do not know the correct code, you can select the magnifying glass icon to look it up.
    • After you choose the bank account type, the Deposit Type field should automatically populate. If this does not happen, you may enter the information manually.
  5. Enter the USD for the Control Currency field.
  6. Under the Control Totals section, enter the desired information into the Control Total Amount and Count fields.
    • You will use these fields to enter the control totals for the amount and count of the payments in this deposit.
    • You can have a zero-total deposit if the payment amounts offset each other.
  7. The Control Data section defaults to the current date. Optional to enter the desired information into the Received and Entered fields.
    • You will use the Received field to enter the date when either the bank or your company received the payment.
    • Because of normal processing delays, the Received date may be different from the Entered date.
  8. Select the Payments tab.
Totals tab page
  1. The Payments tab displays.  Use it to enter details about each payment in a regular deposit. The more information you can provide on this page, the easier it will be to work with the payment worksheet. Enter the desired information into the Payment ID field. Use this field to identify a payment. You can enter the check number or any other identifying number.
  2. The Accounting Date field displays the payment date, using the accounting date on the Totals page as the default.  The system validates the payment date to make sure that the date falls within the open period for the business unit and transaction type as defined on the Open Periods page for the business unit.  The payment date may be different from the deposit date, if you use the postmark date from checks.  The payment date affects earned discounts, so it's important that it is accurate.
  3. Enter the payment amount into the Amount field.
  4. Select the Journal Directly check box option.
    • Choose this option only if a payment should be handled as miscellaneous cash received rather than applied to items.
    • Payments journalled directly to the general ledger cannot be processed in payment worksheets and do not go through the Receivable Update process.
  5. Select Save to create a Deposit ID number and deposit should have a Balanced status.
  6. Select the Apply Payment link.

The Balance field displays the status for the deposit. When the amount total and number of entered payments equals the control amount and count from the Totals page, the status changes from "Not Balanced" to "Balanced". The total amount of all the payments in the deposit must match the control totals on the Totals page before you can create a payment worksheet.  Note that you cannot update payment information for a deposit that has been reconciled with a bank statement.

Payments tab
  1. The Accounting Entries page displays. If your college has AR Speed Types set up please see below.  If not, please skip to Step 19.

Optional:  If your college has AR Speed Types set up, select the Speed Type button to auto-fill the Distribution line. Once selected, it will prompt you to use the lookup tool to view active AR Speed Types. Once selected, the Accounting ChartString distribution will be auto-filled.

Example using an AR Speed Type
  1. In the Distribution Lines section, manually enter or lookup the field values:
    1. Enter the negative Line Amount.
    2. Enter the Account.
    3. Enter the Operating Unit.
    4. Enter the Fund.
    5. Enter the Department.
    6. Enter the Class.
    7. Enter the State Purpose.
    8. Use the scroll bar to view all fields. Optional to add a description in the Line Descr field, i.e. J. Smith Citation#012345. OR select the Journal Reference Information tab to enter information in the Reference column.
  2. Select the lightening bolt icon to create the cash balancing line.

The Lightening Bolt icon generates the Cash Balancing Accounting Entries and next to the Lightening Bolt is the Eraser icon which 'erases' the Cash Balancing Accounting Entries to start over.

Example manually entering in the field values
  1. The cash balancing line is created. Select the Complete check box.
  2. Select the Save button.
mark complete and save
  1. The 'eraser' icon disappears. The Direct Journal payment will post to the General Ledger at the next AR Update.
  2. Section complete.
complete AR Direct Journal entry

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 Entering a Direct Journal Payments and Applying Payment (single entry). This link will open in a new tab/window.

Entering a Direct Journal Deposit and Applying Payment (Multiple Items)

Navigation: Accounts Receivable > Payments > Online Payments > Regular Deposit

Use the following steps to enter a single entry Direct Journal Deposit and quickly apply the Payment using the 'Apply Payment' hyperlink.

Navigation: Accounts Receivable > Payments > Online Payments > Regular Deposit

  1. The Regular Deposit search page displays.  Select the Add a New Value tab.
  2. Enter the desired information into the Deposit Unit field.
  3. Select the Add button.
Add a new value
  1. The Totals tab displays.  Use it to enter information and control totals for a new deposit, or delete a deposit. The Totals tab is unavailable if the deposit has been reconciled with a bank statement.
  2. Enter the desired information into the Accounting Date field. (Note: Dates will default to the current date)
    • You will use this field to enter the accounting date for each payment and for all pending items created from the payment.
    • You can override the date on the Regular Deposit - Payments page.
    • The system validates the accounting date to make sure it falls within the open period for the business unit and transaction type as defined on the Open Period page for the business unit.
  3. Enter the desired information into the Bank Code field.
    • If you do not know the correct code, you can select the magnifying glass icon to look it up.
  4. Enter the desired information into the Bank Account field.
    • If you do not know the correct code, you can select the magnifying glass icon to look it up.
    • After you choose the bank account type, the Deposit Type field should automatically populate. If this does not happen, you may enter the information manually.
  5. Enter the USD for the Control Currency field.
  6. Under the Control Totals section, enter the desired information into the Control Total Amount and Count fields.
    • You will use these fields to enter the control totals for the amount and count of the payments in this deposit.
    • You can have a zero-total deposit if the payment amounts offset each other.
  7. The Control Data section defaults to the current date. Optional to enter the desired information into the Received and Entered fields.
    • You will use the Received field to enter the date when either the bank or your company received the payment.
    • Because of normal processing delays, the Received date may be different from the Entered date.
  8. Select the Payments tab.
Totals tab
  1. The Payments tab displays. Enter the desired information into the Payment ID field. Use this field to identify a payment. You can enter the check number or any other identifying number.
  2. The Accounting Date field displays the payment date, using the accounting date on the Totals page as the default.  The system validates the payment date to make sure that the date falls within the open period for the business unit and transaction type as defined on the Open Periods page for the business unit.  The payment date may be different from the deposit date, if you use the postmark date from checks.  The payment date affects earned discounts, so it's important that it is accurate.
  3. Enter the payment amount into the Amount field.
  4. Select the Journal Directly check box option.
    • Choose this option only if a payment should be handled as miscellaneous cash received rather than applied to items.
    • Payments journalled directly to the general ledger cannot be processed in payment worksheets and do not go through the Receivable Update process.
  5. Select the plus icon [+] to add additional payments. Follow steps 14 and 15 for each added entry.
Payments tab page
  1. When you have finished entering payments, select the Totals page using its tab at the top of the page
  2. Select Save to create a Deposit ID number and deposit should have a Balanced status with the Control Total Amount and Count, where the Difference Amount fields should be 'zero'. The system will assign a unique Deposit ID if the previous value was 'NEXT'.

Note the Deposit ID for it will be used at the next step to Create Accounting Entries.

Deposit is saved.

Navigation: Accounts Receivable > Payments > Direct Journal Payments > Direct Journal Acctg Entries

  1. The Create Accounting Entries search page displays. Enter Deposit Unit. Enter or lookup the Deposit ID, as noted in Step 18. Select the Search button. The search results display at the bottom of the Create Accounting Entries search page, and include each payment in the deposit.
  2. Select the first payment in the deposit.
find an existing value
  1. The Accounting Entries page displays. If your college has AR Speed Types set up please see below.  If not, please skip to Step 22.

AR Speed Types are pre-configured and named ChartField (accounting) strings created within the Accounts Receivable Module. Selecting one will autofill the distribution line's ChartFields. For more information, please refer to QRG Creating AR Speed Types.

AR Speed Type example
  1. Enter the Line Amount as a NEGATIVE number (you are crediting the associated revenue account). Enter valid field values to complete the ChartString.
  2. Use the scroll bar to view all field values. Optional to enter details in the Line Description field.
  3. Select the lightening bolt icon to generate the cash balancing lines.
Enter distribution line info
  1. The cash balancing lines appear. Mark the Complete check box and select the Save button.
  2. Select the 'Next in List' to enter the Accounting Entries for the next entry.
mark complete and save

Use the Previous in List and Next in List buttons at the bottom of the page to scroll through your payments to verify all boxes/payment information has been completed correctly.

use previous and next in list
  1. Repeat steps 22-26 until all payments have been processed. Select the Deposit Control tab page to verify the deposit and count is balanced.
  2. Section complete.

Note: The next time that Journal Generator runs, the accounting will be moved into the General Ledger.

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 Entering Direct Journal Deposits and Applying Payments (Multiple Items). This link will open in a new tab/window.

Modifying Direct Journals

Navigation: Accounts Receivable > Payments > Direct Journal Payments > Direct Journal Acctg Entries

To modify a Direct Journal entry, the entry must not be marked 'Complete' and 'Saved'.

  1. On the Create Accounting Entries search page displays. Enter or lookup the unposted Deposit ID. Select the Search button.
  2. The Accounting Entries page displays. Deselect the Complete box and select the eraser icon.
  3. Select the Save button.
select eraser icon
  1. Once the Eraser icon is selected, the Cash Balancing Accounting Entries will disappear. Make adjustments to the ChartString as needed.
  2. Select the Lightening Bolt icon to re-create the Cash Balancing Accounting Entries.
correct chart fields and re-select the lighting bolt icon
  1. The Cash Balancing Accounting Entries will generate. Select the Complete check box.
  2. Select the Save button.
  3. Section complete.
re-select the complete box and save 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 Modifying Direct Journals. This link will open in a new tab/window.

Copying Direct Journal Payments

Use the Copy Direct Journal functionality to efficiently record reoccurring payments.

Navigation: Accounts Receivable > Payments > Direct Journal Payments > Copy Direct Journal

  1. On the Copy Direct Journal search page, enter the Deposit Unit.
  2. Enter or lookup the Deposit ID you wish to copy. Select the Search button
  3. The Copy Direct Journal page displays. In the Direct Journal Action section select the Copy Direct Journal radio button.
  4. Enter the Number of Copies of the selected Direct Journal Deposit ID that you'd like to copy (optional to add more than 1 copy).
  5. Select the Create Direct Journals button. Select the Save button.
Copy Direct Journal page
  1. The Copy Results section populates with the newly copied Direct Journal information. Select the new 'Go to Direct Journal Acctg Entries' hyperlink.
  • Sequence: provides you the number of copied Direct Journals.
  • Copy Deposit ID: generates the new Deposit ID number(s).
  • Go to Direct Journal Acctg Entries: provides the navigation link to create Direct Journal Accounting Entries/Distribution(s).
select link go to direct journal acct entries
  1. The Direct Journal Acctg Entries page displays. If NO CHANGES, select the Complete checkbox and continue to Step 11.
  2. If YES CHANGES, and you would like to make any changes to the copied ChartString follow the directions below;
    1. Select the Delete icon (box with a red X inside).
    2. Update the ChartFields values as needed.
    3. Select the lightning bolt icon to create the offset line.
    4. Mark the Complete checkbox to finish or finalize this transaction.
Accounting Entries page
  1. Select the Deposit Control tab.
  2. Select the Save button.
  3. Verify or confirm that deposit was Journalled.
Deposit Control page

AR Journals are posted to the General Ledger by SBCTC. For more information on Financials Process Schedules, please see the FIN Pillar Currently Scheduled and Running.

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 Copying Direct Journal Payments. 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.