BGSUPeopleSoft Financial Management Solutions FMS

1
BGSU/PeopleSoftFinancial Management Solutions
(FMS)

• BGSU Monthly Reports

2
Agenda

• Overview of Monthly PS/nVision Reports
• Details of Available Reports in Monthly Package
• View Reports from Report Manager
• Create Report Requests in Reporting Tool
• Run Reports in Reporting Tool
• Report Distribution and Retention

3

• Overview of Monthly PS/nVision Reports

4
What is PS/nVision

• Excel-Based Reporting Tool
• Retrieves Information from FMS and Places it into
  a Spreadsheet
• Review and Analyze Budget, Financial, and Payroll
  Information
• Manipulate and Format Data

5
Custom Monthly Reports

• PS/nVision Reporting Tool for Monthly Report
• Replaces AFIN monthly Reports
• Historical Reports View-Only from Page Center
• DCC or Grant Reports

6
Custom Monthly Reports, continued

• Generated in Report Manager after Month-End
• Excel or HTML Format
• Distributed to Budget Administrators and
  Principal Investigators

7
BGSU Monthly Reports
8
Viewing a Report

• Monthly Reports Distributed to Report Manager
• Click Report Manager from Menu Pagelet
• Can Search by Report Name
• Change Days (up to 75) to View More Reports
• Click the Name of the Report

9
Viewing a Report

• Demonstration on Viewing a Report

10
Budget Summary

• Year-to-Date Budgets by Accounts
• Month-to-Date and Year-to-Date Summary Expenses
  by Accounts
• DCC Expenses Categorized in Encumbrances and
  Actual Expenses

11
Budget Summary

• DCC Expenses Grouped as Operating and Personnel
  Expenses
• Encumbrances or Open Items Listed on Separate
  Sub-Sheet

12
Budget Summary Report

• Demonstration on Running and Viewing Budget
  Summary Report

13
Expense Detail

• Detail Transactions for Actual Expenditures
• Detail listing comes from two parts
• Journal Table
• Requisitions
• Provides Subtotals by Account
• Line Description Comes from Journal Line
  Description

14
Expense Detail

• JPMorgan P Card
• Ref Field Last 4 digits of credit card number
• Line Description Vendor Name from Payment Net

15
Expense Detail

• Demonstration on Running and Viewing Expense
  Detail Report

16
Grant Budget Summary/Detail

• Budget Month-to-Date and Year-to-Date Summary by
  Accounts
• Categorized by Encumbrances and Actual Expenses
• Header Information Includes PI, Award Topic,
  Starting and Ending Date, Department

17
Grant Budget Summary/Detail

• Demonstration on Running and Viewing Expense
  Detail Report

18
Payroll Expense

• Ordered By
• Account
• Employee Last Name
• Earn Code
• For Each Employee Shows Encumbrances and Payment
  for Month
• Status Indicates if Employee Terminated, On
  Leave, etc.

19
Report Retention

• 75 days in Report Manager
• Save all Reports for Future Reference

20
Report Distribution

• Budget Administrators
• Business Office decides if additional people
  receive reports
• Principal Investigators
• Grants Accounting Office decides if additional
  people receive reports
• Project Manager for Construction Projects

21
Questions
22
Thank You!

• The BG_at_100 Project Team