/
General Ledger Structure

General Ledger Structure

About

How you structure your general ledger will depend on your institution’s business practices. You may also follow Generally Accepted Accounting Principles (GAAP) and recommendations from the National Association of College and University Business Officers (NACUBO).

Campus Cafe is flexible, containing the ability to create cost centers, accounts, funds and projects.

Required permissions

Module

Number

Description

Module

Number

Description

System Admin

293

Set a department style

System Admin

293

Define default funds for cost centers

Campus Cafe account number format

The general ledger account number is comprised of four components.

  1. Fund (has its own balance sheet)

  1. GL account (object code)

  1. Department (functional area)

  1. Cost Center

Note the project expense tracking (PET) number isn’t part of the general ledger number.

Set a department style

To make entry faster, only the cost center and GL account are entered or selected. The fund and the department are derived based on the other components entered.

The department can be represented (derived) by the first one or the first two positions of the cost center number. This allows up to 9 departments (functional areas) with up to 999 cost centers or up to 99 functions (functional areas) with up to 99 cost centers. This choice is made using a custom control.

Set department style:

  1. Go to Admin > Custom Control.

  2. In Search enter YG200A

  3. Click the pencil.

  4. In Parameter Value 1 enter A or B and click Save.

    A value of A will produce the first structure, and a value of B will produce the latter. The default value is B, which is recommended because it allows more flexibility in the number of functions.

Example, using the default value B, you might have the following cost centers:

Cost Center

Default Function

Cost Center

Default Function

4100

041

4200

042

4201

042

5000

050

5010

050

5120

051

Example, using the value A, you might have the following cost centers:

Cost Center

Default Function

Cost Center

Default Function

4101

040

4202

040

4203

040

5001

050

5011

050

5120

050

Define default funds for cost centers

The fund is derived based on the the cost center. If the cost center is less than 10, then the fund number will be the same as the cost center. If the cost center is greater than 10, the fund will default to 1, which is usually the current operating fund.

You may have a fund structure that looks like the below.

Cost Center

GL Account

Default Function

Default Fund

Cost Center

GL Account

Default Function

Default Fund

0001

1010 (Cash)

000

01

0002

2340 (A/P temporarily restricted)

000

02

0003

2560 (Endow fund balance)

000

03

4204

3450 (Tuition)

042

01

4205

5400 (Photocopy)

042

01

5002

5510 (Internet)

050

01

5012

5510 (Internet)

050

01

5120

5510 (Internet)

051

01

Generally, this means that a break down by cost center is required only in the current fund. There may be a need to have cost center breakdowns within other funds such as the temporary restricted or endowment fund. For example, these could be used to track various endowment funds.

Cost Center

GL Account

Default Department

Default Fund

Cost Center

GL Account

Default Department

Default Fund

8010 (Smith Fund)

2900 (Fund Balance)

090

02 (endowment)

8010 (Smith Fund)

3600 (Revenue)

090

02 (endowment)

8010 (Smith Fund)

7400 (Expense)

090

02 (endowment)

9010 (Rossi Fund)

2900 (Fund Balance)

090

03 (endowment)

9010 (Rossi Fund)

3600 (Revenue)

090

03 (endowment)

9010 (Rossi Fund)

7400 (Expense)

090

03 (endowment)

You can accomplish the above by configuring custom controls to assign default funds to ranges of cost centers.

  1. Go to Admin > Custom Control.

  2. In Search enter GLFUND_MA.

  3. Next to Seq Num 1, Parm 1, click the pencil.

  4. In Parameter Value 1 enter the cost center number followed by a colon followed by the first cost center number, a dash then the last cost center number. For example, if you entered 2:8000-8999 then fund 2 would be the default fund for any cost center between 8000-8999.

  5. In Parameter Value 2 enter the next default fund and cost centers associated with it. For example, if you wanted fund 3 to be associated with cost centers 9000 to 9999, you’d enter 3:9000-9999.

  6. Click Save.