General Ledger | Finance Division

skip to content

Training Resources

GL1 - Getting Started in the General Ledger (classroom) (book onto GL1 | GL1 course manual)
General Ledger Transfer Codes (online) (book onto GL Transfer Codes)
GL2 - General Ledger Reporting (classroom) (book onto GL Reporting | GL2 course manual)

Reference Material

In addition to the documentation below there is a selection of GL-related R12 FAQs you can review.

Documentation	Supporting materials
General
General Ledger Overview The Grants Module and GL Chest Budgets Chart of Accounts Source of Funds Codes Transaction Codes Donations The Personal Profile Form Common Problems to look out for
Journals
Posting a Batch Raising GL Journals Petty Cash Reverse Journals Change the Period for a Journal Journals - More Actions Deleting an Unposted Journal Processing a Credit Card Journal	Expenditure accrual journals Unearned (deferred) revenue journals Other debtors (income accruals) journals Prepayment journals
Online Enquiries
Reviewing Account Balances Online Summary Templates Online Journal Enquiry Funds Available Enquiry
Reports
Standard GL Reports in COGNOS and UFS Finding Reports you have requested in UFS Reprint Reports Monitoring Standard Reports in UFS Exporting CUFS Reports to Excel Account Analysis Reports Account Analysis School Budget to Actual Report in UFS Running Journal Reports Running Standard GL Reports in UFS Segment Value Listing Transaction Code Balances (UFS) Report Transaction Code Balances Excel (UFS) Trial Balance Detail Full Field Positive, Negative, Debit, Credit: What does it all mean? GL Summary Data (UFS) COGNOS Reports Financial Summary Reports Journal Lines Detail Running the Budget Report in COGNOS School Level Reports GL Actual Journal Lines GL Balances with Budget GL Budget to Actual GL Budget Transactions GL Journal Line Details GL Summary Data GL Transactions	Quick Reference Guides (QRGs) : Account Analysis (Excel) Budget to Actual - Excel Version (UFS) Chart of Accounts - Segment Value Listing (UFS) Journals Lines Report (UFS) Transaction Code Balance (UFS) Trial Balance Detail Full Field (UFS) The Reporting Catalogue COGNOS Reports Actual Journal Lines Detail by sof and cc Department Budget to Actual report by cc or by sof Financial Summary by Cost Centre
Exporting & working with Excel
How to Excel with CUFS Part 1 (Excel 2003) How to Excel with CUFS Part 2 (Excel 2003) How to Excel with CUFS Part 3 (Excel 2003)	How to Excel with CUFS Part 1 (Excel 2010) How to Excel with CUFS Part 2 (Excel 2010) How to Excel with CUFS Part 3 (Excel 2010)
New developments being rolled out to departments
Ownership & Categorisation of cost centres What is this? User Guide - Adding owners and categories in GL Departments currently involved with the limited roll out WebADI - configuration changes	FAQs Associated reports: Account Analysis (filter by Categories) Account Analysis (with Categories)
Non-chest plans in UFS What is this? Departments currently involved with the limited roll out	Associated reports: Budget to actual (including plan with conditional column display)

Printer-friendly version