9.2 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. After you receive the deposit, create the 'accounting entries' process is commonly referred as the 'Accounting Distribution'.
Navigation: Accounts Receivable > Payments > Online Payments > Regular Deposit
- The Regular Deposit search page displays. Select the Add a New Value tab.
- Enter the desired information into the Deposit Unit field.
- Select the Add button.
- 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.
- 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.
- 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.
- 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.
- Enter the desired information into the Control Currency field.
- You will enter a currency code only if the same currency is used for all of the payments.
- Specifying a control currency at the deposit level is optional. If you enter currency at this level, all payments in the deposit must have this same currency.
- To take advantage of multi-currency processing, leave the control currency blank and specify the currency at the payment level. The next tab in this component, Payments, enables you to enter a different currency for each payment in the deposit.
- 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.
- 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.
- Select the Payments tab.
- 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.
- 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.
- 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.
- 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.
- Enter the desired information into the Amount field.
- 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.
- Select Save.
Creating Accounting Entries
- Navigate to the Accounting Entries page to create accounting entries for direct journal payments.
Navigation: Accounts Receivable > Payments > Direct Journal Payments > Create Accounting Entries
- The Create Accounting Entries search page displays.
- The system may pre-populate the Deposit Unit and Deposit ID fields with the values of the deposit you just created. If not, you will need to enter this information manually.
- Enter the desired information into the Payment Sequence field.
- Select Search.
- The Accounting Entries tab displays. Use it to create or change accounting entries for direct journal entry payments.
- Enter the desired information into the Line Amount field.
- Enter the desired information into the Account field.
- Use this field to specify the number assigned to an account in the system.
- If you do not know the correct account number, you may select the magnifying glass icon to look it up.
- Enter the desired information into the Dept field.
- If you do not know the correct department code, you may select the magnifying glass icon to look it up.
- Select the Create button (lightning bolt icon) to create the cash line for a direct journal payment. The system populates the ChartField values using either the AR - Cash or DIT - Cash ChartFields that were defined for the bank account on the External Accounts page. The system uses the DIT - AR ChartFields only if the Dep in Transit option is selected for the bank account. The system calls the Centralized Inter/IntraUnit Application Engine process (IU_PROCESSOR) to create intraunit accounting entries if ChartField balancing is enabled for the ledger group and interunit accounting entries, and if you are journaling the cash to a different business unit than the deposit business unit.
- The journal entry has been created. Notice that the debit and credit amounts are now updated at the bottom of the page.
- After you enter all of the accounting lines and they are in balance, select the Complete check box option.
- Select Save.
- Select the Deposit Control tab.
- If you receive the following warning, you will need to return to the previous page and fix any errors:
- The Deposit Control tab displays. Use it to view the information for the deposit entry corresponding to the journal payment. The details of the regular deposit corresponding to the journal payment are displayed.
- In summary, you enter directly journalled payments in the case of miscellaneous cash receipts such as employee travel advance reimbursement.
- 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.
COMING SOON - Appreciate your patience while we wait until this functionality is available in the Testing Environment.
Video Tutorial via Panopto
View the external link to Entering Direct Journal Payments. This link will open in a new tab/window.
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
- Select Add a New Value tab.
- Enter or look up the Deposit Unit field.
- Select the Add button.
- The Regular Deposit page displays.
- Enter the Bank Code.
- Enter the Bank Account.
- Enter the Control Currency 'USD'.
- Enter the Control Total Amount.
- Enter the *Count number.
- Select the Payments tab.
The Accounting, Received, and Entered Dates default to the current date.
- The Payments page displays.
- Enter the Payment ID that works for your college.
- Enter the Amount.
- Select the Journal Directly check box.
- Select Save.
Optional to use the Attachments link to upload backup documentation.
- The Payment Deposit ID has been created and should have a Balanced status.
- Select the Apply Payment link.
- The Accounting Entries page displays.
- If your college has AR Speed Types set up please see below. If not, please skip to Step 17.
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.
- Enter the Line Amount.
- Enter the Account.
- Enter the Operating Unit.
- Enter the Fund.
- Enter the Department.
- Enter the Class.
- Optional to add a description in the Line Descr field.
- Enter the State Purpose.
- 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.
- The cash balancing line is created.
- Select the Complete check box.
- Select Save.
- The 'eraser' icon disappears.
- The Direct Journal payment will post to the General Ledger at the next AR Update.
- 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.
COMING SOON - Appreciate your patience while we wait until this functionality is available in the Testing Environment.
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.
Navigation: Accounts Receivable > Payments > Online Payments > Regular Deposit
- The Regular Deposit search page displays. Select Add a New Value.
- Enter your district's business unit as the Deposit Unit (it may be prefilled).
- Leave the Deposit ID as “Next” (unless local business practice dictates otherwise).
- Select Add.
- The Totals page displays.
- Select an Accounting Date (the current date will be prefilled).
- Select your district's Bank Code.
- Select your district's Bank Account.
- Select a Deposit Type of 'C' (Customer Receipts) (the value may default).
- Enter 'USD' as the Control Currency.
- Enter the Control Total Amount. This amount should be the sum of all payments in the deposit group.
- Enter the Count. The count should be the number of all payments in the deposit group.
- Select the Payments tab.
- The Payments page displays.. For each payment entered into this group:
- Enter a Payment ID (local business practice should inform your decision.).
- Enter an Amount.
- Select a Payment Method. 'Check' is prefilled and most common.
- Check the Journal Directly Checkbox
- Make sure that the Payment Predictor checkbox is NOT checked.
- For Direct Journaling deposits, you will NOT enter anything in the Customer Information or Reference Information sections.
- You can add an additional payment by selecting the + icon in the Payment Information section.
- When you have finished entering payments, select the Totals page using its tab at the top of the page.
Select the Attachments hyperlink to add documentation.
- The Totals page displays.
- Verify the Control Total Amount and Count. The Difference Amount fields should be 'zero'.
- Select Save. The system will assign a unique Deposit ID if the previous value was 'NEXT'. Note this Deposit ID for the next step in this QRG.
Navigation: Accounts Receivable > Payments > Direct Journal Payments > Create Accounting Entries.
- The Create Accounting Entries search page displays.
- Enter Deposit Unit.
- Enter Deposit ID, as noted in Step 12.
- Select Search. The search results display at the bottom of the Create Accounting Entries search page, and include each payment in the deposit.
- Select the first payment in the deposit.
- The Accounting Entries page displays.
- Select Speed Type on the Distribution line or manually enter in the Accounting Distribution.
Optional to utilize the AR Speed Type function or manually enter in the Distribution ChartString.
- A SpeedType Key field will take the place of the button. Use the Lookup to select an appropriate Speed Type.
Note: Speed Types are pre-configured and named ChartField (accounting) strings. Selecting one will fill the distribution line's ChartFields.
- Enter the Line Amount as a NEGATIVE number (you are crediting the associated revenue account).
Use the scroll bar to scroll over to view the Description field. Optional to add custom detailed information.
- Select the lightning bolt icon and the system will generate a Debit line for you.
- If you are satisfied with the accounting, select the Complete checkbox at the top of the page.
Be careful: This is a frequently missed step.
- Select Save.
- Select Next in List at the bottom of the page to open the next payment in the deposit.
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.
- Repeat steps 19-26 until all payments have been processed. Note: The next time that Journal Generator runs, the accounting will be moved into the GL.
- 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.
COMING SOON - Appreciate your patience while we wait until this functionality is available in the Testing Environment.
Video Tutorial via Panopto
View the external link to Entering Direct Journal Payments (Multiple Items). This link will open in a new tab/window.
To modify an unposted Direct Journal Accounting entries, follow these steps.
- Uncheck the Complete Box.
- Select Save.
- Upon saving the Eraser icon reappears. Select the Eraser icon.
- Once the Eraser icon is selected, the Cash Balancing Accounting Entries will disappear.
- Make adjustments to the ChartString as needed.
- Select the Lightening Bolt icon to re-create the Cash Balancing Accounting Entries.
- The Cash Balancing Accounting Entries will generate.
- Select the Complete check box.
- Select Save.
- 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.
COMING SOON - Appreciate your patience while we wait until this functionality is available in the Testing Environment.
Video Tutorial via Panopto
View the external link to Modifying Unposted Direct Journal Payments. This link will open in a new tab/window.
Use the Copy Direct Journal functionality to efficiently record reoccurring payments.
Navigation: Accounts Receivable > Payments > Direct Journal Payments > Copy Direct Journal
- On the Copy Direct Journal search page, enter the Deposit Unit.
- Enter or lookup the Deposit ID you wish to copy.
- Select the Search button
- The Copy Direct Journal page displays. In the Direct Journal Action section select the Copy Direct Journal radio button.
- 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).
- Select the Create Direct Journals button.
- Select the Save button.
- 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).
- The Direct Journal Acctg Entries page displays. If NO CHANGES, select the Complete checkbox and continue to Step 11.
- If YES CHANGES, and you would like to make any changes to the copied ChartString follow the directions below;
- Select the Delete icon (box with a red X inside).
- Update the ChartFields values as needed.
- Select the lightning bolt icon to create the offset line.
- Mark the Complete checkbox to finish or finalize this transaction.
- Select the Deposit Control tab.
- Select the Save button.
- Verify or confirm that deposit was Journalled.
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.
COMING SOON - Appreciate your patience while we wait until this functionality is available in the Testing Environment.
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