Process a Journal Entry

A journal entry is one way to get information into the general ledger.  The process includes three steps:

  1. Create the journal entry
  2. Review Journal Entry Edit List
  3. Post the journal entry

Create the Journal Entry

NAVIGATION: ACTIVITIES menu > GL Journal Entry

  1. J/E Number
    1. Leave this field blank when entering a new journal entry.
    2. The system will assign the number based upon the last journal entry number shown in General Ledger Settings.
    3. To view a voucher that has been entered but not posted, you may enter the unposted J/E Number or browse to pull up a voucher.
  2. User ID
    1. The system will default the user identification to the initials of the person who is logged into the module.  
    2. The default User ID may be changed to create a unique identification for the journal transaction.
    3. The User ID entered is used as a selection criteria for the edit and posting programs.
    4. Example: If the initials CJG are entered for several transactions which are saved but not posted and another transaction must be entered, edited and posted before the other transactions. Change the initials CJG to ADJ1 (or a user identification of your choosing) for the User ID as you begin to enter the new journal entry.  
  3. DescriptionJ/E Header: type a description for the journal entry (up to 30 characters in length).
  4. Auto Reverse
    1. When this field is checked a reversing Journal Entry will be created for the first day of the next accounting period for all transactions in the Journal Voucher when it is posted.  
    2. When this box is checked, the entries will post for the date entered as usual; however, they will remain in the Journal Entry view.  The debits and credits will be reversed and the dates will be updated to the first of the next month and the Auto Reverse check box will be unchecked.  These entries will need posted a second time to complete the reversal.
    3. Uses:  This can be used every month to accrue expenses, but is most often used at the end of a fiscal  year to enter "Audit Reversing Entries".  This process can be used to move expenses and revenue recorded in one month back to the previous month.

  5. Balance
    1. As each line is entered for the JV, the balance information will change.  
    2. When you are finished with the journal entry, the balance area should display $0.00 when the journal transaction is in balance.
    3. If there is an amount displayed, the transaction is not in balance and will not be posted.
    4. If you need to post a one sided (unbalanced) entry, please call the help desk for assistance.

  6. Line #
    1. The system will automatically begin to number the lines beginning with 1.  
    2. You may change the number displayed to retrieve a previously entered line on the journal voucher transaction.
    3. The entry for a line # will not be complete unless you have entered the entire transaction and the line has dropped into the display grid at the bottom of the program.  
    4. You may call up a previously entered line by clicking in the edit box for the line in the grid.  You may also make changes to any undimmed area in the grid.
    5. You may delete a line that is in the grid by placing the cursor in any undimmed area of the line you want to delete in the grid and press DELETE.  
    6. You should see a "Delete this Line" confirmation box.  Press YES to delete the line.   NO will not delete the line.  
    7. If you see a "Delete this record" confirmation box when you are trying to delete a line always press NO or you will delete the entire journal entry.
  7. Account Number
    1. Enter or select the general ledger account number to apply the debit or credit amount to.  
    2. Account Numbers with an effective date range will return an "Account Number Entered not Valid for the Date Entered" error message, when an attempt is made to save the line with a transaction date that is not within the account number's effective date range.
  8. Account Description
    1. When a valid general ledger account number is selected this area will display the description for the general ledger account number and become dimmed which will not allow users to alter the description.
    2. There is a memo field for the line that allows users to enter a more descriptive entry for the transaction.
  9. Source
    1. Select a Source for the transaction.  JV will be the most common selection.
    2. A source is not required; however, it is a way to group entries for a better audit trail.  You may also printout or view some reports grouped by source.
    3. Source options:
      1. BC - Bank Credit
      2. BD - Bank Draft
      3. DP - Deposit
      4. IFC - Interfund
      5. INT - Interest
      6. JV - Journal Voucher

        Please note that the source IFC does not interface to the check book. Use Source IFC only for transactions to cash accounts that do not affect the check book. These transactions must balance and have a zero effect on cash over all.
  10. Reference
    1. Reference is an optional field.  
    2. You may enter anything you would like to track for the entry line.
    3. Use a check number, invoice number, name, etc. (up to ten characters).
  11. Transaction Date
    1. Enter or select a transaction date for this entry.  
    2. A transaction date is required and is the date the debit or credit will be recorded in the general ledger.  
    3. For accounts linked to a check book, the entry will also be recorded in the selected check book.
  12. Memo
    1. This field is provided for users to place a memo for the transaction line being entered.  
    2. The memo will follow the transaction into the general ledger trial balance report.
  13. Debit or Credit
    1. Enter the amount for the transaction in either the debit or credit field. Do not enter a value in both fields.
    2. The amount entered will either add to or subtract from the balance display field above the entry line.
    3. The line being entered is not completed until it has dropped down into the grid area below the entry line.
  14. Display Grid
    1. As lines are completed, they will drop down into the display grid.  
    2. Some information may be edited/changed within the grid or lines may be brought back into the entry area for editing.
    3. Click the Edit box to checkmark it and bring the line back up for editing.
    4. Lines may be deleted from within the grid by highlighting the line and clicking the delete button.  
      1. Users will see an information box displaying "Delete this line".  
      2. Click YES to confirm the deletion or press NO to close the information box without deleting the line.
  15. The Display Grid contains the following information:
    1. Edit
    2. Line Number
    3. Account Number
    4. Account Description
    5. Date
    6. Debit
    7. Credit
    8. Source
    9. Memo
    10. Reference
    11. Allocation Model
  16. Save
    1. Each line of the journal entry is saved once it is dropped down into the grid.
    2. Click SAVE at the top of the view to save all entries prior to leaving this view and moving on to the GL Journal Edit List.
    3. Possible errors before a save is allowed:
      1. Account Number Entered not Valid for the Date Entered - in the GL Account Master, the general ledger account entered has either a Start Date or an End Date the excludes the date of this entry.
      2. The Date Entered Locked From Entry - The Date entered is locked in the Accounting Period Master or the Check Book has already been reconciled and is now locked from entry.

