9.2 Creating a Standard Journal Entry

Purpose: Use this document as a reference for creating a standard journal entry in ctcLink.

Audience: Accounting Staff.

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

  • ZZ GL Journal Entry

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.

Standard Journal Entries (SJEs) enable you to automate the entry of similar or identical journals.  The only type of SJE at SBCTC is 'Model'.  Note that all SJEs and their models must be for the same business unit.

The first step to creating SJEs is establishing the model entry.

Creating a Standard Journal Entry Model

Navigation: NavBar > Navigator > General Ledger > Journals > Journal Entry > Create/Update Journal Entries

  1. The Create/Update Journals Entries search page displays.  Enter existing search criteria or select Add a New Value to create a new value.
  2. If it did not automatically populate, enter or select the business unit in the Business Unit field.
  3. Enter a journal ID for the standard SJE in the Journal ID field.  Note:  Because you are setting up the model for the standard journal entry, you do not want to leave 'NEXT' in this field.
  4. Select Add.
Create Update Journal Entries Add a New Value tab
  1. The Create/Update Journal Entries page displays.  The Header tab displays journal header information that uniquely identifies a journal, such as business unit, journal ID, and journal date.  This page also contains options for setting, adjusting and reversing entries.
  2. Enter an appropriate description in the Long Description field, e.g. “Advertising Accrual.”
  3. Enter or select 'ACTUALS'  in the Ledger Group field.
  4. Enter ‘ONL’ in the Source field.  This is the code used for manual journal entries.
  5. Use the SJE Type drop-down button to select Model -- Do Not Post.
  6. When the Header page is complete, select Lines.

Utilize the Long Description field to provide useful and detailed information that can help out with future reconciliations.

Create Update Journal Entries Header page

Entering Line Items

  1. The Lines page displays.  Use it to record the transaction lines that comprise the journal.

Note:  SBCTC requires the presence of a Business Unit (*Unit), Account, Dept, Fund, Class, and State Purpose for every journal entry.  Additionally, grant and project related journal entries require a Project Bus Unit, Project Number, Activity, and Analysis Type.  During processing of the journal entry, the system will use this information to check against the control budget.

  1. Enter or select the appropriate account in the Account field.
  2. Enter or select the appropriate operating unit in the Oper Unit field.
  3. Enter or select the appropriate fund in the Fund field.
  4. Enter or select the appropriate department in the Dept field.
  5. Enter or select the appropriate class in the Class field.
  6. Enter the journal entry amount in the Amount field.
  7. Enter or select the appropriate state purpose in the State Purpose field
  8. Select Insert Lines to add the off-setting item with the Copy Down ID functionality.
Lines page
  1. Enter or select the appropriate account for the second line item in the Account field.

Note:  The journal entry is balanced when the value in the Total Debits column is equal to the value in the Total Credits column.  When you have a balanced journal, you may begin processing the journal directly from this page.

  1. Select Save.
Lines tab
  1. Next, edit the model journal. Select Process.
Lines page
  1. Two confirmation message boxes appears in succession.  Select OK to acknowledge that the journal has been saved; the message box disappears.  Select OK to acknowledge that the journal that you have created is an SJE model journal.  The message box disappears.
Journal saved confirmation box
SJE Model confirmation box

Note: The Journal Status is now ‘M’ (Model) .  The normal journal that you use as a model should have a valid status.  The system does not post Model SJEs to the general ledger, and they cannot be changed or deleted after you execute the edit process.

Lines page
  1. Next, define the standard journal entry based on the model journal just created.

Defining a Standard Journal Based on the Model

Navigation: NavBar > Navigator > General Ledger > Journals > Standard Journals > Define Standard Journals

  1. The Define Standard Journals search page displays.  Enter existing search criteria or select Add a New Value  to create a new value.
  2. Enter a meaningful journal ID for the standard journal in the Standard Journal field.
  3. Select Add.
Define Standard Journals Add a New Value tab
  1. The Define Standard Journals page displays.  Use it to define the standard journal that becomes the high-level key for all journal entries generated using this definition.
  2. Enter a brief description of journal that you want to create in the Description field (this is the field at the very top of the screen to the right of the SJE ID field).
  3. Enter a meaningful description of the standard journals to be created in the Description field (this is the field in the SJE Detail section of the screen).
  4. Use the SJE Type drop-down button to select the SJE type.  SBCTC will use ‘Recurring on a Schedule.’
  5. Use the Journal ID field to enter or select the ID of the model journal that you created earlier.  This ID provides the system with information about the model that is linked to the standard journal.
  6. Enter or select the appropriate date that the model journal was created into the Journal Date field.
  7. Use the Schedule drop-down button to select the processing frequency for the SJE.
  8. Use the From Date and the To Date fields to define the time range of the SJE entries.
  9. If you want to add lead days to have the journal entry ready for creation each month, use the Journal Creation Lead Days field to enter the number of days in advance of the journal date that you want the standard journals to be ready for creation.
  10. Select Save.
Define Standard Journals page
  1. Finally, post to the General Ledger using the SJE.

Creating Standard Journals Postings

Navigation:  NavBar > Navigator > General Ledger > Journals > Standard Journals > Create Standard Journals

  1. The Create Standard Journals run control ID search page displays.
  2. Enter an existing Run Control ID or use the Add a New Value tab on the Create Standard Journal page to add a new value.
    • Enter a meaningful Run Control ID for the standard journal in the Run Control ID field.
  1. Select Add.
Create Standard Journals Add a New Value tab
  1. The Create Standard Journals Request page displays.  Use it to specify the parameters for running the SJE process.
  2. Use the Process Frequency drop-down button to select the processing frequency.  SBCTC will use ‘Always.’
  3. Enter or select the appropriate unit in the Unit field.
  4. Use the From SJE and the To SJE fields to define the journal range of the SJE entries.
  5. Enter a brief description of the processing request in the Description field.
  6. SBCTC is utilizing budget commitment controls.  Select the Recalculate Budget Date checkbox to create a standard journal entry with a budget recalculation.
  7. Select Run.
Create Standard Journals Request page
  1. The Process Scheduler Request page displays.  Use it to enter or update parameters, such as server name and process output format.
    • Use the Server Name drop-down button to select the appropriate processing server for the request.
    • Select OK.
Process Scheduler Request page
  1. The Process Scheduler Request page disappears.  The updated Create Standard Journals Request page displays.  Note the Process Instance number.  Select Process Monitor, then refer to the Process Monitor QRG for instructions.
Create Standard Journals Request page

Edit and Post standard journals just like regular journals.  See the Editing a Journal and Posting Journals QRGs.

  1. Process complete.

0 Comments

Add your comment

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