Viewing Unbalanced Journal Entries

Purpose:  Use this document as a reference to view balanced and unbalanced Journal Chartfield totals.

Audience:  Finance or Business Office 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.

Key Takeaway: You should have a Debit and Credit with the same the ChartString, except for the GL Account number. A correction should have two lines; debit and a credit.

Viewing Balanced Journal Entries

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

  1. Select the Find an Existing Value tab.
  2. Select in the Business Unit field - Enter in the desired information into the Business Unit field.
  3. Select in the Journal ID field - Enter the desired information into the Journal ID field. Use additional criteria to refine results.
  4. Select the Search button. Select on the link from the search results.
  5. The Header page displays information that uniquely identifies a journal entry.
  6. Select the Lines tab.
Header tab
  1. On the Lines tab review the Totals section located at the bottom. The Journal Total Debits should equal Total Credits.
  2. Select the Totals tab.
Line tab page
  1. The Totals tab page displays. Select the View All / View 1 to review all Fund totals.

The Totals tab is checking for the Debits and Credits of the Fund (but also may look at other Chartfields).

Totals Tab page
  1. Section complete.
Viewing Unbalanced Journal Entries
  1. Select the Find an Existing Value tab.
  2. Select in the Business Unit field - Enter in the desired information into the Business Unit field.
  3. Select in the Journal ID field - Enter the desired information into the Journal ID field. Use additional criteria to refine results.
  4. Select the Search button. Select on the link from the search results.
  5. The Header page displays information that uniquely identifies a journal entry. Select the Lines tab; notice the Journal Status is E = Error.
  6. Select the Totals tab.
Lines tab
  1. The Totals tab displays the unbalanced Chartfields.

The Focus is on the Fund but will include other Chartfields if out of balance.

Notice the "NET" highlighted below which represents the out of balance amount(s). Please return to the Lines tab to make necessary corrections.

Totals tab page
  1. Section complete.

0 Comments

Add your comment

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