340 likes | 572 Views
WISDM. BATO Facts and Snacks October 21, 2010. Agenda. WISDM overview WISDM navigation. WISDM Overview . WISDM – Wisconsin Data Mart Information flows to WISDM from UWM’s General Ledger – SFS – Shared Financial System WISDM data is one day behind the SFS system. WISDM Overview.
E N D
WISDM BATO Facts and Snacks October 21, 2010
Agenda • WISDM overview • WISDM navigation
WISDM Overview • WISDM – Wisconsin Data Mart • Information flows to WISDM from UWM’s General Ledger – SFS – Shared Financial System • WISDM data is one day behind the SFS system
WISDM Overview • For access to WISDM, email Heather Lee or Jessica Russell, who will send a request to BFS • Logging in: https://authhub.wisconsin.edu/?app=WISDM
WISDM Navigation • Department Search • Viewing data • Fiscal Year, Accounting Period, MTD, YTD • Balance of a Department • Viewing detail • Sorting data • Edit Custom View • Drilldown levels • View As options (export to excel) • How to identify transactions • Setting Favorites • Project/Grant Search • My Profile – setting your login page • Questions
Department SearchCan search by Division if you are unsure of the exact department number
Fiscal Year, Acctg Period, MTD, YTD Fiscal year Change Accounting period here Current Month expenses Year to date expenses
What Is My Balance?Budget based funds: Fund 101, Fund 114 • Budget • -Expenses • Encumbrances • =Balance
What Is My Balance?Cash basis funds: Funds 128,136,150,189 Fiscal year balance: Revenues less Expenses Total balance
Viewing Detail Can click on any subtotal to see the detail that makes up the balance
Sorting Data Sorting data: click on any column heading to sort the data by that column
Edit Custom ViewYou can choose which columns of information you do and don’t want to see when viewing transactions. SELECT
Edit Custom View Select (or de-select) fields that do (or don’t) want to see
Drilldown Levels Drilldown Levels: allows you to see different levels of account detail
View As Options*Viewing the data in Excel will allow you to manipulate the data and save it in spreadsheets. This is a VERY helpful tool!
Common journal ID’s • Start with: • AP - Accounts Payable (check was issued) • DC – Direct Charge • FB – Fringe benefits • NSPT – NonSalary Payment Transfers • PJ – Payroll payments • PT – SCT’s • VISA – Pcard transactions
Setting FavoritesYou can create a favorites list of your most commonly used departments
Setting Favorites Name your favorite
Projects/GrantsCommon ways to search: by Project ID or by PI
Projects/Grants Click here for detailed info
Projects/Grants • Financial data for projects and grants is posted by the Project Dates (not by Fiscal Year, like it is in the departments • There will be a BATO Facts & Snacks session on Grants & WISPER on December 16, 2010
My ProfileYou can change your profile so that upon logging in, WISDM will default to YOUR “favorite” department or to your grant(s)
Additional WISDM Features • Salary and Encumbrance searches • Department Rollup features • PO searches • Transaction searches • Vouchers and WebNow • Contact Heather Lee at x2639 or hmlee@uwm.edu for any other questions or additional WISDM training