GL Part 2: Reporting in the General Ledger

Prerequisites

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.

Departmental accounts staff and those responsible for managing departmental finances.

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

• attended a Getting Started in the General Ledger course
• a LIVE GL Responsibility
• a Raven Password
• a COGNOS account.

  If you do not have one, 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

You will also receive an email with some pre-course questions , which must be completed by the date in the email and emailed to the trainer for review.

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

Number of sessions: 2

• Generate and discuss the standard reports required for monitoring departmental finances
• Look at common items that appear on reports and what they mean
• Study and discuss the significance of positive/negative and debit/credit values
• Cancel reports that you have set to run
• Re-print and copy reports quickly
• Discuss some of the common mistakes to look out for when reviewing departmental accounts

To run various reports to monitor departmental accounts and interpret the data.

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

• Lunch is not provided.
• Please indicate at the time of booking if you wish to stay for the optional afternoon workshop.

One half day session.

Every other month