Agresso Web Reporting - Budget Holder Pay Details (UE)

Introduction

Budget holders will now be able to view payroll staff payment details made against their project/general ledger codes.

The following link Pay Details will be emailed to the budget holder together with their PL2 and GL2 reports on a monthly basis as part of their monthly report pack.  All users are encouraged to use the Agresso web facility as it is more efficient and provides more up-to-date results.  Users will only have access to their projects/cost centres as defined in the project master file in Agresso.  Access to the pay detail report is restricted at budget holder level therefore users will only be able to run this report for their defined codes.

The pay detail report can also be accessed directly from Agresso web reporting by selecting the link from the drop down list of available reports.

Instructions

Running the Report

To access Pay details report please click on the following link Pay Details

Click search to show pay results for all codes that the budget holder is responsible for. 

If you require data for a specific cost code this can be done using one of the following methods:

• Enter a cost code in the following field .  This can be entered as a single value i.e. 123A or if it is a range of codes use an asterisk sign i.e. 123A* or *123A* or *12*3A* depending on what is required. If the code is not known click the blue square icon with three dots to search for the appropriate code.
• Also you can use the report fields, as per below, to query on specific fields as long as you add a cost centre ("Costctre").
  
  Same search rules, using asterisk sign, as used above still apply.

Export report to Excel

Ensure that Pay Details [.xlsx] is ticked
Click OK

Click Open

If you are unable to export the report into excel and you are a thick client user you may need to install the following Agresso report engine into your PC's (this only needs to be done once):

Agresso Report Engine 8.25

Click run
Ignore any security warning messages.

If you are not an administrator to the PC you are trying to load this software on, then you will not be able to install the Agresso report engine.  If this is the case please contact your Faculty/Service IT support or IT helpdesk to help you with this.

Note: Please be aware that this report has been run on Windows 7 environment with Internet Explorer 9 and any pop ups may differ on other operating systems.

The excel report has subtotals by account code.

To expand the subtotaled values and see individual employees, click level number 4 on the subtotal hierarchy values on the top left hand side .

Note: Each sheet in excel represents data for a cost code. Therefore if a budget holder has more than one code with pay costs, the Pay Detail workbook will have multiple sheets at the bottom of it
.

Each report shows actual year to date payroll costs by employee, by account code, against the year to date budget and highlights the year to date variance.  If you have any queries about the data in your reports, please contact your Management Accountant.

Reports exported from Web Agresso must be stored securely in line with Data Protection Act.