ctcLink Reference Center

test

9.2 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:

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

Navigation: Reporting Tools > Query > Query Viewer

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

For this example, the Run to HTML was selected and the query results are displayed below. Note the total number of Accounts. As new accounts are added/modified/archived, the query will be updated to reflect changes.
Select the desired link; Download the results in; Excel Spreadsheet, CSV Text File, or 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).