Transcript Supporting PI’s with PeopleSoft Data
S
UPPORTING
PI’
S WITH
P
EOPLE
S
OFT
D
ATA
Sponsored Awards Financial Monitoring August 8, 2013
Agenda
• Open Discussion – Who, What, Where, When, How, & Why?
• What reports are available?
• What is S.P.E.R.?
• Who are the reports available to and how is access obtained?
• Need Assistance?
• Questions, Comments, Suggestions, Opinions?
O
PEN
D
ISCUSSION
Open Discussion
• Who, What, Where, When, How, & Why?
• Questions, Comments, Suggestions, Opinions?
R
EPORTS
Sponsored Awards Repository Queries
Sponsored Accounting Bursted Reports
Current Report Name
Sponsored Projects Summary
Location
Personal Folder Userid Subfolder Sponsored Projects Summary by Account Sponsored Projects – Detail Activity by Department, Project, Activity Sponsored Labor Distribution Personal Folder Userid Subfolder Personal Folder Userid Subfolder Personal Folder Userid Subfolder Cost Share Labor Distribution Personal Folder Userid Subfolder
FAB Reports – Sponsored Repository Reports
FAB Reports Use Location Sponsored Project Chartstring Listing Sponsored Award Financial Report Due Grants Inquiry Sponsored Contracts and Projects Summary Sponsored Project Expenditures by Fiscal Year This query provides listings of project chartstring with the Budget Reference start and end dates for each project combination List of Sponsored awards that currently have a financial report due date assigned.
This 1 st section of the query provides summary and detail information for budget, expenditures, and commitments at the project level. The 2 nd section of the query provides expenditures summarized at the account level for a contract.
Summary of the budget, expenditures, commitments and available budget balance for Sponsored Contracts and Projects. Summary and detail information of Sponsored project to date expenditures by fiscal year.
FAB Folder
Grants Subfolder FAB Folder
Grants Subfolder FAB Folder
Grants Subfolder FAB Folder
Grants Subfolder FAB Folder
Grants Subfolder
FAB Reports – Sponsored Repository Reports FAB Reports Use Location Sponsored Project Payroll Activity Detail Report Sponsored Projects Payroll Activity FYTD Summary List of Sponsored Project Payroll transactions for employees.
List of total labor charges and open commitments for each employee for the current fiscal year to date.
FAB Folder
Grants Subfolder FAB Folder
Grants Subfolder Sponsored Payroll Fringe Report Provides sponsored project information for payroll activity and related fringe and facilities and admin (F&A) costs from July 1, 2005 through the current date.
FAB Folder
Grants Subfolder Project Run Rate Grants Available Budget Balance Enhanced Provides information on financial performance of sponsored projects, as well as, six and twelve month average spending by project.
FAB Folder
Grants Subfolder This Query provides Net Budget, Activity Fiscal YTD, Open Commitments, and the Available Budget Balance, by GL account or Budget Account with in an Area, Department or Project based on parameters selected by the end user.
FAB Folder
Grants Subfolder
REFERENCE DOCUMENT
Navigation
• Log on to
myslice.syr.edu
with your SU NetId and password • Under
Administrative applications
box, locate the SU Reports section and click on the
My Reports
link • Locate FAB folder located in the Report Repository folder – Click on the FAB folder • You will see at least one folder in the FAB folder including
Grants,
which is where the Sponsored Repository Reports are located • Locate Personal folder located in the Report Repository folder – Click on the • Personal folder You will see a folder with your SU NetID, which is where the Sponsored Bursted Reports are located
S
.
P
.
E
.
R
.
S.P.E.R.
Sponsored Project Expenditure Report
Overview
• Designed to facilitate the Principal Investigator’s (PI) or designee in the financial oversight and efficient management of sponsored awards. • Presents financial data at three levels: – Summary – Mid-level – Chart string detail • Has drill down capabilities • All data can be exported to excel spread sheets
Navigation
• Log on to
myslice.syr.edu
with your SU NetId and password • Under
Administrative applications
box, locate the People Soft section and click on the
PeopleSoft Financials/Supply Chain
link. • Click on
Syracuse Applications
link – You will see at least one folder in Syracuse Applications including
Grants
, which is where the Sponsored Projects Expenditure Report is located
Current Authorization Process
Current Authorization Process
• Access is given via the FAST access requests processed through the FAST system • The Department Information Coordinator (IC) submits the access request in the FAST system • Upon the appropriate approvals access is granted
Items for consideration
• Access: • Determination of levels of access for users • Award vs. Project level access • Current School/College security structure • Department level access • Inter Disciplinarian Awards access
A
SSISTANCE
Need Assistance?
Need Assistance?
Visit the BFAS Training Web site at
http://fab.syr.edu/
Schedule One on One Training with the Report Experts
http://fab.syr.edu/Fab/display.cfm?content_ID=%23%28%28%29% 2A%0A
Need Assistance?
For Specific Financial Award Related Assistance contact the Office of Sponsored Accounting:
E-mail us at [email protected]
Phone us at 443-2059 Contact the OSA Senior Accountant assigned to your department
For Additional Sponsored Award related assistance, contact the Office of Sponsored Programs
E-mail: [email protected]
Phone: 443-2807 Contact the OSP Research Administrator assigned to your department
O
N THE
H