Docstoc

Monthly Expense Spreadsheet - PowerPoint

Document Sample
Monthly Expense Spreadsheet - PowerPoint Powered By Docstoc
					       BGSU/PeopleSoft
Financial Management Solutions
             (FMS)

     BGSU Monthly Reports
                  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


                                                  2
Overview of Monthly
PS/nVision Reports




                      3
     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
                                        4
  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
                                        5
Custom Monthly Reports, continued
Generated in Report Manager after
Month-End

Excel or HTML Format

Distributed to Budget Administrators
and Principal Investigators


                                       6
           BGSU Monthly Reports
FMS                           AFIN
Budget Summary                A120BG-Monthly Organization summary

Expense Detail                BG204-Departmental Activity Report

Payroll Expense Detail        P100 Payroll Expense Report

Revenue Summary               A286 Listing of Revenue vs Budget

Revenue Detail                A440-Revenue Detail Report

Result of Operation by Fund   B120552 Result of Operation by Fund

Grant Summary/Detail          G200 Grant Detail Report
                              G210 Grant Summary Report
Project Summary/Detail        A120BG-Monthly Organization Summary

                                                                   7
        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
                                         8
     Viewing a Report
Demonstration on Viewing a Report




                                    9
      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


                                   10
      Budget Summary
DCC Expenses Grouped as Operating
and Personnel Expenses

Encumbrances or Open Items Listed on
Separate Sub-Sheet




                                    11
  Budget Summary Report
Demonstration on Running and Viewing
      Budget Summary Report




                                       12
             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


                                              13
         Expense Detail
JPMorgan P Card
 Ref Field: Last 4 digits of credit card
 number
 Line Description: Vendor Name from
 Payment Net




                                           14
        Expense Detail
Demonstration on Running and Viewing
        Expense Detail Report




                                       15
  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
                                     16
 Grant Budget Summary/Detail

Demonstration on Running and Viewing
        Expense Detail Report




                                       17
        Payroll Expense
Ordered By
1. Account
2. Employee Last Name
3. Earn Code

For Each Employee Shows Encumbrances
and Payment for Month

Status Indicates if Employee Terminated,
On Leave, etc.

                                           18
        Report Retention

75 days in Report Manager

Save all Reports for Future Reference




                                        19
       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


                                                   20
Questions




            21
     Thank You!

The BG@100 Project Team

				
DOCUMENT INFO
Description: Monthly Expense Spreadsheet document sample