Chart of Accounts - Account Within Center Report

Report Name
Chart of Accounts - Account Within Center

Report Series Name
C-U-Gl-Coa-By-Center (agency run report)

Library
Source code for this report is located in GLPUBLIC.

Use
Use this report to verify the agency Chart of Accounts.

Content
This report lists all accounts for established centers, their description, class, group and status.

Totals
N/A

Column Headings

  • CENTER - lists budget funds, agency-defined cost centers (if applicable), and system-defined centers which are used with the suspense account and with summary accounts.
  • ACCOUNT - details accounting information and classifies revenue, expenditure, and balance sheet information.
  • Account Description
  • CLASS - indicates the accounting treatment of account types at year-end. Account types are determined by the first position of an account number. The following is a list of account types with their processing class.
  • Types Class
    • 1 - Assets 1
    • 2 - Liabilities 2
    • 3 - Fund Equity and Other Credits 3
    • 4 - Revenues 4
    • 5 - Expenditures 5
    • 6 - Budget (Revenues) 6
    • 7 - Budget (Expenditures) 7
    • 8 - Purchase Order Encumbrances 2
    • 9 - Reserved for Suspense Accounts 3
    • 0 - Accounts Payable Encumbrances 2
    • 65 - LTD Budget Accounts 2
    • 75 - LTD Budget Accounts 2
  • GROUP - lists the statewide object categories which are valid for each account type and generally corresponds with the third position of an account number for revenue/expenditure accounts.
  • NS CD (normal sign code) - indicates whether a particular account is generally regarded as a debit or credit account. However, to avoid alert reporting, the OSC assigns a NS CD = 0 which does not associate accounts with a debit/credit.
  • STATUS - identifies whether a center is active or inactive.
  • 0 = active
  • 1 = inactive

Run Statements
The run statement member name is C-U-GL-Coa-By-Center-Run.

000100 Options Library(Glpublic)
000200 Run C-U-Gl-Coa-By-Center ;
000300 Into Library Xxxxxxxx ;
000400 Variable Page-Break-By-Center ;
000500 'N' ;
000600 Select Gl-Company-Id ;
000700 'Xxxx' 'Xxxx' ;
000710 Select Gl-Account-Id ;
000720 'Xxxxxxxxxxxxxxxxxx' ;
000730 Select Gl-Center-Id ;
000740 'Xxxxxxxxxxxx' ;
000800 Exclude Gl-Cntr-Status-Code ;
000900 '1'

Type over the displayed variable values with your agency’s values.