Fy11 commitment accounting efp rollover june 10 2010 school of nursing room 130
This presentation is the property of its rightful owner.
Sponsored Links
1 / 51

FY11 Commitment Accounting EFP Rollover June 10, 2010 School of Nursing- Room 130 PowerPoint PPT Presentation


  • 83 Views
  • Uploaded on
  • Presentation posted in: General

FY11 Commitment Accounting EFP Rollover June 10, 2010 School of Nursing- Room 130. Presenters. Candace Chow- Payroll Manager- Financial Services Pat Holmes- Manager- Cost Analysis & Studies. Agenda. Key Dates and Deadlines Before the EFP Rollover The FY11 Rollover Process

Download Presentation

FY11 Commitment Accounting EFP Rollover June 10, 2010 School of Nursing- Room 130

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Fy11 commitment accounting efp rollover june 10 2010 school of nursing room 130

FY11Commitment AccountingEFP Rollover June 10, 2010School of Nursing- Room 130


Presenters

Presenters

  • Candace Chow-

    • Payroll Manager- Financial Services

  • Pat Holmes-

    • Manager- Cost Analysis & Studies


Agenda

Agenda

  • Key Dates and Deadlines

  • Before the EFP Rollover

  • The FY11 Rollover Process

  • After the EFP Rollover

  • FY11 Distributions

  • Funding Summary Report


Key dates and deadlines

Key Dates and Deadlines


Key dates change from prior years

Key Dates- Change from prior years


Fy10 cut off dates drs

FY10 Cut Off Dates- DRs


Fy10 cut off dates drs1

FY10 Cut Off Dates- DRs

  • Reminder- a direct retro and a budget retro cannot be processed in same pay period- plan accordingly!!!


Fy10 cut off dates

FY10 Cut Off Dates

  • Friday- 6/25/10 – all EFPs for FY10 must be approved in eUMB before 2 PM

    • EFPs entered but not approved by the deadline will be deleted

  • Reminder: PCAs should be zeroed out by end of the fiscal year


Pp10 26 6 6 6 19 distribution

PP10-26 (6/6-6/19) Distribution

  • Saturday-6/26: Actuals Distribution process is run for PP10-26 with no encumbrances

  • Monday-6/28: Validate that payroll expenses were distributed correctly using PCD

  • Tuesday-6/29: Validate that payroll expenses were distributed correctly using SPC


Fy10 redistributions

FY10 Redistributions

  • No budget retros after 6/25

  • Direct retros for all projects* will be processed between 6/28 and 7/9 (posted to GL in FY10 but reflected in HRMS as FY11)

  • Direct retros for all projects except for Physician Service Contract projects can be processed from 7/12 and forward (posted in FY11)


Checking efps

Checking EFPs

  • Use Funding Summary Report (demo later in presentation)

  • Use queries (recommend using pivot tables with download to Excel)

    • UMB_CA_EFP_BY_EMPL_ID (one employee)

    • UMB_CA_EFP_BY_DEPT_ID (all employees)

    • UMB_CA_NO_EFP (for missing EFPs)


Before the fy11 efp rollover

Before the FY11 EFP Rollover

(From today until 2pm on Friday, 6/25/10)


What to do before fy11 rollover 6 26

What To Do Before FY11 Rollover (6/26)

  • Make sure all employees have a FY10 EFP

    • Run Funding Summary Report and/or

    • Run query UMB_CA_NO_EFP

  • Administrative depts tend to forget to set up EFPs for new employees- means more work at budget time!


What to do before fy11 rollover 6 261

What To Do Before FY11 Rollover (6/26)

  • Review all funding sources that end 6/30/10 or earlier and determine redistributions

    • Use EFP Query or Funding Summary Report

  • Complete redistributions by entering & approving new EFP for a Budget Retro

    • Approve new EFP by 2pm on Friday, 6/11 for PP10-25 distribution

    • Approve new EFP by 2pm on Friday, 6/25 for PP10-26 distribution


What to do before fy11 rollover 6 262

What To Do Before FY11 Rollover (6/26)

  • Check ALL Funding End Dates:

    • No Funding End Date = no change required

    • Funding End Date > 6/30/10 = no change required


What to do before fy11 rollover 6 263

What To Do Before FY11 Rollover (6/26)

  • Check ALL Funding End Dates:

    • Funding End Date < 6/30/10 = change now so that payroll expenses do not charge PCA

    • Funding End Date of 6/30/10 = OK to change now; must change later to avoid charging PCA


Fy11 efp rollover

FY11 EFP Rollover

(on Saturday, 6/26/10)


Rollover of the initial fy11 efp

Rollover of the Initial FY11 EFP

  • EFP in effect on 6/25/10 will be used to programmatically:

    • Create the initial 7/1/10 EFP

    • Create the “fix” EFP to be used for any earnings associated with dates prior to 7/1/10 paid in FY11

      • (Note: Fix EFP will have a Funding Begin Date of 3/23/03, employee’s hire date, or date transferred to department -- whichever is latest)


