General Ledger Accounts

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.

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 > Refresh Data Cache > reload data