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

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.
    1. If it did not automatically populate, enter or select the business unit in the Business Unit field.
    2. 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.
    3. 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.
    1. Enter an appropriate description in the Long Description field, e.g. “Advertising Accrual.”
    2. Enter or select 'ACTUALS'  in the Ledger Group field.
    3. Enter ‘ONL’ in the Source field.  This is the code used for manual journal entries.
    4. Use the SJE Type drop-down button to select Model -- Do Not Post.
    5. When the Header page is complete, select Lines.
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.

  • Enter or select the appropriate account in the Account field.
  • Enter or select the appropriate operating unit in the Oper Unit field.
  • Enter or select the appropriate fund in the Fund field.
  • Enter or select the appropriate department in the Dept field.
  • Enter or select the appropriate class in the Class field.
  • Enter the journal entry amount in the Amount field.
  • Enter or select the appropriate state purpose in the State Purpose field
  • Select Insert Lines to add the off-setting item with the Copy Down ID functionality.
  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.
  1. Next, edit the model journal. Select Process.
  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.

  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 displasy.  Enter existing search criteria or select Add a New Value  to create a new value.
    • Enter a meaningful journal ID for the standard journal in the Standard Journal field.
    • 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.
    • 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).
    • 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).
    • Use the SJE Type drop-down button to select the SJE type.  SBCTC will use ‘Recurring on a Schedule.’
    • 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.
    • Enter or select the appropriate date that the model journal was created into the Journal Date field.
    • Use the Schedule drop-down button to select the processing frequency for the SJE.
    • Use the From Date and the To Date fields to define the time range of the SJE entries.
    • 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.
    • Select Save.
  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.

Note: A Run Control ID is an identifier that, when paired with your User ID, uniquely identifies the process that you are running. The Run Control ID defines parameters that are used when a process is run. These parameters ensure that when a process runs in the background, the system does not prompt you for additional values.

  • 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.
    • Use the Process Frequency drop-down button to select the processing frequency.  SBCTC will use ‘Always.’
    • Enter or select the appropriate unit in the Unit field.
    • Use the From SJE and the To SJE fields to define the journal range of the SJE entries.
    • Enter a brief description of the processing request in the Description field.
  2. SBCTC is utilizing budget commitment controls.  Select the Recalculate Budget Date checkbox to create a standard journal entry with a budget recalculation.
  3. Select Run.
  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.

Note: A Process Instance number appears. This number helps you identify the process you have run when you check its status.

  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.

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

E-Mail me when someone replies to this comment