skip to navigation skip to content
Instructor-led course

Provided by: Finance Training


This course has 6 scheduled runs. To book a place, please choose your preferred date:


2019


2020

Events available

GL Part 2: Reporting in the General Ledger
Prerequisites


Description

This course provides users the opportunity to run General Ledger reports and how to interpret them when managing departmental funds.

You are invited to bring with you any reference documents that you may have detailing your own departmental codes.

Target audience

Departmental accounts staff and those responsible for managing departmental finances.

Prerequisites

Your booking will remain provisional until you have completed the following prerequisites and advised finance.training@admin.cam.ac.uk that you have:

  • previously attended GL Part 1: Getting Started in the General Ledger course
  • a LIVE GL Responsibility
  • a Raven Password, with a Cognos account activated.

A few days before the course, you will be sent an email with some pre-course questions. These must be completed by the date in the email and emailed to the trainer for review.

If you do not have Cognos activated, please complete the online Cognos Access Request form, URL: https://www.finance.admin.cam.ac.uk/cognos-access-request (Finance Division > Systems > Reporting > Cognos Access Request).

Please liaise with your department key contact/line manager to ensure you complete the form correctly. If you require access to more than one department, all the departments within the school, or across schools, this must be clearly indicated on the form. You also need to know whether or not you will need to receive 'burst reports in your school/department. These are reports that are automatically generated and emailed to you regularly.

Once you have access to Cognos, it is important to check that you can view the reports within the General ledger folder by following the steps below.

  • Log into COGNOS by clicking on COGNOS Login: http://www.admin-reporting.cam.ac.uk/
  • Click on 'Log into Cognos'
  • Enter your CRSID, raven password and click OK
  • Public Folders page will display.
  • Click on the folder called 'LIVE'
  • Click on the folder for your School
  • Click on the folder titled 'Departmental (Shared) Reports
  • You should have a folder called 'General Ledger Reporting' with various reports listed

Upon completion of all prerequisites, your booking for the course will be approved.

Objectives
  • Generate and discuss the standard reports required for monitoring departmental finances
  • Look at common items that appear on reports and what they mean
  • Discuss some of the common mistakes to look out for when reviewing departmental accounts
  • In UFS, copy, re-print and cancel reports that you have set to run
  • Learn how to use basic Cognos tools
Aims

To run various General Ledger reports, using both Cognos and UFS, to monitor departmental accounts and interpret the data.

Format

The session will be a mixture of presentation, demonstrations and hands on practice.

Notes
  • Lunch is not provided.
Duration

One day session.

Frequency

Every other month

Related courses
Themes

Events available