Roll over of the initial fy11 efp

Roll-over of the Initial FY11 EFP

  • EFPs will programmatically be created for both active employees and employees who were terminated after 1/1

    • No action is required on your part for terminated employees (unless you have a payout in FY11)

    • Review initial EFP for active employees to be sure it is valid (check account codes, funding end dates, % distribution)


After the rollover

After the Rollover

(from Monday, 6/28/10 until 2pm on Friday, 7/9/10)


What to do after fy11 rollover

What To Do After FY11 Rollover

  • Prior to actuals distribution (Saturday, 7/10/10) you need to

    • Make sure there is a valid 7/1/10 EFP for each active employee

    • Create a valid 7/1/10 EFP if it is not there


Creating new fy11 efps

Creating New FY11 EFPs

  • 6/28, 6AM – 7/9, 2PM (Two week period): Departments review and create additional 7/1/10 EFPs as needed to reflect valid account codes, funding end dates, % distributions


Creating new fy11 efps1

Creating New FY11 EFPs

  • EFPs will display the salary in effect at the time the EFP is created

  • If an employee action is submitted effective 7/1/10 but it hasn’t been entered in eUMB then the old salary will be reflected on the EFP page- this is OK

  • Reminder- salary displayed on the EFP is informational only and may not reflect the actual amount distributed


Cost sharing for payroll expenses

Cost Sharing for Payroll Expenses

  • NIH OTC Cap is $199,700- check employees who may have gone over the cap with 7/1 pay increases

    • Amount is based on annualized salary- Ex. FTE=.20 and amount paid at UMB= $40K  Annualized= $200K

  • This only applies to NIH agencies- if you don’t know whether a sponsor is under the NIH umbrella check the following website: http://www.nih.gov/icd/index.html


Cost sharing for payroll expenses1

Cost Sharing for Payroll Expenses

  • Position owner creates EFP but may be unaware that project from another dept requires OTC- communicate!


What to do before fy11 distribution on 7 10

What To Do Before FY11 Distribution on 7/10

  • Make sure all employees have a FY11 EFP

    • Run Funding Summary Report and/or

    • Run query UMB_CA_NO_EFP

  • Administrative depts tend to forget to set up EFPs for new employees- means more work at budget time!


Fy11 distributions

FY11 Distributions

(on Saturday, 7/10/10)


Fy11 distributions1

FY11 Distributions

  • If the EFP has a funding end date of 6/30/10 or earlier, at 2:01pm on Friday, July 9th- the EFP will be changed

  • A process will run to replace the account code with the expired funding end date with your department default account code- AKA your PCA


Efp example

EFP Example

FY10 EFP used in the rollover process

Initial FY11 EFP created effective 7/1/10 (and same for “fix” EFP) with account codes expiring before 7/1/10

New FY11 EFP wasn’t created so the process run on 7/10 will remove account codes with funding end dates prior to 7/1/10 and add the PCA/Dept Default account code equal to percent of account codes removed


Pp11 01 distribution

PP11-01 Distribution

  • Two week period = 6/20-7/3

  • For PCD reporting purposes only we refer to period of 6/20-6/30 as PP10-27 (AKA the payroll accrual) and 7/1-7/3 as PP11-01

  • PeopleSoft does not recognize pay period #27


Pp11 01 distribution1

PP11-01 Distribution

  • PP11-01 covers payroll expenses associated with both FY10 and FY11- when the actuals distribution process is run:

    • FY10 payroll expenses (based on pay earnings dates) will be distributed based on the “fix” EFP (ex. Shift, OVT, hourly employees)

    • FY11 payroll expenses (based on pay earnings dates) will be distributed based on the 7/1/10 EFP in effect


Pp11 01 distribution2

PP11-01 Distribution

  • When a valid EFP is not set up before actuals distribution process is run:

    • Payroll expenses associated with earnings dates greater than the Funding End Dates on your EFPs will be distributed to your PCA

    • You will need to do a budget retro

    • You will have LARGE encumbrance balances on your PCA


Pp11 01 reminders

PP11-01 Reminders

  • Since we are using the real service dates on the PA form, the earnings will be distributed to the appropriate fiscal year according to those dates


Pp11 01 reminders1

PP11-01 Reminders

  • Salary Pay is calculated on 14ths instead of 10ths- ex. new faculty employee who starts 7/1/10 will receive 3/14ths pay; exempt employee terminating 6/30/10 will receive 11/14ths pay

  • Hourly Pay (Non-exempt and hourly employees) is calculated based on hours entered/scheduled


Pp11 01 and forward reminders

PP11-01 (and forward) Reminders

  • If you are paying a new employee who was entered in eUMB AFTER 6/28 with an effective date prior to 7/1/10:

    • You will not be able to enter any hours in the WET pages prior to 7/1/10

    • You MUST submit a Retro Pay PA form for the retro pay with a HRMS Account Code


Funding summary report

