General Ledger Accounts
  • 21 Jan 2022
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

General Ledger Accounts

  • Dark
    Light
  • PDF

About GL Account Listing (General Ledger Accounts)

General ledger accounts represent lines within a general ledger. For example, one general ledger account may represent tuition collected while another represents office supply expenses. 

For institutions utilizing Campus Cafe's general ledger module the creation of general ledger accounts is required. Institutions not utilizing the general ledger module may still opt to create accounts to facilitate reconciliation between Campus Cafe and separate general ledger software.

Transaction codes must be associated with a general ledger account. For institutions not utilizing the Campus Cafe general ledger module or seeking to reconcile by general ledger account number, a single account number can be tied to all transaction codes.

Create General Ledger Account

Permission #102 is required to access this function.

  1. Navigate to Accounting > GL Account Maintenance
  2. Click Submit
  3. Click New Record
    FY: Select the fiscal year associated with the account. Options set using STParm ZZFISC
    GL Account: A number representing the account. Sometimes referred to as an object code, five digits or fewer to categorize assets, revenue, expenses and liabilities. Campus Cafe recommends the account number structure follow industry standards. Typically assets are 1xxxx, liabilities are 2xxxx, equity or fund balances are 3xxxx, revenues are 4xxxx, salary/fringe are 5xxxx and general expenditures are 6xxxx or higher.
    Cost Center Number: The number of the cost center
    Title: Text describing the account
    Type: Not in use
    Line Number: A number further representing the account
    Periods: The starting dollar amount for each period. Automatically populated by the system. Adjusting Custom Control GLBALLOCK will allow a manual override of these amounts.
  4. Click Create

General Ledger Accounts Example

Below is an example of setting up general ledger accounts.

Cost CenterGL AccountTitleLine NumberSubline Number
110001                      Cash Checking125
110005Cash Savings125
110008Petty Cash125
111000Accounts Receivable1210
120000Accounts Payable425
120005Deposits4210
105040000Tuition Revenue725
105040005Registration Fee Revenue7210
105040007Late Fee Revenue7210
105050000Salaries825
105060000Telephone Expenses865

Copy General Ledger Accounts

This function permits institutions to duplicate accounts in one fiscal year to another.

Permission #102 is required to access this function.

  1. Navigate to Accounting > GL Account Maintenance
  2. Click Copy
  3. In the Source Fiscal Year enter the fiscal year where the accounts already exist. Enter as FY#### (e.g. FY2122)
  4. In the Target Fiscal Year enter the fiscal year to copy the accounts to. Enter as FY#### (e.g. FY2122)
  5. Click Copy

Fund Numbers

Account fund numbers are set using a pattern based on the cost center. For example, all cost centers 9000-9100 could map to fund 5.

Configure fund numbers:

  1. Navigate to Admin > Custom Control Maintenance
  2. Next to ProgramId GLFUND_MAP, Sequence 2, Parameter 1 click the pencil
  3. In Parameter Value 1 enter Y
  4. Click Save & Back
  5. Next to ProgramId GLFUND_MAP, Sequence 1, Parameter 1 click the pencil
  6. In the Parameter Value 1 box enter the fund number followed by a colon followed by the first cost center number followed by a dash followed by the last cost center number.
    For example, if cost centers 9000-9100 should map to cost center 5 then you would enter 5:9000-9100
  7. Click Save
  8. Add additional mappings in Parameter Values 2-10 (one mapping per box) or using ProgramId GLFUND_MAP, Sequence 3, Parameters 1-10
  9. Click Save
  10. Refresh the cache by navigating to Admin > Admin Servlet > reload data



Was this article helpful?