General Ledger

440

Provides access to upload entries from a spreadsheet

CC_GL

The cost center followed by a dash followed by the general ledger account associated with the entry. For example, Cost Center 100, Account 300 would be 100-300. Each transaction should credit one account and debit another.

Yes

AMOUNT

The dollar value of the entry

Yes

BOOKNUMBER

The book number.

Yes

BOOK

The book. May be a number or text. For example PR.

You may not use the following system-generated books, which are used by Campus Cafe as part of automated processing.

• CH (Charge): Revenue to various G/L accounts based on transaction code.

• IN (Invoice): Offset to student A/R for per Fund Master (table GLCOMP) A/R designation or override to A/R in the transaction code.

• CR (Cash Received): Cash received.

• PM (Payment): Offset to student A/R for cash received per Fund Master (table GLCOMP) A/R designation or override to A/R in the transaction code.

• MI (Miscellaneous Cash) Non-Student Ledger related cash received.

• OA (Other amount) Offset for Non-Student related cash received.

• CD (cash Disbursement) Cash disbursed for checks written or ACH.

• AP (Accounts Payable) = Debit to A/P to offset cash disbursed and credit to A/P to offset expenses vouched.

• EX: Expenses to various G/L accounts per vouchers created.

• AX: Used for reversal of voucher in a voided check.

Yes

DESCRIPTION

Explanation of the entry, descriptions over 30 characters will be truncated to 30 characters

Yes

PET

Project expense transaction code associated with the entry

No