Analysis Type

What is an Analysis Type?

An Analysis Type is a code used on a ChartString that, with an account code value, defines the type of transaction the journal line row represents.

In BFS, a single transaction can result in multiple transaction rows as it moves through the system. For example, a payroll expense (PAY) can create fringe (CBP) and overhead (SFA) that need to be tracked against budget (BUD) and billing rows (BIL/BLD). By assigning Analysis Types for each, we can track the transaction rows resulting from this single transaction throughout the different stages of the project.

It is important to note that an Analysis Type is not a ChartField within the Berkeley Chart of Accounts, but rather a control data code.

UC Berkeley Analysis Types

The tables below list Analysis Types and related account code values configured within BFS.

General Ledger

Applicable Accounts

Type

Analysis Type

Description

10000-45049
45051-49951

GL Offset

GLR

Offset (Account begins with 1, 2, 3 or 4)

45050

Program Income

PRI

Program Income Revenue

50211, 50212,
50215, 50240,
50241,50242,
51029, 51210,
51231, 51232

Actual Salaries and Wages

PAY

Time and Labor Actual

52000-52010
52020-53090
54110-57307
57311-59998

GL Expense

GLE

Actual or Accrual Expense (Account values 5xxxx)
*Account 57399 is a Non-billable account

52011, 52012,
50213, 53410,
53800, 53801,
53802, 57310

Benefits

FRP

Paid Fringe Benefits

53100-53105
53200-53400
53411-53706
53803-53922
53941, 53960

Non Grants Fringe Benefits

FRI

Fringe No CBR (not used on Grants)

57720

Deficit Clearing

DFC

Deficit Clearing Expense

5XXXX

Encumbrance

COM

Commitment incl. PO & Subcontract

71110-75195

GL Transfer

7XX

7XXXX Transfer

Cost Share

Applicable Accounts

Type

Analysis Type

Description

50211, 50212, 50215, 50240, 50241, 50242, 51029, 51210, 51231, 51232

Salaries and Wages

CPY

Cost Share Payroll

52011, 52012, 52013, 53070, 53410, 53800, 53801, 53802, 57310, 74195

Benefits

CFR

Cost Share Fringe Benefits

5XXXX

GL Expenses

CGE

Cost Share GL Expenses(CF1 value 2xxxxx)

5XXXX

Award to Award Cost Share

CAA

Award to Award Cost Share Actual Expense

Budget

Applicable Accounts

Type

Analysis Type

Description

5XXXX Budgetary Accounts

Budget

BUD

Budget

5XXXX Budgetary Accounts

Budget

CBU

Cost Share Budget

Berkeley Specific Requirements

  • BFS validation requires that all C&G ChartStrings (those with a C&G Fund or a Cost Share CF1 value) have an Analysis Type value identified on the transaction.
  • C&G ChartStrings with a 5xxxx (Expense) Account code should not have a GLR Analysis Type except for Contra Expense accounts related to intercampus vouchers.