Closeout of
This presentation is the property of its rightful owner.
Sponsored Links
1 / 31

Closeout of Sponsored Project Funds Michael Hay Assistant Director, Post Award Office of Research Services PowerPoint PPT Presentation


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

Closeout of Sponsored Project Funds Michael Hay Assistant Director, Post Award Office of Research Services. ORS BROWN BAG. Closeout of Sponsored Project Funds Agenda. PI & Department responsibilities Pre-closeout review Adjustment period Freeze/unfreeze grant requests ORS responsibilities

Download Presentation

Closeout of Sponsored Project Funds Michael Hay Assistant Director, Post Award Office of Research Services

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


Closeout of sponsored project funds michael hay assistant director post award office of research services

Closeout of Sponsored Project FundsMichael HayAssistant Director, Post AwardOffice of Research Services

ORS BROWN BAG


Closeout of sponsored project funds agenda

Closeout of Sponsored Project FundsAgenda

  • PI & Department responsibilities

    • Pre-closeout review

    • Adjustment period

    • Freeze/unfreeze grant requests

  • ORS responsibilities

    • Unfreeze requests

    • Closeout review

    • Financial report Completion

    • Disabling accounts

      SPP # 2126 Interim & Final Financial Reports

      SPP # 2128 Account Close-out


What funds are due to close

What Funds are Due to Close?

  • Run a Ben 133.OG report

  • Shows the BA what funds have budget end dates that are ending soon

  • Also shows the Freeze Status and when the financial report is due to the sponsor


133 org report

133.ORG Report


Org summary report

ORG Summary Report

  • Located in WEBI

  • Two helpful tabs:

    • Funds Frozen

      • Froze in the last 30 days

    • Funds Freezing

      • Will freeze in the next 90 days


What is the adjustment period

What is the Adjustment Period?

  • Period of up to 60 days after Account end date

    • Allows for final review of project activity

      so adjustments can be made prior to final reporting

      • 30/31 days: Account End Date + 15 days

      • 45 days: Account End + 30 days

      • 60/61 days: Account End + 30 days

      • 90/91 days: Account End Date + 60 days


Adjustment period cont

Adjustment Period (cont.)

  • Review the following areas (cont.)

    • Payroll – Any adjustments that may be needed must be made by the end of the adjustment period

    • Service Centers – Were these handled appropriately

    • Cost transfers over 90 days that were done without prior approval (wrong category used?)

    • Other direct costs for allowability


Adjustment period cont1

Adjustment Period (cont.)

  • Run 134.ORG Report in BEN Financials or Fund Summary in Business Objects (WEBI)

    • Review the following areas

      • PBUD/PBIL should be equal

      • Revenue vs. Expense

        • Should be equal

        • If not, requires further review

      • F&A and Employee Benefits (EB) – Were the correct rates appropriately applied?


Final review prior to end of adjustment period

Final Review Prior to End of Adjustment Period

  • Review NOGA for approved carryforward, if applicable

  • Review subcontracts and respective closeouts

  • Determine and address unliquidated and unobligated carryovers

  • Communicate and confirm all expenses w/ PI

  • Communicate with ORS Accountant

  • All adjustments must be processed by end of the fund adjustment period

    • Complete all approved, allowable, allocable and appropriate adjustments identified during pre-closeout review


Freeze unfreeze grant functionality

Freeze/Unfreeze Grant Functionality


Freeze grants functionality

Freeze Grants Functionality

  • Tool that allows authorized research administrators and ORS to limit activity against an award

    • Can be used during life of project and during the adjustment period

    • Can reduce cost transfers and overruns after the end of the fund project period

    • Improve timeliness and accuracy of final financial reports


Freeze grants features

Freeze Grants Features

  • Awards are frozen/unfrozen at fund level

    • Payroll can be frozen manually prior to the Account End Date

    • Functionality frozen automatically after Account End Date

      • New Purchase Orders/Requisitions

    • Functionalities frozen automatically after Adjustment Period End Date (APED)

      • Manual Journal Entries

      • C-forms

      • Feeder Journal Entries

      • Payroll


Unfreeze request

Unfreeze Request


Unfreeze request cont

Unfreeze Request (cont.)


Unfreeze grants cont

Unfreeze Grants (cont.)

  • Submit your request to:

    • School of Medicine departments

      • Send worksheet and details (including documentation) to Office of Research Services Support (ORSS) Grant Manager with a cc to ORS Accountant

      • ORSS will review and, if approved, will forward to Research Services Accountant and cc Assistant Director

    • All other Schools

      • Send worksheet and details to ORS Accountant and cc Assistant Director

    • Unfreeze requests are normally addressed within two business days


