Johns Hopkins University | University Finance Home

 

Salary

salary

Overview

The salary report section displays the salary paid by employee.

This report allows the user to:

  • Quickly look and see who is being paid
  • Easily check employee names
  • Look at salary types
  • Review Payroll Cost Transfers completed this period
  • Review Vacation credits
  • What is included?

    vacationcredit

1. Header Section

salaryheader

The Header Section provides identifying information about the non-sponsored cost object from SAP Master Data such as:

  • Fund Center
  • Funded Program (this is the name of the Faculty member that receives the report, this is updated by fqchelp@jhu.edu)
  • PI for Funded Program (this data is based on SAP Master Data and must be updated using the Master Data Request Tool, it is not related to the report distribution)
  • Responsible Person
  • Business Area
  • Fund
  • Fund Type
  • Function Group
  • Financial Function

Updates to a more meaningful name are allowed as it pertains to the fund center or funded programs. The department should use the Master Data Request Tool in SAP to initiate the change process.

If an update is approved all SAP applications using this data will also be updated.

2. Salary Columns

Click on letter of column you wish to review:

salcolumn1 salcolumn2 salcolumn3 salcolumn4 salcolumn5

sallarge

A. Employee  top

  • First column on the Salary report
  • Field shows Text only
  • Sorted by Last Name

B. GL Account  top

  • Second column on the Salary report
  • Field shows Text only
  • Description of type of salary, for example admin and faculty

C. End of Pay Period  top

  • Third column on the Salary report
  • Field shows Text only
  • Use this column to see if a person is paid from a previous period, look for possible Payroll Cost Transfers or Vacation Credits

D. Wage Type  top

  • Fourth column on the Salary report
  • Field shows Text only
  • E210SIOf - identifies Vacation Credits

E. Pay Period Salary Amount top

  • Fifth column on the Salary report
  • In this example: the report was run for FY/Period 06/2017 (December, 2016)

3. Sub-report Subtotals

Screen shot below, reconciles the summary page with the salary report and provides detail for each non-payroll commitment.

nonpayrollcom

Error Corrections

To correct an error contact the analyst that reconciles this account or the department administrator and request a Payroll Cost Transfer to be completed.

Sub-report Exclusion

This sub-report has omitted several items so it provides the user with only pertinent data elements to properly reconcile the account.

  • Fringe detail

 

Salary Commitment

salcomm

Overview

The Salary Commitment report displays the salary commitments by person and the period(s) they will be paid. A user can quickly look and see who will be paid on this account.

What is included?

  • Future salary commitments by employee (as of month close) through the fiscal year.

This report has omitted several items so it provides the user with only pertinent data elements to properly reconcile the account.

1. Header Section

salcomheader

The Header Section provides identifying information about the non-sponsored cost object from SAP Master Data such as:

  • Fund Center
  • Funded Program (this is the name of the Faculty member that receives the report, this is updated by fqchelp@jhu.edu)
  • PI for Funded Program (this data is based on SAP Master Data and must be updated using the Master Data Request Tool, it is not related to the report distribution)
  • Responsible Person
  • Business Area
  • Fund
  • Fund Type
  • Function Group
  • Financial Function

Updates to a more meaningful name are allowed as it pertains to the fund center or funded programs. The department should use the Master Data Request Tool in SAP to initiate the change process.

If an update is approved all SAP applications using this data will also be updated.

2. Salary Commitment Columns

Click on letter of column you wish to review:

salcomcolumn1 salcomcolumn2 salcomcolumn3 salcomcolumn4 salcomcolumn5

salcomlarge

A. Employee  top

  • First column on the Salary Commitment report
  • Field shows Text only
  • Sorted by Last Name

B. GL Account  top

  • Second column on the Salary Commitment report
  • Field shows Text only
  • Description of type of salary, for example student, admin and faculty

C. Commitment Start  top

  • Third column on the Salary Commitment report
  • Field shows Key only

D. Commitment End  top

  • Fourth column on the Salary Commitment report
  • Field shows Key only
  • For sponsored awards check the budget end date; commitments after the budget end date are not included.

E. Commitment Amount top

  • Fifth column on the Salary Commitment report
  • In this example: the report was run for FY/Period 06/2017 (December, 2016)

3. Sub-report Subtotals

Screen shot below, reconciles the summary page with the salary commitment and provides detail for each payroll commitment.

salpayrollcom

Error Corrections

To correct an error contact the analyst that reconciles this account or the department administrator and request a Payroll Cost Transfer to be completed.

Sub-report Exclusions

This sub-report has omitted several items so it provides the user with only pertinent data elements to properly reconcile the account.

  • Fringe detail
  • Payroll Cost Transfers processed after the month-end close cutoff date.
  • Commitments after budget end date

 

 

 

© 2012 The Johns Hopkins University. All rights reserved. Baltimore, Maryland. JHU Home