General Ledger Account List

Purpose:   The following provides the steps to view the active General Ledger Accounts or Chart of Accounts (COA) in ctcLink.

Audience:   Everyone within ctcLink.

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

  • ZD_DS_QUERY_VIEWER

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

General Ledger Account List

Navigation: Reporting Tools > Query > Query Viewer

  1. The Query Viewer page displays.
  2. Ensure that Query Name is selected from the *Search By drop down menu. Enter the query QFS_GL_ACCOUNT_TBL_ACTIVE into the "begins with" field.
  3. Select the Search button.
  4. The query results will display.

Select the link Add to Favorites to add this query onto your own favorites list.

  1. Select Run to HTML, Excel or XML to display query results.
  2. For this example, the Run to HTML was selected and the query results display on the page. Note the total number of Accounts. As new accounts are added/modified/archived, the query will be updated to reflect changes.
  3. Select the desired link from the Download results in options from the upper left area of the results page:
    1. Excel SpreadSheet
    2. CSV Text File
    3. XML File

Note: all Active Accounts in ctcLink will display with the following fields/values:

  • SetID = WACTC (Accounts are Global and maintained by SBCTC).
  • Account = Each General Ledger Account has 7 digits.
  • Effective Date =  Date the Account was activated.
  • Status as Effective Date =  Active (excludes old COA).
  • Description =  Long description displayed.
  • Short Description =   Short description displayed.
  • Account Type =   Short Account Type Description.
  • Account Type Description =   Long Account Type Description:  A - Assets, E - Expenses, L - Liabilities, R - Revenue, Q - Equity.
  • Bud. Only =   Y or N (Budgetary Accounts Only. Note: only N or non-budgetary accounts can be used for Accounting Transactions).
  1. Process complete.

Video Tutorial

The video below demonstrates the process actions described in steps listed above. There is no audio included with this video. Select the play button to start the video.

Video Tutorial Via Panopto

View the external link to General Ledger Account List. This link will open in a new tab/window.

0 Comments

Add your comment

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