Unfreeze request cont1

Unfreeze Request (cont.)

  • Are not necessary to:

    • Prepare budget journals

    • Pay already encumbered amounts on an existing P.O.

    • Unfreeze advance accounts (request an extension of advance account)


Ors responsibilities

ORS Responsibilities


Ors reporting period tasks

ORS Reporting Period Tasks

  • Review Due Reports Report to determine if Financial Report is to be completed that month

  • Report is run through WEBI and pulls information from PennERA and BEN to determine if a final report is due


Ors reporting period tasks cont

ORS Reporting Period Tasks (cont.)


Ors reporting period tasks cont1

ORS Reporting Period Tasks (cont.)

  • Email will be sent requesting closeout information

  • Email should contain the following information:

    • Fund Number

    • PI Name

    • Award Amount

    • Current Balance

    • Deadline for response


Ors reporting period tasks cont2

ORS Reporting Period Tasks (cont.)


Ors reporting period tasks cont3

ORS Reporting Period Tasks (cont.)

  • ORS Accountant reviews the following standard issues

    -Terms and conditions of award and sponsor reporting requirements

    • Review the 734 report in WEBI

    • Check PBUD/PBIL for accuracy

    • Reconcile EB’s, F&A and Cash

    • Allowability of Costs

    • Review 252 report for stale dated checks

    • Review Cost Transfer Report


Ors reporting period tasks cont4

ORS Reporting Period Tasks (cont.)


Ors reporting period tasks cont5

ORS Reporting Period Tasks (cont.)

  • Review Revenue

    • 4600, 4620, 4630, 478X, 4822, TIF, Program Income & Other Revenue

  • Review remaining balances or deficits

  • ORS will communicate any issues identified and request a response from the BA

  • If the ORS Accountant does not receive a response regarding closeout the report will be issued and an email will be sent stating what was reported to the sponsor.


  • Ors reporting period tasks cont6

    ORS Reporting Period Tasks (cont.)

    • Overdrafts

      • ORS will contact department regarding resolution

      • If no response is received by report due date, fund will be reported up to award amount and ORS will process journal to transfer resources from departmental fund to grant fund to offset overdraft via object code 4822

        SPP # 2129 Chargeback of Overdrafts and Disallowances


    Ors reporting period tasks cont7

    ORS Reporting Period Tasks (cont.)

    • Unexpended Balance

      • Will be reported to sponsor

      • Carryover will be processed and/or requested as appropriate

      • Residual cash will be remitted to sponsor according to agreement

      • Carryovers and/or unliquidated obligations will be determined and handled as appropriate


    Ors reporting period tasks cont8

    ORS Reporting Period Tasks (cont.)

    • Final Financial Status Report (FSR)/(FFR) Submission

      • Financial report will be issued by ORS no later than due date

      • A copy will be sent to department and a copy will be scanned into our imaging system (Acorde)

      • ORS will process any closing entries based upon final reports


    Disabling funds

    Disabling Funds

    • How does a fund get Disabled?

      • ORS runs 717.RA report in BEN Financial weekly

        • To identify funds that meet disable requirements

      • If the fund is eligible for disabling ORS checks “Enable” flag

        • Enters date in BEN Financials


    Requirements to disable funds

    Requirements to Disable Funds

    • Financial Report must be submitted if required-Last FIN Report Filed=Next FIN Report Due

    • FSRD and FSRI s/b posted reflecting Direct and Indirect Costs reported

    • PBIL=PBUD=FSRD+FSRI=Total Expenses reported and on the G/L

    • No Encumbrances can remain

    • Object Code 1220 Receivable must =0

    • Equipment in Object Code 183X/187X must be transferred to School Surrogate Accounts via an Object Code 4826 Equipment Transfer

    • BRIM (ORS billing system) is reconciled (requires ORS action)

    • All stale dated checks have been satisfactorily addressed


    Getting assistance on closeouts

    Getting Assistance on Closeouts

    • For financial matters:

      • Contact ORS accountant or Post-Award Assistant Director

    • Regarding extensions, requests for budget or other modifications to agreement, or non-financial matters:

      • Contact your Contract Administrator


    Closeout of sponsored project funds michael hay assistant director post award office of research services

    Questions???


  • Login