UO GL Transaction Listing report

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
 

Report Parameters

uo gl transaction listing 363x466

 

 

 

 

 

 

 

 

 

 

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?

  • GL Concurrent Program Group
  • UO GL Fin Rep Reports
  • UO GL Div Fin Reports
  • UO GL Dept Reports
  • UO GL Dept Reports - Sal
  • OSPS GL Dept Reports – Sal

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
fssc logo

Contact Us


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

 financials@admin.ox.ac.uk
 : 01865 (2) 84800
 : Contact Financial Systems    

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

 
1 Start 2 Complete
finance.web.ox.ac.uk//uo-gl-transaction-listing-report
21/10/2019 01:47:37
List of site pages