Funding Summary Report


Using the funding summary report

Using the Funding Summary Report

Three key times to run it:

Before FY11 Rollover (now thru 6/25)

Before first FY11 Actuals Distribution (6/28 thru 7/9)

After 11-01 Actuals Distribution (starting 7/12)


Checking efps before fy11 rollover

Checking EFPs Before FY11 Rollover

  • Reminder on Funding Summary Report:

    There is a Report Choice option so that you can retrieve all EFPs for your department or just the EFPs where there is an issue that will cause a charge to the PCA/Dept Level account code


Checking efps before fy11 rollover1

Checking EFPs Before FY11 Rollover

Run Funding Summary Report using an “as of” date of 6/30/10 and select the “PCAs Only” report choice. Only the following will be returned:

  • Lines marked as ‘DP’

  • Lines with Funding End Dates of 6/30/10 or earlier


Setting up funding summary report checking efps before fy11 rollover

Setting Up Funding Summary Report: Checking EFPs Before FY11 Rollover

Using 6/30/10 will help you insure that charges through the end of the fiscal year are using the correct account code.

The default setting (“No”) returns EFPs for active employees only. Select “Yes” if you also need to display EFPs for terminated employees.

A new feature for this year is the ability to isolate the EFPs that will default to the PCA/Dept level


Reviewing funding summary report checking efps before fy11 rollover

Reviewing Funding Summary Report: Checking EFPs Before FY11 Rollover

Only the portion of the EFP that will be charged to the PCA is displayed- not the full EFP.

Displays problem EFPs in effect as of 6/30/10

PCAs Only Version

AP= Appointment Level Profile (EFP is in eUMB);

DP= Department Level Profile (EFP is NOT in eUMB and payroll-related expenses will be charged to departmental PCA!)


Checking fy11 efps before actuals distribution

Checking FY11 EFPs Before Actuals Distribution

Run Funding Summary Report using an “as of” date of 7/3/10 and select the “PCAs Only” report choice. Only the following will be returned:

  • Lines marked as ‘DP’

  • Lines with Funding End Dates of 7/3/10 or earlier


Setting up funding summary report checking fy11 efps before first distribution

Setting Up Funding Summary Report: Checking FY11 EFPs Before First Distribution

This report displays the “problem” EFPs in effect “as of” the last day of PP 11-01.


Reviewing funding summary report checking fy11 efps before first distribution

Reviewing Funding Summary Report: Checking FY11 EFPs Before First Distribution

ALERT! Funding sources expiring 06/30/10 and earlier require your quick attention or your PCA will be charged.

Displays EFPs in effect as of 7/3/10

PCAs Only

Version

ALERT! If Funding Level = DP (Department Level Profile), employee DOES NOT HAVE EFP in eUMB. Payroll-related expenses will be charged to the departmental PCA!


Setting up funding summary report checking fy11 efps used in first distribution

Setting Up Funding Summary Report: Checking FY11 EFPs Used in First Distribution

This report displays the “problem” EFPs in effect “as of” the last day of PP 11-01.


Reviewing funding summary report checking fy11 efps used in first distribution

Reviewing Funding Summary Report: Checking FY11 EFPs Used in First Distribution

Example where no changes were made to FY11 EFPs

PCAs Only

Version

Displays problem EFPs in effect as of PP 11-01

ALERT! Funding sources expiring 06/30/10 and earlier will be changed to charge your PCA


Pcd vs raven

PCD vs. RAVEN

  • PCD By Pay Period = SPC by Pay Period Affected

  • PCD By Accounting Period = SPC by Pay Period Posted = RAVEN Ledger Inquiries

  • Note: Check cancellations/overpayments do not appear in PCD or SPC- only appear in RAVEN Ledger

PCD = Payroll Charges Detail Report in HRMS

SPC = Statement of Payroll Charges Inquiry in RAVEN


Viewing raven spc

Viewing RAVEN SPC

  • Since 11-01 spans two fiscal years need to use “Fiscal Year” field to segregate amounts on report

    • To view period 6/20-6/30: use pay period 11-01 and FY 2010

    • To view period 7/1-7/3: use pay period 11-01 and FY 2011

    • To view period 6/20-7/3: use pay period 11-01 and leave FY blank


Viewing raven spc1

Viewing RAVEN SPC

By entering the fiscal year, only amounts for 7/1/09-6/30/10 are displayed. If blank, the period 6/21/09-7/3/10 will be displayed.


New salary account for fy11

New Salary Account for FY11

  • Post Doc Fellows (Empl Class 19)

    • Currently mapped to Account 2071

    • will be mapped to New Account 1021 effective 7/1/10


Questions

Questions?

  • Please contact FS-Payroll if you have questions regarding the rollover process

    • Phone: (410) 706-1243

    • E-mail:

      [email protected]

  • Please contact Cost Analysis if you have questions regarding Direct Retros

    • Phone: (410) 706-2987

    • E-mail:

      [email protected]


  • Login