Adjust an Unposted Journal Entry

If an unposted journal entry needs adjustments after reviewing the edit list, you may come back to the Journal Entry screen.

  1. J/E Number: click the browse to view the list of unposted journal entries and select the entry you want to edit
  2. Make any changes needed
  3. Save the journal entry
  4. Review the edit list again

Delete an Unposted Journal Entry

Only Journal Entries that have not been posted may be deleted. Once a journal entry is posted, you will need to process another journal entry to correct it.

  1. J/E Number: click the browse to view the list of unposted journal entries and select the entry you want to delete
  2. Make sure your cursor is in the J/E Number field
  3. Click DELETE
  4. You will receive a "Delete this record" confirmation box.  Upon pressing YES, the entire journal entry is deleted.

GL Journal Edit List

The edit list will subtotal each journal voucher. A JV that is out of balance will be noted on the edit list. If the total of all JVs balance, they will post.

NAVIGATION: ACTIVITIES menu > Journal Edit List

  1. Display/Order by: click the circle to select the sort order by:
    1. Entry Number
      1. When selected, the edit list will show the information for the journal entries in the order that they were entered into the Journal Entry view.
    2. Account Number
      1. When this option is selected, the journal entry information will be shown in account number order.
  2. Reference Number User ID (Blank for All)
    1. Leave this field blank to generate an edit list containing all entered but unposted journal entries.  
    2. Enter a User ID to constrain the edit list to only those journal entries that contain that user identification.
    3. The default User ID used when entering a journal entry are the initials of the person who is logged into the program.  
  3. Journal Number: use this field to select one journal entry to review
  4. Filtering
    1. A Journal Number or Filtering may be used as additional selection criteria or these fields may be left blank.
    2. Use the Filtering options to find out of balance entries within your Balance Controlled Segments.  
    3. For Example: If Segment Fund is out of balance for Funds 10 & 20, try running the edit list for Fund 10 to see only those entries to help find out what entry is extra or missing.  Then run the edit list for Fund 20 and compare the two lists to find the incorrect entries.
  5. Print, preview, or save the report (see Report Preview, Print and Save Options).
  6. Review the edit list:
    1. If a journal entry is out of balance, a notice will be displayed or printed stating "Posting is Out of Balance".
    2. Two out of balance transactions that together balance the edit list will post.
    3. If any balanced controlled segments are out of balance, the end of the edit list will have a summary of these segment balances.  This will show each segment that is out of balance with the total Debits, Credits and a Net (out of balance).
    4. Warning:  If summary shows two different segments such as Fund and Department out of balance, it may be the same entry causing both balance issues.
    5. If out of balance segments are listed, or if you need to edit an entry Go to ACTIVITIES menu > GL Journal Entry; click on the browse button by the J/E field and select the voucher to edit.
  7. When finished editing, review your edit list again.

Post GL Journal Entries

NAVIGATION: ACTIVITIES menu > Post Journals

  1. User ID
    1. The User ID will default to the user logged in.
    2. To post all journal entries regardless of who entered, remove the User ID and leave the field blank. All journal entries will be posted.
    3. To post only one user's journal entries, enter the user initials in this field. Only entries with this User ID will be posted.
  2. Click POST
  3. Print, preview, or save the report (see Report Preview, Print and Save Options).
  4. If you receive the following error during the posting process, "Errors in Posting Detected", click the View Errors button.  This will display the error report.  
  5. Errors may be for out of balance segments or Locked Accounting Periods. Review the errors and edit the journal entries to correct or reopen the accounting period(s).  
  6. After correcting the journal voucher, review the edit list again and post.

Drag and Drop Journal Entries

  1. Journal entries may be created in Microsoft Excel, version 2003 or later and "dragged and dropped" onto the view.
  2. Lines within the excel file that have zero entered for both the debit and credit fields will not import into the journal.
  3. Blank lines within the import file will stop the import from completing.
  4. If errors are found in the Excel file, the process will be halted and information will be displayed in the Excel file to indicate where the error is.

See General Ledger - Import Journal Entries

See General Ledger Journal Listing

8/2023

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388