FIS REPORTS B U S I N ES S SE RV I C ES I N T R O T O F I N A N C I A

FIS REPORTS B U S I N ES S SE RV I C ES I N T R O T O F I N A N C I A L R E P O RT S Fall 2013

OUTLINE Logging In Initial Setup Main Page Monthly Department Reports Other Reports Questions

FIS BANNER – COGNOS BI-HOME

LOGGING IN

LOGGING IN Password process New staff member: Need FIS Banner access and Cognos report access. Current staff member: If you cannot gain access, you may require an “Increase” in Banner FIS access to include Cognos report access.

INITIAL SETUP

FIS REPORTS MAIN PAGE

MONTHLY DEPARTMENT REPORTS

SUMMARY REPORT REVENUE & EXPENSE SUMMARY & BY ORG CODE

DETAIL REPORT REVENUE & EXPENSE BY INDEX CODE

PAYROLL REPORT BY 12-MONTH WITH ENCUMBRANCE REMAINING

NON-PAYROLL REPORT

OTHER REPORTS

RECAP COGNOS REPORTS: BUDGETED OPERATIONS “Monthly” Financial Reports are now “Real Time” Department Reports Use Cognos dashboard and select: DATE: Select Date Parameters (default is set to “closed period”) FUND TYPE: Budgeted Operations ORGANIZATION: Select your Department Organization Level SUBMIT (retrieves data from Data Warehouse)

RECAP COGNOS: BUDGETED OPERATIONS REPORTS Recap of Budgeted Operations Reports Pre-defined Reports are built in Cognos as follows: 1. Budgeted Operations Revenue & Expense Summary [Summary tab] 2. Budgeted Operations Revenue & Expense by Organization [Summary tab by All-Sub Organizations] 3. Budgeted Operations Revenue & Expense by Index [Detail tab] [All Index Summary] and by [YTD by Index Detail] 4. Payroll Report by 12 months [Payroll tab] 5. Non-Payroll Transaction Report [NonPayroll tab] [By Month] and by [YTD] 6. Professional Development Spending [Other tab]

QUESTIONS?

CONTACTS Business Services New reports, issues, training Steve Larvick, Director Business Services Patti Eliot, Accounting Manager Institutional Research (IR) Shane Hunter, Research & Reporting Analyst Information Technology (IT) Programmer Analyst staff Training, Access and Reports Debbie Jones, Fiscal Coordinator Business Services