skip to navigation skip to content
Wed 20 Nov 2019
09:30 - 16:30

Venue: Finance Division, Greenwich House, Ferrara Room (IT Training Room)

Provided by: Finance Training


Booking

Bookings cannot be made on this event (Event is not taking bookings).


Other dates:


2020


[ Show past events ]



Booking / availability

GL Part 2: Reporting in the General Ledger
Prerequisites

Wed 20 Nov 2019

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:

  1. completed the GL Part 1: Getting Started in the General Ledger course
  2. a LIVE GL responsibility in CUFS
  3. a Raven Password, with a Cognos account activated (see table below)
  4. completed the pre-course questions that will be emailed out to you a few days before the course. These must be returned to the trainer for review by the date given in the email.

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

Cognos Action required
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. 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

Sessions

Number of sessions: 1

# Date Time Venue Trainers
1 Wed 20 Nov   09:30 - 16:30 09:30 - 16:30 Finance Division, Greenwich House, Ferrara Room (IT Training Room) map Christine Rogerson,  Lin Cheng
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

Booking / availability