fms finance orsp reporting nov09
Post on 07-Apr-2018
231 Views
Preview:
TRANSCRIPT
-
8/6/2019 Fms Finance Orsp Reporting NOV09
1/18
Finance Reporting
Edition (OBIEE) Training
-
8/6/2019 Fms Finance Orsp Reporting NOV09
2/18
Summary / Benefits
Ease of Use
Performance Updated nightly
Report criteria defaults
Drill-down to details
Download to Excel, PowerPoint, data, andweb page
-
8/6/2019 Fms Finance Orsp Reporting NOV09
3/18
Login at
-
8/6/2019 Fms Finance Orsp Reporting NOV09
4/18
Access Requirements
SF State UIN: University identification numbera a emp oyee , , etc
SF State Password: Formerly known as your
Completed ESIP (Employee/Student Information
Privacy) Training FMS Account with permissions to Project/s
Set up as either a PI (Principal Investigator) or a
FMS)
-
8/6/2019 Fms Finance Orsp Reporting NOV09
5/18
Dashboards by Fund Types
Grants and Contracts Projects: SG001 selectt s as oar or most accounts
Trust Funds: Trust Fund & Revenue Fund Codes=
General Fund: NG001
Capital Outlay: BH###
-
8/6/2019 Fms Finance Orsp Reporting NOV09
6/18
Dashboard Reports within a Dashboard
Available Balance Overview
Financial Summar Re ort, e uivalent to Revenue /
Expenditure Summary Report (SFOGL104)GL Detail Activity, both as Month-to-Date (MTD) and Project-to-Date (PTD), equivalent to GL Detail Report (SFOGL100)
Open Commitment Report, equivalent to SFOGL109Payroll Report, grouped by employee name
Ex ense Account Grou ing
Expense Summary Report
-
8/6/2019 Fms Finance Orsp Reporting NOV09
7/18
Dashboard Prompts / CriteriaNote: Select / change only one level / row of criteria at a time, hit Go, then
,
1st Level Criteria, filter by:, , ,
Account Type, Project ID, Project End Date >=,Project Status, Total Available
2nd Level Criteria, additional filter for:
Grants Administrator, PI/Dean/DeptChair/Director,
-
8/6/2019 Fms Finance Orsp Reporting NOV09
8/18
Acronyms / Definitions
FY, Fiscal Year: July June for SF State= =
MTD, Month-to-Date: cumulative activities to datefor a project, within a given month (for a specifiedaccount ng per o an
YTD, Year-to-Date: cumulative activities to date,since the ro ects activation within a iven FiscalYear (for a specified accounting period and FY);will never go back further than period 1 of a FY
, - - ,since a projects activation, which may spanmultiple FYs(e.g. a project period is 10/1/07-9/30/10; on8/15/09 the PTD will show cumulative activities 10/1/07 8/15/09 )
-
8/6/2019 Fms Finance Orsp Reporting NOV09
9/18
Grants and Contract Dashboard
Available Balance Overview Lists basic Project Attributes (Project Number; In-house
Title; Start / End Dates; Award #; GA, PI, and Dean / Depta r names; un ng gency
Shows the corresponding Available Direct and IndirectCosts, and Total Available Balance (AB)
AB = Revised Budget sum (PTD Actuals + Open POs + Open Reqs)
Positive Balance = money left in the project account
Negative Balance = project is in deficit
-
8/6/2019 Fms Finance Orsp Reporting NOV09
10/18
Grants and Contract Dashboard
Financial Summary ReportEquivalent to the online reports that were posted on ids.sfsu.eduIncludes: Header with project information, and breakdown ofPa roll, O eratin Ex enses, and Indirect Cost Totals
-
8/6/2019 Fms Finance Orsp Reporting NOV09
11/18
Grants and Contract Dashboard
GL Detail Activit Re ort MTDTransactions to date for the selected accounting period
.
This example shows Period 5 (11/09) as of 11/6, so MTD = 11/1-11/6
-
8/6/2019 Fms Finance Orsp Reporting NOV09
12/18
Grants and Contract Dashboard
GL Detail Activit Re ort PTDTransactions to date for the entire project period are
listed and rou ed b Account.This example is Period 5 (11/09) as of 11/6, so PTD = 7/1/07-11/6/09
-
8/6/2019 Fms Finance Orsp Reporting NOV09
13/18
Grants and Contract Dashboard
O en Commitment Re ortProvides a detailed listing of all Open Requisitions
-
Orders (listed as an Encumbrance)
-
8/6/2019 Fms Finance Orsp Reporting NOV09
14/18
Grants and Contract Dashboard
Pa roll Re ortPayroll transactions are grouped by
,
details by employeeNote: The Pa roll Re ort will onl show data after LCD has run
-
8/6/2019 Fms Finance Orsp Reporting NOV09
15/18
Tips on Navigation
You can drill-down on any blue row or column cells:
Sort report details by clicking the column header;^ ,
sorted in ascending or descending order
-
8/6/2019 Fms Finance Orsp Reporting NOV09
16/18
Tips on Navigation .
How to download to Excel, PowerPoint,
etc. Locate at the bottom
of the report the
Download link and
- Select the desired
download o tion
-
8/6/2019 Fms Finance Orsp Reporting NOV09
17/18
For more information...
Visit:. .
tutorials/tutorials_big.jsp
-
8/6/2019 Fms Finance Orsp Reporting NOV09
18/18
Contact / Help Desk :
LDAP ID x 5-4357 (5-Help)
Access x 8-7143 Data
Report
Fund Feedback x 8-7143
top related