pre-game - session etiquette please turn off all cell phones. please keep side conversations to a...
TRANSCRIPT
Pre-Game - Session Etiquette
• Please turn off all cell phones.
• Please keep side conversations to a minimum.
• If you must leave during the presentation, please do so as quietly as possible.
1
Finance Reporting at Your Fingertips
Constance Mallette
Winston-Salem State University
Process Improvement Reporting and Analysis
Pre-Game - Introduction
• Purpose– Presentation of various reports developed by WSSU utilizing
Information Builders WebFOCUS reporting tool. – Review some of the techniques used to promote efficiency using
various reporting delivery methods and meet the informational needs of the various stakeholders.
• Advantages– Desktop delivery – Right to your E-mail, Portal or Webpage– Provides effective communication to groups/stakeholders– Promotes data transparency, integrity and accountability– Data driven decision making opportunities
Pre-Game - Agenda
• 1st Quarter - Tools / Resources• 2nd Quarter - Types of Reports• 3rd Quarter - Delivery Modes• 4th Quarter – How To
5
1st Quarter – TOOLS / RESOURCES
• Business Intelligence Reporting Tools• Information Builders WebFOCUS• KNOW THE DATA – KNOW THE TOOL - VALIDATE• Consult with appropriate stakeholders to understand
needs• Be Proactive / Be a GREAT Data Steward• Catalog Reports to avoid redundancy
6
2nd Quarter – Types of Reports/ Information
Letter Generation
Financial Data
Third Party
Export
Specific Board
Groups
Student Information
Alumni Contributors
7
2nd Quarter – Types of Reports/Information
Budget
Payroll
Vendor
Student Billing
Position Control
Purchase Order
General Ledger
Contract & Grants
Fund & Account Status
Letter
HTML
Charts
Report
Spreadsheet
TYPE SOURCE OUTPUT
8
3rd Quarter – Delivery Methods
PORTAL E-MAIL SELF EXECUTE
WEB DASHBOARD
IF YOU BUILD IT THEY WILL COME
(Only if they know how to get there!)
-KNOW YOUR CLIENT-REMAIN OPEN-FLEXIBLE
9
3rd Quarter – Delivery Method Location
• FIREWALL – INSIDE / OUTSIDE
Population GroupType of Data
Sensitive/ConfidentialSecurity
10
Delivery Method – Interactive Dashboard
» RAMS Reporting Dashboard
» Executive Dashboard
Prominent Location on Web
11
Interactive Dashboards – Rams Dashboard
HOT KEYS
USER GUIDE
12
Interactive Dashboards - Executive
Linked directly to the
Strategic Goals
2010 – 2015 University Strategic Plan
HOT KEYS
13
Interactive Dashboards – Executive - Drilldown
SPREADSHEET
PIE CHARTS
REPORTS
14
Delivery Method – E-MAIL
15
Delivery Method – E-MAILCurrent Date: 02/12/2013
Current Time: 10.00.01
Report Path: Finance\Standard Reports\Management Reports\Distribution Reports\Budget (FGIBAVL) Distribution
Report reflects prior day Banner data
Winston-Salem State UniversityBanner Finance
Month: FebruaryFiscal Year: 2013
Detail By Fund\Account
FundFund Title Acct
AccountTitle
Budgeted Authorized
Actual CurrentMonth
Actual Year-To-Date
Encumbrances/Reserves
AvailableBalance
% Of Budget Comment
Financial Manager: Constance G Mallette
Expenditures
117037 Financial Systems 912000SPA Employee Salaries Pool(L4) 223,195.00 .00 116,668.81 .00 106,526.19 52.27%
117037 Financial Systems 912700 SPA Longevity Pay(L4) .00 .00 2,319.80 .00 -2,319.80 .00%No Authorized Budget
117037 Financial Systems 918100 Social Security(L4) 25,287.00 .00 13,670.37 .00 11,616.63 54.06%
117037 Financial Systems 918200 State Retirement(L4) 48,088.00 .00 26,263.86 .00 21,824.14 54.62%
117037 Financial Systems 918300 Medical Insurance(L4) 19,903.00 .00 10,816.50 .00 9,086.50 54.35%
117037 Financial Systems 920000Supplies and Materials Pool(L4) 3,300.00 178.20 2,413.99 .00 886.01 73.15%
117037 Financial Systems 930000 Current Services Pool(L4) 6,000.00 .00 .00 .00 6,000.00 .00%
117037 Financial Systems 931000 Travel Pool(L4) 1,505.00 525.10 621.42 .00 883.58 41.29%
117037 Financial Systems 932000 Communications Pool(L4) 7,000.00 .00 3,645.61 .00 3,354.39 52.08%
117037 Financial Systems 934000 Printing Binding Pool(L4) 2,100.00 .00 .24 .00 2,099.76 .01%
117037 Financial Systems 950000 Capital Outlay Pool(L4) 195.00 .00 .00 .00 195.00 .00%
Total 117037 448,993.00 703.30 241,998.91 .00 206,994.09 53.90%
Total Expenditures 448,993.00 703.30 241,998.91 .00 206,994.09 53.90%
-E-MAIL sent to Financial Manager-FGIBAVL-Distributed once per week
16
Delivery Method – E-MAIL
17
Delivery Method - PORTAL
Drag-N-Drop
Allow for Sort Selection
Optional Filter Selection
Optional Desired Output Type
Assign Report Heading Description
18
4TH QUARTER – HOW TO
• Set-up E-mail (WebFOCUS Dynamic Distribution)
Create Report in Developer Studio
19
4TH QUARTER – HOW TO
Create an HTML for message.This will be displayed in body of email
Create Distribution Procedure on the server i. e. PCHOLD file.
20
Set-up an Executive Dashboard/Portal
– Begin with the End on Mind – WHO, WHAT, WHEN, WHERE, HOW– Establish the basis for your data (Strategic Plan/Enrollment
Data)– Create a team of Experts from each Functional area
• What is the most important information in your area?• Allow the Unit to “Tell their Story”
– Develop reports– Identify Placement Location/Delivery Method– Inform Stakeholders that reports exist
4TH QUARTER – HOW TO
POST GAME - QUESTION & ANSWERS
Thank You!
Constance Mallette – Director Process Improvement Reporting & Analysis
WSSU CIAA FOOTBALL Champion 2 YEARS IN A ROW