Payroll Expenditures without Fringe

 

This guide will cover:

  • How to navigate and run the Payroll Expenditures without Fringe report on the Table of Contents
  • How to interpret the report which provides the payroll expenses for monthly and bi-weekly paid employees

Fringe benefit costs are not shown on this report at this time, because the system only allows one fringe rate while the University of Wyoming uses 5 different fringe rates. Therefore, fringe is calculated within finance and loaded to the GL and PPM.  Users can manually calculate fringe using this report and the fringe rates for the current fiscal year. Fringe rates are located the Budget Office website.

Additionally, this report will only return natural accounts above 60000 for salary expenditures.

Step One

Upon accessing WyoCloud from WyoWeb, navigate to Reports and Analytics.

  • Click on the Navigator (three horizontal lines) in the upper left corner of the homepage.

  • First click on Tools to expand (you may need to scroll within the navigator), then click Reports and Analytics.

  • The Reports and Analytics page is displayed.

Step Two

Navigate to the Transactional Reporting Table of Contents, where the Invoice Status Report is located.

  • Select the small double arrow above the search.

  • From the drop down, select Shared Folders.

  • All Shared Folders you currently have security access for will display.  To locate the Transactional Table of Contents, begin by clicking on the Custom folder (you may need to scroll to locate it).

  • Click Dashboards.

  • Click Table of Contents.

  • To open the Table of Contents, click on the title

sign23

Note: You can set the Table of Contents as a favorite for easier navigation in the future.  For directions see this Quick Reference Guide.

 

Step Three

Running the Payroll Expenditures without Fringe report

  • Under the General Ledger and Budgetary Control heading on the Table of Contents, click on Payroll Expenditures Without Fringe link.

 

  • The report will open in a new browser tab. (Note – At least one prompt must be entered to run the report)

Step Four

Narrowing down and running the Payroll Expenditures without Fringe report

  • At least one prompt must be selected to run the report. You may use the following prompts on the left of the report to run the report to only display information relevant to your needs.
    • Paid Date From – Paid date of the payroll transaction. “From” provides flexibility to use a range in conjunction with the Paid Date To prompt.
    • Paid Date To – Paid date of the payroll transaction. “To” provides flexibility to use a range in conjunction with the Paid Date From prompt.
    • Period Start Date – Minimum start date
    • Period End Date – Minimum end date
    • Payroll Name – Type of pay schedule/frequency: bi-weekly or monthly.
    • Payroll Type – Type of payroll entry: Balance adjustment costing, Cost adjustment, Estimate costing, Payroll calculation, QuickPay, Retroactive costing and Reversal.
    • Natural Account – Natural account associated with the payroll transaction.
    • Fund Source – Funding source the payroll transaction is expended from.
    • Organization – Organization the payroll transaction is expended from for either the general ledger chart of accounts organization or a project organization.
    • Project – Project the payroll transaction is expended from if using project funds.

  • After selecting desired prompts, click Apply

 

  • The report will begin to load. 
    • In FireFox, once it’s ready, an Excel pop-up window will open. You can select to open immediately or save the file based on your preference.  Click Ok.

 

  • In Chrome, once it’s ready, an Excel file will appear in the downloads section at the bottom.  Click the file to open it.

 

  • The report will open in Excel. 

Step Five

Interpreting the Payroll Expenditures without Fringe Report

  • The following columns are included:

Column Name

Description

Assignment Number

Assignment number of employee. If an employee has multiple assignments, the additional assignments will be denoted with a dash      “-“ and a number “2,3,4” following the assignment number (ex. E46908-2).

Assignment Name

Assignment type is the employee’s job name. 

Employee Number

Employee number. The employee number will be the same for all assignments.

Last Name

Last name of employee.

First Name

First name of employee.

Accounting Date

Date the payroll transaction is applied to the general ledger of the funding source.

Paid Date

Date the payroll transaction was paid.

Date Earned

Last date the payroll transaction was earned. (i.e., monthly payroll transactions have an earned date equal to the last day of the month; biweekly payroll transactions have an earned date of the last date in their paycycle).

Period Start Date

First day of pay period.

Period End Date

Last day of pay period.

Run Type

Regular or supplemental type pay. May also return a null status.

Payroll Name

Represents monthly or biweekly pay frequency.

Payroll Type

Type of payroll entry: Balance adjustment costing, Cost adjustment, Estimate costing, Payroll calculation, QuickPay, Retroactive costing and Reversal.

Element

Type of payroll expense: Salary, Mobile Communication Device, Temporary increase, supplemental pay, etc.

Entity

Chart of account segment for the entity of the payroll transaction.

Natural Account

Chart of account segment for the natural account of the payroll transaction.

Fund Class

Chart of account segment for the fund class of the payroll transaction.

Fund Source

Chart of account segment for the fund source of the payroll transaction.

Organization

Chart of account segment for the organization of the payroll transaction.

Expense Class

Chart of account segment for the expense class of the payroll transaction.

Program

Chart of account segment for the program of the payroll transaction.

Activity

Chart of account segment for the activity of the payroll transaction.

Future

Chart of account segment for the future of the payroll transaction.

P-Project

Project number if applicable for the payroll transaction.

O-Project Organization

Project organization if applicable for the payroll transaction.

E-Expenditure Type

Project expenditure type if applicable for the payroll transaction.

T-Task

Project task if applicable for the payroll transaction.

Debit Amount

Debit amount of the payroll transaction.

Credit Amount

Credit amount of the payroll transaction.

 

Tips & Tricks

Below are some tips and tricks on using the Payroll Expenditures without Fringe Report

  • This report only returns records for natural accounts greater than or equal to 60000.
  • This report does NOT include fringe benefits.
  • The 9 columns of the chart of account segments will be blank when a project has been applied to cover the payroll transaction.
  • Run the report monthly to compare and supplement the account analysis report to ensure all charges applied to your organization are accurate.
  • The various prompts allow for a lot of flexibility in running the report to your individual needs. For example, you can run it one organization at a time or you can run multiple organizations at a time.

You have now navigated to and ran the Payroll Expenditures without Fringe report.

 

Was this helpful?
0 reviews

Details

Article ID: 82515
Created
Wed 7/3/19 12:52 PM
Modified
Wed 8/7/19 8:43 AM