16.52, Payroll Expenditure Listing (PEL)

16.52 - Payroll Expenditure Listing (PEL)

last updated: 03/08/2006
Purpose: The PEL details payroll expense activity for a department for a specified pay period. Payroll expenses are listed by account number, object code and employee.
To Get Report: PELs are available from Information Services Web (http://www.fso.arizona.edu/isw), Electronic Reports on Wednesday of pay week at approximately 8:30 a.m.

The Dean, Director, Department Head or his/her designee should retrieve this form, reconcile to the Payroll Time Roster and Payroll Online Payment Requests (POPR) and retain in the department in accordance with the Retention Policy.

Error Correction: If corrections are necessary, process a Payroll Expense Transfer (PET). Correct name, social security number and funding errors on the Personnel Action Form (PAF).
Policy Owner: Financial Management - Cash and Clearing

Field Descriptions| Reconciliation

NOTE: This report summarizes the payroll expenses for each department's account and object code. If an employee's salary is split funded with another department's account, the employee's full salary will not appear on the PEL for your department, only the portion paid by your department. Click here to view an example of this report.

Field Descriptions

  1. Payroll Ending: The date the pay period ended. The expense will usually appear in FRS the Thursday of pay week or the first Tuesday after FRS close.

  2. Account:/Object: The six digit FRS account number and the four digit FRS object code to which the expense is being charged. The employees paid from each account and object code are listed with Employee Identification Number (IDN) and Position Number.

  3. TRAN TYPE: Indicates the type of payroll transaction that generated this entry. The following codes may appear:

    Tran TypeGenerated by:Tran TypeGenerated by:
    CANCELCancellation of a State WarrantCURR PAYPayroll Time Roster and Supplemental Comp (Ern Typ "Z"
    EXP TRSFPayroll Expense Transfer (PET)HAND DRWHand Drawn Check paid from a prior pay period.
    OVER PAYRecovered overpayments to employees or cancellation of a Hand Drawn Check
    RETR ADJA rate adjustmentRETR PAYPayroll Online Payment Request (POPR) or Incentive Pay

  4. ERN TYP: Indicates the earning type reported on the Payroll Time Roster or POPR. Refer to 19.73, Payroll Earnings Type Codes for valid codes.

  5. HOURS PAID: Total number of hours charged to the account.

  6. DIST PCT: The percentage of the total expense charged to the account. Dist Pct of 1.00 indicates the account is funding 100% of the employee's total expense.

  7. GROSS PAY: The gross pay charged to this account number and object code.

  8. W
    C:     The Workman's Compensation (WC) Code assigned.

  9. E
    C:     The ERE Code (EC) assigned, based on the employee type.

  10. E.R.E. PERCENT: The Employee Related Expense (ERE) percent. This percent includes the following benefits (when appropriate): FICA, Retirement, Worker's Compensation, Unemployment Compensation, Health, Accident, Life and Disability Insurance, and Liability Insurance.

    Rates vary annually, and are published each year.

  11. E.R.E. APPLIED: ERE Applied = The Gross Pay x ERE Percent.

  12. TOTAL EXPENDITURE: Total Expenditure = Gross Pay + ERE Applied.

  13. EARNINGS DATE: The end date of the pay period in which the pay was earned. If different from the report date, this represents a Payroll Expense Transfer or other adjustment.

Reconciliation

The expense reported on the PEL can be tied to the FBM091, Report of Transactions, as follows:

  • The GROSS PAY amount is fed to FRS as a payroll expense. All CURR PAY expenses for an account and object code feed to FRS as one lump sum. All other expense transactions are totaled and fed as separate lump sums.

  • The ERE APPLIED amount is fed to FRS as the ERE expense (object code 2110). All CURR PAY ERE expense transactions are totaled and fed as a separate lump sum. All other expense transactions are totaled and fed as separate lump sums.

FRS Departmental Manual ·FSO Homepage ·UAInfo ·16 Reports, Reconciliation & Correction

maintained by: John Lockwood
last reviewed: 6/30/04