RFA - Payroll

RFA - Payroll

Payroll RFA Gross & Fringe Payroll Office May 2016 First Steps & Questions to Ask Discovery of need Someone discovers a project closed, but the researchers did not get moved off. Notification from FWS of fund

exhaustion Email from someone Budget reports shows overspent funding Is an RFA the best way to fix the problem? Will moving this salary/fringe truly represent the effort for the project?

Can other expenses be moved via journal voucher or budget transfer? Questions to Ask How many pay periods are involved? Are any of the periods partial? What type and how many

employees are involved? Could someone have already started an RFA? Common when dealing with project start and end dates Has funding been submitted to Also common at the beginning and stop future RFAs? end of the academic year

Important Payroll Terms On-cycle Refers to normal biweekly payroll process DEMIS vouchers V7002XXX Off-cycle Refers to supplemental or adjustment payroll cycle DEMIS vouchers V7003XXX

RFA DEMIS vouchers V7004XXX, V7005XXX, and V7006XXX Pay Group Located in Job Data Indicates if the EE is exempt, hourly, 10 day, and/or 14 day Hourly & 10 day schedule CUN & STN Exempt & 10 day schedule CUX, LTX & SRX

Exempt & 14 day schedule LFC, LCT & STX Additional Pay Cell Phone Stipend paid on-cycle Cash Award paid supplemental

Overload paid supplemental Benefit/Other Adjustments How to obtain DEMIS gross & fringe report Log into the DEMIS portal using your KU User ID and password http://financial-management-systems. ku.edu/

Running DEMIS Gross & Fringe Report Click on the HREO/Payroll Tab Select the gross & fringe for the appropriate fiscal year How to obtain DEMIS gross & fringe report

By default, every voucher is selected for reports. This is the best choice to ensure all transactions are caught. Running DEMIS gross & fringe report Contd The first section is the Restrict Analysis section. Scroll down to Employee ID and Position Number.

Enter both to restrict your report results. Running DEMIS gross & fringe report Contd The next section is called Report Breaks. Make the 3

selections shown. Running DEMIS gross & fringe report Contd The next section is Report Options. In it, select the additional extract columns

shown. Running DEMIS gross & fringe report Contd The last section is Output Options. Select Excel data file Click the Run

button Running DEMIS gross & fringe report Contd A new tab will appear briefly on your browser. Then a box similar to this one should appear.

Click the OK button DEMIS Report Results The resulting spreadsheet should look like this one. Note: I have removed the EE ID for privacy purposes. Payroll DEMIS Shortcut FY 2013/2014

FY 2015/2016/2017 REPORT BREAKS ACCOUNT CODE CHARTFIELD STRING VOUCHER VOUCHER

CHARTFIELD 2 DEMIS ADDITIONAL EXTRACT COLUMNS EE ID & RECORD NUMBER EE ID & RECORD NUMBER DEPARTMENT DEPARTMENT

POSITION NUMBER POSITION NUMBER POOL ID POOL ID TRUE PAY END DATE

TRUE PAY END DATE COST CENTER COST CENTER FUND FUND

PROJECT OR GRANT PROJECT OR GRANT SCENARIO CHARTFIELD 3 OFFCYCLE FLAG

OFFCYCLE FLAG EXCEL RFA MACROS Shortcut Formats Ctrl + d DEMIS report

Ctrl + r Redistribution query Ctrl + Shift + a Accounting line query DEMIS Report Formatting

Recommended Formatting Auto-fit the columns Cut and Insert Chrtfld 2 column to the immediate right of Chrtfld 3 column Sort Data by True Pay End Date Oldest to Newest

Format Total columns to Number, Accounting, or Currency Example 1 Mid-Period Change RFA is to move funding for Dianas position from 2330450-908STE0074332/2330450-718-STE0075732 to 2330450-717-STE0076041 (1/1/162/27/16) Exempt (salaried) employee Involves 5 pay periods New funding starting January 1 2 changes to funding Multiple funding rows remaining the same

Example 1 Page 1 of Gross & Fringe Example 1 Page 2 of Gross & Fringe How to insert Pivot Table 1 of 4 Select INSERT tab Click PivotTable How to insert Pivot Table 2 of 4 Select a table or range

Table/Range Select entire range (Do not include the row for sum total) How to insert Pivot Table 3 of 4 Choose Existing Worksheet Location: Click anywhere on the spreadsheet you would like to insert pivot table Click Ok How to insert Pivot Table 4 of 4

