NewSouth HR Reporting Running the Payroll Analysis Query

1. NewSouth HR Reporting Running the Payroll Analysis Query

2. Select New South HR by a left mouse click once on NewSouth HR icon

3. Select Inquiries and Reporting

4. Select Reporting

5. Select Financial Information

6. Select Payroll Analysis Report NOTE: The parameters for the Payroll Analysis Query are defined in the same panel as the Payroll Analysis Report.

7. Name the Run Control e.g. payroll_analysis A Run Control ID is an identifier or title given to a specific report to allow use of the same parameters in the future. Alternatively, you may choose to use the same Run Control ID for every report (e.g. your initials) and redefine all parameters each time a report is run. Enter the chosen Run Control ID and click

8. Define the parameters to include the required payroll details. Pay End Date: Enter the Pay End Date or click to access a dropdown list of Pay End Dates highlight the appropriate date and click (Compulsory Field)

9. Note: The Business Unit must be defined before the Department can be defined. Business Unit: Click to access a dropdown list of appropriate Business Units There are two Business Units: UNSWA for Kensington, University College & others TERM6 used rarely for some grants and CRCs soon to be phased out. Note: A business unit that corresponds with the department must be selected or a nil report will result i.e. UNSWA must be selected for a Kensington Department (Compulsory Field)

10. Note: The Business Unit must be defined before the Department can be defined. Department: Define the department by entering the Department ID or click to access a dropdown list of Department IDs If unsure of the Department ID, search by entering part of the name of the department in Description field (Note: case sensitive) and click highlight the appropriate department and click (Compulsory Field)

11. Fund Code:Leave the field blank to report on all Fund Codes or click to access a dropdown list to select and report on a specific fund code

12. Account Code:Leave the field blank to report on all Account Codes or click to access a dropdown list to select and report on a specific account code

13. Sub Classifications:Leave the field blank to report on all Sub Classifications or click to access a dropdown list to select and report on a specific Sub Classification

14. Project/Grant:Leave the field blank to report all Project/Grant or click to access a dropdown list to select and report on a specific Project/Grant

15. Tick the Print Details check box to include totals by earnings type e.g. Basic Salary, Recreation Leave etc or leave unchecked to report totals for each employee.

16. Save . After saving the panel navigate to: View > Navigator Display > Query

17. A blank panel is presented. Click the to maximise the panel and view the query names in alphabetical order. Select To run to Excel: Right mouse click on and choose Run to Excel. Enter your Run Control ID or click to access the drop list, select from the list and click The result of the query will appear in Excel.

18. To run the query to the screen: Double click on Type in the name of your run control e.g. payroll_analysisor click to access the drop list and select the run control, click and click again. The query result will appear on the screen.

19. Saving to Your Local Drive Follow the steps to save the query to your local drive. Mac Select File > Save As Enter L:\directory path\..\filename’ Press Enter or Return Select the desktop/disk volume from the list displayed PC Select File > Save As Choose Client C: (L:) and choose appropriate C:\ drive location and file name