UO GL Transaction Listing by Period- Cost Centre - Account Report

 1st December 2022 - To improve performance we are making a change to the Ledger Parameters.

The two current parameters ‘Ledger From’ and ‘Ledger To’, will be consolidated into a single ‘Ledger’ parameter.

The default values will remain the same, and the users will be able to run the report for other ledgers, if required.

There are no changes to the report output.

Should you have any existing schedules set up for this report, please cancel them and set up a new schedule for
the updated report otherwise your schedule will error.

An example output of this report is available: New_UO GL Transaction Listing by Period- Cost Centre - Account  (XLS) .

Why run this report?

For a summary of all transactions for a range of departmental Cost Centres or Account Codes.

When should you run this report?

This report is recommended for your month/quarter end preparation and closure.

How to run this report

When running this report, make sure the Ledger is populated correctly and that the Periods entered will return a sensible amount of data. It is also prudent to restrict the parameter range of Cost Centres, Natural Accounts, Source of Funds. This is a
complex report, please see Hints and Tips below.

Report Parameters

gl trans new parameters

Which outputs does this report have?

•    Excel - a simple list of data that can be filtered but has no totals.

•    Excel Pivot - designed to make analysis of the data easier, the default layout can be changed once the report has opened in Excel from this output.

Which roles have access to this report?

  • XX General Ledger
  • XX General Ledger Sal
  • XX General Ledger Enquiry
  • General Ledger Divisional Finance Teams
  • UO Consolidation General Ledger Enquiry
  • UO General Ledger XX
  • UO Trust Fund General Ledger Enquiry

Hints and Tips

  • Staff costs charged to Projects have the employee details anonymised for data security reasons
  • No data exists for this report before August 2012
  • This report is extremely complex and contains considerably detailed data so, when running it, take care to enter suitable parameters to restrict the amount of data in the output; run it for a single period or a short range of accounts
  • There are 2 columns in the output “Cost Centre and Description” and “Natural Account and Description”; these are included to make the pivot outputs work
  • Applying the Cost Centre Parent parameter, a user in Chemistry, for example, could run the report for cost centre parent 104A1, to receive all transactions posted to the A1 ledger across Chemistry, without having to run the report across the entirety
    of Chemistry and then remove the lines from the A2 and B ledgers

Contact Us

 : Financial Systems
       Finance Division
       University of Oxford
       23-38 Hythe Bridge Street
       OX1 2ET

 : 01865 (2) 84800
 : Contact Financial Systems    

 : Opening hours:
       8.00am - 5.00pm
       Monday - Friday (except Bank
       Holidays, Easter and