Drag Chartfield String to ROWS Drag Total Gross Wages, Total Fringe and Total Grss/Fng to VALUES Totals of each funding sources prior to the RFA transaction Movement of Charges Statement & Ending

Charges Include gross and dollar amounts total and affected grants. Include totals of each funding source at the end of the RFA transaction Example 1 First Funding Section on PAF Example 1 Second Funding Section on PAF Example 2 Multiple Funding Changes

RFA is to move 2% out of total gross and fringe to 2330250-908STE0075512 Exempt (salaried) employee Involves 13 pay periods New funding starting August 2 Many funding changes throughout the RFA period Multiple funding rows remaining the same Example 2 Page 1 of Gross & Fringe Example 2 Page 2 of Gross & Fringe

Example 2 First & Second Funding Sections on PAF Example 2 Third & Fourth Funding Sections on PAF Example 3 Mid-Period Change RFA is to move funding from 2330255-867 to 2330256-907 / STE0075025 / STE0075120 (07/01/2015-08/15/2015) Non-exempt (hourly) employee Involves 4 pay periods

New funding starting July 1 Non-standard schedule Example 3 - Hours worked by day Hourly employees may not work a standard 8-5 M-F shift. (Pay groups CUN & STN) Please attach a

breakdown of hours worked by day from the first day to the last day of the partial pay period. Calculate the number of hours for the days that need to be moved to the

new funding and the number of hours remaining on the old funding 57 hours 06/21/15-06/30/15 23 hours 7/1/15-7/3/15 Example 3 Gross & Fringe

Example 3 Funding Section Questions If you have any questions, please call the Payroll Office at 4-4385 or email [email protected]

Recently Viewed Presentations

  • Chapter 3: Internetworking

    Chapter 3: Internetworking

    Chapter 3 Internetworking Copyright © 2010, Elsevier Inc. All rights Reserved Computer Networks: A Systems Approach, 5e Larry L. Peterson and Bruce S. Davie
  • 1 2  3  4 5  6  7 8

    1 2 3 4 5 6 7 8

    Author: Ouellette, Angela N Created Date: 01/14/2016 13:42:53 Title: PowerPoint Presentation Last modified by: Ouellette, Angela N Company: Denton ISD
  • Affine Transformations

    Affine Transformations

    CS5540 HCI Assignment 1 Affordance and Mapping Spencer Visick September 4, 2003 Definitions (my words) Affordance: Some clear hint to a thing's function Mapping: choosing a widget that clearly represents it's function Good and Poor Examples Twist & Go Ex...
  • Newsletter Spring 2011 In This Issue Greetings from

    Newsletter Spring 2011 In This Issue Greetings from

    Franklin F. Gorospe IV RN MN Why Nursing? In the midst of a true winter season, Nurses continue to venture out in the pursuit of a safer health care. As 2011 rolls out, MINIG is committed to promoting the diversity...
  • Why Primary Care? - pcpcc.org

    Why Primary Care? - pcpcc.org

    Research prior work on principles of primary care, including the Joint Principles of Primary Care, in order to build on that work. Public survey to determine what needed to be included. Convene an in-person working Summit in November 2016. Feedback...
  • Practice Standards - Kristine Cargill, RN

    Practice Standards - Kristine Cargill, RN

    (Potter & Perry, 2009) Diagnosis. ... ANA practice standards influence my nursing practice by guiding how I care for my patients. Assessment is an ongoing process as I care for patients. When I assess patients and evaluate the patient outcomes,...
  • Part 11 CoC Plan - HUD Exchange

    Part 11 CoC Plan - HUD Exchange

    Debriefing Broadcast Continuum of Care February 21, 2008 Broadcast Overview 2007 "Big Picture" Lessons Learned in 2007 Pro-Rata Need 2008 CoC Application and Registration Overview Helpful Questions and Answers 2007 "Big Picture" Competition Highlights Requested: $1.4 billion for 6,266 projects...
  • Hlukové mapy - Masaryk University

    Hlukové mapy - Masaryk University

    Night Noise Guidelines (NNGL) for Europe. WHO, 2007. Position paper on dose response relationships between transportation noise and annoyance. European Commission 2002. Mapping Environmental Noise. München, Nov. 23, 2012. 5. března 2010. Hlukové mapy.